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); }
/// <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); }
/// <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); }
//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\">×</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\">×</span><span class=\"sr-only\">Close</span></button>"; } } catch (Exception ex) { Log.Entry.Ins.WriteHistoryEntry(DateTime.Now.ToString() + " Exception - " + ex); throw ex; } } }
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\">×</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\">×</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 { } } }
/// <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; } }
//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; } }
/// <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; } }
public DataTable GetNameforStatus(DominoCluster ClusterObj) { try { return(VSWebDAL.ConfiguratorDAL.DominoClusterDAL.Ins.GetNameforStatus(ClusterObj)); } catch (Exception ex) { throw ex; } }
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(); }
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); }
//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); }
/// <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; } }
//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); }
/// <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); }
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 { } }
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 { } }
/// <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(""); }
/// <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); }