public IActionResult PromoteStudents(PromotionsReq request)
{
String resp = entityStudent.promoteStudents(request);
if (resp == null)
{
return(BadRequest("problem z promocja"));
}
return(Ok(resp));
}
public IActionResult PromoteStudents(PromotionsReq request)
{
var resp = enrolmentDb.promoteStudents(request);
if (resp == null)
{
return(NotFound("zły semestr lub student"));
}
return(Ok(resp));
}
public String promoteStudents(PromotionsReq request)
{
var enrolments = context.Enrollment.Where(e => e.Semester == request.Semester).Where(e => e.IdStudyNavigation.Name == request.Studies).ToList();
if (enrolments.Count == 0 || enrolments == null)
{
return(null);
}
enrolments.ForEach(e => e.Semester = e.Semester + 1);
enrolments.ForEach(e => context.Enrollment.Update(e));
context.SaveChanges();
return("udało się zwiekszyć lvl studentów");
}
public PromotionsResp promoteStudents(PromotionsReq req)
{
using (SqlConnection connection = new SqlConnection(SystemConsts.DB_ADDRESS))
using (SqlCommand command = new SqlCommand())
{
connection.Open();
command.Connection = connection;
getPromotiontByStudiesAndSemester(command, req.Studies, req.Semester);
command.CommandText = "EXECUTE dbo.StudentsPromotion @Studies, @Semester";
command.Parameters.Clear();
command.Parameters.AddWithValue("@Studies", req.Studies);
command.Parameters.AddWithValue("@Semester", req.Semester);
command.ExecuteNonQuery();
return(getPromotiontByStudiesAndSemester(command, req.Studies, req.Semester + 1));
}
}
