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