public IActionResult Index() { var model = new CaseDeactivationFilterVM() { DateFrom = new DateTime(DateTime.Now.Year, 1, 1) }; return(View(model)); }
public IActionResult Index() { var model = new CaseDeactivationFilterVM() { DateFrom = new DateTime(DateTime.Now.Year, 1, 1) }; SetHelpFile(HelpFileValues.AnnulledCasesRegister); return(View(model)); }
public IQueryable <CaseDeactivationVM> Select(CaseDeactivationFilterVM filter) { return(repo.AllReadonly <CaseDeactivation>() .Include(x => x.Case) .ThenInclude(x => x.CourtGroup) .Include(x => x.Case) .ThenInclude(x => x.CaseCode) .Include(x => x.Case) .ThenInclude(x => x.CaseType) .Include(x => x.Case) .ThenInclude(x => x.Document) .Include(x => x.DeactivateUser) .ThenInclude(x => x.LawUnit) .Include(x => x.Court) .Where(x => x.CourtId == userContext.CourtId) .Where(x => (x.DeclaredDate ?? x.DateWrt) >= filter.DateFrom.OrMinDate()) .Where(x => (x.DeclaredDate ?? x.DateWrt) <= filter.DateTo.OrMaxDate()) .Where(x => EF.Functions.ILike(x.Case.RegNumber, filter.RegNumber.ToEndingPaternSearch())) .Where(x => x.Id == (filter.Id ?? x.Id)) .Where(FilterExpireInfo <CaseDeactivation>(false)) .Select(x => new CaseDeactivationVM { Id = x.Id, CaseId = x.CaseId, CaseNumber = x.Case.RegNumber, CaseDate = x.Case.RegDate, CourtName = x.Court.Label, CourtGroupName = (x.Case.CourtGroup != null) ? x.Case.CourtGroup.Label : "", CaseTypeName = x.Case.CaseType.Label, CaseCodeName = x.Case.CaseCode.Label, DocumentNumber = $"{x.Case.Document.DocumentNumber}/{x.Case.Document.DocumentDate:dd.MM.yyyy}", DeclaredDate = x.DeclaredDate, Description = x.Description, DateWrt = x.DateWrt, DeactivateUserName = x.DeactivateUser.LawUnit.FullName, DeactivateUserUIC = x.DeactivateUser.LawUnit.Uic }).AsQueryable()); }
public IActionResult ListData(IDataTablesRequest request, CaseDeactivationFilterVM filter) { var data = service.Select(filter); return(request.GetResponse(data)); }