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); }
public static TokoBeDiaEntities GetInstance() { if (db == null) { db = new TokoBeDiaEntities(); } return(db); }