public static List <ProductPhoto> GetAllPhotosInSortOrder(int productId)
{
ProductPhotoQuery q = new ProductPhotoQuery();
q.Where(q.ProductId == productId);
q.OrderBy(q.SortOrder.Ascending, q.DisplayName.Ascending);
ProductPhotoCollection collection = new ProductPhotoCollection();
if (collection.Load(q))
{
return(collection.ToList());
}
return(new List <ProductPhoto>());
}
public ProductPhoto GetMainPhoto()
{
ProductPhotoQuery q = new ProductPhotoQuery();
q.es.Top = 1;
q.Where(q.ProductId == this.Id.Value);
q.OrderBy(q.SortOrder.Ascending, q.DisplayName.Ascending);
ProductPhoto mainPhoto = new ProductPhoto();
if (mainPhoto.Load(q))
{
return(mainPhoto);
}
return(new ProductPhoto());
}