public List <VmNewProduct> ShowRelatedProduct(int ProductId, string ProductNameFA, int LastSubCatId) { var qRelatedProduct = database.Tbl_Products.Where(c => c.IsShowProduct == true && c.ProductNameFA.Contains(ProductNameFA) || c.LastSubCat_FK == LastSubCatId) .OrderByDescending(c => c.ProductId) .Include(c => c.Tbl_Gallery) .ToList(); List <VmNewProduct> lstNewProduct = new List <VmNewProduct>(); foreach (var item in qRelatedProduct) { VmNewProduct vmNewPro = new VmNewProduct(); vmNewPro.ProductId = item.ProductId; vmNewPro.ProductNameFA = item.ProductNameFA; vmNewPro.OffProduct = item.OffProduct; vmNewPro.Price = item.Price; vmNewPro.ProductNameEN = item.ProductNameEN; string productImageName = database.Tbl_Gallery.Where(c => c.ProductId_FK == item.ProductId && c.DefaultPicProduct == true).FirstOrDefault().PictureName; vmNewPro.DefaultPic = "/Files/Images/Products/" + productImageName; lstNewProduct.Add(vmNewPro); } return(lstNewProduct ?? null); }
public List <VmNewProduct> ShowNewProductsByCategory() { var qNewPro = database.Tbl_Products.Where(c => c.IsShowProduct == true && c.CategoryId_FK == c.Tbl_Category.CatId) .OrderByDescending(c => c.ProductId) .Include(c => c.Tbl_Gallery) .ToList(); List <VmNewProduct> lstNewProduct = new List <VmNewProduct>(); foreach (var item in qNewPro) { VmNewProduct vmNewPro = new VmNewProduct(); vmNewPro.CategoryId_FK = item.CategoryId_FK; vmNewPro.ProductId = item.ProductId; vmNewPro.ProductNameFA = item.ProductNameFA; vmNewPro.ProductNameEN = item.ProductNameEN; vmNewPro.OffProduct = item.OffProduct; vmNewPro.Price = item.Price; string productImageName = database.Tbl_Gallery.Where(c => c.ProductId_FK == item.ProductId && c.DefaultPicProduct == true).FirstOrDefault().PictureName; vmNewPro.DefaultPic = "/Files/Images/Products/" + productImageName; lstNewProduct.Add(vmNewPro); } return(lstNewProduct ?? null); }