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