//create product color tie public static void CreateProductColorTie(ProductColorTie productColorTie) { var sqlQuery = "INSERT INTO productcolortie (ProductId, ColorId, Amount, Discount, Stock, Updated) VALUES (@ProductId, @ColorId, @Amount, @Discount, @Stock, @Updated) "; var sqlParams = new List <MySqlParameter>() { new MySqlParameter("@ProductId", productColorTie.ProductId), new MySqlParameter("@ColorId", productColorTie.ColorId), new MySqlParameter("@Amount", productColorTie.ColorAmount), new MySqlParameter("@Discount", productColorTie.ColorDiscount), new MySqlParameter("@Stock", productColorTie.ColorStock), new MySqlParameter("@Updated", DateTime.Now) }; Db.ExecDb(sqlQuery, Database.DatabaseProcedureType.Text, sqlParams.ToArray(), Database.ReturnType.None, false); }
//update product color tie public static void UpdateProductColorTie(ProductColorTie productColorTie) { var sqlQuery = @" UPDATE productcolortie SET ColorId = @ColorId, Amount = @Amount, Discount = @Discount, Stock = @Stock, Updated = @Updated WHERE ProductColorTieId = @ProductColorTieId "; var sqlParams = new List <MySqlParameter>() { new MySqlParameter("@ProductColorTieId", productColorTie.ProductColorTieId), new MySqlParameter("@ColorId", productColorTie.ColorId), new MySqlParameter("@Amount", productColorTie.ColorAmount), new MySqlParameter("@Discount", productColorTie.ColorDiscount), new MySqlParameter("@Stock", productColorTie.ColorStock), new MySqlParameter("@Updated", DateTime.Now) }; Db.ExecDb(sqlQuery, Database.DatabaseProcedureType.Text, sqlParams.ToArray(), Database.ReturnType.None, false); }