public void UpdateRecipeCreator(RecipeCreator recipeCreator, string[] whereColumns = null, string[] whereValues = null, string comparisonSymbol = "=")
{
string[] setColumns = { "numero" };
string[] setValues = { "'" + recipeCreator.Id + "'" };
Update <RecipeCreator>(recipeCreator, setColumns, setValues, whereColumns, whereValues, comparisonSymbol);
}
public void DeleteRecipeCreator(RecipeCreator recipeCreator)
{
List <Recipe> recipes = SelectRecipe(new string[] { "numeroCreateur" }, new string[] { $"'{recipeCreator.Id}'" });
foreach (Recipe recipe in recipes)
{
DeleteRecipe(recipe);
}
Delete(recipeCreator, new string[] { "numero" }, new string[] { $"'{recipeCreator.Id}'" });
}
public void InsertRecipeCreator(string phoneNumber)
{
RecipeCreator recipeCreator = new RecipeCreator(phoneNumber);
Insert <RecipeCreator>(recipeCreator);
}
/// <summary>
/// Convert the result of the sql request in an object
/// </summary>
/// <param name="value"></param>
/// <param name="tableType"></param>
/// <returns></returns>
public static ITable ConvertFromString(string value, TableType tableType)
{
string[] values = value.Split(';');
ITable valueConverted = null;
switch (tableType)
{
case TableType.client:
valueConverted = new Client(
name: values[0],
money: Convert.ToInt32(values[1]),
adress: values[2],
phoneNumber: values[3],
email: values[4],
password: values[5],
userType: (UserType)(Enum.Parse(typeof(UserType), values[6])));
break;
case TableType.order:
valueConverted = new Order(
id: values[0],
orderDate: DateTime.Parse(values[1]),
clientNumber: values[2],
recipeName: values[3]
);
break; // dateValue.ToString("yyyy-MM-dd HH:mm:ss"); dans l'autre sens
case TableType.recipe:
valueConverted = new Recipe(
name: values[0],
recipeType: (RecipeType)(Enum.Parse(typeof(RecipeType), values[1])),
description: values[2],
price: Convert.ToInt32(values[3]),
numberCreator: values[4],
isHealthy: values[5].Equals("True"),
isBio: values[6].Equals("True"),
isVegan: values[7].Equals("True"),
isChimical: values[8].Equals("True"),
isTrending: values[9].Equals("True"),
rating: Convert.ToInt32(values[10]));
break;
case TableType.product:
valueConverted = new Product(
reference: values[0],
name: values[1],
productCategory: (ProductCategory)(Enum.Parse(typeof(ProductCategory), values[2])),
currentQuantity: Convert.ToInt32(values[3]),
minQuantity: Convert.ToInt32(values[4]),
maxQuantity: Convert.ToInt32(values[5]),
unit: values[6],
providerNumber: values[7]
);
break;
case TableType.supplier:
valueConverted = new Supplier(
name: values[0],
number: values[1]
);
break;
case TableType.recipeCreator:
valueConverted = new RecipeCreator(
id: values[0]
);
break;
case TableType.productComposition:
valueConverted = new ProductComposition(
id: values[0],
quantity: Convert.ToInt32(values[1]),
refProduct: values[2],
recipeName: values[3]
);
break;
default:
Console.WriteLine("ERROR : TableType unknown! (Converter : ConvertFromString)");
break;
}
return(valueConverted);
}
