public void PromoteStudent(EnrollPromotionsRequest enrollPromotionsRequest)
{
var st = new Student();
st.Studies = enrollPromotionsRequest.Studies;
st.Semester = enrollPromotionsRequest.Semester;
using (var con = new SqlConnection(ConString))
using (var com = new SqlCommand())
{
com.Connection = con;
con.Open();
var transaction = con.BeginTransaction();
com.Transaction = transaction;
try
{
com.CommandText = "EXEC @studies, @semester";
com.Parameters.AddWithValue("studies", enrollPromotionsRequest.Studies);
com.Parameters.AddWithValue("semester", enrollPromotionsRequest.Semester);
com.ExecuteNonQuery();
transaction.Commit();
}
catch (SqlException)
{
transaction.Rollback();
}
}
}
public IActionResult EnrollPromotions(EnrollPromotionsRequest request)
{
EnrollStudentResponse response = null;
try {
response = _service.EnrollPromotions(request);
} catch (SqlException e) {
return(NotFound(e.Message));
}
return(Created(nameof(response), response));
}
public EnrollStudentResponse EnrollPromotions(EnrollPromotionsRequest request)
{
EnrollStudentResponse response = null;
using (var con = new SqlConnection(ConString))
using (var com = new SqlCommand()) {
com.Connection = con;
con.Open();
com.CommandText = "exec enrollpromotions @studies, @semester";
com.Parameters.AddWithValue("studies", request.Studies);
com.Parameters.AddWithValue("semester", request.Semester);
var dr = com.ExecuteReader();
if (dr.Read())
{
response = new EnrollStudentResponse {
IdEnrollment = int.Parse(dr["IdEnrollment"].ToString()),
Semester = int.Parse(dr["Semester"].ToString()),
Study = dr["Name"].ToString(),
StartDate = dr["StartDate"].ToString()
};
}
}
return(response);
}
public IActionResult Promotions(EnrollPromotionsRequest request)
{
if (!ModelState.IsValid)
{
var d = ModelState;
return(BadRequest("!!!"));
}
var enroll = new Enrollment();
using (var con = new SqlConnection("Data Source=db-mssql;Initial Catalog=s15157;Integrated Security=True"))
using (var com = new SqlCommand())
{
com.Connection = con;
con.Open();
var tran = con.BeginTransaction();
com.Transaction = tran;
try
{
com.CommandText = "SELECT IdStudy FROM Studies WHERE name=@name";
com.Parameters.AddWithValue("name", request.Studies);
var IdStudy = (int)com.ExecuteScalar();
com.CommandText = "select IdEnrollment FROM Enrollment WHERE IdStudy=@IdStudy AND Semester=@Semester";
com.Parameters.AddWithValue("Semester", (int)request.Semester);
com.Parameters.AddWithValue("IdStudy", IdStudy);
var dr = com.ExecuteReader();
if (!dr.Read())
{
return(BadRequest("Wpis w tabeli Enrollment nie istnieje"));
}
dr.Close();
SqlCommand cmd = new SqlCommand("dbo.PromoteStudents", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Studies", request.Studies);
cmd.Parameters.AddWithValue("@Semester", request.Semester);
cmd.Transaction = tran;
cmd.ExecuteNonQuery();
dr.Close();
com.CommandText = "SELECT IdEnrollment FROM Enrollment WHERE IdStudy=@IdStudy AND Semester=@Semester";
enroll.IdEnrollment = (int)com.ExecuteScalar();
enroll.IdStudy = IdStudy;
enroll.Semester = (int)request.Semester + 1;
com.CommandText = "SELECT StartDate FROM Enrollment WHERE IdStudy=@IdStudy AND Semester=@Semester";
dr.Close();
dr = com.ExecuteReader();
if (dr.Read())
{
enroll.StartDate = dr.GetDateTime(dr.GetOrdinal("StartDate"));
}
dr.Close();
tran.Commit();
}
catch (SqlException exc)
{
tran.Rollback();
}
}
return(Ok(enroll));
}
public void PromoteStudent(EnrollPromotionsRequest request)
{
_dbContext.Database.ExecuteSqlRaw("EXEC PromoteStudentProcedure @studies, @semester", request.Studies,
request.Semester);
}
public IActionResult GetStudent(EnrollPromotionsRequest enrollPromotionsRequest)
{
_server.PromoteStudent(enrollPromotionsRequest);
return(Ok(enrollPromotionsRequest));
}
public void EnrollPromotions(EnrollPromotionsRequest request)
{
_context.Database.ExecuteSqlInterpolated($"exec enrollpromotions {request.Studies}, {request.Semester}");
}
public IActionResult EnrollPromotions(EnrollPromotionsRequest request)
{
_service.EnrollPromotions(request);
return(Created(nameof(request), request));
}
public IActionResult PromoteStudents(EnrollPromotionsRequest enrollPromotionsRequest)
{
_server.PromoteStudent(enrollPromotionsRequest);
return(Ok("Success with promotions"));
}
