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