//Get list of products
public IQueryable <ProductDTO> Get()
{
ApiProductsEntities db = new ApiProductsEntities();
var query = from product in db.Products
join category in db.Categories on product.CategoryId equals category.Id
select new ProductDTO {
Id = product.Id, Name = product.Name, Price = product.Price, Description = product.Description, Category = category.Name
};
return(query);
}
//Get list of categories (1)
public List <string> Get()
{
using (ApiProductsEntities db = new ApiProductsEntities())
{
List <string> categories = new List <string>();
foreach (var category in db.Categories)
{
categories.Add(category.Name);
}
return(categories);
}
}
//Get product info by id (3)
public ProductDTO Get(Guid id)
{
using (ApiProductsEntities db = new ApiProductsEntities())
{
var query = (from product in db.Products
join category in db.Categories on product.CategoryId equals category.Id
select new ProductDTO
{
Id = product.Id,
Name = product.Name,
Price = product.Price,
Description = product.Description,
Category = category.Name
}).FirstOrDefault(x => x.Id == id);
return(query);
}
}
