internal SqlDataAdapter buildVitalSignsRequest(string patientIcn)
{
string queryString = "SELECT * FROM App.Vitals where PatientICN = @patientIcn";
PatientQueryBuilder queryBuilder = new PatientQueryBuilder();
SqlDataAdapter adapter = queryBuilder.buildPatientSelectQuery(patientIcn, queryString);
return(adapter);
}
internal SqlDataAdapter buildChemHemRequest(string patientIcn, string fromDate, string toDate)
{
string queryString = "SELECT * FROM App.ChemLabs where PatientICN = @patientIcn " +
"AND LabChemCompleteDateTime >= @fromDate AND LabChemCompleteDateTime <= @toDate";
PatientQueryBuilder queryBuilder = new PatientQueryBuilder();
SqlDataAdapter adapter = queryBuilder.buildPatientSelectQuery(patientIcn, queryString);
SqlParameter startDate = new SqlParameter("@fromDate", System.Data.SqlDbType.Date);
startDate.Value = fromDate;
SqlParameter endDate = new SqlParameter("@toDate", System.Data.SqlDbType.Date);
endDate.Value = toDate;
adapter.SelectCommand.Parameters.Add(startDate);
adapter.SelectCommand.Parameters.Add(endDate);
return(adapter);
}
