public ActionResult Database() { SQLTestData sd = new SQLTestData() { Advanced = CloudConfigurationManager.GetSetting("Advanced") == "true" }; if (sd.Advanced) { sd.SQLConnection = System.Configuration.ConfigurationManager.ConnectionStrings["CorpDataConnectionString"].ConnectionString; sd.MySQLConnection = System.Configuration.ConfigurationManager.ConnectionStrings["CustomerDataConnectionString"].ConnectionString; } ViewBag.Result = new DataTestResult(); return(View(sd)); }
public DataTestResult TestMySQL(SQLTestData data) { DataTestResult result = new DataTestResult(); try { MySqlConnection conn = new MySqlConnection(data.MySQLConnection); string SQL = "SELECT * FROM customer;"; MySqlCommand cmd = new MySqlCommand(SQL, conn); conn.Open(); try { var rdr = cmd.ExecuteReader(); while (rdr.Read()) { result.Customers.Add(new Customer { id = (int)rdr["id"], name = rdr["name"].ToString() }); } if (result.Customers.Count == 0) { result.Passed = false; result.Status = "The connection to MySQL is correct but returned no data"; } else { result.Passed = true; result.Status = "Passed all MySQL tests."; } } finally { conn.Close(); } } catch (Exception ex) { result.Passed = false; result.Status = $"Encountered an error: {ex.Message}"; } return(result); }
public DataTestResult TestSQLServer(SQLTestData data) { DataTestResult result = new DataTestResult(); try { using (var conn = new SqlConnection(data.SQLConnection)) { var SQL = "SELECT * FROM Sales.SalesPerson;"; var cmd = new SqlCommand(SQL, conn); conn.Open(); var rdr = cmd.ExecuteReader(); while (rdr.Read()) { result.SalesPeople.Add(new SalesPerson { ID = (int)rdr["ID"], FirstName = rdr["FirstName"].ToString(), LastName = rdr["LastName"].ToString(), Phone = rdr["Phone"].ToString() }); } if (result.SalesPeople.Count == 0) { result.Passed = false; result.Status = "The connection to SQL Server worked, but there was no data"; } else { result.Passed = true; result.Status = "Passed all SQL Server tests."; } } } catch (Exception ex) { result.Passed = false; result.Status = $"Encountered an error: {ex.Message}"; } return(result); }
public ActionResult Database(SQLTestData data) { var test = new TestProcessor(); DataTestResult result = new DataTestResult(); if (TestType.TestSQLServer && TestType.TestMySQL) { var sqlResult = test.TestSQLServer(data); var mySqlResult = test.TestMySQL(data); result = new DataTestResult(sqlResult, mySqlResult); } else if (TestType.TestSQLServer) { result = test.TestSQLServer(data); } else { result = test.TestMySQL(data); } result.Ignore = false; ViewBag.Result = result; return(View(data)); }