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); }