public List <Topic> TopicAll()
{
using (var db = new LoveDb())
{
return(db.Topics.ToList());
}
}
public Message LastOne(Func <Message, bool> predicate)
{
using (var db = new LoveDb())
{
return(db.Messages.ToList().Where(predicate).LastOrDefault());
}
}
public LoginLog LastOne(Func <LoginLog, bool> predicate)
{
using (var db = new LoveDb())
{
return(db.LoginLogs.ToList().Where(predicate).LastOrDefault());
}
}
public Authority One(Func <Authority, bool> predicate)
{
using (var db = new LoveDb())
{
return(db.Authoritys.ToList().Where(predicate).FirstOrDefault());
}
}
public Praise One(Func <Praise, bool> predicate)
{
using (var db = new LoveDb())
{
return(db.Praises.ToList().Where(predicate).FirstOrDefault());
}
}
public Comment One(Func <Comment, bool> predicate)
{
using (var db = new LoveDb())
{
return(db.Comments.ToList().Where(predicate).FirstOrDefault());
}
}
public EnjoyTopic One(Func <EnjoyTopic, bool> predicate)
{
using (var db = new LoveDb())
{
return(db.EnjoyTopics.ToList().Where(predicate).FirstOrDefault());
}
}
public List <Message> MessageAll()
{
using (var db = new LoveDb())
{
return(db.Messages.ToList());
}
}
public List <Comment> CommentAll()
{
using (var db = new LoveDb())
{
return(db.Comments.ToList());
}
}
public List <Role> RoleAll()
{
using (var db = new LoveDb())
{
return(db.Roles.ToList());
}
}
public List <ReportLog> ReportLogAll()
{
using (var db = new LoveDb())
{
return(db.ReportLogs.ToList());
}
}
public List <Iamgbox> IamgAll()
{
using (var db = new LoveDb())
{
return(db.Iamgboxes.ToList());
}
}
public List <State> StateAll()
{
using (var db = new LoveDb())
{
return(db.States.ToList());
}
}
public List <DisLove> DisLoveAll()
{
using (var db = new LoveDb())
{
return(db.DisLoves.ToList());
}
}
public LoveView One(Func <LoveView, bool> predicate)
{
using (var db = new LoveDb())
{
return(db.LoveViews.ToList().Where(predicate).FirstOrDefault());
}
}
public List <AdminStatistic> AdminStatisticAll()
{
using (var db = new LoveDb())
{
return(db.AdminStatistics.ToList());
}
}
public DetailInfo One(Func <DetailInfo, bool> predicate)
{
using (var db = new LoveDb())
{
return(db.DetailInfos.ToList().Where(predicate).FirstOrDefault());
}
}
public List <VisitLog> VisitorAll()
{
using (var db = new LoveDb())
{
return(db.VisitLogs.ToList());
}
}
public Hello One(Func <Hello, bool> predicate)
{
using (var db = new LoveDb())
{
return(db.Hellos.ToList().Where(predicate).FirstOrDefault());
}
}
public List <Praise> PraiseAll()
{
using (var db = new LoveDb())
{
return(db.Praises.ToList());
}
}
public UserHot One(Func <UserHot, bool> predicate)
{
using (var db = new LoveDb())
{
return(db.UserHots.ToList().Where(predicate).FirstOrDefault());
}
}
public List <Hello> HelloAll()
{
using (var db = new LoveDb())
{
return(db.Hellos.ToList());
}
}
public AdminStatistic One(Func <AdminStatistic, bool> predicate)
{
using (var db = new LoveDb())
{
return(db.AdminStatistics.ToList().Where(predicate).FirstOrDefault());
}
}
/// <summary>
/// 已经倒叙
/// </summary>
/// <returns></returns>
public List <Report> ReportAll()
{
using (var db = new LoveDb())
{
return(db.Reports.OrderByDescending(n => n.Id).ToList());
}
}
public ReportLog One(Func <ReportLog, bool> predicate)
{
using (var db = new LoveDb())
{
return(db.ReportLogs.ToList().Where(predicate).FirstOrDefault());
}
}
public List <UserHot> UserHotAllDes()
{
using (var db = new LoveDb())
{
return(db.UserHots.OrderByDescending(n => n.HotValue).ToList());
}
}
public Topic LastOne(Func <Topic, bool> predicate)
{
using (var db = new LoveDb())
{
return(db.Topics.ToList().Where(predicate).LastOrDefault());
}
}
public Iamgbox One(Func <Iamgbox, bool> predicate)
{
using (var db = new LoveDb())
{
return(db.Iamgboxes.ToList().Where(predicate).FirstOrDefault());
}
}
/// <summary>
/// 将IsRead=false的消息设置为true
/// </summary>
public void ReadMessage <T>(int id)
{
using (var db = new LoveDb())
{
switch (typeof(T).Name)
{
//消息
case "Message":
db.Messages.Find(id).IsReaded = true;
break;
case "MyLove":
db.MyLoves.Find(id).IsRead = true;
break;
case "VisitLog":
db.VisitLogs.Find(id).IsRead = true;
break;
case "EnjoyTopic":
db.EnjoyTopics.Find(id).IsRead = true;
break;
}
db.SaveChanges();
}
}
public List <MyLove> MyLoveAll()
{
using (var db = new LoveDb())
{
return(db.MyLoves.ToList());
}
}
