Example #1
0
        public IActionResult CreateSubject(Subject subject,string teacher)
        {
            var student = DB.Students
                .Where(x => x.UserId == User.Current.Id)
                .SingleOrDefault();
            var sub = DB.Subjects
                .Include(x=>x.Student)
                .Where(x => x.Title == subject.Title&&x.Student.IsGraduate==IsGraduate.否&&x.Student.MajorId==student.MajorId)
                .SingleOrDefault();
            if (student == null)
            {
                return Content("error");
            }
            else
            {
                if (sub != null)
                {
                    return Content("重复添加");
                }
                else
                {
                    if (student.State == State.锁定)
                    {
                        return Content("锁定");
                    }

                    else
                    {
                        var tea = DB.Teachers
                        .Where(x => x.Name == teacher)
                        .SingleOrDefault();
                        subject.Draw = Draw.待审核;
                        subject.StudentId = student.Id;
                        subject.TeacherId = tea.Id;
                        subject.PostTime = DateTime.Now;
                        DB.Subjects.Add(subject);
                        DB.SaveChanges();
                        var log = new Log
                        {
                            Time = DateTime.Now,
                            Roles = Roles.学生,
                            Operation = Operation.添加毕业设计选题,
                            UserId = User.Current.Id,
                            Number = subject.Id,
                        };
                        DB.Logs.Add(log);
                        DB.SaveChanges();
                        return Content("success");
                    }
                }
            }
            
        }
Example #2
0
 public IActionResult FixedStudent(string teachername,string studentname,string subjecttitle)
 {
     var teacher = DB.Teachers
         .Where(x => x.Name == teachername && x.MajorId == DB.Teachers
         .Where(y => y.UserId == User.Current.Id)
         .SingleOrDefault()
         .MajorId)
         .SingleOrDefault();
     var student = DB.Students
         .Where(x => x.Name == studentname && x.MajorId == DB.Teachers
         .Where(y => y.UserId == User.Current.Id)
         .SingleOrDefault()
         .MajorId&&x.IsGraduate==IsGraduate.否)
         .SingleOrDefault();
     var sub = DB.Subjects
         .Include(x=>x.Student)
         .Where(x => x.Student.MajorId == DB.Teachers
         .Where(y => y.UserId == User.Current.Id)
         .SingleOrDefault()
         .MajorId&&x.Student.Name==studentname&&x.Student.IsGraduate==IsGraduate.否)
         .ToList();
     foreach(var x in sub)
     {
         //DB.Subjects.Remove(x);
         x.Draw = Draw.未通过;
     }
     var subject = new Subject
     {
         TeacherId=teacher.Id,
         StudentId=student.Id,
         DrawTime=DateTime.Now,
         PostTime=DateTime.Now,
         Draw=Draw.通过,
         Title=subjecttitle,
     };
     DB.Subjects.Add(subject);
     student.State = State.锁定;
     var log = new Log
     {
         Operation = Operation.添加学生,
         Roles = Roles.系主任,
         Number = student.Id,
         Time = DateTime.Now,
         UserId = User.Current.Id,
     };
     DB.Logs.Add(log);
     var info = DB.Informations.Add(new Information
     {
         SNumber = student.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 + " 已经将你的题目改为《" + subjecttitle + "》,指导老师为" + teachername,
     });
     DB.SaveChanges();
     return RedirectToAction("Subject", "Admin");
 }