public Menu getMenu(int id)
{
DB_DATAEntities _db = new DB_DATAEntities();
IQueryable <Menu> menus = from menu in _db.Menus
where (menu.deleted_at == null) && (menu.id == id)
select menu;
return(menus.FirstOrDefault());
}
public Menu getLastInsertedData()
{
DB_DATAEntities _db = new DB_DATAEntities();
IQueryable <Menu> menus = from menu in _db.Menus
where menu.deleted_at == null
orderby menu.id descending
select menu;
return(menus.First());
}
public List <Menu> fetchMenu()
{
DB_DATAEntities _db = new DB_DATAEntities();
IQueryable <Menu> menus = from menu in _db.Menus
where menu.deleted_at == null
select menu;
return(menus.ToList());
}
public List <Menu> fetchMenuSortByPriceAsc()
{
DB_DATAEntities _db = new DB_DATAEntities();
IQueryable <Menu> menus = from menu in _db.Menus
where menu.deleted_at == null
orderby menu.price ascending
select menu;
return(menus.ToList());
}
