public async Task <bool> ModifyProduct_Category(IProduct_Category modifiedProduct_Category)
{
var param = new
{
modifiedProduct_Category.UID,
modifiedProduct_Category.CAT_Date,
modifiedProduct_Category.CAT_Description,
modifiedProduct_Category.CAT_Name
};
return(await _dataBaseManager.Modify("SP_UPDATE_Product_Category", param));
}
public async Task <bool> Product_CategoryExists(IProduct_Category product_Category)
{
string query = @"SELECT * FROM Product_Category WHERE [UID] LIKE @UID OR
TRIM(LOWER(CAT_Name)) LIKE TRIM(LOWER(@CAT_Name))";
var param = new
{
product_Category.UID,
product_Category.CAT_Name
};
return(await _dataBaseManager.Find <Product_Category>(query, param) != null);
}
public async Task <bool> AddProduct_Category(IProduct_Category product_Category)
{
var param = new
{
product_Category.UID,
product_Category.CAT_Date,
product_Category.CAT_Description,
product_Category.CAT_Name
};
return(await _dataBaseManager.Add("SP_ADD_Product_Category", param));
}
