public async Task <int> Count(TicketGeneratedIdFilter filter)
{
IQueryable <TicketGeneratedIdDAO> TicketGeneratedIds = DataContext.TicketGeneratedId.AsNoTracking();
TicketGeneratedIds = DynamicFilter(TicketGeneratedIds, filter);
return(await TicketGeneratedIds.CountAsync());
}
public async Task <List <TicketGeneratedId> > List(TicketGeneratedIdFilter filter)
{
if (filter == null)
{
return(new List <TicketGeneratedId>());
}
IQueryable <TicketGeneratedIdDAO> TicketGeneratedIdDAOs = DataContext.TicketGeneratedId.AsNoTracking();
TicketGeneratedIdDAOs = DynamicFilter(TicketGeneratedIdDAOs, filter);
TicketGeneratedIdDAOs = DynamicOrder(TicketGeneratedIdDAOs, filter);
List <TicketGeneratedId> TicketGeneratedIds = await DynamicSelect(TicketGeneratedIdDAOs, filter);
return(TicketGeneratedIds);
}
public async Task <bool> ValidateId(TicketGeneratedId TicketGeneratedId)
{
TicketGeneratedIdFilter TicketGeneratedIdFilter = new TicketGeneratedIdFilter
{
Skip = 0,
Take = 10,
Id = new IdFilter {
Equal = TicketGeneratedId.Id
},
Selects = TicketGeneratedIdSelect.Id
};
int count = await UOW.TicketGeneratedIdRepository.Count(TicketGeneratedIdFilter);
if (count == 0)
{
TicketGeneratedId.AddError(nameof(TicketGeneratedIdValidator), nameof(TicketGeneratedId.Id), ErrorCode.IdNotExisted);
}
return(count == 1);
}
public async Task <List <TicketGeneratedId> > List(TicketGeneratedIdFilter TicketGeneratedIdFilter)
{
try
{
List <TicketGeneratedId> TicketGeneratedIds = await UOW.TicketGeneratedIdRepository.List(TicketGeneratedIdFilter);
return(TicketGeneratedIds);
}
catch (Exception ex)
{
if (ex.InnerException == null)
{
await Logging.CreateSystemLog(ex, nameof(TicketGeneratedIdService));
throw new MessageException(ex);
}
else
{
await Logging.CreateSystemLog(ex.InnerException, nameof(TicketGeneratedIdService));
throw new MessageException(ex.InnerException);
}
}
}
public async Task <int> Count(TicketGeneratedIdFilter TicketGeneratedIdFilter)
{
try
{
int result = await UOW.TicketGeneratedIdRepository.Count(TicketGeneratedIdFilter);
return(result);
}
catch (Exception ex)
{
if (ex.InnerException == null)
{
await Logging.CreateSystemLog(ex, nameof(TicketGeneratedIdService));
throw new MessageException(ex);
}
else
{
await Logging.CreateSystemLog(ex.InnerException, nameof(TicketGeneratedIdService));
throw new MessageException(ex.InnerException);
}
}
}
private IQueryable <TicketGeneratedIdDAO> DynamicOrder(IQueryable <TicketGeneratedIdDAO> query, TicketGeneratedIdFilter filter)
{
switch (filter.OrderType)
{
case OrderType.ASC:
switch (filter.OrderBy)
{
case TicketGeneratedIdOrder.Id:
query = query.OrderBy(q => q.Id);
break;
case TicketGeneratedIdOrder.Used:
query = query.OrderBy(q => q.Used);
break;
}
break;
case OrderType.DESC:
switch (filter.OrderBy)
{
case TicketGeneratedIdOrder.Id:
query = query.OrderByDescending(q => q.Id);
break;
case TicketGeneratedIdOrder.Used:
query = query.OrderByDescending(q => q.Used);
break;
}
break;
}
query = query.Skip(filter.Skip).Take(filter.Take);
return(query);
}
private IQueryable <TicketGeneratedIdDAO> OrFilter(IQueryable <TicketGeneratedIdDAO> query, TicketGeneratedIdFilter filter)
{
if (filter.OrFilter == null || filter.OrFilter.Count == 0)
{
return(query);
}
IQueryable <TicketGeneratedIdDAO> initQuery = query.Where(q => false);
foreach (TicketGeneratedIdFilter TicketGeneratedIdFilter in filter.OrFilter)
{
IQueryable <TicketGeneratedIdDAO> queryable = query;
if (TicketGeneratedIdFilter.Id != null)
{
queryable = queryable.Where(q => q.Id, TicketGeneratedIdFilter.Id);
}
initQuery = initQuery.Union(queryable);
}
return(initQuery);
}
private IQueryable <TicketGeneratedIdDAO> DynamicFilter(IQueryable <TicketGeneratedIdDAO> query, TicketGeneratedIdFilter filter)
{
if (filter == null)
{
return(query.Where(q => false));
}
query = query.Where(q => !q.DeletedAt.HasValue);
if (filter.CreatedAt != null)
{
query = query.Where(q => q.CreatedAt, filter.CreatedAt);
}
if (filter.UpdatedAt != null)
{
query = query.Where(q => q.UpdatedAt, filter.UpdatedAt);
}
if (filter.Id != null)
{
query = query.Where(q => q.Id, filter.Id);
}
query = OrFilter(query, filter);
return(query);
}
private async Task <List <TicketGeneratedId> > DynamicSelect(IQueryable <TicketGeneratedIdDAO> query, TicketGeneratedIdFilter filter)
{
List <TicketGeneratedId> TicketGeneratedIds = await query.Select(q => new TicketGeneratedId()
{
Id = filter.Selects.Contains(TicketGeneratedIdSelect.Id) ? q.Id : default(long),
Used = filter.Selects.Contains(TicketGeneratedIdSelect.Used) ? q.Used : default(bool),
CreatedAt = q.CreatedAt,
UpdatedAt = q.UpdatedAt,
}).ToListAsync();
return(TicketGeneratedIds);
}
