public DataSet InsertUpdateEBClaimDetails_Portal(clsEBClaimDetails objEBClaimDetails) { dataAccess = new DataAccess(); //System.Data.SqlClient.SqlParameter parameter = new System.Data.SqlClient.SqlParameter(); //parameter.ParameterName = "@DiagnosisDescriptions"; //parameter.SqlDbType = System.Data.SqlDbType.Structured; //parameter.TypeName = "EB_DiagnosisDescriptionType"; //parameter.Value = objEBClaimDetails.DiagnosisDescriptions; Object[] parameters = new Object[] { objEBClaimDetails.CaseRefNo, objEBClaimDetails.MemberCode, objEBClaimDetails.ClaimRefNo, objEBClaimDetails.MemberRegRefNo, objEBClaimDetails.ClaimNo, objEBClaimDetails.ClaimTypeCode, objEBClaimDetails.ClaimTypeDesc, objEBClaimDetails.IssueDate, objEBClaimDetails.CoverNoteNo, objEBClaimDetails.SubClassID, objEBClaimDetails.SubClass, objEBClaimDetails.PolicyNo, objEBClaimDetails.POIFromDate, objEBClaimDetails.POIToDate, objEBClaimDetails.NotifyByCode, objEBClaimDetails.NotifyBy, objEBClaimDetails.NotifyDate, objEBClaimDetails.LocationCode, objEBClaimDetails.Location, objEBClaimDetails.ClientCode, objEBClaimDetails.ClientName, objEBClaimDetails.ClientTeam, objEBClaimDetails.ClientFirstName, objEBClaimDetails.ClientLastName, objEBClaimDetails.ClientEmail, objEBClaimDetails.ClientDirectLine1, objEBClaimDetails.ClientDirectLine2, objEBClaimDetails.ClientMobile1, objEBClaimDetails.ClientMobile2, objEBClaimDetails.ClientFax1, objEBClaimDetails.ClientFax2, objEBClaimDetails.UwriterCode, objEBClaimDetails.UwriterName, objEBClaimDetails.UwClaimNo, objEBClaimDetails.UwriterTeam, objEBClaimDetails.UwriterFirstName, objEBClaimDetails.UwriterLastName, objEBClaimDetails.UwriterEmail, objEBClaimDetails.UwriterDirectLine1, objEBClaimDetails.UwriterDirectLine2, objEBClaimDetails.UwriterMobile1, objEBClaimDetails.UwriterMobile2, objEBClaimDetails.UwriterFax1, objEBClaimDetails.UwriterFax2, objEBClaimDetails.ClaimHandlerCode, objEBClaimDetails.ClaimHandlerDescription, objEBClaimDetails.SurveyorCode, objEBClaimDetails.SurveyorDescription, objEBClaimDetails.AccountHandlerCode, objEBClaimDetails.AccountHandlerDescription, objEBClaimDetails.LossAdjusterCode, objEBClaimDetails.LossAdjusterDescription, objEBClaimDetails.HealthCareCode, objEBClaimDetails.HealthCareDescription, objEBClaimDetails.SolicitorCode, objEBClaimDetails.SolicitorDescription, objEBClaimDetails.InvestigatorCode, objEBClaimDetails.InvestigatoreDescription, objEBClaimDetails.UserID, objEBClaimDetails.IncurredAdmDate, objEBClaimDetails.InsurerClaimNo, objEBClaimDetails.LOGIssued, objEBClaimDetails.LOGRefNo, objEBClaimDetails.DischargeDate, objEBClaimDetails.FirstDocReceived , objEBClaimDetails.ServiceProvider, objEBClaimDetails.FinalDocReceived, objEBClaimDetails.Others, objEBClaimDetails.SubmissiontoInsurer , objEBClaimDetails.ServiceProviderType, objEBClaimDetails.AdmissionType, objEBClaimDetails.HospitalName, objEBClaimDetails.HospitalType, objEBClaimDetails.DiseaseType, objEBClaimDetails.MCDays, objEBClaimDetails.RejectedDate, objEBClaimDetails.RejectedReason, objEBClaimDetails.RejectedReturnDocDate, objEBClaimDetails.WithdrawDate, objEBClaimDetails.WithdrawReason, objEBClaimDetails.WithdrawReturnDocDate, objEBClaimDetails.VoidDate, objEBClaimDetails.VoidReason, objEBClaimDetails.ClaimId, objEBClaimDetails.PreHospitalizationDays, objEBClaimDetails.PostHospitalizationDays, objEBClaimDetails.PerDisabilitydays, objEBClaimDetails.AmountIncurred }; return(dataAccess.LoadDataSet(parameters, "P_EB_ClaimInsertUpdate", "EB_ClaimInsertUpdate")); }
public DataSet GetEBClaimDetails(clsEBClaimDetails objEBClaimDetails) { dataAccess = new DataAccess(); Object[] parameters = new Object[3] { objEBClaimDetails.CaseRefNo, objEBClaimDetails.MemberCode, objEBClaimDetails.ClaimRefNo }; return(dataAccess.LoadDataSet(parameters, "P_EB_ClaimDetails", "EB_ClaimDetails")); }
public DataSet GetEBMemberDetailsAudit(clsEBClaimDetails objEBClaimDetails) { dataAccess = new DataAccess(); Object[] parameters = new Object[2] { objEBClaimDetails.CaseRefNo, objEBClaimDetails.MemberCode }; return(dataAccess.LoadDataSet(parameters, "P_EB_MemberDetailsAudit", "EB_MemberDetails")); }
public DataSet ValidIhPolicy(clsEBClaimDetails objEBClaimDetails) { dataAccess = new DataAccess(); Object[] parameters = new Object[1] { objEBClaimDetails.CorporatePolicyNo }; return(dataAccess.LoadDataSet(parameters, "Pol_ValidIHCorporatePolicy", "ValidIHPolicy")); }
public DataSet GetEBClaimPlanDetails(clsEBClaimDetails objEBClaimDetails) { dataAccess = new DataAccess(); Object[] parameters = new Object[2] { objEBClaimDetails.CoverNoteNo, objEBClaimDetails.PlanName }; return(dataAccess.LoadDataSet(parameters, "P_EBClaim_PlanDetail", "EB_ClaimMemberDetails")); }
public DataSet GetEBClaimEntitleAmount(clsEBClaimDetails objEBClaimDetails) { dataAccess = new DataAccess(); Object[] parameters = new Object[4] { objEBClaimDetails.CaseRefNo, objEBClaimDetails.MemberCode, objEBClaimDetails.RefNo, objEBClaimDetails.Benefitlimit }; return(dataAccess.LoadDataSet(parameters, "[P_EBClaimEntitleAmount]", "EBClaimEntitleAmount")); }
public DataSet GetEBClaimMemberList(clsEBClaimDetails objEBClaimDetails) { dataAccess = new DataAccess(); Object[] parameters = new Object[11] { objEBClaimDetails.MemberCode, objEBClaimDetails.MemberName, objEBClaimDetails.PassportNo, objEBClaimDetails.ClientCode, objEBClaimDetails.ClientName, objEBClaimDetails.UwriterCode, objEBClaimDetails.UwriterName, objEBClaimDetails.CoverNoteNo, objEBClaimDetails.PolicyNo, objEBClaimDetails.SubClass, objEBClaimDetails.MemberType }; return(dataAccess.LoadDataSet(parameters, "P_EB_ClaimMemberList", "EB_ClaimMemberList")); }
public DataSet GetEBLetterClaimOutstandingList(clsEBClaimDetails objEBClaimDetails, string SPRClaimStatus) { dataAccess = new DataAccess(); Object[] parameters = new Object[21] { objEBClaimDetails.ClaimNo, objEBClaimDetails.MemberCode, objEBClaimDetails.MemberName, objEBClaimDetails.PassportNo, objEBClaimDetails.ClientCode, objEBClaimDetails.ClientName, objEBClaimDetails.UwriterCode, objEBClaimDetails.UwriterName, objEBClaimDetails.CoverNoteNo, objEBClaimDetails.PolicyNo, objEBClaimDetails.SubClass, objEBClaimDetails.ClaimTypeDesc, objEBClaimDetails.AdmissionDate, objEBClaimDetails.UserID, objEBClaimDetails.ClaimStatus, objEBClaimDetails.IssueFromDate, objEBClaimDetails.IssueToDate, objEBClaimDetails.POIFromDate, objEBClaimDetails.POIToDate, objEBClaimDetails.CertificateNo, SPRClaimStatus }; //Object[] parameters = new Object[20] { objEBClaimDetails.ClaimNo, objEBClaimDetails.MemberCode, objEBClaimDetails.MemberName, objEBClaimDetails.PassportNo, objEBClaimDetails.ClientCode, objEBClaimDetails.ClientName, objEBClaimDetails.UwriterCode, objEBClaimDetails.UwriterName, objEBClaimDetails.CoverNoteNo, objEBClaimDetails.PolicyNo, objEBClaimDetails.SubClass, objEBClaimDetails.ClaimTypeDesc, objEBClaimDetails.AdmissionDate, objEBClaimDetails.UserID, objEBClaimDetails.ClaimStatus, objEBClaimDetails.IssueFromDate, objEBClaimDetails.IssueToDate, objEBClaimDetails.POIFromDate, objEBClaimDetails.POIToDate, objEBClaimDetails.CertificateNo }; return(dataAccess.LoadDataSet(parameters, "P_EBLetter_ClaimOutstandingList", "EB_ClaimOutstandingList")); }
public DataSet InsertUpdateEBClaimDetails(clsEBClaimDetails objEBClaimDetails) { dataAccess = new DataAccess(); Object[] parameters = new Object[59] { objEBClaimDetails.CaseRefNo, objEBClaimDetails.MemberCode, objEBClaimDetails.ClaimRefNo, objEBClaimDetails.MemberRegRefNo, objEBClaimDetails.ClaimNo, objEBClaimDetails.ClaimTypeCode, objEBClaimDetails.ClaimTypeDesc, objEBClaimDetails.IssueDate, objEBClaimDetails.CoverNoteNo, objEBClaimDetails.SubClassID, objEBClaimDetails.SubClass, objEBClaimDetails.PolicyNo, objEBClaimDetails.POIFromDate, objEBClaimDetails.POIToDate, objEBClaimDetails.NotifyByCode, objEBClaimDetails.NotifyBy, objEBClaimDetails.NotifyDate, objEBClaimDetails.LocationCode, objEBClaimDetails.Location, objEBClaimDetails.ClientCode, objEBClaimDetails.ClientName, objEBClaimDetails.ClientTeam, objEBClaimDetails.ClientFirstName, objEBClaimDetails.ClientLastName, objEBClaimDetails.ClientEmail, objEBClaimDetails.ClientDirectLine1, objEBClaimDetails.ClientDirectLine2, objEBClaimDetails.ClientMobile1, objEBClaimDetails.ClientMobile2, objEBClaimDetails.ClientFax1, objEBClaimDetails.ClientFax2, objEBClaimDetails.UwriterCode, objEBClaimDetails.UwriterName, objEBClaimDetails.UwClaimNo, objEBClaimDetails.UwriterTeam, objEBClaimDetails.UwriterFirstName, objEBClaimDetails.UwriterLastName, objEBClaimDetails.UwriterEmail, objEBClaimDetails.UwriterDirectLine1, objEBClaimDetails.UwriterDirectLine2, objEBClaimDetails.UwriterMobile1, objEBClaimDetails.UwriterMobile2, objEBClaimDetails.UwriterFax1, objEBClaimDetails.UwriterFax2, objEBClaimDetails.ClaimHandlerCode, objEBClaimDetails.ClaimHandlerDescription, objEBClaimDetails.SurveyorCode, objEBClaimDetails.SurveyorDescription, objEBClaimDetails.AccountHandlerCode, objEBClaimDetails.AccountHandlerDescription, objEBClaimDetails.LossAdjusterCode, objEBClaimDetails.LossAdjusterDescription, objEBClaimDetails.HealthCareCode, objEBClaimDetails.HealthCareDescription, objEBClaimDetails.SolicitorCode, objEBClaimDetails.SolicitorDescription, objEBClaimDetails.InvestigatorCode, objEBClaimDetails.InvestigatoreDescription, objEBClaimDetails.UserID }; return(dataAccess.LoadDataSet(parameters, "P_EB_ClaimInsertUpdate", "EB_ClaimInsertUpdate")); }
public DataSet GetClaimPendingDocumentsSelect(clsEBClaimDetails objEBClaimDetails, string claimType) { dataAccess = new DataAccess(); Object[] parameters = new Object[] { objEBClaimDetails.ClaimNo, objEBClaimDetails.ClaimId, claimType }; return(dataAccess.LoadDataSet(parameters, "P_ClaimPendingDocumentsSelect", "ClaimPendingDocumentsSelect")); }
public DataSet GetEBClaimDiagnosisDetailsSaveSelect(clsEBClaimDetails objEBClaimDetails) { dataAccess = new DataAccess(); Object[] parameters = new Object[] { objEBClaimDetails.ClaimId, objEBClaimDetails.ClaimNo }; return(dataAccess.LoadDataSet(parameters, "P_EB_ClaimDiagnosisDetailsSaveSelect", "ClaimDiagnosisDetailsSaveSelect")); }
public DataSet GetEBClaimClaimPaymentDetailsSelect(clsEBClaimDetails objEBClaimDetails) { dataAccess = new DataAccess(); Object[] parameters = new Object[] { objEBClaimDetails.ClaimId, objEBClaimDetails.ClaimNo, null }; return(dataAccess.LoadDataSet(parameters, "P_EB_ClaimPaymentDetailsSelect", "ClaimPaymentDetailsSelect")); }
public DataSet GetMemberClaimDiagnosisDetails(clsEBClaimDetails objEBClaimDetails) { dataAccess = new DataAccess(); Object[] parameters = new Object[] { objEBClaimDetails.MemberCode }; return(dataAccess.LoadDataSet(parameters, "P_EB_ClaimDiagnosisDetailsSelect", "MemberClaimDiagnosisDetails")); }