/// <summary>
/// Gets the one.
/// </summary>
/// <param name="id">The id.</param>
/// <returns></returns>
public Category GetOne(int id)
{
var item = this.db.Categories.FirstOrDefault(x => x.CategoryID == id);
if (item == null)
{
return null;
}
else
{
var category = new Category()
{
CategoryID = item.CategoryID,
CategoryName = item.CategoryName,
Description = item.Description
};
return category;
}
}
/// <summary>
/// Gets the categories.
/// </summary>
/// <returns></returns>
public List<Category> GetCategories()
{
List<Category> result = new List<Category>();
var categories = this.db.Categories.OrderBy(x => x.CategoryID);
foreach (var item in categories)
{
var category = new Category()
{
CategoryID = item.CategoryID,
CategoryName = item.CategoryName,
Description = item.Description
};
result.Add(category);
}
return result;
}