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()); }