public int Delete(string sku)
{
var data = new Data();
var skuParameter = new SqlParameter("@pSku", sku);
var allParams = new SqlParameter[] { skuParameter };
return(data.ExecuteWithoutResult("DELETE FROM Product WHERE sku = @pSku", allParams));
}
public int Update(string sku, string name, double price, bool enabled, int minQuantity, int maxQuantity)
{
var data = new Data();
var pSku = new SqlParameter("@pSku", sku);
var pName = new SqlParameter("@pName", name);
var pPrice = new SqlParameter("@pPrice", price);
var pEnabled = new SqlParameter("@pEnabled", enabled);
var pMinQuantity = new SqlParameter("@pMinQuantity", minQuantity);
var pMaxQuantity = new SqlParameter("@pMaxQuantity", maxQuantity);
var allParams = new SqlParameter[] { pSku, pName, pPrice, pEnabled, pMinQuantity, pMaxQuantity };
return(data.ExecuteWithoutResult("UPDATE PRODUCT SET name = @pName, price = @pPrice, is_enabled = @pEnabled, min_quantity = @pMinQuantity, max_quantity = @pMaxQuantity WHERE sku = @pSku", allParams));
}
public int Insert(string sku, string brand, string name, double price, bool isEnabled, int minQuantity, int maxQuantity, int productTypeId)
{
var data = new Data();
var pSku = new SqlParameter("@pSku", sku);
var pBrand = new SqlParameter("pBrand", brand);
var pName = new SqlParameter("@pName", name);
var pPrice = new SqlParameter("@pPrice", price);
var pEnabled = new SqlParameter("@pEnabled", isEnabled);
var pMinQuantity = new SqlParameter("@pMinQuantity", minQuantity);
var pMaxQuantity = new SqlParameter("@pMaxQuantity", maxQuantity);
var pProductType = new SqlParameter("@pProductTypeId", productTypeId);
var allParams = new SqlParameter[] { pSku, pBrand, pName, pPrice, pEnabled, pMinQuantity, pMaxQuantity, pProductType };
return(data.ExecuteWithoutResult("INSERT INTO Product (sku, brand, name, price, is_enabled, min_quantity, max_quantity, product_type_id) VALUES (@pSku, @pBrand, @pName, @pPrice, @pEnabled, @pMinQuantity, @pMaxQuantity, @pProductTypeId)", allParams));
}