protected void btnAddIngredient_Click(object sender, EventArgs e)
{
Int32 RecipeID;
try
{
if (!String.IsNullOrEmpty(Request.QueryString["recipe_id"]))
{
//get the recipe id
RecipeID = Convert.ToInt32(Request.QueryString["recipe_id"]);
}
else
{
//connect
using (DefaultConnectionEF conn = new DefaultConnectionEF())
{
//instantiate a new recipe object in memory
Recipe r = new Recipe();
//fill the properties of our object from the form inputs
r.recipe_name = txtRecipeName.Text;
r.directions = txtRecipeDirections.Text;
//add the new object and save changes
conn.Recipes.Add(r);
conn.SaveChanges();
//get recipe info
var Recipe = (from rec in conn.Recipes
where rec.recipe_name == r.recipe_name && rec.directions == r.directions
select new { rec.recipe_id}).FirstOrDefault();
RecipeID = Recipe.recipe_id;
}
}
Response.Redirect("~/Admin/ingredient.aspx?recipe_id=" + RecipeID);
}
catch (Exception ex)
{
lblError.Text = ex.Message;
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
try
{
if (String.IsNullOrEmpty(Request.QueryString["recipe_id"]))
{
lblIngredientMessage.Text = "At Least One Ingredent Must be Added";
lblIngredientMessage.Visible = true;
}
else
{
using (DefaultConnectionEF conn = new DefaultConnectionEF())
{
Recipe r = new Recipe();
Int32 RecipeID = Convert.ToInt32(Request.QueryString["recipe_id"]);
r = (from rec in conn.Recipes
where rec.recipe_id == RecipeID
select rec).FirstOrDefault();
//fill the properties of our object from the form inputs
r.recipe_name = txtRecipeName.Text;
r.directions = txtRecipeDirections.Text;
conn.SaveChanges();
lblIngredientMessage.Visible = false;
Response.Redirect("/Admin/recipes.aspx");
}
}
}
catch (Exception exception)
{
lblError.Text = exception.Message;
}
}