public void button2_Click(object sender, EventArgs e) // Retrieve Button on click event { // selecting or typing a valid order id and displaying the results try { int orderID = Convert.ToInt32(cborderId.Text); Orders myOrder = OrdersDB.GetOrders(orderID); List <OrderDetails> myOrderDetails = OrderDetailsDB.GetOrderDetails(orderID); if (Object.Equals(myOrder, null)) // if ordr id not valid, show the follofing message { MessageBox.Show("No matching Order Id's found, please provide a valid Order ID", "Order ID Error"); } else // else display all the fields and read only order details data grid form { displayOrder(myOrder); displayOrderDetails(myOrderDetails); calculateTotalprice(); } } catch (FormatException) // catching the wrong format order id exception, in case user types an alphabet or anything other than the valid id { MessageBox.Show("Select from the drop down list and Retrieve.", "Input Error"); } }
public void UpdateShipDate(object sender, EventArgs e) // update ship date method { try { // setting the orderid to accept null values by using nullable datetime values int orderID = Convert.ToInt32(cborderId.Text); DateTime?NewShippedDate; if (String.IsNullOrEmpty(txtShipDate.Text)) { NewShippedDate = null; } else { NewShippedDate = DateTime.Parse(txtShipDate.Text); } // adding validation for new shipped date to be between order date and requird date DateTime?RequiredDate = Convert.ToDateTime(txtReqDate.Text); DateTime?Orderdate = Convert.ToDateTime(txtOrderDate.Text); if (RequiredDate >= NewShippedDate && Orderdate <= NewShippedDate) { OrdersDB.UpdateShippingDate(NewShippedDate, orderID); // method to update shipping value MessageBox.Show("Shipped Date Updated", "Update"); } else if (RequiredDate < NewShippedDate) { MessageBox.Show("Shipped Date can not be ahead of Required Date.", "Date Error"); Form1_Load(sender, e); } else if (Orderdate > NewShippedDate) { MessageBox.Show("Shipped Date can not be earlier than the Order Date", "Date Error"); } else if (NewShippedDate == null) //method to update new shipped date with null values { OrdersDB.UpdateShippingDate(orderID); // using the same method name with different signatures MessageBox.Show("Null value Added.", "Null Value"); } else { MessageBox.Show("Shipped Date not acceptable.", "Incorrect Syntax"); } } catch (FormatException) // catching the shipped date format exception incase it's in a wrong format { MessageBox.Show("Select from the drop down list and Retrieve. Use the correct format for date MM/DD/YYYY.", "Input Error"); } }