private void AskForRecipeProperty(RecipeProperty prop)
{
if (prop == null)
{
return;
}
_toFetch.Add(new FetchingObject()
{
PrimaryKey = prop.PropertyId,
Type = "RecipeProperty"
});
}
private void TranslateRecipeProperty(RecipeProperty prop, string language)
{
if (prop == null)
{
return;
}
var specs = _data[$"{prop.PropertyId}RecipeProperty"];
if (specs.ContainsKey("Type"))
{
prop.Type = specs["Type"];
}
if (specs.ContainsKey("Value"))
{
prop.Value = specs["Value"];
}
}
// GET: Filler
public IHttpActionResult Index()
{
string filename = @"C:\Users\Jasper De Vrient\Documents\Tin3\Project III\ApiBackEnd\EVARest\EVARest\recepten.json";
IDictionary <string, RecipeProperty> properties = new Dictionary <string, RecipeProperty>();
IDictionary <string, Ingredient> ingredients = new Dictionary <string, Ingredient>();
IList <Recipe> recipeObjects = new List <Recipe>();
const string r_prop = "properties";
const string r_title = "title";
const string r_image = "image";
const string r_description = "description";
const string r_ingredients = "ingredients";
const string c_ingredient = "ingredient";
const string i_name = "name";
const string i_prefix = "prefix";
const string i_postfix = "postfix";
int successes = 0;
int failures = 0;
using (StreamReader file = File.OpenText(filename))
using (JsonTextReader reader = new JsonTextReader(file)) {
JArray recepten = (JArray)JToken.ReadFrom(reader);
Console.WriteLine($"{recepten.Count} Recepten gelezen uit json.");
foreach (JObject recipeJson in recepten)
{
try {
Recipe r = new Recipe();
r.Name = recipeJson[r_title].ToString();
r.Image = recipeJson[r_image].ToString();
r.Description = recipeJson[r_description].ToString();
foreach (JObject component in recipeJson[r_ingredients])
{
Component c = new Component();
int amount = 0;
// if (int.TryParse(component[c_count].ToString(), out amount))
c.Prefix = component[c_ingredient][i_prefix].ToString();
c.Postfix = component[c_ingredient][i_postfix].ToString();
var iname = component[c_ingredient][i_name].ToString();
if (!ingredients.ContainsKey(iname))
{
Ingredient i = new Ingredient();
i.Name = component[c_ingredient][i_name].ToString();
ingredients[i.Name] = i;
}
c.Ingredient = ingredients[iname];
r.Ingredients.Add(c);
}
foreach (var kv in JsonConvert.DeserializeObject <Dictionary <string, string> >(recipeJson[r_prop].ToString()))
{
var joinedkey = kv.Key + kv.Value;
if (!properties.ContainsKey(joinedkey))
{
properties[joinedkey] = new RecipeProperty {
Type = kv.Key, Value = kv.Value
}
}
;
r.Properties.Add(properties[joinedkey]);
}
recipeObjects.Add(r);
successes++;
} catch {
failures++;
}
}
Console.WriteLine($"ERROR: {failures}");
Console.WriteLine($"SUCCES: {successes}");
}
try {
Console.WriteLine("Attempting connection with database.");
Console.WriteLine("Connection succeeded.");
Console.WriteLine("Start Writing.");
foreach (var recipe in recipeObjects)
{
_context.Recipes.Add(recipe);
}
_context.SaveChanges();
Console.WriteLine("Connection closed.");
} catch (Exception ex) {
Console.Error.WriteLine(ex.Message);
}
try {
filename = @"C:\Users\Jasper De Vrient\Documents\Tin3\Project III\ApiBackEnd\EVARest\EVARest\restaurants.json";
const string rest_name = "name";
const string rest_lng = "lng";
const string rest_lat = "lat";
const string rest_website = "website";
const string rest_street = "street";
const string rest_postal = "postal";
const string rest_city = "city";
const string rest_phone = "phone";
const string rest_mail = "mail";
const string rest_body = "body";
using (StreamReader file = File.OpenText(filename))
using (JsonTextReader reader = new JsonTextReader(file)) {
JArray restaurants = (JArray)JToken.ReadFrom(reader);
foreach (var r in restaurants)
{
var restaurant = new Restaurant();
restaurant.Name = r[rest_name].ToString();
if (r[rest_lng] != null)
{
double outing;
if (double.TryParse(r[rest_lng].ToString(), out outing))
{
restaurant.Longitute = outing;
}
}
if (r[rest_lat] != null)
{
double outing;
if (double.TryParse(r[rest_lat].ToString(), out outing))
{
restaurant.Latitude = outing;
}
}
if (r[rest_postal] != null)
{
int outing;
if (int.TryParse(r[rest_postal].ToString(), out outing))
{
restaurant.Postal = outing;
}
}
if (r[rest_body] != null)
{
restaurant.Description = r[rest_body].ToString();
}
if (r[rest_city] != null)
{
restaurant.City = r[rest_city].ToString();
}
if (r[rest_mail] != null)
{
restaurant.Email = r[rest_mail].ToString();
}
if (r[rest_phone] != null)
{
restaurant.Phone = r[rest_phone].ToString();
}
if (r[rest_street] != null)
{
restaurant.Street = r[rest_street].ToString();
}
if (r[rest_website] != null)
{
restaurant.Website = r[rest_website].ToString();
}
_context.Restaurants.Add(restaurant);
}
}
_context.SaveChanges();
} catch (Exception ex) {
Console.Error.WriteLine(ex.Message);
}
return(Ok());
}
public IQueryable <Recipe> FindRecipesByProperty(RecipeProperty property)
{
return(Recipes.Where(r => r.Properties.Contains(property)));
}
set => this.SetValue(RecipeProperty, value);
public static IQueryable <Recipe> FindRecipesByProperty(this IQueryable <Recipe> recipes, RecipeProperty property)
{
return(recipes.Where(r => r.Properties.Contains(property)));
}
