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