protected void OpenButton_Click(object sender, EventArgs e) { if (AllDBGridView.FocusedRowIndex > -1) { DataTable dt = new DataTable(); int index; if (AllDBGridView.FocusedRowIndex > -1) { index = AllDBGridView.FocusedRowIndex; } else { index = 0; } string HostName = "Nohost"; string Server = AllDBGridView.GetRowValues(index, "Server").ToString(); DataTable servertab = VSWebBL.DashboardBL.DatabaseHealthBL.Ins.GetIPfromServers(Server); if (servertab.Rows.Count > 0) { HostName = servertab.Rows[0]["IPAddress"].ToString(); } string filepath = AllDBGridView.GetRowValues(index, "Folder").ToString(); string fileName = AllDBGridView.GetRowValues(index, "FileName").ToString(); filepath = filepath.Replace("'\'", "'/'"); if (filepath == "") { Page.ClientScript.RegisterStartupScript(this.GetType(), "Script", "PopupCenter('http://" + HostName + "/" + fileName + "?OpenDatabase');", true); } else { Page.ClientScript.RegisterStartupScript(this.GetType(), "Script", "PopupCenter('http://" + HostName + "/" + filepath + "/" + fileName + "?OpenDatabase');", true); } //if (filepath == "") //{ // Response.Write("<script>window.open('http://" + HostName + "/" + fileName + "?OpenDatabase','Open Database','width=500px height=50px left=(screen.width/2)-(500/2) top=(screen.height/2)-(50/2)',1)</script>"); //} //else //{ // Response.Write("<script>window.open('http://" + HostName + "/" + filepath + "/" + fileName + "?OpenDatabase','Open Database','width=500px height=50px',1)</script>"); //} } else { msglbl.Text = "Please select a database in the All Databases grid."; msgPopupControl.ShowOnPageLoad = true; } }
protected void ASPxMenu1_ItemClick(object source, DevExpress.Web.MenuItemEventArgs e) { if (e.Item.Name == "OpenDBItem") { if (AllDBGridView.FocusedRowIndex > -1) { DataTable dt = new DataTable(); int index; if (AllDBGridView.FocusedRowIndex > -1) { index = AllDBGridView.FocusedRowIndex; } else { index = 0; } string HostName = "Nohost"; string Server = AllDBGridView.GetRowValues(index, "Server").ToString(); DataTable servertab = VSWebBL.DashboardBL.DatabaseHealthBL.Ins.GetIPfromServers(Server); if (servertab.Rows.Count > 0) { HostName = servertab.Rows[0]["IPAddress"].ToString(); } string filepath = AllDBGridView.GetRowValues(index, "Folder").ToString(); string fileName = AllDBGridView.GetRowValues(index, "FileName").ToString(); filepath = filepath.Replace("'\'", "'/'"); if (filepath == "") { Page.ClientScript.RegisterStartupScript(this.GetType(), "Script", "PopupCenter('http://" + HostName + "/" + fileName + "?OpenDatabase');", true); } else { Page.ClientScript.RegisterStartupScript(this.GetType(), "Script", "PopupCenter('http://" + HostName + "/" + filepath + "/" + fileName + "?OpenDatabase');", true); } //if (filepath == "") //{ // Response.Write("<script>window.open('http://" + HostName + "/" + fileName + "?OpenDatabase','Open Database','width=500px height=50px left=(screen.width/2)-(500/2) top=(screen.height/2)-(50/2)',1)</script>"); //} //else //{ // Response.Write("<script>window.open('http://" + HostName + "/" + filepath + "/" + fileName + "?OpenDatabase','Open Database','width=500px height=50px',1)</script>"); //} } else { msglbl.Text = "Please select a database in the All Databases grid."; msgPopupControl.ShowOnPageLoad = true; } } else if (e.Item.Name == "CompactItem") { popuptextBox.Text = ""; DBPopupControl.HeaderText = "Compact Options"; ASPxLabel1.Text = "Please enter the desired COMPACT options."; ASPxLabel2.Text = "Use -c for corrupt databases and -B for in place compaction with file size reduction."; ASPxLabel3.Text = "Google 'IBM domino compact switches' for the full list of options."; ASPxLabel4.Visible = false; DBPopupControl.ShowOnPageLoad = true; Session["ActBtn"] = "CompactButton"; } else if (e.Item.Name == "FixupItem") { popuptextBox.Text = ""; DBPopupControl.HeaderText = "Fixup Options"; ASPxLabel1.Text = "Please enter the desired FIXUP options."; ASPxLabel2.Text = "For example, use -Q to check more quickly but less thoroughly."; ASPxLabel3.Text = "Google 'IBM fixup compact switches' for the full list of options."; ASPxLabel4.Visible = true; ASPxLabel4.Text = "Use -V to prevent Fixup from running on views. This option reduces the time it takes Fixup to run."; DBPopupControl.ShowOnPageLoad = true; Session["ActBtn"] = "Fixup"; } else if (e.Item.Name == "UpdallItem") { popuptextBox.Text = ""; DBPopupControl.HeaderText = "Updall Options"; ASPxLabel1.Text = "Please enter the desired UPDALL options."; ASPxLabel2.Text = "For example, use -R to rebuild all used views (resource intensive)."; ASPxLabel3.Text = "Use -X to rebuild the full text index."; ASPxLabel4.Visible = false; DBPopupControl.ShowOnPageLoad = true; Session["ActBtn"] = "Updall"; } }