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