public void TestDBConnection() { string sqlTEST = "select * from GMI_TRANS"; string OraConnectionString = "(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=DTCP-GMIGDBC01)(PORT=1521))(CONNECT_DATA=(SID=GMIDPROD)))"; DBConnectAndRunSQL handler = new DBConnectAndRunSQL(); // As a list of strings List <string> listSQLResults = handler.GetResultsAsList(handler.GetResultsAsReader(sqlTEST, handler.OpenConnection(OraConnectionString))); // Get the properties of the connection for the log and to close it. DBConnectLog DBLog = handler.DBLog; if (!DBLog.Successful) { Status.Print(true, true, "DBConnection", DBLog.LogError); } else { // Close the connection handler.CloseConnection(DBLog.connection); Status.Print(false, true, "DBConnection", DBLog.LogInfo); } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { //Initial Page load // SSO Authenticate SAFESSO(); Status.Print(false, true, "Login: "******" " + LoginUser.Surname + " " + "[" + LoginUser.ID + "] has logged on to page"); //Admin users can additionally see the Delete GMI_REF Record button see web.config GTMAdmins if (GTMAdmins.Contains(LoginUser.ID)) { btnGMI_REF_DeleteRecord.Visible = true; btnGMI_REF_DeleteRecord.Enabled = true; lblProcessID.Visible = true; } // Set initial Filter image state imgButShowAdvFilters.ImageUrl = IMGURLFiltersShow; // CHECK DATABASE CONNECTION IS OK HERE // Populate drop down controls. // Maybe get this value from a cookie. ddListPageRows.DataSource = gridRowsShown; ddListPageRows.DataBind(); ddListPageRows.SelectedItem.Value = gridRowsShown[0]; ddListPageRows.SelectedIndex = 0; // Get gmi_status as list of values and add a blank unselected at the top lov_GMI_STATUS lovGMISTATUS = new lov_GMI_STATUS(); ddLGMISTATUS.DataSource = lovGMISTATUS.getLOV(); ddLGMISTATUS.DataBind(); ddLGMISTATUS.Items.Insert(0, new ListItem(String.Empty, String.Empty)); ddLGMISTATUS.SelectedIndex = 0; // Get gmi_environment as list of values and add a blank unselected at the top lov_GMI_ENVIRONMENT lovGMI_ENV = new lov_GMI_ENVIRONMENT(); ddLENVIRONMENT.DataSource = lovGMI_ENV.getLOV(); ddLENVIRONMENT.DataBind(); ddLENVIRONMENT.Items.Insert(0, new ListItem(String.Empty, String.Empty)); ddLENVIRONMENT.SelectedIndex = 0; //Get Feeds as list of values lov_FEED lov_FEEDS = new lov_FEED(); ddlFEED.DataSource = lov_FEEDS.getLOV(); ddlFEED.DataBind(); ddlFEED.Items.Insert(0, new ListItem(String.Empty, String.Empty)); ddlFEED.SelectedIndex = 0; ddlEventSeverity.Items.Insert(0, lstSeverity[0]); ddlEventSeverity.Items.Insert(1, lstSeverity[1]); ddlEventSeverity.Items.Insert(2, lstSeverity[2]); ddlEventSeverity.Items.Insert(3, lstSeverity[3]); ddlEventSeverity.Items.Insert(4, lstSeverity[4]); ddlEventSeverity.Items.Insert(5, lstSeverity[5]); ddlEventSeverity.SelectedIndex = 4; } else { } }