public ActionResult Addnewproductprice(int id) { BundlePriceDetailsitemVm bundlePriceDetailsitemVm = new BundlePriceDetailsitemVm(); var data = Db.tbld_bundle_price_details.Where(x => x.id == id); foreach (var item in data) { bundlePriceDetailsitemVm = new BundlePriceDetailsitemVm() { BundlePriceId = item.bundle_price_id, SkuId = item.sku_id, BatchId = item.batch_id, Quantity = 1, StartDate = DateTime.Now }; } var skuname = Db.tbld_SKU.Where(x => x.SKU_id == bundlePriceDetailsitemVm.SkuId); foreach (var item in skuname) { ViewBag.SkuName = item.SKUName; } ViewBag.SKUStatus = new SelectList(Db.status.ToList(), "status_Id", "status_code"); return(PartialView(bundlePriceDetailsitemVm)); }
public ActionResult AddnewProductinbundle(BundlePriceDetailsitemVm bundlePriceDetailsitemVm) { if (ModelState.IsValid) { tbld_bundle_price_details tbldBundlePriceDetails = new tbld_bundle_price_details { quantity = bundlePriceDetailsitemVm.Quantity, batch_id = bundlePriceDetailsitemVm.BatchId, bundle_price_id = bundlePriceDetailsitemVm.BundlePriceId, sku_id = bundlePriceDetailsitemVm.SkuId, db_lifting_price = bundlePriceDetailsitemVm.DbLiftingPrice, outlet_lifting_price = bundlePriceDetailsitemVm.OutletLiftingPrice, mrp = bundlePriceDetailsitemVm.Mrp, start_date = bundlePriceDetailsitemVm.StartDate, end_date = bundlePriceDetailsitemVm.EndDate, status = bundlePriceDetailsitemVm.Status }; Db.tbld_bundle_price_details.Add(tbldBundlePriceDetails); Db.SaveChanges(); return(Json("Save", JsonRequestBehavior.AllowGet)); //return Redirect("/BundlePrice/Details/"+BundlePriceDetailsitemVM.bundle_price_id); } return(Json("Error", JsonRequestBehavior.AllowGet)); }
public ActionResult Addnewproductprice(BundlePriceDetailsitemVm bundlePriceDetailsitemVm) { var bundlePriceDetails = Db.tbld_bundle_price_details.OrderByDescending(u => u.id).FirstOrDefault(x => x.sku_id == bundlePriceDetailsitemVm.SkuId); if (bundlePriceDetails != null) { int batchId = bundlePriceDetails.batch_id; //need previous betch inactive if (ModelState.IsValid) { tbld_bundle_price_details tbldBundlePriceDetails = new tbld_bundle_price_details { quantity = bundlePriceDetailsitemVm.Quantity, batch_id = batchId + 1, bundle_price_id = bundlePriceDetailsitemVm.BundlePriceId, sku_id = bundlePriceDetailsitemVm.SkuId, db_lifting_price = bundlePriceDetailsitemVm.DbLiftingPrice, outlet_lifting_price = bundlePriceDetailsitemVm.OutletLiftingPrice, mrp = bundlePriceDetailsitemVm.Mrp, start_date = bundlePriceDetailsitemVm.StartDate, end_date = bundlePriceDetailsitemVm.EndDate, status = bundlePriceDetailsitemVm.Status }; Db.tbld_bundle_price_details.Add(tbldBundlePriceDetails); Db.tbld_bundle_price_details.Where(x => x.batch_id == batchId - 1 && x.sku_id == bundlePriceDetailsitemVm.SkuId && x.status != 2).ToList().ForEach(x => { x.status = 2; x.end_date = DateTime.Now; }); Db.SaveChanges(); return(Json("Save", JsonRequestBehavior.AllowGet)); //return Redirect("/BundlePrice/Details/"+BundlePriceDetailsitemVM.bundle_price_id); } } return(Json("Error", JsonRequestBehavior.AllowGet)); }
public ActionResult Addnewproduct(int id) { BundlePriceDetailsitemVm bundlePriceDetailsitemVm = new BundlePriceDetailsitemVm { BundlePriceId = id, BatchId = 100, Quantity = 1, StartDate = DateTime.Now }; HashSet <int> expectList = new HashSet <int>(Db.tbld_bundle_price_details.Where(x => x.bundle_price_id == id).Select(x => x.sku_id)); var allskulist = Db.tbld_SKU.Where(x => !expectList.Contains(x.SKU_id)).ToList(); ViewBag.SkuList = new SelectList(allskulist, "SKU_id", "SKUName"); ViewBag.SKUStatus = new SelectList(Db.status.ToList(), "status_Id", "status_code"); return(PartialView(bundlePriceDetailsitemVm)); }