//create product nicotine tie
public static void CreateProductNicotineTie(ProductNicotineTie productNicotineTie)
{
var sqlQuery = "INSERT INTO productnicotinetie (ProductId, NicotineId, Amount, Discount, Stock, Updated) VALUES (@ProductId, @NicotineId, @Amount, @Discount, @Stock, @Updated) ";
var sqlParams = new List <MySqlParameter>()
{
new MySqlParameter("@ProductId", productNicotineTie.ProductId),
new MySqlParameter("@NicotineId", productNicotineTie.NicotineId),
new MySqlParameter("@Amount", productNicotineTie.NicotineAmount),
new MySqlParameter("@Discount", productNicotineTie.NicotineDiscount),
new MySqlParameter("@Stock", productNicotineTie.NicotineStock),
new MySqlParameter("@Updated", DateTime.Now)
};
Db.ExecDb(sqlQuery, Database.DatabaseProcedureType.Text, sqlParams.ToArray(), Database.ReturnType.None, false);
}
//update product nicotine tie
public static void UpdateProductNicotineTie(ProductNicotineTie productNicotineTie)
{
var sqlQuery = @" UPDATE productnicotinetie SET
NicotineId = @NicotineId,
Amount = @Amount,
Discount = @Discount,
Stock = @Stock,
Updated = @Updated
WHERE ProductNicotineTieId = @ProductNicotineTieId
";
var sqlParams = new List <MySqlParameter>()
{
new MySqlParameter("@ProductNicotineTieId", productNicotineTie.ProductNicotineTieId),
new MySqlParameter("@NicotineId", productNicotineTie.NicotineId),
new MySqlParameter("@Amount", productNicotineTie.NicotineAmount),
new MySqlParameter("@Discount", productNicotineTie.NicotineDiscount),
new MySqlParameter("@Stock", productNicotineTie.NicotineStock),
new MySqlParameter("@Updated", DateTime.Now),
};
Db.ExecDb(sqlQuery, Database.DatabaseProcedureType.Text, sqlParams.ToArray(), Database.ReturnType.None, false);
}
