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
