//create product Size tie
public static void CreateProductSizeTie(ProductSizeTie productSizeTie)
{
var sqlQuery = "INSERT INTO productsizetie (ProductId, SizeId, Amount, Discount, Stock, Updated) VALUES (@ProductId, @SizeId, @Amount, @Discount, @Stock, @Updated) ";
var sqlParams = new List <MySqlParameter>()
{
new MySqlParameter("@ProductId", productSizeTie.ProductId),
new MySqlParameter("@SizeId", productSizeTie.SizeId),
new MySqlParameter("@Amount", productSizeTie.SizeAmount),
new MySqlParameter("@Discount", productSizeTie.SizeDiscount),
new MySqlParameter("@Stock", productSizeTie.SizeStock),
new MySqlParameter("@Updated", DateTime.Now)
};
Db.ExecDb(sqlQuery, Database.DatabaseProcedureType.Text, sqlParams.ToArray(), Database.ReturnType.None, false);
}
//update product Size tie
public static void UpdateProductSizeTie(ProductSizeTie productSizeTie)
{
var sqlQuery = @" UPDATE productsizetie SET
SizeId = @SizeId,
Amount = @Amount,
Discount = @Discount,
Stock = @Stock,
Updated = @Updated
WHERE ProductSizeTieId = @ProductSizeTieId
";
var sqlParams = new List <MySqlParameter>()
{
new MySqlParameter("@ProductSizeTieId", productSizeTie.ProductSizeTieId),
new MySqlParameter("@SizeId", productSizeTie.SizeId),
new MySqlParameter("@Amount", productSizeTie.SizeAmount),
new MySqlParameter("@Discount", productSizeTie.SizeDiscount),
new MySqlParameter("@Stock", productSizeTie.SizeStock),
new MySqlParameter("@Updated", DateTime.Now)
};
Db.ExecDb(sqlQuery, Database.DatabaseProcedureType.Text, sqlParams.ToArray(), Database.ReturnType.None, false);
}
