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