public ActionResult Edit(int id) { TempData["SuccessMsg"] = ""; TempData["FailedMsg"] = ""; if (id > 0) { var data = db.Product.Where(w => w.ProductHeaderId == id).FirstOrDefault(); if (data == null) { TempData["FailedMsg"] = "Product Not Found"; } else { var model = new VmProductAdd { BrandId = data.BrandId, Description = data.Description, ModelNo = data.ModelNo, ProductCategoryHeaderId = data.ProductSubCategory.ProductCategory.ProductCategoryHeaderId, ProductCode = data.ProductCode, ProductHeaderId = data.ProductHeaderId, ProductName = data.ProductName, ProductSubCategoryHeaderId = data.ProductSubCategoryHeaderId, Rate = data.Rate, UnitId = data.UnitId, }; ViewBag.SubCategoryList = db.ProductSubCategory.AsEnumerable().Select(s => new ProductSubCategory { ProductCategoryHeaderId = s.ProductCategoryHeaderId, ProductSubCategoryHeaderId = s.ProductSubCategoryHeaderId, ProductSubCategoryName = s.ProductSubCategoryName }); ViewBag.UnitList = db.FndFlexValueSet.Where(w => w.FlexValueSetShortName == "unit").FirstOrDefault().FndFlexValue.Select(s => new VmSelectList { Id = s.FlexValueId, Name = s.FlexValue }); ViewBag.BrandList = db.FndFlexValueSet.Where(w => w.FlexValueSetShortName == "brand").FirstOrDefault().FndFlexValue.Select(s => new VmSelectList { Id = s.FlexValueId, Name = s.FlexValue }); ViewBag.CategoryList = db.ProductCategory.Select(s => new VmSelectList { Id = s.ProductCategoryHeaderId, Name = s.ProductCategoryName }); return(View(model)); } } else { TempData["FailedMsg"] = "Invalid Url"; } return(Redirect(Request.UrlReferrer.ToString())); }
public ActionResult Add(VmProductAdd model) { TempData["SuccessMsg"] = ""; TempData["FailedMsg"] = ""; if (ModelState.IsValid) { try { if (db.Product.Any(a => a.ProductName == model.ProductName)) { TempData["FailedMsg"] = "Product Already Exist"; } else if (db.Product.Any(a => a.ProductCode == model.ProductCode)) { TempData["FailedMsg"] = "Product Code Already Exist"; } else { #region Image Upload var uri = Request.Url.Host; System.IO.Directory.CreateDirectory(Server.MapPath("~/Images/Product/" + uri)); string path = ""; if (model.Image1 != null) { string pic = System.IO.Path.GetFileName(model.Image1.FileName); string physicalPath = System.IO.Path.Combine(Server.MapPath("~/Images/Product/" + uri), pic); path = "/Images/Product/" + uri + "/" + pic; model.Image1.SaveAs(physicalPath); model.ImageUrl1 = path; } path = ""; if (model.Image2 != null) { string pic = System.IO.Path.GetFileName(model.Image2.FileName); string physicalPath = System.IO.Path.Combine(Server.MapPath("~/Images/Product/" + uri), pic); path = "/Images/Product/" + uri + "/" + pic; model.Image2.SaveAs(physicalPath); model.ImageUrl2 = path; } path = ""; if (model.Image3 != null) { string pic = System.IO.Path.GetFileName(model.Image3.FileName); string physicalPath = System.IO.Path.Combine(Server.MapPath("~/Images/Product/" + uri), pic); path = "/Images/Product/" + uri + "/" + pic; model.Image3.SaveAs(physicalPath); model.ImageUrl3 = path; } #endregion var newData = new Product(); newData.BrandId = model.BrandId; newData.Description = model.Description; newData.ModelNo = model.ModelNo; newData.ProductCode = model.ProductCode; newData.ProductHeaderId = model.ProductHeaderId; newData.ProductName = model.ProductName; newData.ProductSubCategoryHeaderId = model.ProductSubCategoryHeaderId; newData.Rate = model.Rate; newData.UnitId = model.UnitId; newData.ImageUrl3 = model.ImageUrl3; newData.ImageUrl2 = model.ImageUrl2; newData.ImageUrl1 = model.ImageUrl1; db.Product.Add(newData); db.SaveChanges(); TempData["SuccessMsg"] = "Product Added Successfully"; return(RedirectToAction("Index")); } } catch (Exception e) { TempData["FailedMsg"] = e.Message; } } else { TempData["FailedMsg"] = "Failed"; } ViewBag.SubCategoryList = db.ProductSubCategory.AsEnumerable().Select(s => new ProductSubCategory { ProductCategoryHeaderId = s.ProductCategoryHeaderId, ProductSubCategoryHeaderId = s.ProductSubCategoryHeaderId, ProductSubCategoryName = s.ProductSubCategoryName }); ViewBag.UnitList = db.FndFlexValueSet.Where(w => w.FlexValueSetShortName == "unit").FirstOrDefault().FndFlexValue.Select(s => new VmSelectList { Id = s.FlexValueId, Name = s.FlexValue }); ViewBag.BrandList = db.FndFlexValueSet.Where(w => w.FlexValueSetShortName == "brand").FirstOrDefault().FndFlexValue.Select(s => new VmSelectList { Id = s.FlexValueId, Name = s.FlexValue }); ViewBag.CategoryList = db.ProductCategory.Select(s => new VmSelectList { Id = s.ProductCategoryHeaderId, Name = s.ProductCategoryName }); return(View(model)); }
public ActionResult Edit(VmProductAdd model) { TempData["SuccessMsg"] = ""; TempData["FailedMsg"] = ""; if (ModelState.IsValid) { try { var data = db.Product.Find(model.ProductHeaderId); if (data == null) { TempData["FailedMsg"] = "Product Not Found"; } else { #region Image Upload var uri = Request.Url.Host; System.IO.Directory.CreateDirectory(Server.MapPath("~/Images/Product/" + uri)); string path = ""; if (model.Image1 != null) { string pic = System.IO.Path.GetFileName(model.Image1.FileName); string physicalPath = System.IO.Path.Combine(Server.MapPath("~/Images/Product/" + uri), pic); path = "/Images/Product/" + uri + "/" + pic; model.Image1.SaveAs(physicalPath); data.ImageUrl1 = path; } path = ""; if (model.Image2 != null) { string pic = System.IO.Path.GetFileName(model.Image2.FileName); string physicalPath = System.IO.Path.Combine(Server.MapPath("~/Images/Product/" + uri), pic); path = "/Images/Product/" + uri + "/" + pic; model.Image2.SaveAs(physicalPath); data.ImageUrl2 = path; } path = ""; if (model.Image3 != null) { string pic = System.IO.Path.GetFileName(model.Image3.FileName); string physicalPath = System.IO.Path.Combine(Server.MapPath("~/Images/Product/" + uri), pic); path = "/Images/Product/" + uri + "/" + pic; model.Image3.SaveAs(physicalPath); data.ImageUrl3 = path; } #endregion data.BrandId = model.BrandId; data.Description = model.Description; data.ModelNo = model.ModelNo; data.ProductCode = model.ProductCode; data.ProductName = model.ProductName; data.ProductSubCategoryHeaderId = model.ProductSubCategoryHeaderId; data.Rate = model.Rate; data.UnitId = model.UnitId; db.SaveChanges(); TempData["SuccessMsg"] = "Product Updated Successfully"; return(RedirectToAction("Index")); } } catch (Exception e) { TempData["FailedMsg"] = e.Message; } } else { TempData["FailedMsg"] = "Failed"; } return(View(model)); }