protected void Page_Load(object sender, EventArgs e) { using (var context = new rheaxuEntities()) { int smId = Convert.ToInt32(Request["smId"]); memberSheetMusic msmObj = context.memberSheetMusics.SingleOrDefault(mSM => mSM.Id == smId); List <memberSheetMusic> msmObjList = new List <memberSheetMusic>(); msmObjList.Add(msmObj); detailsmRepeater.DataSource = msmObjList; detailsmRepeater.DataBind(); var likes = (from s in context.userLikeSms where s.smId == smId select s).Count(); likeCountLabel.Text = "Likes: " + likes.ToString(); List <sheetMusicComment> pCmntObjList = (from s in context.sheetMusicComments where s.smId == smId orderby s.createTime descending select s).ToList(); CmntCountLabel.Text = pCmntObjList.Count() + " comments for this sheet music"; cmntRepeater.DataSource = pCmntObjList; cmntRepeater.DataBind(); var likeUsersList = (from s in context.userLikeSms where s.smId == smId select s).ToList(); likeUserRepeater.DataSource = likeUsersList; likeUserRepeater.DataBind(); } }
protected void likeBtn_Click(object sender, EventArgs e) { using (var context = new rheaxuEntities()) { string likeTxt = likeBtn.Text; int smId = Convert.ToInt32(Request["smId"]); if (likeTxt == "Like") { userLikeSm uli = new userLikeSm { smId = smId, username = User.Identity.Name }; context.userLikeSms.Add(uli); memberSheetMusic msmObj = (from p in context.memberSheetMusics where p.Id == smId select p).FirstOrDefault(); msmObj.likes += 1; context.SaveChanges(); likeBtn.CssClass = "orange btn-sm"; likeBtn.Text = "Unlike"; } else { string visitorname = User.Identity.Name; //userLikeImg uli = context.userLikeImgs.SingleOrDefault(visitor => visitor.username == visitorname); var uli = (from s in context.userLikeSms where s.username == visitorname && s.smId == smId select s).FirstOrDefault(); context.userLikeSms.Remove(uli); memberSheetMusic msmObj = (from p in context.memberSheetMusics where p.Id == smId select p).FirstOrDefault(); msmObj.likes -= 1; context.SaveChanges(); likeBtn.CssClass = "blue btn-sm"; likeBtn.Text = "Like"; } var likes = (from s in context.userLikeSms where s.smId == smId select s).Count(); likeCountLabel.Text = "Likes: " + likes.ToString(); } }
protected void addToGallery_Click(object sender, EventArgs e) { using (var context = new rheaxuEntities()) { int smId = Convert.ToInt32(Request["smId"]); memberSheetMusic msmObj = (from s in context.memberSheetMusics where s.Id == smId select s).FirstOrDefault(); string custom_url = msmObj.smurl; Response.Redirect("postSheetMusic.aspx?custom_url=" + custom_url); } }
protected void PostBtn_Click(object sender, EventArgs e) { using (var context = new rheaxuEntities()) { memberSheetMusic msm = new memberSheetMusic { smurl = UrlTxt.Text, smTitle = TitleTxt.Text, smDesc = DescriptionArea.Text, ownername = User.Identity.Name, createTime = System.DateTime.Now, likes = 0 }; context.memberSheetMusics.Add(msm); context.SaveChanges(); int nPId = msm.Id; UploadStatusLabel.Text = "Successfully added photot '" + msm.smTitle + "' to your collection"; Response.Redirect("sheetMusicDetail.aspx?ownername=" + User.Identity.Name + "&smId=" + nPId); } //PhotoDAO dao = new PhotoDAO(); //Photo photo = new Photo(UrlTxt.Text, User.Identity.Name, TitleTxt.Text, DescriptionArea.Text,0); //string uid = Page.User.Identity.Name; //int nPId = dao.insertPhotoInfo(photo); //UploadStatusLabel.Text = "Successfully added sheet music '" + photo.imgTitle+"' to your collectionn"; //Response.Redirect("sheetMusicDetail.aspx?ownername=" + User.Identity.Name+"smId="+nPId); }