/******************************************************************/ /* 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(); }