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));
}
