private void BtnOverview_Click(object sender, EventArgs e) { string[] columns = new string[] { "OrderId", "StaffName", "CustomerName", "CardNumber", "OrderPaid", "OrderAddress", "OrderDate", "StockName", "StockQuantity" }; string CustomerOrderId = LblOrderID.Text; string staffId; string customerId; string cardId; string orderPaid; string orderAddress; string OrderDate; if (newOrder) { if (EmptyFields()) { return; } staffId = (CbxStaffID.SelectedItem as Container).Id; customerId = (CbxCustomerID.SelectedItem as Container).Id; cardId = (CbxCardID.SelectedItem as Container).Id; orderPaid = CbxOrderPaid.Checked.ToString(); orderAddress = TbxOrderAddress.ToString(); OrderDate = DtpOrderDate.Value.ToString(); } else { //NEED TO PASS IN CUSTOMER ORDER ID AND USE IN QUERY FrmCustomerOrderReport report = new FrmCustomerOrderReport(CustomerOrderId); report.Show(); return; } FrmOverview overview = new FrmOverview(columns); overview.Show(); string staffName = Staff.GetData(new string[] { staffId }, new string[] { "StaffName" })[0]; string customerName = Customer.GetData(new string[] { customerId }, new string[] { "CustomerName" })[0]; string cardNumber = Card.GetData(new string[] { cardId }, new string[] { "CardNumber" })[0]; for (int i = 0; i < StockIdToAdd.Count; i++) { string stockName = Stock.GetData(new string[] { StockIdToAdd[i] }, new string[] { "StockName" })[0]; overview.Add(new string[] { CustomerOrderId, staffName, customerName, cardNumber, orderPaid, orderAddress, OrderDate, stockName, QuantityToAdd[i] }); } }
private void BtnOverview_Click(object sender, EventArgs e) { string[] columns = new string[] { "StockOrderId", "StaffName", "StockOrderDate", "StockName", "StockQuantity" }; string StockOrderId = LblStockOrderID.Text; string staffId; string staffName; string stockOrderDate; if (newOrder) { if (EmptyFields()) { return; } staffId = (CbxStaffID.SelectedItem as Container).Id; staffName = Staff.GetData(new string[] { staffId }, new string[] { "StaffName" })[0]; stockOrderDate = DtpStockOrderDate.Value.ToString(); } else { //NEED TO PASS IN STOCK ORDER ID AND USE IN QUERY FrmStockOrderReport report = new FrmStockOrderReport(StockOrderId); report.Show(); return; } FrmOverview overview = new FrmOverview(columns); overview.Show(); for (int i = 0; i < StockIdToAdd.Count; i++) { string stockName = Stock.GetData(new string[] { StockIdToAdd[i] }, new string[] { "StockName" })[0]; overview.Add(new string[] { StockOrderId, staffName, stockOrderDate, stockName, QuantityToAdd[i] }); } }