public List <Data.Models.Product> ProductsByCategoryId(string json) { List <Data.Models.Product> result = new List <Data.Models.Product>(); DTO.ProductsByCategoryId productsByCategoryId = Newtonsoft.Json.JsonConvert.DeserializeObject <DTO.ProductsByCategoryId>(json); IQueryable <Product> products = productAdapter.Get <Data.Models.Product>(); result = products.Include(a => a.Category).Where(a => a.CategoryId == productsByCategoryId.CategoryId).ToList(); return(result); }
public List <Models.Product> ProductsByCategoryId(string json) { List <Models.Product> result = new List <Models.Product>(); DTO.ProductsByCategoryId productsByCategoryId = Newtonsoft.Json.JsonConvert.DeserializeObject <DTO.ProductsByCategoryId>(json); using (ECommerceContext eCommerceContext = new ECommerceContext()) { result = eCommerceContext.Products.Where(a => a.CategoryId == productsByCategoryId.CategoryId).ToList(); } return(result); }