//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);
}
