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