public static void LogFileMove(string srcFilename, string destFilename)
{
//Log the file move transaction to database
Mediator mediator = null;
try {
//
mediator = new SQLMediator();
mediator.ExecuteNonQuery(USP_MOVENEW, new object[] { srcFilename, destFilename });
}
catch (Exception ex) { throw ex; }
}
private ArgixLogDS getLogEvents(DateTime startDate, DateTime endDate)
{
//Read log events
ArgixLogDS logDS = null;
try {
logDS = new ArgixLogDS();
Mediator mediator = new SQLMediator(this.mTraceSQLConnection);
DataSet ds = mediator.FillDataset(App.USP_LOGGET, App.TBL_LOGGET, new object[] { startDate.ToString("yyyy-MM-dd HH:mm:ss"), endDate.ToString("yyyy-MM-dd HH:mm:ss") });
if (ds != null)
{
logDS.Merge(ds);
}
}
catch (Exception ex) { throw new ApplicationException("Unexpected error while reading log events.", ex); }
return(logDS);
}
private void refreshStatistics(DateTime startDate, DateTime endDate)
{
//Read log events
try {
Mediator mediator = new SQLMediator(this.mStation.TraceSQLConnection);
DataSet ds = null;
ds = mediator.FillDataset(App.USP_PANDA_DATAREQ, App.TBL_DATAREQ, new object[] { startDate.ToString("yyyy-MM-dd HH:mm:ss"), endDate.ToString("yyyy-MM-dd HH:mm:ss") });
if (ds != null)
{
this.lblLDReq.Text = ds.Tables[App.TBL_DATAREQ].Rows.Count.ToString().PadLeft(5, ' ');
}
ds = mediator.FillDataset(App.USP_PANDA_DATARES, App.TBL_DATARES, new object[] { startDate.ToString("yyyy-MM-dd HH:mm:ss"), endDate.ToString("yyyy-MM-dd HH:mm:ss"), null });
if (ds != null)
{
this.lblLDRes.Text = ds.Tables[App.TBL_DATARES].Rows.Count.ToString().PadLeft(5, ' ');
}
ds = mediator.FillDataset(App.USP_PANDA_DATARES, App.TBL_DATARES, new object[] { startDate.ToString("yyyy-MM-dd HH:mm:ss"), endDate.ToString("yyyy-MM-dd HH:mm:ss"), "1" });
if (ds != null)
{
this.lblLDRes01.Text = ds.Tables[App.TBL_DATARES].Rows.Count.ToString().PadLeft(5, ' ');
}
ds = mediator.FillDataset(App.USP_PANDA_DATARES, App.TBL_DATARES, new object[] { startDate.ToString("yyyy-MM-dd HH:mm:ss"), endDate.ToString("yyyy-MM-dd HH:mm:ss"), "2" });
if (ds != null)
{
this.lblLDRes02.Text = ds.Tables[App.TBL_DATARES].Rows.Count.ToString().PadLeft(5, ' ');
}
ds = mediator.FillDataset(App.USP_PANDA_DATARES, App.TBL_DATARES, new object[] { startDate.ToString("yyyy-MM-dd HH:mm:ss"), endDate.ToString("yyyy-MM-dd HH:mm:ss"), "3" });
if (ds != null)
{
this.lblLDRes03.Text = ds.Tables[App.TBL_DATARES].Rows.Count.ToString().PadLeft(5, ' ');
}
ds = mediator.FillDataset(App.USP_PANDA_DATARES, App.TBL_DATARES, new object[] { startDate.ToString("yyyy-MM-dd HH:mm:ss"), endDate.ToString("yyyy-MM-dd HH:mm:ss"), "4" });
if (ds != null)
{
this.lblLDRes04.Text = ds.Tables[App.TBL_DATARES].Rows.Count.ToString().PadLeft(5, ' ');
}
ds = mediator.FillDataset(App.USP_PANDA_DATARES, App.TBL_DATARES, new object[] { startDate.ToString("yyyy-MM-dd HH:mm:ss"), endDate.ToString("yyyy-MM-dd HH:mm:ss"), "5" });
if (ds != null)
{
this.lblLDRes05.Text = ds.Tables[App.TBL_DATARES].Rows.Count.ToString().PadLeft(5, ' ');
}
ds = mediator.FillDataset(App.USP_PANDA_DATARES, App.TBL_DATARES, new object[] { startDate.ToString("yyyy-MM-dd HH:mm:ss"), endDate.ToString("yyyy-MM-dd HH:mm:ss"), "6" });
if (ds != null)
{
this.lblLDRes06.Text = ds.Tables[App.TBL_DATARES].Rows.Count.ToString().PadLeft(5, ' ');
}
ds = mediator.FillDataset(App.USP_PANDA_DATARES, App.TBL_DATARES, new object[] { startDate.ToString("yyyy-MM-dd HH:mm:ss"), endDate.ToString("yyyy-MM-dd HH:mm:ss"), "7" });
if (ds != null)
{
this.lblLDRes07.Text = ds.Tables[App.TBL_DATARES].Rows.Count.ToString().PadLeft(5, ' ');
}
ds = mediator.FillDataset(App.USP_PANDA_DATARES, App.TBL_DATARES, new object[] { startDate.ToString("yyyy-MM-dd HH:mm:ss"), endDate.ToString("yyyy-MM-dd HH:mm:ss"), "8" });
if (ds != null)
{
this.lblLDRes08.Text = ds.Tables[App.TBL_DATARES].Rows.Count.ToString().PadLeft(5, ' ');
}
ds = mediator.FillDataset(App.USP_PANDA_DATARES, App.TBL_DATARES, new object[] { startDate.ToString("yyyy-MM-dd HH:mm:ss"), endDate.ToString("yyyy-MM-dd HH:mm:ss"), "9" });
if (ds != null)
{
this.lblLDRes09.Text = ds.Tables[App.TBL_DATARES].Rows.Count.ToString().PadLeft(5, ' ');
}
ds = mediator.FillDataset(App.USP_PANDA_VERIFYREQ, App.TBL_VERIFYREQ, new object[] { startDate.ToString("yyyy-MM-dd HH:mm:ss"), endDate.ToString("yyyy-MM-dd HH:mm:ss"), null });
if (ds != null)
{
this.lblVLReq.Text = ds.Tables[App.TBL_VERIFYREQ].Rows.Count.ToString().PadLeft(5, ' ');
}
ds = mediator.FillDataset(App.USP_PANDA_VERIFYREQ, App.TBL_VERIFYREQ, new object[] { startDate.ToString("yyyy-MM-dd HH:mm:ss"), endDate.ToString("yyyy-MM-dd HH:mm:ss"), "1" });
if (ds != null)
{
this.lblVLReq1.Text = ds.Tables[App.TBL_VERIFYREQ].Rows.Count.ToString().PadLeft(5, ' ');
}
ds = mediator.FillDataset(App.USP_PANDA_VERIFYREQ, App.TBL_VERIFYREQ, new object[] { startDate.ToString("yyyy-MM-dd HH:mm:ss"), endDate.ToString("yyyy-MM-dd HH:mm:ss"), "2" });
if (ds != null)
{
this.lblVLReq2.Text = ds.Tables[App.TBL_VERIFYREQ].Rows.Count.ToString().PadLeft(5, ' ');
}
ds = mediator.FillDataset(App.USP_PANDA_VERIFYREQ, App.TBL_VERIFYREQ, new object[] { startDate.ToString("yyyy-MM-dd HH:mm:ss"), endDate.ToString("yyyy-MM-dd HH:mm:ss"), "3" });
if (ds != null)
{
this.lblVLReq3.Text = ds.Tables[App.TBL_VERIFYREQ].Rows.Count.ToString().PadLeft(5, ' ');
}
ds = mediator.FillDataset(App.USP_PANDA_VERIFYRES, App.TBL_VERIFYRES, new object[] { startDate.ToString("yyyy-MM-dd HH:mm:ss"), endDate.ToString("yyyy-MM-dd HH:mm:ss"), null });
if (ds != null)
{
this.lblVLRes.Text = ds.Tables[App.TBL_VERIFYRES].Rows.Count.ToString().PadLeft(5, ' ');
}
ds = mediator.FillDataset(App.USP_PANDA_VERIFYRES, App.TBL_VERIFYRES, new object[] { startDate.ToString("yyyy-MM-dd HH:mm:ss"), endDate.ToString("yyyy-MM-dd HH:mm:ss"), "N" });
if (ds != null)
{
this.lblVLResN.Text = ds.Tables[App.TBL_VERIFYRES].Rows.Count.ToString().PadLeft(5, ' ');
}
ds = mediator.FillDataset(App.USP_PANDA_VERIFYRES, App.TBL_VERIFYRES, new object[] { startDate.ToString("yyyy-MM-dd HH:mm:ss"), endDate.ToString("yyyy-MM-dd HH:mm:ss"), "Y" });
if (ds != null)
{
this.lblVLResY.Text = ds.Tables[App.TBL_VERIFYRES].Rows.Count.ToString().PadLeft(5, ' ');
}
}
catch (Exception ex) { throw new ApplicationException("Unexpected error while refreshing statistics.", ex); }
}
