/// <summary>
/// Delete API using category name
/// </summary>
/// <param name="name"></param>
public void Delete(string name)
{
using (CategoryDBEntities entities = new CategoryDBEntities())
{
entities.Categories.Remove(entities.Categories.FirstOrDefault(p => p.CategoryName == name));
entities.SaveChanges();
}
}
/// <summary>
/// Get the all Item
/// </summary>
/// <param name="name"></param>
/// <returns></returns>
public IEnumerable <AllDetails> GetItem(string name)
{
using (CategoryDBEntities entities = new CategoryDBEntities())
{
var itemResult = (from cat in entities.Categories
join subcat in entities.SubCategories on cat.ID equals subcat.CategoryId
join item in entities.Items on subcat.ID equals item.SubCategoryId
where item.ItemName.Contains(name)
select new AllDetails()
{
CategoryName = cat.CategoryName,
SubCategoryName = subcat.SubCategoryName,
ItemName = item.ItemName,
ItemDescription = item.ItemDescription
}).ToList <AllDetails>();
return(itemResult);
}
}
