public async Task <IEnumerable <StoreResponseModel> > FilterStoresAsync <T>(BaseFilterRequestModel <int> filter) { await using (var connection = new NpgsqlConnection(_connectionString)) { connection.Open(); var x = await connection.QueryAsync <StoreResponseModel>("SELECT * FROM ims.stores " + "WHERE name LIKE @t AND (store_type_id=@stid OR @stid=0)", new { t = "%" + filter.typed + "%", stid = Equals(filter.id, default(T)) ? 0 : filter.id }); return(x); } }
public async Task <IEnumerable <InvestmentToolResponseModel> > FilterInvestmentToolAsync([FromQuery] BaseFilterRequestModel <int> filter) { return(await _queries.FilterInvestmentToolAsync <int>(filter)); }
public async Task <IEnumerable <InvestmentToolResponseModel> > FilterInvestmentToolAsync <T>(BaseFilterRequestModel <int> queryString) { await using (var connection = new NpgsqlConnection(_connectionString)) { connection.Open(); return(await connection.QueryAsync <InvestmentToolResponseModel>("SELECT * FROM ims.investment_tools " + "WHERE name LIKE @t AND (investment_tool_type_id=@ittid OR @ittid=0)", new { t = "%" + queryString.typed + "%", ittid = Equals(queryString.id, default(T)) ? 0 : queryString.id })); } }
public async Task <IEnumerable <StoreResponseModel> > FilterStoresAsync([FromQuery] BaseFilterRequestModel <int> filter) { return(await _queries.FilterStoresAsync <int>(filter)); }
public async Task <IEnumerable <StoreBranchResponseModel> > FilterStoreBranchesAsync([FromQuery] BaseFilterRequestModel <string> queryString) { var filter = new BaseFilterRequestModel <Guid> { typed = queryString.typed, id = !Guid.TryParse(queryString.id, out var storeId) ? Guid.Empty : storeId }; return(await _queries.FilterStoreBranchesAsync <Guid>(filter)); }