static IList <Message> GetMessages()
{
SqlDbContext context = new SqlDbContext();
//var resultFalse = context.Messages.Where(m => m.HasRead == false).OrderByDescending(m => m.DateTime).ToList();
//var resultTrue = context.Messages.Where(m => m.HasRead == true).OrderByDescending(m => m.DateTime).ToList();
//resultFalse.AddRange(resultTrue);
//return resultFalse;
return(context.Messages.FromSqlInterpolated($"SELECT * FROM Messages ORDER bY HasRead , DateTime DESC").ToList());
}
public ProblemRepository()
{
context = new SqlDbContext();
}
public UserRepository()
{
context = new SqlDbContext();
}
public HelpMoneyRepository()
{
context = new SqlDbContext();
}
public ArticleRepository()
{
context = new SqlDbContext();
}
static void Main(string[] args)
{
SqlDbContext context = new SqlDbContext();
//var db = context.Database;
//db.EnsureDeleted();
//db.EnsureCreated();
//利用EF，插入3个User对象
//User mbg = new User("马保国", "1234")
//{
// CreateTime = DateTime.Now,
// Id = 1
//};
//User mxg = new User("马大国", "1234")
//{
// CreateTime = DateTime.Now,
// Id = 2
//};
//User mdg = new User("马小国", "1234")
//{
// CreateTime = DateTime.Now,
// Id = 3
//};
//context.AddRange(mbg, mxg, mdg);
//通过主键找到其中一个User对象
//User user = context.Find<User>("马小国");
//修改该User对象的Name属性，将其同步到数据库
//User user = context.Find<User>("马小国");
//user.Name = "小马国";
//不加载User对象，仅凭其Id用一句Update SQL语句完成上题
//User user = new User("马国国", "")
//{
// Id = 3
//};
//context.Attach<User>(user);
//user.HelpBean = 55;
//删除该用户
//context.Remove<User>(context.Find<User>("马小国"));
// 利用Linq to EntityFramework，实现方法：
//GetBy(IList < ProblemStatus > exclude, bool hasReward, bool descByPublishTime)，该方法可以根据输入参数：
//IList<ProblemStatus> exclude：不显示（排除）某些状态的求助
//bool hasReward：只显示已有酬谢的求助（如果传入值为true的话）
//bool descByPublishTime：按发布时间正序还是倒序
//参考：求助列表（不显示 / 只显示）和文章列表（正序 / 倒序）
//context.AddRange(new Problem("总结-撤销") { Title = "总结", ProblemStatus = ProblemStatus.HasBackout, Summary = new Summary() { Content = "问题总结白给" } },
// new Problem("总结-撤销闪电乱鞭9") { Title = "总结", ProblemStatus = ProblemStatus.HasBackout, Summary = new Summary() { Content = "问题总结犹豫就会败北" } },
// new Problem("撤销闪电五连鞭8") { Title = "撤销", ProblemStatus = ProblemStatus.HasBackout },
// new Problem("撤销如何打好闪电五连鞭11") { Title = "撤销", ProblemStatus = ProblemStatus.HasBackout },
// new Problem("协助闪电乱鞭99") { Title = "协助", ProblemStatus = ProblemStatus.Helping },
// new Problem("协助闪电五连鞭88") { Title = "协助", ProblemStatus = ProblemStatus.Helping },
// new Problem("酬谢协助闪电五连鞭66") { Title = "酬谢", ProblemStatus = ProblemStatus.HasReward },
// new Problem("酬谢协助闪电五连鞭77") { Title = "酬谢", ProblemStatus = ProblemStatus.HasReward },
// new Problem("总结酬谢协助闪电五连鞭77") { Title = "酬谢", ProblemStatus = ProblemStatus.HasReward, Summary = new Summary() { Content = "果断就会白给" } },
// new Problem("总结酬谢协助闪电五连鞭77") { Title = "酬谢", ProblemStatus = ProblemStatus.HasReward, Summary = new Summary() { Content = "果断就会白给2" } }
//);
//List<ProblemStatus> problemStatuses = new List<ProblemStatus>();
//problemStatuses.Add(ProblemStatus.HasBackout);
//problemStatuses.Add(ProblemStatus.HasReward);
//problemStatuses.Add(ProblemStatus.Helping);
//IList<Problem> problems = GetBy(problemStatuses, true, false);
// 实现方法：GetMessage()，靠将消息列表：
//所有未读在已读前面
//未读和已读各自按生成时间排序
//context.Messages.AddRange(
// new Message() { DateTime = DateTime.Now.AddDays(-1), Content = "马保国发来挑战", HasRead = true, MessageStatus = MessageStatus.LeaveMessage },
// new Message() { DateTime = DateTime.Now.AddDays(-10), Content = "蔡徐坤邀请你打篮球", HasRead = false, MessageStatus = MessageStatus.Inform },
// new Message() { DateTime = DateTime.Now.AddDays(-50), Content = "吴亦凡邀请你充电", HasRead = false, MessageStatus = MessageStatus.comment },
// new Message() { DateTime = DateTime.Now.AddDays(-100), Content = "赵4邀请你跳舞", HasRead = false, MessageStatus = MessageStatus.comment },
// new Message() { DateTime = DateTime.Now.AddDays(-200), Content = "xx邀请你整容", HasRead = true, MessageStatus = MessageStatus.Inform }
//);
//IList<Message> messages = GetMessages();
// 观察一起帮的功能，思考并
//Email和User有一对一的关系，参照课堂演示，在数据库上建立User外键引用Email的映射
//按继承映射：Blog / Article / Suggest以及他们的父类Content
//contexkt.Add<Problem>(new Problem() { Author = new User("过过过", "") { CreateTime = DateTime.Now }, Body = "闪电鞭", Title = "打好闪电鞭", ProblemStatus = ProblemStatus.Helping });
//发布文章和求助时包含关键字（keyword）
//ProblemRepository problemRepository = new ProblemRepository();
//context.Add(
// new Problem()
// {
// Title = "如何打好闪电五连鞭",
// Body = "求大佬解答",
// Keywords = new List<Keyword>() { new Keyword() { Name = "闪电鞭" } },
// Reward = 5,
// PublishTime = DateTime.Now,
// Author = context.Users.Where(U => U.Id == 1).Include(U => U.HelpMoney).FirstOrDefault()
// }
// );
//context.Add(
// new Problem()
// {
// Title = "闪电五连鞭",
// Body = "等马保国老师",
// Keywords = new List<Keyword>() { context.Keywords.Find(1) },
// Reward = 5,
// PublishTime = DateTime.Now,
// Author = context.Users.Where(U => U.Id == 1).Include(U => U.HelpMoney).FirstOrDefault()
// }
// );
//context.Add(
// new Problem()
// {
// Title = "马保国是骗子",
// Body = "我被马保国骗了",
// Keywords = new List<Keyword>() { new Keyword() { Name = "骗子" } },
// Reward = 5,
// PublishTime = DateTime.Now,
// Author = context.Users.Where(U => U.Id == 1).Include(U => U.HelpMoney).FirstOrDefault()
// }
// );
//可以按关键字筛选求助
//var result = context.Keywords.Where(k => k.Name == "闪电鞭").Include(k => k.Problems).ToList();
//能够按作者（Author）/ 分类（Category）显示文章列表
//User xm = new User() { Name = "小马", Password = "", CreateTime = DateTime.Now, HelpMoney = new HelpMoney() { Surplus = 20 } };
//User xn = new User() { Name = "小牛", Password = "", CreateTime = DateTime.Now, HelpMoney = new HelpMoney() { Surplus = 20 } };
//context.AddRange(xm, xn);
//context.Add(new Article() { Title = "小马发布的文章", Body = "", PublishTime = DateTime.Now, Author = xm });
//context.Add(new Article() { Title = "小牛发布的文章", Body = "", PublishTime = DateTime.Now, Author = xn });
//var article = context.Articles.Where(a => a.Author.Name == "小马").ToList();
//var xm = context.Users.Where(u => u.Name == "小马").SingleOrDefault();
//var xn = context.Users.Where(u => u.Name == "小牛").SingleOrDefault();
//Category category1 = new Category() { Name = "精品文章", Author = xm };
//Category category2 = new Category() { Name = "精品文章", Author = xn };
//context.Add(category1);
//context.Add(category2);
//context.Add(new Article() { Title = "精品系列-小马发布", Body = "", PublishTime = DateTime.Now, Category = category1 });
//context.Add(new Article() { Title = "日常系列-小牛发布", Body = "", PublishTime = DateTime.Now, Category = category2 });
//var result = context.Categories.Where(c => c.Id == 1).Include(c => c.Author).Include(c => c.Articles).SingleOrDefault();
//能够选择文章列表的排序方向（按发布时间顺序倒序）和每页显示格式（50篇标题 / 10篇标题 + 摘要）
//var result = GetbyArticles(true, false);
//发布文章会：扣掉作者1枚帮帮币、增加10个帮帮点
//帮帮点和帮帮币的每一次变更都会被记录并可以显示
//UserRepository userRepository = new UserRepository();
//User xm = userRepository.GetUserById(1);
//Article article = new Article()
//{
// Title = "精品系列666-小马发布",
// Body = "",
// PublishTime = DateTime.Now,
// Author = xm
//};
//xm.Articles = new List<Article>();
//xm.Articles.Add(article);
//article.Publish();
//xm.HelpMoney.Accounts = new List<Account>() { new Account() { CreateTime = DateTime.Now, Freeze = 0, Remark = "发布文章", Variation = "-1", Usable = xm.HelpMoney.Surplus } };
//userRepository.Save();
//发布求助时可以设置悬赏帮帮币，发布后会被冻结，求助被解决时会划拨给好心人
User xn = context.Users.Include(u => u.HelpMoney).Where(u => u.Id == 2).SingleOrDefault();
Problem p1 = new Problem()
{
Title = "想学闪电五连鞭",
Body = "强身健体",
ProblemStatus = ProblemStatus.Helping,
Author = xn,
CreateTime = DateTime.Now,
PublishTime = DateTime.Now,
Reward = 5,
};
xn.HelpMoney.Surplus -= 5;
xn.HelpMoney.Accounts = new List <Account>()
{
new Account()
{
CreateTime = DateTime.Now, Freeze = 5, Remark = "求助的悬赏", Usable = xn.HelpMoney.Surplus, Variation = "-5"
}
};
context.Add(p1);
context.SaveChanges();
}
