public string GetJudgeUserId(int caseId) { var caseLawUnitsActive = caseLawUnitService.CaseLawUnit_Select(caseId, null).ToList(); var judgeRep = caseLawUnitsActive.Where(x => x.JudgeRoleId == NomenclatureConstants.JudgeRole.JudgeReporter).FirstOrDefault(); if (judgeRep == null) { return(null); } return(GetUserIdByLawUnitId(judgeRep.LawUnitId)); }
/// <summary> /// Добавяне на Натовареност по дела: основни и допълнителни дейности /// </summary> /// <param name="caseId"></param> /// <param name="isMainActivity"></param> /// <returns></returns> public IActionResult Add(int caseId, int?CaseSessionId, bool isMainActivity, bool isFromCase) { if (!CheckAccess(service, SourceTypeSelectVM.CaseLoadIndex, null, AuditConstants.Operations.Append, caseId)) { return(Redirect_Denied()); } var caseLawUnit = caseLawUnitService.CaseLawUnit_Select(caseId, null).Where(x => x.JudgeRoleId == NomenclatureConstants.JudgeRole.JudgeReporter).FirstOrDefault(); var judgeReporterId = (caseLawUnit != null) ? caseLawUnit.LawUnitId : 0; var model = new CaseLoadIndex() { CaseId = caseId, CaseSessionId = CaseSessionId, CourtId = userContext.CourtId, IsMainActivity = isMainActivity, DateActivity = DateTime.Now, LawUnitId = judgeReporterId, DescriptionExpired = isFromCase ? "Case" : null }; SetViewbag(caseId, CaseSessionId, isMainActivity, isFromCase); return(View(nameof(Edit), model)); }
public IActionResult ListData(IDataTablesRequest request, int caseId, int?caseSessionId) { var data = service.CaseLawUnit_Select(caseId, caseSessionId); return(request.GetResponse(data)); }
/// <summary> /// Проверка за съдия-докладчик към дело дали съществува /// </summary> /// <param name="caseId"></param> /// <returns></returns> private bool IsExistJudge(int caseId) { return(lawUnitService.CaseLawUnit_Select(caseId, null).Any(x => x.JudgeRoleId == NomenclatureConstants.JudgeRole.JudgeReporter)); }
/// <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()); }