Пример #1
0
        private void BtnAddProduct_Click_1(object sender, EventArgs e)
        {
            try
            {
                AdminAddNewProducts addProduct = new AdminAddNewProducts(this);

                //if the add product button is click
                //save button is present in the form
                addProduct.BtnSave.Visible = true;

                //change the location of save button next to cancel button
                addProduct.BtnSave.Location = new System.Drawing.Point(133, 515);

                //update button is not present in the form
                addProduct.BtnUpdate.Visible = false;
                addProduct.Show();

                // Populate the Combobox with category
                addProduct.PopulateCategoryInCombobox();
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message, "Oops Something came up", MessageBoxButtons.OK, MessageBoxIcon.Error);
            }
        }
Пример #2
0
        private void dataGridView1_CellContentClick(object sender, DataGridViewCellEventArgs e)
        {
            string colName = dataGridView1.Columns[e.ColumnIndex].Name;

            if (colName == "Edit")
            {
                AdminAddNewProducts Frp = new AdminAddNewProducts(this);
                Frp.BtnSave.Enabled   = false;
                Frp.BtnUpdate.Enabled = true;
                Frp.lbl1.Text         = "Update Product";

                Frp.lblID.Text       = dataGridView1.Rows[e.RowIndex].Cells[1].Value.ToString();
                Frp.txtCode.Text     = dataGridView1.Rows[e.RowIndex].Cells[2].Value.ToString();
                Frp.txtDesc.Text     = dataGridView1.Rows[e.RowIndex].Cells[3].Value.ToString();
                Frp.txtPrice.Text    = dataGridView1.Rows[e.RowIndex].Cells[5].Value.ToString();
                Frp.txtCategory.Text = dataGridView1.Rows[e.RowIndex].Cells[4].Value.ToString();
                Frp.txtQuan.Text     = dataGridView1.Rows[e.RowIndex].Cells[6].Value.ToString();
                Frp.txtWarnqty.Text  = dataGridView1.Rows[e.RowIndex].Cells[7].Value.ToString();

                ShowAllProductsInDatabase();
                Frp.BtnSave.Visible   = false;
                Frp.BtnUpdate.Visible = true;

                // Populate the Category Combobox
                Frp.PopulateCategoryInCombobox();
                Frp.Show();
            }
            else if (colName == "Delete")
            {
                if (MessageBox.Show("Are you sure you want to delete this Product's Information?", "Delete Product", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
                {
                    cn.Open();
                    cm = new SqlCommand("Delete FROM tblProduct WHERE id like '" + dataGridView1.Rows[e.RowIndex].Cells[1].Value.ToString() + "'", cn);
                    cm.ExecuteNonQuery();
                    cn.Close();
                    MessageBox.Show("Product's Information Successfully Deleted.", "Product Deleted", MessageBoxButtons.OK, MessageBoxIcon.Information);
                    ShowAllProductsInDatabase();
                }
            }
        }
Пример #3
0
        private void contextMenuStrip1_ItemClicked(object sender, ToolStripItemClickedEventArgs e)
        {
            //File a switch case statement
            switch (e.ClickedItem.Name.ToString())
            {
            case "edi":

                contextMenuStrip1.Hide();
                AdminAddNewProducts c = new AdminAddNewProducts(this);

                c.lblID.Text       = ID.Text;
                c.txtDesc.Text     = label3.Text;
                c.txtCode.Text     = label2.Text;
                c.txtCategory.Text = label5.Text;
                c.txtPrice.Text    = label4.Text;
                c.txtQuan.Text     = label6.Text;
                c.txtWarnqty.Text  = label7.Text;

                //Hide the Save Button
                c.BtnSave.Visible = false;

                // Populate the Category Combobox
                c.PopulateCategoryInCombobox();

                //Show Only the Update Button
                c.BtnUpdate.Visible = true;
                c.lbl1.Text         = "Update Product Information";
                c.txtQuan.Enabled   = false;
                c.Focus();
                c.Show();

                break;

            case "del":

                contextMenuStrip1.Hide();
                if (MessageBox.Show("Are you sure you want to delete the Product Information?", "Delete Product", MessageBoxButtons.YesNo, MessageBoxIcon.Warning) == DialogResult.Yes)
                {
                    cn.Open();
                    cm = new SqlCommand("DELETE FROM tblProduct WHERE id like '" + ID.Text + "'", cn);
                    cm.ExecuteNonQuery();
                    cn.Close();
                    MessageBox.Show("Product Information has been successfully Deleted", "Product Deleted", MessageBoxButtons.OK, MessageBoxIcon.Information);
                    ShowAllProductsInDatabase();
                }

                break;

            case "deta":

                contextMenuStrip1.Hide();

                AdminProductDetails pd = new AdminProductDetails();

                pd.lblWhatProduct.Text  = label3.Text;
                pd.lblWhatCategory.Text = "This product is under " + label5.Text + "  Category.";
                pd.lblWhatID.Text       = ID.Text;
                pd.lblWhatCode.Text     = label2.Text;
                pd.lblWhatPrice.Text    = "₱  " + label4.Text + " ";
                pd.lblWhatStatus.Text   = label9.Text;
                pd.Show();

                break;
            }
        }