protected void btnComplete_Click(object sender, EventArgs e) { try { TimeBoundAccessRequest tbar = Session["TBAR"] as TimeBoundAccessRequest; string sqlText = txtQuery.Text; //check if tbar has expired ApiResult checkResult = BussinessLogic.CheckIfTbarIsStillValid(tbar); //tbar has expired if (checkResult.StatusCode != Globals.SUCCESS_STATUS_CODE) { lblErrorMsg.Text = checkResult.StatusDesc; Multiview1.ActiveViewIndex = 0; return; } //see if the dude is fooling around with his query checkResult = CheckIfQueryIsValidForTbar(sqlText, tbar); //failed check if (checkResult.StatusCode != Globals.SUCCESS_STATUS_CODE) { //return error Master.ErrorMessage = checkResult.StatusDesc; return; } int dt = BussinessLogic.cRSystemAPIClient.ExecuteNonQuery(sqlText, tbar); //Show Error Message string msg1 = $"SUCCESS: {dt} ROWS WHERE AFFECTED."; Master.ErrorMessage = msg1; btnComplete.Visible = false; btnExecute.Visible = true; txtQuery.Enabled = true; return; } catch (Exception ex) { //Show Error Message string msg = "ERROR:" + ex.Message; Master.ErrorMessage = msg; return; } }
protected void btnExecute_Click(object sender, EventArgs e) { try { TimeBoundAccessRequest tbar = Session["TBAR"] as TimeBoundAccessRequest; string sqlText = txtQuery.Text; //check if tbar has expired ApiResult checkResult = BussinessLogic.CheckIfTbarIsStillValid(tbar); //tbar has expired if (checkResult.StatusCode != Globals.SUCCESS_STATUS_CODE) { lblErrorMsg.Text = checkResult.StatusDesc; Multiview1.ActiveViewIndex = 0; return; } //see if the dude is fooling around with his query checkResult = CheckIfQueryIsValidForTbar(sqlText, tbar); //failed check if (checkResult.StatusCode != Globals.SUCCESS_STATUS_CODE) { //return error Master.ErrorMessage = checkResult.StatusDesc; return; } ApiResult result = ConvertToSelect(); if (result.StatusCode == Globals.PARSE_ERROR_CODE) { //Show Error Message string msg = "ERROR:" + result.StatusDesc; dataGridResults.DataSource = null; dataGridResults.DataBind(); Master.ErrorMessage = msg; return; } if (result.StatusCode == Globals.FAILURE_STATUS_CODE) { //Show Error Message string msg = "ERROR:" + result.StatusDesc; Master.ErrorMessage = msg; dataGridResults.DataSource = null; dataGridResults.DataBind(); return; } //he input an update or delete statement if (result.StatusCode == Globals.SUCCESS_STATUS_CODE) { DataTable dt = BussinessLogic.cRSystemAPIClient.ExecuteSqlQuery(result.PegPayID, tbar).Tables[0]; dataGridResults.DataSource = dt; dataGridResults.DataBind(); string msg = $"SUCCESS: {dt.Rows.Count} ROWS WILL BE AFFECTED. PLEASE CONFIRM QUERY EXECUTION"; Master.ErrorMessage = msg; btnComplete.Visible = true; btnExecute.Visible = false; txtQuery.Enabled = false; return; } //this is most likely an Insert or create Statment string msg2 = $"SUCCESS: {result.PegPayID} DETECTED. PLEASE CONFIRM QUERY EXECUTION"; Master.ErrorMessage = msg2; txtQuery.Enabled = false; btnComplete.Visible = true; btnExecute.Visible = false; } catch (Exception ex) { //Show Error Message string msg = "ERROR, Query Failed:" + ex.Message; Master.ErrorMessage = msg; return; } }