Esempio n. 1
0
        private void btnEditProduct_Click(object sender, EventArgs e)
        {
            if (Role == 1)
            {
                int id = Convert.ToInt32(txtIdProduct.Text);

                Data.Product pr = new Data.Product();
                pr                 = (from p in manage.Products where p.ProductID == id select p).FirstOrDefault();
                pr.ProductName     = txtNameProduct.Text;
                pr.QuantityInStock = Convert.ToInt32(numberQuantityProduct.Value);
                pr.Price           = Convert.ToInt32(numberPriceProduct.Value);
                pr.CategoryID      = Convert.ToInt32(ComboCateProduct.SelectedValue);
                pr.BrandID         = Convert.ToInt32(ComboBrandProduct.SelectedValue);
                pr.Avatar          = "";

                manage.SaveChanges();
                MessageBox.Show("Bạn đã sửa 1 mục");

                LoadGridViewProduct();
            }

            else
            {
                MessageBox.Show("Bạn không có quyền sửa !");
            }
        }
Esempio n. 2
0
        private void btnSaveProduct_Click(object sender, EventArgs e)
        {
            string name     = txtNameProduct.Text;
            var    cate     = Convert.ToInt32(ComboCateProduct.SelectedValue);
            int    quantity = Convert.ToInt32(numberQuantityProduct.Value);
            int    price    = Convert.ToInt32(numberPriceProduct.Value);
            var    brand    = Convert.ToInt32(ComboBrandProduct.SelectedValue);

            Data.Product pro = new Data.Product();
            pro.ProductName     = name;
            pro.QuantityInStock = quantity;
            pro.CategoryID      = cate;
            pro.BrandID         = brand;
            pro.Price           = price;
            pro.Avatar          = "";

            manage.Products.Add(pro);
            manage.SaveChanges();

            txtNameProduct.Text          = "";
            numberQuantityProduct.Value  = 0;
            numberPriceProduct.Value     = 0;
            txtIdProduct.Text            = "";
            ComboBrandProduct.DataSource = (from b in manage.Brands
                                            select b).ToList();
            ComboBrandProduct.ValueMember   = "BrandID";
            ComboBrandProduct.DisplayMember = "BrandName";

            ComboCateProduct.DataSource = (from c in manage.Categories
                                           select c).ToList();
            ComboCateProduct.ValueMember   = "CategoryID";
            ComboCateProduct.DisplayMember = "CategoryName";
            ComboBrandProduct.SelectedItem = 0;
            ComboCateProduct.SelectedItem  = 0;

            MessageBox.Show("Bạn đã thêm thành công");
            LoadGridViewProduct();
        }
Esempio n. 3
0
        private void btnRemoveProduct_Click(object sender, EventArgs e)
        {
            DialogResult dialogResult = MessageBox.Show("Bạn có muốn xóa không?", "Some Title", MessageBoxButtons.YesNo);

            if (dialogResult == DialogResult.Yes)
            {
                if (Role == 1)
                {
                    int          id = Convert.ToInt32(txtIdProduct.Text);
                    Data.Product pr = new Data.Product();
                    pr = (from p in manage.Products where p.ProductID == id select p).FirstOrDefault();
                    manage.Entry(pr).State = System.Data.Entity.EntityState.Deleted;
                    manage.SaveChanges();

                    MessageBox.Show("Bạn đã xóa thành công");
                    LoadGridViewProduct();
                }
                else
                {
                    MessageBox.Show("Bạn không có quyền xóa");
                }
            }
        }