Пример #1
0
        private void dataGridView_CellContentClick(object sender, DataGridViewCellEventArgs e)
        {
            var senderGrid = (DataGridView)sender;

            if (senderGrid.Columns[e.ColumnIndex] is DataGridViewButtonColumn &&
                e.RowIndex >= 0 && e.ColumnIndex == 4) // update record
            {
                //TODO - Button Clicked - Execute Code Here
                Int64  pvID   = Int64.Parse(dataGridView.Rows[e.RowIndex].Cells[0].Value.ToString());
                string flavor = dataGridView.Rows[e.RowIndex].Cells[1].Value.ToString();
                string price  = dataGridView.Rows[e.RowIndex].Cells[2].Value.ToString();
                string size   = dataGridView.Rows[e.RowIndex].Cells[3].Value.ToString();

                updateProductVariants upV = new updateProductVariants(pvID, price, flavor, size, productID);
                upV.Show();
            }
            else if (senderGrid.Columns[e.ColumnIndex] is DataGridViewButtonColumn &&
                     e.RowIndex >= 0 && e.ColumnIndex == 5) // update record
            {
                //TODO - Button Clicked - Execute Code Here
                Int64        pvID         = Int64.Parse(dataGridView.Rows[e.RowIndex].Cells[0].Value.ToString());
                DialogResult dialogResult = MessageBox.Show("Are you sure want to Delete record?", "Delete", MessageBoxButtons.YesNo);
                if (dialogResult == DialogResult.Yes)
                {
                    ProductVariantsBLL pvBLL = new ProductVariantsBLL();
                    pvBLL.deleteVariant(pvID);
                    searchAll();
                }
                else if (dialogResult == DialogResult.No)
                {
                }
            }
        }
Пример #2
0
        void searchAll()
        {
            dataGridView.Rows.Clear();
            dataGridView.Refresh();
            ProductVariantsBLL pvBLL = new ProductVariantsBLL();
            ArrayList          arr   = pvBLL.searchAllVariant(productID);

            foreach (object o in arr)
            {
                ProductVariantsDTO dto = (ProductVariantsDTO)o;

                int a = dataGridView.Rows.Add();
                dataGridView.Rows[a].Cells[0].Value = dto.PRODVARID;
                dataGridView.Rows[a].Cells[1].Value = dto.FLAVOR;
                dataGridView.Rows[a].Cells[2].Value = dto.PRICE;
                dataGridView.Rows[a].Cells[3].Value = dto.SIZE;
            }
        }
Пример #3
0
        private void btnAdd_Click(object sender, EventArgs e)
        {
            string flavor = txtFlavor.Text;
            string price  = txtPrice.Text;
            string size   = txtSize.Text;

            if (flavor != "" & price != "" & size != "")
            {
                ProductVariantsDTO pvDTO = new ProductVariantsDTO(price, flavor, size, productID);
                ProductVariantsBLL pvBLL = new ProductVariantsBLL();
                pvBLL.addVariant(pvDTO);
                searchAll();
                clearAllFields();
            }
            else
            {
                MessageBox.Show("Please Fill All The Fields!", "Error");
            }
        }
        private void btnUpdate_Click(object sender, EventArgs e)
        {
            string flavor = txtFlavor.Text;
            string price  = txtPrice.Text;
            string size   = txtSize.Text;

            DialogResult dialogResult = MessageBox.Show("Are you sure want to Update record?", "Update", MessageBoxButtons.YesNo);

            if (dialogResult == DialogResult.Yes)
            {
                ProductVariantsDTO pvDTO = new ProductVariantsDTO(pvID, price, flavor, size, productID);
                ProductVariantsBLL pvBLL = new ProductVariantsBLL();
                pvBLL.updateVariant(pvDTO);
                clearAllFields();
                Close();
            }
            else if (dialogResult == DialogResult.No)
            {
            }
        }