public Prescription InputNewReceipt(ReceipeRequest request)
{
using (var con = new SqlConnection("Data Source=db-mssql;Initial Catalog=s18923;Integrated Security=True"))
using (var com = new SqlCommand())
{
com.Connection = con;
con.Open();
DateTime data1 = DateTime.ParseExact(request.Date, "d", CultureInfo.InvariantCulture);
DateTime data2 = DateTime.ParseExact(request.DueDate, "d", CultureInfo.InvariantCulture);
com.CommandText = "Insert into Prescription (Date, DueDate, IdPatient, IdDoctor)" +
"values ( @Date, @DueDate, @IdPatient, @IdDoctor); Select Scope_Identity()";
com.Parameters.AddWithValue("Date", data1);
com.Parameters.AddWithValue("DueDate", data2);
com.Parameters.AddWithValue("IdPatient", request.IdPatient);
com.Parameters.AddWithValue("IdDoctor", request.IdDoctor);
int id = Convert.ToInt32(com.ExecuteScalar());
var response = new Prescription
{
IdPrescription = id,
Date = data1,
DueDate = data2,
IdPatient = request.IdPatient,
IdDoctor = request.IdDoctor
};
return(response);
}
}
public IActionResult Receipt(ReceipeRequest request)
{
DateTime date = DateTime.ParseExact(request.Date, "d", CultureInfo.InvariantCulture);
DateTime dueDate = DateTime.ParseExact(request.DueDate, "d", CultureInfo.InvariantCulture);
if (date < dueDate)
{
return(BadRequest("DueDate nie jest starsza niż Date! "));
}
var result = service.InputNewReceipt(request);
return(Ok(result));
}
