public int Upload(FormCollection formCollection) { var filePath = ""; var v = 0; if (formCollection["productId"] != null) { v = Convert.ToInt16(formCollection["productId"]); } if (Request.Files.Count > 0) { var i = 1; foreach (string file in Request.Files) { var _file = Request.Files[file]; filePath = BaseUtil.UploadFile(_file, "/Content/Images"); TblProductImage tblProductImage = new TblProductImage(); tblProductImage.ProductID = v; tblProductImage.ProductImageURL = filePath; db.TblProductImages.Add(tblProductImage); } db.SaveChanges(); } return(1); }
public ActionResult NewProduct(TblProduct tblProduct, IEnumerable <HttpPostedFileBase> file) { try { ViewBag.Attributes = db.TblAttributes.Where(e => e.IsDelete == false); ViewBag.StoreId = new SelectList(db.TblStoreInformations.Where(e => e.IsDelete == false), "StoreId", "StoreName", tblProduct.StoreId); ViewBag.ProductCategoryId = new SelectList(db.TblProductCategories.Where(e => e.IsDelete == false), "ProductCategoryId", "CategoryName", tblProduct.ProductCategoryId); ViewBag.SupplierId = new SelectList(db.TblSuppliers.Where(e => e.IsDelete == false && e.IsActive == true).Select(e => new { e.SupplierId, e.SupplierName }), "SupplierId", "SupplierName", tblProduct.SupplierId); //tblProduct = productModel.Product; tblProduct.IsDelete = false; tblProduct.IsActive = true; tblProduct.CreatedBy = Convert.ToInt32(BaseUtil.GetSessionValue(AdminInfo.LoginID.ToString())); tblProduct.ModifiedBy = Convert.ToInt32(BaseUtil.GetSessionValue(AdminInfo.LoginID.ToString())); tblProduct.CreatedDate = DateTime.Now; tblProduct.ModifiedDate = DateTime.Now; tblProduct.PriceDispay = true; tblProduct.ProductName = tblProduct.productTitle; if (tblProduct.srNumber == 0) { tblProduct.srNumber = 1000; } List <TblProductImage> productImageList = new List <TblProductImage>(); if (file != null) { var i = 1; TblProductImage productImage; foreach (var p in file) { if (p != null) { productImage = new TblProductImage(); productImage.ProductImageURL = BaseUtil.UploadFile(p, "/Content/ProductImages"); productImageList.Add(productImage); i++; } } } else { tblProduct.DisplayImg = "/images/item-01.jpgg"; } if (ModelState.IsValid) { db.TblProducts.Add(tblProduct); db.SaveChanges(); foreach (var productImage in productImageList) { productImage.ProductID = tblProduct.ProductID; } db.TblProductImages.AddRange(productImageList); db.SaveChanges(); List <TblProductAttribute> LsttblProductAttributes = new List <TblProductAttribute>(); TblProductAttribute tblProductAttribute; if (tblProduct.Attributes != null && tblProduct.Attributes != "") { var arr = tblProduct.Attributes.Split('$'); for (var i = 0; i < arr.Length - 1; i++) { var att = arr[i].Split('!'); var dd = att[1].Split(';'); for (var k = 0; k < dd.Length - 1; k++) { tblProductAttribute = new TblProductAttribute(); tblProductAttribute.AttributeId = Convert.ToInt16(att[0]); tblProductAttribute.MeasurementUnits = dd[k]; tblProductAttribute.ProductID = tblProduct.ProductID; tblProductAttribute.CreatedDate = DateTime.Now; LsttblProductAttributes.Add(tblProductAttribute); } } } db.TblProductAttributes.AddRange(LsttblProductAttributes); db.SaveChanges(); TempData["msg"] = "1"; return(RedirectToAction("products")); } TempData["msg"] = "0"; } catch (Exception e) { TempData["msg"] = "0"; } return(View(tblProduct)); }