protected void Page_Load(object sender, EventArgs e)
{
using (var context = new rheaxuEntities())
{
string ownername = Request["ownername"];
if (ownername == "" || ownername == null)
{
ownername = User.Identity.Name;
}
profileOwnername.Text = ownername + "'s Profile";
var followers = (from s in context.follows where s.username == ownername select s).ToList();
int followerCount = followers.Count();
var followings = (from s in context.follows where s.follower == ownername select s).ToList();
int followingCount = followings.Count();
followerCountLabel.Text = followerCount.ToString() + " followers";
followingCountlabel.Text = followingCount.ToString() + " followings";
followerRepeater.DataSource = followers;
followerRepeater.DataBind();
followingRepeater.DataSource = followings;
followingRepeater.DataBind();
List <AuthUser> ownerList = new List <AuthUser>();
var owner = (from s in context.AuthUsers where s.username == ownername select s).FirstOrDefault();
ownerList.Add(owner);
ownerView.DataSource = ownerList;
ownerView.DataBind();
var likedSmObjList = (from s in context.userLikeSms join p in context.memberSheetMusics on s.smId equals p.Id where s.username == ownername select new { likeUsername = s.username, likedSMId = s.smId, likedSMTitle = p.smTitle }).ToList();
var likedPObjList = (from s in context.userLikeImgs join p in context.memberPhotos on s.photoId equals p.Id where s.username == ownername select new { likeUsername = s.username, likedImgId = s.photoId, likedImgTitle = p.imgTitle }).ToList();
favSMRepeater.DataSource = likedSmObjList;
favPRepeater.DataSource = likedPObjList;
favPRepeater.DataBind();
favSMRepeater.DataBind();
}
}
protected void Page_Load(object sender, EventArgs e)
{
using (var context = new rheaxuEntities())
{
int imgId = Convert.ToInt32(Request["imgId"]);
memberPhoto mPhotoObj = context.memberPhotos.SingleOrDefault(mPhoto => mPhoto.Id == imgId);
List <memberPhoto> mPhotoObjList = new List <memberPhoto>();
mPhotoObjList.Add(mPhotoObj);
detailimgRepeater.DataSource = mPhotoObjList;
detailimgRepeater.DataBind();
var likes = (from s in context.userLikeImgs where s.photoId == imgId select s).Count();
likeCountLabel.Text = "Likes: " + likes.ToString();
List <photoComment> pCmntObjList = (from s in context.photoComments where s.pId == imgId orderby s.createTime descending select s).ToList();
CmntCountLabel.Text = pCmntObjList.Count() + " comments for this photo";
cmntRepeater.DataSource = pCmntObjList;
cmntRepeater.DataBind();
var likeUsersList = (from s in context.userLikeImgs where s.photoId == imgId 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 imgId = Convert.ToInt32(Request["imgId"]);
if (likeTxt == "Like")
{
userLikeImg uli = new userLikeImg {
photoId = imgId, username = User.Identity.Name
};
context.userLikeImgs.Add(uli);
memberPhoto mpObj = (from p in context.memberPhotos where p.Id == imgId select p).FirstOrDefault();
mpObj.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.userLikeImgs where s.username == visitorname && s.photoId == imgId select s).FirstOrDefault();
context.userLikeImgs.Remove(uli);
memberPhoto mpObj = (from p in context.memberPhotos where p.Id == imgId select p).FirstOrDefault();
mpObj.likes -= 1;
context.SaveChanges();
likeBtn.CssClass = "blue btn-sm";
likeBtn.Text = "Like";
}
var likes = (from s in context.userLikeImgs where s.photoId == imgId 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 addToGallery_Click(object sender, EventArgs e)
{
using (var context = new rheaxuEntities())
{
int imgId = Convert.ToInt32(Request["imgId"]);
memberPhoto pObj = (from s in context.memberPhotos where s.Id == imgId select s).FirstOrDefault();
string imgUrl = pObj.imgurl;
Response.Redirect("postPhoto.aspx?toAddImgUrl=" + imgUrl);
}
}
protected void Page_Load(object sender, EventArgs e)
{
using (var context = new rheaxuEntities())
{
string Ownername = Request["ownername"].ToString();
AuthUser authUserObj = context.AuthUsers.SingleOrDefault(authUser => authUser.username == Ownername);
carouselRx.DataSource = authUserObj.memberPhotos.ToList();
carouselRx.DataBind();
}
}
protected void Page_Load(object sender, EventArgs e)
{
using (var context = new rheaxuEntities())
{
memberRepeater.DataSource = context.AuthUsers.ToList();
memberRepeater.DataBind();
var mpObjList = context.memberPhotos.OrderByDescending(p => p.likes).ToList();
popular_repeater.DataSource = mpObjList;
popular_repeater.DataBind();
}
}
protected void Page_Load(object sender, EventArgs e)
{
using (var context = new rheaxuEntities())
{
string owner = Request["ownername"];
if (owner == "" || owner == null)
{
owner = User.Identity.Name;
}
var msmObjList = (from s in context.memberSheetMusics where s.ownername == owner orderby s.likes descending select s).ToList();
//var msmObjList = context.memberSheetMusics.OrderByDescending(p => p.likes).ToList();
mySheetMusicRepeater.DataSource = msmObjList;
mySheetMusicRepeater.DataBind();
}
}
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 likeBtn_Load(object sender, EventArgs e)
{
using (var context = new rheaxuEntities())
{
string visitorname = User.Identity.Name;
int smId = Convert.ToInt32(Request["smId"]);
var uli = (from s in context.userLikeSms where s.username == visitorname && s.smId == smId select s).FirstOrDefault();
likeBtn.Visible = true;
if (uli == null)
{
likeBtn.CssClass = "blue btn-sm";
likeBtn.Text = "Like";
}
else
{
likeBtn.CssClass = "orange btn-sm";
likeBtn.Text = "Unlike";
}
}
}
protected void followBtn_Load(object sender, EventArgs e)
{
using (var context = new rheaxuEntities())
{
string visitorname = User.Identity.Name;
string ownername = Request["ownername"];
var f = (from s in context.follows where s.username == ownername && s.follower == visitorname select s).FirstOrDefault();
followBtn.Visible = true;
if (f == null)
{
followBtn.CssClass = "blue btn-sm";
followBtn.Text = "Follow";
}
else
{
followBtn.CssClass = "orange btn-sm";
followBtn.Text = "Unfollow";
}
}
}
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);
}
