コード例 #1
0
        private void Form1_Load(object sender, EventArgs e)
        {
            List <Order> ord = new List <Order>();

            ord = OrderDB.GetOrders();
            orderBindingSource.DataSource = ord;
        }
コード例 #2
0
ファイル: OrderForm.cs プロジェクト: Hoorasadat/Lab-4
        // method for getting data for the orders and displaying orders
        private void DisplayOrders()
        {
            List <Order> ord = new List <Order>();

            try
            {
                ord = OrderDB.GetOrders();
                orderBindingSource.DataSource = ord;
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message, ex.GetType().ToString());
            }
        }
コード例 #3
0
 private void btnSaveDate_Click(object sender, EventArgs e)
 {
     try
     {
         OrderDB.SaveShippedDate(orders[recordIndex], tmpDate); // call the Save method
         orders = OrderDB.GetOrders();                          // reload the orders list
         LoadOrders(recordIndex);                               // redisplay the information based on the current record
         btnSaveDate.Enabled = false;                           // disable the button as we are done this operation
     }
     catch (Exception ex)
     {
         MessageBox.Show(ex.ToString());
     }
 }
コード例 #4
0
ファイル: OrderForm.cs プロジェクト: Hoorasadat/Lab-4
        // method for getting data for an order
        private Order GetOrder(int orderId)
        {
            Order ord = null;

            try
            {
                ord = new Order();
                ord = OrderDB.GetOrder(orderId);
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message, ex.GetType().ToString());
            }
            return(ord);
        }
コード例 #5
0
 /// <summary>
 /// Method to refresh the list in any situation where it's needed
 /// </summary>
 private void RefreshList()
 {
     try
     {
         orders = OrderDB.GetOrders();                       // get an updated list of orders from the database
         dgvOrders.DataSource = orders;                      // put it in the data grid view
         dgvOrders.Columns[2].DefaultCellStyle.Format = "d"; // set the date columns to short date format
         dgvOrders.Columns[3].DefaultCellStyle.Format = "d";
         dgvOrders.Columns[4].DefaultCellStyle.Format = "d";
     }
     catch (Exception ex)
     {
         MessageBox.Show("Error loading the order list: " + ex.Message, ex.GetType().ToString());
     }
 }
コード例 #6
0
ファイル: UpdateForm.cs プロジェクト: Hoorasadat/Lab-4
        // if the user confirm the changes
        private void btnConfirm_Click(object sender, EventArgs e)
        {
            // check if the new shipped date is valid (in range) or it is null
            if (IsValidData(DTPShippedDate) || (DTPShippedDate.Value == null))
            {
                // creating a new order and setting its properties
                Order newOrder = new Order();
                GetNewOrder(newOrder);

                // if the user wants to delete the shipped date
                if (delete == true)
                {
                    newOrder.ShippedDate = null;
                }
                else
                {
                    // the new order has a different shipped date
                    newOrder.ShippedDate = Convert.ToDateTime(DTPShippedDate.Value);
                }

                // try to update data in the database
                try
                {
                    if (!OrderDB.UpdateOrder(newOrder, order))
                    {
                        MessageBox.Show("Another user has updated or " +
                                        "deleted that customer.", "Database Error");
                        this.DialogResult = DialogResult.Retry;
                    }
                    else // successfully updated
                    {
                        order.ShippedDate = newOrder.ShippedDate;
                        this.DialogResult = DialogResult.OK;
                    }
                }
                catch (Exception ex)
                {
                    MessageBox.Show(ex.Message, ex.GetType().ToString());
                }
            }
        }
コード例 #7
0
        /// <summary>
        /// Save changes to the shipping date for this order
        /// </summary>
        private void btnSave_Click(object sender, EventArgs e)
        {
            // first, have to check if the date is null or invalid (treat as null) before trying to parse it
            DateTime newDate;  // somewhere to put the result
            bool     parseResult = DateTime.TryParse(txtShippedDate.Text, out newDate);

            if (parseResult) // if the parse was successful (it's a legitimate date), compare against the other dates to make sure it's between them
            {
                if ((CurrentOrder.OrderDate != null && CurrentOrder.OrderDate > newDate) || (CurrentOrder.RequiredDate != null && CurrentOrder.RequiredDate < newDate))
                {
                    MessageBox.Show("Shipping Date must be later than order date and earlier than Required date"); // notify the user
                    txtShippedDate.Text = "";                                                                      // clear out the bad date and focus the field for correction
                    txtShippedDate.Focus();
                    return;                                                                                        // break out of this method entirely so they can fix it
                }
            }
            try
            {
                if (parseResult) // if the parse worked (and it was in the correct range), send the new date
                {
                    OrderDB.UpdateOrder(CurrentOrder, newDate);
                }
                else // if it's blank or isn't a date
                {
                    OrderDB.UpdateOrder(CurrentOrder, null);
                }

                // if we're still here and nothing messed up, close this and go back to the order list
                DialogResult = DialogResult.OK;
                this.Close();
            }
            catch (Exception ex)
            {
                MessageBox.Show("Error saving shipping date: " + ex.Message, ex.GetType().ToString());
            }
        }
コード例 #8
0
 private void Form1_Shown(object sender, EventArgs e)
 {
     orders = OrderDB.GetOrders(); // populate the list with all the orders from the DB
     LoadOrders(recordIndex);      // set Form controls with the first order entity information
 }