public DataSet InsertUpdateECClaimsDetails(clsECClaimDetails objECClaimDetails)
{
dataAccess = new DataAccess();
Object[] parameters = new Object[] {
objECClaimDetails.CaseRefNo, objECClaimDetails.ClaimRefNo, objECClaimDetails.ClaimNo, objECClaimDetails.CoverNoteNo, objECClaimDetails.UnderwriterCode, objECClaimDetails.UnderwriterName, objECClaimDetails.UWShare,
objECClaimDetails.ReportDate, objECClaimDetails.InjuredName, objECClaimDetails.LossDetails, objECClaimDetails.DateOfBirth, objECClaimDetails.AccidentDate, objECClaimDetails.Age, objECClaimDetails.MonthlyEarning, objECClaimDetails.OccupationCode, objECClaimDetails.OccupationDesc,
objECClaimDetails.Currency, objECClaimDetails.TotalPaid, objECClaimDetails.AdjusterFee, objECClaimDetails.RecoveryAmount, objECClaimDetails.Current_OSReserveAmount, objECClaimDetails.Total_Incurred, objECClaimDetails.Injury_Death_Code, objECClaimDetails.Injury_Death_Desc,
objECClaimDetails.Nature_Injury_Code, objECClaimDetails.Nature_Injury_Desc, objECClaimDetails.Cause_Injury_Code, objECClaimDetails.Cause_Injury_Desc, objECClaimDetails.Body_Injury_Code, objECClaimDetails.Body_Injury_Desc, objECClaimDetails.Permanent_Disability, objECClaimDetails.Claim_Status,
objECClaimDetails.Claim_StatusDate, objECClaimDetails.PaymentStatus, objECClaimDetails.Alet_AccountHandler, objECClaimDetails.ECC_Count_Case, objECClaimDetails.CommonLawClaim,
objECClaimDetails.PaymentName, objECClaimDetails.PaymentModeCode, objECClaimDetails.PaymentModeDesc, objECClaimDetails.PaymentRef, objECClaimDetails.ReferenceNo, objECClaimDetails.UserID, objECClaimDetails.Disability_Grade, objECClaimDetails.BoxNo, objECClaimDetails.DetailedStatus, objECClaimDetails.LossTypeID, objECClaimDetails.LossNatureID
, objECClaimDetails.TimeBar, objECClaimDetails.Mortgagee, objECClaimDetails.SumInsured, objECClaimDetails.Deductible, objECClaimDetails.DeductibleCollected, objECClaimDetails.DeductibleType, objECClaimDetails.DeductibleAmount
, objECClaimDetails.AccidentLocationValue, objECClaimDetails.AccidentLocationText
, objECClaimDetails.LocationRemarks
, objECClaimDetails.VehicleNo
, objECClaimDetails.VehicleName
, objECClaimDetails.ReserveAmount
, objECClaimDetails.DateOfDischarge
, objECClaimDetails.DateUpdated
, objECClaimDetails.OutstandingAmount
, objECClaimDetails.TypeofHospital
, objECClaimDetails.Expenses
, objECClaimDetails.GMMActivation
, objECClaimDetails.ReferralLetter
, objECClaimDetails.SubClassId,
objECClaimDetails.AddmissionDate,
objECClaimDetails.HospitalClinicName
};
return(dataAccess.LoadDataSet(parameters, "P_EC_ClaimDetails_InsertUpdate", "EC_ClaimDetails_InsertUpdate"));
}
public DataSet DeleteECClaimClaiment(clsECClaimDetails objECClaimDtls)
{
dataAccess = new DataAccess();
Object[] parameters = new Object[3] {
objECClaimDtls.CaseRefNo, objECClaimDtls.ClaimRefNo, objECClaimDtls.RefNo
};
return(dataAccess.LoadDataSet(parameters, "P_ECClaimsClaimentDelete", "ECClaimsClaiment"));
}
public DataSet InsertUpdateClaimClaimentDtls(clsECClaimDetails objECClaimDtl)
{
dataAccess = new DataAccess();
Object[] parameters = new Object[5] {
objECClaimDtl.CaseRefNo, objECClaimDtl.ClaimRefNo, objECClaimDtl.RefNo, objECClaimDtl.ClaimantName, objECClaimDtl.UserID
};
return(dataAccess.LoadDataSet(parameters, "P_ECClaimsClaimentInsertUpdate", "ECClaimsClaimentDtls"));
}
public DataSet GetECClaimDetailsData(clsECClaimDetails objECClaimDetails)
{
dataAccess = new DataAccess();
Object[] parameters = new Object[2] {
objECClaimDetails.CaseRefNo, objECClaimDetails.ClaimRefNo
};
return(dataAccess.LoadDataSet(parameters, "P_EC_GetClaimDetails", "EC_GetClaimDetails"));
}
public DataSet GetLossRatioDetails(clsECClaimDetails objECClaimDetails)
{
dataAccess = new DataAccess();
Object[] parameters = new Object[] {
objECClaimDetails.ClientName
, objECClaimDetails.ClientCode
, objECClaimDetails.PolicyNo
, objECClaimDetails.CoverNoteNo
, objECClaimDetails.PolicyType
, objECClaimDetails.PeriodofInsuranceFrom
, objECClaimDetails.PeriodofInsuranceTo
, objECClaimDetails.ReportType, objECClaimDetails.UserID
};
return(dataAccess.LoadDataSet(parameters, "P_EC_Get_LossRatioDetails", "P_EC_Get_LossRatioDetails"));
}
public DataSet GetClaimListingDetails(clsECClaimDetails objECClaimDetails)
{
dataAccess = new DataAccess();
Object[] parameters = new Object[] {
objECClaimDetails.ClientName
, objECClaimDetails.ClientCode
, objECClaimDetails.Class
, objECClaimDetails.CoverNoteNo
, objECClaimDetails.PolicyNo
, objECClaimDetails.PeriodofInsuranceFrom
, objECClaimDetails.PeriodofInsuranceTo
, objECClaimDetails.Insurer
, objECClaimDetails.Claim_Status, objECClaimDetails.UserID
};
return(dataAccess.LoadDataSet(parameters, "P_EC_Get_ClaimListingDetails", "P_EC_Get_ClaimListingDetails"));
}
public DataSet GetAgeingDetails(clsECClaimDetails objECClaimDetails)
{
dataAccess = new DataAccess();
Object[] parameters = new Object[] {
objECClaimDetails.ClientName
, objECClaimDetails.ClientCode
, objECClaimDetails.Class
, objECClaimDetails.PeriodofInsuranceFrom
, objECClaimDetails.PeriodofInsuranceTo
, objECClaimDetails.Insurer
, objECClaimDetails.ClaimNo
, objECClaimDetails.InsurerClaimNo
, objECClaimDetails.NotificationFromDate
, objECClaimDetails.NotificationToDate
, objECClaimDetails.Ageing
, objECClaimDetails.TotalIncured, objECClaimDetails.UserID
};
return(dataAccess.LoadDataSet(parameters, "P_EC_Get_AgeingDetails", "P_EC_Get_AgeingDetails"));
}
