// Custom methods for each tab of the data tables. They will execute the method above and return a list of objects (corresponding to the table). public void UpdateProudctComposition(ProductComposition productComposition, string[] whereColumns = null, string[] whereValues = null, string comparisonSymbol = "=") { string[] setColumns = { "id", "quantite_produit", "refProduit", "nomRecette" }; string[] setValues = { "'" + productComposition.Id + "'", Convert.ToString(productComposition.Quantity), "'" + productComposition.RefProduct + "'", "'" + productComposition.RecipeName + "'" }; Update <ProductComposition>(productComposition, setColumns, setValues, whereColumns, whereValues, comparisonSymbol); }
public void InsertProudctComposition(string id, int quantity, string refProduct, string recipeName) { ProductComposition productComposition = new ProductComposition(id, quantity, refProduct, recipeName); Insert <ProductComposition>(productComposition); }
/// <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); }