public static async Task <int> createNewUser(person objPerson)
{
FSEEntities dbcontest = new FSEEntities();
dbcontest.people.Add(objPerson);
return(await dbcontest.SaveChangesAsync());
}
public static person getPersonDetails(string username)
{
using (var db = new FSEEntities())
{
var result = db.people.Where(x => x.user_id == username).FirstOrDefault();
return(result);
}
}
public static List <person> validateUser(string username, string password)
{
FSEEntities dbcontest = new FSEEntities();
var result = dbcontest.people.Where(x => x.user_id == username && x.password == password);
return(result.ToList());
}
public static bool saveUserTweet(tweet twmodel)
{
bool result = false;
using (var db = new FSEEntities())
{
db.tweets.Add(twmodel);
db.SaveChanges();
result = true;
}
return(result);
}
public static bool isUserAvailable(string username)
{
bool result = false;
using (var db = new FSEEntities())
{
var isUser = db.people.Where(x => x.user_id == username).Any();
if (isUser)
{
result = true;
}
}
return(result);
}
public static TweetModel getUserTweets(string username)
{
TweetModel tm = new TweetModel();
using (var db = new FSEEntities())
{
var followingUsers = db.followings.Where(x => x.user_id == username).Select(x => x.following_id);
var userTweets = db.tweets.Where(x => x.user_id == username).ToList();
var followerTweets = db.tweets.Where(x => followingUsers.Contains(x.user_id)).ToList();
var allTweets = userTweets.Union(followerTweets).OrderByDescending(x => x.craeted).ToList();
tm.no_of_followers = followingUsers.Count();
tm.no_of_followings = db.followings.Where(x => x.following_id == username).Count();
tm.no_of_tweets = userTweets.Count();
tm.tweets = allTweets;
}
return(tm);
}
public static bool followUser(string loginUserid, string followUserid)
{
bool result = false;
using (var db = new FSEEntities())
{
following following = new following();
following.user_id = loginUserid;
following.following_id = followUserid;
var userTest = db.followings.Where(x => x.user_id == loginUserid && x.following_id == followUserid).Any();
if (!userTest)
{
db.followings.Add(following);
db.SaveChanges();
result = true;
}
}
return(result);
}