Beispiel #1
0
        public static Panel ConvertToDomainModel(this PanelDto panelDto)
        {
            var panel = new Panel(new PersistPanel()
            {
                Active       = true,
                PanelId      = panelDto.Id,
                PanelName    = panelDto.Name,
                AdvertiserId = panelDto.AdvertiserId,
            });

            return(panel);
        }
        public IActionResult MountPanel([FromBody] PanelDto panelDto, [FromQuery] string sessionId)
        {
            var session = _db.Sessions.First(x => x.Id == Guid.Parse(sessionId));
            var panel   = _db.Panels.Where(x => x.Session == session).First(x => x.ForgeId == panelDto.ForgeId);

            panel.IsMounted = true;
            _db.SaveChanges();
            var result = Mapper.Map <PanelDto>(panel);

            _signalService.PanelMounted(result);
            return(Ok(null));
        }
Beispiel #3
0
        public void Then_Updating_A_NonExistant_Panel_Will_Cause_A_DomainException()
        {
            _searchByIdReturnsResult = false;
            Initialize();

            PanelDto dto = new PanelDto {
                AdvertiserId = 1, Id = 100, Name = "Panel Update Name"
            };

            _panelService.UpdatePanel(dto);

            _panelRepository.Verify(r => r.Update(It.IsAny <Panel>()), Times.Never);
        }
Beispiel #4
0
        private PanelDto ConvertDomainModelToDto(Panel domainModel)
        {
            PanelDto dto = null;

            if (domainModel != null)
            {
                dto      = new PanelDto();
                dto.Id   = domainModel.Id;
                dto.Name = domainModel.Name;
            }

            return(dto);
        }
Beispiel #5
0
        private static void ValidateUpdateOfDomainModel(PanelDto panelDto, Panel panel)
        {
            if (panelDto == null)
            {
                throw new DomainException("Unable to update Panel from null PanelDto.");
            }

            if (panel == null)
            {
                throw new DomainException("Unable to update null Panel from PanelDto.");
            }

            if (panel.Id != panelDto.Id)
            {
                throw new DomainException("Unable to update Panel since Id values do not match.");
            }
        }
        public async Task <IList <WeeklyReport> > GetReport(PanelDto model)
        {
            // List<WeeklyReport> data = await  _context.WeeklyReport.Where(x => x.Customer.Id == customer && x.CustomerId == model.Customer).ToListAsync();
            List <WeeklyReport> data = null;

            if (model.FinishedEnd == null)
            {
                model.FinishedEnd = DateTime.Now;
            }
            if (model.RequestEnd == null)
            {
                model.RequestEnd = DateTime.Now;
            }
            DateTime? finishedEnd   = model.FinishedEnd;
            DateTime? finishedStart = model.FinishedStart;
            DateTime? requestEnd    = model.RequestEnd;
            DateTime? requestStart  = model.RequestStart;
            EPriority?priority      = model.Priority;
            EStatus?  status        = model.Status;
            int?      customer      = model.Customer;
            int?      request       = model.Request;
            int?      responsible   = model.Responsible;



            //status
            if (status != null && responsible == null && request == null && finishedStart == null && requestStart == null && priority == null)
            {
                data = await _context.WeeklyReport.Where(x => x.Customer.Id == customer && x.Status == status).ToListAsync();
            }
            //responsible
            else if (status == null && responsible != null && request == null && finishedStart == null && requestStart == null && priority == null)
            {
                data = await _context.WeeklyReport.Where(x => x.Customer.Id == customer && x.ResponsibleArea.Id == responsible).
                       ToListAsync();
            }
            //request
            else if (status == null && responsible == null && request != null && finishedStart == null && requestStart == null && priority == null)
            {
                data = await _context.WeeklyReport.Where(x => x.Customer.Id == customer &&
                                                         x.Request.Id == request).
                       ToListAsync();
            }
            //finishedStart
            else if (status == null && responsible == null && request == null && finishedStart != null && requestStart == null && priority == null)
            {
                data = await _context.WeeklyReport.Where(x => x.Customer.Id == customer &&
                                                         x.DateFinished >= finishedStart && x.DateFinished <= finishedEnd).
                       ToListAsync();
            }
            //requestStart
            else if (status == null && responsible == null && request == null && finishedStart == null && requestStart != null && priority == null)
            {
                data = await _context.WeeklyReport.Where(x => x.Customer.Id == customer &&
                                                         x.DateRequest >= requestStart && x.DateRequest <= requestEnd).
                       ToListAsync();
            }
            //priority
            else if (status == null && responsible == null && request == null && finishedStart == null && requestStart == null && priority != null)
            {
                data = await _context.WeeklyReport.Where(x => x.Customer.Id == customer &&
                                                         x.Priority == priority).
                       ToListAsync();
            }

            //------Filter two item------

            //stats responsible

            else if (status != null && responsible != null && request == null && finishedStart == null && requestStart == null && priority == null)
            {
                data = await _context.WeeklyReport.Where(x => x.Customer.Id == customer &&
                                                         x.Status == status &&
                                                         x.ResponsibleArea.Id == responsible).
                       ToListAsync();
            }
            //status request
            else if (status != null && responsible == null && request != null && finishedStart == null && requestStart == null && priority == null)
            {
                data = await _context.WeeklyReport.Where(x => x.Customer.Id == customer &&
                                                         x.Status == status &&
                                                         x.Request.Id == request).
                       ToListAsync();
            }
            //status finishedStart
            else if (status != null && responsible == null && request == null && finishedStart != null && requestStart == null && priority == null)
            {
                data = await _context.WeeklyReport.Where(x => x.Customer.Id == customer &&
                                                         x.Status == status &&
                                                         x.DateFinished >= finishedStart && x.DateFinished <= finishedEnd).
                       ToListAsync();
            }
            //status requestStart
            else if (status != null && responsible == null && request == null && finishedStart == null && requestStart != null && priority == null)
            {
                data = await _context.WeeklyReport.Where(x => x.Customer.Id == customer &&
                                                         x.Status == status &&
                                                         x.DateRequest >= requestStart && x.DateRequest <= requestEnd).
                       ToListAsync();
            }
            //status priority
            else if (status != null && responsible == null && request == null && finishedStart == null && requestStart == null && priority != null)
            {
                data = await _context.WeeklyReport.Where(x => x.Customer.Id == customer &&
                                                         x.Status == status &&
                                                         x.Priority == priority).
                       ToListAsync();
            }

            //responsible request
            else if (status == null && responsible != null && request != null && finishedStart == null && requestStart == null && priority == null)
            {
                data = await _context.WeeklyReport.Where(x => x.Customer.Id == customer &&
                                                         x.ResponsibleArea.Id == responsible &&
                                                         x.Request.Id == request).
                       ToListAsync();
            }
            //responsible inicial
            else if (status == null && responsible == null && request != null && finishedStart != null && requestStart == null && priority == null)
            {
                data = await _context.WeeklyReport.Where(x => x.Customer.Id == customer &&
                                                         x.Request.Id == request &&
                                                         x.DateFinished >= finishedStart && x.DateFinished <= finishedEnd).
                       ToListAsync();
            }
            //responsible requestStart
            else if (status == null && responsible != null && request == null && finishedStart == null && requestStart != null && priority == null)
            {
                data = await _context.WeeklyReport.Where(x => x.Customer.Id == customer &&
                                                         x.ResponsibleArea.Id == responsible &&
                                                         x.DateRequest >= requestStart && x.DateRequest <= requestEnd).
                       ToListAsync();
            }
            //responsible priority
            else if (status == null && responsible != null && request == null && finishedStart == null && requestStart == null && priority != null)
            {
                data = await _context.WeeklyReport.Where(x => x.Customer.Id == customer &&
                                                         x.ResponsibleArea.Id == responsible &&
                                                         x.Priority == priority).
                       ToListAsync();
            }

            //request inicial
            else if (status == null && responsible == null && request != null && finishedStart != null && requestStart == null && priority == null)
            {
                data = await _context.WeeklyReport.Where(x => x.Customer.Id == customer &&
                                                         x.Request.Id == request &&
                                                         x.DateFinished >= finishedStart && x.DateFinished <= finishedEnd).
                       ToListAsync();
            }
            //request requestStart
            else if (status == null && responsible == null && request != null && finishedStart == null && requestStart != null && priority == null)
            {
                data = await _context.WeeklyReport.Where(x => x.Customer.Id == customer &&
                                                         x.Request.Id == request &&
                                                         x.DateRequest >= requestStart && x.DateRequest <= requestEnd).
                       ToListAsync();
            }
            //request priority
            else if (status == null && responsible == null && request != null && finishedStart == null && requestStart == null && priority != null)
            {
                data = await _context.WeeklyReport.Where(x => x.Customer.Id == customer &&
                                                         x.Request.Id == request &&
                                                         x.Priority == priority).
                       ToListAsync();
            }

            //inicial requestStart
            else if (status == null && responsible == null && request == null && finishedStart != null && requestStart != null && priority == null)
            {
                data = await _context.WeeklyReport.Where(x => x.Customer.Id == customer &&
                                                         x.DateRequest >= requestStart && x.DateRequest <= requestEnd &&
                                                         x.DateFinished >= finishedStart && x.DateFinished <= finishedEnd).
                       ToListAsync();
            }
            //finishedStart priority
            else if (status == null && responsible == null && request == null && finishedStart != null && requestStart == null && priority != null)
            {
                data = await _context.WeeklyReport.Where(x => x.Customer.Id == customer &&
                                                         x.DateRequest >= finishedStart && x.DateRequest <= requestEnd &&
                                                         x.Priority == priority).
                       ToListAsync();
            }


            //requestStart priority
            else if (status == null && responsible == null && request == null && finishedStart == null && requestStart != null && priority != null)
            {
                data = await _context.WeeklyReport.Where(x => x.Customer.Id == customer &&
                                                         x.DateRequest >= requestStart && x.DateRequest <= requestEnd &&
                                                         x.Priority == priority).
                       ToListAsync();
            }

            //------filter three item

            //stats responsible request

            else if (status != null && responsible != null && request != null && finishedStart == null && requestStart == null && priority == null)
            {
                data = await _context.WeeklyReport.Where(x => x.Customer.Id == customer &&
                                                         x.Status == status &&
                                                         x.ResponsibleArea.Id == responsible &&
                                                         x.Request.Id == request).
                       ToListAsync();
            }
            //stats responsible finishedStart
            else if (status != null && responsible != null && request == null && finishedStart != null && requestStart == null && priority == null)
            {
                data = await _context.WeeklyReport.Where(x => x.Customer.Id == customer &&
                                                         x.Status == status &&
                                                         x.ResponsibleArea.Id == responsible &&
                                                         x.DateFinished >= finishedStart && x.DateFinished <= finishedEnd).
                       ToListAsync();
            }
            //stats responsible finishedStart
            else if (status != null && responsible != null && request == null && finishedStart == null && requestStart != null && priority == null)
            {
                data = await _context.WeeklyReport.Where(x => x.Customer.Id == customer &&
                                                         x.Status == status &&
                                                         x.ResponsibleArea.Id == responsible &&
                                                         x.DateRequest >= requestStart && x.DateRequest <= requestEnd).
                       ToListAsync();
            }
            //stats responsible Priority
            else if (status != null && responsible != null && request == null && finishedStart == null && requestStart == null && priority != null)
            {
                data = await _context.WeeklyReport.Where(x => x.Customer.Id == customer &&
                                                         x.Status == status &&
                                                         x.ResponsibleArea.Id == responsible &&
                                                         x.Priority == priority).
                       ToListAsync();
            }


            //responsible request finishedStart
            else if (status == null && responsible != null && request != null && finishedStart != null && requestStart == null && priority == null)
            {
                data = await _context.WeeklyReport.Where(x => x.Customer.Id == customer &&
                                                         x.ResponsibleArea.Id == responsible &&
                                                         x.Request.Id == request &&
                                                         x.DateFinished >= finishedStart && x.DateFinished <= finishedEnd).
                       ToListAsync();
            }
            //responsible request requestStart
            else if (status == null && responsible != null && request != null && finishedStart == null && requestStart != null && priority == null)
            {
                data = await _context.WeeklyReport.Where(x => x.Customer.Id == customer &&
                                                         x.ResponsibleArea.Id == responsible &&
                                                         x.Request.Id == request &&
                                                         x.DateRequest >= requestStart && x.DateRequest <= requestEnd).
                       ToListAsync();
            }
            //responsible request priority
            else if (status == null && responsible != null && request != null && finishedStart == null && requestStart == null && priority != null)
            {
                data = await _context.WeeklyReport.Where(x => x.Customer.Id == customer &&
                                                         x.ResponsibleArea.Id == responsible &&
                                                         x.Request.Id == request &&
                                                         x.Priority == priority).
                       ToListAsync();
            }
            //finishedStart requestStart priority
            else if (status == null && responsible == null && request == null && finishedStart != null && requestStart != null && priority != null)
            {
                data = await _context.WeeklyReport.Where(x => x.Customer.Id == customer &&
                                                         x.DateFinished >= finishedStart && x.DateFinished <= finishedEnd &&
                                                         x.DateRequest >= requestStart && x.DateRequest <= requestEnd &&
                                                         x.Priority == priority).
                       ToListAsync();
            }
            //finishedStart requestStart status

            else if (status != null && responsible == null && request == null && finishedStart != null && requestStart != null && priority == null)
            {
                data = await _context.WeeklyReport.Where(x => x.Customer.Id == customer &&
                                                         x.DateFinished >= finishedStart && x.DateFinished <= finishedEnd &&
                                                         x.DateRequest >= requestStart && x.DateRequest <= requestEnd &&
                                                         x.Status == status).
                       ToListAsync();
            }

            //finishedStart requestStart responsible
            else if (status == null && responsible != null && request == null && finishedStart != null && requestStart != null && priority == null)
            {
                data = await _context.WeeklyReport.Where(x => x.Customer.Id == customer &&
                                                         x.DateFinished >= finishedStart && x.DateFinished <= finishedEnd &&
                                                         x.DateRequest >= requestStart && x.DateRequest <= requestEnd &&
                                                         x.ResponsibleArea.Id == responsible).
                       ToListAsync();
            }
            //finishedStart requestStart request
            else if (status == null && responsible == null && request != null && finishedStart != null && requestStart != null && priority == null)
            {
                data = await _context.WeeklyReport.Where(x => x.Customer.Id == customer &&
                                                         x.DateFinished >= finishedStart && x.DateFinished <= finishedEnd &&
                                                         x.DateRequest >= requestStart && x.DateRequest <= requestEnd &&
                                                         x.Request.Id == request).
                       ToListAsync();
            }
            //requestStart priority status
            else if (status != null && responsible == null && request == null && finishedStart == null && requestStart != null && priority != null)
            {
                data = await _context.WeeklyReport.Where(x => x.Customer.Id == customer &&
                                                         x.Status == status &&
                                                         x.DateRequest >= requestStart && x.DateRequest <= requestEnd &&
                                                         x.Priority == priority).
                       ToListAsync();
            }
            //requestStart priority responsible
            else if (status == null && responsible != null && request == null && finishedStart == null && requestStart != null && priority != null)
            {
                data = await _context.WeeklyReport.Where(x => x.Customer.Id == customer &&
                                                         x.ResponsibleArea.Id == responsible &&
                                                         x.DateRequest >= requestStart && x.DateRequest <= requestEnd &&
                                                         x.Priority == priority).
                       ToListAsync();
            }
            //requestStart priority request
            else if (status == null && responsible == null && request != null && finishedStart == null && requestStart != null && priority != null)
            {
                data = await _context.WeeklyReport.Where(x => x.Customer.Id == customer &&
                                                         x.Request.Id == request &&
                                                         x.DateRequest >= requestStart && x.DateRequest <= requestEnd &&
                                                         x.Priority == priority).
                       ToListAsync();
            }
            //priority status responsible

            else if (status != null && responsible != null && request == null && finishedStart == null && requestStart != null && priority != null)
            {
                data = await _context.WeeklyReport.Where(x => x.Customer.Id == customer &&
                                                         x.Status == status &&
                                                         x.ResponsibleArea.Id == responsible &&
                                                         x.DateRequest >= requestStart && x.DateRequest <= requestEnd &&
                                                         x.Priority == priority).ToListAsync();
            }

            //priority  responsible request
            else if (status == null && responsible != null && request != null && finishedStart == null && requestStart != null && priority != null)
            {
                data = await _context.WeeklyReport.Where(x => x.Customer.Id == customer &&
                                                         x.Request.Id == request &&
                                                         x.ResponsibleArea.Id == responsible &&
                                                         x.DateRequest >= requestStart && x.DateRequest <= requestEnd &&
                                                         x.Priority == priority).
                       ToListAsync();
            }
            //priority   request finishedStart
            else if (status == null && responsible == null && request != null && finishedStart != null && requestStart != null && priority != null)
            {
                data = await _context.WeeklyReport.Where(x => x.Customer.Id == customer &&
                                                         x.Request.Id == request &&
                                                         x.DateRequest >= requestStart && x.DateRequest <= requestEnd &&
                                                         x.DateFinished >= finishedStart && x.DateFinished <= finishedEnd &&
                                                         x.Priority == priority).
                       ToListAsync();
            }

            //priority   request finishedStart
            else if (status != null && responsible == null && request == null && finishedStart != null && requestStart == null && priority != null)
            {
                data = await _context.WeeklyReport.Where(x => x.Customer.Id == customer &&
                                                         x.Status == status &&
                                                         x.DateFinished >= finishedStart && x.DateFinished <= finishedEnd &&
                                                         x.Priority == priority).
                       ToListAsync();
            }
            //------Filter four items

            // request finishedStart requestStart priority
            else if (status == null && responsible == null && request != null && finishedStart != null && requestStart != null && priority != null)
            {
                data = await _context.WeeklyReport.Where(x => x.Customer.Id == customer &&
                                                         x.Request.Id == request &&
                                                         x.DateRequest >= requestStart && x.DateRequest <= requestEnd &&
                                                         x.DateFinished >= finishedStart && x.DateFinished <= finishedEnd &&
                                                         x.Priority == priority).
                       ToListAsync();
            }
            // responsible finishedStart requestStart priority
            else if (status == null && responsible != null && request == null && finishedStart != null && requestStart != null && priority != null)
            {
                data = await _context.WeeklyReport.Where(x => x.Customer.Id == customer &&
                                                         x.ResponsibleArea.Id == responsible &&
                                                         x.DateRequest >= requestStart && x.DateRequest <= requestEnd &&
                                                         x.DateFinished >= finishedStart && x.DateFinished <= finishedEnd &&
                                                         x.Priority == priority).
                       ToListAsync();
            }
            //responsible request requestStart priority
            else if (status == null && responsible != null && request != null && finishedStart == null && requestStart != null && priority != null)
            {
                data = await _context.WeeklyReport.Where(x => x.Customer.Id == customer &&
                                                         x.Request.Id == request &&
                                                         x.ResponsibleArea.Id == responsible &&
                                                         x.DateRequest >= requestStart && x.DateRequest <= requestEnd &&
                                                         x.Priority == priority).
                       ToListAsync();
            }
            //responsible request finishedStart priority
            else if (status == null && responsible != null && request != null && finishedStart != null && requestStart == null && priority != null)
            {
                data = await _context.WeeklyReport.Where(x => x.Customer.Id == customer &&
                                                         x.Request.Id == request &&
                                                         x.ResponsibleArea.Id == responsible &&
                                                         x.DateFinished >= finishedStart && x.DateFinished <= finishedEnd &&
                                                         x.Priority == priority).
                       ToListAsync();
            }
            // responsible request finishedStart requestStart
            else if (status == null && responsible != null && request != null && finishedStart != null && requestStart != null && priority == null)
            {
                data = await _context.WeeklyReport.Where(x => x.Customer.Id == customer &&
                                                         x.ResponsibleArea.Id == responsible &&
                                                         x.Request.Id == request &&
                                                         x.DateRequest >= requestStart && x.DateRequest <= requestEnd &&
                                                         x.DateFinished >= finishedStart && x.DateFinished <= finishedEnd).
                       ToListAsync();
            }
            // status finishedStart requestStart priority

            else if (status != null && responsible == null && request == null && finishedStart != null && requestStart != null && priority != null)
            {
                data = await _context.WeeklyReport.Where(x => x.Customer.Id == customer &&
                                                         x.Status == status &&
                                                         x.DateRequest >= requestStart && x.DateRequest <= requestEnd &&
                                                         x.DateFinished >= finishedStart && x.DateFinished <= finishedEnd &&
                                                         x.Priority == priority).
                       ToListAsync();
            }
            // status request requestStart priority
            else if (status != null && responsible == null && request != null && finishedStart == null && requestStart != null && priority != null)
            {
                data = await _context.WeeklyReport.Where(x => x.Customer.Id == customer &&
                                                         x.Status == status &&
                                                         x.Request.Id == request &&
                                                         x.DateRequest >= requestStart && x.DateRequest <= requestEnd &&
                                                         x.Priority == priority).
                       ToListAsync();
            }
            // status request finishedStart priority
            else if (status != null && responsible == null && request != null && finishedStart != null && requestStart == null && priority != null)
            {
                data = await _context.WeeklyReport.Where(x => x.Customer.Id == customer &&
                                                         x.Status == status &&
                                                         x.Request.Id == request &&
                                                         x.DateFinished >= finishedStart && x.DateFinished <= finishedEnd &&
                                                         x.Priority == priority).
                       ToListAsync();
            }
            // status request finishedStart requestStart
            else if (status != null && responsible == null && request != null && finishedStart != null && requestStart != null && priority == null)
            {
                data = await _context.WeeklyReport.Where(x => x.Customer.Id == customer &&
                                                         x.Status == status &&
                                                         x.DateRequest >= requestStart && x.DateRequest <= requestEnd &&
                                                         x.DateFinished >= finishedStart && x.DateFinished <= finishedEnd).
                       ToListAsync();
            }
            // status responsible requestStart priority
            else if (status != null && responsible == null && request != null && finishedStart != null && requestStart == null && priority != null)
            {
                data = await _context.WeeklyReport.Where(x => x.Customer.Id == customer &&
                                                         x.Status == status &&
                                                         x.Request.Id == request &&
                                                         x.DateFinished >= finishedStart && x.DateFinished <= finishedEnd &&
                                                         x.Priority == priority).
                       ToListAsync();
            }
            // status responsible finishedStart priority
            else if (status != null && responsible != null && request == null && finishedStart != null && requestStart == null && priority != null)
            {
                data = await _context.WeeklyReport.Where(x => x.Customer.Id == customer &&
                                                         x.Status == status &&
                                                         x.ResponsibleArea.Id == responsible &&
                                                         x.DateFinished >= finishedStart && x.DateFinished <= finishedEnd &&
                                                         x.Priority == priority).
                       ToListAsync();
            }
            // status responsible request priority
            else if (status != null && responsible != null && request != null && finishedStart == null && requestStart == null && priority != null)
            {
                data = await _context.WeeklyReport.Where(x => x.Customer.Id == customer &&
                                                         x.Status == status &&
                                                         x.ResponsibleArea.Id == responsible &&
                                                         x.Request.Id == request &&
                                                         x.Priority == priority).
                       ToListAsync();
            }
            // status responsible request requestStart
            else if (status != null && responsible != null && request != null && finishedStart == null && requestStart != null && priority == null)
            {
                data = await _context.WeeklyReport.Where(x => x.Customer.Id == customer &&
                                                         x.Status == status &&
                                                         x.ResponsibleArea.Id == responsible &&
                                                         x.Request.Id == request &&
                                                         x.DateRequest >= requestStart && x.DateRequest <= requestEnd).
                       ToListAsync();
            }
            // status responsible request finishedStart
            else if (status != null && responsible != null && request != null && finishedStart != null && requestStart == null && priority == null)
            {
                data = await _context.WeeklyReport.Where(x => x.Customer.Id == customer &&
                                                         x.Status == status &&
                                                         x.ResponsibleArea.Id == responsible &&
                                                         x.Request.Id == request &&
                                                         x.DateFinished >= finishedStart && x.DateFinished <= finishedEnd).
                       ToListAsync();
            }

            // status responsible  finishedStart requestStart
            else if (status != null && responsible != null && request == null && finishedStart != null && requestStart != null && priority == null)
            {
                data = await _context.WeeklyReport.Where(x => x.Customer.Id == customer &&
                                                         x.Status == status &&
                                                         x.ResponsibleArea.Id == responsible &&
                                                         x.DateRequest >= requestStart && x.DateRequest <= requestEnd &&
                                                         x.DateFinished >= finishedStart && x.DateFinished <= finishedEnd).
                       ToListAsync();
            }

            //------Filter five item
            //status request finishedStart requestStart priority

            else if (status != null && responsible == null && request != null && finishedStart != null && requestStart != null && priority != null)
            {
                data = await _context.WeeklyReport.Where(x => x.Customer.Id == customer &&
                                                         x.Status == status &&
                                                         x.Request.Id == request &&
                                                         x.DateRequest >= requestStart && x.DateRequest <= requestEnd &&
                                                         x.DateFinished >= finishedStart && x.DateFinished <= finishedEnd &&
                                                         x.Priority == priority).
                       ToListAsync();
            }
            //status responsible finishedStart requestStart priority
            else if (status != null && responsible != null && request == null && finishedStart != null && requestStart != null && priority != null)
            {
                data = await _context.WeeklyReport.Where(x => x.Customer.Id == customer &&
                                                         x.Status == status &&
                                                         x.ResponsibleArea.Id == responsible &&
                                                         x.DateRequest >= requestStart && x.DateRequest <= requestEnd &&
                                                         x.DateFinished >= finishedStart && x.DateFinished <= finishedEnd &&
                                                         x.Priority == priority).
                       ToListAsync();
            }
            //status responsible request requestStart priority
            else if (status != null && responsible != null && request != null && finishedStart == null && requestStart != null && priority != null)
            {
                data = await _context.WeeklyReport.Where(x => x.Customer.Id == customer &&
                                                         x.Status == status &&
                                                         x.ResponsibleArea.Id == responsible &&
                                                         x.Request.Id == request &&
                                                         x.DateRequest >= requestStart && x.DateRequest <= requestEnd &&
                                                         x.Priority == priority).ToListAsync();
            }
            //status responsible request finishedStart priority
            else if (status != null && responsible != null && request != null && finishedStart != null && requestStart == null && priority != null)
            {
                data = await _context.WeeklyReport.Where(x => x.Customer.Id == customer &&
                                                         x.Status == status &&
                                                         x.ResponsibleArea.Id == responsible &&
                                                         x.Request.Id == request &&
                                                         x.DateFinished >= finishedStart && x.DateFinished <= finishedEnd &&
                                                         x.Priority == priority).
                       ToListAsync();
            }
            //status responsible request finishedStart requestStart
            else if (status != null && responsible != null && request != null && finishedStart != null && requestStart != null && priority == null)
            {
                data = await _context.WeeklyReport.Where(x => x.Customer.Id == customer &&
                                                         x.Status == status &&
                                                         x.ResponsibleArea.Id == responsible &&
                                                         x.Request.Id == request &&
                                                         x.DateRequest >= requestStart && x.DateRequest <= requestEnd &&
                                                         x.DateFinished >= finishedStart && x.DateFinished <= finishedEnd).
                       ToListAsync();
            }


            //responsible request finishedStart requestStart priority
            else if (status == null && responsible != null && request != null && finishedStart != null && requestStart != null && priority != null)
            {
                data = await _context.WeeklyReport.Where(x => x.Customer.Id == customer &&
                                                         x.ResponsibleArea.Id == responsible &&
                                                         x.Request.Id == request &&
                                                         x.DateRequest >= requestStart && x.DateRequest <= requestEnd &&
                                                         x.DateFinished >= finishedStart && x.DateFinished <= finishedEnd &&
                                                         x.Priority == priority).
                       ToListAsync();
            }

            //------Filter six item
            //stats responsible request finishedStart requestStart priority
            else if (status != null && responsible != null && request != null && finishedStart != null && requestStart != null && priority != null)
            {
                data = await _context.WeeklyReport.Where(x => x.Customer.Id == customer &&
                                                         x.Status == status &&
                                                         x.ResponsibleArea.Id == responsible &&
                                                         x.Request.Id == request &&
                                                         x.DateRequest >= requestStart && x.DateRequest <= requestEnd &&
                                                         x.DateFinished >= finishedStart && x.DateFinished <= finishedEnd &&
                                                         x.Priority == priority).ToListAsync();
            }

            else
            {
                data = await _context.WeeklyReport.Where(x => x.Customer.Id == customer).
                       OrderByDescending(u => u.Id).
                       ToListAsync();
            }

            return(data);
        }
Beispiel #7
0
        public async Task <IList <WeeklyReport> > GetAll([FromBody] PanelDto model)
        {
            var data = await _weekyReportPanel.GetReport(model);

            return(data);
        }
Beispiel #8
0
 public void UpdatePanel(PanelDto dto)
 {
     _panelsService.UpdatePanel(dto);
 }
Beispiel #9
0
 public void PanelMounted(PanelDto panel)
 {
     _hub.Clients.All.InvokeAsync("PanelMounted", panel);
 }
Beispiel #10
0
 public async Task <IHttpActionResult> Put(PanelDto dto)
 {
     _panelsFacade.UpdatePanel(dto);
     return(NoContent());
 }
Beispiel #11
0
        public async Task <IHttpActionResult> Post(PanelDto dto)
        {
            PanelDto newPanel = _panelsFacade.CreatePanel(dto);

            return(Created <PanelDto>(Url.Content(Url.Route(PanelRoute.CREATE, new { panelId = newPanel.Id })), newPanel));
        }