Esempio n. 1
0
        private async Task <IReadOnlyCollection <SessionFrequentTimeModel> > LoadTimes()
        {
            var query = new SessionFrequentTimeQuery(User, Tenant.Value.Id);
            var items = await Mediator.Send(query);

            return(items);
        }
        protected override async Task <IReadOnlyCollection <SessionFrequentTimeModel> > Process(SessionFrequentTimeQuery request, CancellationToken cancellationToken)
        {
            var results = await _dataSession
                          .StoredProcedure("[IQ].[FrequentSessionTimes]")
                          .Parameter("@tenantId", request.TenantId)
                          .QueryAsync(r =>
            {
                var reader = r as SqlDataReader;
                return(new SessionFrequentTimeModel
                {
                    StartTime = reader.GetTimeSpan(0),
                    EndTime = reader.GetTimeSpan(1),
                    Count = r.GetInt32(2)
                });
            }, cancellationToken);

            return(results.ToList());
        }