/// <summary>
/// Get an individual category based on a provided id
/// </summary>
/// <param name="categoryId">Category id</param>
/// <returns>Details about the Category</returns>
public CategoryInfo GetCategory(string categoryId)
{
MSPetShop4DataContext db = new MSPetShop4DataContext();
var category = db.Categories.Single(c => c.Id == categoryId);
return category;
}
/// <summary>
/// Query for a product
/// </summary>
/// <param name="productId">Product Id</param>
/// <returns>ProductInfo object for requested product</returns>
public ProductInfo GetProduct(string productId)
{
MSPetShop4DataContext db = new MSPetShop4DataContext();
var product = db.Products.Single(p => p.Id == productId);
return product;
}
/// <summary>
/// Method to get all categories
/// </summary>
public IList<CategoryInfo> GetCategories()
{
MSPetShop4DataContext db = new MSPetShop4DataContext();
IEnumerable<CategoryInfo> categories = from c in db.Categories
select c;
return categories.ToList<CategoryInfo>();
}
/// <summary>
/// Query for products by category
/// </summary>
/// <param name="category">category name</param>
/// <returns>A Generic List of ProductInfo</returns>
public IList<ProductInfo> GetProductsByCategory(string category)
{
MSPetShop4DataContext db = new MSPetShop4DataContext();
IEnumerable<ProductInfo> products = from p in db.Products
where p.Category.Id == category
select p;
return products.ToList<ProductInfo>();
}
/// <summary>
/// Get Product List
/// </summary>
/// <param name="category">Category Id</param>
/// <returns></returns>
public SyndicationFeedFormatter GetProducts(string category)
{
Uri uri = GetRootUri();
SyndicationFeed feed = new SyndicationFeed(
Resource.FeedTitle,
Resource.FeedContent,
uri
);
MSPetShop4DataContext db = new MSPetShop4DataContext();
IEnumerable<SyndicationItem> items = from p in db.Products
where p.Category.Id == category
orderby p.Id descending
select CreateSyndicationItem(p, uri, category);
feed.Items = items.Take(10);
return new Rss20FeedFormatter(feed);
}