public List <Eligible> GetAllPendingByDepartmentAndStatus(int DepartmentId)
{
EligibleDAC _eligibleComponent = new EligibleDAC();
string where = String.Format("CurrentTransferredToDepartmentId = {0} AND CurrentEligibilityStatusId NOT IN(1,4,5)", DepartmentId);
IDataReader reader = _eligibleComponent.GetAllEligible(where).CreateDataReader();
List <Eligible> _eligibleList = new List <Eligible>();
while (reader.Read())
{
if (_eligibleList == null)
{
_eligibleList = new List <Eligible>();
}
Eligible _eligible = new Eligible();
if (reader["EligibleId"] != DBNull.Value)
{
_eligible.EligibleId = Convert.ToInt32(reader["EligibleId"]);
}
if (reader["PatientId"] != DBNull.Value)
{
_eligible.PatientId = Convert.ToString(reader["PatientId"]);
}
if (reader["PatientName"] != DBNull.Value)
{
_eligible.PatientName = Convert.ToString(reader["PatientName"]);
}
if (reader["NationalityId"] != DBNull.Value)
{
_eligible.NationalityId = Convert.ToString(reader["NationalityId"]);
}
if (reader["Age"] != DBNull.Value)
{
_eligible.Age = Convert.ToInt32(reader["Age"]);
}
if (reader["Mobile"] != DBNull.Value)
{
_eligible.Mobile = Convert.ToString(reader["Mobile"]);
}
if (reader["Fax"] != DBNull.Value)
{
_eligible.Fax = Convert.ToString(reader["Fax"]);
}
if (reader["Email"] != DBNull.Value)
{
_eligible.Email = Convert.ToString(reader["Email"]);
}
if (reader["TransferredFrom"] != DBNull.Value)
{
_eligible.TransferredFrom = Convert.ToString(reader["TransferredFrom"]);
}
if (reader["CurrentTransferredToDepartmentId"] != DBNull.Value)
{
_eligible.CurrentTransferredToDepartmentId = Convert.ToInt32(reader["CurrentTransferredToDepartmentId"]);
}
if (reader["CurrentEligibilityStatusId"] != DBNull.Value)
{
_eligible.CurrentEligibilityStatusId = Convert.ToInt32(reader["CurrentEligibilityStatusId"]);
}
if (reader["IsAdmitted"] != DBNull.Value)
{
_eligible.IsAdmitted = Convert.ToBoolean(reader["IsAdmitted"]);
}
if (reader["AdmissionApointmentDate"] != DBNull.Value)
{
_eligible.AdmissionApointmentDate = Convert.ToDateTime(reader["AdmissionApointmentDate"]);
}
if (reader["Ward"] != DBNull.Value)
{
_eligible.Ward = Convert.ToString(reader["Ward"]);
}
if (reader["IsOPDAppointment"] != DBNull.Value)
{
_eligible.IsOPDAppointment = Convert.ToBoolean(reader["IsOPDAppointment"]);
}
if (reader["OPDAppointmentDate"] != DBNull.Value)
{
_eligible.OPDAppointmentDate = Convert.ToDateTime(reader["OPDAppointmentDate"]);
}
if (reader["HomePhone"] != DBNull.Value)
{
_eligible.HomePhone = Convert.ToString(reader["HomePhone"]);
}
if (reader["Clinic"] != DBNull.Value)
{
_eligible.Clinic = Convert.ToString(reader["Clinic"]);
}
if (reader["IsFurtherInvestigationDoneInReferringHospital"] != DBNull.Value)
{
_eligible.IsFurtherInvestigationDoneInReferringHospital = Convert.ToBoolean(reader["IsFurtherInvestigationDoneInReferringHospital"]);
}
if (reader["IsPatientCantBeAccommodatedForBedUnavailability"] != DBNull.Value)
{
_eligible.IsPatientCantBeAccommodatedForBedUnavailability = Convert.ToBoolean(reader["IsPatientCantBeAccommodatedForBedUnavailability"]);
}
if (reader["IsNothingAdditionalCanBeOfferedRightMedication"] != DBNull.Value)
{
_eligible.IsNothingAdditionalCanBeOfferedRightMedication = Convert.ToBoolean(reader["IsNothingAdditionalCanBeOfferedRightMedication"]);
}
if (reader["IsNothingAdditionalCanBeOfferedIsTerminal"] != DBNull.Value)
{
_eligible.IsNothingAdditionalCanBeOfferedIsTerminal = Convert.ToBoolean(reader["IsNothingAdditionalCanBeOfferedIsTerminal"]);
}
if (reader["IsMedicalReportIncomplete"] != DBNull.Value)
{
_eligible.IsMedicalReportIncomplete = Convert.ToBoolean(reader["IsMedicalReportIncomplete"]);
}
if (reader["IsNotAvailableSpeciality"] != DBNull.Value)
{
_eligible.IsNotAvailableSpeciality = Convert.ToBoolean(reader["IsNotAvailableSpeciality"]);
}
if (reader["IsOtherReason"] != DBNull.Value)
{
_eligible.IsOtherReason = Convert.ToBoolean(reader["IsOtherReason"]);
}
if (reader["OtherReason"] != DBNull.Value)
{
_eligible.OtherReason = Convert.ToString(reader["OtherReason"]);
}
if (reader["ConsultantName"] != DBNull.Value)
{
_eligible.ConsultantName = Convert.ToString(reader["ConsultantName"]);
}
if (reader["ConsultantID"] != DBNull.Value)
{
_eligible.ConsultantID = Convert.ToInt32(reader["ConsultantID"]);
}
if (reader["DivisionID"] != DBNull.Value)
{
_eligible.DivisionID = Convert.ToInt32(reader["DivisionID"]);
}
_eligible.NewRecord = false;
_eligibleList.Add(_eligible);
}
reader.Close();
return(_eligibleList);
}
