public void GetGreenCriteriaTest() { XmlRequestUtility xmlRequestUtility = new XmlRequestUtility(_elementsString); string criterianToTest = "customer='Happy Gilmore'"; string criterianTested = ""; criterianTested = xmlRequestUtility.GreenCriteria; Assert.AreEqual(criterianToTest, criterianTested); }
public void GetRedCriterianTest() { XmlRequestUtility xmlRequestUtility = new XmlRequestUtility(_elementsString); string criterianToTest = "customer='Burt'"; string criterianTested = ""; criterianTested = xmlRequestUtility.RedCriteria; Assert.AreEqual(criterianToTest, criterianTested); }
public void GetYellowCriteriaTest() { XmlRequestUtility xmlRequestUtility = new XmlRequestUtility(_elementsString); string criterianToTest = "customer='BobbyJoe'"; string criterianTested = ""; criterianTested = xmlRequestUtility.YellowCriteria; Assert.AreEqual(criterianToTest, criterianTested); }
public void GetSqlParameters() { try { XmlRequestUtility xmlRequestUtility = new XmlRequestUtility(_elementsString); var parameterList = xmlRequestUtility.SqlParameters; Assert.AreEqual(4, parameterList.Count); } catch (Exception e) { Console.WriteLine(e); throw; } }
public DynamicSqlAccess(string xmlRequest) { XmlRequestUtility request = new XmlRequestUtility(xmlRequest); _requestConnection = new DatabaseConnectionInfo() { ServerName = request.ServerName, CatalogName = request.CatalogName, Password = request.Password, ServerType = request.ServerType, UserName = request.UserName }; ConnectionFactory = () => new SqlConnection(CreateConnStr(_requestConnection)); }
public void GetServerNameTest() { try { XmlRequestUtility xmlRequestUtility = new XmlRequestUtility(_elementsString); string serverNameToTest = "sdisssql01"; string serverNameTested = ""; serverNameTested = xmlRequestUtility.ServerName; Assert.AreEqual(serverNameToTest, serverNameTested); } catch (Exception e) { Assert.AreEqual("ERROR 1 - Invalid Server Name", e.Message); } }
public void GetPasswordTest() { try { XmlRequestUtility xmlRequestUtility = new XmlRequestUtility(_elementsString); string passwordToTest = "MyUiEmployerUser"; string passwordTested = ""; passwordTested = xmlRequestUtility.Password; Assert.AreEqual(passwordToTest, passwordTested); } catch (Exception e) { Assert.AreEqual("ERROR 4 - Invalid Password", e.Message); } }
public void GetUserNameTest() { try { XmlRequestUtility xmlRequestUtility = new XmlRequestUtility(_elementsString); string userNameToTest = "MyUiEmployerUser"; string userNameTested = ""; userNameTested = xmlRequestUtility.UserName; Assert.AreEqual(userNameToTest, userNameTested); } catch (Exception e) { Assert.AreEqual("ERROR 3 - Invalid User Name", e.Message); } }
public void GetCatalogNameTest() { try { XmlRequestUtility xmlRequestUtility = new XmlRequestUtility(_elementsString); string catalogNameToTest = "MyUiEmployer"; string catalogNameTested = ""; catalogNameTested = xmlRequestUtility.CatalogName; Assert.AreEqual(catalogNameToTest, catalogNameTested); } catch (Exception e) { Assert.AreEqual("ERROR 2 - Invalid Catalog Name", e.Message); } }