public Collection <Tweet> GetFollowingTweets(string userId)
{
Collection <Tweet> tweets = new Collection <Tweet>();
using (var db = new MVCApplicationEntities())
{
db.Tweets.Join(db.Followings, r => r.User_Id, p => p.User_Id, (r, p) =>
new
{
r.Tweet_Id,
p.Following_Id,
r.Message,
r.Created
}).ToList()
.ForEach(y =>
tweets.Add(new Tweet()
{
Tweet_Id = y.Tweet_Id,
User_Id = y.Following_Id,
Message = y.Message,
Created = y.Created
}));
}
return(tweets);
}
public string Save(Person person)
{
using (var db = new MVCApplicationEntities())
{
var upPerson = db.People.Where(a => a.User_Id.ToLower().Equals(person.User_Id.ToLower()) || a.Email.ToLower().Equals(person.Email.ToLower())).FirstOrDefault();
var rePerson = db.People.Where(a => a.User_Id.ToLower().Equals(person.User_Id.ToLower()) && a.Active == false && a.Email.ToLower().Equals(person.Email.ToLower())).FirstOrDefault();
if (upPerson == null)
{
db.People.Add(person);
db.SaveChanges();
}
else if (upPerson != null && rePerson != null)
{
rePerson.Password = person.Password;
rePerson.FullName = person.FullName;
rePerson.Email = person.Email;
rePerson.Active = true;
db.SaveChanges();
}
else
{
return("UserName or EmailId already registered with us");
}
return("success");
}
}
public List <Tweet> GetTweetsByUserId(int userId)
{
using (var db = new MVCApplicationEntities())
{
return(db.Tweets.Where(item => item.User_Id == userId.ToString()).ToList());
}
}
public void SaveTweet(Tweet tweet)
{
using (var db = new MVCApplicationEntities())
{
db.Tweets.Add(tweet);
db.SaveChanges();
}
}
public Person Login(string userName, string password)
{
using (var db = new MVCApplicationEntities())
{
var person = db.People.Where(a => a.User_Id.ToLower().Equals(userName.ToLower()) && a.Password.Equals(password) && a.Active == true).FirstOrDefault();
return(person);
}
}
public List <string> SearchUsersByName(string name)
{
using (var db = new MVCApplicationEntities())
{
List <string> names = db.People.Where(item => item.FullName.StartsWith(name) || item.FullName.Contains(name)).Select(item => item.FullName).ToList();
return(names);
}
}
public void DeleteTweet(int tweetId)
{
using (var db = new MVCApplicationEntities())
{
var deleteTweet = db.Tweets.FirstOrDefault(item => item.Tweet_Id == tweetId);
db.Tweets.Remove(deleteTweet);
db.SaveChanges();
}
}
public void Update(Tweet tweet)
{
using (var db = new MVCApplicationEntities())
{
var updateTweet = db.Tweets.FirstOrDefault(item => item.Tweet_Id == tweet.Tweet_Id);
updateTweet.Message = tweet.Message;
db.SaveChanges();
}
}
public void FollowUser(string userId, string follwerId)
{
using (var db = new MVCApplicationEntities())
{
db.Followings.Add(new Following {
User_Id = userId, Following_Id = follwerId
});
db.SaveChanges();
}
}
public List <Tweet> GetFollwersTweets(string userId)
{
using (var db = new MVCApplicationEntities())
{
var tweets = (from peopl in db.People
join following in db.Followings
on peopl.User_Id equals following.User_Id
join tweet in db.Tweets
on following.Following_Id equals tweet.User_Id
select tweet).ToList();
return(tweets);
}
}
public Collection <Following> GetFollowers(string userId)
{
Collection <Following> followers = new Collection <Following>();
using (var db = new MVCApplicationEntities())
{
db.Followings.Where(x => x.Following_Id == userId)
.ToList()
.ForEach(y =>
followers.Add(new Following()
{
User_Id = y.User_Id,
Following_Id = y.Following_Id
}));
}
return(followers);
}
public Collection <Tweet> GetTweets(string userId)
{
Collection <Tweet> tweets = new Collection <Tweet>();
using (var db = new MVCApplicationEntities())
{
db.Tweets.Where(x => x.User_Id == userId).ToList()
.ForEach(y =>
tweets.Add(new Tweet()
{
Tweet_Id = y.Tweet_Id,
User_Id = y.User_Id,
Message = y.Message,
Created = y.Created
}));
}
return(tweets);
}
public string Update(Person person)
{
using (var db = new MVCApplicationEntities())
{
var upPerson = db.People.Where(a => a.User_Id.ToLower().Equals(person.User_Id.ToLower())).FirstOrDefault();
var updatePerson = db.People.Where(a => !a.User_Id.ToLower().Equals(person.User_Id.ToLower()) && a.Email.ToLower().Equals(person.Email.ToLower())).FirstOrDefault();
if (upPerson != null && updatePerson == null)
{
upPerson.Password = person.Password ?? upPerson.Password;
upPerson.FullName = person.FullName;
upPerson.Email = person.Email;
upPerson.Active = person.Active;
db.SaveChanges();
}
else
{
return("EmailId already registered with other user");
}
return("success");
}
}
