static Recipe search(int id) { try { RecipesEntities re = new RecipesEntities(); Recipe recipe = (Recipe)re.Recipes.Where(r => r.Id == id).First(); return(recipe); } catch (Exception Ex) { Console.WriteLine("Exception : " + Ex.Message); return(null); } }
static List <Recipe> allRecip() { using (var context = new RecipesEntities()) { try { return(context.Recipes.ToList()); } catch (Exception Ex) { Console.WriteLine("Error : " + Ex.Message); return(null); } } }
static Boolean delete(int id) { try { RecipesEntities re = new RecipesEntities(); Recipe recipe = (Recipe)re.Recipes.Where(r => r.Id == id).First(); re.Recipes.Remove(recipe); re.SaveChanges(); return(true); } catch (Exception Ex) { Console.WriteLine("Exception : " + Ex.Message); return(false); } }
static Boolean insert(Recipe r) { using (RecipesEntities context = new RecipesEntities()) { try { context.Recipes.Add(r); context.SaveChanges(); return(true); } catch (Exception Ex) { Console.WriteLine("Error : " + Ex.Message); return(false); } } }
static Boolean Update(int id, Recipe res) { using (RecipesEntities context = new RecipesEntities()) { try { Recipe recipe = (Recipe)context.Recipes.Where(r => r.Id == id).First(); recipe.Name = res.Name; context.SaveChanges(); return(true); } catch (Exception Ex) { Console.WriteLine("Error : " + Ex.Message); return(false); } } }