public override void Execute(object parameter)
{
//var values = (object[])parameter;
// Because of namespace we have to use "Model" prefix.
Model.Recipe recipe = (Model.Recipe)parameter;
Model.IngredientAmount ia = new IngredientAmount();
recipe.Ingredients.Add(ia);
}
public override void Execute(object parameter)
{
var values = (object[])parameter;
// Because of namespace we have to use "Model" prefix.
Model.Recipe recipe = (Model.Recipe)values[0];
_viewModel.Items.Remove(recipe);
}
public override void Execute(object parameter)
{
// Because of namespace we have to use "Model" prefix.
Model.Recipe newRecipe = new Model.Recipe();
newRecipe.Name = "New Recipe";
newRecipe.PreparationSteps = "Write the preparation steps here.";
_viewModel.Items.Add(newRecipe);
}
public override void Execute(object parameter)
{
var values = (object[])parameter;
// Because of namespace we have to use "Model" prefix.
Model.Recipe recipe = (Model.Recipe)values[0];
Model.IngredientAmount ia = (Model.IngredientAmount)values[1];
recipe.Ingredients.Remove(ia);
}
private void Add_Click(object sender, EventArgs e)
{
try
{
#if DEBUG
var newRecipe = new Model.Recipe("new recipe", null);
Navigate.ToRecipeDetail(newRecipe);
#endif
}
catch (Exception ex) { LittleWatson.ReportException(ex); }
}
protected void Page_Load(object sender, EventArgs e)
{
for (int i = 1; i <= 5; i++) {
DropDownList1.Items.Add(i.ToString());
DropDownList1.Items[i - 1].Value = i.ToString();
}
//int recipeID = 3;
if (Request["RecipeID"] != null)
{
int recipeID = Convert.ToInt32(Request["RecipeID"]);
mRecipe = Model.RecipeManagement.getRecipe(recipeID)[0];
Label1.Text = recipeID.ToString();
if (Session["UID"] != null) {
int userID = Convert.ToInt16(Session["UID"]);
AddToWishListYet = Model.WishListManagement.CheckAdded(recipeID, userID);
if (AddToWishListYet != false) {
Button3.Attributes.Add("style", "display:none");
}
}
}
}
public Model.Recipe Get(int recipeId)
{
Model.Recipe recipe = null;
using (var conn = GetConnection())
{
conn.Open();
var sql = @"
SELECT r.RecipeId, r.Title, r.RecipeDescr, r.NbrServings, r.Notes
FROM cf.Recipe r
WHERE r.RecipeId = @RecipeId
AND FamilyId = @FamilyId";
using (var cmd = new SqlCommand(sql, conn))
{
cmd.Parameters.AddWithValue("@RecipeId", recipeId);
cmd.Parameters.AddWithValue("@FamilyId", _familyId);
using (var rdr = cmd.ExecuteReader())
{
while (rdr.Read())
{
recipe = new Model.Recipe
{
RecipeId = (int)rdr["RecipeId"],
Title = (string)rdr["Title"],
RecipeDescr = (string)rdr["RecipeDescr"],
NbrServings = (int)rdr["NbrServings"],
Notes = (string)rdr["Notes"]
};
}
}
}
// Add Ingredients
sql = @"
SELECT r.IngredientId, r.Name, r.OrderId
FROM cf.RecipeIngredient r
WHERE r.RecipeId = @RecipeId
ORDER BY r.OrderId";
using (var cmd = new SqlCommand(sql, conn))
{
cmd.Parameters.AddWithValue("@RecipeId", recipeId);
using (var rdr = cmd.ExecuteReader())
{
while (rdr.Read())
{
if (recipe.Ingredients == null)
recipe.Ingredients = new List<Model.RecipeIngredient>();
recipe.Ingredients.Add(new Model.RecipeIngredient
{
IngredientId = (int)rdr["IngredientId"],
Name = (string)rdr["Name"],
OrderId = (int)rdr["OrderId"]
});
}
}
}
// Add Steps
sql = @"
SELECT r.RecipeStepId, r.StepNumber, r.StepDescr
FROM cf.RecipeStep r
WHERE r.RecipeId = @RecipeId
ORDER BY r.StepNumber";
using (var cmd = new SqlCommand(sql, conn))
{
cmd.Parameters.AddWithValue("@RecipeId", recipeId);
using (var rdr = cmd.ExecuteReader())
{
while (rdr.Read())
{
if (recipe.Steps == null)
recipe.Steps = new List<Model.RecipeStep>();
recipe.Steps.Add(new Model.RecipeStep
{
RecipeStepId = (int)rdr["RecipeStepId"],
StepNumber = (int)rdr["StepNumber"],
StepDescr = (string)rdr["StepDescr"]
});
}
}
}
conn.Close();
}
return recipe;
}
public override void Execute(object parameter)
{
Model.Recipe r = (Model.Recipe)parameter;
ViewModel.LastPlannedRecipe = r;
ViewModel.IsPlanning = true;
}
