public Model.Enrollment GetEnrollment(int studentId)
{
string sql = "select * from [Enrollment] where StudentId=" + studentId.ToString();
Model.Enrollment enrollment = db.QuerySingleOrDefault <Model.Enrollment>(sql);
return(enrollment);
}
/// <summary>
///
/// </summary>
/// <param name="newStudent"></param>
/// <param name="enrollment"></param>
public void SetAsEnroll(Model.NewStudent newStudent, Model.Enrollment enrollment)
{
enrollment.NewStudentId = newStudent.NewStudentId;
try
{
this.dbContext.Set <Model.Enrollment>().Add(enrollment);
this.dbContext.SaveChanges();
}
catch (Exception ex)
{
throw (ex);
}
}
/// <summary>
///
/// </summary>
/// <param name="newStudent"></param>
public void SetAsNotEnroll(Model.NewStudent newStudent)
{
try
{
Model.Enrollment enrollment = this.dbContext.Set <Model.Enrollment>().Single(x => x.EnrollmentId == newStudent.NewStudentId);
if (enrollment != null)
{
this.dbContext.Set <Model.Enrollment>().Remove(enrollment);
this.dbContext.SaveChanges();
}
}
catch (Exception ex)
{
throw (ex);
}
}
public void SetAsEnrollment(int studentId, string memo1, string memo2)
{
string sql1 = "update [Student] set sfbd=1 where ID=" + studentId.ToString();
string sql2 = "insert into [Enrollment](EnrollmentTime,StudentId,Memo1,Memo2) values(@EnrollmentTime,@StudentId,@Memo1,@Memo2)";
Model.Enrollment e = new Model.Enrollment()
{
EnrollmentTime = DateTime.Now, StudentId = studentId, Memo1 = memo1, Memo2 = memo2
};
if (db.State == ConnectionState.Closed)
{
db.Open();
}
using (var transaction = db.BeginTransaction())
{
db.Execute(sql1, transaction);
db.Execute(sql2, e, transaction);
transaction.Commit();
}
}
