public static void AddPaging( this IHeaderDictionary header, CollectionQueryParameters queryParameters, int totalCount, int maxPages = 500) { var skip = queryParameters.Skip ?? 0; var pageSize = queryParameters.Top ?? maxPages; int currentPage = (skip / pageSize) + 1; int totalPages = totalCount > 0 ? (int)Math.Ceiling(totalCount / (double)pageSize) : 0; var paginationHeader = new { currentPage, pageSize, totalCount, totalPages }; header.Add("X-Pagination", JsonConvert.SerializeObject(paginationHeader)); }
public async Task <(int, IEnumerable <StudentOutputDto>)> GetAsync(CollectionQueryParameters queryParameters) { var repository = (StudentQueryRepository)RepositoryContext.GetQueryRepository(typeof(Student)); var(count, entities) = await repository.GetNotEnrolledAsync(queryParameters); var data = new Tuple <int, IEnumerable <IEntity> >(count, entities); return(await GetAsync(data)); }
public (int, IEnumerable <ApplicationLogOutputDto>) Get(CollectionQueryParameters queryParameters) { var repository = (ApplicationLogQueryRepository)RepositoryContext.GetQueryRepository(typeof(ApplicationLog)); var(count, entities) = repository.Get(queryParameters); var data = new Tuple <int, IEnumerable <IEntity> >(count, entities); return(Get(data)); }
public override async Task <(int, IEnumerable <PersonEntity3>)> GetAsync(CollectionQueryParameters parameters) { var result = await Query <PersonEntity3> .Collection() .Connection(ConnectionName) .StoredProcedure("p_Person_GetAll") .ExecuteAsync(); return(result.Count, result.Records); }
public (int, IEnumerable <StudentOutputDto>) Get(CollectionQueryParameters queryParameters) { var repository = (StudentQueryRepository)RepositoryContext.GetQueryRepository(typeof(Student)); var(count, entities) = repository.GetNotEnrolled(queryParameters); var data = new Tuple <int, IEnumerable <IEntity> >(count, entities); return(Get(data)); }
public CollectionQueryParameters Build() { var queryParameters = new CollectionQueryParameters(); foreach (var query in _queryCollection) { var value = query.Value.SingleOrDefault(); switch (query.Key.ToLowerInvariant()) { case "$top": { queryParameters.Top = int.Parse(value); } break; case "$skip": { queryParameters.Skip = int.Parse(value); } break; case "$select": { queryParameters.Select = value .Split(',', StringSplitOptions.RemoveEmptyEntries) .Select(f => f.Trim()); } break; case "$filter": { queryParameters.Filter = new ODataFilterBuilder() .Build(value); } break; case "$orderby": { queryParameters.OrderBy = new ODataOrderByBuilder() .Build(value); } break; default: { queryParameters.ExtraParameters.Add(query.Key, value); } break; } } return(queryParameters); }
public override (int, IEnumerable <Page>) Get(CollectionQueryParameters queryParameters) { var result = Query <Page> .Collection() .Connection(BookWithPagesConnectionClass.GetConnectionName()) .StoredProcedure("[BookBoundedContext].[pPage_Get]") .QueryParameters(queryParameters) .Parameters(p => p.Name("count").Count()) .Execute(); return(result.Count, result.Records); }
public override (int, IEnumerable <SimpleLog>) Get(CollectionQueryParameters queryParameters) { var result = Query <SimpleLog> .Collection() .Connection(SimpleLogsConnectionClass.GetConnectionName()) .StoredProcedure("[SimpleLogsBoundedContext].[pSimpleLog_Get]") .QueryParameters(queryParameters) .Parameters(p => p.Name("count").Count()) .Execute(); return(result.Count, result.Records); }
public async Task <(int, IEnumerable <Student>)> GetNotEnrolledAsync(CollectionQueryParameters queryParameters) { var result = await Query <Student> .Collection() .Connection(ClassesWithStudentsConnectionClass.GetConnectionName()) .StoredProcedure("[ClassBoundedContext].[Student_GetNotEnrolled]") .QueryParameters(queryParameters) .Parameters(p => p.Name("count").Count()) .ExecuteAsync(); return(result.Count, result.Records); }
public override (int, IEnumerable <Truck>) Get(CollectionQueryParameters queryParameters) { var result = Query <Truck> .Collection() .Connection(MechanicServicesSeveralVehiclesConnectionClass.GetConnectionName()) .StoredProcedure("[GarageBoundedContext].[pTruck_Get]") .QueryParameters(queryParameters) .Parameters(p => p.Name("count").Count()) .Execute(); return(result.Count, result.Records); }
public async override Task <(int, IEnumerable <Course>)> GetAsync(CollectionQueryParameters queryParameters) { var result = await Query <Course> .Collection() .Connection(CourseWithPreRequisitesAndRelatedConnectionClass.GetConnectionName()) .StoredProcedure("[CourseBoundedContext].[pCourse_Get]") .QueryParameters(queryParameters) .Parameters(p => p.Name("count").Count()) .ExecuteAsync(); return(result.Count, result.Records); }
public async override Task <(int, IEnumerable <Employee>)> GetAsync(CollectionQueryParameters queryParameters) { var result = await Query <Employee> .Collection() .Connection(EmployeeWithSpouseConnectionClass.GetConnectionName()) .StoredProcedure("[EmployeeBoundedContext].[pEmployee_Get]") .QueryParameters(queryParameters) .Parameters(p => p.Name("count").Count()) .ExecuteAsync(); return(result.Count, result.Records); }
public override (int, IEnumerable <Address>) Get(CollectionQueryParameters queryParameters) { var result = Query <Address> .Collection() .Connection(SchoolRoleOrganizationAddressConnectionClass.GetConnectionName()) .StoredProcedure("[SchoolBoundedContext].[pAddress_Get]") .QueryParameters(queryParameters) .Parameters(p => p.Name("count").Count()) .Execute(); return(result.Count, result.Records); }
public async override Task <(int, IEnumerable <Book>)> GetAsync(CollectionQueryParameters queryParameters) { var result = await Query <Book> .Collection() .Connection(BookWithPagesConnectionClass.GetConnectionName()) .StoredProcedure("[BookBoundedContext].[pBook_Get]") .QueryParameters(queryParameters) .Parameters(p => p.Name("count").Count()) .ExecuteAsync(); return(result.Count, result.Records); }
public async override Task <(int, IEnumerable <Country>)> GetAsync(CollectionQueryParameters queryParameters) { var result = await Query <Country> .Collection() .Connection(CountryWithCapitalCityConnectionClass.GetConnectionName()) .StoredProcedure("[CountryBoundedContext].[pCountry_Get]") .QueryParameters(queryParameters) .Parameters(p => p.Name("count").Count()) .ExecuteAsync(); return(result.Count, result.Records); }
public override (int, IEnumerable <Executive>) Get(CollectionQueryParameters queryParameters) { var result = Query <Executive> .Collection() .Connection(ExecutiveEmployeePersonConnectionClass.GetConnectionName()) .StoredProcedure("[ExecutiveBoundedContext].[pExecutive_Get]") .QueryParameters(queryParameters) .Parameters(p => p.Name("count").Count()) .Execute(); return(result.Count, result.Records); }
public override (int, IEnumerable <Organization>) Get(CollectionQueryParameters queryParameters) { var result = Query <Organization> .Collection() .Connection(OrganizationPersonWithCommonEntitiesConnectionClass.GetConnectionName()) .StoredProcedure("[OrganizationPersonBoundedContext].[pOrganization_Get]") .QueryParameters(queryParameters) .Parameters(p => p.Name("count").Count()) .Execute(); return(result.Count, result.Records); }
public override (int, IEnumerable <Manager>) Get(CollectionQueryParameters queryParameters) { var result = Query <Manager> .Collection() .Connection(ManagerWithEmployeesConnectionClass.GetConnectionName()) .StoredProcedure("[ManagerBoundedContext].[pManager_Get]") .QueryParameters(queryParameters) .Parameters(p => p.Name("count").Count()) .Execute(); return(result.Count, result.Records); }
public async override Task <(int, IEnumerable <Car>)> GetAsync(CollectionQueryParameters queryParameters) { var result = await Query <Car> .Collection() .Connection(MechanicServicesSeveralVehiclesConnectionClass.GetConnectionName()) .StoredProcedure("[GarageBoundedContext].[pCar_Get]") .QueryParameters(queryParameters) .Parameters(p => p.Name("count").Count()) .ExecuteAsync(); return(result.Count, result.Records); }
public override (int, IEnumerable <Person>) Get(CollectionQueryParameters queryParameters) { var result = Query <Person> .Collection() .Connection(PersonWithSpouseAndDependantsConnectionClass.GetConnectionName()) .StoredProcedure("[PersonBoundedContext].[pPerson_Get]") .QueryParameters(queryParameters) .Parameters(p => p.Name("count").Count()) .Execute(); return(result.Count, result.Records); }
public async override Task <(int, IEnumerable <TestEntity>)> GetAsync(CollectionQueryParameters queryParameters) { var result = await Query <TestEntity> .Collection() .Connection(EntityWithMultiValuedValueObjectConnectionClass.GetConnectionName()) .StoredProcedure("[pTestEntity_Get]") .QueryParameters(queryParameters) .Parameters(p => p.Name("count").Count()) .ExecuteAsync(); return(result.Count, result.Records); }
public async override Task <(int, IEnumerable <TestEntity>)> GetAsync(CollectionQueryParameters queryParameters) { var result = await Query <TestEntity> .Collection() .Connection(SimpleEntityWithAutoGeneratedKeyConnectionClass.GetConnectionName()) .StoredProcedure("[SimpleEntityWithAutoGeneratedKeyBoundedContext].[pTestEntity_Get]") .QueryParameters(queryParameters) .Parameters(p => p.Name("count").Count()) .ExecuteAsync(); return(result.Count, result.Records); }
public async override Task <(int, IEnumerable <Address>)> GetAsync(CollectionQueryParameters queryParameters) { var result = await Query <Address> .Collection() .Connection(OrganizationPersonWithCommonEntitiesConnectionClass.GetConnectionName()) .StoredProcedure("[OrganizationPersonBoundedContext].[pAddress_Get]") .QueryParameters(queryParameters) .Parameters(p => p.Name("count").Count()) .ExecuteAsync(); return(result.Count, result.Records); }
public async override Task <(int, IEnumerable <Organization>)> GetAsync(CollectionQueryParameters queryParameters) { var result = await Query <Organization> .Collection() .Connection(SchoolRoleOrganizationAddressConnectionClass.GetConnectionName()) .StoredProcedure("[SchoolBoundedContext].[pOrganization_Get]") .QueryParameters(queryParameters) .Parameters(p => p.Name("count").Count()) .ExecuteAsync(); return(result.Count, result.Records); }
public async override Task <(int, IEnumerable <Person>)> GetAsync(CollectionQueryParameters queryParameters) { var result = await Query <Person> .Collection() .Connection(PersonWithDisciplesAndServantsConnectionClass.GetConnectionName()) .StoredProcedure("[PersonBoundedContext].[pPerson_Get]") .QueryParameters(queryParameters) .Parameters(p => p.Name("count").Count()) .ExecuteAsync(); return(result.Count, result.Records); }
public async override Task <(int, IEnumerable <Class>)> GetAsync(CollectionQueryParameters queryParameters) { var result = await Query <Class> .Collection() .Connection(ClassesWithStudentsConnectionClass.GetConnectionName()) .StoredProcedure("[ClassBoundedContext].[pClass_Get]") .QueryParameters(queryParameters) .Parameters(p => p.Name("count").Count()) .ExecuteAsync(); var count = (int)result.GetParameter("count").Value; return(count, result.Records); }
public async override Task <(int, IEnumerable <ApplicationLog>)> GetAsync(CollectionQueryParameters queryParameters) { var result = await Query <ApplicationLog> .Collection() .Connection(ApplicationLogsConnectionClass.GetConnectionName()) .StoredProcedure("[Logs].[pApplicationLog_Get]") .QueryParameters(queryParameters) .Parameters(p => p.Name("count").Size(20).Output()) .ExecuteAsync(); var count = (string)result.GetParameter("count").Value; return(int.Parse(count), result.Data); }
public override (int, IEnumerable <User>) Get(CollectionQueryParameters queryParameters) { var result = Query <User> .Collection() .Connection(AuthorizationConnectionClass.GetConnectionName()) .StoredProcedure("[AccessControl].[pUser_Get]") .QueryParameters(queryParameters) .Parameters(p => p.Name("count").Size(20).Output()) .Execute(); var count = (string)result.GetParameter("count").Value; return(int.Parse(count), result.Data); }
public override (int, IEnumerable <Inspection>) Get(int truckId, CollectionQueryParameters queryParameters) { var result = Query <Inspection> .Collection() .Connection(MechanicServicesSingleVehicleConnectionClass.GetConnectionName()) .StoredProcedure("[GarageBoundedContext].[pTruck_GetInspections]") .QueryParameters(queryParameters) .Parameters(p => p.Name("count").Count()) .Parameters( p => p.Name("truckId").Value(truckId) ) .Execute(); return(result.Count, result.Records); }
public (int, IEnumerable <Person>) GetServantsForPerson(int personId, CollectionQueryParameters queryParameters) { var result = Query <Person> .Collection() .Connection(PersonWithDisciplesAndServantsConnectionClass.GetConnectionName()) .StoredProcedure("[PersonBoundedContext].[pPerson_GetServants]") .QueryParameters(queryParameters) .Parameters(p => p.Name("count").Count()) .Parameters( p => p.Name("personId").Value(personId) ) .Execute(); return(result.Count, result.Records); }