public void LoadReport(DateTime dtFrom, DateTime dtTo)
{
List <BLL.BalanceSheet> list = BLL.BalanceSheet.ToList(dtFrom, dtTo);
list = list.Select(x => new BLL.BalanceSheet()
{
Ledger = x.LedgerList.AccountName, CrAmt = x.CrAmt, DrAmt = x.DrAmt, CrAmtOP = x.CrAmtOP, DrAmtOP = x.DrAmtOP
}).ToList();
try
{
RptViewer.Reset();
ReportDataSource data = new ReportDataSource("BalanceSheet", list);
ReportDataSource data1 = new ReportDataSource("CompanyDetail", BLL.CompanyDetail.toList.Where(x => x.Id == BLL.UserAccount.User.UserType.Company.Id).ToList());
RptViewer.LocalReport.DataSources.Add(data);
RptViewer.LocalReport.DataSources.Add(data1);
RptViewer.LocalReport.ReportPath = @"Reports\rptBalancesheet.rdlc";
ReportParameter[] par = new ReportParameter[2];
par[0] = new ReportParameter("DateFrom", dtFrom.ToString());
par[1] = new ReportParameter("DateTo", dtTo.ToString());
RptViewer.LocalReport.SetParameters(par);
RptViewer.RefreshReport();
}
catch (Exception ex)
{
}
}
private void ShowData()
{
Copyright = getVersion();
try {
//string str = ConfigurationManager.ConnectionStrings["ProTRAC_ConnectionString"].ConnectionString;
string str = Session[Session["TMLDealercode"] + "-TMLConString"].ToString();
SqlConnection con = new SqlConnection(str);
RptViewer.Reset();
//datasource
DataTable dt = getTable();
ReportDataSource rds = new ReportDataSource("DataSet1", dt);
RptViewer.LocalReport.DataSources.Add(rds);
//path
RptViewer.LocalReport.ReportPath = "TAT_BSRpt.rdlc";
//params
ReportParameter[] rptparams = new ReportParameter[4];
//{
rptparams[0] = new ReportParameter("FromDate", txtFrom.Text);
rptparams[1] = new ReportParameter("ToDate", TextTo.Text);
rptparams[2] = new ReportParameter("DealerDetails", DealerName);
rptparams[3] = new ReportParameter("Copyright", Copyright);
// };
RptViewer.LocalReport.SetParameters(rptparams);
//refresh
RptViewer.LocalReport.Refresh();
}
catch (Exception ex)
{
}
}
public void LoadReport(int LID, DateTime dtFrom, DateTime dtTo)
{
try
{
List <BLL.GeneralLedger> list = BLL.GeneralLedger.ToList((int)LID, dtFrom, dtTo);
list = list.Select(x => new BLL.GeneralLedger()
{
AccountName = x.Ledger.AccountName, Particular = x.Particular, CrAmt = x.CrAmt, DrAmt = x.DrAmt, BalAmt = x.BalAmt, EDate = x.EDate, EntryNo = x.EntryNo, EType = x.EType, Ledger = x.Ledger, RefNo = x.RefNo
}).ToList();
try
{
RptViewer.Reset();
ReportDataSource data = new ReportDataSource("GeneralLedger", list);
// ReportDataSource data1 = new ReportDataSource("CompanyDetail", BLL.CompanyDetail.toList.Where(x => x.Id == BLL.UserAccount.User.UserType.CompanyId).ToList());
RptViewer.LocalReport.DataSources.Add(data);
// RptViewer.LocalReport.DataSources.Add(data1);
RptViewer.LocalReport.ReportPath = @"Reports\rptGeneralLedger.rdlc";
ReportParameter[] par = new ReportParameter[2];
par[0] = new ReportParameter("DateFrom", dtFrom.ToString());
par[1] = new ReportParameter("DateTo", dtTo.ToString());
RptViewer.LocalReport.SetParameters(par);
RptViewer.RefreshReport();
}
catch (Exception ex)
{
}
}
catch (Exception ex)
{
}
}
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();
}
public void LoadReport(List <BLL.ReceiptAndPayment> list, DateTime dtFrom, DateTime dtTo, bool AccountHead)
{
try
{
RptViewer.Reset();
ReportDataSource data = new ReportDataSource("PaymentAndReceipt", list);
RptViewer.LocalReport.DataSources.Add(data);
if (AccountHead == true)
{
RptViewer.LocalReport.ReportPath = @"Reports\rptPaymentReceiptAccountHead.rdlc";
}
else
{
RptViewer.LocalReport.ReportPath = @"Reports\rptPaymentReceipt.rdlc";
}
ReportParameter[] par = new ReportParameter[4];
par[0] = new ReportParameter("DateFrom", dtFrom.ToString());
par[1] = new ReportParameter("DateTo", dtTo.ToString());
par[2] = new ReportParameter("Title", "Receipt And Payment Report");
par[3] = new ReportParameter("Fund", BLL.UserAccount.User.UserType.Fund.FundName);
RptViewer.LocalReport.SetParameters(par);
RptViewer.RefreshReport();
}
catch (Exception ex)
{
}
}
public void LoadReport(DateTime dtFrom, DateTime dtTo)
{
try
{
List <BLL.GeneralLedger> list = BLL.GeneralLedger.Activity_ToList(dtFrom, dtTo);
list = list.Select(x => new BLL.GeneralLedger()
{
AccountName = x.Ledger.AccountName, SNo = x.SNo, Particular = x.Particular, CrAmt = x.CrAmt, DrAmt = x.DrAmt, BalAmt = x.BalAmt, EDate = x.EDate, EntryNo = x.EntryNo, EType = x.EType, Ledger = x.Ledger, RefNo = x.RefNo
}).ToList();
try
{
RptViewer.Reset();
ReportDataSource data = new ReportDataSource("ActivityReport", list);
RptViewer.LocalReport.DataSources.Add(data);
RptViewer.LocalReport.ReportPath = @"Reports\rptActivityReport.rdlc";
ReportParameter[] par = new ReportParameter[3];
par[0] = new ReportParameter("DateFrom", dtFrom.ToString());
par[1] = new ReportParameter("DateTo", dtTo.ToString());
par[2] = new ReportParameter("Fund", BLL.UserAccount.User.UserType.Company.CompanyName);
RptViewer.LocalReport.SetParameters(par);
RptViewer.RefreshReport();
}
catch (Exception ex)
{
}
}
catch (Exception ex)
{
}
}
public void LoadReport(DateTime dtFrom, DateTime dtTo)
{
List <BLL.SubsidaryAccounts> list = BLL.SubsidaryAccounts.ToList(dtFrom, dtTo);
list = list.Select(x => new BLL.SubsidaryAccounts()
{
AccountName = x.LedgerList.AccountName, CrAmt = x.CrAmt, DrAmt = x.DrAmt, CrAmtOP = x.CrAmtOP, DrAmtOP = x.DrAmtOP
}).ToList();
try
{
RptViewer.Reset();
ReportDataSource data = new ReportDataSource("SubsidaryAccounts", list);
ReportDataSource data1 = new ReportDataSource("FundMaster", BLL.FundMaster.toList.Where(x => x.Id == BLL.UserAccount.User.UserType.Fund.Id).ToList());
RptViewer.LocalReport.DataSources.Add(data);
RptViewer.LocalReport.DataSources.Add(data1);
RptViewer.LocalReport.ReportPath = @"Reports\rptSubsidaryAccount.rdlc";
ReportParameter[] par = new ReportParameter[3];
par[0] = new ReportParameter("DateFrom", dtFrom.ToString());
par[1] = new ReportParameter("DateTo", dtTo.ToString());
par[2] = new ReportParameter("Fund", BLL.UserAccount.User.UserType.Fund.FundName);
RptViewer.LocalReport.SetParameters(par);
RptViewer.RefreshReport();
}
catch (Exception ex)
{
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
Usuarios usuario = new Usuarios();
RptViewer.ProcessingMode = Microsoft.Reporting.WebForms.ProcessingMode.Local;
RptViewer.Reset();
RptViewer.LocalReport.ReportPath = Server.MapPath(@"~\Rpts\UsuarioReport.rdlc");
RptViewer.LocalReport.DataSources.Clear();
RptViewer.LocalReport.DataSources.Add(new ReportDataSource("Usuarios", usuario.Listado("*", "1=1", "")));
RptViewer.LocalReport.Refresh();
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
string strTicID = Convert.ToString(Request.QueryString["TicID"]);
string strDeptID = Convert.ToString(Request.QueryString["DeptID"]);
string strStatus = Convert.ToString(Request.QueryString["Status"]);
BusinessObjects bo = new BusinessObjects();
DataTable dt = bo.GetReportData(strTicID, strDeptID, strStatus);
dt.TableName = "TicketMasterTbl";
RptViewer.Reset();
RptViewer.LocalReport.DataSources.Clear();
ReportDataSource datasource = new ReportDataSource("DataSet1", dt);
RptViewer.ProcessingMode = ProcessingMode.Local;
RptViewer.LocalReport.ReportPath = Server.MapPath("~/Report/RptTic.rdlc");
RptViewer.LocalReport.DataSources.Add(datasource);
RptViewer.ZoomMode = ZoomMode.PageWidth;
//RptViewer.ReportRefresh();
}
}
public void LoadReport(List <BLL.VoucherReport> list)
{
try
{
RptViewer.Reset();
ReportDataSource data = new ReportDataSource("VoucherReport", list);
RptViewer.LocalReport.DataSources.Add(data);
RptViewer.LocalReport.ReportPath = @"Reports\rptVoucherReport.rdlc";
ReportParameter[] par = new ReportParameter[3];
par[0] = new ReportParameter("DateFrom", dtFrom.ToString());
par[1] = new ReportParameter("DateTo", dtTo.ToString());
par[2] = new ReportParameter("Fund", BLL.UserAccount.User.UserType.Company.CompanyName);
RptViewer.LocalReport.SetParameters(par);
RptViewer.RefreshReport();
}
catch (Exception ex)
{
}
}
public void LoadReport(int?LID, DateTime dtFrom, DateTime dtTo, String EntryNo, String Payto, bool AccountHead)
{
try
{
List <BLL.ExpenseReport> list = new List <BLL.ExpenseReport>();
if (AccountHead == true)
{
list = BLL.ExpenseReport.ToList((int?)LID, dtFrom, dtTo, EntryNo, Payto, true);
}
else
{
list = BLL.ExpenseReport.ToList((int?)LID, dtFrom, dtTo, EntryNo, Payto, false);
}
try
{
RptViewer.Reset();
ReportDataSource data = new ReportDataSource("ExpenseReport", list);
ReportDataSource data1 = new ReportDataSource("FundMaster", BLL.FundMaster.toList.Where(x => x.Id == BLL.UserAccount.User.UserType.FundMasterId).ToList());
RptViewer.LocalReport.DataSources.Add(data);
RptViewer.LocalReport.DataSources.Add(data1);
RptViewer.LocalReport.ReportPath = @"Reports\rptExpenseReport.rdlc";
ReportParameter[] par = new ReportParameter[3];
par[0] = new ReportParameter("DateFrom", dtFrom.ToString());
par[1] = new ReportParameter("DateTo", dtTo.ToString());
par[2] = new ReportParameter("Fund", BLL.UserAccount.User.UserType.Fund.FundName.ToString());
RptViewer.LocalReport.SetParameters(par);
RptViewer.RefreshReport();
}
catch (Exception ex)
{
}
}
catch (Exception ex)
{
}
}
private void ShowData()
{
string str = ConfigurationManager.ConnectionStrings["ProTRAC_ConnectionString"].ConnectionString;
SqlConnection con = new SqlConnection(str);
RptViewer.Reset();
//datasource
DataTable dt = getTable();
ReportDataSource rds = new ReportDataSource("DataSet1", dt);
RptViewer.LocalReport.DataSources.Add(rds);
//path
RptViewer.LocalReport.ReportPath = "Report_sample.rdlc";
//params
ReportParameter[] rptparams = new ReportParameter[]
{
new ReportParameter("Bodyshop", txtFrom.Text)
};
RptViewer.LocalReport.SetParameters(rptparams);
//refresh
RptViewer.LocalReport.Refresh();
}
public void LoadReport(int LID, DateTime dtFrom, DateTime dtTo, string endBal, string diffAmt, string BalAmt)
{
try
{
List <BLL.BankReconcilation> list = BLL.BankReconcilation.ToList((int)LID, dtFrom, dtTo);
list = list.Select(x => new BLL.BankReconcilation()
{
AccountName = x.Ledger.AccountName, Particular = x.Particular, CrAmt = x.CrAmt, DrAmt = x.DrAmt, EDate = x.EDate, EntryNo = x.EntryNo, EType = x.EType, Ledger = x.Ledger, RefNo = x.RefNo
}).ToList();
try
{
RptViewer.Reset();
ReportDataSource data = new ReportDataSource("BankReconciliation", list);
RptViewer.LocalReport.DataSources.Add(data);
RptViewer.LocalReport.ReportPath = @"Transaction\rptBankReconciiation.rdlc";
ReportParameter[] par = new ReportParameter[6];
par[0] = new ReportParameter("FromDate", dtFrom.ToString());
par[1] = new ReportParameter("ToDate", dtTo.ToString());
par[2] = new ReportParameter("Fund", BLL.UserAccount.User.UserType.Fund.FundName);
par[3] = new ReportParameter("EndingBalance", endBal.ToString());
par[4] = new ReportParameter("DiffAmt", diffAmt.ToString());
par[5] = new ReportParameter("BalAmt", BalAmt.ToString());
RptViewer.LocalReport.SetParameters(par);
RptViewer.RefreshReport();
}
catch (Exception ex)
{
}
}
catch (Exception ex)
{
}
}