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