public async Task <IEnumerable <GenericEvent> > GetSinceEvent(IEnumerable <string> eventTypes, long fromEventId, int pageSize, int pageNumber) { var offset = pageSize * (pageNumber - 1); var parameters = new EventTypeTableParam(eventTypes); parameters.Add("@fromEventId", DbType.Int64, fromEventId); parameters.Add("@pageSize", DbType.Int32, pageSize); parameters.Add("@offset", DbType.Int32, offset); var result = await WithConnection(async c => await c.QueryAsync <GenericEvent>( sql: "[dbo].[GetGenericEventsSinceEvent]", param: parameters, commandType: CommandType.StoredProcedure)); return(result); }
public async Task <IEnumerable <GenericEvent> > GetByDateRange(IEnumerable <string> eventTypes, DateTime fromDate, DateTime toDate, int pageSize, int pageNumber) { var offset = pageSize * (pageNumber - 1); var parameters = new EventTypeTableParam(eventTypes); parameters.Add("@fromDate", DbType.DateTime, fromDate); parameters.Add("@toDate", DbType.DateTime, toDate); parameters.Add("@pageSize", DbType.Int32, pageSize); parameters.Add("@offset", DbType.Int32, offset); var result = await WithConnection(async c => await c.QueryAsync <GenericEvent>( sql: "[dbo].[GetGenericEventsByDateRange]", param: parameters, commandType: CommandType.StoredProcedure)); return(result); }