private void buttonOrdUpdate_Click(object sender, EventArgs e)
        {
            if (!Validator.IsEmpty(textBoxOrdQuantity))
            {
                MessageBox.Show("Orders must have a valid quantity.", "Validation Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
                textBoxAutID.Clear();
                textBoxAutID.Focus();
                return;
            }

            Order aorder = createOrder();
            Order xorder = OrderDA.SearchByNumber(Convert.ToInt32(textBoxOrdNumber.Text));

            Books   abook   = BooksDA.SearchByTitle(comboBoxOrdProduct.Text);
            Clients aclient = ClientsDA.Search(comboBoxOrdClient.Text);

            abook.QOH = (abook.QOH + xorder.OrdQuantity) - aorder.OrdQuantity;
            BooksDA.Update(abook);

            aclient.creditLimit = (aclient.creditLimit + aorder.OrdTotal) - aorder.OrdTotal;
            ClientsDA.Update(aclient);

            OrderDA.Update(aorder);
            OrderDA.ListOrder(listViewOrd);

            buttonOrdList.PerformClick();
            UpdateComboBoxes();
        }
示例#2
0
 private void buttonUpdateBook_Click(object sender, EventArgs e)
 {
     if ((textBoxTitle.Text == "") || (textBoxAuthor.Text == "") || (textBoxYearPublished.Text == "") || (textBoxQOH.Text == "") || (textBoxUnitPrice.Text == ""))
     {
         MessageBox.Show("Please fill all the fields ", "Missing Data");
         textBoxISBN.Clear();
         textBoxISBN.Focus();
         return;
     }
     else
     {
         Books book = new Books();
         book.ISBN              = Convert.ToInt32(textBoxISBN.Text);
         book.Title             = textBoxTitle.Text;
         book.BookAuthor        = textBoxAuthor.Text;
         book.BookYearPublished = textBoxYearPublished.Text;
         book.BookQOH           = Convert.ToInt32(textBoxQOH.Text);
         book.BookUnitePrice    = Convert.ToInt32(textBoxUnitPrice.Text);
         DialogResult ans = MessageBox.Show("Do you really want to update this Book information?", "Confirmation", MessageBoxButtons.YesNo, MessageBoxIcon.Information);
         if (ans == DialogResult.Yes)
         {
             BooksDA.Update(book);
             MessageBox.Show("Book record has been updated successfully", "Confirmation");
         }
         textBoxNamePublisher.Enabled = true;
         ClearAll2();
     }
 }
        private void buttonOrdPlaceOrder_Click(object sender, EventArgs e)
        {
            //Order Validators
            if (!Validator.IsEmptyComboBox(comboBoxOrdClient))
            {
                MessageBox.Show("Order must have a valid Client.", "Validation Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
                textBoxAutID.Clear();
                textBoxAutID.Focus();
                return;
            }

            if (!Validator.IsEmptyComboBox(comboBoxOrdProduct))
            {
                MessageBox.Show("Order must have a valid Product.", "Validation Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
                textBoxAutID.Clear();
                textBoxAutID.Focus();
                return;
            }

            if (!Validator.IsEmpty(textBoxOrdQuantity))
            {
                MessageBox.Show("Orders must have a valid quantity.", "Validation Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
                textBoxAutID.Clear();
                textBoxAutID.Focus();
                return;
            }

            int temp = 0;

            if ((!int.TryParse((textBoxOrdQuantity.Text), out temp)))
            {
                MessageBox.Show("Quantity of Products must be a integer number.", "Validation Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
                textBoxOrdQuantity.Clear();
                textBoxOrdQuantity.Focus();
                return;
            }

            Order   aOrder  = createOrder();
            Books   aBook   = BooksDA.SearchByTitle(comboBoxOrdProduct.Text);
            Clients aClient = ClientsDA.Search(comboBoxOrdClient.Text);

            aBook.QOH = aBook.QOH - aOrder.OrdQuantity;
            BooksDA.Update(aBook);

            aClient.creditLimit = aClient.creditLimit - aOrder.OrdTotal;
            ClientsDA.Update(aClient);

            OrderDA.SaveOrder(aOrder);
            buttonOrdList.PerformClick();
            UpdateComboBoxes();
        }
        private void buttonBooUpdate_Click(object sender, EventArgs e)
        {
            Books aBook = new Books();

            aBook.ISBN          = Convert.ToInt32(textBoxBooISBN.Text);
            aBook.title         = textBoxBooTitle.Text;
            aBook.author        = comboBoxBooAuthor.Text;
            aBook.yearPublished = textBoxBooYPublished.Text;
            aBook.unitPrice     = Convert.ToDecimal(textBoxBooPrice.Text);
            aBook.QOH           = Convert.ToInt32(textBoxBooQOH.Text);
            aBook.publisher     = comboBoxBooSuplier.Text;
            DialogResult ans = MessageBox.Show("Do you really want to update this Book?", "Confirmation", MessageBoxButtons.YesNo, MessageBoxIcon.Information);

            if (ans == DialogResult.Yes)
            {
                BooksDA.Update(aBook);
                MessageBox.Show("Book record has been updated successfully", "Confirmation");
                ClearAllBoo();
                UpdateComboBoxes();
                buttonBooList.PerformClick();
            }
        }