Example #1
0
 protected void btnDelete_Click(object sender, EventArgs e)
 {
     using (var context = new StoreEntities())
     {
         var productToDelete = context.Products.Find(Int32.Parse(ddlProducts.SelectedValue));
         if (productToDelete != null)
         {
             context.Products.Remove(productToDelete);
             context.SaveChanges();
             BindGridAllProducts();
         }
     }
 }
Example #2
0
        protected void btnUpdate_Click(object sender, EventArgs e)
        {
            using (var entities = new StoreEntities())
            {
                var product = entities.Products.Find(Int32.Parse(txtUpdateProductId.Text));
                product.Name        = txtUpdateProductName.Text;
                product.Description = txtUpdateProductDescription.Text;
                product.Price       = decimal.Parse(txtUpdateProductPrice.Text);

                entities.Entry(product).State = System.Data.EntityState.Modified;
                entities.SaveChanges();
                BindGridAllProducts();
            }

            pnlEditProduct.Visible = false;
        }
Example #3
0
        protected void btnInsertNewProduct_Click(object sender, EventArgs e)
        {
            using (var context = new StoreEntities())
            {
                context.Products.Add(new Product
                {
                    ProductId   = Int32.Parse(txtNewProductId.Text),
                    Name        = txtNewProductName.Text,
                    Description = txtNewProductDescription.Text,
                    Price       = decimal.Parse(txtNewProductPrice.Text)
                });

                context.SaveChanges();
                BindGridAllProducts();

                txtNewProductName.Text        = "";
                txtNewProductDescription.Text = "";
                txtNewProductPrice.Text       = "";
            }
        }
Example #4
0
        protected void ddlEditProduct_SelectedIndexChanged(object sender, EventArgs e)
        {
            if (ddlEditProduct.SelectedValue != "Select Product..")
            {
                txtUpdateProductId.Text    = ddlEditProduct.SelectedValue;
                txtUpdateProductId.Enabled = false;
                using (var entities = new StoreEntities())
                {
                    var product = entities.Products.Find(Int32.Parse(ddlEditProduct.SelectedValue));
                    txtUpdateProductName.Text        = product.Name;
                    txtUpdateProductDescription.Text = product.Description;
                    txtUpdateProductPrice.Text       = product.Price.ToString();
                }

                pnlEditProduct.Visible = true;
            }
            else
            {
                pnlEditProduct.Visible = false;
            }
        }
Example #5
0
        protected void BindGridAllProducts()
        {
            using (StoreEntities entities = new StoreEntities())
            {
                grdAllProducts.DataSource = entities.GetAllProducts();
                grdAllProducts.DataBind();

                ddlProducts.DataSource     = entities.Products.ToList();
                ddlProducts.DataTextField  = "Name";
                ddlProducts.DataValueField = "ProductId";
                ddlProducts.DataBind();

                ddlEditProduct.Items.Clear();
                ddlEditProduct.DataSource     = entities.Products.ToList();
                ddlEditProduct.DataTextField  = "Name";
                ddlEditProduct.DataValueField = "ProductId";
                ddlEditProduct.Items.Insert(0, "Select Product..");
                ddlEditProduct.DataBind();

                txtNewProductId.Text    = entities.Products.Max(p => p.ProductId + 1).ToString();
                txtNewProductId.Enabled = false;
            }
        }