public static TweetDto.DtoTweet AddTweet(TweetDto.DtoTweet tweetObject) { TweetDto.DtoTweet newTweet = null; try { using (GlitterDBEntities1 context = new GlitterDBEntities1()) { Tweet tweet = new Tweet { TweetContent = tweetObject.TweetContent, UserDetailId = tweetObject.UserDetailId, Date = tweetObject.Date }; context.Tweets.Add(tweet); if (context.SaveChanges() > 0) { newTweet = tweetObject; } } } catch (Exception e) { Console.Write(e); } return(newTweet); }
public static DtoUserFollower AddFollower(DtoUserFollower userTrack) { DtoUserFollower newFollowee = new DtoUserFollower(); try { using (GlitterDBEntities1 context = new GlitterDBEntities1()) { UserFollower followee = new UserFollower { FollowerId = userTrack.FollowerId, UserDetailId = userTrack.UserDetailId }; context.UserFollowers.Add(followee); context.SaveChanges(); { newFollowee.UserDetailId = followee.UserDetailId; newFollowee.FollowerId = followee.FollowerId; } } } catch (Exception e) { throw e; } return(newFollowee); }
public static bool AddToHashTagList(IList <DtoHashTag> listOFHashTags) { try { using (GlitterDBEntities1 context = new GlitterDBEntities1()) { foreach (DtoHashTag hashtag in listOFHashTags) { HashTag newHashtag = context.HashTags.FirstOrDefault(a => a.HashTagName == hashtag.HashTagName); context.HashTags.Add(new HashTag { HashTagName = newHashtag.HashTagName, TweetId = newHashtag.TweetId }); } context.SaveChanges(); } return(true); } catch (Exception) { return(false); } }
public static Register AddUser(Register register) { try { using (GlitterDBEntities1 context = new GlitterDBEntities1()) { UserDetail user = new UserDetail { Email = register.Email, Password = register.Password, FirstName = register.FirstName, LastName = register.LastName, Image = Enumerable.Repeat((byte)0x20, 10).ToArray(), MobileNumber = register.MobileNumber, Country = register.Country }; context.UserDetails.Add(user); context.SaveChanges(); } } catch (Exception e) { Console.Write(e); throw (e); } return(register); }
public static bool DeleteTweet(TweetDto.DtoTweet tweettoDelete) { try { using (GlitterDBEntities1 context = new GlitterDBEntities1()) { var tweet = context.Tweets.Find(tweettoDelete.TweetId); context.Tweets.Remove(tweet); context.SaveChanges(); } return(true); } catch (Exception) { return(false); } }
public static TweetDto.DtoTweet EditTweet(TweetDto.DtoTweet editedTweet) { TweetDto.DtoTweet newtweet = null; try { using (GlitterDBEntities1 context = new GlitterDBEntities1()) { var tweet = context.Tweets.Find(editedTweet.TweetId); tweet.TweetContent = editedTweet.TweetContent; tweet.Date = editedTweet.Date; context.SaveChanges(); } } catch (Exception) { } return(newtweet); }
public static bool ReamoveReaction(UserReactionDto.DtoUserReaction reactionObject) { try { using (GlitterDBEntities1 context = new GlitterDBEntities1()) { //var react = context.Reacts.Find(reactObject.Id); var react = context.UserReactions.FirstOrDefault(l => l.UserReactionId == reactionObject.UserReactionId && l.UserDetailId == reactionObject.UserDetailId); context.UserReactions.Remove(react); context.SaveChanges(); } return(true); } catch (Exception) { return(false); } }
public static bool AddToDislikes(UserReactionDto.DtoUserReaction reactionObject) { try { using (GlitterDBEntities1 context = new GlitterDBEntities1()) { context.UserReactions.Add(new UserReaction { UserReactionId = reactionObject.UserReactionId, UserDetailId = reactionObject.UserDetailId, IsLiked = 1 }); context.SaveChanges(); } return(true); } catch (Exception) { return(false); } }
public static bool UnFollow(DtoUserFollower followee) { try { using (GlitterDBEntities1 context = new GlitterDBEntities1()) { var following = (from followings in context.UserFollowers where followings.FollowerId == followee.FollowerId && followings.UserDetailId == followee.UserDetailId select followings).FirstOrDefault(); if (following == null) { return(false); } context.UserFollowers.Remove(following); context.SaveChanges(); } return(true); } catch (Exception) { return(false); } }
public static bool DeleteFromHashTagList(IList <DtoHashTag> listOFHashTags) { try { using (GlitterDBEntities1 context = new GlitterDBEntities1()) { foreach (DtoHashTag hashtag in listOFHashTags) { HashTag newHashtag = context.HashTags.FirstOrDefault(a => a.HashTagName == hashtag.HashTagName && a.TweetId == hashtag.TweetId); //if a hashtag already exists if (newHashtag != null) { context.HashTags.Remove(newHashtag); } context.SaveChanges(); } return(true); } } catch (Exception) { return(false); } }