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 AddUser(Person item) { using (TwitterCloneEntities db = new TwitterCloneEntities()) { db.People.Add(item); db.SaveChanges(); } }
public JsonResult PostTweet(string tweet) { try { _twitterCloneEntity.Tweets.Add(new Tweet() { created = DateTime.Now, message = tweet, user_id = User.Identity.Name }); _twitterCloneEntity.SaveChanges(); return(Json("success", JsonRequestBehavior.AllowGet)); } catch (Exception ex) { return(Json(ex, JsonRequestBehavior.AllowGet)); } }
public void DeleteTweet(int tweetId) { using (TwitterCloneEntities db = new TwitterCloneEntities()) { Tweet twt; twt = GetTweetById(tweetId); db.Entry(twt).State = EntityState.Deleted; db.SaveChanges(); } }
public ActionResult AddTweet(string tweetText) { using (TwitterCloneEntities db = new TwitterCloneEntities()) { var tweet = new Tweet(); tweet.TweetText = tweetText; tweet.TweetTime = DateTime.Now; tweet.UserId = (int)Session["Id"]; db.Tweets.Add(tweet); db.SaveChanges(); } return(RedirectToAction("Index", "Dashboard")); }
public void SaveTweet(Tweet tweet) { using (TwitterCloneEntities db = new TwitterCloneEntities()) { if (tweet.TweetId == 0) { db.Tweets.Add(tweet); } else { Tweet t; t = GetTweetById(tweet.TweetId); } 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 string DeleteTweet(int tweetId) { string strUserName = string.Empty; 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(); if (tweet != null && tweetId != 0) { strUserName = tweet.User_Id; _dbContext.Tweets.Remove(tweet); } _dbContext.SaveChanges(); } } catch (Exception ex) { } return(strUserName); }
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); }