public IActionResult IndexSpr()
{
var model = new CourtLawUnitFilter()
{
DateFrom = NomenclatureExtensions.GetStartYear(),
DateTo = NomenclatureExtensions.GetEndYear(),
};
return(View(model));
}
/// <summary>
/// Справка Oбразувани и свършени дела за коруп. престъпления
/// </summary>
/// <returns></returns>
public IActionResult IndexCaseCorruptCrimes()
{
CaseFilterReport filter = new CaseFilterReport()
{
DateFrom = NomenclatureExtensions.GetStartYear(),
DateTo = NomenclatureExtensions.GetEndYear(),
};
return(View(filter));
}
/// <summary>
/// Страница с Длъжностни лица
/// </summary>
/// <returns></returns>
public IActionResult IndexSpr()
{
ViewBag.PeriodTypeId_ddl = nomService.GetDropDownList <PeriodType>();
var model = new CourtLawUnitFilter()
{
DateFrom = NomenclatureExtensions.GetStartYear(),
DateTo = NomenclatureExtensions.GetEndYear(),
};
return(View(model));
}
/// <summary>
/// Книга за закрити заседания
/// </summary>
/// <returns></returns>
public IActionResult CaseSessionPrivateReport()
{
ViewBag.CaseGroupId_ddl = nomService.GetDropDownList <CaseGroup>();
ViewBag.DepartmentId_ddl = departmentService.Department_SelectDDL(userContext.CourtId, NomenclatureConstants.DepartmentType.Systav);
var model = new CaseSessionPrivateFilterReportVM();
model.DateFrom = NomenclatureExtensions.ForceStartDate(new DateTime(DateTime.Now.Year, 1, 1));
model.DateTo = NomenclatureExtensions.ForceEndDate(DateTime.Now);
return(View(model));
}
/// <summary>
/// Справка Дела с ненаписани съдебни актове от всички съдии
/// </summary>
/// <returns></returns>
public IActionResult IndexCaseWithoutFinalAct()
{
CaseFilterReport filter = new CaseFilterReport()
{
DateFrom = NomenclatureExtensions.GetStartYear(),
DateTo = NomenclatureExtensions.GetEndYear(),
};
SetViewbagIndex();
return(View(filter));
}
/// <summary>
/// Справка за предоставени/върнати документи
/// </summary>
/// <returns></returns>
public IActionResult IndexDocumentProvidedReturned()
{
CaseFilterReport filter = new CaseFilterReport()
{
DateFrom = NomenclatureExtensions.GetStartYear(),
DateTo = NomenclatureExtensions.GetEndYear(),
};
ViewBag.CaseGroupId_ddl = nomService.GetDropDownList <CaseGroup>();
ViewBag.DocumentGroupId_ddl = nomService.GetDropDownList <DocumentGroup>();
return(View(filter));
}
/// <summary>
/// Справка Заседания с не написани съдебни актове към [дата] от всички съдии
/// </summary>
/// <returns></returns>
public IActionResult IndexCaseSessionWithActProject()
{
CaseFilterReport filter = new CaseFilterReport()
{
DateFrom = NomenclatureExtensions.GetStartYear(),
DateTo = NomenclatureExtensions.GetEndYear(),
ActDateToSpr = DateTime.Now
};
ViewBag.CaseGroupId_ddl = nomService.GetDropDownList <CaseGroup>();
return(View(filter));
}
/// <summary>
/// Справка за Заседания за период с участието на малолетни/непълнолетни лица
/// </summary>
/// <returns></returns>
public IActionResult IndexReportMaturity()
{
ViewBag.CaseGroupId_ddl = nomService.GetDropDownList <CaseGroup>();
ViewBag.SessionTypeId_ddl = nomService.GetDropDownList <SessionType>();
CaseFilterReport filter = new CaseFilterReport()
{
DateFrom = NomenclatureExtensions.GetStartYear(),
DateTo = NomenclatureExtensions.GetEndYear(),
};
return(View(filter));
}
public IActionResult IndexSpr()
{
ViewBag.CaseGroupId_ddl = nomService.GetDropDownList <CaseGroup>();
ViewBag.ActResultId_ddl = nomService.GetDDL_ActResult();
ViewBag.ActComplainIndexId_ddl = nomService.GetDDL_ActComplainIndexByCourtType();
var filter = new CaseSessionActComplainFilterVM()
{
DateFrom = NomenclatureExtensions.GetStartYear(),
DateTo = NomenclatureExtensions.GetEndYear(),
};
return(View(filter));
}
/// <summary>
/// Справка за срочност за насрочване на дела
/// </summary>
/// <returns></returns>
public IActionResult IndexCaseBeginReport()
{
CaseFilterReport filter = new CaseFilterReport()
{
DateFrom = NomenclatureExtensions.GetStartYear(),
DateTo = NomenclatureExtensions.GetEndYear(),
};
ViewBag.CaseGroupId_ddl = nomService.GetDropDownList <CaseGroup>();
ViewBag.SessionTypeId_ddl = nomService.GetDDL_SessionTypeWithoutClosedSession();
ViewBag.SessionDateToId_ddl = nomService.GetDDL_SessionToDate();
return(View(filter));
}
/// <summary>
/// Справка за Образувани дела с участието на малолетни/непълнолетни лица
/// </summary>
/// <returns></returns>
public IActionResult IndexReportMaturity()
{
CaseFilterReport filter = new CaseFilterReport()
{
DateFrom = NomenclatureExtensions.GetStartYear(),
DateTo = NomenclatureExtensions.GetEndYear(),
};
SetViewbagIndex();
SetHelpFile(HelpFileValues.Report3);
return(View(filter));
}
/// <summary>
/// Справка Справка Несвършени дела към дата
/// </summary>
/// <returns></returns>
public IActionResult IndexCaseWithoutFinal()
{
CaseFilterReport filter = new CaseFilterReport()
{
DateFrom = NomenclatureExtensions.GetStartYear(),
DateTo = NomenclatureExtensions.GetEndYear(),
DateToSpr = DateTime.Now
};
SetViewbagIndex();
SetHelpFile(HelpFileValues.Report1);
return(View(filter));
}
/// <summary>
/// Справка за времетраене на размяната на книжата (двойна размяна)
/// </summary>
/// <returns></returns>
public IActionResult IndexCaseFirstLifecyclieDoubleExchange()
{
CaseFilterReport filter = new CaseFilterReport()
{
DateFrom = NomenclatureExtensions.GetStartYear(),
DateTo = NomenclatureExtensions.GetEndYear(),
Session_DateFrom = NomenclatureExtensions.GetStartYear(),
SessionDateTo = NomenclatureExtensions.GetEndYear(),
};
ViewBag.CaseGroupId_ddl = nomService.GetDropDownList <CaseGroup>().Where(x => x.Value != NomenclatureConstants.CaseGroups.NakazatelnoDelo.ToString()).ToList();
ViewBag.ProcessPriorityId_ddl = nomService.GetDropDownList <ProcessPriority>();
return(View(filter));
}
/// <summary>
/// Справка за заетост на зали по заседание/сесии
/// </summary>
/// <param name="HallId"></param>
/// <returns></returns>
public IActionResult CaseSessionHallUseSpr(int HallId)
{
ViewBag.CourtHallId_ddl = commonService.GetDropDownList_CourtHall(userContext.CourtId);
var model = new CaseSessionHallUseFilterVM();
model.DateFrom = NomenclatureExtensions.ForceStartDate(new DateTime(DateTime.Now.Year, DateTime.Now.Month, 1, DateTime.Now.Hour, DateTime.Now.Minute, DateTime.Now.Second));
model.DateTo = NomenclatureExtensions.ForceEndDate((model.DateFrom ?? DateTime.Now).AddDays(30));
model.IsCalendar = false;
if (HallId > 0)
{
model.CourtHallId = HallId;
}
SetHelpFile(HelpFileValues.HallOcupancy);
return(View(model));
}
/// <summary>
/// Справка за срочност за изготвяне на съдебен акт
/// </summary>
/// <returns></returns>
public IActionResult IndexCaseActReport()
{
CaseFilterReport filter = new CaseFilterReport()
{
DateFrom = NomenclatureExtensions.GetStartYear(),
DateTo = NomenclatureExtensions.GetEndYear(),
Session_DateFrom = NomenclatureExtensions.GetStartYear(),
SessionDateTo = NomenclatureExtensions.GetEndYear(),
ActDateFrom = NomenclatureExtensions.GetStartYear(),
ActDateTo = NomenclatureExtensions.GetEndYear(),
};
ViewBag.CaseGroupId_ddl = nomService.GetDropDownList <CaseGroup>();
ViewBag.SessionTypeId_ddl = nomService.GetDropDownList <SessionType>();
ViewBag.SessionResultId_ddl = nomService.GetDropDownList <SessionResult>();
ViewBag.ActDateToId_ddl = nomService.GetDDL_ActToDate();
SetHelpFile(HelpFileValues.Report22);
return(View(filter));
}
public IActionResult ListDataSpr(IDataTablesRequest request, DateTime?DateFrom, DateTime?DateTo, DateTime?DateFromActReturn, DateTime?DateToActReturn, DateTime?DateFromSendDocument, DateTime?DateToSendDocument, int CaseGroupId, int CaseTypeId, string CaseRegNumber, string ActRegNumber, int RegNumFrom, int RegNumTo, int ActComplainIndexId, int ActResultId, int JudgeReporterId)
{
var data = service.CaseSessionActComplainSpr_Select(DateFrom ?? NomenclatureExtensions.GetStartYear(), DateTo ?? NomenclatureExtensions.GetEndYear(), DateFromActReturn, DateToActReturn, DateFromSendDocument, DateToSendDocument, CaseGroupId, CaseTypeId, CaseRegNumber ?? string.Empty, ActRegNumber ?? string.Empty, RegNumFrom, RegNumTo, ActComplainIndexId, ActResultId, JudgeReporterId);
return(request.GetResponse(data));
}
public IActionResult ListDataSpr(IDataTablesRequest request, int LawUnitId, int PeriodTypeId, DateTime?DateFrom, DateTime?DateTo)
{
var data = service.CourtLawUnitSpr_Select(LawUnitId, PeriodTypeId, DateFrom ?? NomenclatureExtensions.GetStartYear(), DateTo ?? NomenclatureExtensions.GetEndYear());
return(request.GetResponse(data));
}
/// <summary>
/// Извличане на данни за справка за обжалване
/// </summary>
/// <param name="DateFrom"></param>
/// <param name="DateTo"></param>
/// <param name="DateFromActReturn"></param>
/// <param name="DateToActReturn"></param>
/// <param name="DateFromSendDocument"></param>
/// <param name="DateToSendDocument"></param>
/// <param name="CaseGroupId"></param>
/// <param name="CaseTypeId"></param>
/// <param name="CaseRegNumber"></param>
/// <param name="ActRegNumber"></param>
/// <param name="CaseRegNumFrom"></param>
/// <param name="CaseRegNumTo"></param>
/// <param name="ActComplainIndexId"></param>
/// <param name="ActResultId"></param>
/// <param name="JudgeReporterId"></param>
/// <returns></returns>
public IQueryable <CaseSessionActComplainSprVM> CaseSessionActComplainSpr_Select(DateTime DateFrom, DateTime DateTo, DateTime?DateFromActReturn, DateTime?DateToActReturn, DateTime?DateFromSendDocument, DateTime?DateToSendDocument, int CaseGroupId, int CaseTypeId, string CaseRegNumber, string ActRegNumber, int CaseRegNumFrom, int CaseRegNumTo, int ActComplainIndexId, int ActResultId, int JudgeReporterId)
{
DateFrom = NomenclatureExtensions.ForceStartDate(DateFrom);
DateTo = NomenclatureExtensions.ForceEndDate(DateTo);
DateFromActReturn = NomenclatureExtensions.ForceStartDate(DateFromActReturn);
DateToActReturn = NomenclatureExtensions.ForceEndDate(DateToActReturn);
DateFromSendDocument = NomenclatureExtensions.ForceStartDate(DateFromSendDocument);
DateToSendDocument = NomenclatureExtensions.ForceEndDate(DateToSendDocument);
var caseSessionActComplains = repo.AllReadonly <CaseSessionActComplain>()
.Include(x => x.Case)
.ThenInclude(x => x.CaseGroup)
.Include(x => x.Case)
.ThenInclude(x => x.CaseType)
.Include(x => x.Case)
.ThenInclude(x => x.CaseCode)
.Include(x => x.ComplainDocument)
.ThenInclude(x => x.DocumentType)
.Include(x => x.ComplainState)
.Include(x => x.CaseSessionAct)
.ThenInclude(x => x.ActComplainIndex)
.Include(x => x.CaseSessionAct)
.ThenInclude(x => x.CaseSession)
.ThenInclude(x => x.CaseLawUnits)
.Where(x => (x.CourtId == userContext.CourtId) &&
(x.DateExpired == null) &&
(x.ComplainDocument.DocumentDate >= DateFrom && x.ComplainDocument.DocumentDate <= DateTo) &&
((DateFromActReturn != null && DateToActReturn != null) ? x.CaseSessionAct.ActReturnDate >= DateFromActReturn && x.CaseSessionAct.ActReturnDate <= DateToActReturn : true) &&
((DateFromSendDocument != null && DateToSendDocument != null) ? (repo.AllReadonly <CaseMigration>().Any(m => m.CaseId == x.CaseId &&
m.CaseSessionActId == x.CaseSessionActId &&
m.CaseMigrationTypeId == NomenclatureConstants.CaseMigrationTypes.SendNextLevel &&
(m.OutDocument.DocumentDate >= DateFromSendDocument && m.OutDocument.DocumentDate <= DateToSendDocument))) : true) &&
(CaseGroupId > 0 ? x.Case.CaseGroupId == CaseGroupId : true) &&
(CaseTypeId > 0 ? x.Case.CaseTypeId == CaseTypeId : true) &&
(CaseRegNumFrom > 0 ? x.Case.ShortNumberValue >= CaseRegNumFrom : true) &&
(CaseRegNumTo > 0 ? x.Case.ShortNumberValue <= CaseRegNumTo : true) &&
(ActComplainIndexId > 0 ? x.CaseSessionAct.ActComplainIndexId == ActComplainIndexId : true) &&
(ActResultId > 0 ? x.CaseSessionAct.ActResultId == ActResultId : true) &&
((JudgeReporterId > 0) ? (x.CaseSessionAct.CaseSession.CaseLawUnits.Where(a => (a.DateTo ?? DateTime.Now.AddYears(100)).Date >= x.CaseSessionAct.CaseSession.DateFrom && a.LawUnitId == JudgeReporterId &&
a.JudgeRoleId == NomenclatureConstants.JudgeRole.JudgeReporter).Any()) : true) &&
(!string.IsNullOrEmpty(CaseRegNumber) ? x.Case.RegNumber.ToLower().Contains(CaseRegNumber.ToLower()) : true) &&
(!string.IsNullOrEmpty(ActRegNumber) ? x.CaseSessionAct.RegNumber.ToLower().Contains(ActRegNumber.ToLower()) : true))
.Where(x => !x.Case.CaseDeactivations.Any(d => d.CaseId == x.CaseId && d.DateExpired == null))
.ToList();
var result = new List <CaseSessionActComplainSprVM>();
foreach (var caseSessionActComplain in caseSessionActComplains)
{
var migrationSend = repo.AllReadonly <CaseMigration>()
.Include(x => x.OutDocument)
.ThenInclude(x => x.DocumentType)
.Where(x => x.CaseId == caseSessionActComplain.CaseId &&
x.CaseSessionActId == caseSessionActComplain.CaseSessionActId &&
x.CaseMigrationTypeId == NomenclatureConstants.CaseMigrationTypes.SendNextLevel).FirstOrDefault();
CaseMigration migrationRecive = null;
if (migrationSend != null)
{
migrationRecive = repo.AllReadonly <CaseMigration>()
.Include(x => x.Case)
.ThenInclude(x => x.Court)
.Where(x => x.OutCaseMigrationId == migrationSend.Id)
.FirstOrDefault();
}
//var migration = repo.AllReadonly<CaseMigration>()
// .Where(x => x.CaseId == caseSessionActComplain.CaseId &&
// x.CaseMigrationTypeId == NomenclatureConstants.CaseMigrationTypes.AcceptCase_AfterComplain &&
// x.DateWrt >= caseSessionActComplain.ComplainDocument.DocumentDate).FirstOrDefault();
var complainResult = repo.AllReadonly <CaseSessionActComplainResult>()
.Include(x => x.ActResult)
.Include(x => x.ComplainCase)
.ThenInclude(x => x.Court)
.Where(x => x.CaseSessionActComplainId == caseSessionActComplain.Id).FirstOrDefault();
var caseLawUnitsActive = caseLawUnitService.CaseLawUnit_Select(caseSessionActComplain.CaseId ?? 0, null).ToList();
var judgeRep = caseLawUnitsActive.Where(x => x.JudgeRoleId == NomenclatureConstants.JudgeRole.JudgeReporter).FirstOrDefault();
var sessionActComplainVM = new CaseSessionActComplainSprVM()
{
Id = caseSessionActComplain.Id,
JudgeName = (judgeRep != null) ? judgeRep.LawUnitName + ((!string.IsNullOrEmpty(judgeRep.DepartmentLabel)) ? " състав: " + judgeRep.DepartmentLabel : string.Empty) : string.Empty,
//ComplainDocumentNumber = caseSessionActComplain.ComplainDocument.DocumentNumber,
//ComplainDocumentDate = caseSessionActComplain.ComplainDocument.DocumentDate,
//ComplainDocumentType = caseSessionActComplain.ComplainDocument.DocumentType.Label,
ComplainDocumentNumber = migrationSend != null ? (migrationSend.OutDocument != null ? migrationSend.OutDocument.DocumentNumber : string.Empty) : string.Empty,
ComplainDocumentDate = migrationSend != null ? (migrationSend.OutDocument != null ? (DateTime?)migrationSend.OutDocument.DocumentDate : null) : null,
ComplainDocumentType = migrationSend != null ? (migrationSend.OutDocument != null ? migrationSend.OutDocument.DocumentType.Label : string.Empty) : string.Empty,
ActName = caseSessionActComplain.CaseSessionAct.RegNumber + "/" + (caseSessionActComplain.CaseSessionAct.RegDate ?? DateTime.Now).ToString("dd.MM.yyyy"),
CaseGroupLabel = caseSessionActComplain.Case.CaseType.Label + " " + caseSessionActComplain.Case.CaseCode.Code,
CaseNumber = caseSessionActComplain.Case.RegNumber + "/" + caseSessionActComplain.Case.RegDate.Year + "г.",
CaseId = caseSessionActComplain.Case.Id,
DateReturn = caseSessionActComplain.CaseSessionAct.ActReturnDate, /*migration?.DateWrt,*/
Result = (complainResult != null) ? complainResult.ActResult.Label : string.Empty,
Instance = (migrationRecive != null) ? migrationRecive.Case.Court.Label : string.Empty,
IndexLabel = (caseSessionActComplain.CaseSessionAct.ActComplainIndex != null) ? caseSessionActComplain.CaseSessionAct.ActComplainIndex.Code + " - " + caseSessionActComplain.CaseSessionAct.ActComplainIndex.Label : string.Empty
};
result.Add(sessionActComplainVM);
}
return(result.AsQueryable());
}
