public Eligible GetByID(int _eligibleId) { EligibleDAC _eligibleComponent = new EligibleDAC(); IDataReader reader = _eligibleComponent.GetByIDEligible(_eligibleId); Eligible _eligible = null; while (reader.Read()) { _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; } reader.Close(); return(_eligible); }