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