Exemplo n.º 1
0
        public DataTable GetIPAddress(DominoCluster ClusterObj)
        {
            //SametimeServers SametimeObj = new SametimeServers();
            DataTable ClusterTable = new DataTable();

            try
            {
                if (ClusterObj.ID == 0)
                {
                    string sqlQuery = "Select * from DominoCluster where Name='" + ClusterObj.Name + "' ";
                    ClusterTable = objAdaptor.FetchData(sqlQuery);
                }
                else
                {
                    string sqlQuery = "Select * from DominoCluster where Name='" + ClusterObj.Name + "' and ID <>" + ClusterObj.ID + " ";
                    ClusterTable = objAdaptor.FetchData(sqlQuery);
                }
            }

            catch (Exception ex)
            {
                throw ex;
            }
            return(ClusterTable);
        }
Exemplo n.º 2
0
        /// <summary>
        /// Insert data into DominoCluster table
        /// </summary>
        /// <param name="DSObject">DominoServers object</param>
        /// <returns></returns>

        public bool InsertData(DominoCluster DCObject)
        {
            bool Insert = false;

            try
            {
                //4/27/2016 NS modified for VSPLUS-2724
                string SqlQuery = "INSERT INTO DominoCluster (ServerID_A,Server_A_Directory,Server_A_ExcludeList,ServerID_B,Server_B_Directory," +
                                  "Server_B_ExcludeList,ServerID_C,Server_C_Directory,Server_C_ExcludeList,Missing_Replica_Alert,First_Alert_Threshold," +
                                  "Enabled,Name,ScanInterval,OffHoursScanInterval,RetryInterval,Category,ServerAName,ServerBName,ServerCName) " +
                                  "VALUES('" + DCObject.ServerID_A + "','" + DCObject.Server_A_Directory + "','" + DCObject.Server_A_ExcludeList +
                                  "','" + DCObject.ServerID_B + "','" + DCObject.Server_B_Directory + "','" + DCObject.Server_B_ExcludeList +
                                  "','" + DCObject.ServerID_C + "','" + DCObject.Server_C_Directory + "','" + DCObject.Server_C_ExcludeList +
                                  "','" + DCObject.Missing_Replica_Alert + "'," + DCObject.First_Alert_Threshold +
                                  ",'" + DCObject.Enabled + "','" + DCObject.Name + "'," + DCObject.ScanInterval + "," + DCObject.OffHoursScanInterval +
                                  "," + DCObject.RetryInterval + ",'" + DCObject.Category + "', " +
                                  "'" + DCObject.ServerAName + "', '" + DCObject.ServerBName + "', " +
                                  "'" + DCObject.ServerCName + "')";



                Insert = objAdaptor.ExecuteNonQuery(SqlQuery);
            }
            catch
            {
                Insert = false;
            }
            finally
            {
            }
            return(Insert);
        }
Exemplo n.º 3
0
        /// <summary>
        /// Update data into DominoCluster table
        /// </summary>
        /// <param name="DSObject">DominoServers object</param>
        /// <returns></returns>
        public Object UpdateData(DominoCluster DCObject)
        {
            Object Update;

            try
            {
                string SqlQuery = "UPDATE DominoCluster SET ServerID_A='" + DCObject.ServerID_A + "', " +
                                  "Name='" + DCObject.Name + "', Server_A_Directory='" + DCObject.Server_A_Directory + "', " +
                                  "Server_A_ExcludeList='" + DCObject.Server_A_ExcludeList + "', " +
                                  "ServerID_B='" + DCObject.ServerID_B + "', Server_B_Directory='" + DCObject.Server_B_Directory + "', " +
                                  "Server_B_ExcludeList='" + DCObject.Server_B_ExcludeList + "', ServerID_C='" + DCObject.ServerID_C + "', " +
                                  "Server_C_Directory='" + DCObject.Server_C_Directory + "', " +
                                  "Server_C_ExcludeList='" + DCObject.Server_C_ExcludeList + "', " +
                                  "Missing_Replica_Alert='" + DCObject.Missing_Replica_Alert + "', " +
                                  "First_Alert_Threshold=" + DCObject.First_Alert_Threshold + ", Enabled='" + DCObject.Enabled + "', " +
                                  "ScanInterval=" + DCObject.ScanInterval + ", OffHoursScanInterval=" + DCObject.OffHoursScanInterval + ", " +
                                  "RetryInterval=" + DCObject.RetryInterval + ", Category='" + DCObject.Category + "', " +
                                  "ServerAName='" + DCObject.ServerAName + "', ServerBName='" + DCObject.ServerBName + "', " +
                                  "ServerCName='" + DCObject.ServerCName + "' " +
                                  "WHERE ID = " + DCObject.ID + "";

                Update = objAdaptor.ExecuteNonQuery(SqlQuery);
            }
            catch
            {
                Update = false;
            }
            finally
            {
            }
            return(Update);
        }
Exemplo n.º 4
0
        //10/2/2016 Sowmya Added for VSPLUS 2455
        protected void ASPxMenu1_ItemClick(object source, DevExpress.Web.MenuItemEventArgs e)
        {
            if (e.Item.Name == "ScanItem")
            {
                try
                {
                    DominoCluster ClusterObj = new DominoCluster();
                    ClusterObj.Name = Session["ClustName"] == null ? "" : Session["ClustName"].ToString();
                    if (ClusterObj.Name != "")
                    {
                        ClusterObj.ClusterScan = "Ready";
                        //2/22/2016 NS modified for VSPLUS-2629
                        bool returnvalue = VSWebBL.SettingBL.SettingsBL.Ins.UpdateScanvalue("ScanDominoClusterASAP", ClusterObj.Name, VSWeb.Constants.Constants.SysString);
                        successDiv.Style.Value = "display: block";
                        successDiv.InnerHtml   = "Cluster scan is initiated, please allow a few minutes for the data to refresh." +
                                                 "<button type=\"button\" class=\"close\" data-dismiss=\"alert\"><span aria-hidden=\"true\">&times;</span><span class=\"sr-only\">Close</span></button>";
                        ErrorDiv.Style.Value = "display: none";
                    }

                    else
                    {
                        successDiv.Style.Value = "display:none";
                        ErrorDiv.Style.Value   = "display: block";
                        ErrorDiv.InnerHtml     = "There are no clusters to scan." +
                                                 "<button type=\"button\" class=\"close\" data-dismiss=\"alert\"><span aria-hidden=\"true\">&times;</span><span class=\"sr-only\">Close</span></button>";
                    }
                }
                catch (Exception ex)
                {
                    Log.Entry.Ins.WriteHistoryEntry(DateTime.Now.ToString() + " Exception - " + ex);
                    throw ex;
                }
            }
        }
Exemplo n.º 5
0
        private void InsertStatus()
        {
            errorDiv.Style.Value = "display: none";
            DominoCluster ClsObj = new DominoCluster();

            ClsObj.Name = ClsAttNameTextBox.Text;
            DataTable returntable = VSWebBL.ConfiguratorBL.DominoClusterBL.Ins.GetNameforStatus(ClsObj);

            if (returntable.Rows.Count > 0)
            {
                //4/29/2015 NS modified

                /*
                 * ErrorMessageLabel.Text = "This cluster name is already in use.  Please enter a different server name.";
                 * ErrorMessagePopupControl.ShowOnPageLoad = true;
                 */
                errorDiv.InnerHtml = "This cluster name is already in use.  Please enter a different cluster name." +
                                     "<button type=\"button\" class=\"close\" data-dismiss=\"alert\"><span aria-hidden=\"true\">&times;</span><span class=\"sr-only\">Close</span></button>";
                errorDiv.Style.Value = "display: block";
                flag = true;
                ClsAttNameTextBox.Focus();
            }
            else
            {
                try
                {
                    object ReturnValue = VSWebBL.StatusBL.StatusTBL.Ins.InsertData(CollectDataforStatus());
                    // SetFocusOnError(ReturnValue);
                    if (ReturnValue.ToString().Equals("True"))
                    {
                        Session["Status"] = ClsAttNameTextBox.Text;
                        Response.Redirect("ClusterGrid.aspx", false);                         //Mukund, 05Aug14, VSPLUS-844:Page redirect on callback
                        Context.ApplicationInstance.CompleteRequest();
                        //ErrorMessageLabel.Text = "Cluster record created successfully.";
                        //ErrorMessagePopupControl.HeaderText = "Information";
                        //ErrorMessagePopupControl.ShowCloseButton = false;
                        //ValidationUpdatedButton.Visible = true;
                        //ValidationOkButton.Visible = false;
                        //ErrorMessagePopupControl.ShowOnPageLoad = true;
                    }
                    else if (ReturnValue.ToString().Equals("false"))
                    {
                        errorDiv.InnerHtml = "The following error has occurred: could not insert a record into the SQL table." +
                                             "<button type=\"button\" class=\"close\" data-dismiss=\"alert\"><span aria-hidden=\"true\">&times;</span><span class=\"sr-only\">Close</span></button>";
                        errorDiv.Style.Value = "display: block";
                        //6/27/2014 NS added for VSPLUS-634
                        Log.Entry.Ins.WriteHistoryEntry(DateTime.Now.ToString() + " Error while trying to insert to SQL.");
                    }
                }
                catch (Exception ex)
                {
                    ErrorMessageLabel.Text = "Error attempting to update the status table :" + ex.Message;
                    ErrorMessagePopupControl.ShowOnPageLoad = true;
                    //6/27/2014 NS added for VSPLUS-634
                    Log.Entry.Ins.WriteHistoryEntry(DateTime.Now.ToString() + " Exception - " + ex);
                }
                finally { }
            }
        }
Exemplo n.º 6
0
 /// <summary>
 /// Call to Get Data from DominoCluster based on Primary key
 /// </summary>
 /// <param name="DominoClusterObject">DominoClusterObject object</param>
 /// <returns></returns>
 public DominoCluster GetData(DominoCluster DominoClusterObject)
 {
     try
     {
         return(VSWebDAL.ConfiguratorDAL.DominoClusterDAL.Ins.GetData(DominoClusterObject));
     }
     catch (Exception ex)
     {
         throw ex;
     }
 }
Exemplo n.º 7
0
 //10/2/2016 Sowmya Added for VSPLUS 2455
 public bool Updateclusterscandata(DominoCluster DominoClusterObject)
 {
     try
     {
         return(VSWebDAL.ConfiguratorDAL.DominoClusterDAL.Ins.Updateclusterscandata(DominoClusterObject));
     }
     catch (Exception ex)
     {
         throw ex;
     }
 }
Exemplo n.º 8
0
 /// <summary>
 /// Call DAL Delete Data
 /// </summary>
 /// <param name="DCObject"></param>
 /// <returns></returns>
 public Object DeleteData(DominoCluster DCObject)
 {
     try
     {
         return(VSWebDAL.ConfiguratorDAL.DominoClusterDAL.Ins.DeleteData(DCObject));
     }
     catch (Exception ex)
     {
         throw ex;
     }
 }
Exemplo n.º 9
0
 public DataTable GetNameforStatus(DominoCluster ClusterObj)
 {
     try
     {
         return(VSWebDAL.ConfiguratorDAL.DominoClusterDAL.Ins.GetNameforStatus(ClusterObj));
     }
     catch (Exception ex)
     {
         throw ex;
     }
 }
Exemplo n.º 10
0
        protected void DominoClusterGridView_RowDeleting(object sender, DevExpress.Web.Data.ASPxDataDeletingEventArgs e)
        {
            DominoCluster DCObject = new DominoCluster();

            DCObject.ID = Convert.ToInt32(e.Keys[0]);
            //Delete row from DB
            Object ReturnValue = VSWebBL.ConfiguratorBL.DominoClusterBL.Ins.DeleteData(DCObject);

            //Update Grid after inserting new row, refresh grid as in page load
            ASPxGridView gridView = (ASPxGridView)sender;

            gridView.CancelEdit();
            e.Cancel = true;
            FillDominoClusterGrid();
        }
Exemplo n.º 11
0
        public DataTable GetNameforStatus(DominoCluster ClusterObj)
        {
            //SametimeServers SametimeObj = new SametimeServers();
            DataTable ClusterTable = new DataTable();

            try
            {
                string sqlQuery = "Select * from Status where Name='" + ClusterObj.Name + "' ";
                ClusterTable = objAdaptor.FetchData(sqlQuery);
            }

            catch (Exception ex)
            {
                throw ex;
            }
            return(ClusterTable);
        }
Exemplo n.º 12
0
        //delete Data from DominoCluster Table

        public Object DeleteData(DominoCluster DCObject)
        {
            Object Update;

            try
            {
                string SqlQuery = "Delete DominoCluster Where ID=" + DCObject.ID;

                Update = objAdaptor.ExecuteNonQuery(SqlQuery);
            }
            catch
            {
                Update = false;
            }
            finally
            {
            }
            return(Update);
        }
Exemplo n.º 13
0
 /// <summary>
 /// Call to Update Data of DominoServers based on Key
 /// </summary>
 /// <param name="DominoClusterObject">DominoServers object</param>
 /// <returns>Object</returns>
 public Object UpdateData(DominoCluster DominoClusterObject)
 {
     try
     {
         Object ReturnValue = ValidateDCUpdate(DominoClusterObject);
         if (ReturnValue.ToString() == "")
         {
             return(VSWebDAL.ConfiguratorDAL.DominoClusterDAL.Ins.UpdateData(DominoClusterObject));
         }
         else
         {
             return(ReturnValue);
         }
     }
     catch (Exception ex)
     {
         throw ex;
     }
 }
Exemplo n.º 14
0
        //10/2/2016 Sowmya Added for VSPLUS 2455
        public bool Updateclusterscandata(DominoCluster DCObject)
        {
            bool Updateclusterscan = false;

            try
            {
                string SqlQuery = "UPDATE DominoCluster SET ClusterScan='" + DCObject.ClusterScan + "' "
                                  + "WHERE Name = '" + DCObject.Name + "'";

                Updateclusterscan = objAdaptor.ExecuteNonQuery(SqlQuery);
            }
            catch
            {
                Updateclusterscan = false;
            }
            finally
            {
            }
            return(Updateclusterscan);
        }
Exemplo n.º 15
0
        /// <summary>
        /// Get all Data from DominoCluster
        /// </summary>

        public DataTable GetAllData()
        {
            DataTable     DominoClusterDataTable = new DataTable();
            DominoCluster ReturnDCObject         = new DominoCluster();

            try
            {
                string SqlQuery = "SELECT ID,(select ServerName from Servers where ID in (ServerID_A)) as ServerA,Server_A_Directory,Server_A_ExcludeList,(select ServerName from Servers where ID in (ServerID_B)) as ServerB,Server_B_Directory,Server_B_ExcludeList" +
                                  ", (select ServerName from Servers where ID in (ServerID_C)) as ServerC,Server_C_Directory,Server_C_ExcludeList,Missing_Replica_Alert,First_Alert_Threshold" +
                                  ",Enabled,Name,ScanInterval,OffHoursScanInterval,RetryInterval,Category FROM DominoCluster";

                DominoClusterDataTable = objAdaptor.FetchData(SqlQuery);
            }
            catch (Exception ex)
            {
                throw ex;
            }
            finally
            {
            }
            return(DominoClusterDataTable);
        }
Exemplo n.º 16
0
        private DominoCluster CollectDataForDominoCluster()
        {
            try
            {
                // SetFocusOnControl();
                //Cluster Settings
                DominoCluster DominoClusterObject = new DominoCluster();
                DominoClusterObject.Name     = ClsAttNameTextBox.Text;
                DominoClusterObject.Enabled  = scanEnableCheckBox.Checked;
                DominoClusterObject.Category = ClusterCategoryComboBox.Text;
                if (ScanIntervalTextBox.Text != "" && ScanIntervalTextBox.Text != null)
                {
                    DominoClusterObject.ScanInterval = int.Parse(ScanIntervalTextBox.Text);
                }
                if (OHScanTextBox.Text != "" && OHScanTextBox.Text != null)
                {
                    DominoClusterObject.OffHoursScanInterval = int.Parse(OHScanTextBox.Text);
                }
                if (AlertTextBox.Text != "" && AlertTextBox.Text != null)
                {
                    DominoClusterObject.First_Alert_Threshold = float.Parse(AlertTextBox.Text);
                }
                //DominoClusterObject.Missing_Replica_Alert = AlertCheckBox.Checked;
                //servers Fields
                //12/13/2012 NS modified
                if (ServerAComboBox.Text != "" && ServerAComboBox.Text != null)
                {
                    DominoClusterObject.ServerID_A = int.Parse(ServerAComboBox.Value.ToString());
                }
                DominoClusterObject.Server_A_Directory = ServerATextBox.Text;
                DominoClusterObject.ServerAName        = ServerAComboBox.Text.ToString();
                if (ServerBComboBox3.Text != "" && ServerBComboBox3.Text != null)
                {
                    DominoClusterObject.ServerID_B = int.Parse(ServerBComboBox3.Value.ToString());
                }
                DominoClusterObject.Server_B_Directory = ServerBTextBox.Text;
                DominoClusterObject.ServerBName        = ServerBComboBox3.Text.ToString();
                if (ServerCComboBox.Value != null)
                {
                    if (ServerCComboBox.Value.ToString() != "None" && ServerCComboBox.Value.ToString() != "" && ServerCComboBox.Value.ToString() != null)
                    {
                        DominoClusterObject.ServerID_C  = int.Parse(ServerCComboBox.Value.ToString());
                        DominoClusterObject.ServerCName = ServerCComboBox.Text.ToString();
                    }
                }
                DominoClusterObject.Server_C_Directory = ServerCTextBox.Text;
                //4/20/2016 NS added for VSPLUS-2724
                DominoClusterObject.Server_A_ExcludeList = ExcludeATextBox.Text;
                DominoClusterObject.Server_B_ExcludeList = ExcludeBTextBox.Text;
                DominoClusterObject.Server_C_ExcludeList = ExcludeCTextBox.Text;

                if (Mode == "Update")
                {
                    DominoClusterObject.ID = ServerKey;
                }
                return(DominoClusterObject);
            }
            catch (Exception ex)
            {
                //6/27/2014 NS added for VSPLUS-634
                Log.Entry.Ins.WriteHistoryEntry(DateTime.Now.ToString() + " Exception - " + ex);
                throw ex;
            }
            finally { }
        }
Exemplo n.º 17
0
        private void FillData(int ID)
        {
            try
            {
                DominoCluster DominoClusterObject = new DominoCluster();
                DominoCluster ReturnDCObject      = new DominoCluster();
                DominoClusterObject.ID = ID;
                ReturnDCObject         = VSWebBL.ConfiguratorBL.DominoClusterBL.Ins.GetData(DominoClusterObject);
                //Cluster Setting fields
                ClsAttNameTextBox.Text       = ReturnDCObject.Name.ToString();
                ClusterCategoryComboBox.Text = ReturnDCObject.Category.ToString();
                ScanIntervalTextBox.Text     = ReturnDCObject.ScanInterval.ToString();
                OHScanTextBox.Text           = ReturnDCObject.OffHoursScanInterval.ToString();
                scanEnableCheckBox.Checked   = ReturnDCObject.Enabled;//(ScanTextBox.Text != null ? true : false);
                AlertTextBox.Text            = ReturnDCObject.First_Alert_Threshold.ToString();
                //AlertCheckBox.Checked = ReturnDCObject.Enabled;
                //Servers fields
                //12/13/2012 NS modified - Server fields should display server name, not ID
                //ServerAComboBox.Text = ReturnDCObject.ServerID_A.ToString();
                ServerAComboBox.Text  = ReturnDCObject.ServerAName;
                ServerAComboBox.Value = ReturnDCObject.ServerID_A.ToString();
                ServerATextBox.Text   = ReturnDCObject.Server_A_Directory;
                //ServerBComboBox3.Text = ReturnDCObject.ServerID_B.ToString();
                ServerBComboBox3.Text  = ReturnDCObject.ServerBName;
                ServerBComboBox3.Value = ReturnDCObject.ServerID_B.ToString();
                ServerBTextBox.Text    = ReturnDCObject.Server_B_Directory;

                if (ReturnDCObject.ServerID_C.ToString() != "0")
                {
                    //ServerCComboBox.Text = ReturnDCObject.ServerID_C.ToString();
                    ServerCComboBox.Text  = ReturnDCObject.ServerCName;
                    ServerCComboBox.Value = ReturnDCObject.ServerID_C.ToString();
                }
                else
                {
                    ServerCComboBox.Text = "None";
                }
                if (ServerCComboBox.Text == "" || ServerCComboBox.Text == "None")
                {
                    ServerCTextBox.Enabled = false;
                }
                else
                {
                    ServerCTextBox.Enabled = true;
                }

                ServerCTextBox.Text = ReturnDCObject.Server_C_Directory;
                //4/20/2016 NS added for VSPLUS-2724
                ExcludeATextBox.Text = ReturnDCObject.Server_A_ExcludeList;
                ExcludeBTextBox.Text = ReturnDCObject.Server_B_ExcludeList;
                ExcludeCTextBox.Text = ReturnDCObject.Server_C_ExcludeList;
                Session["ReturnURL"] = "LotusDominoCluster.aspx?ID=" + ID + "&tab=2";


                //if (ReturnDCObject.ServerID_B.ToString() != "0")
                //{
                //    //ServerCComboBox.Text = ReturnDCObject.ServerID_C.ToString();
                //     ServerBComboBox3.Text = ReturnDCObject.ServerBName;
                //ServerBComboBox3.Value = ReturnDCObject.ServerID_B.ToString();
                //}
                //else
                //{
                //    ServerBComboBox3.Text = "None";
                //}
                //ServerBComboBox3.Text =  ReturnDCObject.Server_B_Directory;
                //Session["ReturnURL"] = "LotusDominoCluster.aspx?ID=" + ID+"&tab=2";
            }

            //

            catch (Exception ex)
            {
                //6/27/2014 NS added for VSPLUS-634
                Log.Entry.Ins.WriteHistoryEntry(DateTime.Now.ToString() + " Exception - " + ex);
                throw ex;
            }
            finally { }
        }
Exemplo n.º 18
0
        /// <summary>
        /// Validation before submitting data for Server tab
        /// </summary>
        /// <param name="DominoClusterObject"></param>
        /// <returns></returns>
        public Object ValidateDCUpdate(DominoCluster DominoClusterObject)
        {
            Object ReturnValue = "";

            try
            {
                if (DominoClusterObject.Name == null || DominoClusterObject.Name == "")
                {
                    return("ER#Please enter a Cluster name.");
                }
                if (DominoClusterObject.ServerID_A == null || DominoClusterObject.ServerID_A.ToString() == "")
                {
                    return("ER#Please select the first server in the Cluster.");
                }
                if (DominoClusterObject.ServerID_B == null || DominoClusterObject.ServerID_B.ToString() == "")
                {
                    return("ER#Please select the second server in the Cluster.");
                }
                if ((DominoClusterObject.ServerID_C != 0) && (DominoClusterObject.Server_C_Directory == ""))
                {
                    return("ER#Please enter the name of the directory where user mail files are located, for example, 'mail'.");
                }
                if (DominoClusterObject.ServerID_A == DominoClusterObject.ServerID_B)
                {
                    return("ER#You must select two different servers to be added as cluster members.");
                }
                if (DominoClusterObject.Server_A_Directory == "" || DominoClusterObject.Server_A_Directory == null)
                {
                    return("ER#Please enter the name of the directory where user mail files are located, for example, 'mail'.");
                }
                if (DominoClusterObject.Server_B_Directory == "" || DominoClusterObject.Server_B_Directory == null)
                {
                    return("ER#Please enter the name of the directory where user mail files are located, for example, 'mail'.");
                }
                if (DominoClusterObject.Category == null || DominoClusterObject.Category == "")
                {
                    return("ER#Please enter a Category.");
                }
                if (DominoClusterObject.ScanInterval.ToString() == "")
                {
                    return("ER#Please enter a Scan Interval.");
                }
                if (DominoClusterObject.ScanInterval < 60)
                {
                    return("ER#The value of the Scan Interval for clusters may not be less than 60 minutes.");
                }
                if (DominoClusterObject.OffHoursScanInterval < 120)
                {
                    return("ER#The value of the Scan Interval for clusters during the off-hours may not be less than 120 minutes.");
                }
                if (DominoClusterObject.OffHoursScanInterval.ToString() == "")
                {
                    return("ER#Please enter an Off-Hours Scan Interval.");
                }
            }
            catch (Exception ex)
            { throw ex; }
            finally
            { }
            return("");
        }
Exemplo n.º 19
0
        /// <summary>
        /// Get Data from DominoServers based on Key
        /// </summary>
        public DominoCluster GetData(DominoCluster DCObject)
        {
            DataTable     DominoClusterDataTable = new DataTable();
            DominoCluster ReturnDCObject         = new DominoCluster();

            try
            {
                string SqlQuery = "Select * from DominoCluster where [ID]=" + DCObject.ID.ToString();
                DominoClusterDataTable = objAdaptor.FetchData(SqlQuery);
                //populate & return data object
                ReturnDCObject.Server_A_Directory   = DominoClusterDataTable.Rows[0]["Server_A_Directory"].ToString();
                ReturnDCObject.Server_A_ExcludeList = DominoClusterDataTable.Rows[0]["Server_A_ExcludeList"].ToString();
                ReturnDCObject.ServerID_A           = int.Parse(DominoClusterDataTable.Rows[0]["ServerID_A"].ToString());
                ReturnDCObject.Server_B_Directory   = DominoClusterDataTable.Rows[0]["Server_B_Directory"].ToString();
                ReturnDCObject.Server_B_ExcludeList = DominoClusterDataTable.Rows[0]["Server_B_ExcludeList"].ToString();
                ReturnDCObject.ServerID_B           = int.Parse(DominoClusterDataTable.Rows[0]["ServerID_B"].ToString());
                ReturnDCObject.Server_C_Directory   = DominoClusterDataTable.Rows[0]["Server_C_Directory"].ToString();
                ReturnDCObject.Server_C_ExcludeList = DominoClusterDataTable.Rows[0]["Server_C_ExcludeList"].ToString();
                ReturnDCObject.ServerID_C           = int.Parse(DominoClusterDataTable.Rows[0]["ServerID_C"].ToString());
                if (DominoClusterDataTable.Rows[0]["Missing_Replica_Alert"].ToString() != "")
                {
                    ReturnDCObject.Missing_Replica_Alert = bool.Parse(DominoClusterDataTable.Rows[0]["Missing_Replica_Alert"].ToString());
                }
                if (DominoClusterDataTable.Rows[0]["First_Alert_Threshold"].ToString() != "")
                {
                    ReturnDCObject.First_Alert_Threshold = float.Parse(DominoClusterDataTable.Rows[0]["First_Alert_Threshold"].ToString());
                }
                //ReturnDCObject.Second_Alert_Threshold = float.Parse(DominoClusterDataTable.Rows[0]["Second_Alert_Threshold"].ToString());
                //if (DominoClusterDataTable.Rows[0]["Second_Alert_Threshold"].ToString() != "")
                // ReturnDCObject.Second_Alert_Threshold = float.Parse(DominoClusterDataTable.Rows[0]["Second_Alert_Threshold"].ToString());
                if (DominoClusterDataTable.Rows[0]["Enabled"].ToString() != "")
                {
                    ReturnDCObject.Enabled = bool.Parse(DominoClusterDataTable.Rows[0]["Enabled"].ToString());
                }
                ReturnDCObject.Name = DominoClusterDataTable.Rows[0]["Name"].ToString();
                if (DominoClusterDataTable.Rows[0]["ScanInterval"].ToString() != "")
                {
                    ReturnDCObject.ScanInterval = int.Parse(DominoClusterDataTable.Rows[0]["ScanInterval"].ToString());
                }
                if (DominoClusterDataTable.Rows[0]["OffHoursScanInterval"].ToString() != "")
                {
                    ReturnDCObject.OffHoursScanInterval = int.Parse(DominoClusterDataTable.Rows[0]["OffHoursScanInterval"].ToString());
                }
                if (DominoClusterDataTable.Rows[0]["RetryInterval"].ToString() != "")
                {
                    ReturnDCObject.RetryInterval = int.Parse(DominoClusterDataTable.Rows[0]["RetryInterval"].ToString());
                }
                ReturnDCObject.Category    = DominoClusterDataTable.Rows[0]["Category"].ToString();
                ReturnDCObject.ServerAName = DominoClusterDataTable.Rows[0]["ServerAName"].ToString();
                ReturnDCObject.ServerBName = DominoClusterDataTable.Rows[0]["ServerBName"].ToString();
                ReturnDCObject.ServerCName = DominoClusterDataTable.Rows[0]["ServerCName"].ToString();
                // AdvNtwrkConCheckBox.Checked = (AdvIPAddressTextBox.Text != "" ? true : false);
            }
            catch (Exception ex)
            {
                throw ex;
            }
            finally
            {
            }
            return(ReturnDCObject);
        }