public bool UpdateDatafortestsnew(Office365Tests o365tests) { string sqlQuery; bool Update = false; DataTable testdatatable = new DataTable(); try { sqlQuery = "select Tests from Office365Tests where ServerId='" + o365tests.ServerId + "' and Tests= '" + o365tests.Tests + "' "; testdatatable = objAdaptor.FetchData(sqlQuery); if (testdatatable.Rows.Count > 0) { sqlQuery = "UPDATE Office365Tests set ServerId='" + o365tests.ServerId + "', EnableSimulationTests= '" + o365tests.EnableSimulationTests + "',ResponseThreshold=" + o365tests.ResponseThreshold + " ,Type='" + o365tests.Type + "',Tests='" + o365tests.Tests + "' WHERE ServerId='" + o365tests.ServerId + "' and Tests='" + o365tests.Tests + "'"; Update = objAdaptor.ExecuteNonQuery(sqlQuery); } else { string SqlQuery = "INSERT into Office365Tests (ServerId,Tests,EnableSimulationTests,ResponseThreshold,Type)" + //somaraj "VALUES(" + o365tests.ServerId + ",'" + o365tests.Tests + "', '" + o365tests.EnableSimulationTests + "','" + o365tests.ResponseThreshold + "','" + o365tests.Type + "')"; Update = objAdaptor.ExecuteNonQuery(SqlQuery); } } catch { Update = false; } finally { } return(Update); }
public Object InsertDatafortestsnew(Office365Tests o365testdata) { try { return(VSWebDAL.ConfiguratorDAL.O365ServerDAL.Ins.InsertDatafortestsnew(o365testdata)); } catch (Exception ex) { throw ex; } }
public DataTable GetIBMConnectionTestsData(int ID) { DataTable Office365TestsDataTable = new DataTable(); Office365Tests ReturnObject = new Office365Tests(); try { string SqlQuery = "Select TM.Tests,IT.EnableSimulationTests,IT.ResponseThreshold from IBMConnectionsTests IT inner join TestsMaster TM on IT.Id=TM.Id where ServerId=" + ID; Office365TestsDataTable = objAdaptor.FetchData(SqlQuery); } catch { } finally { } return(Office365TestsDataTable); }
public DataTable GetOffice365TestsData(int ID) { DataTable Office365TestsDataTable = new DataTable(); Office365Tests ReturnObject = new Office365Tests(); try { string SqlQuery = "Select * from Office365Tests where ServerId=" + ID; Office365TestsDataTable = objAdaptor.FetchData(SqlQuery); } catch { } finally { } return(Office365TestsDataTable); }
public bool InsertDatafortestsnew(Office365Tests o365tests) { string sqlQuery; bool Insert = false; try { DataTable TestsDetails = new DataTable(); DataTable TestsData = new DataTable(); sqlQuery = "Select * from O365Server where ID='" + o365tests.ServerId + "'"; TestsDetails = objAdaptor.FetchData(sqlQuery); if (TestsDetails.Rows.Count > 0) { //for (int i = 0; i < fieldValues.Count; i++) //{ //sqlQuery = "Select Id from Office365Tests where Tests='" + ((object[])(fieldValues[i]))[3] + "' and ServerId="+ Convert.ToInt32(TestsDetails.Rows[0]["id"]+""); //TestsData = objAdaptor.FetchData(sqlQuery); //if (TestsData.Rows.Count > 0) //{ // string SqlQuery = "UPDATE Office365Tests set EnableSimulationTests='" + ((object[])(fieldValues[i]))[1] + "', ResponseThreshold='" + ((object[])(fieldValues[i]))[2] + "' WHERE Id=" + ((object[])(fieldValues[i]))[0]; // Insert = objAdaptor.ExecuteNonQuery(SqlQuery); //} //string SqlQuery = "INSERT into Office365Tests (Id,ServerId,Tests,EnableSimulationTests,ResponseThreshold,Type)" +//somaraj // "VALUES(" + ((object[])(fieldValues[i]))[0] + "," + Convert.ToInt32(TestsDetails.Rows[0]["id"]) + ", '" + ((object[])(fieldValues[i]))[3] + "','" + ((object[])(fieldValues[i]))[1] + "','" + ((object[])(fieldValues[i]))[2] + "','" + ((object[])(fieldValues[i]))[4] + "')"; string SqlQuery = "INSERT into Office365Tests (ServerId,Tests,EnableSimulationTests,ResponseThreshold,Type)" + //somaraj "VALUES(" + o365tests.ServerId + ",'" + o365tests.Tests + "', '" + o365tests.EnableSimulationTests + "','" + o365tests.ResponseThreshold + "','" + o365tests.Type + "')"; Insert = objAdaptor.ExecuteNonQuery(SqlQuery); //} } } catch { Insert = false; } finally { } return(Insert); }