public List <PatientsByDOE_Result> getPatientsByDOE(DateTime _doe, string _location)
{
List <PatientsByDOE_Result> _patients = new List <PatientsByDOE_Result>();
DataAccess _dal = new DataAccess();
List <SqlParameter> param = new List <SqlParameter>();
param.Add(new SqlParameter("@DOE", _doe));
if (_location != "All")
{
//string[] _locations = _location.Split('_');
param.Add(new SqlParameter("@Location_ID", _location));
//param.Add(new SqlParameter("@City", _locations[0]));
}
DataTable _dt = _dal.getDataTable("nusp_GetPatientsByDOE", param);
foreach (DataRow _dr in _dt.Rows)
{
PatientsByDOE_Result _patient = new PatientsByDOE_Result();
_patient.PatientIEId = Convert.ToInt64(_dr["PatientIE_ID"]);
_patient.PatientFUId = Convert.ToInt64(_dr["PatientFU_ID"]);
_patient.FirstName = _dr["FirstName"].ToString();
_patient.LastName = _dr["LastName"].ToString();
_patient.DOE = Convert.ToDateTime(_dr["DOE"]);
_patient.DOA = Convert.IsDBNull(_dr["DOA"]) ? null : (DateTime?)Convert.ToDateTime(_dr["DOA"]);
_patient.ExamType = _dr["ExamType"].ToString();
_patient.Location = _dr["Location"].ToString();
_patient.State = _dr["State"].ToString();
_patient.City = _dr["City"].ToString();
_patient.Compensation = _dr["Compensation"].ToString();
_patients.Add(_patient);
}
return(_patients);
}
public List <PatientsByDOE_Result> getPatientByIE(int patientIE_ID)
{
List <PatientsByDOE_Result> _patients = new List <PatientsByDOE_Result>();
DataAccess _dal = new DataAccess();
List <SqlParameter> param = new List <SqlParameter>();
param.Add(new SqlParameter("@PatientIE_ID", patientIE_ID));
DataTable _dt = _dal.getDataTable("nusp_GetPatientDetailsByIE_ID", param);
foreach (DataRow _dr in _dt.Rows)
{
PatientsByDOE_Result _patient = new PatientsByDOE_Result();
_patient.PatientIEId = Convert.ToInt64(_dr["PatientIE_ID"]);
_patient.PatientFUId = Convert.ToInt64(_dr["PatientFU_ID"]);
_patient.FirstName = _dr["FirstName"].ToString();
_patient.LastName = _dr["LastName"].ToString();
_patient.DOE = _dr["DOE"] != null?Convert.ToDateTime(_dr["DOE"]) : DateTime.Now;
_patient.DOA = Convert.IsDBNull(_dr["DOA"]) ? null : (DateTime?)Convert.ToDateTime(_dr["DOA"]);
_patient.ExamType = _dr["ExamType"].ToString();
_patient.Location = _dr["Location"].ToString();
_patient.State = _dr["State"].ToString();
_patient.City = _dr["City"].ToString();
_patient.Compensation = _dr["Compensation"].ToString();
_patients.Add(_patient);
}
return(_patients);
}
