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; } }