public IActionResult GetPrescriptions(int id) { using (SqlConnection con = new SqlConnection(ConString)) using (SqlCommand com = new SqlCommand()) { com.Connection = con; com.CommandText = "select * from dbo.Medicament, dbo.Prescription_Medicament, dbo.Prescription where dbo.Medicament.IdMedicament = dbo.Prescription_Medicament.IdMedicament and dbo.Prescription_Medicament.IdPrescription = dbo.Prescription.IdPrescription and dbo.Prescription.IdPrescription = @id"; com.Parameters.AddWithValue("id", id); var request = new PrescriptionRequest(); con.Open(); var response = new PrescriptionResponse(); SqlDataReader dr = com.ExecuteReader(); List<String> lista = new List<string>(); while (dr.Read()) { response.IdDoctor = (int)dr["IdDoctor"]; response.Date = (DateTime)dr["Date"]; response.DueDate = (DateTime)dr["DueDate"]; response.IdPatient = (int)dr["IdPatient"]; response.IdPrescription = (int)dr["IdPrescription"]; lista.Add((string)dr["Name"]); } response.Leki = lista; return Ok(response); } return BadRequest("XD"); }
public async Task <PrescriptionResponse> Create(PrescriptionRequest prescriptionRequest) { var response = new PrescriptionResponse(); try { TTAC tTAC = new TTAC(_serviceProvider); Prescription prescription = new Prescription(); prescriptionRequest.CopyPropertiesTo(prescription); await _PrescriptionRepository.Add(prescription); TTACPrescriptionRequest tTACPrescriptionRequest = new TTACPrescriptionRequest(); TTACPrescriptionResponse tTACPrescriptionResponse = new TTACPrescriptionResponse(); prescriptionRequest.CopyPropertiesTo(tTACPrescriptionRequest); tTACPrescriptionRequest.Username = Constants.TTAC_UserName; tTACPrescriptionRequest.Password = Constants.TTAC_Password; tTACPrescriptionResponse = await tTAC.CallPrescriptionApi(tTACPrescriptionRequest); response.ErrorCode = tTACPrescriptionResponse.ErrorCode; response.ErrorMessage = tTACPrescriptionResponse.ErrorMessage; response.PrescriptionId = tTACPrescriptionResponse.PrescriptionId; prescription.OutErrorCode = tTACPrescriptionResponse.ErrorCode; prescription.OutErrorMessage = tTACPrescriptionResponse.ErrorMessage; prescription.OutPrescriptionId = tTACPrescriptionResponse.PrescriptionId; await _PrescriptionRepository.Update(prescription); response.HasError = false; return(response); } catch (Exception e) { _logService.LogText("PrescriptionInternalError" + e.Message.ToString()); throw new Exception(e.Message); } }
public IActionResult addPresctription(PrescriptionRequest request) { try { using (SqlConnection con = new SqlConnection("Data Source = db-mssql; Initial Catalog=s18793; Integrated Security=True")) using (SqlCommand com = new SqlCommand()) { com.Connection = con; con.Open(); com.CommandText = "Insert Into Prescription (Date, DueDate, IdPatient, IdDoctor) Values (@data, @ddata, @patient, @doctor)"; //Id Autonumerowane także nie dodaje com.Parameters.AddWithValue("data", request.Date); com.Parameters.AddWithValue("ddata", request.DueTime); com.Parameters.AddWithValue("patient", request.IdPatient); com.Parameters.AddWithValue("doctor", request.IdDoctor); if (DateTime.Compare(request.DueTime, request.Date) < 0) { return(BadRequest("Data ważności/format jest błędna/y")); } com.ExecuteNonQuery(); return(Ok()); } }catch (SqlException ex) { return(BadRequest("Brak danych lub dane nie poprawnego typu")); } }
public IActionResult AddPrescription(PrescriptionRequest prescription) { var res = _dbService.AddPrescription(prescription); if (res == null) { return(BadRequest()); } return(Created("", res)); }
public IActionResult AddPrescription(PrescriptionRequest request) { if (DateTime.Compare(request.DueDate, request.Date) < 0) { return(BadRequest("Invalid due date")); } _context.AddPrescription(request); return(Ok()); }
public IActionResult GetPrescription(int IdPrescription) { using (SqlConnection connect = new SqlConnection(ConString)) using (SqlCommand command = new SqlCommand()) { command.Connection = connect; command.CommandText = "select IdPrescription, Date, DueDate, IdPatient, IdDoctor from Prescription where IdPrescription=@IdPrescription"; command.Parameters.AddWithValue("IdPrescription", IdPrescription); var request = new PrescriptionRequest(); connect.Open(); } return(BadRequest("Error")); }
public async Task <PrescriptionRequest> GetPrescriptionById(int Id_Prescription) { var leki = new List <Medicament>(); using (var client = new SqlConnection(_connection)) using (var command = new SqlCommand()) { command.Connection = client; command.CommandText = @"SELECT * FROM Medicament m INNER JOIN Prescription_medicament pm ON pm.IdMedicament = m.IdMedicament WHERE pm.IdPrescription = @IdPres"; command.Parameters.AddWithValue("IdPres", Id_Prescription); client.Open(); var dataReader = await command.ExecuteReaderAsync(); while (await dataReader.ReadAsync()) { var medicament = new Medicament(); medicament.IdMedicament = int.Parse(dataReader["IdMedicament"].ToString()); medicament.Name = dataReader["Name"].ToString(); medicament.Description = dataReader["Description"].ToString(); medicament.Type = dataReader["Type"].ToString(); leki.Add(medicament); } client.Close(); } using (var client = new SqlConnection(_connection)) using (var command = new SqlCommand()) { command.Connection = client; command.CommandText = "SELECT 1 FROM Prescription WHERE IdPrescription = @IdPres"; command.Parameters.AddWithValue("IdPres", Id_Prescription); client.Open(); var dr = await command.ExecuteReaderAsync(); while (await dr.ReadAsync()) { var PRequest = new PrescriptionRequest(); PRequest.IdPrescription = int.Parse(dr["IdPrescription"].ToString()); PRequest.Date = DateTime.Parse(dr["Date"].ToString()); PRequest.DueDate = DateTime.Parse(dr["DueDate"].ToString()); PRequest.Leki = leki; return(PRequest); } } return(null); }
public IActionResult addPres(PrescriptionRequest prescrptionRequest) { using (SqlConnection client = new SqlConnection("Data Source=db-mssql;Initial Catalog=s18840;Integrated Security=True")) using (var com = new SqlCommand()) { com.Connection = client; client.Open(); com.CommandText = "Insert Into Prescription(Date,DueDate,IdPatient,IdDoctor) values (@date, @duedate, @patient, @doctor)"; } }
public Prescription AddPrescription(PrescriptionRequest request) { var prescr = new Prescription() { Date = request.Date, DueDate = request.DueDate, IdDoctor = request.IdDoctor, IdPatient = request.IdPatient, IdPrescription = 20 }; //_context.Prescriptions.InsertOnSubmit(prescr); using (var con = new SqlConnection("Data Source=db-mssql;Initial Catalog=s17060;Integrated Security=True;MultipleActiveResultSets=true")) using (var com = new SqlCommand()) { com.Connection = con; con.Open(); var transaction = con.BeginTransaction(); com.Transaction = transaction; try { com.CommandText = "INSERT INTO Prescription(IdPrescription, Date, DueDate, IdPatient, IdDoctor) VALUES(@idprescr, @date, @duedate, @idpatient, @iddoctor)"; com.Parameters.AddWithValue("idprescr", 20); com.Parameters.AddWithValue("date", prescr.Date); com.Parameters.AddWithValue("duedate", prescr.DueDate); com.Parameters.AddWithValue("idpatient", prescr.IdPatient); com.Parameters.AddWithValue("iddoctor", prescr.IdDoctor); com.ExecuteNonQuery(); transaction.Commit(); } catch (SqlException e) { transaction.Rollback(); } finally { con.Close(); } } return(prescr); }
public PrescriptionRequest AddPrescription(PrescriptionRequest request) { using (SqlConnection con = new SqlConnection(connection)) using (SqlCommand com = new SqlCommand()) { com.Connection = con; con.Open(); SqlTransaction transaction = con.BeginTransaction(); com.Transaction = transaction; com.CommandText = "Insert Into Prescription (Date, DueDate, IdPatient, IdDoctor) Values (@date, @dueDate, @IdPatient, @IdDoctor)"; com.Parameters.AddWithValue("Date", request.date); com.Parameters.AddWithValue("DueDate", request.dueDate); com.Parameters.AddWithValue("IdPatient", request.IdPatient); com.Parameters.AddWithValue("IdDoctor", request.IdDoctor); com.ExecuteNonQuery(); transaction.Commit(); } return(request); }
public async Task <PrescriptionResponse> Create([FromBody] PrescriptionRequest prescriptionRequest) { return(await _prescriptionService.Create(prescriptionRequest)); }