Example #1
0
        // ------------Added by Wei Guang Yan----------------
        // Method of inserting suplier's name to database
        public void AddSupplier(string txtAdd)
        {
            // Innitialize for messagebox
            string            message;
            string            title  = "New Product Insert";
            MessageBoxButtons button = MessageBoxButtons.OK;
            MessageBoxIcon    icon;

            // Generate new supplier Id based on max id in database
            int id = SuppliersDB.GetMaxId() + 1;

            // Add new item to database
            bool flag = SuppliersDB.AddSupplier(id, txtAdd);

            // Check whether adding excution is successful, and show message
            if (flag == true)
            {
                comboBox2.DataSource    = SuppliersDB.GetSuppliers();
                comboBox2.DisplayMember = "SupName";
                comboBox2.ValueMember   = "SupplierId";
                comboBox2.SelectedIndex = comboBox2.Items.Count - 1;
                txtAddItem.Text         = "";
                message = "The supplier is added successfully!";
                icon    = MessageBoxIcon.None;
            }
            else
            {
                message = "Error: Fail to add new supplier!\n Please try again or contact IT supports.";
                icon    = MessageBoxIcon.Error;
            }
            MessageBox.Show(message, title, button, icon);
        }
Example #2
0
        private void btnSaveSupp_Click(object sender, EventArgs e)
        {
            try
            {
                if (Validator.IsPresent(txtNewSupp, "New Supplier Name"))
                {
                    Suppliers newSupplier = new Suppliers();

                    newSupplier.SupName = txtNewSupp.Text;

                    newSupplier.SupplierId = AllSuppliers.Max(s => s.SupplierId) + 1;

                    if (SuppliersDB.AddSupplier(newSupplier))
                    {
                        MessageBox.Show("Supplier has been updated :)");
                        UpdateAllInfos();
                        suppliersDataGridView.DataSource = AllSuppliers;
                    }
                }
            }
            //catch the other error and show the ex error message from db class
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message, ex.GetType().ToString());
            }
        }
Example #3
0
        private void btnAdd_Click(object sender, EventArgs e)
        {
            if (IsValidData())
            {
                if (addsupplier) // processing Add
                {
                    supplier = new Suppliers();
                    this.PutSupplier(supplier);

                    try
                    {
                        supplier.SupplierId = SuppliersDB.AddSupplier(supplier);
                        this.DialogResult   = DialogResult.OK;
                    }
                    catch (Exception ex)
                    {
                        MessageBox.Show(ex.Message, ex.GetType().ToString());
                    }
                }
                else // processing Modify
                {
                    suppliers newSupplier = new suppliers
                    {
                        SupplierId = supplier.SupplierId
                    };
                    this.PutSupplier(newSupplier);

                    try
                    {
                        if (!SuppliersDB.UpdateSupplier(supplier, newSupplier))
                        {
                            MessageBox.Show("Another user has updated or " +
                                            "deleted that  supplier ID.", "Database Error");
                            this.DialogResult = DialogResult.Retry;
                        }
                        else
                        {
                            supplier          = newSupplier;
                            this.DialogResult = DialogResult.OK;
                        }
                    }
                    catch (Exception ex)
                    {
                        MessageBox.Show(ex.Message, ex.GetType().ToString());
                    }
                }
            }
        }
Example #4
0
 private void btnAddSupplier_Click(object sender, EventArgs e)
 {
     supplier = new Suppliers();
     this.PutSupplierData(supplier);
     try
     {
         supplier.SupplierId = SuppliersDB.AddSupplier(supplier);
         MessageBox.Show("Supplier added", "Success!");
         this.DialogResult = DialogResult.OK;
     }
     catch (Exception ex)
     {
         MessageBox.Show(ex.Message, ex.GetType().ToString());
     }
     this.Close();
 }
        private void btnUpdate_Click(object sender, EventArgs e)
        {
            // valid supplier id
            if (!Validator.IsValidSupplierId(supplierId.Text, out string result))
            {
                MessageBox.Show(result, "Supplier Error");
                return;
            }
            // supplier name required as per Jolanta
            if (string.IsNullOrEmpty(supplierName.Text))
            {
                MessageBox.Show("Supplier Name is required.", "Supplier Error");
                return;
            }

            Supplier supplier = new Supplier()
            {
                SupplierId = Int32.Parse(supplierId.Text),
                SupName    = supplierName.Text
            };

            try
            {
                SuppliersDB.AddSupplier(supplier);
                this.DialogResult = DialogResult.OK;
            }
            catch (SqlException ex)
            {
                if (ex.Number == 2627) // supplier id already exists
                {
                    MessageBox.Show("Supplier ID already exists.", "ID Error");
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show("Error while adding supplier.\n\n" + ex.Message,
                                ex.GetType().ToString());
            }
        }
Example #6
0
 //adds the input to the table
 private void AddButton_Click(object sender, EventArgs e)
 {
     if (isValid())
     {
         supp = new Supplier();
         this.buildSupplier(supp);
         try
         {
             if (SuppliersDB.AddSupplier(supp))
             {
                 MessageBox.Show("Supplier added successfully.", "Success");
                 clearContent();
             }
             else
             {
                 MessageBox.Show("Failed to add the suplier. Please try again.", "Database Error");
                 clearContent();
             }
         }
         catch (Exception ex) { MessageBox.Show(ex.Message, ex.GetType().ToString()); }
     }
 }
Example #7
0
        private void btnAdd_Click(object sender, EventArgs e)
        {
            if (Validator.IsPresent(txtSupName))
            //&& !Validator.UserInputDataExists(txtSupName))

            {
                supplier = new Suppliers();

                supplier.SupName = txtSupName.Text;
                // add SupID code ... called ADD function txtSupName.Text = supplier.SupName;
                supplier.SupplierId = SuppliersDB.AddSupplier(supplier);


                LoadComboAndGrid();
            }
            else
            {
                MessageBox.Show("Type in Supplier Name if none exists");
                this.DialogResult = DialogResult.Retry;
            }

            txtSupName.Text = "";
        }
Example #8
0
        private void fourBtnSave_Click(object sender, EventArgs e)
        {
            if (fourTab.SelectedIndex == 1)  // EDIT MODE
            {
                // get current Supplier obj
                var currentSupplier = SuppliersDB.GetSuppliers()
                                      .Find(s => s.SupplierId == Convert.ToInt32(fourTxtEditSuppId.Text));
                // initialize new Suppliers obj
                Suppliers newSupplier;
                // do validation: no empty name, no duplicated name
                if (Validator.TBIsEmpty(fourTxtEditSuppName, "Supplier Name") ||
                    FindDuplicatedSupplierName(fourTxtEditSuppName.Text))
                {
                    // validation failed, rollback to old name, do nothing
                    fourTxtEditSuppName.Text = currentSupplier.SupName;
                    fourTxtEditSuppName.SelectAll();
                    return;
                }
                else
                {
                    // validation passed, create new Suppliers obj
                    newSupplier = new Suppliers {
                        SupName = fourTxtEditSuppName.Text
                    }
                };

                // try update
                try
                {
                    int rowsAffected = SuppliersDB.UpdateSupplier(currentSupplier, newSupplier);
                    MessageBox.Show($"{rowsAffected} record was successfully updated.", "Congratulations");
                }
                catch (Exception ex)
                {
                    MessageBox.Show($"Cannot complete update due to error: {ex.Message}.");
                }
            }
            else if (fourTab.SelectedIndex == 2)  // ADD MODE
            {
                // validate input: no empty name, no duplicated name
                if (!Validator.TBIsEmpty(fourTxtAddSuppName, "Supplier Name") &&
                    Validator.TBHasNonNegativeInt(fourTxtAddSuppId, "Supplier Id") &&
                    !FindDuplicatedSupplierName(fourTxtAddSuppName.Text))
                {
                    // validation passed, create new Suppliers obj
                    var newSupplier = new Suppliers
                    {
                        SupName = fourTxtAddSuppName.Text,
                        // PK SuppId is not auto-increment, need to assign an new id
                        SupplierId = Convert.ToInt32(fourTxtAddSuppId.Text)
                    };
                    // try to add to DB
                    try
                    {
                        int id = SuppliersDB.AddSupplier(newSupplier);
                        MessageBox.Show($"New supplier was successfully added, supplier id: {id}.",
                                        "Congratulations");
                        fourTxtAddSuppId.Clear();
                        fourTxtAddSuppName.Clear();
                    }
                    catch (Exception ex)
                    {
                        MessageBox.Show($"Cannot add new supplier due to duplicated id. Error detail: {ex.Message}.");
                    }
                }
            }
        }