public IActionResult promote(PromoteDTO req)
{
var res = context.Enrollment.Join(context.Study, enrollment => enrollment.IdStudy,
studies => studies.IdStudy, ((enrollment, studies) => new
{
studies.Name,
enrollment.Semester
})).Where(res => res.Name == req.studies && res.Semester == req.semester);
if (!res.Any())
{
return(new BadRequestResult());
}
context.Database.ExecuteSqlInterpolated($"exec promoteStudent {req.studies}, {req.semester}");
context.SaveChanges();
return(new OkObjectResult(req));
}
public IActionResult Promote(PromoteDTO req)
{
return(service.promote(req));
}
