public ValidationData ValidateGetRoomBookings( ClaimsPrincipal principal, BookingQueryFilter filter, BookingQuerySort sort, BookingQueryProjection projection, BookingQueryPaging paging, BookingQueryOptions options) { var validationData = new ValidationData(); if (filter.to_date != null && filter.from_date != null && filter.to_date.Value.Subtract(filter.from_date.Value).TotalDays > 31) { validationData.Fail(mess: "Only 1 month range is allowed", code: AppResultCode.FailValidation); } return(validationData); }
public async Task <IActionResult> GetRoomBookings([FromQuery][QueryObject] BookingQueryFilter filter, [FromQuery] BookingQuerySort sort, [FromQuery] BookingQueryProjection projection, [FromQuery] BookingQueryPaging paging, [FromQuery] BookingQueryOptions options) { var validationData = _service.ValidateGetRoomBookings( User, filter, sort, projection, paging, options); if (!validationData.IsValid) { return(BadRequest(AppResult.FailValidation(data: validationData))); } var result = await _service.QueryBookingDynamic( User, member : null, relationship : null, projection, validationData.TempData, filter, sort, paging, options); if (options.single_only && result == null) { return(NotFound(AppResult.NotFound())); } return(Ok(AppResult.Success(data: result))); }
public async Task <IActionResult> GetManagedRequests([FromQuery][QueryObject] BookingQueryFilter filter, [FromQuery] BookingQuerySort sort, [FromQuery] BookingQueryProjection projection, [FromQuery] BookingQueryPaging paging, [FromQuery] BookingQueryOptions options) { var validationData = _service.ValidateGetBookings( User, BookingPrincipalRelationship.Manager, filter, sort, projection, paging, options); if (!validationData.IsValid) { return(BadRequest(AppResult.FailValidation(data: validationData))); } var member = _memberService.Members.Id(UserId).FirstOrDefault(); var result = await _service.QueryBookingDynamic( User, member, BookingPrincipalRelationship.Manager, projection, validationData.TempData, filter, sort, paging, options); if (options.single_only && result == null) { return(NotFound(AppResult.NotFound())); } return(Ok(AppResult.Success(data: result))); }
public async Task <QueryResult <object> > QueryBookingDynamic( ClaimsPrincipal principal, Member member, BookingPrincipalRelationship?relationship, BookingQueryProjection projection, IDictionary <string, object> tempData = null, BookingQueryFilter filter = null, BookingQuerySort sort = null, BookingQueryPaging paging = null, BookingQueryOptions options = null) { var query = Bookings.AsNoTracking(); //---- multi-tenants ------ if (principal != null) { var memberId = principal.Identity.Name; switch (relationship) { case BookingPrincipalRelationship.Owner: query = query.RelatedToMember(memberId); break; case BookingPrincipalRelationship.Manager: query = QueryBookingsManagedByManager(member); break; } } //------------------------- if (filter != null) { query = query.Filter(filter, tempData); } int?totalCount = null; Task <int> countTask = null; var countQuery = query; query = query.Project(projection); if (options != null && !options.single_only) { #region List query if (sort != null) { query = query.Sort(sort); } if (paging != null && (!options.load_all || !BookingQueryOptions.IsLoadAllAllowed)) { query = query.SelectPage(paging.page, paging.limit); } #endregion #region Count query if (options.count_total) { countTask = countQuery.CountAsync(); } #endregion } if (options != null && options.count_total) { totalCount = await countTask; } var queryResult = await query.ToListAsync(); if (options != null && options.single_only) { var single = queryResult.FirstOrDefault(); if (single == null) { return(null); } var singleResult = GetBookingDynamic(single, projection, options); return(new QueryResult <object>() { SingleResult = singleResult }); } var results = GetBookingDynamic(queryResult, projection, options); return(new QueryResult <object>() { Results = results, TotalCount = totalCount }); }