public static IQueryable <Booking> Filter(this IQueryable <Booking> query, BookingQueryFilter model, IDictionary <string, object> tempData)
{
var archived = model.archived ?? BoolOptions.F;
if (archived != BoolOptions.B)
{
query = query.Archived(!(archived == BoolOptions.F));
}
switch (model.date_type)
{
case BookingQueryFilterDateType.SENT_DATE:
if (model.from_date != null)
{
query = query.SentDateFromDate(model.from_date.Value);
}
if (model.to_date != null)
{
var toDateUtc = model.to_date.Value.ToEndOfDay().ToUtc();
query = query.SentDateToDate(toDateUtc);
}
if (model.date != null)
{
query = query.SentDate(model.date.Value);
}
break;
case BookingQueryFilterDateType.BOOKED_DATE:
if (model.from_date != null)
{
query = query.BookedDateFromDate(model.from_date.Value);
}
if (model.to_date != null)
{
var toDateUtc = model.to_date.Value.ToEndOfDay().ToUtc();
query = query.BookedDateToDate(toDateUtc);
}
if (model.date != null)
{
query = query.BookedDate(model.date.Value);
}
break;
}
if (model.status != null)
{
query = query.Status(model.status);
}
if (model.search != null)
{
query = query.Search(model.search);
}
if (model.room_code != null)
{
query = query.OfRoom(model.room_code);
}
return(query);
}
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
});
}
