private void btnOk_Click(object sender, EventArgs e)
{
//if validation
Order newupdateOrder = new Order();
newupdateOrder.OrderID = updateOrder.OrderID;
newupdateOrder.CustomerID = updateOrder.CustomerID;
newupdateOrder.OrderDate = updateOrder.OrderDate;
newupdateOrder.RequiredDate = updateOrder.RequiredDate;
if (txtUpdateShipDate.Text == "")
{
newupdateOrder.ShippedDate = null;
try
{
if (!OrdersDB.UpdateOrder(updateOrder, newupdateOrder))
{
MessageBox.Show("Recorder has been updated or deleted by another user!");
this.DialogResult = DialogResult.Retry;
}
else
{
this.DialogResult = DialogResult.OK;
updateOrder = newupdateOrder;
}
}
catch (Exception ex)
{
throw ex;
}
}
else if (validation.IsDateTime(txtOrderDate) && validation.IsDateTime(txtReqiuredDate) && validation.IsDateTime(txtUpdateShipDate) && validation.IsEarlyOrder(Convert.ToDateTime(txtReqiuredDate.Text), Convert.ToDateTime(txtUpdateShipDate.Text)) && validation.IsLateOrder(Convert.ToDateTime(txtOrderDate.Text), Convert.ToDateTime(txtUpdateShipDate.Text)))
{
// newupdateOrder.ShippedDate = DateTime.ParseExact(txtUpdateShipDate.Text, "MM-dd-yyyy", System.Globalization.CultureInfo.InvariantCulture, System.Globalization.DateTimeStyles.None); ;
newupdateOrder.ShippedDate = Convert.ToDateTime(txtUpdateShipDate.Text);
try
{
if (!OrdersDB.UpdateOrder(updateOrder, newupdateOrder))
{
MessageBox.Show("Recorder has been updated or deleted by another user!");
this.DialogResult = DialogResult.Retry;
}
else
{
this.DialogResult = DialogResult.OK;
updateOrder = newupdateOrder;
}
}
catch (Exception ex)
{
throw ex;
}
}
}
private void OrderMaintenance_Load(object sender, EventArgs e)
{ //initialize the text box
txtCustomerID.Enabled = false;
txtOrderDate.Enabled = false;
txtRequiredDate.Enabled = false;
txtShippedDate.Enabled = false;
txtTotalCharge.Enabled = false;
List <int> orderId = new List <int>(); //empty list
try
{
orderId = OrdersDB.GetAllOrderID(); //get all orderID from TABLE order
cmbOrderID.DataSource = orderId; //set all of orderID to combox to list them
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, ex.GetType().ToString());
}
}
private void cmbOrderID_SelectedIndexChanged(object sender, EventArgs e)//select ORDERID and dispaly all of info related to it
{
order1 = new Order();
List <OrderDetail> orderDetails = new List <OrderDetail>();
order1 = OrdersDB.GetOrder(Convert.ToInt32(cmbOrderID.Text));//get specific ORDER recorder and return it to order1
//need display method
OrderDisplay(); //display order info
orderDetails = OrderDetailsDB.GetRelativeDetails(order1.OrderID); //get related orderdetails info from TABLE order details
dgvOrderDetail.DataSource = orderDetails; //set gridviewer datasource equals to orderdetails and display it
if (orderDetails.Count > 0) //there are relative details
{
//call summary of total charges from order details in TABLE ORDER DETAILS
txtTotalCharge.Text = OrderDetailsDB.GetTotalCharge(order1.OrderID).ToString("c");
}
else
{
txtTotalCharge.Text = null;
}
}
