public IActionResult EnrollStudent(EnrollStudentRequest req) { EnrollStudentResponse erep = new EnrollStudentResponse(); erep = iDB.EnrollStudent(req); return(Created("Added", erep)); }
public IActionResult EnrollStudent(EnrollStudentRequest request) //public IActionResult EnrollStudent(Student newstudent) { return(RespoState(_service.EnrollStudent(request))); //walidacja /*if(newstudent.FirstName==null || newstudent.LastName == null) * { * return BadRequest("Brak danych"); * } */ /* * using(var con=new SqlConnection(ConString2)) * using(var com=new SqlCommand()) * { * * com.Connection = con; * var tran = con.BeginTransaction(); * try * { * //czy studia istnieją * com.CommandText = "select IdStudies from studies where name=@name"; * com.Parameters.AddWithValue("name", newstudent.Studies); * var dr = com.ExecuteReader(); * if (!dr.Read()) * { * tran.Rollback(); * return BadRequest("Studia nie istnieją"); * } * // * * int idstudies = (int)dr["IdStudies"]; * //dodanie studenta * com.CommandText = "INSERT INTO Student(IndexNumber, FirstName, LastName, BirthDate, Studies) VALUES(@IndexNumber, @FirstName, @LastName, @BirthDate, @Studies)"; * com.Parameters.AddWithValue("IndexNumber", newstudent.IndexNumber); * com.Parameters.AddWithValue("FirstName", newstudent.FirstName); * com.Parameters.AddWithValue("LastName", newstudent.LastName); * com.Parameters.AddWithValue("BirthDate", newstudent.BirthDate); * com.Parameters.AddWithValue("Studies", newstudent.Studies); * //.. * com.ExecuteNonQuery(); * tran.Commit(); * }catch(SqlException ex) * { * tran.Rollback(); * return BadRequest(ex); * } * }*/ return(Ok()); }
public IActionResult EnrollStudent(EnrollStudentRequest request) { if (!ModelState.IsValid) { var d = ModelState; return(BadRequest("!!!")); } var response = _service.EnrollStudent(request); if (response.Status == 201) { return(CreatedAtAction(response.Message, response.enrollment)); } return(BadRequest(response.Message)); }
public IActionResult EnrollStudnet(EnrollStudentRequest student) { return(Created("", _service.EnrollStudent(student))); }
public IActionResult EnrollStudent(EnrollStudentRequest request) { // { // var student = new Student(); // student.IndexNumber = request.IndexNumber; // student.FirstName = request.FirstName; // student.LastName = request.LastName; // student.BirthDate = request.BirthDate; // // Enrollment enrollment = new Enrollment(); // // // // if (!ModelState.IsValid) // { // var d = ModelState; // return BadRequest("!!!"); // } // // using (var con = new SqlConnection(ConString)) // { // using (var com = new SqlCommand()) // { // com.Connection = con; // con.Open(); // // var transaction = con.BeginTransaction(); // com.Transaction = transaction; // // try // { // Console.WriteLine(request.Studies); // // Sprawdzenie czy studia istnieją // com.CommandText = "SELECT IdStudy from studies where name = @name"; // com.Parameters.AddWithValue("name", request.Studies); // // var dr = com.ExecuteReader(); // // if (!dr.Read()) // { // dr.Close(); // transaction.Rollback(); // return BadRequest("Studia nie istnieją"); // //... // } // // int idStudies = (int) dr["IdStudy"]; // dr.Close(); // // enrollment.IdStudy = idStudies; // // // // // Odnalezienie najnowszego wpisu // com.CommandText = // "SELECT * FROM ENROLLMENT WHERE IdEnrollment = (SELECT MAX(IdEnrollment) FROM Enrollment WHERE IdStudy = @idStudies AND Semester = 1);"; // com.Parameters.AddWithValue("idStudies", idStudies); // var dr1 = com.ExecuteReader(); // int idEnrollment; // // Sprawdzenie czy wpis istnieje, jeżeli nie, jestem zobowiązany go utworzyć // if (!dr1.Read()) // { // dr1.Close(); // com.CommandText = "SELECT MAX(IdEnrollment) + 1 FROM Enrollment"; // idEnrollment = Convert.ToInt32(com.ExecuteScalar()); // Console.WriteLine(idEnrollment); // DateTime myDateTime = DateTime.Now; // string dateFormat = myDateTime.ToString("yyyy-MM-dd"); // Console.WriteLine(dateFormat); // Console.WriteLine(idStudies); // // com.CommandText = // // "INSERT INTO Enrollment (IdEnrollment, Semester, IdStudy, StartDate) VALUES ({idEnrollment},1,{idStudies}, '2000-12-12')"; // "INSERT INTO Enrollment (IdEnrollment, Semester, IdStudy, StartDate) " + // $"VALUES ({idEnrollment},1,{idStudies}, '{dateFormat}')"; // // // com.Parameters.AddWithValue("idEnrollment", idEnrollment); // // com.Parameters.AddWithValue("date", dateFormat); // // com.Parameters.AddWithValue("idStudies", idStudies); // com.ExecuteNonQuery(); // // enrollment.Semester = 1; // enrollment.IdEnrollment = idEnrollment; // enrollment.IdStudy = idStudies; // enrollment.StartDate = myDateTime; // // } // else // { // idEnrollment = (int) dr1["IdEnrollment"]; // enrollment.IdEnrollment = idEnrollment; // enrollment.Semester = (int) dr1["Semester"]; // enrollment.IdStudy = (int) dr1["IdStudy"]; // enrollment.StartDate = (DateTime) dr1["StartDate"]; // // } // dr1.Close(); // // // // // Sprawdzenie, czy student ma unikalne ID // com.CommandText = "SELECT * FROM Student WHERE IndexNumber = @index"; // com.Parameters.AddWithValue("index", request.IndexNumber); // var dr3 = com.ExecuteReader(); // if (dr3.Read()) // { // dr3.Close(); // transaction.Rollback(); // return BadRequest("Numer indeksu nie jest unikalny"); // } // // dr3.Close(); // // // // // com.CommandText = // "INSERT INTO Student (IndexNumber, FirstName, LastName, BirthDate, IdEnrollment) VALUES (@studentindex, @fname, @lname, @dob, @idEnrollment)"; // // // com.Parameters.AddWithValue("studentindex", request.IndexNumber); // com.Parameters.AddWithValue("fname", request.FirstName); // com.Parameters.AddWithValue("lname", request.LastName); // com.Parameters.AddWithValue("dob", request.BirthDate); // com.Parameters.AddWithValue("idEnrollment", idEnrollment); // // com.ExecuteNonQuery(); // // transaction.Commit(); // // } // catch (SqlException exc) // { // transaction.Rollback(); // Console.WriteLine("SQL ERROR and rollback"); // Console.WriteLine(exc); // // // } // // // // // // // // // // // } // } if (!ModelState.IsValid) { var d = ModelState; return(BadRequest("!!!")); } var response = _service.EnrollStudent(request); if (response.Status == 201) { return(CreatedAtAction(response.Message, response.enrollment)); } return(BadRequest(response.Message)); }