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; } }