public IEnumerable <Recipe> GetRecipes()
{
using (var db = new RecipeBook())
{
return(db.Recipe.Include(x => x.Ingredient).Include(x => x.Instruction).ToList());
}
}
public IEnumerable <Instruction> GetInstructions()
{
using (var db = new RecipeBook())
{
return(db.Instruction.ToList());
}
}
public IEnumerable <Ingredient> GetIngredients()
{
using (var db = new RecipeBook())
{
return(db.Ingredient.ToList());
}
}
public int Add(Recipe recipe)
{
using (var db = new RecipeBook())
{
db.Recipe.Add(recipe);
db.SaveChanges();
return(recipe.RecipeID);
}
}
public Recipe Find(int recipeID)
{
var foundRecipe = new Recipe();
using (var db = new RecipeBook())
{
foundRecipe = db.Recipe.Include(x => x.Ingredient).Include(x => x.Instruction).SingleOrDefault(x => x.RecipeID == recipeID);
}
return(foundRecipe);
}
public string Delete(Recipe recipe)
{
var message = $"{recipe.Name} has been removed from the database ";
using (var db = new RecipeBook())
{
db.Remove(recipe);
db.SaveChanges();
};
return(message);
}
public void Update(Recipe recipe)
{
Recipe entity = new Recipe();
try
{
using (var db = new RecipeBook())
{
entity = db.Recipe.Include(x => x.Ingredient).Include(x => x.Instruction).SingleOrDefault(x => x.RecipeID == recipe.RecipeID);
if (entity != null)
{
entity = new Recipe()
{
RecipeID = recipe.RecipeID,
Name = recipe.Name,
GlutenFree = recipe.GlutenFree,
DairyFree = recipe.DairyFree,
Vegetarian = recipe.Vegetarian,
Vegan = recipe.Vegan,
Nuts = recipe.Nuts,
Ingredient = recipe.Ingredient,
Instruction = recipe.Instruction
};
db.Recipe.Update(recipe);
db.SaveChanges();
}
}
}
catch (DbUpdateConcurrencyException dbUpdateConCurr)
{
foreach (var entry in dbUpdateConCurr.Entries)
{
if (entry.Entity is Recipe)
{
//var proposedValues = entry.CurrentValues;
//var databaseValues = entry.GetDatabaseValues();
//foreach (var property in proposedValues.Properties)
//{
// var proposedValue = proposedValues[property];
// var databaseValue = databaseValues[property];
// // TODO: decide which value should be written to database
// // proposedValues[property] = <value to be saved>;
//}
////Refresh original values to bypass next concurrency check
//entry.OriginalValues.SetValues(databaseValues);
}
else
{
throw new NotSupportedException(
"Don't know how to handle concurrency conflicts for "
+ entry.Metadata.Name);
}
}
//throw new DbUpdateConcurrencyException(dbUpdateConCurr.Message, dbUpdateConCurr.Entries);
}
catch (DbUpdateException dbUpdate)
{
foreach (var entry in dbUpdate.Entries)
{
if (entry.Entity is Recipe)
{
//var proposedValues = entry.CurrentValues;
//var databaseValues = entry.GetDatabaseValues();
//foreach (var property in proposedValues.Properties)
//{
// var proposedValue = proposedValues[property];
// var databaseValue = databaseValues[property];
// // TODO: decide which value should be written to database
// // proposedValues[property] = <value to be saved>;
//}
//// Refresh original values to bypass next concurrency check
//entry.OriginalValues.SetValues(databaseValues);
}
else
{
throw new NotSupportedException(
"Don't know how to handle concurrency conflicts for "
+ entry.Metadata.Name);
}
}
}
}
