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);
}
}
}
