public bool Insert(EligibilityDepartmentAction eligibilitydepartmentaction) { int autonumber = 0; EligibilityDepartmentActionDAC eligibilitydepartmentactionComponent = new EligibilityDepartmentActionDAC(); bool endedSuccessfuly = eligibilitydepartmentactionComponent.InsertNewEligibilityDepartmentAction(ref autonumber, eligibilitydepartmentaction.EligibilityDepartmentId, eligibilitydepartmentaction.EligibleId, eligibilitydepartmentaction.ConsultantSubmittingActionId, eligibilitydepartmentaction.ConsultantName, eligibilitydepartmentaction.Note, eligibilitydepartmentaction.EligibilityStatusId, eligibilitydepartmentaction.IsAdmitted, eligibilitydepartmentaction.AdmissionApointmentDate, eligibilitydepartmentaction.Ward, eligibilitydepartmentaction.IsOPDAppointment, eligibilitydepartmentaction.OPDAppointmentDate, eligibilitydepartmentaction.Clinic, eligibilitydepartmentaction.IsFurtherInvestigationDoneInReferringHospital, eligibilitydepartmentaction.IsPatientCantBeAccommodatedForBedUnavailability, eligibilitydepartmentaction.IsNothingAdditionalCanBeOfferedRightMedication, eligibilitydepartmentaction.IsNothingAdditionalCanBeOfferedIsTerminal, eligibilitydepartmentaction.IsMedicalReportIncomplete, eligibilitydepartmentaction.IsNotAvailableSpeciality, eligibilitydepartmentaction.IsOtherReason, eligibilitydepartmentaction.OtherReason, eligibilitydepartmentaction.DateCreated, eligibilitydepartmentaction.DateModified, eligibilitydepartmentaction.TransferToDepartmentId); if (endedSuccessfuly) { eligibilitydepartmentaction.EligibilityDepartmentActionId = autonumber; } return(endedSuccessfuly); }
public EligibilityDepartmentAction GetByDepartmentIDNew(int EligibilityDepartmentId, int EligibleId) { EligibilityDepartmentActionDAC _eligibilityDepartmentActionComponent = new EligibilityDepartmentActionDAC(); IDataReader reader = _eligibilityDepartmentActionComponent.GetByDepartmentIDEligibilityDepartmentActionnew(EligibilityDepartmentId, EligibleId); EligibilityDepartmentAction _eligibilityDepartmentAction = null; while (reader.Read()) { _eligibilityDepartmentAction = new EligibilityDepartmentAction(); if (reader["EligibilityDepartmentActionId"] != DBNull.Value) { _eligibilityDepartmentAction.EligibilityDepartmentActionId = Convert.ToInt32(reader["EligibilityDepartmentActionId"]); } if (reader["EligibilityDepartmentId"] != DBNull.Value) { _eligibilityDepartmentAction.EligibilityDepartmentId = Convert.ToInt32(reader["EligibilityDepartmentId"]); } if (reader["EligibleId"] != DBNull.Value) { _eligibilityDepartmentAction.EligibleId = Convert.ToInt32(reader["EligibleId"]); } if (reader["ConsultantSubmittingActionId"] != DBNull.Value) { _eligibilityDepartmentAction.ConsultantSubmittingActionId = Convert.ToInt32(reader["ConsultantSubmittingActionId"]); } if (reader["ConsultantName"] != DBNull.Value) { _eligibilityDepartmentAction.ConsultantName = Convert.ToString(reader["ConsultantName"]); } if (reader["Note"] != DBNull.Value) { _eligibilityDepartmentAction.Note = Convert.ToString(reader["Note"]); } if (reader["EligibilityStatusId"] != DBNull.Value) { _eligibilityDepartmentAction.EligibilityStatusId = Convert.ToInt32(reader["EligibilityStatusId"]); } if (reader["IsAdmitted"] != DBNull.Value) { _eligibilityDepartmentAction.IsAdmitted = Convert.ToBoolean(reader["IsAdmitted"]); } if (reader["AdmissionApointmentDate"] != DBNull.Value) { _eligibilityDepartmentAction.AdmissionApointmentDate = Convert.ToDateTime(reader["AdmissionApointmentDate"]); } if (reader["Ward"] != DBNull.Value) { _eligibilityDepartmentAction.Ward = Convert.ToString(reader["Ward"]); } if (reader["IsOPDAppointment"] != DBNull.Value) { _eligibilityDepartmentAction.IsOPDAppointment = Convert.ToBoolean(reader["IsOPDAppointment"]); } if (reader["OPDAppointmentDate"] != DBNull.Value) { _eligibilityDepartmentAction.OPDAppointmentDate = Convert.ToDateTime(reader["OPDAppointmentDate"]); } if (reader["Clinic"] != DBNull.Value) { _eligibilityDepartmentAction.Clinic = Convert.ToString(reader["Clinic"]); } if (reader["IsFurtherInvestigationDoneInReferringHospital"] != DBNull.Value) { _eligibilityDepartmentAction.IsFurtherInvestigationDoneInReferringHospital = Convert.ToBoolean(reader["IsFurtherInvestigationDoneInReferringHospital"]); } if (reader["IsPatientCantBeAccommodatedForBedUnavailability"] != DBNull.Value) { _eligibilityDepartmentAction.IsPatientCantBeAccommodatedForBedUnavailability = Convert.ToBoolean(reader["IsPatientCantBeAccommodatedForBedUnavailability"]); } if (reader["IsNothingAdditionalCanBeOfferedRightMedication"] != DBNull.Value) { _eligibilityDepartmentAction.IsNothingAdditionalCanBeOfferedRightMedication = Convert.ToBoolean(reader["IsNothingAdditionalCanBeOfferedRightMedication"]); } if (reader["IsNothingAdditionalCanBeOfferedIsTerminal"] != DBNull.Value) { _eligibilityDepartmentAction.IsNothingAdditionalCanBeOfferedIsTerminal = Convert.ToBoolean(reader["IsNothingAdditionalCanBeOfferedIsTerminal"]); } if (reader["IsMedicalReportIncomplete"] != DBNull.Value) { _eligibilityDepartmentAction.IsMedicalReportIncomplete = Convert.ToBoolean(reader["IsMedicalReportIncomplete"]); } if (reader["IsNotAvailableSpeciality"] != DBNull.Value) { _eligibilityDepartmentAction.IsNotAvailableSpeciality = Convert.ToBoolean(reader["IsNotAvailableSpeciality"]); } if (reader["IsOtherReason"] != DBNull.Value) { _eligibilityDepartmentAction.IsOtherReason = Convert.ToBoolean(reader["IsOtherReason"]); } if (reader["OtherReason"] != DBNull.Value) { _eligibilityDepartmentAction.OtherReason = Convert.ToString(reader["OtherReason"]); } if (reader["DateCreated"] != DBNull.Value) { _eligibilityDepartmentAction.DateCreated = Convert.ToDateTime(reader["DateCreated"]); } if (reader["DateModified"] != DBNull.Value) { _eligibilityDepartmentAction.DateModified = Convert.ToDateTime(reader["DateModified"]); } if (reader["TransferToDepartmentId"] != DBNull.Value) { _eligibilityDepartmentAction.TransferToDepartmentId = Convert.ToInt32(reader["TransferToDepartmentId"]); } _eligibilityDepartmentAction.NewRecord = false; } reader.Close(); return(_eligibilityDepartmentAction); }
public bool Update(EligibilityDepartmentAction eligibilitydepartmentaction, int old_eligibilityDepartmentActionId) { EligibilityDepartmentActionDAC eligibilitydepartmentactionComponent = new EligibilityDepartmentActionDAC(); return(eligibilitydepartmentactionComponent.UpdateEligibilityDepartmentAction(eligibilitydepartmentaction.EligibilityDepartmentId, eligibilitydepartmentaction.EligibleId, eligibilitydepartmentaction.ConsultantSubmittingActionId, eligibilitydepartmentaction.ConsultantName, eligibilitydepartmentaction.Note, eligibilitydepartmentaction.EligibilityStatusId, eligibilitydepartmentaction.IsAdmitted, eligibilitydepartmentaction.AdmissionApointmentDate, eligibilitydepartmentaction.Ward, eligibilitydepartmentaction.IsOPDAppointment, eligibilitydepartmentaction.OPDAppointmentDate, eligibilitydepartmentaction.Clinic, eligibilitydepartmentaction.IsFurtherInvestigationDoneInReferringHospital, eligibilitydepartmentaction.IsPatientCantBeAccommodatedForBedUnavailability, eligibilitydepartmentaction.IsNothingAdditionalCanBeOfferedRightMedication, eligibilitydepartmentaction.IsNothingAdditionalCanBeOfferedIsTerminal, eligibilitydepartmentaction.IsMedicalReportIncomplete, eligibilitydepartmentaction.IsNotAvailableSpeciality, eligibilitydepartmentaction.IsOtherReason, eligibilitydepartmentaction.OtherReason, eligibilitydepartmentaction.DateCreated, eligibilitydepartmentaction.DateModified, eligibilitydepartmentaction.TransferToDepartmentId, old_eligibilityDepartmentActionId)); }