public async Task <bool> Product_StockExists(IProduct_Stock product_Stock)
{
var param = new
{
Date = product_Stock.Date.ToShortDateString(),
product_Stock.Product_UID
};
string query = @"SELECT * FROM Product_Stock WHERE [Product_UID] LIKE @Product_UID AND [Date] LIKE @Date ";
return(await _dataBaseManager.Find <Product_Stock>(query, param) != null);
}
public async Task <bool> AddProduct_Stock(IProduct_Stock product_Stock)
{
var param = new
{
product_Stock.UID,
product_Stock.Init_Qte,
product_Stock.Status,
product_Stock.Date,
product_Stock.Product_UID
};
return(await _dataBaseManager.Add("SP_ADD_Product_Stock", param));
}
public async Task <bool> ModifyProduct_Stock(IProduct_Stock modifiedProduct_Stock)
{
var param = new
{
modifiedProduct_Stock.UID,
modifiedProduct_Stock.Init_Qte,
modifiedProduct_Stock.Current_Qte,
modifiedProduct_Stock.Status,
modifiedProduct_Stock.Date,
modifiedProduct_Stock.Product_UID
};
return(await _dataBaseManager.Modify("SP_UPDATE_Product_Stock", param));
}
