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));
}
