/// <summary>
/// Inserts the formcollection data into the database
/// </summary>
/// <param name="meal">A struct with the collection data</param>
/// <param name="uid">The UserID of the current User</param>
public void SaveToDatabase(MealCollection meal, int uid)
{
using var connection = db.Connect();
connection.Execute("INSERT INTO maaltijden (UserID, Name, Description, PhotoPath) VALUES (@uid, @name, @description, @imagePath)", new {
uid,
name = meal.Name,
description = meal.Description,
imagePath = meal.ImagePath
});
int mealid = this.getMealID(uid, meal.Name, meal.Description);
connection.Execute("INSERT INTO maaltijd_info (MealID, AmountAvailable, Type, PortionPrice, PortionWeight, Fresh, PreparedOn, Availability) VALUES (@mealid, @amount, @category, @price, @weight, @frozen, @date, @availability)", new {
mealid,
amount = meal.Amount,
category = meal.Category,
price = meal.Price,
weight = meal.Weight,
frozen = meal.Fresh,
date = meal.Date,
availability = meal.Availability
});
foreach (var ingredient in this.ParseIngredients(meal.Ingredients))
{
connection.Execute($"INSERT INTO maaltijd_ingredienten (MealID, Ingredient) VALUES (@mealid, @ingredients)", new { mealid, ingredients = ingredient });
}
}
public void UpdateToDatabase(MealCollection meal, int mealid)
{
using var connection = db.Connect();
connection.Execute("UPDATE maaltijden SET Name=@name, Description=@description WHERE MealID=@id", new {
name = meal.Name,
description = meal.Description,
id = mealid
});
if (meal.ImagePath is not null)
{
connection.Execute("UPDATE maaltijden SET PhotoPath=@photopath WHERE MealID=@id", new { photopath = meal.ImagePath, id = mealid });
}
connection.Execute("UPDATE maaltijd_info SET AmountAvailable=@amount, Type=@type, PortionPrice=@price, PortionWeight=@weight, Fresh=@fresh, PreparedOn=@date, Availability=@availability WHERE MealID=@id", new {
amount = meal.Amount,
type = meal.Category,
price = meal.Price,
weight = meal.Weight,
fresh = meal.Fresh,
date = meal.Date,
availability = meal.Availability,
id = mealid
});
foreach (var ingredient in this.UpdateIngredients(meal.Ingredients, mealid))
{
connection.Execute($"INSERT INTO maaltijd_ingredienten (MealID, Ingredient) VALUES (@mealid, @ingredients)", new { mealid, ingredients = ingredient });
}
}
