/// <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);
}
