public IActionResult PromoteStudents(PromotionStudentRequest promotionStudentRequest) { using (var con = new SqlConnection("Data Source=db-mssql.pjwstk.edu.pl;Initial Catalog=2019SBD;Integrated Security=True")) using (var com = new SqlCommand()) { con.Open(); SqlTransaction tran = con.BeginTransaction(); com.Transaction = tran; com.Connection = con; com.Parameters.AddWithValue("Semester", promotionStudentRequest.Semester); com.Parameters.AddWithValue("idStudy", promotionStudentRequest.Studies); com.CommandText = "select count() 'cnt' from Enrollment where semester = @Semester " + "and idStudy = (select idstudy from Studies where idstudy = @idStudy )"; var dr = com.ExecuteReader(); dr.Read(); if ((int)dr["cnt"] > 0) { dr.Close(); com.CommandText = "P_PromoteStudent"; com.CommandType = System.Data.CommandType.StoredProcedure; } else { return(NotFound("Not Found")); } } return(Ok()); }
public IActionResult PromoteStudents(PromotionStudentRequest request, string promotions) { if (promotions.Equals("promotions")) { try { return(Ok(_service.PromoteStudents(request.Semester, request.Studies))); } catch (Exception ex) { return(BadRequest(ex.Message)); } } else { return(BadRequest("Bad request!")); } }
//[Authorize(Roles = "employee")] public IActionResult PromoteStudent(PromotionStudentRequest request) { var st = _service.GetStudyName(request.Studies); if (st == null) { return(NotFound("Nie znaleziono")); } var enrollment = _service.GetEnrollment(st.IdStudy, request.Semester); var setEnrollment = _service.Promote(st.IdStudy, request.Semester); return(CreatedAtAction(nameof(GetEnrollment), new { idEnrollment = setEnrollment.IdEnrollment }, new EnrollStudentResponse { IdEnrollment = setEnrollment.IdEnrollment, IdStudy = setEnrollment.IdStudy, Semester = setEnrollment.Semester, StartDate = setEnrollment.StartDate })); }
public IActionResult PromotionStudent(PromotionStudentRequest promotion) { return(_service.PromoteStudents(promotion)); }
public IActionResult PromoteStudents(PromotionStudentRequest request, string promotions) { if (promotions.Equals("promotions")) { int idStud; using (var con = new SqlConnection("Data Source=db-mssql;Initial Catalog=s16503;Integrated Security=True;")) using (var com = new SqlCommand()) { com.Connection = con; com.CommandText = "SELECT Studies.IdStudy FROm Studies WHERE Studies.Name = '" + request.Studies + "';"; con.Open(); var dr = com.ExecuteReader(); if (dr.Read()) { idStud = (int)dr["IdStudy"]; } else { return(NotFound("Not found >> studia")); } // var tran = con.BeginTransaction("SampleTransaction"); // com.Transaction = tran; com.CommandText = "select IdEnrollment from Enrollment where IdStudy=" + idStud + " AND Semester= " + request.Semester + ";"; // con.Open(); // dr = com.ExecuteReader(); dr.Close(); dr = com.ExecuteReader(); if (!dr.Read()) { return(NotFound("Not found >> enrollment")); } con.Close(); dr.Close(); } using (var con = new SqlConnection("Data Source=db-mssql;Initial Catalog=s16503;Integrated Security=True;")) using (var com = new SqlCommand("Promotions", con)) { com.Connection = con; con.Open(); try { com.CommandType = System.Data.CommandType.StoredProcedure; com.Parameters.Add("@Studies", SqlDbType.VarChar).Value = request.Studies; com.Parameters.Add("@Semester", SqlDbType.Int).Value = request.Semester; com.ExecuteNonQuery(); // NIECH PROCEDURA ZWRACA ENROLLMENT (selectem ) << reultSet con.Close(); } catch (SqlException ex) { return(BadRequest("sql error > " + ex.Message)); } } using (var con = new SqlConnection("Data Source=db-mssql;Initial Catalog=s16503;Integrated Security=True;")) using (var com = new SqlCommand()) { com.Connection = con; com.CommandText = "SELECT * FROM Enrollment WHERE Semester = " + (request.Semester + 1) + " AND IdStudy = " + idStud + " ORDER BY IdEnrollment;"; con.Open(); var dr = com.ExecuteReader(); var enrollment = new Enrollment(); if (dr.Read()) { enrollment.IdEnrollment = (int)dr["IdEnrollment"]; enrollment.Semester = (int)dr["Semester"]; enrollment.Study = request.Studies; enrollment.StartDate = dr["StartDate"].ToString(); } else { return(NotFound("not found new enrollment!")); } return(Ok(enrollment)); } } else { return(BadRequest("Bad request!")); } }