public StockTest()
{
ingrediantUn = new Ingrediant();
IngrediantDeux = new Ingrediant();
array = new Ingrediant[2] {
ingrediantUn, IngrediantDeux
};
}
public async Task <List <Recipe> > LoadRecipes()
{
List <Recipe> recipes = new List <Recipe>();
try
{
using (SqlConnection connection = new SqlConnection(_settings.ConnectionString))
{
await connection.OpenAsync().ConfigureAwait(false);
using (SqlCommand cmd = new SqlCommand(LOAD_RECIPES, connection))
{
using (var reader = await cmd.ExecuteReaderAsync().ConfigureAwait(false))
{
while (await reader.ReadAsync().ConfigureAwait(false))
{
Recipe recipe = new Recipe();
recipe.ID = Convert.ToInt32(reader["ID"]);
recipe.Name = Convert.ToString(reader["RecipeName"]);
recipe.Description = Convert.ToString(reader["Description"]);
recipe.ImgPath = Convert.ToString(reader["ImgPath"]);
recipe.DateCreated = Convert.ToDateTime(reader["DateCreated"]);
recipe.Ingrediants = new List <Ingrediant>();
recipes.Add(recipe);
}
}
}
using (SqlCommand cmd = new SqlCommand(LOAD_INGREDIANTS, connection))
{
using (var reader = await cmd.ExecuteReaderAsync().ConfigureAwait(false))
{
while (await reader.ReadAsync().ConfigureAwait(false))
{
Ingrediant ingrediant = new Ingrediant();
ingrediant.ID = Convert.ToInt32(reader["ID"]);
ingrediant.RecipeID = Convert.ToInt32(reader["RecipeID"]);
ingrediant.Name = Convert.ToString(reader["Name"]);
ingrediant.Count = Convert.ToInt32(reader["Count"]);
Recipe recipe = recipes.Where(x => x.ID == ingrediant.RecipeID).First();
recipe.Ingrediants.Add(ingrediant);
}
}
}
connection.Close();
}
}
catch (Exception ex)
{
throw;
}
return(recipes);
}
public async Task <Recipe> LoadRecipe(int recipeID)
{
Recipe recipe = new Recipe();
using (SqlConnection connection = new SqlConnection(_settings.ConnectionString))
{
await connection.OpenAsync().ConfigureAwait(false);
using (SqlCommand cmd = new SqlCommand(LOAD_RECIPE, connection))
{
cmd.Parameters.Add("@ID", SqlDbType.Int).Value = recipeID;
using (var reader = cmd.ExecuteReader())
{
while (reader.Read())
{
recipe.ID = Convert.ToInt32(reader["ID"]);
recipe.Name = Convert.ToString(reader["RecipeName"]);
recipe.Description = Convert.ToString(reader["Description"]);
recipe.ImgPath = Convert.ToString(reader["ImgPath"]);
recipe.Ingrediants = new List <Ingrediant>();
}
}
}
using (SqlCommand cmd = new SqlCommand(LOAD_INGREDIANT, connection))
{
using (var reader = cmd.ExecuteReader())
{
cmd.Parameters.Add("@RecipeID", SqlDbType.Int).Value = recipeID;
while (reader.Read())
{
Ingrediant ingrediant = new Ingrediant();
ingrediant.ID = Convert.ToInt32(reader["ID"]);
ingrediant.RecipeID = Convert.ToInt32(reader["RecipeID"]);
ingrediant.Name = Convert.ToString(reader["Name"]);
ingrediant.Count = Convert.ToInt32(reader["Count"]);
recipe.Ingrediants.Add(ingrediant);
}
}
}
connection.Close();
}
return(recipe);
}
public RecipeTestData()
{
#region Init Recipe
// ------------------- Generel ----------------------
Recipe = new Recipe()
{
Name = "My Recipe",
Id = 1,
Calories = 1,
CookedCounter = 2,
Creator = "Tester",
LastTimeCooked = new DateTime(),
NumberOfServings = 3
};
// ------------------- Images ----------------------
var image = new RecipeImage()
{
Recipe = this.Recipe,
Id = 1,
RecipeId = Recipe.Id,
Url = "http://imageUrl.de",
Filename = "MyImage.jpg"
};
Recipe.Images.Add(image);
// ------------------- Steps ----------------------
var steps = new List <RecipeStep>()
{
new RecipeStep()
{
Recipe = Recipe, Id = 1, RecipeId = Recipe.Id, Order = 0, Description = "Step 1"
},
new RecipeStep()
{
Recipe = Recipe, Id = 2, RecipeId = Recipe.Id, Order = 1, Description = "Step 2"
}
};
Recipe.Steps.AddRange(steps);
// ------------------- Tags ----------------------
var tags = new List <RecipeTag>()
{
new RecipeTag()
{
Id = 1, Name = "Tag 1"
},
new RecipeTag()
{
Id = 2, Name = "Tag 2"
},
};
var recipeTags = new List <RecipeRecipeTag>()
{
new RecipeRecipeTag()
{
Recipe = Recipe, RecipeId = Recipe.Id, RecipeTag = tags.First(), RecipeTagId = tags.First().Id
},
new RecipeRecipeTag()
{
Recipe = Recipe, RecipeId = Recipe.Id, RecipeTag = tags.Last(), RecipeTagId = tags.Last().Id
},
};
tags.First().Recipes.Add(recipeTags.First());
tags.Last().Recipes.Add(recipeTags.Last());
Recipe.Tags.AddRange(recipeTags);
// ------------------- Source ----------------------
var source = new RecipeUrlSource()
{
Id = 1,
Name = "WebSource",
Url = "http://www.websource.de"
};
var recipeSource = new RecipeSourceRecipe()
{
Page = 0,
Recipe = Recipe,
RecipeId = Recipe.Id,
Source = source,
SourceId = source.Id
};
source.RecipeSourceRecipes.Add(recipeSource);
Recipe.Source = recipeSource;
Recipe.SourceId = source.Id;
// ------------------- Ingrediant ----------------------
var ingrediant = new Ingrediant()
{
Id = 1,
Name = "Ingrediant 1"
};
var recipeIngrediant = new RecipeIngrediant()
{
Recipe = Recipe,
RecipeId = Recipe.Id,
Ingrediant = ingrediant,
IngrediantId = ingrediant.Id,
Amount = 1,
CookingUnit = CookingUnit.Gramm
};
ingrediant.Recipes.Add(recipeIngrediant);
Recipe.Ingrediants.Add(recipeIngrediant);
#endregion
UpdateModel = new RecipeUpdateViewModel()
{
Id = 1,
Name = "Old Recipe",
Url = "http://www.webservice.de/recipes/1",
Calories = Recipe.Calories.GetValueOrDefault(),
NumberOfServings = Recipe.NumberOfServings
};
CreationModel = new RecipeCreationViewModel()
{
Name = UpdateModel.Name,
Calories = UpdateModel.Calories,
NumberOfServings = UpdateModel.NumberOfServings,
Creator = Recipe.Creator
};
}
private void InitLocalTestData()
{
//-------------------- Recipes ---------------------------------------
var recipe1 = new Recipe()
{
Id = 0,
Name = "Recipe 1",
Calories = 1,
CookedCounter = 0,
Creator = "Tester",
LastTimeCooked = new DateTime(),
NumberOfServings = 1
};
var recipe2 = new Recipe()
{
Id = 0,
Name = "Recipe 2",
Calories = 1,
CookedCounter = 0,
Creator = "Tester",
LastTimeCooked = new DateTime(),
NumberOfServings = 1
};
this.Recipes.Add(recipe1);
this.Recipes.Add(recipe2);
//-------------------- Sources ---------------------------------------
var cookbookSource = new RecipeCookbookSource()
{
Id = 0,
ISBN = "ISBN 978-3-86680-192-9",
Name = "Cookbook 1",
PublishingCompany = "ABC Corp"
};
var webSource = new RecipeUrlSource()
{
Id = 0,
Name = "Chefkoch.de",
Url = "http://www.chefkoch.de/recipe/1"
};
this.Sources.Add(cookbookSource);
this.Sources.Add(webSource);
//-------------------- Steps ---------------------------------------
var recipe1Step1 = new RecipeStep()
{
Id = 0, Recipe = recipe1, RecipeId = recipe1.Id, Order = 0, Description = "Desc 1"
};
var recipe1Step2 = new RecipeStep()
{
Id = 0, Recipe = recipe1, RecipeId = recipe1.Id, Order = 1, Description = "Desc 2"
};
var recipe2Step1 = new RecipeStep()
{
Id = 0, Recipe = recipe2, RecipeId = recipe2.Id, Order = 0, Description = "Desc 1"
};
var recipe2Step2 = new RecipeStep()
{
Id = 0, Recipe = recipe2, RecipeId = recipe2.Id, Order = 1, Description = "Desc 2"
};
var recipe2Step3 = new RecipeStep()
{
Id = 0, Recipe = recipe2, RecipeId = recipe2.Id, Order = 2, Description = "Desc 3"
};
this.Steps.Add(recipe1Step1);
this.Steps.Add(recipe1Step2);
this.Steps.Add(recipe2Step1);
this.Steps.Add(recipe2Step2);
this.Steps.Add(recipe2Step3);
recipe1.Steps.Add(recipe1Step1);
recipe1.Steps.Add(recipe1Step2);
recipe2.Steps.Add(recipe2Step1);
recipe2.Steps.Add(recipe2Step2);
recipe2.Steps.Add(recipe2Step3);
var ingrediant1 = new Ingrediant()
{
Id = 0, Name = "Ingrediant 1"
};
var ingrediant2 = new Ingrediant()
{
Id = 0, Name = "Ingrediant 2"
};
var ingrediant3 = new Ingrediant()
{
Id = 0, Name = "Ingrediant 3"
};
var ingrediant4 = new Ingrediant()
{
Id = 0, Name = "Ingrediant 4"
};
var ingrediant5 = new Ingrediant()
{
Id = 0, Name = "Ingrediant 5"
};
this.Ingrediants.Add(ingrediant1);
this.Ingrediants.Add(ingrediant2);
this.Ingrediants.Add(ingrediant3);
this.Ingrediants.Add(ingrediant4);
this.Ingrediants.Add(ingrediant5);
//-------------------- Images ---------------------------------------
var image1 = new RecipeImage()
{
Id = 0, Recipe = recipe1, RecipeId = recipe1.Id, Filename = "File1.jpg", Url = "http://www.service.de/images/1"
};
var image2 = new RecipeImage()
{
Id = 0, Recipe = recipe1, RecipeId = recipe1.Id, Filename = "File2.jpg", Url = "http://www.service.de/images/2"
};
var image3 = new RecipeImage()
{
Id = 0, Recipe = recipe2, RecipeId = recipe2.Id, Filename = "File3.jpg", Url = "http://www.service.de/images/3"
};
this.Images.Add(image1);
this.Images.Add(image2);
this.Images.Add(image3);
recipe1.Images.Add(image1);
recipe1.Images.Add(image2);
recipe2.Images.Add(image3);
//-------------------- Tags ---------------------------------------
var tag1 = new RecipeTag()
{
Id = 0, Name = "Tag 1"
};
var tag2 = new RecipeTag()
{
Id = 0, Name = "Tag 2"
};
var tag3 = new RecipeTag()
{
Id = 0, Name = "Tag 3"
};
var tag4 = new RecipeTag()
{
Id = 0, Name = "Tag 4"
};
this.Tags.Add(tag1);
this.Tags.Add(tag2);
this.Tags.Add(tag3);
this.Tags.Add(tag4);
}
