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));
}
