public ObservableCollection <Category> GetCategories()
{
using (var ctx = new MyCerealContext())
{
return(new ObservableCollection <Category>(ctx.Categories));
}
}
public void AddUser(CustomerDetails customer)
{
using (var ctx = new MyCerealContext())
{
ctx.CustomerDetails.Add(customer);
ctx.SaveChanges();
}
}
public void DeleteMuesli(Cereal selectedCereal)
{
using (var ctx = new MyCerealContext())
{
try
{
ctx.Cereals.Remove(selectedCereal);
ctx.SaveChanges();
}
catch (Exception e)
{
Log.Error("DeleteMuesli failed: " + e.InnerException);
}
}
}
public void AddCereal(Cereal cereal)
{
using (var ctx = new MyCerealContext())
{
try
{
ctx.Cereals.Add(cereal);
ctx.SaveChanges();
}
catch (Exception e)
{
Log.Error("AddCereal failed: " + e.InnerException);
}
}
}
public ObservableCollection <Ingredient> GetIngredients()
{
using (var ctx = new MyCerealContext())
{
IQueryable <Ingredient> ingredients = null;
try
{
ingredients = from ing in ctx.Ingredients
join category in ctx.Categories on ing.Category.CategoryId
equals category.CategoryId
select ing;
}
catch (Exception e)
{
Log.Error("GetIngredients failed: " + e.InnerException);
}
return(new ObservableCollection <Ingredient>(ingredients));
}
}
public void UpdateCereal(Cereal cereal)
{
using (var ctx = new MyCerealContext())
{
try
{
var old = ctx.Cereals.First(c => c.CerealId == cereal.CerealId);
old.Name = cereal.Name;
old.CreatedOn = cereal.CreatedOn;
old.Ingredients = cereal.Ingredients;
old.Price = cereal.Price;
ctx.SaveChanges();
}
catch (Exception e)
{
Log.Error("UpdateCereal failed: " + e.InnerException);
}
}
}
public ObservableCollection <Cereal> GetMyCereals(CustomerDetails customer)
{
using (var ctx = new MyCerealContext())
{
IQueryable <Cereal> cereals;
try
{
cereals = from cereal in ctx.Cereals
join cust in ctx.CustomerDetails on cereal.Customer.CustomerDetailsId
equals cust
.CustomerDetailsId
select cereal;
}
catch (Exception e)
{
Console.WriteLine(e);
throw;
}
return(new ObservableCollection <Cereal>(cereals.Where(c => c.Customer
.Equals(customer))));
}
}
