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);
}
