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