public Person GetUserDetails(string userid)
{
using (TwitterCloneDBEntities db = new TwitterCloneDBEntities())
{
return(db.Persons.Find(userid));
}
}
public List <Person> GetSearchList(string name)
{
using (TwitterCloneDBEntities db = new TwitterCloneDBEntities())
{
return(db.Persons.Where(x => x.User_id.StartsWith(name)).ToList());
}
}
public void DeleteAccount(string userid)
{
using (TwitterCloneDBEntities db = new TwitterCloneDBEntities())
{
db.uspDeleteAccount(userid);
}
}
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 IEnumerable <Tweet> GetAllTweetList(string id)
{
List <Tweet> tweetList = new List <Tweet>();
TwitterCloneDBEntities db = new TwitterCloneDBEntities();
var followingList = db.Followings.Where(x => x.User_id.ToUpper() == id.ToUpper())
.Select(x => x.Following_id).ToList();
return(db.Tweets.Where(tweet => followingList.Contains(tweet.user_id) || tweet.user_id == id)
.OrderByDescending(o => o.created));
}
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();
}
}
public int ValidatedUser(string userId, string password)
{
using (TwitterCloneDBEntities db = new TwitterCloneDBEntities())
{
var result = db.Persons.Find(userId);
if (result != null)
{
if (result.Active)
{
return((result.User_id.ToUpper() == userId.ToUpper() && result.Password == password) ? 1 : 2);
}
else
{
return(3);
}
}
else
{
return(0);
}
}
}
public IEnumerable <Tweet> GetTotalTweetByUser(string id)
{
TwitterCloneDBEntities db = new TwitterCloneDBEntities();
return(db.Tweets.Where(x => x.user_id.ToUpper() == id.ToUpper()).OrderByDescending(o => o.created));
}
public List <Following> GetAllFollowers(string userid)
{
TwitterCloneDBEntities db = new TwitterCloneDBEntities();
return(db.Followings.Where(x => x.Following_id.ToUpper() == userid.ToUpper()).ToList());
}
