/// <summary> /// /// </summary> /// <param name="newStudent"></param> /// <param name="enrollment"></param> public void SetAsEnroll(Model.NewStudent newStudent, Model.Enrollment enrollment) { enrollment.NewStudentId = newStudent.NewStudentId; enrollment.EnrollmentTime = DateTime.Now; newStudent.sfbd = 1; using (MyDbContext dbContext = new MyDbContext()) { using (IDbContextTransaction trans = dbContext.Database.BeginTransaction()) { try { dbContext.Set <Model.Enrollment>().Add(enrollment); dbContext.Set <Model.NewStudent>().Update(newStudent); dbContext.SaveChanges(); trans.Commit(); } catch (Exception ex) { trans.Rollback(); throw (ex); } } } }
/// <summary> /// /// </summary> /// <param name="newStudent"></param> public void Update(Model.NewStudent newStudent) { using (MyDbContext dbContext = new MyDbContext()) { dbContext.Set <Model.NewStudent>().Update(newStudent); dbContext.SaveChanges(); } }
/// <summary> /// /// </summary> /// <param name="newStudent"></param> public void Add(Model.NewStudent newStudent) { using (MyDbContext dbContext = new MyDbContext()) { dbContext.Set <Model.NewStudent>().Add(newStudent); int flag = dbContext.SaveChanges(); } }
/// <summary> /// /// </summary> /// <param name="newStudent"></param> public void SetAsScience(Model.NewStudent newStudent) { using (MyDbContext dbContext = new MyDbContext()) { newStudent.sfwk = 0; dbContext.SaveChanges(); } }
/// <summary> /// /// </summary> /// <param name="newStudent"></param> public void SetAsLiberalArts(Model.NewStudent newStudent) { using (MyDbContext dbContext = new MyDbContext()) { newStudent.sfwk = 1; dbContext.SaveChanges(); } }
/// <summary> /// /// </summary> /// <param name="newStudent"></param> public void Delete(Model.NewStudent newStudent) { //1. 删除student //2. 删除报到信息 using (MyDbContext dbContext = new MyDbContext()) { dbContext.Set <Model.NewStudent>().Remove(newStudent); dbContext.SaveChanges(); } }
/// <summary> /// /// </summary> /// <param name="newStudent"></param> public void SetAsNotEnroll(Model.NewStudent newStudent) { using (MyDbContext dbContext = new MyDbContext()) { Model.Enrollment enrollment = dbContext.Set <Model.Enrollment>().Single(x => x.EnrollmentId == newStudent.NewStudentId); if (enrollment != null) { dbContext.Set <Model.Enrollment>().Remove(enrollment); dbContext.SaveChanges(); } } }
public void ChangeStudentClass(Model.NewStudent s, Model.Class newClass, Model.Class oldClass) { try { Model.StudentClass studentClass = this.dbContext.Set <Model.StudentClass>().Single(x => x.ClassId == oldClass.ClassId && x.StudentId == s.NewStudentId); studentClass.ClassId = newClass.ClassId; this.dbContext.SaveChanges(); } catch (Exception ex) { throw (ex); } }
/// <summary> /// /// </summary> /// <param name="s"></param> /// <param name="c"></param> public void RemoveStudentFromClass(Model.NewStudent s, Model.Class c) { try { Model.StudentClass studentClass = this.dbContext.Set <Model.StudentClass>().Single(x => x.ClassId == c.ClassId && x.StudentId == s.NewStudentId); this.dbContext.Set <Model.StudentClass>().Remove(studentClass); this.dbContext.SaveChanges(); } catch (Exception ex) { throw (ex); } }
/// <summary> /// /// </summary> /// <param name="s"></param> /// <param name="c"></param> public void AddStudentToClass(Model.NewStudent s, Model.Class c) { Model.StudentClass studentClass = new Model.StudentClass(); studentClass.ClassId = c.ClassId; studentClass.StudentId = s.NewStudentId; try { this.dbContext.Set <Model.StudentClass>().Add(studentClass); this.dbContext.SaveChanges(); } catch (Exception ex) { throw(ex); } }
public bool IsEnroll(Model.NewStudent newStudent) { return(newStudent.Enrollment != null); }