private void setArchLogData(PreviousArchStatVO vo, OracleConnection connection)
{
string sql = "SELECT TRUNC(ARCH_DATE),SOURCE_DOC_DB,TARGET_DOC_DB,TOTAL_DOCS,ARCHIVED,FAILED," +
"TO_CHAR(STARTTIME, 'HH12:MI:SS AM'), TO_CHAR(ENDTIME, 'HH12:MI:SS AM') FROM" +
" CCSOWNER.PWN_DOC_REG_ARCH_LOG ORDER BY STARTTIME DESC";
using (var oracleCommand = new OracleCommand(sql, connection))
{
log.Debug(string.Format("Executing: {0}", sql));
using (var reader = oracleCommand.ExecuteReader())
{
if (reader.RowSize > 0 && reader.HasRows)
{
DataTable dataTable = new DataTable("PAWNARCHLOG");
dataTable.Load(reader, LoadOption.OverwriteChanges);
vo.DataTableValue = dataTable;
}
if (reader != null)
{
reader.Dispose();
reader.Close();
}
}
}
}
public void BackgroundWorkerForGetDocsDoWork(object sender, DoWorkEventArgs e)
{
//prepateDataToDisplay();
BackgroundWorker worker = sender as BackgroundWorker;
job1 = new ThreadForDocListTree(worker, e);
oThread = new Thread(new ThreadStart(job1.run));
oThread.Name = "T1";
oThread.Start();
job2 = new ThreadForDocList(worker, e);
if (Properties.Settings.Default.TempFetch)
{
oThread1 = new Thread(new ThreadStart(job2.testRun));
}
else
{
oThread1 = new Thread(new ThreadStart(job2.run));
}
oThread1.Name = "T2";
oThread1.Start();
while (oThread.IsAlive || oThread1.IsAlive)
{
if (worker.CancellationPending)
{
e.Cancel = true;
break;
}
//log.Debug(string.Format("Waiting on threads Thread1:{0} Thread2:{1} ", oThread.IsAlive, oThread1.IsAlive));
}
log.Info("Threads completed...");
prevVO = job1.getPreviousArchData();
totalDoc = job2.getTotalRecords();
dataList = job2.getResultData();
resultTable = CouchConsoleApp.thread.ThreadForDocList.getDataTableFromVO(dataList);;
if (job1.isExecSuccess() && job2.isExecSuccess())
{
exeSuccess = true;
}
else
{
exeSuccess = false;
if (!job1.isExecSuccess())
{
errorMsg = job1.getError();
}
else
{
errorMsg = job2.getError();
}
}
}
public bool getPreviousRunStats(out PreviousArchStatVO vo)
{
vo = new PreviousArchStatVO();
var stopwatch = new Stopwatch();
stopwatch.Start();
try
{
if (DBConnector.getInstance().getStatus() != DBConnector.Status.INITIALIZED)
{
log.Error("DB Connection not established: Search aborted");
return(false);
}
using (var connection = new OracleConnection())
{
connection.ConnectionString = DBConnector.getInstance().databaseServiceName();
connection.Open();
string countSql = "SELECT COUNT(*) CNT FROM CCSOWNER.PWN_DOC_REG_ARCH_STAT STAT WHERE STATUS='Y'";
vo.SucessCount = executeCountQuery(countSql, connection);
countSql = "SELECT COUNT(*) CNT FROM CCSOWNER.PWN_DOC_REG_ARCH_STAT STAT WHERE STATUS='G'";
vo.GetErrorCount = executeCountQuery(countSql, connection);
countSql = "SELECT COUNT(*) CNT FROM CCSOWNER.PWN_DOC_REG_ARCH_STAT STAT WHERE STATUS='A'";
vo.AddErrorCount = executeCountQuery(countSql, connection);
countSql = "SELECT COUNT(*) CNT FROM CCSOWNER.PWN_DOC_REG_ARCH_STAT STAT WHERE STATUS='D'";
vo.DelErrorCount = executeCountQuery(countSql, connection);
setArchLogData(vo, connection);
return(true);
}
}
catch (Exception e)
{
log.Error("Getting previoud archival statistics failed", e);
}finally
{
stopwatch.Stop();
log.Debug(string.Format("Time Taken for getPreviousRunStats : {0} Msec", stopwatch.Elapsed));
/*if (var reader != null)
* {
* reader.Dispose();
* reader.Close();
* }
* if(connection != null)
* {
* connection.Close();
* connection = null;
* }*/
}
return(false);
}
public ListDocsForm(Form1 mainForm, DataTable table, PreviousArchStatVO prevVO, int totalDocs, List <PawnDocRegVO> dataList)
{
InitializeComponent();
resultTable = table;
//this.srcListTree = srcListTreeList;
this.mainForm = mainForm;
this.eventHnadler = new ListDocsFormEvents(mainForm, this);
//this.srcListForTargetTree = srcListForTargetTree;
this.prevVO = prevVO;
FormClosing += this.eventHnadler.ListDocForm_FormClosing;
if (table != null)
{
setDataTable();
}
//setSourceTrees();
setPrevStat();
this.totalDoc = totalDocs;
this.dataList = dataList;
this.totalRecLbL.Text = totalDoc.ToString();
this.backgroundWorker1.ProgressChanged += eventHnadler.BackgroundWorkerForGetDocsProgressChanged;
this.backgroundWorker1.DoWork += eventHnadler.BackgroundWorkerForGetDocsDoWork;
this.backgroundWorker1.RunWorkerCompleted += eventHnadler.BgWork_GetDocs_Completed;
this.mainForm.constrollSet1Disable();
}
