public static bool SaveTweet(TweetMessageViewModel tweetMsg)
{
bool IsSuccess = false;
try
{
using (var _context = new TwitterCloneDBEntities())
{
var tweets = _context.People.Where(x => x.user_id.Trim().ToUpper() == tweetMsg.userid.Trim().ToUpper()).FirstOrDefault();
var tweet = tweets.TWEETs.Where(x => x.tweet_id == tweetMsg.TweetId).FirstOrDefault();//_context.TWEETs.Where(x => x.tweet_id == tweetMsg.TweetId).FirstOrDefault();
if (tweet == null && tweetMsg.TweetId == 0)
{
tweet = new TWEET();
tweet.user_id = tweetMsg.userid;
tweet.message = tweetMsg.TweetMessage;
tweet.created = DateTime.Now;
_context.Entry(tweet).State = EntityState.Added;
}
else
{
tweet.message = tweetMsg.TweetMessage;
}
IsSuccess = true;
_context.SaveChanges();
}
}
catch (Exception ex)
{
}
return(IsSuccess);
}
public static bool RegisterUser(SignUpViewModel userInfo)
{
bool isRegistered = false;
try
{
using (var _context = new TwitterCloneDBEntities())
{
var items = _context.People.Where(x => x.user_id.ToUpper().Trim() == userInfo.UserName.ToUpper().Trim()).FirstOrDefault();
if (items == null)
{
Person user = new Person();
user.user_id = userInfo.UserName;
user.password = userInfo.Password;
user.fullName = userInfo.FullName;
user.email = userInfo.Email;
user.joined = DateTime.Now;
user.active = true;
_context.People.Add(user);
}
else
{
items.password = userInfo.Password;
items.fullName = userInfo.FullName;
}
_context.SaveChanges();
isRegistered = true;
}
}
catch (Exception ex)
{
isRegistered = false;
}
return(isRegistered);
}
public static string DeleteTweet(int tweetId)
{
string strUserName = string.Empty;
try
{
using (var _context = new TwitterCloneDBEntities())
{
var tweet = _context.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;
_context.TWEETs.Remove(tweet);
//_context.Entry(tweet).State = EntityState.Deleted;
}
_context.SaveChanges();
}
}
catch (Exception ex)
{
}
return(strUserName);
}
