public IActionResult GetDetail(int id,
[FromQuery] BookingQueryProjection projection,
[FromQuery] BookingQueryOptions options)
{
var getManagerType = projection.GetFieldsArr().Contains(BookingQueryProjection.MANAGER_TYPE);
projection = new BookingQueryProjection {
fields = BookingQueryProjection.DETAIL
};
var entity = _service.GetBookingDetail(id, projection);
if (entity == null)
{
return(NotFound(AppResult.NotFound()));
}
var validationData = _service.ValidateGetBookingDetail(entity, User, options);
if (!validationData.IsValid)
{
return(BadRequest(AppResult.FailValidation(data: validationData)));
}
var obj = _service.GetBookingDynamic(entity, projection, options);
if (getManagerType)
{
obj["manager_type"] = validationData.TempData["manager_type"];
}
return(Ok(AppResult.Success(data: obj)));
}
public static IQueryable <Booking> Project(this IQueryable <Booking> query, BookingQueryProjection model)
{
bool room = false, member = false, services = false;
foreach (var f in model.GetFieldsArr())
{
switch (f)
{
case BookingQueryProjection.ROOM: room = true; break;
case BookingQueryProjection.MEMBER: member = true; break;
case BookingQueryProjection.SERVICES: services = true; break;
}
}
query = query.Select(o => new Booking
{
Archived = o.Archived,
BookedDate = o.BookedDate,
//BookingHistory = o.BookingHistory,
BookMemberId = o.BookMemberId,
Code = o.Code,
FromTime = o.FromTime,
Id = o.Id,
Note = o.Note,
NumOfPeople = o.NumOfPeople,
Room = room ? o.Room : null,
Status = o.Status,
UsingMemberIds = o.UsingMemberIds,
RoomCode = o.RoomCode,
SentDate = o.SentDate,
ToTime = o.ToTime,
Feedback = o.Feedback,
ManagerMessage = o.ManagerMessage,
AttachedService = services ? o.AttachedService.AsQueryable()
.Select(s => new AttachedService
{
Id = s.Id,
BookingService = new BookingService
{
Code = s.BookingService.Code,
Name = s.BookingService.Name
}
}).ToList() : null,
BookMember = member ? o.BookMember : null,
});
return(query);
}
public IDictionary <string, object> GetBookingDynamic(
Booking row, BookingQueryProjection projection,
BookingQueryOptions options)
{
var obj = new Dictionary <string, object>();
foreach (var f in projection.GetFieldsArr())
{
switch (f)
{
case BookingQueryProjection.INFO:
{
var entity = row;
obj["id"] = entity.Id;
obj["code"] = entity.Code;
var sentDate = entity.SentDate
.ToTimeZone(options.time_zone, options.culture, Settings.Instance.SupportedLangs[0]);
var timeStr = sentDate.ToString(dateFormat: AppDateTimeFormat.DEFAULT_FORMAT_FOR_CONVERT);
obj["group_by_date_key"] = sentDate.ToString(dateFormat: AppDateTimeFormat.DEFAULT_DATE_FORMAT);
obj["sent_date"] = new
{
display = timeStr,
iso = $"{sentDate.ToUtc():s}Z"
};
var bookedDate = entity.BookedDate
.ToTimeZone(options.time_zone, options.culture, Settings.Instance.SupportedLangs[0]);
timeStr = bookedDate.ToString(options.date_format, options.culture, Settings.Instance.SupportedLangs[0]);
obj["booked_date"] = new
{
display = timeStr,
iso = $"{bookedDate.ToUtc():s}Z"
};
obj["from_time"] = entity.FromTime.ToString("hh\\:mm");
obj["to_time"] = entity.ToTime.ToString("hh\\:mm");
var startTime = bookedDate.Add(entity.FromTime);
timeStr = startTime.ToString(dateFormat: AppDateTimeFormat.DEFAULT_FORMAT_FOR_CONVERT);
obj["start_time"] = new
{
display = timeStr,
iso = $"{startTime.ToUtc():s}Z"
};
var finishTime = bookedDate.Add(entity.ToTime);
timeStr = finishTime.ToString(dateFormat: AppDateTimeFormat.DEFAULT_FORMAT_FOR_CONVERT);
obj["finish_time"] = new
{
display = timeStr,
iso = $"{finishTime.ToUtc():s}Z"
};
obj["type"] = entity.Id != 0 ? BookingTypeValues.BOOKING : BookingTypeValues.SCHEDULE;
obj["status"] = entity.Status;
obj["archived"] = entity.Archived;
obj["book_member_id"] = entity.BookMemberId;
obj["note"] = entity.Note;
obj["num_of_people"] = entity.NumOfPeople;
obj["manager_message"] = entity.ManagerMessage;
obj["feedback"] = entity.Feedback;
}
break;
case BookingQueryProjection.SELECT:
{
var entity = row;
obj["id"] = entity.Code;
obj["code"] = entity.Code;
}
break;
case BookingQueryProjection.ROOM:
{
var entity = row.Room;
if (entity != null)
{
obj["room"] = new
{
code = entity.Code,
name = entity.Name
}
}
;
}
break;
case BookingQueryProjection.SERVICES:
{
var entities = row.AttachedService?
.Select(o => new
{
id = o.Id,
code = o.BookingService.Code,
name = o.BookingService.Name
}).ToList();
obj["attached_services"] = entities;
}
break;
case BookingQueryProjection.MEMBER:
{
var entity = row.BookMember;
if (entity != null)
{
obj["book_member"] = new
{
user_id = entity.UserId,
email = entity.Email,
code = entity.Code
}
}
;
}
break;
case BookingQueryProjection.USING_EMAILS:
{
if (row.UsingMemberIds != null)
{
var ids = row.UsingMemberIds.Split('\n');
var usingEmails = _memberService.Members.Ids(ids)
.Select(o => o.Email).ToList();
obj["using_emails"] = usingEmails;
}
}
break;
}
}
return(obj);
}