public DataSet GetPremiumStatus(clsEnquiryReport objEnquiryReport)
{
dataAccess = new DataAccess();
Object[] parameters = new Object[20] {
objEnquiryReport.POIFromDate,
objEnquiryReport.POIToDate,
objEnquiryReport.PlacementClosingNo,
objEnquiryReport.MainClass,
objEnquiryReport.SubClass,
objEnquiryReport.ClientName,
objEnquiryReport.ClientCode,
objEnquiryReport.AgentId,
objEnquiryReport.AccountHandler,
objEnquiryReport.PolicyNo,
objEnquiryReport.VehicleNo,
objEnquiryReport.PremiumStatus,
objEnquiryReport.DNCNNo,
objEnquiryReport.Team,
objEnquiryReport.KeyAccountmanager,
objEnquiryReport.Industrytype,
objEnquiryReport.ProfitCenter,
objEnquiryReport.Branch,
objEnquiryReport.ProjectTitle, objEnquiryReport.UserId
};
return(dataAccess.LoadDataSet(parameters, "P_Pol_PremiumStatusReport1", "PremiumStatus"));
}
public DataSet GetMainClass(clsEnquiryReport objMainClass)
{
dataAccess = new DataAccess();
Object[] parameters = new Object[20] {
objMainClass.DNFromDate,
objMainClass.DNToDate,
objMainClass.PlacementClosingNo,
objMainClass.ClientName,
objMainClass.ClientCode,
objMainClass.AccountHandler,
objMainClass.MainClass,
objMainClass.UnderwriterName,
objMainClass.GlobalProgram,
objMainClass.BusinessType,
objMainClass.RenewalType,
objMainClass.AgentName,
objMainClass.ProfitCentre,
objMainClass.Branch
, objMainClass.AccountingMonthFrom
, objMainClass.AccountingMonthTo
, objMainClass.ReportType
, objMainClass.UserId
, objMainClass.TeamID //Redmine #33818
, objMainClass.CustomizedClient //Redmine #33818
};
return(dataAccess.LoadDataSet(parameters, "P_Pol_MainClassReport", "MainClass"));
}
public DataSet GetPremiumSummary(clsEnquiryReport objEnquiryReport)
{
dataAccess = new DataAccess();
Object[] parameters = new Object[18] {
objEnquiryReport.DNFromDate,
objEnquiryReport.DNToDate,
objEnquiryReport.POIFromDate,
objEnquiryReport.POIToDate,
objEnquiryReport.PlacementClosingNo,
objEnquiryReport.ClientName,
objEnquiryReport.ClientCode,
objEnquiryReport.AgentId,
objEnquiryReport.MainClass,
objEnquiryReport.UnderwriterName,
objEnquiryReport.ProfitCenter,
objEnquiryReport.Branch
, objEnquiryReport.AccountingMonthFrom
, objEnquiryReport.AccountingMonthTo
, objEnquiryReport.ReportBy,
objEnquiryReport.UserId,
objEnquiryReport.SubClass,
objEnquiryReport.Team
};
return(dataAccess.LoadDataSetWithTimeout(parameters, "P_Pol_PremiumSummaryReport", "PremiumSummaryReport"));
}
public DataSet GetEnquiryList(clsEnquiryReport objEnquiryReport)
{
dataAccess = new DataAccess();
Object[] parameters = new Object[25] {
objEnquiryReport.DNFromDate,
objEnquiryReport.DNToDate,
objEnquiryReport.POIFromDate,
objEnquiryReport.POIToDate,
objEnquiryReport.ClientName,
objEnquiryReport.ClientCode,
objEnquiryReport.AccountHandler,
objEnquiryReport.MainClass,
objEnquiryReport.SubClass,
objEnquiryReport.UnderwriterName,
objEnquiryReport.GlobalProgram,
objEnquiryReport.BusinessType,
objEnquiryReport.RenewalType,
objEnquiryReport.RenewalStatus,
objEnquiryReport.ClaimStatus,
objEnquiryReport.Team,
objEnquiryReport.AgentName,
objEnquiryReport.KeyAccountmanager,
objEnquiryReport.Industrytype,
objEnquiryReport.ProfitCentre,
objEnquiryReport.Branch
, objEnquiryReport.AccountingMonthFrom
, objEnquiryReport.AccountingMonthTo
, objEnquiryReport.ReportBy, objEnquiryReport.UserId
};
return(dataAccess.LoadDataSetWithTimeout(parameters, "P_Pol_EnquiryReport", "EnquiryReport"));
}
public DataSet GetProducerList(clsEnquiryReport objEnquiryReport)
{
dataAccess = new DataAccess();
Object[] parameters = new Object[6] {
objEnquiryReport.ClientName,
objEnquiryReport.AccountHandler,
objEnquiryReport.MainClass,
objEnquiryReport.SubClass,
objEnquiryReport.AccountingMonthFrom,
objEnquiryReport.AccountingMonthTo
};
return(dataAccess.LoadDataSetWithTimeout(parameters, "P_Pol_ProducERReport", "ProducerReport"));
}
public DataSet GetUnsuccessfulQuotations(clsEnquiryReport objReportParams)
{
dataAccess = new DataAccess();
Object[] parameters = new Object[10] {
objReportParams.DNFromDate,
objReportParams.DNToDate,
objReportParams.ClientName,
objReportParams.ClientCode,
objReportParams.AccountHandler,
objReportParams.MainClass,
objReportParams.UnderwriterName,
objReportParams.ProfitCenter,
objReportParams.Branch, objReportParams.UserId
};
return(dataAccess.LoadDataSet(parameters, "P_Pol_Unsuccessful_Quotations", "UnsuccessfulQuotations"));
}
public DataSet GetLapsedReport(clsEnquiryReport objReportParams)
{
dataAccess = new DataAccess();
Object[] parameters = new Object[15] {
objReportParams.POIFromDate,
objReportParams.POIToDate,
objReportParams.DNFromDate,
objReportParams.DNToDate,
objReportParams.ClientName,
objReportParams.ClientCode,
objReportParams.AccountHandler,
objReportParams.MainClass,
objReportParams.SubClass,
objReportParams.UnderwriterName,
objReportParams.VehicleNo,
objReportParams.Team,
objReportParams.ProfitCenter,
objReportParams.Branch, objReportParams.UserId
};
return(dataAccess.LoadDataSet(parameters, "P_Pol_LapsedReport", "LapsedReport"));
}
public DataSet GetMasterClientReport(clsEnquiryReport objReportParams)
{
dataAccess = new DataAccess();
Object[] parameters = new Object[15] {
objReportParams.ReportType,
objReportParams.DNFromDate,
objReportParams.DNToDate,
objReportParams.ClientName,
objReportParams.ClientCode,
objReportParams.AccountHandler,
objReportParams.PolicyNo,
objReportParams.MainClass,
objReportParams.UnderwriterName,
objReportParams.ProfitCenter,
objReportParams.Branch
, objReportParams.AccountingMonthFrom
, objReportParams.AccountingMonthTo
, objReportParams.ReportBy,
objReportParams.UserId
};
return(dataAccess.LoadDataSet(parameters, "P_Pol_MasterClientReport", "MasterClient"));
}
public DataSet GetProductionList(clsEnquiryReport objEnquiryReport)
{
dataAccess = new DataAccess();
Object[] parameters = new Object[30] {
objEnquiryReport.DNFromDate,
objEnquiryReport.DNToDate,
objEnquiryReport.POIFromDate,
objEnquiryReport.POIToDate,
objEnquiryReport.PlacementClosingNo,
objEnquiryReport.ClientName,
objEnquiryReport.ClientCode,
objEnquiryReport.AccountHandler,
objEnquiryReport.MainClass,
objEnquiryReport.SubClass,
objEnquiryReport.UnderwriterName,
objEnquiryReport.GlobalProgram,
objEnquiryReport.BusinessType,
objEnquiryReport.RenewalType,
objEnquiryReport.Team,
objEnquiryReport.AgentName,
objEnquiryReport.KeyAccountmanager,
objEnquiryReport.Industrytype,
objEnquiryReport.ProfitCentre,
objEnquiryReport.Branch
, objEnquiryReport.AccountingMonthFrom
, objEnquiryReport.AccountingMonthTo
, objEnquiryReport.ReportBy
, objEnquiryReport.DivisionalGrouping
, objEnquiryReport.ProjectTitle
, objEnquiryReport.BillingParty
, objEnquiryReport.ClientSourceCode
, objEnquiryReport.MasterClient
, objEnquiryReport.CorporateGroup,
objEnquiryReport.UserId
};
return(dataAccess.LoadDataSetWithTimeout(parameters, "P_Pol_ProductionReport", "ProductionReport"));
}
