public ActionResult likePost(int postid, string action_, string controller_, int ownerid, int userid = 0) { var con = new SOCIALMEDIA_DBEntities(); var likedpost = con.LIKEDPOSTS.Where(l => l.USERID == ownerid && l.POSTID == postid); if (likedpost.Count() == 0) { var post = con.POSTS.Find(postid); post.LIKES++; LIKEDPOST liked = new LIKEDPOST(); var last = con.LIKEDPOSTS.OrderByDescending(l => l.ID); liked.ID = (last.Count() != 0)? con.LIKEDPOSTS.OrderByDescending(l => l.ID).First().ID + 1 : 1; liked.USERID = ownerid; liked.POSTID = postid; con.LIKEDPOSTS.Add(liked); } else { var post = con.POSTS.Find(postid); post.LIKES--; con.LIKEDPOSTS.Remove(likedpost.First()); } con.SaveChanges(); return(RedirectToAction(action_, controller_, new { userid = userid, ownerid = ownerid })); }
public ActionResult createPost(string postContent, int ownerid, string action_, string controller_, HttpPostedFileBase attach) { POST post = new POST(); post.CONTENT = postContent; post.POSTDATE = DateTime.Now; post.LIKES = 0; post.USERID = ownerid; //upload attachments if (attach != null) { var fileName = Path.GetFileName(attach.FileName); var path = Path.Combine(Server.MapPath("~/Data/Posts_Attachments/"), fileName); attach.SaveAs(path); post.MEDIA = "../Data/Posts_Attachments/" + fileName; } var con = new SOCIALMEDIA_DBEntities(); var posts = con.POSTS.OrderByDescending(p => p.POSTID); post.POSTID = (posts.Count() != 0)? posts.First().POSTID + 1:1; con.POSTS.Add(post); con.SaveChanges(); return(RedirectToAction(action_, controller_, new { userid = ownerid })); }
public ActionResult cancelFR(int userid, int ownerid, String action_, string controller_) { var con = new SOCIALMEDIA_DBEntities(); var friend = con.FOLLOWINGS.Where(f => f.USERID == userid && f.FOLLOWINGID == ownerid).First(); con.FOLLOWINGS.Remove(friend); con.SaveChanges(); return(RedirectToAction(action_, controller_, new { userid = userid })); }
public ActionResult editReply(int replyid, string action_, string controller_, string content, int userid) { var con = new SOCIALMEDIA_DBEntities(); var reply = con.REPLIES.Find(replyid); reply.CONTENT = content; con.SaveChanges(); return(RedirectToAction(action_, controller_, new { userid = userid })); }
public ActionResult editComment(int commentid, string action_, string controller_, string content, int userid) { var con = new SOCIALMEDIA_DBEntities(); var comment = con.COMMENTS.Find(commentid); comment.CONTENT = content; con.SaveChanges(); return(RedirectToAction(action_, controller_, new { userid = userid })); }
public ActionResult editPost(int postid, string action_, string controller_, string content, int userid) { var con = new SOCIALMEDIA_DBEntities(); var post = con.POSTS.Find(postid); post.CONTENT = content; con.SaveChanges(); return(RedirectToAction(action_, controller_, new { userid = userid })); }
public ActionResult delReply(int replyid, string action_, string controller_, int userid = 0) { var con = new SOCIALMEDIA_DBEntities(); var reply = con.REPLIES.Find(replyid); con.REPLIES.Remove(reply); con.SaveChanges(); return(RedirectToAction(action_, controller_, new { userid = userid })); }
public ActionResult delComment(int commentid, string action_, string controller_, int userid = 0) { var con = new SOCIALMEDIA_DBEntities(); var comment = con.COMMENTS.Find(commentid); var reps = con.REPLIES.Where(r => r.COMMENTID == commentid); con.REPLIES.RemoveRange(reps); con.COMMENTS.Remove(comment); con.SaveChanges(); return(RedirectToAction(action_, controller_, new { userid = userid })); }
public ActionResult unfriend(int userid, int ownerid, String action_, string controller_) { var con = new SOCIALMEDIA_DBEntities(); var follow = con.FOLLOWINGS.Where(f => f.USERID == userid && f.FOLLOWINGID == ownerid); if (follow.Count() == 0) { follow = con.FOLLOWINGS.Where(f => f.FOLLOWINGID == userid && f.USERID == ownerid); } con.FOLLOWINGS.Remove(follow.FirstOrDefault()); con.SaveChanges(); return(RedirectToAction(action_, controller_, new { userid = userid })); }
public ActionResult sendFR(int userid, int ownerid, String action_, string controller_) { var con = new SOCIALMEDIA_DBEntities(); FOLLOWING follow = new FOLLOWING(); //get last following id var arr = con.FOLLOWINGS.OrderByDescending(f => f.ID); int lastId = (arr.Count() != 0) ?arr.First().ID : 0; follow.ID = lastId + 1; follow.USERID = userid; follow.FOLLOWINGID = ownerid; follow.FR_CONFIRMED = false; //add user to the other user as temp friend con.FOLLOWINGS.Add(follow); con.SaveChanges(); return(RedirectToAction(action_, controller_, new { userid = userid })); }
public ActionResult delPost(int postid, string action_, string controller_, int userid = 0) { var con = new SOCIALMEDIA_DBEntities(); var post = con.POSTS.Find(postid); var comments = con.COMMENTS.Where(c => c.POSTID == postid); foreach (var c in comments)//remove replies for each comment { con.REPLIES.RemoveRange(con.REPLIES.Where(r => r.COMMENTID == c.COMMENTID)); } var liked = con.LIKEDPOSTS.Where(l => l.POSTID == postid); con.COMMENTS.RemoveRange(comments); con.LIKEDPOSTS.RemoveRange(liked); con.POSTS.Remove(post); con.SaveChanges(); return(RedirectToAction(action_, controller_, new { userid = userid })); }
public ActionResult createReply(int commentid, string replyContent, int ownerid, string action_, string controller_, int userid = 1) { REPLY reply = new REPLY(); reply.CONTENT = replyContent; reply.LIKES = 0; reply.USERID = ownerid; reply.COMMENTID = commentid; var con = new SOCIALMEDIA_DBEntities(); //get the last id and ++ the new id var reps = con.REPLIES.OrderByDescending(r => r.REPLYID); reply.REPLYID = (reps.Count() != 0)? reps.First().REPLYID + 1:1; con.REPLIES.Add(reply); con.SaveChanges(); return(RedirectToAction(action_, controller_, new { userid = userid })); }
public ActionResult createComment(int postid, string commentContent, int ownerid, string action_, string controller_, int userid = 1) { COMMENT comment = new COMMENT(); comment.CONTENT = commentContent; comment.LIKES = 0; comment.USERID = ownerid; comment.POSTID = postid; var con = new SOCIALMEDIA_DBEntities(); //get the last id and ++ the new id var comms = con.COMMENTS.OrderByDescending(c => c.COMMENTID); comment.COMMENTID = (comms.Count() != 0)? comms.First().COMMENTID + 1:1; con.COMMENTS.Add(comment); con.SaveChanges(); return(RedirectToAction(action_, controller_, new { userid = userid })); }
public ActionResult Register(USER user) { var m = new RegisterModel(); var con = new SOCIALMEDIA_DBEntities(); //check email , username var us = con.USERS.Where(u => u.EMAIL == user.EMAIL || u.USERNAME == user.USERNAME); if (us.Count() != 0) { m.status = "registered"; return(View(m)); } else { //get last id var ids = con.USERS.OrderByDescending(u => u.USERID); user.USERID = (ids.Count() != 0) ? ids.First().USERID + 1 : 1; con.USERS.Add(user); con.SaveChanges(); } return(RedirectToAction("Login", "Login")); }
public void upload(HttpPostedFileBase file, int ownerid, string dataPath, string type) { //upload Display Picture if (file != null) { var fileName = Path.GetFileName(file.FileName); var path = Path.Combine(Server.MapPath(dataPath), fileName); file.SaveAs(path); var con = new SOCIALMEDIA_DBEntities(); var owner = con.USERS.Find(ownerid); if (type == "dp") { owner.DISPLAYPICTURE = "../Data/Display_Pictures/" + fileName; } else if (type == "bg") { owner.BG = "../Data/BG/" + fileName; } con.SaveChanges(); } }