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