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