예제 #1
0
        public void FillALLGridfromSession()
        {
            DataTable dt = new DataTable();

            if (Session["Dailytab"] != "" && Session["Dailytab"] != null)
            {
                dt = Session["Dailytab"] as DataTable;
            }
            if (dt.Rows.Count > 0)
            {
                AllDBGridView.DataSource = dt;
                AllDBGridView.DataBind();
            }
        }
예제 #2
0
 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;
     }
 }
예제 #3
0
        //protected void AllDBGridView_SelectionChanged(object sender, EventArgs e)
        //{
        //    if (AllDBGridView.Selection.Count > 0)
        //    {
        //        System.Collections.Generic.List<object> Type = AllDBGridView.GetSelectedFieldValues("Server");

        //        if (Type.Count > 0)
        //        {
        //            string Name = Type[0].ToString();
        //            Session["Type"] = Type[0];
        //            DevExpress.Web.ASPxWebControl.RedirectOnCallback("Performance.aspx?Name=" + Server + "");
        //            //Response.Redirect("DeviceChart.aspx");
        //        }


        //    }
        //}

        public void FillALLGrid()
        {
            DataTable Dailytab = new DataTable();

            try
            {
                Dailytab = VSWebBL.DashboardBL.DatabaseHealthBL.Ins.GetAllData("");

                if (Dailytab.Rows.Count > 0)
                {
                }
                Session["Dailytab"]      = Dailytab;
                AllDBGridView.DataSource = Dailytab;
                AllDBGridView.DataBind();
                AllDBGridView.FocusedRowIndex = -1;
            }
            catch (Exception ex)
            {
                Log.Entry.Ins.WriteHistoryEntry(DateTime.Now.ToString() + " Exception - " + ex);
                throw ex;
            }
        }
예제 #4
0
 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";
     }
 }
예제 #5
0
        protected void OKButton_Click(object sender, EventArgs e)
        {
            if (Session["ActBtn"] != "" && Session["ActBtn"] != null)
            {
                if (AllDBGridView.FocusedRowIndex > -1)
                {
                    if (Session["ActBtn"] == "CompactButton")
                    {
                        //            NotesSession  session =new NotesSession();
                        //// NotesUIWorkspace workspace = New NotesUIWorkspace();
                        //    // NotesUIDocument  uidoc= new NotesUIDocument();
                        ////Set uidoc = workspace.CurrentDocument
                        //        NotesDocument doc =new NotesDocument();
                        //    //doc = uidoc.Document
                        //// Variant StatValue;
                        //    string dbPath;
                        //if(doc.FolderReferences.Folder(0) != "" )
                        //{

                        //    dbPath = doc.FolderReferences.Folder(0) &doc.FolderReferences.Filename(0);
                        //}

                        //else
                        //                {
                        //    dbPath = doc.FolderReferences.Filename(0);
                        //}
                        ////serverName$ =doc.Server(0);
                        //
                        //// Config$ ="lo compact "+ dbPath + " " + Options;
                        ////consoleReturn$ = session.SendConsoleCommand(serverName$, Config$)
                        ////Print  "Sent the command " &Config$  & ".  Note that this will only work if YOU have the appropriate remote console and admin rights."
                        string  Server   = "";
                        string  Config   = "";
                        string  Folder   = "";
                        string  FileName = "";
                        DataRow myRow    = AllDBGridView.GetDataRow(AllDBGridView.FocusedRowIndex);
                        if (AllDBGridView.FocusedRowIndex > -1)
                        {
                            Server   = myRow["Server"].ToString();
                            Folder   = myRow["Folder"].ToString();
                            FileName = myRow["Filename"].ToString();
                        }
                        string Options;
                        Options = popuptextBox.Text;
                        Config  = "lo compact " + Folder + "/" + FileName + "" + Options;
                        bool returnval = VSWebBL.DashboardBL.LotusTravelerHealthBLL.Ins.SENDTravelerConsoleCommand(Server, Config, Session["UserFullName"].ToString());
                        if (returnval == true)
                        {
                            msglbl.Text = "Sent the following command - " + Config + ". Note that this will only work if you have the appropriate remote console and admin rights.";
                            msgPopupControl.ShowOnPageLoad = true;
                        }
                    }

                    if (Session["ActBtn"] == "Fixup")
                    {
                        string  Server   = "";
                        string  Config   = "";
                        string  Folder   = "";
                        string  FileName = "";
                        DataRow myRow    = AllDBGridView.GetDataRow(AllDBGridView.FocusedRowIndex);
                        if (AllDBGridView.FocusedRowIndex > -1)
                        {
                            Server   = myRow["Server"].ToString();
                            Folder   = myRow["Folder"].ToString();
                            FileName = myRow["Filename"].ToString();
                        }
                        string Options;
                        Options = popuptextBox.Text;
                        Config  = "Load fixupdbpath options " + Folder + "/" + FileName + "" + Options;
                        bool returnval = VSWebBL.DashboardBL.LotusTravelerHealthBLL.Ins.SENDTravelerConsoleCommand(Server, Config, Session["UserFullName"].ToString());
                        if (returnval == true)
                        {
                            msglbl.Text = "Sent the following command - " + Config + ". Note that this will only work if you have the appropriate remote console and admin rights.";
                            msgPopupControl.ShowOnPageLoad = true;
                        }
                        // Config ="Load fixupdbpath options "+ dbPath + " " + Options;
                    }
                    if (Session["ActBtn"] == "Updall")
                    {
                        string  Server   = "";
                        string  Config   = "";
                        string  Folder   = "";
                        string  FileName = "";
                        DataRow myRow    = AllDBGridView.GetDataRow(AllDBGridView.FocusedRowIndex);
                        if (AllDBGridView.FocusedRowIndex > -1)
                        {
                            Server   = myRow["Server"].ToString();
                            Folder   = myRow["Folder"].ToString();
                            FileName = myRow["Filename"].ToString();
                        }
                        string Options;
                        Options = popuptextBox.Text;
                        Config  = "Load updalldbpath options " + Folder + "/" + FileName + "" + Options;
                        bool returnval = VSWebBL.DashboardBL.LotusTravelerHealthBLL.Ins.SENDTravelerConsoleCommand(Server, Config, Session["UserFullName"].ToString());
                        if (returnval == true)
                        {
                            msglbl.Text = "Sent the following command - " + Config + ". Note that this will only work if you have the appropriate remote console and admin rights.";
                            msgPopupControl.ShowOnPageLoad = true;
                        }


                        // Config$ ="Load updalldbpath options"+ dbPath + " " + Options;
                    }
                    DBPopupControl.ShowOnPageLoad = false;
                }

                else
                {
                    msglbl.Text = "Please select a server from the grid.";
                    msgPopupControl.ShowOnPageLoad = true;
                    DBPopupControl.ShowOnPageLoad  = false;
                }
            }
        }