public static async Task <AdmissionTreatmentModel> SearchAdmission(AdmissionTreatmentModel admission) { AdmissionTreatmentModel patientAdmissionitem = new AdmissionTreatmentModel(); using (SqlConnection dbConn = new SqlConnection(connectionString)) { //var query = "SELECT Patient.[Name], Room.[Name], ISNULL(Treatment.[Treatment], '') AS Treatment , ISNULL(Treatment.Medicines, '') AS Medicines , " + // " ISNULL(Treatment.Reports, '') AS Reports from Patient join In_Patient on In_Patient.Patient_ID = Patient.ID " + // " LEFT join Room on Room.ID = In_Patient.RoomID LEFT join Treatment on Treatment.AdmissionID = In_Patient.ID" + // " WHERE In_Patient.ID= '" + admission.ID + "'"; var query = "select Patient.[Name], Room.[Name], In_Patient.AddmittedDate, Patient.ID, Room.Price, In_Patient.RoomID 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= '" + admission.AdmissionID + "'"; SqlDataReader reader; try { dbConn.Open(); SqlCommand cmd = new SqlCommand(query, dbConn); reader = await cmd.ExecuteReaderAsync(); if (reader.HasRows) { while (reader.Read()) { //admissionitem.TreatmentID = reader.GetInt32(0); patientAdmissionitem.PatientName = reader.GetString(0); patientAdmissionitem.RoomName = reader.GetString(1); patientAdmissionitem.admissiondate = reader.GetDateTime(2); patientAdmissionitem.PatientID = reader.GetInt32(3); patientAdmissionitem.RoomPrice = reader.GetDecimal(4); patientAdmissionitem.RoomID = reader.GetInt32(5); //Admission.Add(admissionitem); } } } catch (Exception ex) { reader = null; Console.WriteLine(ex); } finally { dbConn.Close(); } return(patientAdmissionitem); } }//end of search
public async Task <IHttpActionResult> SearchAdmission(AdmissionTreatmentModel Admission) { //CommonResponse validatedResponse = await AuthService.ValidateUserAndToken(); //if (!validatedResponse.IsError) //{ var admission = await TreatmentService.SearchAdmission(Admission); if (admission != null) { return(Ok(admission)); } else { return(BadRequest("Admission Number doesnt Exists!")); } //} //else //{ // return Unauthorized(); //} }//end of search