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