private void getData()
{
RptViewer.Reset();
CommisionReceivableBo CommisionReceivableBo = new CommisionReceivableBo();
DataTable dt = CommisionReceivableBo.GetBranchBrokerage(product, productCategory, fromdate, todate, amcCode, schemeId, adviserId, issueid, CommissionType);
DataTable dt2 = CommisionReceivableBo.GetAssociateBrokerage(product, productCategory, fromdate, todate, amcCode, schemeId, adviserId, issueid, CommissionType);
DataTable dt3 = CommisionReceivableBo.GetProductApplicationWiseData(product, productCategory, fromdate, todate, amcCode, schemeId, adviserId, issueid, CommissionType);
DataTable dt4 = CommisionReceivableBo.GetAssocaiteApplicationWiseData(product, productCategory, fromdate, todate, amcCode, schemeId, adviserId, issueid, CommissionType);
ReportDataSource rds = new ReportDataSource("BranchDS_SPROC_GetBranchBrokerageReceivable", dt);
ReportDataSource rds2 = new ReportDataSource("ProductAssociateBrokarageReceived_SPROC_GetAssociateWiseBrokerageReceived", dt2);
ReportDataSource rds3 = new ReportDataSource("ProductBrokerageApplicationWise_SPROC_GetProductBrokerageApplicationWise", dt3);
ReportDataSource rds4 = new ReportDataSource("ProductAssociateBrokarageReceived_SPROC_GetBranchAssociateCommissionPayOuts", dt4);
RptViewer.LocalReport.DataSources.Add(rds);
RptViewer.LocalReport.DataSources.Add(rds2);
RptViewer.LocalReport.DataSources.Add(rds3);
RptViewer.LocalReport.DataSources.Add(rds4);
RptViewer.LocalReport.ReportPath = @"Reports\BrokerageMIS.rdlc";
ReportParameter[] RP = new ReportParameter[] {
new ReportParameter("Product", product),
new ReportParameter("Category", productCategory),
new ReportParameter("FromDate", fromdate),
new ReportParameter("ToDate", todate),
new ReportParameter("AMCCode", amcCode.ToString()),
new ReportParameter("IssueId", issueid.ToString()),
new ReportParameter("IsReceivable", IsReceivable),
new ReportParameter("CommissionType", CommissionType),
new ReportParameter("Channel", "true"),
};
RptViewer.LocalReport.SetParameters(RP);
RptViewer.LocalReport.Refresh();
}
private void BindProduct()
{
CommisionReceivableBo commisionReceivableBo = new CommisionReceivableBo();
DataTable DtProductType = new DataTable();
DtProductType = commisionReceivableBo.GetProductType().Tables[0];
rcbProductType.DataSource = DtProductType;
rcbProductType.DataValueField = DtProductType.Columns["PAG_AssetGroupCode"].ToString();
rcbProductType.DataTextField = DtProductType.Columns["PAG_AssetGroupName"].ToString();
rcbProductType.DataBind();
rcbProductType.Items.Insert(0, new RadComboBoxItem("Select", "Select"));
rcbProductType.SelectedIndex = 0;
}
