public List <vwUser> UsersWhoLikedPost(vwPost post) { try { using (BetweenUsEntities context = new BetweenUsEntities()) { List <int> usersId = context.tblLikedPosts.Where(x => x.PostId == post.PostId).Select(x => x.UserId).ToList(); List <vwUser> users = new List <vwUser>(); foreach (var item in usersId) { vwUser user = context.vwUsers.Where(x => x.UserId == item).FirstOrDefault(); if (user != null) { users.Add(user); } } return(users); } } catch (Exception ex) { Debug.WriteLine("Exception" + ex.Message.ToString()); return(null); } }
/// <summary> /// This method adds post to DbSet and saves changes to database. /// </summary> /// <param name="postToAdd">Post to be added.</param> /// <returns>True if post is added, false if not.</returns> public bool CreatePost(vwPost postToAdd) { try { using (BetweenUsEntities context = new BetweenUsEntities()) { tblPost newPost = new tblPost { DateOfPost = DateTime.Now.Date, PostContent = postToAdd.PostContent, UserId = postToAdd.UserId, NumberOfLikes = 0 }; context.tblPosts.Add(newPost); context.SaveChanges(); return(true); } } catch (Exception ex) { Debug.WriteLine("Exception" + ex.Message.ToString()); return(false); } }