protected void Page_Load(object sender, EventArgs e)
        {
            TransactionReport newTransRep = new TransactionReport();

            CrystalReportViewer1.ReportSource = newTransRep;
            newTransRep.SetDataSource(GenerateData(TransactionReportController.GetTransaction()));
        }
        private ReportDataset GenerateData(List <HeaderTransaction> listTransaction)
        {
            ReportDataset newDataset        = new ReportDataset();
            var           HeaderTransaction = newDataset.HeaderTransaction;
            var           DetailTransaction = newDataset.DetailTransaction;

            for (int i = 0; i < listTransaction.Count; i++)
            {
                var ht         = listTransaction.ElementAt(i);
                int grandTotal = 0;
                for (int j = 0; j < TransactionReportController.getDetailTransaction(ht.TransactionID).Count; j++)
                {
                    var dt                   = TransactionReportController.getDetailTransaction(ht.TransactionID).ElementAt(j);
                    int subTotal             = (dt.Quantity * dt.Product.ProductPrice);
                    var DetailTransactionRow = DetailTransaction.NewRow();
                    DetailTransactionRow["TransactionID"] = dt.TransactionID;
                    DetailTransactionRow["ProductName"]   = dt.Product.ProductName;
                    DetailTransactionRow["Qty"]           = dt.Quantity;
                    DetailTransactionRow["Price"]         = dt.Product.ProductPrice;
                    DetailTransactionRow["Subtotal"]      = subTotal;
                    DetailTransaction.Rows.Add(DetailTransactionRow);
                    grandTotal += subTotal;
                }
                var HeaderTransactionRow = HeaderTransaction.NewRow();
                HeaderTransactionRow["TransactionID"]   = ht.TransactionID;
                HeaderTransactionRow["UserName"]        = ht.User.UName;
                HeaderTransactionRow["TransactionDate"] = ht.TransactionDate;
                HeaderTransactionRow["GrandTotal"]      = grandTotal;
                HeaderTransaction.Rows.Add(HeaderTransactionRow);
            }

            return(newDataset);
        }
 protected void Page_Load(object sender, EventArgs e)
 {
     if (!TransactionReportController.isUserPermittedToAccess())
     {
         userWarnLbl.Text  = "You're not authorized to access this page. Please login as admin!";
         logoutBtn.Visible = false;
     }
     else
     {
         TransactionReporting newReport = new TransactionReporting();
         ReportViewer.ReportSource = newReport;
         newReport.SetDataSource(GenerateData(TransactionReportController.getTransactionData()));
     }
 }
Example #4
0
        private void LoadReport(CrystalReport1 report)
        {
            DataSet1 dataset = TransactionReportController.getTransactionReportDataSet();

            report.SetDataSource(dataset);
        }