public async Task <IHttpActionResult> GetAdmissionTreatment(PatientTreatmentModel treatment)
{
var Treatments = await TreatmentService.GetAdmissionTreatment(treatment);
if (Treatments != null)
{
return(Ok(Treatments));
}
else
{
return(BadRequest("No Treatments Available!"));
}
}
}//end of add
//search treatment details of an admission
public static async Task <PatientTreatmentModel> GetAdmissionTreatment(PatientTreatmentModel Treatment)
{
PatientTreatmentModel ptnttreatment = new PatientTreatmentModel();
ptnttreatment.PtntTreatments = new List <TreatmentModel>();
using (SqlConnection dbConn = new SqlConnection(connectionString))
{
var query1 = "select Patient.[Name], Room.[Name] from In_Patient " +
" LEFT join Patient on In_Patient.Patient_ID = Patient.ID " +
" LEFT join Room on Room.ID = In_Patient.RoomID " +
" WHERE In_Patient.ID = " + Treatment.AdmissionID;
var query2 = "Select * from Treatment where AdmissionID=" + Treatment.AdmissionID;
SqlDataReader reader;
try
{
dbConn.Open();
SqlCommand cmd = new SqlCommand(query1, dbConn);
reader = await cmd.ExecuteReaderAsync();
if (reader.HasRows)
{
while (reader.Read())
{
//// TreatmentModel Treatmentitems = new TreatmentModel();
ptnttreatment.PatientName = reader.GetString(0);
ptnttreatment.RoomName = reader.GetString(1);
}
}
dbConn.Close();
dbConn.Open();
SqlCommand cmd1 = new SqlCommand(query2, dbConn);
reader = await cmd1.ExecuteReaderAsync();
if (reader.HasRows)
{
while (reader.Read())
{
TreatmentModel Treatmentitems = new TreatmentModel();
Treatmentitems.AdmissionID = reader.GetInt32(1);
Treatmentitems.PtntTreatment = reader.GetString(2);
Treatmentitems.Medicines = reader.GetString(3);
Treatmentitems.Reports = reader.GetString(4);
ptnttreatment.PtntTreatments.Add(Treatmentitems);
}
}
dbConn.Close();
}
catch (Exception ex)
{
reader = null;
Console.WriteLine(ex);
}
finally
{
dbConn.Close();
}
return(ptnttreatment);
}
}//end of search
