public static DataSet1 getTransactionReportDataSet() { DataSet1 dataset = new DataSet1(); var headerTransaction = dataset.HeaderTransaction; var detailTransaction = dataset.DetailTransaction; List <HeaderTransaction> header = TransactionReportHandler.getAllHeaderTransaction(); foreach (HeaderTransaction h in header) { var row = headerTransaction.NewRow(); row["TransactionID"] = h.TransactionID; row["TransactionDate"] = h.Date; row["UserID"] = h.UserID; row["PaymentTypeID"] = h.PaymentTypeID; headerTransaction.Rows.Add(row); List <DetailTransaction> details = TransactionReportHandler.getDetailTransaction(h.TransactionID); foreach (DetailTransaction d in details) { var rowDetail = detailTransaction.NewRow(); rowDetail["TransactionID"] = d.TransactionID; rowDetail["ProductID"] = d.ProductID; rowDetail["ProductName"] = d.Product.Name; rowDetail["ProductPrice"] = d.Product.Price; rowDetail["Quantity"] = d.Quantity; rowDetail["SubTotal"] = d.Quantity * d.Product.Price; detailTransaction.Rows.Add(rowDetail); } } return(dataset); }
public static List <TransactionReportModel> getAllReportData() { return(TransactionReportHandler.getAllReportData()); }
public static string GetTransactions1() { return(JsonHelper.Serialize(TransactionReportHandler.GetTransactions())); }