//get order data by selecting OrderID private void GetOrder(int orderID) { try { order = OrderDB.GetOrder(orderID);//retrieve Order data from database } catch (Exception ex) { MessageBox.Show(ex.Message, ex.GetType().ToString()); } }
//create meathod to load orderId in combobox private void LoadOrderIDComboBox() { List <OrderId> orderId = new List <OrderId>(); //empty list try { orderId = OrderDB.GetOrderIds(); cbOrderID.DataSource = orderId; cbOrderID.DisplayMember = "OrderID"; cbOrderID.ValueMember = "OrderID"; } catch (Exception ex) { MessageBox.Show(ex.Message, ex.GetType().ToString()); } }
public Order order;//order data //update order data by modifying shippedDate private void btnAccept_Click(object sender, EventArgs e) { Order newOrder = new Order(); newOrder.OrderID = order.OrderID; newOrder.CustomerID = order.CustomerID; newOrder.OrderDate = order.OrderDate; newOrder.RequiredDate = order.RequiredDate; this.PutOrderData(newOrder); if (Validator.IsNull(newOrder.ShippedDate) && Validator.IsNull(newOrder.RequiredDate) && Validator.IsNull(newOrder.OrderDate))//date values are not null { if ((Validator.CompareTo(newOrder.ShippedDate, newOrder.OrderDate) == 1 || Validator.CompareTo(newOrder.ShippedDate, newOrder.OrderDate) == 0) && (Validator.CompareTo(newOrder.ShippedDate, newOrder.RequiredDate) == 0 || Validator.CompareTo(newOrder.ShippedDate, newOrder.RequiredDate) == -1))//new value for ShippedDate is not earlier than OrderDate and no later than RequiredDate { try { if (!OrderDB.UpdateOrder(order, newOrder)) { MessageBox.Show("Another user has updated or " + "deleted that customer.", "Database Error"); this.DialogResult = DialogResult.Retry; } else { order = newOrder; this.DialogResult = DialogResult.OK; } } catch (Exception ex) { MessageBox.Show(ex.Message, ex.GetType().ToString()); } } else //new value for ShippedDate is earlier than OrderDate or later than RequiredDate { MessageBox.Show("Make sure that the new value for ShippedDate is not earlier than OrderDate and no later than RequiredDate"); } } else //date values have null values { try { if (!OrderDB.UpdateOrder(order, newOrder)) { MessageBox.Show("Another user has updated or " + "deleted that customer.", "Database Error"); this.DialogResult = DialogResult.Retry; } else { order = newOrder; this.DialogResult = DialogResult.OK; } } catch (Exception ex) { MessageBox.Show(ex.Message, ex.GetType().ToString()); } } }