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)); }