public void SessionTransfer(DWCourt court) { serviceErrorLog.LogError((court.CourtId ?? 0), court.CourtName, "SessionTransfer", 0, "Стартирал"); IEnumerable <DWCaseSession> dwcasesSessions = SelectCasesSessionForTransfer(DWConstants.DWTransfer.TransferRowCounts, court); bool insertRow = true; while (dwcasesSessions.Any() && insertRow) { List <int> updateList = new List <int>(); foreach (var current_session in dwcasesSessions) { insertRow = SessionInsertUpdate(current_session, court); if (insertRow) { updateList.Add(current_session.Id); } } dwRepo.SaveChanges(); UpdateCaseSession(updateList, dwcasesSessions); dwcasesSessions = SelectCasesSessionForTransfer(DWConstants.DWTransfer.TransferRowCounts, court); } }
public void CaseTransfer(DWCourt court) { serviceErrorLog.LogError((court.CourtId ?? 0), court.CourtName, "CaseTransfer", 0, "Стартирал"); IEnumerable <DWCase> dwcases = SelectCasesForTransfer(DWConstants.DWTransfer.TransferRowCounts, court); bool insertRow = true; while (dwcases.Any() && insertRow) { //using (TransactionScope ts = new TransactionScope()) foreach (var current_case in dwcases) { insertRow = CaseInsertUpdate(court, current_case); if (insertRow) { var updResult = repo.ExecuteProc <UpdateDateTransferedVM>($"{UpdateDateTransferedVM.ProcedureName}({current_case.CaseId},'{UpdateDateTransferedVM.Tables.Case}')"); //var main_case = repo.GetById<Case>(current_case.CaseId); //main_case.DateTransferedDW = DateTime.Now; //repo.Update<Case>(main_case); } } dwRepo.SaveChanges(); //repo.SaveChanges(); // ts.Complete(); //} dwcases = SelectCasesForTransfer(DWConstants.DWTransfer.TransferRowCounts, court); } }
public bool DocumentInsertUpdate(DWDocument current, DWCourt court) { bool result = false; try { DWDocument saved = dwRepo.All <DWDocument>().Where(x => x.Id == current.Id).FirstOrDefault(); if (saved == null) { current.DateTransferedDW = DateTime.Now; dwRepo.Add <DWDocument>(current); result = true; } else { saved.Id = current.Id; saved.ActualDocumentDate = current.ActualDocumentDate; saved.DeliveryGroupId = current.DeliveryGroupId; saved.DeliveryGroupName = current.DeliveryGroupName; saved.DeliveryTypeId = current.DeliveryTypeId; saved.DeliveryTypeName = current.DeliveryTypeName; saved.Description = current.Description; saved.DocumentDate = current.DocumentDate; saved.DocumentDirectionId = current.DocumentDirectionId; saved.DocumentDirectionName = current.DocumentDirectionName; saved.DocumentGroupId = current.DocumentGroupId; saved.DocumentGroupName = current.DocumentGroupName; saved.DocumentNumber = current.DocumentNumber; saved.DocumentNumberValue = current.DocumentNumberValue; saved.DocumentTypeId = current.DocumentTypeId; saved.DocumentTypeName = current.DocumentTypeName; saved.IsOldNumber = current.IsOldNumber; saved.IsRestictedAccess = current.IsRestictedAccess; saved.IsSecret = current.IsSecret; saved.DateTransferedDW = DateTime.Now; saved.DateWrt = current.DateWrt; saved.UserId = current.UserId; saved.UserName = current.UserName; saved.CourtId = current.CourtId; saved.DwCount = current.DwCount; saved.CourtName = current.CourtName; saved.CourtRegionId = current.CourtRegionId; saved.CourtRegionName = current.CourtRegionName; saved.CourtTypeId = current.CourtTypeId; saved.CourtTypeName = current.CourtTypeName; saved.ParentCourtId = current.ParentCourtId; saved.ParentCourtName = current.ParentCourtName; saved.EcliCode = current.EcliCode; saved.EISPPCode = current.EISPPCode; saved.CityCode = current.CityCode; saved.CityName = current.CityName; dwRepo.Update <DWDocument>(saved); result = true; } if (result) { DocumentCaseInfoTransfer(court, current.Id); DocumentPersonTransfer(court, current.Id); DocumentLinkTransfer(court, current.Id); DocumentInstitutionCaseInfoTransfer(court, current.Id); } } catch (Exception ex) { serviceErrorLog.LogError((court.CourtId ?? 0), court.CourtName, "document", current.Id, ex.Message); } return(result); }
public bool CaseSelectionProtocolInsertUpdate(DWCaseSelectionProtocol current, DWCourt court) { bool result = false; try { DWCaseSelectionProtocol saved = dwRepo.All<DWCaseSelectionProtocol>().Where(x => x.Id == current.Id).FirstOrDefault(); if (saved == null) { current.DateTransferedDW = DateTime.Now; dwRepo.Add<DWCaseSelectionProtocol>(current); result = true; } else { saved.Id = current.Id; saved.CaseId = current.CaseId; saved.CompartmentID = current.CompartmentID; saved.CompartmentName = current.CompartmentName; saved.CaseLawUnitDismisalId = current.CaseLawUnitDismisalId; saved.CourtDutyId = current.CourtDutyId; saved.CourtDutyName = current.CourtDutyName; saved.CourtGroupName = current.CourtGroupName; saved.SelectionDate = current.SelectionDate; saved.JudgeRoleId = current.JudgeRoleId; saved.JudgeRoleName = current.JudgeRoleName; saved.SelectionModeId = current.SelectionModeId; saved.SelectionModeName = current.SelectionModeName; saved.SpecialityId = current.SpecialityId; saved.SpecialityName = current.SpecialityName; saved.IncludeCompartmentJudges = current.IncludeCompartmentJudges; saved.Description = current.Description; saved.SelectedLawUnitId = current.SelectedLawUnitId; saved.SelectedLawUnitName = current.SelectedLawUnitName; saved.SelectionProtokolStateId = current.SelectionProtokolStateId; saved.SelectionProtokolStateName = current.SelectionProtokolStateName; saved.DateTransferedDW = DateTime.Now; saved.DateWrt = current.DateWrt; saved.UserId = current.UserId; saved.UserName = current.UserName; saved.CourtId = current.CourtId; saved.DwCount = current.DwCount; saved.CourtName = current.CourtName; saved.CourtRegionId = current.CourtRegionId; saved.CourtRegionName = current.CourtRegionName; saved.CourtTypeId = current.CourtTypeId; saved.CourtTypeName = current.CourtTypeName; saved.ParentCourtId = current.ParentCourtId; saved.ParentCourtName = current.ParentCourtName; saved.EcliCode = current.EcliCode; saved.EISPPCode = current.EISPPCode; saved.CityCode = current.CityCode; saved.CityName = current.CityName; dwRepo.Update<DWCaseSelectionProtocol>(saved); result = true; } } catch (Exception ex) { serviceErrorLog.LogError((current.CourtId ?? 0), current.CourtName, "case+selection_protocol", current.Id, ex.Message); } return result; }
public void MigrateAllForCourt(int?courtId) { Expression <Func <Court, bool> > selectedCourt = x => true; if ((courtId ?? 0) > 0) { selectedCourt = x => x.Id == courtId; } var courtList = repo.AllReadonly <Court>().Where(selectedCourt).Select(x => x.Id).ToArray(); foreach (var cId in courtList) { //На колко добавени елемента да прави нов контекст if (dwRepo.TrackerCount > 10000) { dwRepo.RefreshDbContext(config.GetConnectionString("DWConnection")); } DWCourt court = new DWCourt(); int errRow = 0; try { court = GetCourtData(cId); serviceErrorLog.LogError((court.CourtId ?? 0), court.CourtName, "НАЧАЛО НА СЪД", 1, "Стартирал"); errRow = 1; caseService.CaseTransfer(court); errRow = 2; caseService.CasePersonTransfer(court); errRow = 3; caseService.CaseLifecycleTransfer(court); errRow = 4; caseSessionService.SessionTransfer(court); errRow = 5; caseSessionActService.SessionActTransfer(court); errRow = 6; caseSessionActService.SessionActDivorceTransfer(court); errRow = 7; caseSessionActService.SessionActComplainTransfer(court); errRow = 8; caseSessionActService.SessionActComplainResultTransfer(court); errRow = 9; caseSessionActService.SessionActComplainPersonTransfer(court); errRow = 10; caseSessionActService.SessionActCoordinationTransfer(court); errRow = 11; documentService.DocumentTransfer(court); errRow = 12; documentService.DocumentDecisionTransfer(court); errRow = 13; caseSelectionProtocolService.CaseSelectionProtokolTransfer(court); errRow = 14; caseSelectionProtocolService.CaseSelectionProtocolCompartmentTransfer(court); errRow = 15; caseSelectionProtocolService.CaseSelectionProtocolLawunitTransfer(court); } catch (Exception ex) { serviceErrorLog.LogError((court.CourtId ?? 0), court.CourtName, "Грешка в MigrateCases", errRow, ex.Message); } } }