public bool ExecuteDatabaseProcedurePromote(PromotePost promotePost)
{
var par1 = new SqlParameter("@studies", promotePost.Studies);
var par2 = new SqlParameter("@semester", promotePost.Semester);
_context.Database.ExecuteSqlRaw("EXECUTE promoteForNextSemester @studies , @semester", par1, par2);
return(true);
}
public IActionResult Promote(PromotePost studies)
{
/* checking if database conatins enrollment with given parameters */
if (!_dbService.ConatinsEnrollment(studies))
{
return(BadRequest("Database does not contain enroll with given parameters."));
}
/* executing procedure */
if (!_dbService.ExecuteDatabaseProcedurePromote(studies))
{
return(BadRequest("Failed to promote students. Restoring changes."));
}
/* returned result */
return(Created("Enroll for updated students", _dbService.ConatinsEnrollment(studies)));
}
Models.Enrollment IStudentsDbService.PromotedEnrollmentStudent(PromotePost promotePost)
{
throw new NotImplementedException();
}
public bool ConatinsEnrollment(PromotePost promotePost)
{
throw new NotImplementedException();
}
