public void deleteRelationshipByID(string idRela) { var deleteRela = dbContext.Relationships.SingleOrDefault(x => x.id == idRela); dbContext.Relationships.Remove(deleteRela); dbContext.SaveChanges(); }
public bool toggleLikeAPost(string userId, string postId) { try { bool isLiked = isLikeByUser(userId, postId); if (isLiked) { dbContext.Favorites.RemoveRange(dbContext.Favorites.Where(x => x.uId == userId && x.pId == postId)); } else { Favorite newLike = new Favorite() { id = DateTimeUtils.getKeyTimeStamp(), uId = userId, pId = postId }; dbContext.Favorites.Add(newLike); } dbContext.SaveChanges(); return(!isLiked); }catch (Exception e) { return(false); } }
// return user id public string insert(User user) { dbContext.Users.Add(user); dbContext.SaveChanges(); return(user.id); }
public bool insertComment(Comment comment) { try { dbContext.Comments.Add(comment); dbContext.SaveChanges(); return(true); }catch (Exception e) { Console.WriteLine(e.Message); return(false); } }
public bool insert(Post post) { try { dbContext.Posts.Add(post); dbContext.SaveChanges(); return(true); }catch (Exception e) { Console.WriteLine(e.Message); return(false); } }