/******************************************************************/
/* RETREIVE FROM DATABASE AND */
/******************************************************************/
private List <recipe> PopulateViewRecipe()
{
var context = new RecipeContext();
List <recipe> allRecipes =
(from r in context.recipe
select r).ToList();
return(allRecipes);
}
public static List <recipe> GetAllRecipes()
{
RecipeContext context = new RecipeContext();
List <recipe> allRecipes = (from r in context.recipe
orderby r.recipeTitle ascending
select r).ToList();
return(allRecipes);
}
public static void Delete(recipe r)
{
var context = new RecipeContext();
context.recipe.Add(r);
//mark the recipe as deleted
context.Entry(r).State = EntityState.Deleted;
context.SaveChanges();
}
public static void InsertRecipe(recipe r)
{
RecipeContext context = new RecipeContext();
//assume Recipe is valid
context.recipe.Add(r);
context.Entry(r).State = EntityState.Added;
context.SaveChanges();
}
public static void Update(recipe r)
{
var context = new RecipeContext();
//add recipe to object to current context
context.recipe.Add(r);
//Let EF know the book already exists
context.Entry(r).State = EntityState.Modified;
context.SaveChanges();
}
private void PopulateDeleteRecipe(int id)
{
var context = new RecipeContext();
//pull recipe from DB to make EF track it
recipe recipeToDelete = context.recipe.Find(id);
//mark recipe as deleted
context.recipe.Remove(recipeToDelete);
//send delete query to DB
context.SaveChanges();
}