public IActionResult enrollPrescription(EnrollPrescriptionRequest request) { using (var client = new SqlConnection(databaseURL)) using (var com = new SqlCommand()) { com.Connection = client; client.Open(); com.Transaction = client.BeginTransaction(); SqlDataReader db; try { if (request.DueDate < request.Date) { return(new BadRequestResult()); } com.CommandText = "SELECT MAX(IdPrescription) FROM Prescription"; db = com.ExecuteReader(); db.Read(); int maxId = Convert.ToInt32(db[0].ToString()) + 1; db.Close(); Console.WriteLine(request.Date); com.CommandText = "INSERT INTO Prescription values (@date,@dueDate,@idPat,@idDoc)"; com.Parameters.AddWithValue("date", request.Date); com.Parameters.AddWithValue("dueDate", request.DueDate); com.Parameters.AddWithValue("idPat", request.IdPatient); com.Parameters.AddWithValue("idDoc", request.IdDoctor); com.ExecuteNonQuery(); return(new OkObjectResult(new PrescriptionEnrollResponse() { IdPrescription = maxId, Date = request.Date, DueDate = request.DueDate, IdPatient = request.IdPatient, IdDoctor = request.IdDoctor })); } catch (SqlException e) { com.Transaction.Rollback(); return(new BadRequestResult()); } } }
public IActionResult enrollPrescription(EnrollPrescriptionRequest request) { return(_service.enrollPrescription(request)); }