public bool SaveTweet(TweetMessage tweetMsg) { bool IsSuccess = false; try { using (_dbContext = new TwitterCloneEntities()) { var tweets = _dbContext.People.Where(x => x.User_Id.Trim().ToUpper() == tweetMsg.User_Id.Trim().ToUpper()).FirstOrDefault(); var tweet = _dbContext.Tweets.Where(x => x.Tweet_Id == tweetMsg.Tweet_Id).FirstOrDefault(); if (tweet == null && tweetMsg.Tweet_Id == 0) { tweet = new Tweet(); tweet.User_Id = tweetMsg.User_Id; tweet.Message = tweetMsg.Message; tweet.Created = DateTime.Now; _dbContext.Entry(tweet).State = System.Data.Entity.EntityState.Added; } else { tweet.Message = tweetMsg.Message; } IsSuccess = true; _dbContext.SaveChanges(); } } catch (Exception ex) { } return(IsSuccess); }
public void DeleteTweet(int tweetId) { using (TwitterCloneEntities db = new TwitterCloneEntities()) { Tweet twt; twt = GetTweetById(tweetId); db.Entry(twt).State = EntityState.Deleted; db.SaveChanges(); } }
public void UpdateUser(Person person) { using (TwitterCloneEntities db = new TwitterCloneEntities()) { if (!string.IsNullOrWhiteSpace(person.UserId)) { Person p; p = SearchUser(person.UserId); p.Active = person.Active; p.Email = person.Email; p.FullName = person.FullName; p.Password = person.Password; db.People.Attach(p); db.Entry(p).State = EntityState.Modified; } db.SaveChanges(); } }
public bool RegisterOrUpdateUser(PersonModel personModel) { bool isRegistered = false; try { using (_dbContext = new TwitterCloneEntities()) { Person person = _dbContext.People.Where(x => x.User_Id.ToUpper().Trim() == personModel.User_Id.ToUpper().Trim()).FirstOrDefault(); if (person == null) { Person user = new Person(); user.User_Id = personModel.User_Id; user.Passowrd = personModel.Password; user.FullName = personModel.FullName; user.Email = personModel.Email; user.Joined = DateTime.Now; user.Active = true; _dbContext.People.Add(user); } else { if (string.IsNullOrEmpty(personModel.Password.Trim())) { person.Passowrd = personModel.Password; } person.FullName = personModel.FullName; person.Email = personModel.Email; _dbContext.Entry <Person>(person).State = System.Data.Entity.EntityState.Modified; } _dbContext.SaveChanges(); isRegistered = true; } } catch (Exception ex) { isRegistered = false; } return(isRegistered); }
public void SaveTweet(Tweet tweet) { using (TwitterCloneEntities db = new TwitterCloneEntities()) { if (tweet.TweetId == 0) { db.Tweets.Add(tweet); } else { Tweet twt; twt = GetTweetById(tweet.TweetId); twt.Message = tweet.Message; db.Tweets.Attach(twt); db.Entry(twt).State = EntityState.Modified; } db.SaveChanges(); } }
public TweetMessage EditTweet(int tweetId) { TweetMessage _editTweet = new TweetMessage(); try { using (_dbContext = new TwitterCloneEntities()) { var tweet = _dbContext.Tweets.Where(x => x.Tweet_Id == tweetId).FirstOrDefault();//_context.TWEETs.Where(x => x.tweet_id == tweetMsg.TweetId).FirstOrDefault(); _editTweet.User_Id = tweet.User_Id; _editTweet.Message = tweet.Message; _editTweet.Tweet_Id = tweet.Tweet_Id; _editTweet.Created = DateTime.Now; _dbContext.Entry(_editTweet).State = System.Data.Entity.EntityState.Modified; _dbContext.SaveChanges(); } } catch (Exception ex) { } return(_editTweet); }