protected void ExecuteButton_Click(object sender, EventArgs e) { try { TableDiv.Visible = false; //visisbility depends on operation if (QueryBox.Text.Trim().Length > 6) { StatusLabel.CssClass = "success"; string query = QueryBox.Text.Trim().Substring(0, 6).ToUpper(); string updatecode = query; if (query == "SELECT") { DataTable dt = HospitalClass.getDataTable(QueryBox.Text.Trim()); TableLabel.Text = HospitalClass.drawDataTableInHtml(dt, 1036); //draw the data table on a label control as html TableDiv.Visible = true; StatusLabel.CssClass = "success paraNormal"; StatusLabel.Text = "Successful."; } else { int status = DataConsumer.executeQuery(QueryBox.Text.Trim()); StatusLabel.Text = "Successful.<br/>Rows affected: " + status + "Rows."; if (System.Text.RegularExpressions.Regex.IsMatch(query, "(^(DROP)|(TRUNC)|(DELETE))")) { updatecode = "DELETE"; } if (!(query == "CREATE" || query == "INSERT" || query == "UPDATE" || System.Text.RegularExpressions.Regex.IsMatch(query, "(^(DROP)|(TRUNC)|(DELETE))"))) { updatecode = "OTHER"; } } TransBox.Text = HospitalClass.getTransactionId(); if (UpdCodeOverrideBox.Text.Trim().Length == 0) { UpdateCodeBox.Text = "A_" + updatecode; } else { UpdateCodeBox.Text = UpdCodeOverrideBox.Text; } UpdaterBox.Text = Session["SuperUser"].ToString(); UserIdBox.Text = Session["User"].ToString(); DateUpdBox.Text = DateTime.Now.ToShortDateString() + ", " + DateTime.Now.ToLongTimeString(); if (AuditCheckBox.Checked) { List <string> values = new List <string>(); values.Add(TransBox.Text); values.Add(UpdateCodeBox.Text); values.Add(UpdaterBox.Text); values.Add(UserIdBox.Text); int status = DataConsumer.executeProcedure("audit_trail_proc", values); AuditLabel.CssClass = "success"; AuditLabel.Text = "ADDED"; } else { AuditLabel.ForeColor = System.Drawing.Color.Brown; AuditLabel.Text = "NOT ADDED"; } } else { StatusLabel.CssClass = "error"; StatusLabel.Text = "Invalid query"; } } catch (Exception ex) { StatusLabel.CssClass = "error paraNormal"; StatusLabel.Text = "Error: " + ex.Message; if (ex.GetType().ToString() != "System.Data.OracleClient.OracleException") { HospitalClass.Log(ex); } } }