Exemple #1
0
        public ActionResult EditProduct(int id)
        {
            AppDbContext          dbContext     = new AppDbContext();
            ListProductsViewModel productDetail = dbContext.GetProducts.SingleOrDefault(p => p.Id == id);

            AddProductDetailsViewModel product = new AddProductDetailsViewModel
            {
                Name      = productDetail.Name,
                Brand     = productDetail.Brand,
                Category  = productDetail.Category,
                ProductId = productDetail.Id
            };

            return(View(product));
        }
Exemple #2
0
        public ActionResult EditProduct(HttpPostedFileBase PhotoPath, AddProductDetailsViewModel model)
        {
            if (ModelState.IsValid)
            {
                AppDbContext          dbContext     = new AppDbContext();
                ListProductsViewModel productDetail = dbContext.GetProducts.SingleOrDefault(p => p.Id == model.ProductId);
                var fileName   = Path.GetFileName(PhotoPath.FileName);
                var path       = "/Public/Products/" + productDetail.Name;
                var photoUrl   = Server.MapPath(path);
                var photoTitle = Path.GetFileNameWithoutExtension(PhotoPath.FileName);
                var uniqName   = Guid.NewGuid().ToString() + "_" + fileName;

                if (!Directory.Exists(photoUrl))
                {
                    Directory.CreateDirectory(photoUrl);
                }

                var photoPath = Path.Combine(photoUrl, uniqName);

                PhotoPath.SaveAs(photoPath);

                AddProductDetailsViewModel product = new AddProductDetailsViewModel
                {
                    Price       = model.Price,
                    Color       = model.Color,
                    Storage     = model.Storage,
                    Processor   = model.Processor,
                    Memory      = model.Memory,
                    Display     = model.Display,
                    CreatedBy   = User.Identity.Name,
                    CreatedDate = DateTime.Now,
                    PhotoPath   = photoPath,
                    PhotoTitle  = photoTitle.ToString(),
                    PhotoSrc    = path + '/' + uniqName,
                    ProductId   = model.ProductId
                };

                dbContext.AddProductDetails(product);
                return(RedirectToAction("Products"));
            }
            return(View());
        }
        public void AddProductDetails(AddProductDetailsViewModel productDetails)
        {
            string cs = ConfigurationManager.ConnectionStrings["EComMgt"].ConnectionString;

            using (SqlConnection con = new SqlConnection(cs))
            {
                SqlCommand cmd = new SqlCommand("addProductDetails", con);
                cmd.CommandType = CommandType.StoredProcedure;

                SqlParameter paramPrice = new SqlParameter();
                paramPrice.ParameterName = "@Price";
                paramPrice.Value         = productDetails.Price;
                cmd.Parameters.Add(paramPrice);

                SqlParameter paramColor = new SqlParameter();
                paramColor.ParameterName = "@Color";
                paramColor.Value         = productDetails.Color;
                cmd.Parameters.Add(paramColor);

                SqlParameter paramStorage = new SqlParameter();
                paramStorage.ParameterName = "@Storage";
                paramStorage.Value         = productDetails.Storage;
                cmd.Parameters.Add(paramStorage);

                SqlParameter paramProcessor = new SqlParameter();
                paramProcessor.ParameterName = "@Processor";
                paramProcessor.Value         = productDetails.Processor;
                cmd.Parameters.Add(paramProcessor);

                SqlParameter paramMemory = new SqlParameter();
                paramMemory.ParameterName = "@Memory";
                paramMemory.Value         = productDetails.Memory;
                cmd.Parameters.Add(paramMemory);

                SqlParameter paramDisplay = new SqlParameter();
                paramDisplay.ParameterName = "@Display";
                paramDisplay.Value         = productDetails.Display;
                cmd.Parameters.Add(paramDisplay);

                SqlParameter paramProductId = new SqlParameter();
                paramProductId.ParameterName = "@ProductId";
                paramProductId.Value         = productDetails.ProductId;
                cmd.Parameters.Add(paramProductId);

                SqlParameter paramCreatedBy = new SqlParameter();
                paramCreatedBy.ParameterName = "@CreatedBy";
                paramCreatedBy.Value         = productDetails.CreatedBy;
                cmd.Parameters.Add(paramCreatedBy);

                SqlParameter paramCreatedDate = new SqlParameter();
                paramCreatedDate.ParameterName = "@CreatedDate";
                paramCreatedDate.Value         = productDetails.CreatedDate;
                cmd.Parameters.Add(paramCreatedDate);

                SqlParameter paramPhotoPath = new SqlParameter();
                paramPhotoPath.ParameterName = "@Path";
                paramPhotoPath.Value         = productDetails.PhotoPath;
                cmd.Parameters.Add(paramPhotoPath);

                SqlParameter paramPhotoTitle = new SqlParameter();
                paramPhotoTitle.ParameterName = "@Title";
                paramPhotoTitle.Value         = productDetails.PhotoTitle;
                cmd.Parameters.Add(paramPhotoTitle);

                SqlParameter paramPhotoSrc = new SqlParameter();
                paramPhotoSrc.ParameterName = "@Src";
                paramPhotoSrc.Value         = productDetails.PhotoSrc;
                cmd.Parameters.Add(paramPhotoSrc);

                con.Open();
                cmd.ExecuteNonQuery();
            }
        }