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 followBtn_Click(object sender, EventArgs e)
{
using (var context = new rheaxuEntities())
{
string followTxt = followBtn.Text;
string ownername = Request["ownername"];
if (followTxt == "Follow")
{
follow f = new follow {
username = ownername, follower = User.Identity.Name
};
context.follows.Add(f);
context.SaveChanges();
followBtn.CssClass = "orange btn-sm";
followBtn.Text = "Unfollow";
}
else
{
var f = (from s in context.follows where s.username == ownername && s.follower == User.Identity.Name select s).FirstOrDefault();
context.follows.Remove(f);
context.SaveChanges();
followBtn.CssClass = "blue btn-sm";
followBtn.Text = "Follow";
}
var follows = (from s in context.follows where s.username == ownername select s).Count();
followerCountLabel.Text = follows.ToString() + " followers";
}
}
protected void PostBtn_Click(object sender, EventArgs e)
{
using (var context = new rheaxuEntities())
{
memberPhoto mp = new memberPhoto {
imgurl = UrlTxt.Text, imgTitle = TitleTxt.Text, imgDesc = DescriptionArea.Text, ownername = User.Identity.Name, createTime = System.DateTime.Now, likes = 0
};
context.memberPhotos.Add(mp);
context.SaveChanges();
int nPId = mp.Id;
UploadStatusLabel.Text = "Successfully added photot '" + mp.imgTitle + "' to your collection";
Response.Redirect("photoDetail.aspx?ownername=" + User.Identity.Name + "&imgId=" + nPId);
}
}
protected void AddCmntBtn_Click(object sender, EventArgs e)
{
using (var context = new rheaxuEntities())
{
string cmntUsername = User.Identity.Name;
DateTime cmntCreateTime = DateTime.Now;
int cmntPId = Convert.ToInt32(Request["smId"]);
string cmnt = CmntTextArea.Text;
sheetMusicComment pcmnt = new sheetMusicComment {
smId = cmntPId, username = cmntUsername, createTime = cmntCreateTime, comment = cmnt
};
context.sheetMusicComments.Add(pcmnt);
context.SaveChanges();
}
Response.Redirect(Request.RawUrl);
}
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);
}
