public void DeleteTweet(int tweetId)
{
using (TwitterCloneDBEntities db = new TwitterCloneDBEntities())
{
db.Tweets.Remove(db.Tweets.Find(tweetId));
db.SaveChanges();
}
}
public void UnFollowUser(string userid, string followingId)
{
using (TwitterCloneDBEntities db = new TwitterCloneDBEntities())
{
var result = db.Followings.Where(x => x.User_id.ToUpper() == userid.ToUpper() && x.Following_id.ToUpper() == followingId.ToUpper()).FirstOrDefault();
db.Followings.Remove(db.Followings.Find(result.Rowid));
db.SaveChanges();
}
}
public void FollowUser(string userid, string followingId)
{
using (TwitterCloneDBEntities db = new TwitterCloneDBEntities())
{
Following obj = new Following();
obj.User_id = userid;
obj.Following_id = followingId;
db.Followings.Add(obj);
db.SaveChanges();
}
}
public void UpdateProfile(Person item)
{
using (TwitterCloneDBEntities db = new TwitterCloneDBEntities())
{
Person personObj = db.Persons.Find(item.User_id);
personObj.FullName = item.FullName;
personObj.Email = item.Email;
personObj.Password = item.Password;
db.SaveChanges();
}
}
public bool CreateAccount(Person item)
{
try
{
using (TwitterCloneDBEntities db = new TwitterCloneDBEntities())
{
db.Persons.Add(item);
db.SaveChanges();
return(true);
}
}
catch (Exception ex)
{
return(false);
}
}
public void SaveTweets(Tweet item)
{
using (TwitterCloneDBEntities db = new TwitterCloneDBEntities())
{
if (item.tweet_id == 0)
{
db.Tweets.Add(item);
}
else
{
Tweet twetObj = db.Tweets.Find(item.tweet_id);
twetObj.message = item.message;
twetObj.created = item.created;
}
db.SaveChanges();
}
}