public async Task <int> Count(TicketSourceFilter filter) { IQueryable <TicketSourceDAO> TicketSources = DataContext.TicketSource.AsNoTracking(); TicketSources = DynamicFilter(TicketSources, filter); return(await TicketSources.CountAsync()); }
public async Task <ActionResult <bool> > BulkDelete([FromBody] List <long> Ids) { if (!ModelState.IsValid) { throw new BindException(ModelState); } TicketSourceFilter TicketSourceFilter = new TicketSourceFilter(); TicketSourceFilter = TicketSourceService.ToFilter(TicketSourceFilter); TicketSourceFilter.Id = new IdFilter { In = Ids }; TicketSourceFilter.Selects = TicketSourceSelect.Id; TicketSourceFilter.Skip = 0; TicketSourceFilter.Take = int.MaxValue; List <TicketSource> TicketSources = await TicketSourceService.List(TicketSourceFilter); TicketSources = await TicketSourceService.BulkDelete(TicketSources); if (TicketSources.Any(x => !x.IsValidated)) { return(BadRequest(TicketSources.Where(x => !x.IsValidated))); } return(true); }
public async Task <List <Ticket_TicketSourceDTO> > SingleListTicketSource([FromBody] Ticket_TicketSourceFilterDTO Ticket_TicketSourceFilterDTO) { if (!ModelState.IsValid) { throw new BindException(ModelState); } TicketSourceFilter TicketSourceFilter = new TicketSourceFilter(); TicketSourceFilter.Skip = 0; TicketSourceFilter.Take = 20; TicketSourceFilter.OrderBy = TicketSourceOrder.Id; TicketSourceFilter.OrderType = OrderType.ASC; TicketSourceFilter.Selects = TicketSourceSelect.ALL; TicketSourceFilter.Id = Ticket_TicketSourceFilterDTO.Id; TicketSourceFilter.Name = Ticket_TicketSourceFilterDTO.Name; TicketSourceFilter.OrderNumber = Ticket_TicketSourceFilterDTO.OrderNumber; TicketSourceFilter.StatusId = Ticket_TicketSourceFilterDTO.StatusId; List <TicketSource> TicketSources = await TicketSourceService.List(TicketSourceFilter); List <Ticket_TicketSourceDTO> Ticket_TicketSourceDTOs = TicketSources .Select(x => new Ticket_TicketSourceDTO(x)).ToList(); return(Ticket_TicketSourceDTOs); }
public async Task <TicketSource> Create(TicketSource TicketSource) { if (!await TicketSourceValidator.Create(TicketSource)) { return(TicketSource); } try { await UOW.Begin(); TicketSourceFilter TicketSourceFilter = new TicketSourceFilter { Take = 1, Selects = TicketSourceSelect.ALL, OrderBy = TicketSourceOrder.OrderNumber, OrderType = OrderType.DESC }; if (TicketSource.OrderNumber == 0) { List <TicketSource> TicketSources = await UOW.TicketSourceRepository.List(TicketSourceFilter); TicketSource.OrderNumber = TicketSources.Any() ? TicketSources.Max(c => c.OrderNumber) + 1 : 1; } await UOW.TicketSourceRepository.Create(TicketSource); await UOW.Commit(); TicketSource = await UOW.TicketSourceRepository.Get(TicketSource.Id); await Logging.CreateAuditLog(TicketSource, new { }, nameof(TicketSourceService)); return(TicketSource); } catch (Exception ex) { if (ex.InnerException == null) { await Logging.CreateSystemLog(ex, nameof(TicketSourceService)); throw new MessageException(ex); } else { await Logging.CreateSystemLog(ex.InnerException, nameof(TicketSourceService)); throw new MessageException(ex.InnerException); } } }
public async Task <List <TicketSource> > List(TicketSourceFilter filter) { if (filter == null) { return(new List <TicketSource>()); } IQueryable <TicketSourceDAO> TicketSourceDAOs = DataContext.TicketSource.AsNoTracking(); TicketSourceDAOs = DynamicFilter(TicketSourceDAOs, filter); TicketSourceDAOs = DynamicOrder(TicketSourceDAOs, filter); List <TicketSource> TicketSources = await DynamicSelect(TicketSourceDAOs, filter); return(TicketSources); }
public async Task <ActionResult <int> > Count([FromBody] TicketSource_TicketSourceFilterDTO TicketSource_TicketSourceFilterDTO) { if (!ModelState.IsValid) { throw new BindException(ModelState); } TicketSourceFilter TicketSourceFilter = ConvertFilterDTOToFilterEntity(TicketSource_TicketSourceFilterDTO); TicketSourceFilter = TicketSourceService.ToFilter(TicketSourceFilter); int count = await TicketSourceService.Count(TicketSourceFilter); return(count); }
public async Task <ActionResult <List <TicketSource_TicketSourceDTO> > > List([FromBody] TicketSource_TicketSourceFilterDTO TicketSource_TicketSourceFilterDTO) { if (!ModelState.IsValid) { throw new BindException(ModelState); } TicketSourceFilter TicketSourceFilter = ConvertFilterDTOToFilterEntity(TicketSource_TicketSourceFilterDTO); TicketSourceFilter = TicketSourceService.ToFilter(TicketSourceFilter); List <TicketSource> TicketSources = await TicketSourceService.List(TicketSourceFilter); List <TicketSource_TicketSourceDTO> TicketSource_TicketSourceDTOs = TicketSources .Select(c => new TicketSource_TicketSourceDTO(c)).ToList(); return(TicketSource_TicketSourceDTOs); }
private TicketSourceFilter ConvertFilterDTOToFilterEntity(TicketSource_TicketSourceFilterDTO TicketSource_TicketSourceFilterDTO) { TicketSourceFilter TicketSourceFilter = new TicketSourceFilter(); TicketSourceFilter.Selects = TicketSourceSelect.ALL; TicketSourceFilter.Skip = TicketSource_TicketSourceFilterDTO.Skip; TicketSourceFilter.Take = TicketSource_TicketSourceFilterDTO.Take; TicketSourceFilter.OrderBy = TicketSource_TicketSourceFilterDTO.OrderBy; TicketSourceFilter.OrderType = TicketSource_TicketSourceFilterDTO.OrderType; TicketSourceFilter.Id = TicketSource_TicketSourceFilterDTO.Id; TicketSourceFilter.Name = TicketSource_TicketSourceFilterDTO.Name; TicketSourceFilter.OrderNumber = TicketSource_TicketSourceFilterDTO.OrderNumber; TicketSourceFilter.StatusId = TicketSource_TicketSourceFilterDTO.StatusId; TicketSourceFilter.CreatedAt = TicketSource_TicketSourceFilterDTO.CreatedAt; TicketSourceFilter.UpdatedAt = TicketSource_TicketSourceFilterDTO.UpdatedAt; return(TicketSourceFilter); }
public async Task <bool> ValidateId(TicketSource TicketSource) { TicketSourceFilter TicketSourceFilter = new TicketSourceFilter { Skip = 0, Take = 10, Id = new IdFilter { Equal = TicketSource.Id }, Selects = TicketSourceSelect.Id }; int count = await UOW.TicketSourceRepository.Count(TicketSourceFilter); if (count == 0) { TicketSource.AddError(nameof(TicketSourceValidator), nameof(TicketSource.Id), ErrorCode.IdNotExisted); } return(count == 1); }
public TicketSourceFilter ToFilter(TicketSourceFilter filter) { if (filter.OrFilter == null) { filter.OrFilter = new List <TicketSourceFilter>(); } if (CurrentContext.Filters == null || CurrentContext.Filters.Count == 0) { return(filter); } foreach (var currentFilter in CurrentContext.Filters) { TicketSourceFilter subFilter = new TicketSourceFilter(); filter.OrFilter.Add(subFilter); List <FilterPermissionDefinition> FilterPermissionDefinitions = currentFilter.Value; foreach (FilterPermissionDefinition FilterPermissionDefinition in FilterPermissionDefinitions) { if (FilterPermissionDefinition.Name == nameof(subFilter.Id)) { subFilter.Id = FilterPermissionDefinition.IdFilter; } if (FilterPermissionDefinition.Name == nameof(subFilter.Name)) { subFilter.Name = FilterPermissionDefinition.StringFilter; } if (FilterPermissionDefinition.Name == nameof(subFilter.OrderNumber)) { subFilter.OrderNumber = FilterPermissionDefinition.LongFilter; } if (FilterPermissionDefinition.Name == nameof(subFilter.StatusId)) { subFilter.StatusId = FilterPermissionDefinition.IdFilter; } } } return(filter); }
private async Task <bool> HasPermission(long Id) { TicketSourceFilter TicketSourceFilter = new TicketSourceFilter(); TicketSourceFilter = TicketSourceService.ToFilter(TicketSourceFilter); if (Id == 0) { } else { TicketSourceFilter.Id = new IdFilter { Equal = Id }; int count = await TicketSourceService.Count(TicketSourceFilter); if (count == 0) { return(false); } } return(true); }
public async Task <int> Count(TicketSourceFilter TicketSourceFilter) { try { int result = await UOW.TicketSourceRepository.Count(TicketSourceFilter); return(result); } catch (Exception ex) { if (ex.InnerException == null) { await Logging.CreateSystemLog(ex, nameof(TicketSourceService)); throw new MessageException(ex); } else { await Logging.CreateSystemLog(ex.InnerException, nameof(TicketSourceService)); throw new MessageException(ex.InnerException); } } }
public async Task <List <TicketSource> > List(TicketSourceFilter TicketSourceFilter) { try { List <TicketSource> TicketSources = await UOW.TicketSourceRepository.List(TicketSourceFilter); return(TicketSources); } catch (Exception ex) { if (ex.InnerException == null) { await Logging.CreateSystemLog(ex, nameof(TicketSourceService)); throw new MessageException(ex); } else { await Logging.CreateSystemLog(ex.InnerException, nameof(TicketSourceService)); throw new MessageException(ex.InnerException); } } }
private IQueryable <TicketSourceDAO> DynamicOrder(IQueryable <TicketSourceDAO> query, TicketSourceFilter filter) { switch (filter.OrderType) { case OrderType.ASC: switch (filter.OrderBy) { case TicketSourceOrder.Id: query = query.OrderBy(q => q.Id); break; case TicketSourceOrder.Name: query = query.OrderBy(q => q.Name); break; case TicketSourceOrder.OrderNumber: query = query.OrderBy(q => q.OrderNumber); break; case TicketSourceOrder.Status: query = query.OrderBy(q => q.StatusId); break; case TicketSourceOrder.Used: query = query.OrderBy(q => q.Used); break; } break; case OrderType.DESC: switch (filter.OrderBy) { case TicketSourceOrder.Id: query = query.OrderByDescending(q => q.Id); break; case TicketSourceOrder.Name: query = query.OrderByDescending(q => q.Name); break; case TicketSourceOrder.OrderNumber: query = query.OrderByDescending(q => q.OrderNumber); break; case TicketSourceOrder.Status: query = query.OrderByDescending(q => q.StatusId); break; case TicketSourceOrder.Used: query = query.OrderByDescending(q => q.Used); break; } break; } query = query.Skip(filter.Skip).Take(filter.Take); return(query); }
private IQueryable <TicketSourceDAO> OrFilter(IQueryable <TicketSourceDAO> query, TicketSourceFilter filter) { if (filter.OrFilter == null || filter.OrFilter.Count == 0) { return(query); } IQueryable <TicketSourceDAO> initQuery = query.Where(q => false); foreach (TicketSourceFilter TicketSourceFilter in filter.OrFilter) { IQueryable <TicketSourceDAO> queryable = query; if (TicketSourceFilter.Id != null) { queryable = queryable.Where(q => q.Id, TicketSourceFilter.Id); } if (TicketSourceFilter.Name != null) { queryable = queryable.Where(q => q.Name, TicketSourceFilter.Name); } if (TicketSourceFilter.OrderNumber != null) { queryable = queryable.Where(q => q.OrderNumber, TicketSourceFilter.OrderNumber); } if (TicketSourceFilter.StatusId != null) { queryable = queryable.Where(q => q.StatusId, TicketSourceFilter.StatusId); } initQuery = initQuery.Union(queryable); } return(initQuery); }
private IQueryable <TicketSourceDAO> DynamicFilter(IQueryable <TicketSourceDAO> query, TicketSourceFilter 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); } if (filter.Name != null) { query = query.Where(q => q.Name, filter.Name); } if (filter.OrderNumber != null) { query = query.Where(q => q.OrderNumber, filter.OrderNumber); } if (filter.StatusId != null) { query = query.Where(q => q.StatusId, filter.StatusId); } query = OrFilter(query, filter); return(query); }
private async Task <List <TicketSource> > DynamicSelect(IQueryable <TicketSourceDAO> query, TicketSourceFilter filter) { List <TicketSource> TicketSources = await query.Select(q => new TicketSource() { Id = filter.Selects.Contains(TicketSourceSelect.Id) ? q.Id : default(long), Name = filter.Selects.Contains(TicketSourceSelect.Name) ? q.Name : default(string), OrderNumber = filter.Selects.Contains(TicketSourceSelect.OrderNumber) ? q.OrderNumber : default(long), StatusId = filter.Selects.Contains(TicketSourceSelect.Status) ? q.StatusId : default(long), Used = filter.Selects.Contains(TicketSourceSelect.Used) ? q.Used : default(bool), Status = filter.Selects.Contains(TicketSourceSelect.Status) && q.Status != null ? new Status { Id = q.Status.Id, Code = q.Status.Code, Name = q.Status.Name, } : null, CreatedAt = q.CreatedAt, UpdatedAt = q.UpdatedAt, }).ToListAsync(); return(TicketSources); }