public async Task <IList <InitPersonalityTestView> > Handle(
GetInitialPersonalityTest request,
CancellationToken cancellationToken)
{
var result = await _queryDbConnector.FetchAsync <List <InitPersonalityTestView> >(
sql : PersonalityTestSqlQueries.InitialTest,
mapping : (reader, list) => list.Add(ParseReaderResult(reader)),
cancellationToken : cancellationToken);
return(result);
}
public async Task <Option <IList <UserView>, Error> > Handle(
GetAllUserAccounts request,
CancellationToken cancellationToken)
{
var result = await _queryDbConnector.FetchAsync <List <UserView> >(
sql : UserAccountQueryRepository.UserAccountsQuery,
mapping : (reader, users) => users.Add(reader.Get <UserView>()),
cancellationToken : cancellationToken);
return(result.Some <IList <UserView>, Error>());
}
public async Task <Option <IList <RestaurantWithAvrgRatingView>, Error> > Handle(GetAllRestaurantsByTown request, CancellationToken cancellationToken)
{
var result = await _queryDbConnector.FetchAsync <List <RestaurantWithAvrgRatingView> >(
sql : RestaurantQueryRepository.RestaurantsByTownQuery,
mapping : (reader, restaurants) => restaurants.Add(reader.Get <RestaurantWithAvrgRatingView>()),
parameters : new Dictionary <string, object>
{
{ "@TownID", request.TownId }
},
cancellationToken : cancellationToken);
return(result.Some <IList <RestaurantWithAvrgRatingView>, Error>());
}
public async Task <IEnumerable <PendingOrderView> > PendingOrdersAsync(
Guid userId,
int limit,
int startPage,
CancellationToken cancellationToken)
{
var result = await _queryDbConnector.FetchAsync <List <PendingOrderView> >(
OrderQueryRepository.PendingOrdersByUserIdWithPagingQuery,
(reader, orders) => orders.Add(ParseReaderResult(reader)),
new Dictionary <string, object>
{
{ "@UserID", userId },
{ "@LimitCount", limit },
{ "@OffsetCount", startPage *limit }
},
cancellationToken);
return(result);
}
