public IActionResult IndexCase(int caseId)
{
if (!CheckAccess(service, SourceTypeSelectVM.CaseDeadLine, null, AuditConstants.Operations.View, caseId))
{
return(Redirect_Denied());
}
CaseDeadLineFilterVM model = new CaseDeadLineFilterVM();
// model.DateEndTo = DateTime.Now; да се виждат и бъдещите срокове
model.CaseId = caseId;
ViewBag.breadcrumbs = commonService.Breadcrumbs_GetForCase(caseId);
SetViewBag();
SetHelpFile(HelpFileValues.CaseDeadline);
return(View(nameof(Index), model));
}
public IActionResult Index(string filterJson)
{
CaseDeadLineFilterVM model = null;
if (!string.IsNullOrEmpty(filterJson))
{
var dateTimeConverter = new IsoDateTimeConverter()
{
DateTimeFormat = FormattingConstant.NormalDateFormat
};
model = JsonConvert.DeserializeObject <CaseDeadLineFilterVM>(filterJson, dateTimeConverter);
}
else
{
model = new CaseDeadLineFilterVM();
model.DateEndTo = DateTime.Now;
}
ViewBag.breadcrumbs = commonService.Breadcrumbs_CaseDeadLine().DeleteOrDisableLast();
SetViewBag();
return(View(model));
}
public IQueryable <CaseDeadLineVM> CaseDeadLineSelect(CaseDeadLineFilterVM filter)
{
var users = repo.AllReadonly <CaseSessionMeetingUser>()
.Include(x => x.SecretaryUser)
.ThenInclude(x => x.LawUnit);
var deadlines = repo.AllReadonly <CaseDeadline>()
.Where(x => x.CourtId == userContext.CourtId)
.Where(x => x.DateExpired == null)
.Where(x => x.DateComplete == null);
if (filter.DateStartFrom != null)
{
deadlines = deadlines.Where(x => x.StartDate >= filter.DateStartFrom.Value.Date);
}
if (filter.DateStartTo != null)
{
deadlines = deadlines.Where(x => x.StartDate.Date <= filter.DateEndTo);
}
if (filter.DateEndFrom != null)
{
deadlines = deadlines.Where(x => x.EndDate >= filter.DateEndFrom.Value.Date);
}
if (filter.DateEndTo != null)
{
deadlines = deadlines.Where(x => x.EndDate.Date <= filter.DateEndTo);
}
if (filter.CaseId > 0)
{
deadlines = deadlines.Where(x => x.CaseId == filter.CaseId);
}
if (filter.CaseGroupId > 0)
{
deadlines = deadlines.Where(x => x.Case.CaseGroupId == filter.CaseGroupId);
}
if (filter.LawUnitId > 0)
{
deadlines = deadlines.Where(x => x.Case.CaseLawUnits.Any(l => l.LawUnitId == filter.LawUnitId && l.CaseSessionId == null && l.DateTo == null && l.JudgeRoleId == NomenclatureConstants.JudgeRole.JudgeReporter));
}
if (!string.IsNullOrEmpty(filter.RegNumber))
{
deadlines = deadlines.Where(x => x.Case.RegNumber.EndsWith(filter.RegNumber));
}
if (filter.DeadlineTypeId > 0)
{
deadlines = deadlines.Where(x => x.DeadlineTypeId == filter.DeadlineTypeId);
}
return(deadlines.Select(x => new CaseDeadLineVM()
{
Id = x.Id,
CaseId = x.CaseId,
CaseInfo = x.Case.RegNumber + "/" + x.Case.RegDate.ToString(FormattingConstant.NormalDateFormat) + " " + (x.Case.CaseType.Code ?? ""),
LawUnitName = string.Join("<br>", x.Case.CaseLawUnits.Where(l => l.CaseSessionId == null && l.DateTo == null && l.JudgeRoleId == NomenclatureConstants.JudgeRole.JudgeReporter).Select(n => n.LawUnit != null ? n.LawUnit.FullName : "")),
SecretaryName = x.DeadlineTypeId != NomenclatureConstants.DeadlineType.OpenSessionResult ? "" :
string.Join("<br>", users.Where(u => u.CaseSessionMeeting.CaseSessionId == x.SourceId).Select(s => s.SecretaryUser.LawUnit.FullName)),
DeadlineGroup = x.DeadlineGroup.Label,
DeadlineType = x.DeadlineType.Label,
EndDate = x.EndDate,
StartDate = x.StartDate,
DateComplete = x.DateComplete,
SourceUrl = GetTaskObjectUrl(x.SourceType, x.SourceId)
}));
}
public IActionResult ListData(IDataTablesRequest request, CaseDeadLineFilterVM filterData)
{
var data = service.CaseDeadLineSelect(filterData);
return(request.GetResponse(data));
}
