public IActionResult Pass(int id) { var subject = DB.Subjects .Include(x => x.Student) .Where(x => x.Id == id) .SingleOrDefault(); if (subject == null) { return RedirectToAction("Error", "Home"); } else { var student = DB.Students .Where(x => x.Id == subject.StudentId) .SingleOrDefault(); student.State = State.锁定; subject.Draw = Draw.通过; subject.DrawTime = DateTime.Now; DB.SaveChanges(); var ordersub = DB.Subjects .Where(x => x.StudentId == student.Id) .Where(x => x.Id != subject.Id) .Where(x => x.Draw == Draw.待审核||x.Draw==Draw.未通过) .ToList(); foreach (var x in ordersub) { x.DrawTime = DateTime.Now; x.Draw = Draw.未通过; DB.Logs.Add(new Log { Roles = Roles.老师, Operation = Operation.审核题目未通过, Time = DateTime.Now, UserId = User.Current.Id, Number = x.Id, }); } var log = new Log { UserId = User.Current.Id, Roles = Roles.老师, Number = subject.Id, Operation = Operation.审核题目通过, Time = DateTime.Now, }; DB.Logs.Add(log); var info = new Information { SNumber = student.Id, TNumber = DB.Teachers.Where(x => x.UserId == User.Current.Id).SingleOrDefault().Id, CreateTime = DateTime.Now, IsRead = false, Content = "老师已经将您的题目 《" + subject.Title + "》 审核通过", }; DB.Informations.Add(info); DB.SaveChanges(); return Content("success"); } }
public IActionResult Failure(int id) { var subject = DB.Subjects .Where(x => x.Id == id) .SingleOrDefault(); if (subject == null) { return RedirectToAction("Error", "Home"); } else { var student = DB.Students .Where(x => x.Id == subject.StudentId) .SingleOrDefault(); subject.Draw = Draw.未通过; subject.DrawTime = DateTime.Now; var log = new Log { Roles = Roles.老师, Operation = Operation.审核题目未通过, Time = DateTime.Now, Number = subject.Id, UserId = User.Current.Id, }; DB.Logs.Add(log); var info = new Information { SNumber = student.Id, TNumber = DB.Teachers.Where(x => x.UserId == User.Current.Id).SingleOrDefault().Id, CreateTime = DateTime.Now, IsRead = false, Content = "老师已经将您的题目 《" + subject.Title + "》 设置为审核未通过", }; DB.Informations.Add(info); DB.SaveChanges(); return Content("success"); } }
public IActionResult NotSelected(int id) { var student = DB.Students .SingleOrDefault(x => x.Id == id); if (student == null) { return Content("error"); } else { var subject = DB.Subjects .Where(x => x.StudentId == student.Id) .ToList(); foreach(var x in subject) { //DB.Subjects.Remove(x); x.Draw = Draw.未通过; } student.State = State.未锁定; var info = new Information { SNumber = id, TNumber = DB.Teachers.Where(x => x.UserId == User.Current.Id).SingleOrDefault().Id, CreateTime = DateTime.Now, IsRead = false, Content = "您之前选择的老师 "+ DB.Teachers.Where(x => x.UserId == User.Current.Id).SingleOrDefault().Name+ " 觉得你不适合他们组,请选择别的指导老师...", }; DB.Informations.Add(info); DB.SaveChanges(); return Content("success"); } }