public bool UpdateDatafortestsnew(IBMConnectionTests IBMConnectiondata)
{
string sqlQuery;
bool Update = false;
DataTable testdatatable = new DataTable();
try
{
sqlQuery = "select * from IBMConnectionsTests where ServerId='" + IBMConnectiondata.ServerId + "' and Id= '" + IBMConnectiondata.Id + "' ";
testdatatable = objAdaptor.FetchData(sqlQuery);
if (testdatatable.Rows.Count > 0)
{
sqlQuery = "UPDATE IBMConnectionsTests set ServerId='" + IBMConnectiondata.ServerId + "', EnableSimulationTests= '" + IBMConnectiondata.EnableSimulationTests + "',ResponseThreshold=" + IBMConnectiondata.ResponseThreshold + " WHERE ServerId='" + IBMConnectiondata.ServerId + "' and Id='" + IBMConnectiondata.Id + "'";
Update = objAdaptor.ExecuteNonQuery(sqlQuery);
}
else
{
string SqlQuery = "INSERT into IBMConnectionsTests (ServerId,EnableSimulationTests,ResponseThreshold,Id)" + //somaraj
"VALUES(" + IBMConnectiondata.ServerId + ", '" + IBMConnectiondata.EnableSimulationTests + "','" + IBMConnectiondata.ResponseThreshold + "','" + IBMConnectiondata.Id + "')";
Update = objAdaptor.ExecuteNonQuery(SqlQuery);
}
}
catch
{
Update = false;
}
finally
{
}
return(Update);
}
public Object UpdateDatafortestsnew(IBMConnectionTests IBMConnectiondata)
{
try
{
return(VSWebDAL.ConfiguratorDAL.IBMConnectionsServersDAL.Ins.UpdateDatafortestsnew(IBMConnectiondata));
}
catch (Exception ex)
{
throw ex;
}
}
