public static List <MyProduct> GetMyProductsByName(string namePart)
{
using (MyProductDataContext dc = new MyProductDataContext(new CatalogDataContext()))
{
List <MyProduct> myProduct = (from product in dc.myProducts
where product.Name.Contains(namePart)
select product).ToList();
return(myProduct);
}
}
public static List <MyProduct> GetMyProductsWithNRecentReviews(int howManyReviews)
{
using (MyProductDataContext dc = new MyProductDataContext(new CatalogDataContext()))
{
List <MyProduct> myProduct = (from product in dc.myProducts
where product.ProductReviews.Count == howManyReviews
select product).ToList();
return(myProduct);
}
}
public static List <MyProduct> GetNMyProductsFromCategory(string categoryName, int n)
{
using (MyProductDataContext dc = new MyProductDataContext(new CatalogDataContext()))
{
List <MyProduct> myProducts = (from product in dc.myProducts
where product.ProductSubcategory != null && product.ProductSubcategory.ProductCategory.Name.Equals(categoryName)
orderby product.ProductSubcategory.Name
select product).Take(n).ToList();
return(myProducts);
}
}
public static List <MyProduct> GetProductsByName(string namePart)
{
using (AdventureWorksDataContext dc = new AdventureWorksDataContext())
{
MyProductDataContext dataContext = new MyProductDataContext(dc);
IEnumerable <MyProduct> query = from p in dataContext.MyProducts
where p.Name.Contains(namePart)
select p;
return(query.ToList());
}
}
public static List <MyProduct> GetProductsWithNRecentReviews(int howManyReviews)
{
using (AdventureWorksDataContext dc = new AdventureWorksDataContext())
{
MyProductDataContext dataContext = new MyProductDataContext(dc);
IEnumerable <MyProduct> query = from p in dataContext.MyProducts
where p.ProductReviews.Count == howManyReviews
select p;
return(query.ToList());
}
}
public static List <MyProduct> GetNProductsFromCategory(string categoryName, int n)
{
using (AdventureWorksDataContext dc = new AdventureWorksDataContext())
{
MyProductDataContext dataContext = new MyProductDataContext(dc);
IEnumerable <MyProduct> query = from p in dataContext.MyProducts
where p.ProductSubcategory != null &&
p.ProductSubcategory.ProductCategory != null &&
p.ProductSubcategory.ProductCategory.Name == categoryName
orderby p.Name
select p;
return(query.Take(n).ToList());
}
}
