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