public DataSet GetECClaimFollowUpDiaryData(clsECClaim objECClaim, string strClaimType)
{
dataAccess = new DataAccess();
Object[] parameters = new Object[3] {
objECClaim.CaseRefNo, objECClaim.ClaimRefNo, strClaimType
};
return(dataAccess.LoadDataSet(parameters, "P_ECClaimFollowUpDiary", "ECClaimFollowUpDiary"));
}
public DataSet SaveGenerateClaimNo(clsECClaim objECClaim)
{
dataAccess = new DataAccess();
Object[] parameters = new Object[3] {
objECClaim.CaseRefNo, objECClaim.ClaimRefNo, objECClaim.UserID
};
return(dataAccess.LoadDataSet(parameters, "P_EC_GenerateClaimNo", "EC_GenerateClaimNo"));
}
public DataSet GetECClaimsLoadData(clsECClaim objECClaim)
{
dataAccess = new DataAccess();
Object[] parameters = new Object[2] {
objECClaim.CaseRefNo, objECClaim.PolVersionId
};
return(dataAccess.LoadDataSet(parameters, "P_EC_ClaimsLoadData", "EC_ClaimsLoadData"));
}
public DataSet GetECClaimNewList(clsECClaim objECClaim, int UserId)
{
dataAccess = new DataAccess();
Object[] parameters = new Object[14] {
objECClaim.ClientCode, objECClaim.ClientName, objECClaim.MainClassName, objECClaim.SubClassName, objECClaim.PolicyNo, objECClaim.CoverNoteNo, objECClaim.POIFromDate, objECClaim.POIToDate, UserId, objECClaim.KeyAccountmanager, objECClaim.Industrytype, objECClaim.VehicleNo, objECClaim.VesselName, objECClaim.IsDataFromHist
};
return(dataAccess.LoadDataSet(parameters, "P_DN_ECClaimsList", "DN_ECClaimsList"));
}
public DataSet GetECLetterClaimOutstandingList(clsECClaim objECClaim)
{
dataAccess = new DataAccess();
Object[] parameters = new Object[22] {
objECClaim.IssueFromDate, objECClaim.IssueToDate, objECClaim.ClaimNo, objECClaim.ClientCode, objECClaim.ClientName, objECClaim.MainClassName, objECClaim.UWClaimNo, objECClaim.PolicyNo, objECClaim.CoverNoteNo, objECClaim.ClaimStatus, objECClaim.POIFromDate, objECClaim.POIToDate, objECClaim.InjuredName, objECClaim.AccidentDate, objECClaim.Location, objECClaim.MotorRegNo, objECClaim.ThirdPartyDetails, objECClaim.ReportDate, objECClaim.NotifyDate, objECClaim.LossNature, objECClaim.CauseOfLoss, objECClaim.ChequeRefNo
};
return(dataAccess.LoadDataSet(parameters, "P_ECLetter_ViewClaimsList", "EC_ViewClaimsList"));
}
public DataSet GetECClaimData(clsECClaim objECClaim)
{
dataAccess = new DataAccess();
Object[] parameters = new Object[2] {
objECClaim.CaseRefNo, objECClaim.ClaimRefNo
};
return(dataAccess.LoadDataSet(parameters, "P_EC_CalimsRegistrationDetails", "EC_CalimsRegistrationDetails"));
}
public DataSet ViewClaimBilling(clsECClaim objECClaim)
{
dataAccess = new DataAccess();
Object[] parameters = new Object[2] {
objECClaim.CaseRefNo, objECClaim.ClaimRefNo
};
return(dataAccess.LoadDataSet(parameters, "P_ViewECClaimBilling", "ViewClaimBilling_Data"));
}
//public DataSet GetClaimDetails(clsECClaim objECClaim, int UserId, string id, string reportType)
//{
// dataAccess = new DataAccess();
// Object[] parameters = new Object[8] { objECClaim.IsDataFromHist, objECClaim.pintBrokerId, objECClaim.ConColumName, objECClaim.ConColumValues, UserId, objECClaim.sortBy, objECClaim.sortType, objECClaim.ClaimDiary };
// return dataAccess.LoadDataSet(parameters, "Proc_GetClaimDetails", "GetClaimList");
//}
//Added by Apurva
public DataSet GetClaimDetails(clsECClaim objECClaim, int UserId, string id, string reportType)
{
dataAccess = new DataAccess();
Object[] parameters = new Object[3] {
UserId, id, reportType
};
return(dataAccess.LoadDataSet(parameters, "Proc_GetClaimDetails", "GetClaimList"));
}
//added on 23rd nov for claim billing
public DataSet GetECClaimBilling(clsECClaim objECClaim, int userid)
{
dataAccess = new DataAccess();
Object[] parameters = new Object[6] {
objECClaim.ClientName, objECClaim.UnderwriterName, objECClaim.PolicyNo, objECClaim.CoverNoteNo, objECClaim.VesselName, userid
};
return(dataAccess.LoadDataSet(parameters, "P_Pol_GetClaimBilling", "DN_ClaimBilling"));
}
//end
public DataSet GetRecoveryClaimData(clsECClaim objECClaim)
{
dataAccess = new DataAccess();
Object[] parameters = new Object[5] {
objECClaim.VesselId, objECClaim.RecoveryNo, objECClaim.VesselName, objECClaim.ClientName, objECClaim.RelatedClaimNo
};
return(dataAccess.LoadDataSet(parameters, "P_GetRecoveryClaimData", "GetRecoveryClaimData"));
}
public DataSet GetClaimSummaryList(clsECClaim objECClaim, int UserId)
{
dataAccess = new DataAccess();
Object[] parameters = new Object[25] {
objECClaim.IsDataFromHist, objECClaim.pintBrokerId, objECClaim.ConColumName, objECClaim.ConColumValues, objECClaim.sortBy, objECClaim.sortType, UserId, objECClaim.ReportType, objECClaim.ReportColumns, objECClaim.NotifyFromDate, objECClaim.NotifyToDate, objECClaim.ClaimNo, objECClaim.CoverNoteNo, objECClaim.ClientCode, objECClaim.ClientName, objECClaim.PolicyNo, objECClaim.MainClassName, objECClaim.SubClassName, objECClaim.UnderwriterName, objECClaim.VehicleNo, objECClaim.VesselName, objECClaim.DateofLoss, objECClaim.ClaimStatus, objECClaim.InsurerID, objECClaim.ClaimDiary
};
return(dataAccess.LoadDataSet(parameters, "P_Get_ClaimSummary", "GetClaimList1"));
}
public DataSet GetWICAFollowupDiaryListEnquiry(clsECClaim objECClaim, int userid)
{
dataAccess = new DataAccess();
Object[] parameters = new Object[34] {
objECClaim.IssueFromDate, objECClaim.IssueToDate, objECClaim.ClaimNo, objECClaim.ClientCode, objECClaim.ClientName, objECClaim.MainClassName, objECClaim.UWClaimNo, objECClaim.PolicyNo, objECClaim.CoverNoteNo, objECClaim.ClaimStatus, objECClaim.POIFromDate, objECClaim.POIToDate, objECClaim.InjuredName, objECClaim.AccidentDate, objECClaim.Location, objECClaim.MotorRegNo, objECClaim.ThirdPartyDetails, objECClaim.ReportDate, objECClaim.NotifyDate, objECClaim.LossNature, objECClaim.CauseOfLoss, objECClaim.ChequeRefNo, objECClaim.Disability_Grade, objECClaim.UnderwriterCode, objECClaim.UnderwriterName, objECClaim.VesselName, userid, objECClaim.KeyAccountmanager, objECClaim.Industrytype, objECClaim.AccidentDate, objECClaim.ClaimantName, objECClaim.NatureofInjury, objECClaim.ClaimInfoStatus, objECClaim.NatureofLoss
};
return(dataAccess.LoadDataSet(parameters, "P_EC_FollowupDiaryList", "EC_FollowupDiaryList"));
}
public DataSet GetNonECClaimsIncompleteClaimsListEnquiry(clsECClaim objECClaim)
{
dataAccess = new DataAccess();
Object[] parameters = new Object[25] {
objECClaim.IssueFromDate, objECClaim.IssueToDate, objECClaim.ClaimNo, objECClaim.ClientCode, objECClaim.ClientName, objECClaim.MainClassName, objECClaim.UWClaimNo, objECClaim.PolicyNo, objECClaim.CoverNoteNo, objECClaim.ClaimStatus, objECClaim.POIFromDate, objECClaim.POIToDate, objECClaim.AccidentDate, objECClaim.Location, objECClaim.MotorRegNo, objECClaim.ThirdPartyDetails, objECClaim.ReportDate, objECClaim.NotifyDate, objECClaim.LossNature, objECClaim.CauseOfLoss, objECClaim.ChequeRefNo, objECClaim.UnderwriterCode, objECClaim.UnderwriterName, objECClaim.KeyAccountmanager, objECClaim.Industrytype
};
return(dataAccess.LoadDataSet(parameters, "P_EC_IncompleteNonClaimsList", "EC_IncompleteNonClaimsList"));
}
public DataSet GetECClaimsViewListEnquiry(clsECClaim objECClaim, int userid)
{
dataAccess = new DataAccess();
Object[] parameters = new Object[29] {
objECClaim.IssueFromDate, objECClaim.IssueToDate, objECClaim.ClaimNo, objECClaim.ClientCode, objECClaim.ClientName, objECClaim.MainClassName, objECClaim.UWClaimNo, objECClaim.PolicyNo, objECClaim.CoverNoteNo, objECClaim.ClaimStatus, objECClaim.POIFromDate, objECClaim.POIToDate, objECClaim.InjuredName, objECClaim.AccidentDate, objECClaim.Location, objECClaim.MotorRegNo, objECClaim.ThirdPartyDetails, objECClaim.ReportDate, objECClaim.NotifyDate, objECClaim.LossNature, objECClaim.CauseOfLoss, objECClaim.ChequeRefNo, objECClaim.Disability_Grade, objECClaim.UnderwriterCode, objECClaim.UnderwriterName, objECClaim.VesselName, userid, objECClaim.KeyAccountmanager, objECClaim.Industrytype
}; // disability grade added by kavita//
return(dataAccess.LoadDataSet(parameters, "P_EC_ViewClaimsList", "EC_ViewClaimsList"));
}
public DataSet GetWICAECClaimsIncompleteClaimsListEnquiry(clsECClaim objECClaim, int userid)
{
dataAccess = new DataAccess();
Object[] parameters = new Object[29] {
objECClaim.IssueFromDate, objECClaim.IssueToDate, objECClaim.ClaimNo, objECClaim.ClientCode, objECClaim.ClientName, objECClaim.MainClassName, objECClaim.UWClaimNo, objECClaim.PolicyNo, objECClaim.CoverNoteNo, objECClaim.ClaimStatus, objECClaim.POIFromDate, objECClaim.POIToDate, objECClaim.InjuredName, objECClaim.AccidentDate, objECClaim.ReportDate, objECClaim.NotifyDate, objECClaim.Location, objECClaim.ChequeRefNo, objECClaim.Disability_Grade, objECClaim.UnderwriterCode, objECClaim.UnderwriterName, objECClaim.VesselName, userid, objECClaim.KeyAccountmanager, objECClaim.Industrytype, objECClaim.SubClassName, objECClaim.ClaimantName, objECClaim.NatureofInjury, objECClaim.ClaimInfoStatus
};
return(dataAccess.LoadDataSet(parameters, "P_EC_IncompleteClaimsList", "EC_IncompleteClaimsList"));
}
//added on 21st December for Standard Letter Billing//
public DataSet GetCliamStandardLetterRecords(clsECClaim objECClaim)
{
dataAccess = new DataAccess();
Object[] parameters = new Object[21] {
objECClaim.IssueFromDate, objECClaim.IssueToDate, objECClaim.ClientCode, objECClaim.ClientName, objECClaim.ClaimNo, objECClaim.MainClassName, objECClaim.UWClaimNo, objECClaim.AccidentDate,
objECClaim.ReportDate, objECClaim.NotifyDate, objECClaim.PolicyNo, objECClaim.CoverNoteNo, objECClaim.POIFromDate, objECClaim.POIToDate, objECClaim.ChequeRefNo, objECClaim.ClaimStatus, objECClaim.UnderwriterCode, objECClaim.UnderwriterName, objECClaim.KeyAccountmanager, objECClaim.Industrytype, objECClaim.CalledFor
}; // disability grade added by kavita//
return(dataAccess.LoadDataSet(parameters, "P_EC_ClaimStandardLetter", "EC_ClaimStandardLetter"));
}
public DataSet InsertUpdateClaimBilling(clsECClaim objECClaim)
{
dataAccess = new DataAccess();
Object[] parameters = new Object[] { objECClaim.CaseRefNo, objECClaim.ClaimRefNo, objECClaim.ClaimNo,
objECClaim.ClientCode, objECClaim.ClientName, objECClaim.UnderwriterCode, objECClaim.UnderwriterName, objECClaim.ChequeRefNo, objECClaim.Currency, objECClaim.Amount, objECClaim.IssueDate, objECClaim.VesselName, objECClaim.Casualty,
objECClaim.Remark, objECClaim.UserID, objECClaim.PolicyId, objECClaim.PolVersionId };
return(dataAccess.LoadDataSet(parameters, "P_Policy_ClaimBillingInsertUpdate", "Insert_ClaimBillingData"));
}
public DataSet WICAInsertUpdateECClaims(clsECClaim objECClaim)
{
dataAccess = new DataAccess();
Object[] parameters = new Object[] {
objECClaim.PageMode, objECClaim.CaseRefNo, objECClaim.ClaimRefNo, objECClaim.IssueDate, objECClaim.IsVoid, objECClaim.ClientCode, objECClaim.ClientName, objECClaim.UWClaimNo,
objECClaim.MainClassCode, objECClaim.MainClassName, objECClaim.PolicyNo, objECClaim.CoverNoteNo, objECClaim.POIFromDate, objECClaim.POIToDate, objECClaim.Location, objECClaim.NotifyBy, objECClaim.NotifyDate, objECClaim.Team,
objECClaim.FirstName, objECClaim.LastName, objECClaim.DirectLine1, objECClaim.DirectLine2, objECClaim.MobileNo1, objECClaim.MobileNo2, objECClaim.FaxNo1, objECClaim.FaxNo2,
objECClaim.Email, objECClaim.ClaimsHandlerCode, objECClaim.ClaimsHandlerName, objECClaim.SurveyorCode, objECClaim.SurveyorName, objECClaim.AccountHandlerCode, objECClaim.AccountHandlerName,
objECClaim.LossAdjusterCode, objECClaim.LossAdjusterName, objECClaim.HealthCareCode, objECClaim.HealthCareName, objECClaim.SolicitorCode, objECClaim.SolicitorName, objECClaim.InvestigatorCode,
objECClaim.InvestigatorName, objECClaim.UserID, objECClaim.PolicyId, objECClaim.PolVersionId, objECClaim.FileStatus, objECClaim.SurveyorName2, objECClaim.SolicitorName2, objECClaim.LossAdjusterName2, objECClaim.ReceiptInvoiceNo,
objECClaim.CedantCode, objECClaim.CedantName, objECClaim.CedantClaimNo, objECClaim.CedantPolicyNo, objECClaim.VesselName, objECClaim.ClientClaimNo, objECClaim.NotificationNo, objECClaim.SubmissionDate, objECClaim.Department, objECClaim.SubsidiaryClientCode, objECClaim.SubClassCode, objECClaim.SubClassName
};
return(dataAccess.LoadDataSet(parameters, "P_ECClaimInsertUpdate", "InsertEC_ClaimsData"));
}
public DataSet InsertUpdateRecoveryClaim(clsECClaim objECClaim)
{
dataAccess = new DataAccess();
Object[] parameters = new Object[] { objECClaim.PolicyId, objECClaim.PolVersionId, objECClaim.VesselId, objECClaim.VesselName, objECClaim.ClientName, objECClaim.DateofIncident, objECClaim.RecoveryAmount, objECClaim.RelatedClaimNo, objECClaim.Remark, objECClaim.UserID, objECClaim.RecoveryNo };
return(dataAccess.LoadDataSet(parameters, "P_Policy_RecoveryClaimInsertUpdate", "InsertRecovery_ClaimsData"));
}
public DataSet GetBillingType(clsECClaim objECClaim)
{
dataAccess = new DataAccess();
Object[] parameters = new Object[] { objECClaim.PolicyId, objECClaim.PolVersionId };
return(dataAccess.LoadDataSet(parameters, "P_Get_BillingType", "BillingType"));
}
