public void CaseSelectionProtokolTransfer(DWCourt court)
{
IEnumerable <DWCaseSelectionProtocol> dwSelectCaseSelectionProtokol = SelectCaseSelectionProtokol(DWConstants.DWTransfer.TransferRowCounts, court);
while (dwSelectCaseSelectionProtokol.Any())
{
foreach (var current in dwSelectCaseSelectionProtokol)
{
bool insertRow = CaseSelectionProtocolInsertUpdate(current, court);
if (insertRow)
{
var main = repo.GetById <CaseSelectionProtokol>(current.Id);
main.DateTransferedDW = DateTime.Now;
repo.Update <CaseSelectionProtokol>(main);
}
}
dwRepo.SaveChanges();
repo.SaveChanges();
// ts.Complete();
//}
dwSelectCaseSelectionProtokol = SelectCaseSelectionProtokol(DWConstants.DWTransfer.TransferRowCounts, court);
}
}
public void DocumentTransfer(DWCourt court)
{
serviceErrorLog.LogError((court.CourtId ?? 0), court.CourtName, "DocumentTransfer", 0, "Стартирал");
IEnumerable <DWDocument> dwDocuments = SelectDocumentTransfer(DWConstants.DWTransfer.TransferRowCounts, court);
bool insertRow = true;
while (dwDocuments.Any() && insertRow)
{
foreach (var current in dwDocuments)
{
insertRow = DocumentInsertUpdate(current, court);
if (insertRow)
{
var updResult = repo.ExecuteProc <UpdateDateTransferedVM>($"{UpdateDateTransferedVM.ProcedureName}({current.Id},'{UpdateDateTransferedVM.Tables.Document}')");
//var main = repo.GetById<Document>(current.Id);
//main.DateTransferedDW = DateTime.Now;
//repo.Update<Document>(main);
}
}
dwRepo.SaveChanges();
// repo.SaveChanges();
// ts.Complete();
//}
dwDocuments = SelectDocumentTransfer(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 void DocumentTransfer(DWCourt court)
{
IEnumerable <DWDocument> dwDocuments = SelectDocumentTransfer(DWConstants.DWTransfer.TransferRowCounts, court);
while (dwDocuments.Any())
{
foreach (var current in dwDocuments)
{
bool insertRow = DocumentInsertUpdate(current, court);
if (insertRow)
{
var main = repo.GetById <Document>(current.Id);
main.DateTransferedDW = DateTime.Now;
repo.Update <Document>(main);
}
}
dwRepo.SaveChanges();
repo.SaveChanges();
// ts.Complete();
//}
dwDocuments = SelectDocumentTransfer(DWConstants.DWTransfer.TransferRowCounts, court);
}
}
public void CaseTransfer(DWCourt court)
{
IEnumerable <DWCase> dwcases = SelectCasesForTransfer(DWConstants.DWTransfer.TransferRowCounts, court);
while (dwcases.Any())
{
//using (TransactionScope ts = new TransactionScope())
foreach (var current_case in dwcases)
{
bool insertRow = CaseInsertUpdate(court, current_case);
if (insertRow)
{
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 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 bool LogError(int court_id, string court_name, string table_name, Int64 table_id, string e_msg)
{
bool result = false;
try
{
DWErrorLog err = new DWErrorLog();
err.CourtId = court_id;
err.CourtName = court_name;
err.TableName = table_name;
err.TableId = table_id;
err.ErrorMessage = e_msg;
err.ErrorDate = DateTime.Now;
dwRepo.Add <DWErrorLog>(err);
dwRepo.SaveChanges();
}
catch (Exception ex)
{
}
return(result);
}
public void SessionTransfer(DWCourt court)
{
IEnumerable <DWCaseSession> dwcasesSessions = SelectCasesSessionForTransfer(DWConstants.DWTransfer.TransferRowCounts, court);
while (dwcasesSessions.Any())
{
List <int> updateList = new List <int>();
foreach (var current_session in dwcasesSessions)
{
bool insertRow = SessionInsertUpdate(current_session, court);
if (insertRow)
{
updateList.Add(current_session.Id);
}
}
dwRepo.SaveChanges();
UpdateCaseSession(updateList, dwcasesSessions);
dwcasesSessions = SelectCasesSessionForTransfer(DWConstants.DWTransfer.TransferRowCounts, court);
}
}