public PagedResponse <UseCaseLogDto> Execute(UseCaseLogSearch search) { var query = _context.UseCaseLogs.AsQueryable(); switch (search.SearchBy) { case "datetime": break; case "actor": if (!string.IsNullOrEmpty(search.SearchText) || !string.IsNullOrWhiteSpace(search.SearchText)) { query = query.Where(ucl => ucl.Actor.ToLower().Contains(search.SearchText.ToLower())); } break; case "usecasename": if (!string.IsNullOrEmpty(search.SearchText) || !string.IsNullOrWhiteSpace(search.SearchText)) { query = query.Where(ucl => ucl.UseCaseName.ToLower().Contains(search.SearchText.ToLower())); } break; } return(query.Paged <UseCaseLogDto, UseCaseLog>(search, _mapper)); }
public PagedResponse <UseCaseLogDto> Execute(UseCaseLogSearch search) { var query = _context.UseCaseLogs.AsQueryable(); if (!string.IsNullOrEmpty(search.Actor) || !string.IsNullOrWhiteSpace(search.Actor)) { query = query.Where(x => x.Actor.ToLower().Contains(search.Actor.ToLower())); } if (!string.IsNullOrEmpty(search.UseCaseName) || !string.IsNullOrWhiteSpace(search.UseCaseName)) { query = query.Where(x => x.UseCaseName.ToLower().Contains(search.UseCaseName.ToLower())); } var skipCount = search.PerPage * (search.Page - 1); var response = new PagedResponse <UseCaseLogDto> { CurrentPage = search.Page, ItemsPerPage = search.PerPage, TotalCount = query.Count(), Items = query.Skip(skipCount).Take(search.PerPage).Select(x => new UseCaseLogDto { Id = x.Id, Actor = x.Actor, Data = x.Data, Date = x.Date, UseCaseName = x.UseCaseName }).ToList() }; return(response); }
public PagedResponse <UseCaseLogDto> Execute(UseCaseLogSearch search) { var query = _context.UseCaseLogs.AsQueryable(); if (!string.IsNullOrEmpty(search.UseCaseName) || !string.IsNullOrWhiteSpace(search.UseCaseName)) { query = query.Where(x => x.UseCaseName.ToLower().Contains(search.UseCaseName.ToLower())); } if (!string.IsNullOrEmpty(search.Actor) || !string.IsNullOrWhiteSpace(search.Actor)) { query = query.Where(x => x.Actor.ToLower().Contains(search.Actor.ToLower())); } if (search.BeforeDate != null) { query = query.Where(x => x.Date < search.BeforeDate); } if (search.AfterDate != null) { query = query.Where(x => x.Date > search.AfterDate); } return(query.Paged <UseCaseLogDto, UseCaseLog>(search, _mapper)); }
public IEnumerable <UseCaseLog> Execute(UseCaseLogSearch search) { var query = context.UseCaseLogs.AsQueryable(); if (search.StartDate != null) { query = query.Where(x => x.Date > search.StartDate); } if (search.EndDate != null) { query = query.Where(x => x.Date < search.EndDate); } if (search.UseCaseNameKeyword != null) { query = query.Where(x => x.UseCaseName.ToLower().Contains(search.UseCaseNameKeyword.ToLower())); } if (search.DataKeyword != null) { query = query.Where(x => x.Data.ToLower().Contains(search.DataKeyword.ToLower())); } if (search.ActorKeyword != null) { query = query.Where(x => x.Actor.ToLower().Contains(search.ActorKeyword.ToLower())); } return(query.ToList()); }
public PagedResponse <UseCaseLogDto> Execute(UseCaseLogSearch search) { var query = _context.UseCaseLogs.AsQueryable(); if (!string.IsNullOrEmpty(search.useCaseName) || !string.IsNullOrWhiteSpace(search.useCaseName)) { query = query.Where(x => x.UseCaseName.ToLower().Contains(search.useCaseName.ToLower())); } if (!string.IsNullOrEmpty(search.actor) || !string.IsNullOrWhiteSpace(search.actor)) { query = query.Where(x => x.Actor.ToLower().Contains(search.actor.ToLower())); } if (search.fromDate != null) { query = query.Where(x => x.Date.CompareTo(search.fromDate) >= 0); } //if (search.toDate!=null && search.toDate>search.fromDate) //{ // query = query.Where(x => x.Date.CompareTo(search.toDate)<=0); //} var skipCount = search.PerPage * (search.Page - 1); var response = new PagedResponse <UseCaseLogDto> { CurrentPage = search.Page, ItemsPerPage = search.PerPage, TotalCount = query.Count(), Items = query.Skip(skipCount).Take(search.PerPage).Select(x => _mapper.Map <UseCaseLogDto>(x)) }; return(response); }
public PagedResponse <UseCaseLogDto> Execute(UseCaseLogSearch search) { var query = _context.UseCaseLogs.AsQueryable(); if (!string.IsNullOrEmpty(search.UseCaseName) || !string.IsNullOrWhiteSpace(search.UseCaseName)) { query = query.Where(x => x.UseCaseName.ToLower().Contains(search.UseCaseName.ToLower())); } if (!string.IsNullOrEmpty(search.Actor) || !string.IsNullOrWhiteSpace(search.Actor)) { query = query.Where(x => x.Actor.ToLower().Contains(search.Actor.ToLower())); } if (search.FromDate != null) { query = query.Where(x => x.Date >= search.FromDate); } if (search.ToDate != null) { query = query.Where(x => x.Date <= search.ToDate); } var skipCount = search.PerPage * (search.Page - 1); var response = new PagedResponse <UseCaseLogDto> { CurrentPage = search.Page, ItemsPerPage = search.PerPage, TotalCount = query.Count(), Items = _mapper.Map <List <UseCaseLogDto> >(query.Skip(skipCount).Take(search.PerPage).ToList()) }; return(response); }
public IActionResult Get([FromQuery] UseCaseLogSearch search , [FromServices] IGetUseCaseLogsQuery query) { IEnumerable <UseCaseLog> useCaseLogs = _useCaseExecutor.ExecuteQuery(query, search); return(Ok(useCaseLogs)); }
public PagedResponse <UseCaseLogDto> Izvrsi(UseCaseLogSearch search) { var query = _context.UseCaseLogs.AsQueryable(); if (!string.IsNullOrEmpty(search.Naziv) || !string.IsNullOrWhiteSpace(search.Naziv)) { query = query.Where(x => x.UseCaseNaziv.ToLower().Contains(search.Naziv.ToLower())); } var skipCount = search.PerPage * (search.Page - 1); var response = new PagedResponse <UseCaseLogDto> { CurrentPage = search.Page, ItemsPerPage = search.PerPage, TotalCount = query.Count(), Items = query.Skip(skipCount).Take(search.PerPage).Select(x => new UseCaseLogDto { Id = x.Id, UseCaseNaziv = x.UseCaseNaziv }).ToList() }; return(response); }
public PagedResponse <UseCaseSearchDto> Execute(UseCaseLogSearch search) { var query = context.UseCaseLogs.AsQueryable(); if (!string.IsNullOrEmpty(search.NazivUseCase) || !string.IsNullOrWhiteSpace(search.NazivUseCase)) { query = query.Where(x => x.UseCaseNaziv.ToLower().Contains(search.NazivUseCase.ToLower())); } if (search.Datum != new DateTime()) { query = query.Where(x => x.Datum.Date.ToString() == search.Datum.Date.ToString("yyyy-MM-dd")); } if (!string.IsNullOrEmpty(search.EmailKlijenta) || !string.IsNullOrWhiteSpace(search.EmailKlijenta)) { if (search.NeUlogovaniKlijent != false) { query = query.Where(x => x.Actor.ToLower().Contains(search.EmailKlijenta.ToLower())); } else { query = query.Where(x => x.Actor.ToLower().Contains(search.EmailKlijenta.ToLower())); } } else { if (search.NeUlogovaniKlijent != false) { query = query.Where(x => x.Actor == "Ne ulogovani klijent"); } } var skipCount = search.PerPage * (search.Page - 1); var response = new PagedResponse <UseCaseSearchDto> { CurrentPage = search.Page, ItemsPerPage = search.PerPage, TotalCount = query.Count(), Items = query.Skip(skipCount).Take(search.PerPage).Select(x => new UseCaseSearchDto { UseCaseNaziv = x.UseCaseNaziv, Podaci = x.Podaci, Actor = x.Actor, Datum = x.Datum }).ToList() }; return(response); }
public PagedResponse <UseCaseLogDto> Execute(UseCaseLogSearch search) { var query = _context.UseCaseLogs.Include(x => x.User).Include(x => x.UseCase).AsQueryable(); if (!string.IsNullOrEmpty(search.UseCaseName) || !string.IsNullOrWhiteSpace(search.UseCaseName)) { query = query.Where(x => x.UseCase.Name.ToLower().Contains(search.UseCaseName.ToLower())); // query = query.Where(x => x.Name.ToLower().Contains(search.Name.ToLower())); } if (!string.IsNullOrEmpty(search.UserEmail) || !string.IsNullOrWhiteSpace(search.UserEmail)) { query = query.Where(x => x.User.Email.ToLower().Contains(search.UserEmail.ToLower())); } if (search.StartDate != null) { query = query.Where(x => x.Date >= search.StartDate); } if (search.EndDate != null) { query = query.Where(x => x.Date <= search.EndDate); } var skipCount = search.PerPage * (search.Page - 1); var response = new PagedResponse <UseCaseLogDto> { CurrentPage = search.Page, ItemsPerPage = search.PerPage, TotalCount = query.Count(), Items = query.Skip(skipCount).Take(search.PerPage).Select(x => new UseCaseLogDto { Id = x.Id, Data = x.Data, Date = x.Date, UseCaseId = x.UseCase.Id, UseCaseName = x.UseCase.Name, UserId = x.User.Id, UserEmail = x.User.Email }).ToList() }; return(response); }
public PagedResponse <UseCaseLogDto> Execute(UseCaseLogSearch search) { var query = context.UseCaseLogs.AsQueryable(); if (!string.IsNullOrEmpty(search.Actor) || !string.IsNullOrWhiteSpace(search.Actor)) { query = query.Where(x => x.Actor.ToLower().Contains(search.Actor.ToLower())); } if (!string.IsNullOrEmpty(search.UseCaseName) || !string.IsNullOrWhiteSpace(search.UseCaseName)) { query = query.Where(x => x.UseCaseName.ToLower().Contains(search.UseCaseName.ToLower())); } if (!string.IsNullOrEmpty(search.DateStart) || !string.IsNullOrWhiteSpace(search.DateStart) || !string.IsNullOrEmpty(search.DateEnd) || !string.IsNullOrWhiteSpace(search.DateEnd)) { DateTime startDate = Convert.ToDateTime(search.DateStart); DateTime endDate = Convert.ToDateTime(search.DateEnd); query = query.Where(x => x.Date >= startDate && x.Date <= endDate); } return(query.Paged <UseCaseLogDto, Domain.Entities.UseCaseLog>(search, mapper)); //var skipCount = search.PerPage * (search.Page - 1); ////Page == 1 //var reponse = new PagedResponse<UseCaseLogDto> //{ // CurrentPage = search.Page, // ItemsPerPage = search.PerPage, // TotalCount = query.Count(), // Items = query.Skip(skipCount).Take(search.PerPage).Select(x => new UseCaseLogDto // { // //maper dodaj ovde // Id = x.Id, // Actor = x.Actor, // UseCaseName = x.UseCaseName, // Data = x.Data, // Date = x.Date // }).ToList() //}; //return reponse; }
public PagedResponse <UseCaseLogDto, UseCaseLog> Execute(UseCaseLogSearch search) { if (_actor.RoleType != RoleType.Administrator && _actor.RoleType != RoleType.Moderator) { throw new NotAllowedException(UseCase.getUseCase(this.Id), _actor, "Only administrator and moderator can execute this action."); } var query = _context.UseCaseLogs.AsQueryable(); if (search.UseCaseId != 0) { query = query.Where(r => r.UseCaseId == search.UseCaseId); } if (!string.IsNullOrEmpty(search.Data) && !string.IsNullOrWhiteSpace(search.Data)) { query = query.Where(r => r.Data.ToLower().Contains(search.Data.ToLower())); } if (!string.IsNullOrEmpty(search.UseCaseName) && !string.IsNullOrWhiteSpace(search.UseCaseName)) { query = query.Where(r => r.UseCaseName.ToLower().Contains(search.UseCaseName.ToLower())); } if (!string.IsNullOrEmpty(search.Actor) && !string.IsNullOrWhiteSpace(search.Actor)) { query = query.Where(r => r.Actor.ToLower().Contains(search.Actor.ToLower())); } if (!string.IsNullOrEmpty(search.DateFrom) && !string.IsNullOrWhiteSpace(search.DateFrom)) { query = query.Where(r => r.Date.Date >= DateTime.Parse(search.DateFrom)); } if (!string.IsNullOrEmpty(search.DateTo) && !string.IsNullOrWhiteSpace(search.DateTo)) { query = query.Where(r => r.Date.Date <= DateTime.Parse(search.DateTo)); } query = query; return(new PagedResponse <UseCaseLogDto, UseCaseLog>(query, search, _mapper)); }
public IActionResult Get([FromQuery] UseCaseLogSearch search, [FromServices] IGetUseCaseLogQuery query) { return(Ok(_executor.ExecuteQuery(query, search))); }