public IActionResult PromotionStudent(PromotionStudentsReq req)
{
try
{
StudyEnrollment enroll = _dbService.PromotionStudents(req);
String uris = $"/api/enrollments/{enroll.IdEnrollment}";
return(Created(uris, enroll));
}
catch (StudyEnrollmentNotFoundException)
{
return(NotFound());
}
}
public StudyEnrollment PromotionStudents(PromotionStudentsReq req)
{
using (var conn = new SqlConnection(SqlConnect))
using (var cmd = new SqlCommand())
{
conn.Open();
cmd.Connection = conn;
FindEnrollmentBySemesterAndStudies(cmd, req.Studies, req.Semester);
cmd.CommandText = @"PromotionStudents";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Clear();
cmd.Parameters.AddWithValue("@Studies", req.Studies);
cmd.Parameters.AddWithValue("@Semester", req.Semester);
cmd.Parameters.AddWithValue("@NewIdEnrollment", 0);
cmd.ExecuteNonQuery();
int newSemester = req.Semester + 1;
return(FindEnrollmentBySemesterAndStudies(cmd, req.Studies, newSemester));
}
}