public List <Tweet> GetJoinList(User entity)
{
using (var context = new TwetterContext())
{
var detaits = context.Tweets.Where(a => a.UserId == entity.Id).Include(x => x.Likes).Include("Retweets").Include("Reply").ToList();
return(detaits);
}
}
public void updatestate(Like like)
{
using (var context = new TwetterContext())
{
context.Entry(like).State = EntityState.Modified;
context.SaveChanges();
};
}
public void updatestate(Connection conn)
{
using (var context = new TwetterContext())
{
context.Entry(conn).State = EntityState.Modified;
context.SaveChanges();
};
}
public void updatestate(Retweet entity)
{
using (var context = new TwetterContext())
{
context.Entry(entity).State = EntityState.Modified;
context.SaveChanges();
};
}
public List <Like> GetLike(int id)
{
using (var context = new TwetterContext())
{
var Likelanan = context.Likes.Where(x => x.TweetId == id).ToList();
return(Likelanan);
};
}
public List <Retweet> GetLike(int id)
{
using (var context = new TwetterContext())
{
var retwetlenen = context.Retweets.Where(x => x.TweetId == id).ToList();
return(retwetlenen);
};
}
public List <User> userListGetById(List <Connection> entity)
{
using (var context = new TwetterContext())
{
List <User> userlist = new List <User>();
foreach (var item in entity)
{
var getir = context.Users.Where(x => x.Id == item.takipid).ToList();
userlist.AddRange(getir);
}
return(userlist);
}
}
public List <Tweet> GetListTweetbyUsers(List <User> entity)
{
using (var context = new TwetterContext())
{
List <Tweet> tweets = new List <Tweet>();
foreach (var item in entity)
{
var gelen = context.Tweets.Where(x => x.UserId == item.Id).ToList();
tweets.AddRange(gelen);
}
return(tweets);
}
}
public List <User> GetSearchvalue(string search)
{
using (var context = new TwetterContext())
{
List <User> allsearch = context.Users.Where(x => x.Username.Contains(search)).Select(x => new User()
{
Id = x.Id,
Name = x.Username,
Username = x.Username,
}).ToList();
return(allsearch.ToList());
}
}
public List <Connection> GetFollowers(int id)
{
using (var context = new TwetterContext())
{
var takipci = context.Connections.Where(x => x.takipid == id).Select(k => new Connection()
{
takipid = k.takipid,
Isdeleted = k.Isdeleted,
TakipciId = k.TakipciId,
Isactive = k.Isactive
}).ToList();
return(takipci);
};
}
public EfLike(TwetterContext context) : base(context)
{
}
public EfUser(TwetterContext context) : base(context)
{
}
public EfTweet(TwetterContext context) : base(context)
{
}
public EfConnection(TwetterContext context) : base(context)
{
}
public EfReply(TwetterContext context) : base(context)
{
}
