public ActionResult ProdStockJson(int id)
{
List <ProductStockVIewModel> psvmlist = new List <ProductStockVIewModel>();
var ps = db.ProductStocks.Where(x => x.ProductID == id).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 item in ps)
{
ProductStockVIewModel psvm = new ProductStockVIewModel
{
StockID = item.StockID,
ProductID = item.ProductID,
ProductColorID = item.ProductColorID,
ProductSizeID = item.ProductSizeID,
StockQTY = item.StockQTY,
MinStock = item.MinStock,
CreateDate = item.CreateDate,
PhotoID = item.ProductColor.PhotoID,
ProductColor = c.Where(x => x.ProductColorID == item.ProductColorID).FirstOrDefault().ColorName,
ProductSize = s.Where(x => x.ProductSizeID == item.ProductSizeID).FirstOrDefault().SizeName
};
psvmlist.Add(psvm);
}
return(Json(psvmlist, JsonRequestBehavior.AllowGet));
}
// GET: Backend/ProdStock
public ActionResult Index(int id)
{
ProductStockVIewModel psvm = new ProductStockVIewModel();
var pd = db.Products.Find(id);
psvm.ProductID = pd.ProductID;
psvm.ProductName = pd.ProductName;
ViewBag.productcolor = db.ProductColors.Where(x => x.ProductID == id).Select(x => new
{
x.ProductColorID,
x.Color.ColorName
});
ViewBag.productsize = db.ProductSizes.Where(x => x.ProductID == id).Select(x => new
{
x.ProductSizeID,
x.Size.SizeName
});
return(View(psvm));
}
