public async Task <bool> Product_BrandExists(IProduct_Brand product_Brand)
{
string query = @"SELECT * FROM Product_Brand WHERE [UID] LIKE @UID
OR TRIM(LOWER(BRA_Name)) LIKE TRIM(LOWER(@BRA_Name))";
var param = new {
product_Brand.UID
, product_Brand.BRA_Name
};
return(await _dataBaseManager.Find <Product_Brand>(query, param) != null);
}
public async Task <bool> ModifyProduct_Brand(IProduct_Brand modifiedProduct_Brand)
{
var param = new
{
modifiedProduct_Brand.UID,
modifiedProduct_Brand.BRA_Name,
modifiedProduct_Brand.BRA_Description,
modifiedProduct_Brand.BRA_Date
};
return(await _dataBaseManager.Modify("SP_UPDATE_Product_Brand", param));
}
public async Task <bool> AddProduct_Brand(IProduct_Brand product_Brand)
{
var param = new
{
product_Brand.UID,
product_Brand.BRA_Name,
product_Brand.BRA_Description,
product_Brand.BRA_Date
};
return(await _dataBaseManager.Add("SP_ADD_Product_Brand", param));
}