public void ShouldBootStrapCorrectFailingReport() { var bootStrapper = new ReportFactory(); var report = bootStrapper.ResolveReport(ReportType.Failing, "fake.html"); Assert.That(report.GetType(), Is.EqualTo(typeof(HtmlFailedReport))); }
public static IReportInfo EmployeeDirectory(IEnumerable <Employee> employees) { return(GetReportInfo(SortDirectionViewModel.Create(), p => ReportFactory.EmployeeDirectory(employees, p.SortDirection == SortOrderPrintMode.AscendingOrder))); }
public static void AfterTestRun() { extent.Flush(); ReportFactory.LaunchReport(); }
protected void Page_Load(object sender, EventArgs e) { string FYPart = ""; string CertType = ""; string fundCode = ""; string branchCode = ""; string interim = ""; string ended = ""; if (BaseContent.IsSessionExpired()) { Response.Redirect("../../Default.aspx"); return; } bcContent = (BaseClass)Session["BCContent"]; userObj.UserID = bcContent.LoginID.ToString(); CertType = (string)Session["CertType"]; fundCode = (string)Session["FundCode"]; branchCode = (string)Session["branchCode"]; if (string.Compare(CertType, "IncomeTaxCert", true) == 0)//for Income Tax Report { DataTable dtIncomeTax = (DataTable)Session["dtIncomeTax"]; string FY = (string)Session["FY"]; int REG_NO = (int)Session["REG_NO"]; dtIncomeTax.TableName = "IncomeTax"; if (string.Compare(fundCode, "IAMPH", true) == 0) { FYPart = dtIncomeTax.Rows[0]["FY_PART"].Equals(DBNull.Value) ? "" : dtIncomeTax.Rows[0]["FY_PART"].ToString(); FYPart = "(" + FYPart.ToString() + ")"; } interim = dtIncomeTax.Rows[0]["FY_PART"].ToString(); if (interim.ToString().ToUpper() == "INTERIM") { ended = ""; } else if (interim.ToString().ToUpper() == "FINAL") { ended = "ended"; } else { interim = ""; ended = "ended"; } //dtIncomeTax.WriteXmlSchema(@"D:\Project\Web\AMCL.OPENMF\AMCL.Web\UI\ReportViewer\Report\dtReportIncomeTax.xsd"); DataTable dtTaxCal = diviDAOObj.dtDividendInfo(REG_NO, fundCode, branchCode, FY); ReportDocument rdoc = new ReportDocument(); rdoc = new ReportDocument(); string Path = Server.MapPath("Report/rptIncomeTax.rpt"); rdoc.Load(Path); rdoc.Refresh(); rdoc.SetDataSource(dtIncomeTax); CrystalReportViewer1.ReportSource = rdoc; rdoc.SetParameterValue("fundCode", fundCode); rdoc.SetParameterValue("branchCode", branchCode); rdoc.SetParameterValue("FYPart", FYPart.ToString()); rdoc.SetParameterValue("Interim", interim.ToString()); rdoc.SetParameterValue("ended", ended.ToString()); rdoc = ReportFactory.GetReport(rdoc.GetType()); //} } else if (string.Compare(CertType, "SolventCert", true) == 0)//for Solvent { opendMFDAOObj = new OMFDAO(); DataTable dtInvestCertHolderInfo = (DataTable)Session["dtInvestCertHolderInfo"]; decimal totalUnitHolding = (decimal)Session["totalUnitHolding"]; decimal USDRate = Convert.ToDecimal((string)Session["USDRate"]); decimal repRate = Convert.ToDecimal((string)Session["RepRate"]); string TTDate = (string)Session["TTDate"]; decimal equivalentInvestValue = totalUnitHolding * repRate; equivalentInvestValue = decimal.Round(equivalentInvestValue / USDRate, 2); decimal equivalentMarketValue = totalUnitHolding * repRate; equivalentMarketValue = decimal.Round(equivalentMarketValue, 2); // dtInvestSaleInfo.WriteXmlSchema(@"D:\Project\Web\AMCL.OPENMF\AMCL.Web\UI\ReportViewer\Report\rptSolventCert.xsd"); string Path = Server.MapPath("Report/rptSolventCert.rpt"); rdoc.Load(Path); rdoc.Refresh(); rdoc.SetDataSource(dtInvestCertHolderInfo); CrystalReportViewer1.ReportSource = rdoc; rdoc.SetParameterValue("fundCode", fundCode); rdoc.SetParameterValue("branchCode", branchCode); rdoc.SetParameterValue("HNAME", dtInvestCertHolderInfo.Rows[0]["HNAME"].Equals(DBNull.Value) ? "" : dtInvestCertHolderInfo.Rows[0]["HNAME"].ToString()); rdoc.SetParameterValue("JNT_NAME", dtInvestCertHolderInfo.Rows[0]["JNT_NAME"].Equals(DBNull.Value) ? "" : dtInvestCertHolderInfo.Rows[0]["JNT_NAME"].ToString()); rdoc.SetParameterValue("ADDRESS1", dtInvestCertHolderInfo.Rows[0]["ADDRS1"].Equals(DBNull.Value) ? "" : dtInvestCertHolderInfo.Rows[0]["ADDRS1"].ToString()); rdoc.SetParameterValue("ADDRESS2", dtInvestCertHolderInfo.Rows[0]["ADDRS2"].Equals(DBNull.Value) ? "" : dtInvestCertHolderInfo.Rows[0]["ADDRS2"].ToString()); rdoc.SetParameterValue("CITY", dtInvestCertHolderInfo.Rows[0]["CITY"].Equals(DBNull.Value) ? "" : dtInvestCertHolderInfo.Rows[0]["CITY"].ToString()); rdoc.SetParameterValue("FUND_NAME", dtInvestCertHolderInfo.Rows[0]["FUND_NM"].Equals(DBNull.Value) ? "" : dtInvestCertHolderInfo.Rows[0]["FUND_NM"].ToString()); rdoc.SetParameterValue("Reg_No", dtInvestCertHolderInfo.Rows[0]["REG_NUM"].Equals(DBNull.Value) ? "" : dtInvestCertHolderInfo.Rows[0]["REG_NUM"].ToString()); rdoc.SetParameterValue("TotalUnit", totalUnitHolding); rdoc.SetParameterValue("equivalentInvestValue", equivalentInvestValue); rdoc.SetParameterValue("equivalentInvestValueinWord", numberToEnglisUSDObj.changeNumericToWords(equivalentInvestValue)); rdoc.SetParameterValue("equivalentMarketValue", equivalentMarketValue); rdoc.SetParameterValue("equivalentMarketValueinWord", numberToEnglisUSDObj.changeNumericToWords(equivalentMarketValue)); rdoc.SetParameterValue("TTDate", Convert.ToDateTime(TTDate).ToString("dd-MMM-yyyy")); rdoc = ReportFactory.GetReport(rdoc.GetType()); } else if (string.Compare(CertType, "SurrendertCert", true) == 0)// for Surrender { DataTable dtInvestCertHolderInfo = (DataTable)Session["dtInvestCertHolderInfo"]; DataTable dtLadgerForReport = (DataTable)Session["dtLadgerForReport"]; DataTable dtSurrender = (DataTable)Session["dtSurrender"]; dtLadgerForReport.TableName = "dtLadgerForReport"; dtSurrender.TableName = "dtSurrender"; dtInvestCertHolderInfo.TableName = "dtInvestCertHolderInfo"; // dtLadgerForReport.WriteXmlSchema(@"D:\Project\Web\AMCL.OPENMF\AMCL.Web\UI\ReportViewer\Report\rptSurrenderCert.xsd"); ReportDocument rdoc = new ReportDocument(); string Path = Server.MapPath("Report/rptSurrenderCert.rpt"); rdoc.Load(Path); rdoc.Refresh(); rdoc.SetDataSource(dtLadgerForReport); CrystalReportViewer1.ReportSource = rdoc; rdoc.SetParameterValue("branchCode", branchCode); rdoc.SetParameterValue("fundCode", fundCode); rdoc.SetParameterValue("HNAME", dtInvestCertHolderInfo.Rows[0]["HNAME"].Equals(DBNull.Value) ? "" : dtInvestCertHolderInfo.Rows[0]["HNAME"].ToString()); rdoc.SetParameterValue("ADDRESS1", dtInvestCertHolderInfo.Rows[0]["ADDRS1"].Equals(DBNull.Value) ? "" : dtInvestCertHolderInfo.Rows[0]["ADDRS1"].ToString()); rdoc.SetParameterValue("ADDRESS2", dtInvestCertHolderInfo.Rows[0]["ADDRS2"].Equals(DBNull.Value) ? "" : dtInvestCertHolderInfo.Rows[0]["ADDRS2"].ToString()); rdoc.SetParameterValue("CITY", dtInvestCertHolderInfo.Rows[0]["CITY"].Equals(DBNull.Value) ? "" : dtInvestCertHolderInfo.Rows[0]["CITY"].ToString()); rdoc.SetParameterValue("FUND_NAME", dtInvestCertHolderInfo.Rows[0]["FUND_NM"].Equals(DBNull.Value) ? "" : dtInvestCertHolderInfo.Rows[0]["FUND_NM"].ToString()); rdoc.SetParameterValue("TotalBalance", (int)Session["totalBalance"]); rdoc.SetParameterValue("outBalance", (int)Session["outBalance"]); rdoc.SetParameterValue("inBalance", (int)Session["inBalance"]); rdoc.SetParameterValue("sur_Unit", Convert.ToInt32(dtSurrender.Rows[0]["REP_UNIT"].ToString())); rdoc.SetParameterValue("Sur_Date", dtSurrender.Rows[0]["REP_DATE"].ToString()); rdoc.SetParameterValue("sur_Amount", Convert.ToDecimal(dtSurrender.Rows[0]["AMOUNT"].ToString())); rdoc.SetParameterValue("inWord", numberToEnglisObj.changeNumericToWords(Convert.ToDecimal(dtSurrender.Rows[0]["AMOUNT"].ToString()))); rdoc.SetParameterValue("sur_Rate", Convert.ToDecimal(dtSurrender.Rows[0]["RATE"].ToString())); rdoc.SetParameterValue("repAmount", (decimal)Session["repAmount"]); rdoc.SetParameterValue("saleAmount", (decimal)Session["saleAmount"]); rdoc.SetParameterValue("ledgerAmount", (decimal)Session["ledgerAmount"]); rdoc.SetParameterValue("asOnDate", Convert.ToDateTime((string)Session["asOnDate"])); rdoc = ReportFactory.GetReport(rdoc.GetType()); } else if (string.Compare(CertType, "InvestCert", true) == 0)// for Invest { DataTable dtInvestCertHolderInfo = (DataTable)Session["dtInvestCertHolderInfo"]; DataTable dtInvestSaleInfo = (DataTable)Session["dtInvestSaleInfo"]; DataTable dtInvestTotal = (DataTable)Session["dtInvestTotal"]; string FY = (string)Session["FY"]; string CloseDate = (string)Session["CloseDate"]; string investmentType = (string)Session["investmentType"]; // dtInvestSaleInfo.WriteXmlSchema(@"D:\Project\Web\AMCL.OPENMF\AMCL.Web\UI\ReportViewer\Report\rptInvestCert.xsd"); rdoc = new ReportDocument(); string Path = ""; if (investmentType == "CIP") { Path = Server.MapPath("Report/rptInvestCertCIP.rpt"); } else { Path = Server.MapPath("Report/rptInvestCert.rpt"); } rdoc.Load(Path); rdoc.Refresh(); rdoc.SetDataSource(dtInvestSaleInfo); CrystalReportViewer1.ReportSource = rdoc; rdoc.SetParameterValue("branchCode", branchCode); rdoc.SetParameterValue("fundCode", fundCode); rdoc.SetParameterValue("FY", FY.ToString()); rdoc.SetParameterValue("close_dt", CloseDate.ToString()); rdoc.SetParameterValue("HNAME", dtInvestCertHolderInfo.Rows[0]["HNAME"].Equals(DBNull.Value) ? "" : dtInvestCertHolderInfo.Rows[0]["HNAME"].ToString()); rdoc.SetParameterValue("JHOLDER", dtInvestCertHolderInfo.Rows[0]["JNT_NAME"].Equals(DBNull.Value) ? "" : dtInvestCertHolderInfo.Rows[0]["JNT_NAME"].ToString()); rdoc.SetParameterValue("ADDRESS1", dtInvestCertHolderInfo.Rows[0]["ADDRS1"].Equals(DBNull.Value) ? "" : dtInvestCertHolderInfo.Rows[0]["ADDRS1"].ToString()); rdoc.SetParameterValue("ADDRESS2", dtInvestCertHolderInfo.Rows[0]["ADDRS2"].Equals(DBNull.Value) ? "" : dtInvestCertHolderInfo.Rows[0]["ADDRS2"].ToString()); rdoc.SetParameterValue("CITY", dtInvestCertHolderInfo.Rows[0]["CITY"].Equals(DBNull.Value) ? "" : dtInvestCertHolderInfo.Rows[0]["CITY"].ToString()); rdoc.SetParameterValue("FUND_NAME", dtInvestCertHolderInfo.Rows[0]["FUND_NM"].Equals(DBNull.Value) ? "" : dtInvestCertHolderInfo.Rows[0]["FUND_NM"].ToString()); rdoc.SetParameterValue("TotalAmt", Convert.ToDecimal(dtInvestTotal.Rows[0]["TOTAL_AMOUNT"].Equals(DBNull.Value) ? "0" : dtInvestTotal.Rows[0]["TOTAL_AMOUNT"].ToString())); rdoc = ReportFactory.GetReport(rdoc.GetType()); } else { Response.Write("No Data Found"); } }
public static IReportInfo CustomerLocationsDirectory(IEnumerable <Customer> customers) { return(GetReportInfo(SortDirectionViewModel.Create(), p => ReportFactory.CustomerLocationsDirectory(customers, p.SortDirection == SortOrderPrintMode.AscendingOrder))); }
public static IReportInfo SalesOrdersSummaryReport(IEnumerable <SaleSummaryInfo> sales) { return(GetReportInfo(SortByAndDateRangeViewModel.Create(), p => ReportFactory.SalesOrdersSummaryReport(sales, p.SortDirection == SortByPrintMode.SortByOrderDate, p.FromDate, p.ToDate))); }
public static IReportInfo TaskDetailReport(EmployeeTask task) { return(new ParameterlessReportInfo(ReportFactory.TaskDetailReport(task))); }
public static IReportInfo CustomerSalesDetail(IEnumerable <Order> orders) { return(GetReportInfo(SortByAndDateRangeViewModel.Create(), p => ReportFactory.CustomerSalesDetail(orders, orders.SelectMany(x => x.OrderItems).ToArray(), p.SortDirection == SortByPrintMode.SortByOrderDate, p.FromDate, p.ToDate))); }
public Report(ReportFactory reportFactory) { reportDataCommandTemplate = new List <IReportDataCommandTemplate>(); reportParameters = new List <IReportParameter>(); this.reportFactory = reportFactory; }
public static IReportInfo SalesRevenueAnalysisReport(IEnumerable <OrderItem> sales) { return(GetReportInfo(SortByAndDateRangeViewModel.Create(), p => ReportFactory.SalesRevenueAnalysisReport(sales, p.SortDirection == SortByPrintMode.SortByOrderDate))); }
protected override void Print() { ReportFactory.Show(MdiParent, OptionsBaseForm.Text, ObjectName, ds); }
//Pf1s1DAO pf1s1DAOObj = new Pf1s1DAO(); protected void Page_Load(object sender, EventArgs e) { if (Session["UserID"] == null) { Session.RemoveAll(); Response.Redirect("../../Default.aspx"); } string howlaDateFrom = ""; string howlaDateTo = ""; if (Request.QueryString["howlaDateFrom"] != "") { howlaDateFrom = Request.QueryString["howlaDateFrom"].ToString(); } if (Request.QueryString["howlaDateTo"] != "") { howlaDateTo = Request.QueryString["howlaDateTo"].ToString(); } DataTable dtReprtSource = new DataTable(); StringBuilder sbMst = new StringBuilder(); StringBuilder sbfilter = new StringBuilder(); sbfilter.Append(" "); dtReprtSource.TableName = "IPO_DateWiseReport"; sbMst.Append("SELECT COMP.COMP_CD, COMP.COMP_NM || ' (' || COMP.COMP_CD || ')' as COMP_NM , FUND.F_NAME, FUND_TRANS_HB.VCH_DT,"); sbMst.Append("FUND_TRANS_HB.NO_SHARE, FUND_TRANS_HB.AMOUNT, FUND_TRANS_HB.AMT_AFT_COM "); sbMst.Append("FROM COMP INNER JOIN "); sbMst.Append("FUND_TRANS_HB ON COMP.COMP_CD = FUND_TRANS_HB.COMP_CD INNER JOIN"); sbMst.Append(" FUND ON FUND_TRANS_HB.F_CD = FUND.F_CD WHERE(FUND_TRANS_HB.TRAN_TP = 'I')"); if (howlaDateFrom != "" && howlaDateTo == "") { sbfilter.Append(" AND (FUND_TRANS_HB.VCH_DT >='" + Convert.ToDateTime(Request.QueryString["howlaDateFrom"]).ToString("dd-MMM-yyyy") + "')"); } else if (howlaDateFrom == "" && howlaDateTo != "") { sbfilter.Append(" AND (FUND_TRANS_HB.VCH_DT <='" + Convert.ToDateTime(Request.QueryString["howlaDateTo"]).ToString("dd-MMM-yyyy") + "')"); } else if (howlaDateFrom != "" && howlaDateTo != "") { sbfilter.Append(" AND (FUND_TRANS_HB.VCH_DT >='" + Convert.ToDateTime(Request.QueryString["howlaDateFrom"]).ToString("dd-MMM-yyyy") + "') AND (FUND_TRANS_HB.VCH_DT <='" + Convert.ToDateTime(Request.QueryString["howlaDateTo"]).ToString("dd-MMM-yyyy") + "')"); } sbMst.Append(sbfilter.ToString()); sbMst.Append(" ORDER BY FUND_TRANS_HB.VCH_DT, FUND.F_CD"); dtReprtSource = commonGatewayObj.Select(sbMst.ToString()); dtReprtSource.TableName = "IPO_DateWiseReport"; if (dtReprtSource.Rows.Count > 0) { //dtReprtSource.WriteXmlSchema(@"F:\PortfolioManagementSystem\UI\ReportViewer\Report\crtmIPO_DateWiseReport.xsd"); //ReportDocument rdoc = new ReportDocument(); string Path = Server.MapPath("Report/IPO_DateWise.rpt"); rdoc.Load(Path); rdoc.SetDataSource(dtReprtSource); CrystalReportViewer1.ReportSource = rdoc; CrystalReportViewer1.DisplayToolbar = true; CrystalReportViewer1.HasExportButton = true; CrystalReportViewer1.HasPrintButton = true; rdoc = ReportFactory.GetReport(rdoc.GetType()); } else { Response.Write("No Data Found"); } }
protected void Page_Load(object sender, EventArgs e) { StringBuilder sbFilter = new StringBuilder(); string howlaDate = ""; string fundCodes = ""; string companyCodes = ""; string percentageCheck = ""; if (Session["UserID"] == null) { Session.RemoveAll(); Response.Redirect("../../Default.aspx"); } else { howlaDate = (string)Session["howlaDate"]; fundCodes = (string)Session["fundCodes"]; percentageCheck = (string)Session["percentageCheck"]; companyCodes = (string)Session["companyCodes"]; } DataTable dtReprtSource = new DataTable(); StringBuilder sbMst = new StringBuilder(); StringBuilder sbfilter = new StringBuilder(); sbfilter.Append(" "); sbMst.Append(" SELECT PFOLIO_BK.SECT_MAJ_NM, COMP.COMP_NM, FUND.F_NAME, PFOLIO_BK.TOT_NOS, PFOLIO_BK.TCST_AFT_COM, "); sbMst.Append(" ROUND(PFOLIO_BK.TCST_AFT_COM / PFOLIO_BK.TOT_NOS, 2) AS COST_RT_PER_SHARE, NVL(PFOLIO_BK.DSE_RT, "); sbMst.Append(" PFOLIO_BK.CSE_RT) AS DSE_RT, ROUND(PFOLIO_BK.TOT_NOS * NVL(PFOLIO_BK.DSE_RT, PFOLIO_BK.CSE_RT), 2) "); sbMst.Append(" AS TOT_MARKET_PRICE, ROUND(ROUND(NVL(PFOLIO_BK.DSE_RT, PFOLIO_BK.CSE_RT), 2) "); sbMst.Append(" - ROUND(PFOLIO_BK.TCST_AFT_COM / PFOLIO_BK.TOT_NOS, 2), 2) AS RATE_DIFF, "); sbMst.Append(" ROUND(ROUND(PFOLIO_BK.TOT_NOS * NVL(PFOLIO_BK.DSE_RT, PFOLIO_BK.CSE_RT), 2) - PFOLIO_BK.TCST_AFT_COM, 2) "); sbMst.Append(" AS APPRICIATION_ERROTION, PFOLIO_BK.BAL_DT_CTRL, ROUND(PFOLIO_BK.TOT_NOS / COMP.NO_SHRS * 100, 3) "); sbMst.Append(" AS PERCENTAGE_OF_PAIDUP "); sbMst.Append(" FROM PFOLIO_BK INNER JOIN "); sbMst.Append(" COMP ON PFOLIO_BK.COMP_CD = COMP.COMP_CD INNER JOIN "); sbMst.Append(" FUND ON PFOLIO_BK.F_CD = FUND.F_CD "); sbMst.Append(" WHERE (PFOLIO_BK.BAL_DT_CTRL = '" + howlaDate.ToString() + "') "); if (percentageCheck != "") { sbMst.Append(" AND (ROUND(PFOLIO_BK.TOT_NOS / COMP.NO_SHRS * 100, 3) >=" + percentageCheck + ") "); } if (fundCodes != "") { sbMst.Append(" AND FUND.F_CD IN(" + fundCodes + ") "); } if (companyCodes != "") { sbMst.Append(" AND PFOLIO_BK.COMP_CD IN(" + companyCodes + ") "); } sbMst.Append(" ORDER BY PFOLIO_BK.SECT_MAJ_NM, COMP.COMP_NM, PFOLIO_BK.F_CD "); sbMst.Append(sbfilter.ToString()); dtReprtSource = commonGatewayObj.Select(sbMst.ToString()); dtReprtSource.TableName = "CompanyWiseAllPortfoliosReportDSEonly"; if (dtReprtSource.Rows.Count > 0) { //dtReprtSource.WriteXmlSchema(@"G:\F Drive\PortfolioManagementSystem\UI\ReportViewer\Report\crtmCompanyWiseAllPortfoliosReportDSEonlyReport.xsd"); string Path = Server.MapPath("Report/crtmCompanyWiseAllPortfoliosReportDSEonlyReport.rpt"); rdoc.Load(Path); rdoc.SetDataSource(dtReprtSource); CRV_CompanyWiseAllPortfolioDSEonly.ReportSource = rdoc; //rdoc.SetParameterValue("prmtransactionDate", tranDate); rdoc = ReportFactory.GetReport(rdoc.GetType()); } else { Response.Write("No Data Found"); } }
public static IReportInfo CusomerProfile(Customer customer) { return(GetReportInfo(CustomerContactsPrintModeViewModel.Create(), p => customer == null ? null : ReportFactory.CustomerProfile(customer, p.CustomerContactsPrintMode != CustomerContactsPrintMode.ExcludeContacts))); }
public static IReportInfo EmployeeTaskList(IEnumerable <EmployeeTask> tasks) { return(GetReportInfo(SortByDateViewModel.Create(), p => ReportFactory.EmployeeTaskList(tasks, p.SortDirection == SortByDatePrintMode.SortByDueDate))); }
public static IReportInfo CustomerContactsDirectory(Customer customer) { return(GetReportInfo(SortDirectionViewModel.Create(), p => ReportFactory.CustomerContactsDirectory(customer.Employees, p.SortDirection == SortOrderPrintMode.AscendingOrder))); }
public static IReportInfo ProductProfile(Product product) { return(GetReportInfo(ProductImagesPrintModeViewModel.Create(), p => ReportFactory.ProductProfile(product, p.ProductImagesPrintMode == ProductImagesPrintMode.DisplayProductImages))); }
public static IReportInfo CustomerSalesSummaryReport(IEnumerable <CustomerSaleDetailOrderItemInfo> sales) { return(GetReportInfo(SortByAndDateRangeViewModel.Create(), p => ReportFactory.CustomerSalesSummaryReport(sales, p.SortDirection == SortByPrintMode.SortByOrderDate, p.FromDate, p.ToDate))); }
public static IReportInfo ProductOrders(IEnumerable <OrderItem> sales, IList <State> states) { return(GetReportInfo(SortByAndDateRangeViewModel.Create(), p => ReportFactory.ProductOrders(sales, states, p.SortDirection == SortByPrintMode.SortByOrderDate, p.FromDate, p.ToDate))); }
public static IReportInfo SalesInvoice(Order order) { return(GetReportInfo(InvoiceOptionsViewModel.Create(), p => ReportFactory.SalesInvoice(order, p.IsOptionSelected("ShowHeader"), p.IsOptionSelected("ShowFooter"), p.IsOptionSelected("ShowStatus"), p.IsOptionSelected("ShowComments")))); }
public static IReportInfo ProductSalesSummary(IEnumerable <OrderItem> sales) { return(GetReportInfo(SelectYearsViewModel.Create(), p => ReportFactory.ProductSalesSummary(sales, p.Years))); }
public static IReportInfo SalesAnalysisReport(IEnumerable <SaleAnalysisInfo> sales) { return(GetReportInfo(SelectYearsViewModel.Create(), p => ReportFactory.SalesAnalysisReport(sales, p.Years))); }
public static IReportInfo ProductTopSalesPerson(IEnumerable <OrderItem> sales) { return(GetReportInfo(SortDirectionViewModel.Create(), p => ReportFactory.ProductTopSalesPerson(sales, p.SortDirection == SortOrderPrintMode.AscendingOrder))); }
protected void Page_Load(object sender, EventArgs e) { StringBuilder sbFilter = new StringBuilder(); string fromDate = ""; string toDate = ""; string transType = ""; string fundCode = ""; string companyCode = ""; string bdf = ""; DataTable dtIntimationReport = new DataTable(); if (Session["UserID"] == null) { Session.RemoveAll(); Response.Redirect("../../Default.aspx"); } else { fromDate = (string)Session["fromDate"]; toDate = (string)Session["toDate"]; transType = (string)Session["transType"]; fundCode = (string)Session["fundCode"]; companyCode = (string)Session["companyCode"]; bdf = (string)Session["bdf"]; } DataTable dtReprtSource = new DataTable(); StringBuilder sbMst = new StringBuilder(); StringBuilder sbfilter = new StringBuilder(); sbfilter.Append(" "); sbMst.Append("SELECT COMP.COMP_NM, FUND.F_NAME, SUM(FUND_TRANS_HB.NO_SHARE) AS NO_OF_SHARE, "); sbMst.Append("SUM(FUND_TRANS_HB.CRT_AFT_COM * FUND_TRANS_HB.NO_SHARE) AS COST_PRICE, "); sbMst.Append("ROUND(SUM(FUND_TRANS_HB.CRT_AFT_COM * FUND_TRANS_HB.NO_SHARE) / SUM(FUND_TRANS_HB.NO_SHARE), 2) "); sbMst.Append("AS COST_RATE, SUM(FUND_TRANS_HB.AMT_AFT_COM) AS TOTAL_AMT_AFT_COM, ROUND(SUM(FUND_TRANS_HB.AMT_AFT_COM) "); sbMst.Append("/ SUM(FUND_TRANS_HB.NO_SHARE), 2) AS TRANSACTION_RATE, ROUND(SUM(FUND_TRANS_HB.AMT_AFT_COM) "); sbMst.Append("- SUM(FUND_TRANS_HB.CRT_AFT_COM * FUND_TRANS_HB.NO_SHARE), 2) AS PROFIT_LOSS, "); sbMst.Append("decode(FUND_TRANS_HB.TRAN_TP, 'B', 'Report for Bonus Shares', 'C', 'Report for Purchase Shares', 'S', 'STATEMENT OF PROFIT ON SALE OF INVESTMENT', 'R', 'Report for Right Shares', 'I', 'Report for IPO Shares') AS TRAN_TYPE, "); sbMst.Append("SECT_MAJ.SECT_MAJ_CD, SECT_MAJ.SECT_MAJ_NM "); sbMst.Append("FROM FUND INNER JOIN "); sbMst.Append("FUND_TRANS_HB ON FUND.F_CD = FUND_TRANS_HB.F_CD INNER JOIN "); sbMst.Append("COMP ON FUND_TRANS_HB.COMP_CD = COMP.COMP_CD INNER JOIN "); sbMst.Append(" SECT_MAJ ON COMP.SECT_MAJ_CD = SECT_MAJ.SECT_MAJ_CD "); sbMst.Append("WHERE (FUND_TRANS_HB.VCH_DT BETWEEN '" + fromDate.ToString() + "' AND '" + toDate.ToString() + "') "); if (String.Compare(bdf.ToString(), "no", true) == 0) { sbMst.Append(" AND FUND.F_cd <>17 "); } if (transType != "0") { sbMst.Append(" AND (FUND_TRANS_HB.TRAN_TP ='" + transType.ToString() + "')"); } if (fundCode != "0") { sbMst.Append(" AND (FUND_TRANS_HB.F_CD =" + Convert.ToInt16(fundCode.ToString()) + ")"); } if (companyCode != "0") { sbMst.Append(" AND (FUND_TRANS_HB.COMP_CD =" + Convert.ToInt16(companyCode.ToString()) + ")"); } sbMst.Append(" GROUP BY COMP.COMP_NM, FUND_TRANS_HB.TRAN_TP, FUND.F_NAME, FUND.F_CD, SECT_MAJ.SECT_MAJ_CD, SECT_MAJ.SECT_MAJ_NM "); sbMst.Append(" ORDER BY SECT_MAJ.SECT_MAJ_NM, COMP.COMP_NM, FUND.F_CD "); sbMst.Append(sbfilter.ToString()); dtReprtSource = commonGatewayObj.Select(sbMst.ToString()); if (dtReprtSource.Rows.Count > 0) { dtReprtSource.TableName = "CompanyWiseFundTransactionReport"; //dtReprtSource.WriteXmlSchema(@"F:\PortfolioManagementSystem\UI\ReportViewer\Report\crtCompanyWiseFundTransaction_sale.xsd"); //ReportDocument rdoc = new ReportDocument(); string Path = ""; if (string.Compare(transType, "S", true) == 0) { if (string.Compare(fundCode, "0", true) != 0) { Path = Server.MapPath("Report/crtCompanyWiseFundTransaction_sale_indvidual_fund.rpt"); } else { Path = Server.MapPath("Report/crtCompanyWiseFundTransaction_sale.rpt"); } } else { if (string.Compare(fundCode, "0", true) != 0) { Path = Server.MapPath("Report/crtCompanyWiseFundTransaction_without_sale_individual_fund.rpt"); } else { Path = Server.MapPath("Report/crtCompanyWiseFundTransaction_without_sale.rpt"); } } rdoc.Load(Path); rdoc.SetDataSource(dtReprtSource); CRV_CompanyWiseTransaction.ReportSource = rdoc; rdoc.SetParameterValue("prmFromDate", fromDate); rdoc.SetParameterValue("prmToDate", toDate); CRV_CompanyWiseTransaction.DisplayToolbar = true; CRV_CompanyWiseTransaction.HasExportButton = true; CRV_CompanyWiseTransaction.HasPrintButton = true; rdoc = ReportFactory.GetReport(rdoc.GetType()); } else { Response.Write("No Data Found"); } }
public static IReportInfo EmployeeProfile(Employee employee) { return(GetReportInfo(EmployeeEvaluationsPrintModeViewModel.Create(), p => employee == null ? null : ReportFactory.EmployeeProfile(employee, p.EmployeeEvaluationsPrintMode != EmployeeEvaluationsPrintMode.ExcludeEvaluations))); }
protected void generateReport(int pessoaID, String langCode) { String DestinationReportsPath; String TemplateReportsPath; Projecto p = Projecto.getProjectoID(Utility.currProjeto.ProjectoID, ""); Pessoa self = Pessoa.getPessoa(pessoaID, Utility.currProjeto.owner); Ticket ticket; String selfStrCode = getAAGroupCode(); if (langCode != "") p.traslateTo(langCode); if (Utility.currProjeto.GroupsCodes.Length >= 1) { ticket = Ticket.getAllTicketsAvaliado(pessoaID, p.ProjectoID, p.owner).First(); } else ticket = Ticket.getAllTicketsAvaliado(pessoaID, p.ProjectoID, p.owner).First(a => a.Qualidade == selfStrCode); ReportFactory report; // analisar os templates disponíveis. String DocProcessor; //assumimos que os tempaltes são custom DestinationReportsPath = getCurrentProjectPath(); TemplateReportsPath = DestinationReportsPath + "\\docTemplates"; if ((DocProcessor = ReportHelper.getCustomDocProcessor(TemplateReportsPath, p)) == "NO_TEMPLATE") // ve se tem templates { // se não tem templates, então vamos buscar os templates standard TemplateReportsPath = Request.PhysicalApplicationPath + "docTemplates"; DocProcessor = ReportHelper.getDocProcessor(TemplateReportsPath, p); } if ((DocProcessor != null) && (DocProcessor != "")) { if (DocProcessor != "Standard") { // create an instance of the class from the assembly Assembly assembly = Assembly.Load("QtoolsReportGenerators"); IReportGenerator rep = (IReportGenerator)assembly.CreateInstance("QtoolsReportGenerators." + DocProcessor.Trim() + "Report"); if (rep.GenerateReport(TemplateReportsPath, DestinationReportsPath, DateTime.Now, self, ticket, p, Guid.NewGuid().ToString().Replace("-", ""))) { // multiViewPanels.ActiveViewIndex = 3; // se chegou aqui está tudo OK } else { // deveria avisar que ocorreu um erro e que erro foi! } } else { p.traslateTo(langCode); report = new ReportFactory(TemplateReportsPath, DestinationReportsPath, DateTime.Now, self, ticket, p, ticket.Chave, langCode); report.asyncStart(); } } else { report = new ReportFactory(TemplateReportsPath, DestinationReportsPath, DateTime.Now, self, ticket, p, ticket.Chave, langCode); report.asyncStart(); } }
public static ReportGroupingFactory NewReportGroupingFactory(string path, ReportFactory reportFactory) { return(new Xml.XmlReportGroupingFactory(path, reportFactory)); }