private IEnumerable<Location> FindLocations(SqlMapper.GridReader multi) { var locations = multi.Read<Location>(); var sales = multi.Read<SaleInstance>(); foreach (var location in locations) location.Sales = sales.Where(s => s.SaleId == location.SaleId).ToList(); return locations; }
/// <summary> /// Creates a new <see cref="HistoryStatusCountsRecord"/> by reading from the given multi-mapped reader. /// </summary> /// <param name="multi">The multi-mapped reader to read from.</param> /// <returns>A new <see cref="HistoryStatusCountsRecord"/>.</returns> private static HistoryStatusCountsRecord CreateHistoryStatusCounts(SqlMapper.GridReader multi) { return new HistoryStatusCountsRecord() { TotalCount = multi.Read<long>().First(), SucceededCount = multi.Read<long>().First(), FailedCount = multi.Read<long>().First(), CanceledCount = multi.Read<long>().First(), TimedOutCount = multi.Read<long>().First(), InterruptedCount = multi.Read<long>().First() }; }
/// <summary> /// Creates a new <see cref="CountsRecord"/> by reading from the given multi-mapped reader. /// </summary> /// <param name="multi">The multi-mapped reader to read from.</param> /// <returns>A new <see cref="CountsRecord"/>.</returns> private static CountsRecord CreateCounts(SqlMapper.GridReader multi) { return new CountsRecord() { HistoryCount = multi.Read<long>().FirstOrDefault(), QueueCount = multi.Read<long>().FirstOrDefault(), ScheduleCount = multi.Read<long>().FirstOrDefault(), WorkerCount = multi.Read<long>().FirstOrDefault(), WorkingCount = multi.Read<long>().FirstOrDefault() }; }