private ReportDataset GetData()
{
ReportDataset dataset = new ReportDataset();
ReportDataset.HeaderTransactionDataTable headerTable = dataset.HeaderTransaction;
ReportDataset.DetailTransactionDataTable detailTable = dataset.DetailTransaction;
List <Header_Transaction> headerTransactions = TransactionController.GetHeaderTransactions();
foreach (Header_Transaction ht in headerTransactions)
{
DataRow headerRow = headerTable.NewRow();
headerRow["TransactionID"] = ht.ID;
headerRow["Username"] = ht.User.Name;
headerRow["PaymentType"] = ht.PaymentType.Type;
headerRow["Date"] = ht.Date;
headerTable.Rows.Add(headerRow);
foreach (Detail_Transaction dt in ht.Detail_Transactions)
{
DataRow detailRow = detailTable.NewRow();
detailRow["ProductName"] = dt.Product.Name;
detailRow["ProductPrice"] = dt.Product.Price;
detailRow["Quantity"] = dt.Quantity;
detailRow["TransactionID"] = dt.TransactionID;
detailTable.Rows.Add(detailRow);
}
}
return(dataset);
}
private ReportDataset GetData()
{
ReportDataset dataset = new ReportDataset();
ReportDataset.HeaderTransactionDataTable headerTable = dataset.HeaderTransaction;
ReportDataset.DetailTransactionDataTable detailTable = dataset.DetailTransaction;
TokoBeDiaEntities db = new TokoBeDiaEntities();
foreach (HeaderTransaction ht in db.HeaderTransactions)
{
DataRow headerRow = headerTable.NewRow();
headerRow["Id"] = ht.Id;
headerRow["Email"] = ht.User.Email;
headerRow["Date"] = ht.Date;
headerRow["PaymentType"] = ht.PaymentType.Type;
headerTable.Rows.Add(headerRow);
foreach (DetailTransaction dt in ht.DetailTransactions)
{
DataRow detailRow = detailTable.NewRow();
detailRow["TransactionId"] = dt.TransactionId;
detailRow["ProductName"] = dt.Product.Name;
detailRow["ProductPrice"] = dt.Product.Price;
detailRow["Quantity"] = dt.Quantity;
detailTable.Rows.Add(detailRow);
}
}
return(dataset);
}