//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());
}
}
}
