public IActionResult GetPerscription(int id)
{
using (SqlConnection con = new SqlConnection("Data Source = db-mssql; Initial Catalog=s18793; Integrated Security=True"))
using (SqlCommand com = new SqlCommand())
{
try
{
var list = new List <Prescriptions>();
var lista = new List <PrescriptionsMedicament>();
com.Connection = con;
com.Parameters.AddWithValue("IdPrescription", id);
com.CommandText = "Select * from Prescription where IdPrescription =@id";
con.Open();
SqlDataReader dr = com.ExecuteReader();
while (dr.Read())
{
var per = new Prescriptions();
per.IdPerscription = (int)dr["IdPrescription"];
per.Date = DateTime.Parse(dr["Date"].ToString());
per.DueTime = DateTime.Parse(dr["DueDate"].ToString());
per.IdPatient = (int)dr["IdPatient"];
per.IdDoctor = (int)dr["IdDoctor"];
list.Add(per);
}
com.ExecuteNonQuery();
com.CommandText = "Select * from Prescription_Medicament where IdPrescription= @id";
com.Parameters.AddWithValue("idPerc", id);
while (dr.Read())
{
var permed = new PrescriptionsMedicament();
var listaMed = new List <Medicament>();
permed.IdPerscription = (int)dr["IdPrescription"];;
permed.IdMedicament = (int)dr["IdMedicament"];
permed.Dose = (int)dr["Dose"];
permed.Details = (dr["Details"].ToString());
lista.Add(permed);
}
return(Ok(list + "\n" + lista));
}
catch (SqlException sql)
{
return(BadRequest("Nie prawidłowy parametr/nie podano parametru"));
}
}
}
public IActionResult GetPerscription(int id)
{
using (SqlConnection con = new SqlConnection("Data Source = db-mssql; Initial Catalog=s18830; Integrated Security=True"))
com.Connection = con;
using (SqlCommand com = new SqlCommand())
{
try
{
var list = new List<Prescriptions>();
var lista = new List<PrescriptionsMedicament>();
com.Parameters.AddWithValue("IdPrescription", id);
com.CommandText = "select Name Type,Date ,DueDate ,
Description ,Dose , IdPatient,IdDoctor from Prescription_Medicament
JOIN Prescription on Prescription.IdPrescription = Prescription_Medicament.IdPrescription
JOIN Medicament on Medicament.IdMedicament = Prescription_Medicament.IdMedicament where IdPrescription =@id";
con.Open();
SqlDataReader dr = com.ExecuteReader();
while (dr.Read()){
var recepta = new Prescriptions();
recepta.IdPerscription = (int)dr["IdPrescription"];
recepta.Date = DateTime.Parse(dr["Date"].ToString());
recepta.DueTime = DateTime.Parse(dr["DueDate"].ToString());
recepta.IdPatient = (int)dr["IdPatient"];
recepta.IdDoctor = (int)dr["IdDoctor"];
var permed = new PrescriptionsMedicament();
var listaMed = new List<Medicament>();
permed.IdPerscription = (int)dr["IdPrescription"]; ;
permed.IdMedicament = (int)dr["IdMedicament"];
listaMed.Dose = (int)dr["Dose"];
listaMed.Details = (dr["Details"].ToString());
lista.Add(permed);
list.Add(recepta);
}
return Ok(list + "\n" + lista);
}
catch (SqlException sql)
{
return BadRequest("Wysłano nieprawidłowe zapytanie");
}
}
}
