public DataTable GetName(NetworkLatency nlobj)
{
//SametimeServers SametimeObj = new SametimeServers();
DataTable NetworkLatencyTable = new DataTable();
try
{
if (nlobj.NetworkLatencyId == 0)
{
string sqlQuery = "Select * from NetworkLatency where TestName='" + nlobj.TestName + "' ";
NetworkLatencyTable = objAdaptor.FetchData(sqlQuery);
}
else
{
string sqlQuery = "Select * from NetworkLatency where TestName='" + nlobj.TestName + "' and NetworkLatencyId <>" + nlobj.NetworkLatencyId + " ";
NetworkLatencyTable = objAdaptor.FetchData(sqlQuery);
}
}
catch (Exception ex)
{
throw ex;
}
return(NetworkLatencyTable);
}
/// <summary>
/// Get Data from DominoServers based on Key
/// </summary>
public NetworkLatency GetData(NetworkLatency NLObject)
{
DataTable networklatencyDataTable = new DataTable();
NetworkLatency ReturnNLObject = new NetworkLatency();
try
{
string SqlQuery = "Select * from NetworkLatency where [NetworkLatencyId]=" + NLObject.NetworkLatencyId.ToString();
networklatencyDataTable = objAdaptor.FetchData(SqlQuery);
//populate & return data object
ReturnNLObject.TestName = networklatencyDataTable.Rows[0]["TestName"].ToString();
if (networklatencyDataTable.Rows[0]["ScanInterval"].ToString() != "")
{
ReturnNLObject.ScanInterval = int.Parse(networklatencyDataTable.Rows[0]["ScanInterval"].ToString());
}
if (networklatencyDataTable.Rows[0]["TestDuration"].ToString() != "")
{
ReturnNLObject.TestDuration = int.Parse(networklatencyDataTable.Rows[0]["TestDuration"].ToString());
}
//ReturnNLObject.ServerType = networklatencyDataTable.Rows[0]["ServerType"].ToString();
// AdvNtwrkConCheckBox.Checked = (AdvIPAddressTextBox.Text != "" ? true : false);
}
catch (Exception ex)
{
throw ex;
}
finally
{
}
return(ReturnNLObject);
}
private void FillData(int ID)
{
try
{
NetworkLatency NetworkLatencyObject = new NetworkLatency();
NetworkLatency ReturnNLObject = new NetworkLatency();
NetworkLatencyObject.ID = ID;
ReturnNLObject = VSWebBL.ConfiguratorBL.NetworkLatencyBL.Ins.GetData(NetworkLatencyObject);
//Cluster Setting fields
ClsAttNameTextBox.Text = ReturnNLObject.Name.ToString();
ScanIntervalTextBox.Text = ReturnNLObject.ScanInterval.ToString();
testduration.Text = ReturnNLObject.TestDuration.ToString();
scanEnableCheckBox.Checked = ReturnNLObject.Enabled;//(ScanTextBox.Text != null ? true : false);
//Servers fields
//12/13/2012 NS modified - Server fields should display server name, not ID
//ServerAComboBox.Text = ReturnDCObject.ServerID_A.ToString();
Session["ReturnURL"] = "NetworkLatencyTest.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 { }
}
private NetworkLatency CollectDataForNetworkLatency()
{
try
{
// SetFocusOnControl();
//Cluster Settings
NetworkLatency NetworkLatencyObject = new NetworkLatency();
NetworkLatencyObject.Name = ClsAttNameTextBox.Text;
NetworkLatencyObject.Enabled = scanEnableCheckBox.Checked;
if (ScanIntervalTextBox.Text != "" && ScanIntervalTextBox.Text != null)
{
NetworkLatencyObject.ScanInterval = int.Parse(ScanIntervalTextBox.Text);
}
if (testduration.Text != "" && testduration.Text != null)
{
NetworkLatencyObject.TestDuration = int.Parse(testduration.Text);
}
if (Mode == "Update")
{
NetworkLatencyObject.ID = ServerKey;
}
return(NetworkLatencyObject);
}
catch (Exception ex)
{
//6/27/2014 NS added for VSPLUS-634
Log.Entry.Ins.WriteHistoryEntry(DateTime.Now.ToString() + " Exception - " + ex);
throw ex;
}
finally { }
}
/// <summary>
/// Handles a sync time response and adjusts our clock to the server clock
/// </summary>
public void HandleSyncTime(long clientReceive, long clientSend, long serverReceive, long serverSend)
{
var clientLatency = clientReceive - clientSend - (serverSend - serverReceive);
var clientOffset = (serverReceive - clientSend + (serverSend - clientReceive)) / 2;
ClockOffset.Add(clientOffset);
NetworkLatency.Add(clientLatency);
ServerLag = serverSend - serverReceive;
if (ClockOffset.Count > SyncTimeMax)
{
ClockOffset.RemoveAt(0);
}
if (NetworkLatency.Count > SyncTimeMax)
{
NetworkLatency.RemoveAt(0);
}
//Calculate the average for the offset and latency.
var clockOffsetTotal = ClockOffset.Sum();
ClockOffsetAverage = clockOffsetTotal / ClockOffset.Count;
var networkLatencyTotal = NetworkLatency.Sum();
NetworkLatencyAverage = networkLatencyTotal / NetworkLatency.Count;
//Check if we are now synced
if ((ClockOffset.Count > SettingsSystem.CurrentSettings.InitialConnectionSyncTimeRequests) && !Synced)
{
Synced = true;
Debug.Log($"[LMP]: Initial clock syncronized, offset {ClockOffsetAverage/10000}ms, latency {NetworkLatencyAverage/10000}ms");
}
}
protected void bttnOK_Click(object sender, EventArgs e)
{
NetworkLatency locObj = new NetworkLatency();
locObj.NetworkLatencyId = netid;
Object returnValue = VSWebBL.ConfiguratorBL.NetworkLatencyBL.Ins.DeleteData(locObj.NetworkLatencyId.ToString());
}
private NetworkLatency CollectDataForProfiles(DataRow ProfilesRow)
{
try
{
NetworkLatency nl = new NetworkLatency();
// ProfileNames Profilesnamesobj = new ProfileNames();
//ProfilesObject.ServerID=Convert.ToInt32(ProfilesRow["ServerID"].ToString());
//ProfilesObject.NetworkLatencyId = Convert.ToInt32(ProfilesRow["NetworkLatencyId"].ToString());
//ProfilesObject.ServerType = ProfilesRow["ServerType"].ToString();
// ProfilesObject.ServerID = ProfilesRow["ServerID"].ToString();
nl.NetworkLatencyId = ServerKey;
if (nl.LatencyYellowThreshold != null)
{
nl.LatencyYellowThreshold = ProfilesRow["LatencyYellowThreshold"].ToString() == "" ? 0 : Convert.ToInt32(ProfilesRow["LatencyYellowThreshold"].ToString());
}
if (nl.LatencyYellowThreshold != null)
{
nl.LatencyRedThreshold = ProfilesRow["LatencyRedThreshold"].ToString() == ""? 0 : Convert.ToInt32(ProfilesRow["LatencyRedThreshold"].ToString());
}
nl.Enabled = Convert.ToBoolean(ProfilesRow["Enabled"].ToString());
//ProfilesObject.ProfileId = Convert.ToInt32(ProfileComboBox.SelectedItem.Value);
//Profilesnamesobj.ProfileName = ProfileComboBox.SelectedItem.Text;
return(nl);
}
catch (Exception ex)
{
//6/27/2014 NS added for VSPLUS-634
Log.Entry.Ins.WriteHistoryEntry(DateTime.Now.ToString() + " Exception - " + ex);
throw ex;
}
finally { }
}
private NetworkLatency CollectDataFornl()
{
try
{
NetworkLatency nlobj = new NetworkLatency();
nlobj.NetworkLatencyId = ServerKey;
nlobj.TestName = testtxtname.Text;
nlobj.ScanInterval = Convert.ToInt32(txtscaninterval.Text);
nlobj.TestDuration = Convert.ToInt32(txtduration.Text);
nlobj.LatencyYellowThreshold = txtyellothld.Text == "" ? 0 : Convert.ToInt32(txtyellothld.Text);
nlobj.LatencyRedThreshold = txtredthreshold.Text == "" ? 0 : Convert.ToInt32(txtredthreshold.Text);
// nlobj.ServerType = servertypecombo.Text;
nlobj.Enable = SrvAtrScanCheckBox.Checked;
//DominoServersObject.Modified_By = int.Parse(Session["UserID"].ToString());
//DominoServersObject.Modified_On = DateTime.Now.ToString();
return(nlobj);
}
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 Key)
{
try
{
NetworkLatency nl = new NetworkLatency();
NetworkLatency ReturnDSObject = new NetworkLatency();
nl.NetworkLatencyId = Key;
ReturnDSObject = VSWebBL.ConfiguratorBL.NetworkLatencyBL.Ins.GetData(nl);
//5/5/2014 NS modified for VSPLUS-589
//if (ReturnDSObject.NotificationGroup != null)
testtxtname.Text = ReturnDSObject.TestName.ToString();
txtscaninterval.Text = ReturnDSObject.ScanInterval.ToString();
txtduration.Text = ReturnDSObject.TestDuration.ToString();
// servertypecombo.Text = ReturnDSObject.ServerType.ToString();
SrvAtrScanCheckBox.Checked = (ReturnDSObject.Enable.ToString() == "True" ? true : false);
}
catch (Exception ex)
{
//6/27/2014 NS added for VSPLUS-634
Log.Entry.Ins.WriteHistoryEntry(DateTime.Now.ToString() + " Exception - " + ex);
throw ex;
}
finally { }
}
//public Object UpdateExchangeSettings(NetworkLatency nl)
//{
// Object returnval;
// try
// {
// string st = "update NetworkLatencyServers set LatencyYellowThreshold=" + nl.LatencyYellowThreshold + ", LatencyRedThreshold=" + nl.LatencyRedThreshold + ",Enabled='" + nl.Enabled + "' where ID='"+nl.ID+"'";
// returnval = objAdaptor.ExecuteNonQuery(st);
// }
// catch (Exception e)
// {
// throw e;
// }
// return returnval;
//}
public bool UpdateeditProfiles(NetworkLatency StObject, string strsname)
{
bool UpdateRet = false;
int Update = 0;
try
{
DataTable dt = new DataTable();
ServerTypes STypebject = new ServerTypes();
// RetnSTypebject = VSWebDAL.SecurityDAL.ServerTypesDAL.Ins.GetDataForServerType(STypebject);
// StObject.ServerTypeId = RetnSTypebject.ID;
if (strsname != "")
{
string SqlQuery = "";
//if (StObject.RoleType == null)
//{
// StObject.RoleType = "";
//}
SqlQuery = "select * from NetworkLatencyServers where ServerID='" + strsname + "' ";
dt = objAdaptor.FetchData(SqlQuery);
if (dt.Rows.Count > 0)
{
SqlQuery = "UPDATE NetworkLatencyServers set Enabled='" + StObject.Enabled + "',LatencyRedThreshold='" + StObject.LatencyRedThreshold + "',LatencyYellowThreshold='" + StObject.LatencyYellowThreshold +
"'where ServerID='" + strsname + "'";
Update = objAdaptor.ExecuteNonQueryRetRows(SqlQuery);
}
}
}
catch
{
Update = 0;
}
if (Update == 0)
{
try
{
string SqlQuery = "";
SqlQuery = "Insert into NetworkLatencyServers(ServerID,NetworkLatencyId,LatencyYellowThreshold , LatencyRedThreshold , Enabled) values" +
//"ActiveSyncCredentialsId) values" +
"(" + StObject.ServerID + ",'" + StObject.NetworkLatencyId + "','" +
StObject.LatencyYellowThreshold + "','" + StObject.LatencyRedThreshold + "','" + StObject.Enabled + "')";
Update = objAdaptor.ExecuteNonQueryRetRows(SqlQuery);
}
catch
{
Update = 0;
}
}
if (Update == 1)
{
UpdateRet = true;
}
return(UpdateRet);
}
public DataTable GetName(NetworkLatency nlobj)
{
try
{
return(VSWebDAL.ConfiguratorDAL.NetworkLatencyDAL.Ins.GetName(nlobj));
}
catch (Exception ex)
{
throw ex;
}
}
public bool Updatelatency(NetworkLatency StObject, string id, string name)
{
try
{
return(VSWebDAL.ConfiguratorDAL.NetworkLatencyDAL.Ins.Updatelatency(StObject, id, name));
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// Call to Update Data of DominoServers based on Key
/// </summary>
/// <param name="DominoClusterObject">DominoServers object</param>
/// <returns>Object</returns>
public Object UpdateData(NetworkLatency NetworkLatencyObject)
{
try
{
return(VSWebDAL.ConfiguratorDAL.NetworkLatencyDAL.Ins.UpdateData(NetworkLatencyObject));
}
catch (Exception ex)
{
throw ex;
}
}
public bool UpdateeditProfiles(NetworkLatency StObject, string strsname)
{
try
{
return(VSWebDAL.ConfiguratorDAL.NetworkLatencyDAL.Ins.UpdateeditProfiles(StObject, strsname));
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// Call to Get Data from DominoCluster based on Primary key
/// </summary>
/// <param name="DominoClusterObject">DominoClusterObject object</param>
/// <returns></returns>
public NetworkLatency GetData(NetworkLatency nwlatency)
{
try
{
return(VSWebDAL.ConfiguratorDAL.NetworkLatencyDAL.Ins.GetData(nwlatency));
}
catch (Exception ex)
{
throw ex;
}
}
protected override void OnDisabled()
{
base.OnDisabled();
SyncSenderThread?.Wait(500);
ServerStartTime = 0;
ClockOffset.Clear();
NetworkLatency.Clear();
Synced = false;
ClockOffsetAverage = 0;
NetworkLatencyAverage = 0;
ServerLag = 0;
}
protected void FormSaveButton_Click(object sender, EventArgs e)
{
NetworkLatency nl = new NetworkLatency();
// st.svalue = Enreportcheckbox.Checked.ToString();
object blret = VSWebBL.ConfiguratorBL.NetworkLatencyBL.Ins.UpdateData(nl);
//Object result1 = VSWebBL.ExchangeBAL.Ins.UpdateExchangeSettingsData(CollectDataforExchangeSettings());
DataTable nwDataTable = (DataTable)Session["NetworkLatency"];
FillNwlatencyServerGrid(ServerTypeComboBox.SelectedItem.Text);
successDiv.Style.Value = "display: block";
}
private void FillNwlatencyServerGrid(string servertype)
{
try
{
DataTable networklatencyDataTable = new DataTable();
NetworkLatency NetworkLatencyObject = new NetworkLatency();
networklatencyDataTable = VSWebBL.ConfiguratorBL.NetworkLatencyBL.Ins.Getvalue();
if ((scantext.Text == null) || (scantext.Text == ""))
{
scantext.Text = "8";
}
else
{
scantext.Text = networklatencyDataTable.Rows[0]["ScanInterval"].ToString();
}
if ((testduration.Text == null) || (testduration.Text == ""))
{
testduration.Text = "5";
}
else
{
testduration.Text = networklatencyDataTable.Rows[0]["TestDuration"].ToString();
}
groupname.Text = networklatencyDataTable.Rows[0]["TestDuration"].ToString();
nwDataTable = VSWebBL.ConfiguratorBL.NetworkLatencyBL.Ins.GetAllData1(ServerTypeComboBox.SelectedItem.Text);
// for(int i=0;i>d)
//{
//ID
//insert in to network table
//}
DataColumn[] columns = new DataColumn[1];
columns[0] = nwDataTable.Columns["ServerID"];
nwDataTable.PrimaryKey = columns;
Session["NetworkLatency"] = nwDataTable;
NetworkLatencyTestgrd.DataSource = nwDataTable;
NetworkLatencyTestgrd.DataBind();
}
catch (Exception ex)
{
Log.Entry.Ins.WriteHistoryEntry(DateTime.Now.ToString() + " Exception - " + ex);
throw ex;
}
finally { }
}
protected void nlGridView1_RowDeleting(object sender, DevExpress.Web.Data.ASPxDataDeletingEventArgs e)
{
NetworkLatency LocObject = new NetworkLatency();
LocObject.NetworkLatencyId = Convert.ToInt32(e.Keys[0]);
//Delete row from DB
Object ReturnValue = VSWebBL.ConfiguratorBL.NetworkLatencyBL.Ins.DeleteData(LocObject.NetworkLatencyId.ToString());
//Update Grid after inserting new row, refresh grid as in page load
ASPxGridView gridView = (ASPxGridView)sender;
gridView.CancelEdit();
e.Cancel = true;
FillnetworknlGrid();
}
private void InsertNetworkLatency()
{
NetworkLatency ClsObj = new NetworkLatency();
ClsObj.Name = ClsAttNameTextBox.Text;
DataTable returntable = VSWebBL.ConfiguratorBL.NetworkLatencyBL.Ins.GetIPAddress(ClsObj);
if (returntable.Rows.Count > 0)
{
ErrorMessageLabel.Text = "This Latency name is already in use. Please enter a different server name.";
ErrorMessagePopupControl.ShowOnPageLoad = true;
flag = true;
ClsAttNameTextBox.Focus();
}
else
{
try
{
object ReturnValue = VSWebBL.ConfiguratorBL.NetworkLatencyBL.Ins.InsertData(CollectDataForNetworkLatency());
SetFocusOnError(ReturnValue);
if (ReturnValue.ToString() == "True")
{
ErrorMessageLabel.Text = "Latency record created successfully.";
ErrorMessagePopupControl.HeaderText = "Information";
ErrorMessagePopupControl.ShowCloseButton = false;
ValidationUpdatedButton.Visible = true;
ValidationOkButton.Visible = false;
ErrorMessagePopupControl.ShowOnPageLoad = true;
}
else
{
flag = true;
}
}
catch (Exception ex)
{
//6/27/2014 NS added for VSPLUS-634
Log.Entry.Ins.WriteHistoryEntry(DateTime.Now.ToString() + " Exception - " + ex);
throw ex;
}
finally { }
}
}
/// <summary>
/// Get all Data from DominoCluster
/// </summary>
public DataTable GetAllData()
{
DataTable networklatencyDataTable = new DataTable();
NetworkLatency ReturnDCObject = new NetworkLatency();
try
{
string SqlQuery = "SELECT ID,Enabled,Name,ScanInterval,TestDuration FROM NetworkLatency";
networklatencyDataTable = objAdaptor.FetchData(SqlQuery);
}
catch (Exception ex)
{
throw ex;
}
finally
{
}
return(networklatencyDataTable);
}
/// <summary>
/// Update data into DominoCluster table
/// </summary>
/// <param name="DSObject">DominoServers object</param>
/// <returns></returns>
public Object UpdateData(NetworkLatency NLObject)
{
Object Update;
try
{
string SqlQuery = "UPDATE NetworkLatency SET TestName='" + NLObject.TestName + "', " +
"ScanInterval='" + NLObject.ScanInterval + "', " +
"TestDuration='" + NLObject.TestDuration + "' ,Enable='" + NLObject.Enable + "'" +
"WHERE NetworkLatencyId = " + NLObject.NetworkLatencyId + "";
Update = objAdaptor.ExecuteNonQuery(SqlQuery);
}
catch
{
Update = false;
}
finally
{
}
return(Update);
}
/// <summary>
/// Insert data into DominoCluster table
/// </summary>
/// <param name="DSObject">DominoServers object</param>
/// <returns></returns>
public bool InsertData(NetworkLatency NLObject)
{
bool Insert = false;
try
{
string SqlQuery = "INSERT INTO NetworkLatency ([TestName] ,[ScanInterval],[TestDuration],Enable) " +
"VALUES('" + NLObject.TestName + "'," + NLObject.ScanInterval +
"," + NLObject.TestDuration + ",'" + NLObject.Enable + "')";
Insert = objAdaptor.ExecuteNonQuery(SqlQuery);
}
catch
{
Insert = false;
}
finally
{
}
return(Insert);
}
//private void FillServerTypeComboBox()
//{
// DataTable ServerDataTable = VSWebBL.SecurityBL.ServerTypesBL.Ins.GetSpecificServerTypes();
// //DataTable ServerDataTable = VSWebBL.SecurityBL.AdminTabBL.Ins.GetNavigatorChildsByRefName("ServersDevices");
// servertypecombo.DataSource = ServerDataTable;
// servertypecombo.TextField = "ServerType";
// servertypecombo.ValueField = "ServerType";
// servertypecombo.DataBind();
//}
private DataTable FillNwlatencyServerGrid()
{
try
{
//10/21/2015 NS added for VSPLUS-2223
DataTable selectedserversDT = new DataTable();
DataTable networklatencyDataTable = new DataTable();
NetworkLatency NetworkLatencyObject = new NetworkLatency();
networklatencyDataTable = VSWebBL.ConfiguratorBL.NetworkLatencyBL.Ins.Getvalue1(ServerKey);
if (networklatencyDataTable.Rows.Count > 0)
{
txtscaninterval.Text = networklatencyDataTable.Rows[0]["ScanInterval"].ToString();
txtduration.Text = networklatencyDataTable.Rows[0]["TestDuration"].ToString();
testtxtname.Text = networklatencyDataTable.Rows[0]["TestName"].ToString();
SrvAtrScanCheckBox.Checked = (networklatencyDataTable.Rows[0]["Enable"].ToString() == "True" ? true : false);
}
if ((txtscaninterval.Text == null) || (txtscaninterval.Text == ""))
{
txtscaninterval.Text = "8";
}
if ((txtduration.Text == null) || (txtduration.Text == ""))
{
txtduration.Text = "5";
}
string Page = "NetworkLatencyTestServers.aspx";
string Control = "NetworkLatencyTestgrd";
nwDataTable = VSWebBL.ConfiguratorBL.NetworkLatencyBL.Ins.GetAllData2(ServerKey, Page, Control);
//7/16/2015 NS commented out for VSPLUS-1511
//DataColumn[] columns = new DataColumn[1];
//columns[0] = nwDataTable.Columns["ID"];
//nwDataTable.PrimaryKey = columns;
//nwDataTable.PrimaryKey = new DataColumn[] { nwDataTable.Columns["ID"] };
nwDataTable.Columns.Add("Isselected", typeof(System.Boolean));
//10/21/2015 NS added for VSPLUS-2223
NetworkLatencyTestgrd.DataSource = nwDataTable;
selectedserversDT = VSWebBL.ConfiguratorBL.NetworkLatencyBL.Ins.GetSelectedServers(ServerKey, Page, Control);
if (selectedserversDT.Rows.Count > 0)
{
DataRow[] foundRows;
for (int i = 0; i < selectedserversDT.Rows.Count; i++)
{
foundRows = nwDataTable.Select("ID=" + selectedserversDT.Rows[i]["ID"].ToString() + " AND ServerTypeId=" + selectedserversDT.Rows[i]["ServerTypeId"].ToString());
if (foundRows.Length > 0)
{
foundRows[0]["Enabled"] = true;
foundRows[0]["LatencyYellowThreshold"] = Convert.ToInt32(selectedserversDT.Rows[i]["LatencyYellowThreshold"].ToString());
foundRows[0]["LatencyRedThreshold"] = Convert.ToInt32(selectedserversDT.Rows[i]["LatencyRedThreshold"].ToString());
}
}
nwDataTable.AcceptChanges();
}
Session["NetworkLatency"] = nwDataTable;
NetworkLatencyTestgrd.DataSource = nwDataTable;
NetworkLatencyTestgrd.DataBind();
return(nwDataTable);
}
catch (Exception ex)
{
Log.Entry.Ins.WriteHistoryEntry(DateTime.Now.ToString() + " Exception - " + ex);
throw ex;
}
finally { }
}
public bool Updatelatency(NetworkLatency StObject, string id, string name)
{
DataTable dt = new DataTable();
bool UpdateRet = false;
int Update = 0;
try
{
if (id != "")
{
string SqlQuery = "";
//if (StObject.RoleType == null)
//{
// StObject.RoleType = "";
//}
//10/21/2015 NS modified for VSPLUS-2223
/*
* SqlQuery = "select * from NetworkLatencyServers where ServerID='" + id + "' and [NetworkLatencyId]='"+StObject.NetworkLatencyId+"' ";
* dt = objAdaptor.FetchData(SqlQuery);
* if (dt.Rows.Count > 0)
* {
* SqlQuery = "update NetworkLatencyServers set LatencyYellowThreshold=" + StObject.LatencyYellowThreshold + ", LatencyRedThreshold=" + StObject.LatencyRedThreshold + ",Enabled='" + StObject.Enabled + "' where ServerID=" + id;
*
* Update = objAdaptor.ExecuteNonQueryRetRows(SqlQuery);
* }
*/
if (StObject.Enabled)
{
SqlQuery = "INSERT INTO NetworkLatencyServers(ServerID,NetworkLatencyId,LatencyYellowThreshold,LatencyRedThreshold,Enabled) VALUES" +
"(" + id + ", " + StObject.NetworkLatencyId + ",'" +
StObject.LatencyYellowThreshold + "','" + StObject.LatencyRedThreshold + "','" + StObject.Enabled + "')";
Update = objAdaptor.ExecuteNonQueryRetRows(SqlQuery);
}
}
}
catch
{
Update = 0;
}
if (Update == 0)
{
try
{
string SqlQuery = "";
DataTable networklatency = new DataTable();
string sqlQuery;
sqlQuery = "select [NetworkLatencyId] from [NetworkLatency] where [TestName]='" + name + "'";
networklatency = objAdaptor.FetchData(sqlQuery);
if (networklatency.Rows.Count > 0)
{
//10/21/2015 NS modified for VSPLUS-2223
if (StObject.Enabled)
{
SqlQuery = "Insert into NetworkLatencyServers(ServerID,NetworkLatencyId,LatencyYellowThreshold , LatencyRedThreshold , Enabled) values" +
//"ActiveSyncCredentialsId) values" +
"(" + id + ", " + Convert.ToInt32(networklatency.Rows[0]["NetworkLatencyId"]) + ",'" +
StObject.LatencyYellowThreshold + "','" + StObject.LatencyRedThreshold + "','" + StObject.Enabled + "')";
Update = objAdaptor.ExecuteNonQueryRetRows(SqlQuery);
}
}
}
catch
{
Update = 0;
}
}
if (Update == 1)
{
UpdateRet = true;
}
return(UpdateRet);
}
void Awake()
{
Instance = this;
}
