protected DataSet GetData(int sellerId)
{
// Harusnya munculin cuma show yang dijual sama si seller
List <Show> shows = ShowController.GetShowBySellerId(sellerId);
DataSet dataset = new DataSet();
var dataset_shows = dataset.Show;
var dataset_transaction_headers = dataset.TransactionHeader;
var dataset_transaction_details = dataset.TransactionDetail;
var dataset_users = dataset.User;
foreach (var show in shows)
{
var newShowRow = dataset_shows.NewRow();
newShowRow["Id"] = show.Id;
newShowRow["Name"] = show.Name;
dataset_shows.Rows.Add(newShowRow);
List <TransactionHeader> headers = TransactionController.GetAllTransactionHeaderByShowId(show.Id);
foreach (var header in headers)
{
var newHeaderRow = dataset_transaction_headers.NewRow();
newHeaderRow["ShowId"] = header.ShowId;
newHeaderRow["BuyerId"] = header.BuyerId;
newHeaderRow["CreatedAt"] = header.CreatedAt;
List <TransactionDetail> details = TransactionController.GetAllTransactionDetailById(header.Id);
newHeaderRow["Quantity"] = details.Count;
newShowRow["Price"] = show.Price * details.Count;
User user = UserController.GetUserById(header.BuyerId);
newHeaderRow["BuyerName"] = user.Name;
dataset_transaction_headers.Rows.Add(newHeaderRow);
}
}
return(dataset);
}