public void UpdateStudentsSemester(SemestersIdModel model, ref string errorMessage)
{
using (SZPNUWContext context = new SZPNUWContext())
using (IDbContextTransaction transaction = context.Database.BeginTransaction())
{
try
{
List <int> studentsId = context.Studentsemester.Where(x => x.Semesterid == model.SemesterId).Select(x => x.Studentid).ToList();
if (studentsId.AnyLazy())
{
foreach (int studentId in studentsId)
{
UpdateStudentSemester(context, studentId, model.SemesterId.Value, model.NewSemesterId.Value, ref errorMessage);
}
transaction.Commit();
}
else
{
errorMessage = PortalMessages.NoStudentsOnSemester;
}
}
catch (Exception e)
{
transaction.Rollback();
errorMessage = e.Message;
}
}
}
public IActionResult UpdateStudentSemester([FromBody] SemestersIdModel model)
{
if (ModelState.IsValid)
{
string errorMessage = string.Empty;
service.UpdateStudentSemester(model.StudentId, model.SemesterId.Value, model.NewSemesterId.Value, ref errorMessage);
if (errorMessage.HasValue())
{
return(Json(new Result(errorMessage)));
}
return(Json(new Result(true)));
}
return(Json(new Result(ModelState.GetFirstError())));
}
public IActionResult RewriteStudentsSemester([FromBody] SemestersIdModel model)
{
if (ModelState.IsValid)
{
string errorMessage = string.Empty;
service.RewriteStudentsSemester(model, ref errorMessage);
if (errorMessage.HasValue())
{
return(Json(new Result(errorMessage)));
}
return(Json(new Result(true)));
}
return(Json(new Result(ModelState.GetFirstError())));
}
public void UpdateStudentsSemester(SemestersIdModel model, ref string errorMessage)
{
service.UpdateStudentsSemester(model, ref errorMessage);
}
