private ProductSubcategoryList GetProductSubcategories()
{
using (var entitiesContext = new ProductsModel.Entities())
{
IQueryable<Common.DomainClasses.ProductSubcategory> query =
from productSubcategory in entitiesContext.ProductSubcategories
orderby productSubcategory.Name
select new Common.DomainClasses.ProductSubcategory()
{
Id = productSubcategory.ProductSubcategoryID,
Name = productSubcategory.Name,
ProductCategoryId = productSubcategory.ProductCategoryID
};
var result = new ProductSubcategoryList();
// Note that the query executes on the ToList.
foreach (var item in query.ToList())
{
result.Add(item);
}
return result;
}
}
// TODO Maybe change into universal filter descriptors.
private ProductsOverviewList GetProductsOverview(int? productCategoryId, int? productSubcategoryId, string searchString)
{
using (var entitiesContext = new ProductsModel.Entities())
{
IQueryable<Common.DomainClasses.ProductsOverviewObject> query =
from product in entitiesContext.Products
from productProductPhotoes in product.ProductProductPhotoes
where
(
// Note that ProductCategory is reached through ProductSubcategory.
// Note that product.ProductSubcategoryID is nullable strangely, so there might be no product.ProductSubcategory.
// This junk actually exists in the current DB and has to be tested for.
// No filters.
// TODO Forbid both here as in GUI until paged.
(searchString == null) && (!productSubcategoryId.HasValue) && (!productCategoryId.HasValue) ||
// Category.
(searchString == null) && (!productSubcategoryId.HasValue) && (product.ProductSubcategory != null) && (product.ProductSubcategory.ProductCategoryID == productCategoryId) ||
// Category && Subcategory.
(searchString == null) && (product.ProductSubcategory != null) && (product.ProductSubcategory.ProductCategoryID == productCategoryId) && (product.ProductSubcategory.ProductSubcategoryID == productSubcategoryId) ||
// Category && Subcategory && String.
(product.ProductSubcategory != null) && (product.ProductSubcategory.ProductCategoryID == productCategoryId) && (product.ProductSubcategory.ProductSubcategoryID == productSubcategoryId) && (product.Color.Contains(searchString) || product.Name.Contains(searchString)) ||
// Category && String.
(!productSubcategoryId.HasValue) && (product.ProductSubcategory != null) && (product.ProductSubcategory.ProductCategoryID == productCategoryId) && (product.Color.Contains(searchString) || product.Name.Contains(searchString)) ||
// String.
(!productCategoryId.HasValue) && (!productSubcategoryId.HasValue) && (product.Color.Contains(searchString) || product.Name.Contains(searchString))
)
orderby product.Name
select new Common.DomainClasses.ProductsOverviewObject()
{
Id = product.ProductID,
Name = product.Name,
Color = product.Color,
ListPrice = product.ListPrice,
Size = product.Size,
SizeUnitMeasureCode = product.SizeUnitMeasureCode,
WeightUnitMeasureCode = product.WeightUnitMeasureCode,
ThumbNailPhoto = productProductPhotoes.ProductPhoto.ThumbNailPhoto,
ProductCategoryId = (product.ProductSubcategory != null) ? product.ProductSubcategory.ProductCategoryID : (int?)null,
ProductCategory = (product.ProductSubcategory != null) ? product.ProductSubcategory.ProductCategory.Name : null,
ProductSubcategoryId = (product.ProductSubcategory != null) ? product.ProductSubcategory.ProductSubcategoryID : (int?)null,
ProductSubcategory = (product.ProductSubcategory != null) ? product.ProductSubcategory.Name : null
};
var result = new ProductsOverviewList();
// Note that the query executes on the ToList.
foreach (var item in query.ToList())
{
result.Add(item);
}
return result;
}
}
private Common.DomainClasses.Product GetProductDetails(int productID)
{
using (var entitiesContext = new ProductsModel.Entities())
{
IQueryable<Common.DomainClasses.Product> query =
// Note this benefits from the joins already defined in the model.
from product in entitiesContext.Products
from productProductPhotoes in product.ProductProductPhotoes
from productModelProductDescriptionCulture in product.ProductModel.ProductModelProductDescriptionCultures
where
(
(product.ProductID == productID) &&
// TODO Should this be used by &&?
(productModelProductDescriptionCulture.CultureID == "en") // HACK
)
select new Common.DomainClasses.Product()
{
Id = product.ProductID,
Name = product.Name,
ProductNumber = product.ProductNumber,
Color = product.Color,
ListPrice = product.ListPrice,
Size = product.Size,
SizeUnitMeasureCode = product.SizeUnitMeasureCode,
Weight = product.Weight,
WeightUnitMeasureCode = product.WeightUnitMeasureCode,
LargePhoto = productProductPhotoes.ProductPhoto.LargePhoto,
ProductCategoryId = product.ProductSubcategory.ProductCategoryID,
ProductCategory = product.ProductSubcategory.ProductCategory.Name,
ProductSubcategoryId = product.ProductSubcategory.ProductSubcategoryID,
ProductSubcategory = product.ProductSubcategory.Name,
ModelName = product.ProductModel.Name,
Description = productModelProductDescriptionCulture.ProductDescription.Description
};
// Note that the query executes on the FirstOrDefault.
var result = query.FirstOrDefault();
return result;
}
}