public async Task <bool> ModifyProduct_Command(IProduct_Command modifiedProduct_Command)
{
var param = new
{
modifiedProduct_Command.UID,
modifiedProduct_Command.Date,
modifiedProduct_Command.UID_Supplier
};
return(await _dataBaseManager.Modify("SP_UPDATE_Product_Command", param));
}
public async Task <bool> Product_CommandExists(IProduct_Command product_Command)
{
string query = @"SELECT * FROM Product_Command WHERE [Date] LIKE @date AND UID_Supplier LIKE @UID_Supplier";
var param = new
{
date = product_Command.Date.ToShortDateString(),
product_Command.UID_Supplier
};
return(await _dataBaseManager.Find <Product_Command>(query, param) != null);
}
public async Task <bool> AddProduct_Command(IProduct_Command product_Command)
{
var param = new
{
product_Command.UID,
product_Command.Date,
product_Command.UID_Supplier
};
return(await _dataBaseManager.Add("SP_ADD_Product_Command", param));
}
