예제 #1
0
        public bool AddProduct(string productName, string description, string imagePath, string unitPrice, int labelID, string status, string unitInStock, string categoryID, string userID)
        {
            var newProduct = new Product();
            newProduct.ProductName = productName;
            newProduct.Description = description;
            newProduct.ImagePath = imagePath;
            newProduct.UnitPrice = Convert.ToDouble(unitPrice);
            newProduct.LabelID = labelID;
            newProduct.Status = Convert.ToBoolean(status);
            newProduct.UnitInStock = Convert.ToInt16(unitInStock);
            newProduct.CategoryID = Convert.ToInt16(categoryID);
            newProduct.CreatedDate = DateTime.Now.Date;
            newProduct.CreatedBy = userID;
            newProduct.UnitsAvailable = Convert.ToInt16(unitInStock);
            newProduct.UnitsLock = 0;
            newProduct.Discount = 0;

            using (ProductContext _db = new ProductContext())
            {
                // Add product to DB.
                _db.Products.Add(newProduct);
                _db.SaveChanges();
            }
            return true;
        }
예제 #2
0
        protected void gvProducts_RowCommand(object sender, GridViewCommandEventArgs e)
        {
            if (e.CommandName != "Page" && e.CommandName != "Sort")
            {
                GridViewRow gvr = (GridViewRow)((Control)e.CommandSource).NamingContainer;
                int rowIndex = gvr.RowIndex;
                Product p = new Product();
                p = productAction.GetProduct(int.Parse(gvProducts.Rows[rowIndex].Cells[0].Text));
                if (e.CommandName == "edt")
                {
                    txtEditProDescription.Text = WebUtility.HtmlDecode(p.Description);
                    txtEditProName.Text = WebUtility.HtmlDecode(p.ProductName);
                    txtEditProPrice.Text = ((double)p.UnitPrice).ToString("0.00");
                    txtEditProUnitsInStock.Text = p.UnitInStock.ToString();
                    lblEditProIDDisplay.Text = p.ProductID.ToString();
                    cbEditProStatus.Checked = p.Status;
                    imgEditPro.Src = "~/Catalog/Images/" + p.ImagePath;
                    lblEditProLabelDisplay.Text = p.Label.LabelName;
                    ddEditProCategoryName.SelectedValue = p.CategoryID.ToString();
                    if (p.Discount == 1.0) { txtEditProDiscount.Text = "0"; } else { txtEditProDiscount.Text = (p.Discount * 100).ToString(); }
                    ManageEditProValidation(true);
                    ModalEditProduct.Show();
                }
                else if (e.CommandName == "dlt")
                {
                    lblDeleteProID.Text = p.ProductID.ToString();
                    lblDeleteProName.Text = p.ProductName;
                    ModalDeleteProduct.Show();
                }

            }
        }