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