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