protected void ddlSavedQuery_SelectedIndexChanged(object sender, EventArgs e)
{
if (ddlSavedQuery.SelectedValue == "0")
{
txtQuery.Text = "";
txtQueryName.Text = "";
lblQueryDetails.Text = "";
lblCreatedBy.Text = "";
}
else
{
DataTable dt = BLL_Infra_DaemonSettings.Get_SavedQuery(UDFLib.ConvertToInteger(ddlSavedQuery.SelectedValue), GetSessionUserID());
if (dt.Rows.Count > 0)
{
txtQuery.Text = dt.Rows[0]["Command_SQL"].ToString();
txtQueryName.Text = dt.Rows[0]["Query_Name"].ToString();
lblQueryDetails.Text = "Server: " + dt.Rows[0]["DBServer"].ToString() +
"/ (" + dt.Rows[0]["DatabaseName"].ToString() + ")" +
"<br>Query Name: " + dt.Rows[0]["Query_Name"].ToString();
lblCreatedBy.Text = "Created By: " + dt.Rows[0]["CreatedBy"].ToString() + " on " + dt.Rows[0]["Date_Of_Creation"].ToString();
if (dt.Rows[0]["ModifiedBy"].ToString() != "")
{
lblCreatedBy.Text += ", Modified By: " + dt.Rows[0]["ModifiedBy"].ToString() + " on " + dt.Rows[0]["Date_Of_Modification"].ToString();
}
}
else
{
txtQuery.Text = "";
txtQueryName.Text = "";
lblQueryDetails.Text = "";
lblCreatedBy.Text = "";
}
}
}
protected void Load_SavedQueries()
{
DataTable dt = BLL_Infra_DaemonSettings.Get_SavedQuery(hdnServer.Value, hdnCatalog.Value, hdnUsername.Value, 0, GetSessionUserID());
ddlSavedQuery.Items.Clear();
ddlSavedQuery.DataSource = dt;
ddlSavedQuery.DataTextField = "Query_Name";
ddlSavedQuery.DataValueField = "ID";
ddlSavedQuery.DataBind();
ddlSavedQuery.Items.Insert(0, new ListItem("Select Procedure", "0"));
}
