public async Task <IEnumerable <Dto> > SortAsync(IEnumerable <Dto> entities, ORDER_ENUM col, ORDER_ENUM order)
{
await Task.Run(() => true);
return(null);
}
new public async Task <IEnumerable <CustomerDTO> > SortAsync(IEnumerable <CustomerDTO> entities, ORDER_ENUM col, ORDER_ENUM order)
{
IEnumerable <CustomerDTO> res = null;
await Task.Run(() => true);
if (order == ORDER_ENUM.DESCENDING)
{
switch (col)
{
case ORDER_ENUM.NAME: res = entities.OrderByDescending(m => m.FullName); break;
case ORDER_ENUM.FIRST_NAME: res = entities.OrderByDescending(m => m.FirstName); break;
case ORDER_ENUM.LAST_NAME: res = entities.OrderByDescending(m => m.LastName); break;
case ORDER_ENUM.ADDRESS: res = entities.OrderByDescending(m => m.Address.ToString()); break;
case ORDER_ENUM.STATUS: res = entities.OrderByDescending(m => m.Status); break;
default: res = entities.OrderByDescending(m => m.Id); break;
}
}
else
{
switch (col)
{
case ORDER_ENUM.NAME: res = entities.OrderBy(m => m.FullName); break;
case ORDER_ENUM.FIRST_NAME: res = entities.OrderBy(m => m.FirstName); break;
case ORDER_ENUM.LAST_NAME: res = entities.OrderBy(m => m.LastName); break;
case ORDER_ENUM.ADDRESS: res = entities.OrderBy(m => m.Address.ToString()); break;
case ORDER_ENUM.STATUS: res = entities.OrderBy(m => m.Status); break;
default: res = entities.OrderBy(m => m.Id); break;
}
}
return(res);
}
new public async Task <IEnumerable <AccountDTO> > SortAsync(IEnumerable <AccountDTO> entities, ORDER_ENUM col, ORDER_ENUM order)
{
IEnumerable <AccountDTO> res = null;
await Task.Run(() => true);
if (order == ORDER_ENUM.DESCENDING)
{
switch (col)
{
case ORDER_ENUM.PERSON_NAME:
res = entities.OrderByDescending(m => unitOfWork.Persons.GetByAsync(m.PersonId)
.GetAwaiter().GetResult().FullName); break;
case ORDER_ENUM.PERSON_FIRST_NAME:
res = entities.OrderByDescending(m => unitOfWork.Persons.GetByAsync(m.PersonId)
.GetAwaiter().GetResult().FirstName); break;
case ORDER_ENUM.PERSON_LAST_NAME:
res = entities.OrderByDescending(m => unitOfWork.Persons.GetByAsync(m.PersonId)
.GetAwaiter().GetResult().LastName); break;
case ORDER_ENUM.STATUS: res = entities.OrderByDescending(m => m.Status); break;
default: res = entities.OrderByDescending(m => m.Username); break;
}
}
else
{
switch (col)
{
case ORDER_ENUM.PERSON_NAME:
res = entities.OrderBy(m => unitOfWork.Persons.GetByAsync(m.PersonId)
.GetAwaiter().GetResult().FullName); break;
case ORDER_ENUM.PERSON_FIRST_NAME:
res = entities.OrderBy(m => unitOfWork.Persons.GetByAsync(m.PersonId)
.GetAwaiter().GetResult().FirstName); break;
case ORDER_ENUM.PERSON_LAST_NAME:
res = entities.OrderBy(m => unitOfWork.Persons.GetByAsync(m.PersonId)
.GetAwaiter().GetResult().LastName); break;
case ORDER_ENUM.STATUS: res = entities.OrderBy(m => m.Status); break;
default: res = entities.OrderBy(m => m.Username); break;
}
}
return(res);
}
new public async Task <IEnumerable <RouteDTO> > SortAsync(IEnumerable <RouteDTO> entities, ORDER_ENUM col, ORDER_ENUM order)
{
IEnumerable <RouteDTO> res = null;
await Task.Run(() => true);
if (order == ORDER_ENUM.DESCENDING)
{
switch (col)
{
case ORDER_ENUM.ORIGIN_NAME: res = entities.OrderByDescending(m => unitOfWork.Airports.GetByAsync(m.Origin).GetAwaiter().GetResult().AirportName); break;
case ORDER_ENUM.DESTINATION_NAME: res = entities.OrderByDescending(m => unitOfWork.Airports.GetByAsync(m.Destination).GetAwaiter().GetResult().AirportName); break;
case ORDER_ENUM.STATUS: res = entities.OrderByDescending(m => m.Status); break;
default: res = entities.OrderByDescending(m => m.RouteId); break;
}
}
else
{
switch (col)
{
case ORDER_ENUM.ORIGIN_NAME: res = entities.OrderBy(m => unitOfWork.Airports.GetByAsync(m.Origin).GetAwaiter().GetResult().AirportName); break;
case ORDER_ENUM.DESTINATION_NAME: res = entities.OrderBy(m => unitOfWork.Airports.GetByAsync(m.Destination).GetAwaiter().GetResult().AirportName); break;
case ORDER_ENUM.STATUS: res = entities.OrderBy(m => m.Status); break;
default: res = entities.OrderBy(m => m.RouteId); break;
}
}
return(res);
}
new public async Task <IEnumerable <JobDTO> > SortAsync(IEnumerable <JobDTO> entities, ORDER_ENUM col, ORDER_ENUM order)
{
IEnumerable <JobDTO> res = null;
await Task.Run(() => true);
if (order == ORDER_ENUM.DESCENDING)
{
switch (col)
{
case ORDER_ENUM.NAME: res = entities.OrderByDescending(m => m.JobName); break;
case ORDER_ENUM.STATUS: res = entities.OrderByDescending(m => m.Status); break;
default: res = entities.OrderByDescending(m => m.JobId); break;
}
}
else
{
switch (col)
{
case ORDER_ENUM.NAME: res = entities.OrderBy(m => m.JobName); break;
case ORDER_ENUM.STATUS: res = entities.OrderBy(m => m.Status); break;
default: res = entities.OrderBy(m => m.JobId); break;
}
}
return(res);
}
new public async Task <IEnumerable <PlaneDTO> > SortAsync(IEnumerable <PlaneDTO> entities, ORDER_ENUM col, ORDER_ENUM order)
{
IEnumerable <PlaneDTO> res = null;
await Task.Run(() => true);
if (order == ORDER_ENUM.DESCENDING)
{
switch (col)
{
case ORDER_ENUM.NAME:
case ORDER_ENUM.PLANE_NAME: res = entities.OrderByDescending(m => this.getPlaneFullname(m, m.MakerId).GetAwaiter().GetResult()); break;
case ORDER_ENUM.MAKER_NAME: res = entities.OrderByDescending(m => unitOfWork.Makers.GetByAsync(m.MakerId).GetAwaiter().GetResult()); break;
case ORDER_ENUM.STATUS: res = entities.OrderByDescending(m => m.Status); break;
default: res = entities.OrderByDescending(m => m.PlaneId); break;
}
}
else
{
switch (col)
{
case ORDER_ENUM.NAME:
case ORDER_ENUM.PLANE_NAME: res = entities.OrderBy(m => this.getPlaneFullname(m, m.MakerId).GetAwaiter().GetResult()); break;
case ORDER_ENUM.MAKER_NAME: res = entities.OrderBy(m => unitOfWork.Makers.GetByAsync(m.MakerId).GetAwaiter().GetResult()); break;
case ORDER_ENUM.STATUS: res = entities.OrderBy(m => m.Status); break;
default: res = entities.OrderBy(m => m.PlaneId); break;
}
}
return(res);
}
//Thao tac voi ve =======================================================================================
public async Task <IEnumerable <TicketDTO> > SortTicketAsync(IEnumerable <TicketDTO> entities, ORDER_ENUM col, ORDER_ENUM order)
{
IEnumerable <TicketDTO> res = null;
await Task.Run(() => true);
if (order == ORDER_ENUM.DESCENDING)
{
switch (col)
{
case ORDER_ENUM.CUSTOMER_NAME: res = entities.OrderBy(m => m.FlightId).ThenByDescending(m => unitOfWork.Customers.GetByAsync(m.CustomerId).GetAwaiter().GetResult()); break;
case ORDER_ENUM.ASSIGNED_CUSTOMER: res = entities.OrderBy(m => m.FlightId).ThenByDescending(m => m.AssignedCus); break;
case ORDER_ENUM.TICKET_TYPE_ID: res = entities.OrderBy(m => m.FlightId).ThenByDescending(m => m.TicketTypeId); break;
case ORDER_ENUM.STATUS: res = entities.OrderBy(m => m.FlightId).ThenByDescending(m => m.Status); break;
default: res = entities.OrderBy(m => m.FlightId).OrderByDescending(m => m.FlightId); break;
}
}
else
{
switch (col)
{
case ORDER_ENUM.CUSTOMER_NAME: res = entities.OrderBy(m => m.FlightId).ThenBy(m => unitOfWork.Customers.GetByAsync(m.CustomerId).GetAwaiter().GetResult()); break;
case ORDER_ENUM.ASSIGNED_CUSTOMER: res = entities.OrderBy(m => m.FlightId).ThenBy(m => m.AssignedCus); break;
case ORDER_ENUM.TICKET_TYPE_ID: res = entities.OrderBy(m => m.FlightId).ThenBy(m => m.TicketTypeId); break;
case ORDER_ENUM.STATUS: res = entities.OrderBy(m => m.FlightId).ThenBy(m => m.Status); break;
default: res = entities.OrderBy(m => m.FlightId).OrderBy(m => m.TicketId); break;
}
}
return(res);
}
//Thao tac voi chi tiet ============================================================================================
public async Task <IEnumerable <FlightDetailDTO> > SortFlightDetailAsync(IEnumerable <FlightDetailDTO> entities, ORDER_ENUM order)
{
IEnumerable <FlightDetailDTO> res = null;
await Task.Run(() => true);
if (order == ORDER_ENUM.DESCENDING)
{
res = entities.OrderBy(m => m.FlightId).ThenByDescending(m => m.FlightDetailId);
}
else
{
res = entities.OrderBy(m => m.FlightId).ThenBy(m => m.FlightDetailId);
}
return(res);
}
new public async Task <IEnumerable <FlightDTO> > SortAsync(IEnumerable <FlightDTO> entities, ORDER_ENUM col, ORDER_ENUM order)
{
IEnumerable <FlightDTO> res = null;
await Task.Run(() => true);
if (order == ORDER_ENUM.DESCENDING)
{
switch (col)
{
case ORDER_ENUM.ORIGIN_NAME: res = entities.OrderByDescending(m => this.getOrigin(m.FlightId).GetAwaiter().GetResult().AirportName); break;
case ORDER_ENUM.DESTINATION_NAME: res = entities.OrderByDescending(m => this.getDestination(m.FlightId).GetAwaiter().GetResult().AirportName); break;
case ORDER_ENUM.DEP_DATE: res = entities.OrderByDescending(m => this.getDepDate(m.FlightId).GetAwaiter().GetResult()); break;
case ORDER_ENUM.ARR_DATE: res = entities.OrderByDescending(m => this.getArrDate(m.FlightId).GetAwaiter().GetResult()); break;
case ORDER_ENUM.FLIGHT_TIME: res = entities.OrderByDescending(m => this.getTotalFlightTime(m.FlightId).GetAwaiter().GetResult()); break;
case ORDER_ENUM.STATUS: res = entities.OrderByDescending(m => m.Status); break;
default: res = entities.OrderByDescending(m => m.FlightId); break;
}
}
else
{
switch (col)
{
case ORDER_ENUM.ORIGIN_NAME: res = entities.OrderBy(m => this.getOrigin(m.FlightId).GetAwaiter().GetResult().AirportName); break;
case ORDER_ENUM.DESTINATION_NAME: res = entities.OrderBy(m => this.getDestination(m.FlightId).GetAwaiter().GetResult().AirportName); break;
case ORDER_ENUM.DEP_DATE: res = entities.OrderBy(m => this.getDepDate(m.FlightId).GetAwaiter().GetResult()); break;
case ORDER_ENUM.ARR_DATE: res = entities.OrderBy(m => this.getArrDate(m.FlightId).GetAwaiter().GetResult()); break;
case ORDER_ENUM.FLIGHT_TIME: res = entities.OrderBy(m => this.getTotalFlightTime(m.FlightId).GetAwaiter().GetResult()); break;
case ORDER_ENUM.STATUS: res = entities.OrderBy(m => m.Status); break;
default: res = entities.OrderBy(m => m.FlightId); break;
}
}
return(res);
}
