protected void btnSave_Click(object sender, EventArgs e)
{
try{
int result = 0;
string Query_Name = "";
if (ddlObjectType.SelectedValue == "TB")
{
Query_Name = ddlSavedQuery.SelectedValue;
}
else
{
Query_Name = txtQueryName.Text;
}
result = BLL_QueryBuilder.SaveQuery(Query_Name, ddlObjectType.SelectedValue, txtDisplayName.Text, txtQuery.Text, ddlFields.SelectedValue, ddlResultType.SelectedValue, hdnServer.Value, hdnCatalog.Value,
hdnUsername.Value, hdnPassword.Value, GetSessionUserID());
if (result == 1)
{
lblSuccess.Visible = true;
ddlSavedQuery.SelectedValue = "0";
ddlFields.SelectedValue = "0";
txtDisplayName.Text = "";
}
}
catch (Exception ex)
{
string err = ex.ToString();
}
}
protected void ddlSavedQuery_SelectedIndexChanged(object sender, EventArgs e)
{
try
{
if (ddlObjectType.SelectedValue == "SP" && ddlSavedQuery.SelectedValue != "0")
{
pnlSavedProc.Enabled = true;
txtQuery.Enabled = true;
pnlCtl.Visible = true;
DataTable dt = objQB.Get_SavedQuery(ddlSavedQuery.SelectedValue, ddlCommandType.SelectedValue, GetSessionUserID());
if (dt.Rows.Count > 0)
{
txtQuery.Text = dt.Rows[0]["Command_SQL"].ToString();
txtQueryName.Text = dt.Rows[0]["ObjectName"].ToString();
lblQueryDetails.Text = "Server: " + dt.Rows[0]["DBServer"].ToString() +
"/ (" + dt.Rows[0]["DatabaseName"].ToString() + ")" +
"<br>Query Name: " + dt.Rows[0]["ObjectName"].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();
}
}
DataTable dtQuery = BLL_QueryBuilder.Get_QueryDeatil(ddlSavedQuery.SelectedValue);
if (dtQuery.Rows.Count > 0)
{
txtDisplayName.Text = dtQuery.Rows[0]["Display_Name"].ToString();
}
}
else if (ddlObjectType.SelectedValue == "TB" && ddlSavedQuery.SelectedValue != "0")
{
txtQuery.Text = "";
txtQueryName.Text = "";
lblQueryDetails.Text = "";
lblCreatedBy.Text = "";
txtQuery.Enabled = false;
DataTable dtFields = objQB.GET_Table_Columns(ddlSavedQuery.SelectedValue);
if (dtFields.Rows.Count > 0)
{
pnlSavedProc.Enabled = true;
ddlFields.Items.Clear();
ddlFields.DataSource = dtFields;
ddlFields.DataTextField = "ColumnName";
ddlFields.DataValueField = "ColumnName";
ddlFields.DataBind();
ddlFields.Items.Insert(0, new ListItem("--Select field--", "0"));
}
DataTable dtQuery = BLL_QueryBuilder.Get_QueryDeatil(ddlSavedQuery.SelectedValue);
if (dtQuery.Rows.Count > 0)
{
txtDisplayName.Text = dtQuery.Rows[0]["Display_Name"].ToString();
ddlFields.SelectedValue = dtQuery.Rows[0]["Key_Field"].ToString();
}
}
else
{
txtQuery.Text = "";
txtQueryName.Text = "";
lblQueryDetails.Text = "";
lblCreatedBy.Text = "";
}
}
catch { }
}
