// GET: SK_AREA/ProdMaintainStock public ActionResult Index(int?pid = 1) { if (HttpContext.Request.Cookies["IsLogin"].Value == "Admin") { ProdMaintainStockViewModel _PMSVM = new ProdMaintainStockViewModel(); var _pPK = db.Products.Find(pid); _PMSVM.ProductID = _pPK.ProductID; _PMSVM.ProductName = _pPK.ProductName; var _productcolor = db.ProductColors.Where(x => x.ProductID == pid).Select(x => new { x.ProductColorID, x.Color.ColorName }); ViewBag.ColorSelect = new SelectList(_productcolor, "ProductColorID", "ColorName"); var _productsize = db.ProductSizes.Where(x => x.ProductID == pid).Select(x => new { x.ProductSizeID, x.Size.SizeName }); ViewBag.SizeSelect = new SelectList(_productsize, "ProductSizeID", "SizeName"); return(View(_PMSVM)); } else { RedirectToAction("PermissionError", "ProductMaintain"); } return(View()); }
public ActionResult ProdStockJson(int pid) { List <ProdMaintainStockViewModel> _ListPMSVM = new List <ProdMaintainStockViewModel>(); var _PS = db.ProductStocks.Where(x => x.ProductID == pid).OrderByDescending(x => x.StockID); //var c = db.ProductColors.Where(x => x.ProductID == id).Select(x => new //{ // x.ProductColorID, // x.Color.ColorName //}); //var s = db.ProductSizes.Where(x => x.ProductID == id).Select(x => new //{ // x.ProductSizeID, // x.Size.SizeName //}); foreach (var _data in _PS) { ProdMaintainStockViewModel _PMSVM = new ProdMaintainStockViewModel { StockID = _data.StockID, ProductID = _data.ProductID, ProductColorID = _data.ProductColorID, ProductSizeID = _data.ProductSizeID, StockQTY = _data.StockQTY, MinStock = _data.MinStock, CreateDate = _data.CreateDate, PhotoID = _data.ProductColor.PhotoID, ProductColor = db.ProductColors.Where(x => x.ProductColorID == _data.ProductColorID).FirstOrDefault().Color.ColorName, ProductSize = db.ProductSizes.Where(x => x.ProductSizeID == _data.ProductSizeID).FirstOrDefault().Size.SizeName, }; _ListPMSVM.Add(_PMSVM); } return(Json(_ListPMSVM, JsonRequestBehavior.AllowGet)); }