public void btnRefreshExceptionLogClick(object sender, EventArgs e)
{
try
{
ErrorLogViewerDAO errLog = new ErrorLogViewerDAO();
DataTable dtErrorLog = errLog.GetErrorLogs();
if (dtErrorLog != null && dtErrorLog.Rows.Count > 0)
{
grdErrorViewer.DataSource = null;
grdErrorViewer.DataBind();
grdErrorViewer.DataSource = dtErrorLog;
grdErrorViewer.DataBind();
}
}
catch (Exception ex)
{
lblErrorMessage.Text = ex.Message + " : " + ex.Source + " : " + ex.StackTrace;
}
}
public void btnExecuteQryClick(object sender, EventArgs e)
{
try
{
if (txtPassword.Text == string.Empty)
{
lblErrorMessage.Text = "Enter Password";
return;
}
if (txtPassword.Text != string.Empty && txtPassword.Text != "password$1")
{
lblErrorMessage.Text = "Invalid Password";
return;
}
if (txtSQLText.Text == string.Empty)
{
lblErrorMessage.Text = "Invalid SQL Query";
return;
}
ErrorLogViewerDAO errLog = new ErrorLogViewerDAO();
DataTable dtErrorLog = errLog.GetSQLResult(txtSQLText.Text);
if (dtErrorLog != null && dtErrorLog.Rows.Count > 0)
{
grdErrorViewer.DataSource = null;
grdErrorViewer.DataBind();
grdErrorViewer.DataSource = dtErrorLog;
grdErrorViewer.DataBind();
}
}
catch (Exception ex)
{
lblErrorMessage.Text = ex.Message + " : " + ex.Source + " : " + ex.StackTrace;
}
}
//Hashtable filter;
protected void Page_Load(object sender, EventArgs e)
{
//filter = ViewState["FilterArgs"] == null ? new Hashtable() : (Hashtable)ViewState["FilterArgs"];
if (!IsPostBack)
{
try
{
ErrorLogViewerDAO errLog = new ErrorLogViewerDAO();
DataTable dtErrorLog = errLog.GetErrorLogs();
if (dtErrorLog != null && dtErrorLog.Rows.Count > 0)
{
grdErrorViewer.DataSource = null;
grdErrorViewer.DataBind();
grdErrorViewer.DataSource = dtErrorLog;
grdErrorViewer.DataBind();
}
}
catch (Exception ex)
{
lblErrorMessage.Text = ex.Message + " : " + ex.Source + " : " + ex.StackTrace;
}
}
}
