How did the White Album 1 manga end?

I just finished the manga and the anime, but I didn't understand the ending of the manga. Does he end up with Yuki or not? And do you recommend playing the visual novel?