public bool Save(FoodItem selectedFoodItem) { hasError = false; try { sqlFoodItem f = new sqlFoodItem(selectedFoodItem); FoodItemLINQDataContext dc = new FoodItemLINQDataContext(); dc.UpdateFoodItem(selectedFoodItem.FoodName, selectedFoodItem.ItemPrice, selectedFoodItem.Id); } catch (Exception ex) { errorMessage = "Update error, " + ex.Message; hasError = true; } return (!hasError); }
public ObservableCollection<FoodItem> Refresh() { hasError = false; ObservableCollection<FoodItem> fooditems = new ObservableCollection<FoodItem>(); try { FoodItemLINQDataContext dc = new FoodItemLINQDataContext(); var query = from q in dc.MenuItems select new sqlFoodItem { Id = q.ItemId, FoodName = q.FoodName, ItemPrice = Convert.ToDecimal(q.Price1) }; foreach (sqlFoodItem sp in query) fooditems.Add(sp.sqlFoodItem2FoodItem()); } catch(Exception ex) { errorMessage = "Refresh() error, " + ex.Message; hasError = true; } return fooditems; }