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"));
}