public void TestMethodInsertIntoUserData() { Boolean expectedInsert = true; Boolean expectedDelete = true; string expectedUserName = "******"; string expectedPassword = "******"; string expectedFullName = "John Sampleson"; string expectedType = "SA"; List <object> bookstore = new List <object>( new object[] { expectedUserName, expectedPassword, expectedType, 0, expectedFullName } ); Boolean actualInsert = dbQ.INSERT_INTO_TABLE("UserData", bookstore); //Insert method for database Assert.AreEqual(expectedInsert, actualInsert); ds = dbQ.SELECT_FROM_TABLE("SELECT * FROM UserData WHERE UserName = '******'"); string actualUserName = ds.Tables[0].Rows[0]["UserName"].ToString(); string actualPassword = ds.Tables[0].Rows[0]["Password"].ToString(); string actualFullName = ds.Tables[0].Rows[0]["FullName"].ToString(); string actualType = ds.Tables[0].Rows[0]["Type"].ToString(); Assert.AreEqual(expectedUserName, actualUserName); Assert.AreEqual(expectedPassword, actualPassword); Assert.AreEqual(expectedFullName, actualFullName); Assert.AreEqual(expectedType, actualType); Boolean actualDelete = dbQ.DELETE_FROM_TABLE("DELETE FROM UserData WHERE UserName = '******'"); Assert.AreEqual(expectedDelete, actualDelete); }
public void TestMethodRegisterUser() { inputName = "TestUser"; inputPassword = "******"; inputPasswordV = "ts0987"; inputFullName = "TestUserFull"; bool expectedRegister = true; bool expectedLogin = true; bool expectedDelete = true; var c = new SqlConnection(Properties.Settings.Default.dbConnectionString); bool actualRegister = userRegister.Register(inputName, inputPassword, inputPasswordV, inputFullName); bool actualLogin = userData.LogIn(inputName, inputPassword); int actualUserId = userData.UserID; ds = dbQ.SELECT_FROM_TABLE("SELECT * FROM UserData WHERE UserName = '******'"); int expectedUserId = Int32.Parse(ds.Tables[0].Rows[0]["UserID"].ToString()); Assert.AreEqual(expectedRegister, actualRegister); Assert.AreEqual(expectedLogin, actualLogin); Assert.AreEqual(expectedUserId, actualUserId); DBDelete dbD = new DBDelete(); bool actualDelete = dbD.deleteRow("DELETE FROM UserData WHERE UserName = '******'", c); Assert.AreEqual(expectedDelete, actualDelete); c.Close(); }
public void TestMethodDeleteFromSupplier() { var c = new SqlConnection(Properties.Settings.Default.dbConnectionString); Boolean expectedInsert = true; Boolean expectedDelete = true; string expectedName = "Google"; int expectedSupplierID = dbG.GetID("Supplier", c); List <object> bookstore = new List <object>( new object[] { expectedName } ); Boolean actualInsert = dbQ.INSERT_INTO_TABLE("Supplier", bookstore); Assert.AreEqual(expectedInsert, actualInsert); ds = dbQ.SELECT_FROM_TABLE("SELECT * FROM Supplier WHERE Name = '" + expectedName + "'"); int actualSupplierID = Int32.Parse(ds.Tables[0].Rows[0]["SupplierId"].ToString()); string actualName = ds.Tables[0].Rows[0]["Name"].ToString(); Assert.AreEqual(expectedSupplierID, actualSupplierID); Assert.AreEqual(expectedName, actualName); //Delete from Database Boolean actualDelete = dbQ.DELETE_FROM_TABLE("DELETE FROM Supplier WHERE Name = '" + expectedName + "'"); Assert.AreEqual(expectedDelete, actualDelete); Boolean expectedFinalDeleteReturn = true; Boolean finalDeleteReturn = false; ds = dbQ.SELECT_FROM_TABLE("SELECT * FROM Supplier WHERE Name = '" + expectedName + "'"); if (ds.Tables[0].Rows.Count == 0) { finalDeleteReturn = true; } Assert.AreEqual(expectedFinalDeleteReturn, finalDeleteReturn); c.Close(); }
public void TestDatabaseSelectFromBookData() { int expectedCategoryID = 2; int expectedSupplierID = 1; int expectedYear = 2002; int expectedEdition = 1; double expectedPrice = 70.40; string expectedISBN = "0135974445"; string expectedTitle = "Agile Software Development, Principles, Patterns, and Practices"; string expectedAuthor = "Robert C. Martin"; string expectedPublisher = "Pearson"; string expectedDescription = "Written by a software developer for software developers, this book is a unique collection of the latest software development methods. The author includes OOD, UML, Design Patterns, Agile and XP methods with a detailed description of a complete software design for reusable programs in C++ and Java."; ds = dbQ.SELECT_FROM_TABLE("SELECT * FROM BookData WHERE ISBN = '" + expectedISBN + "'"); int actualCategoryID = Int32.Parse(ds.Tables[0].Rows[0]["CategoryID"].ToString()); int actualSupplierID = Int32.Parse(ds.Tables[0].Rows[0]["SupplierId"].ToString()); int actualYear = Int32.Parse(ds.Tables[0].Rows[0]["Year"].ToString()); int actualEdition = Int32.Parse(ds.Tables[0].Rows[0]["Edition"].ToString()); double actualPrice = Double.Parse(ds.Tables[0].Rows[0]["Price"].ToString()); string actualISBN = ds.Tables[0].Rows[0]["ISBN"].ToString(); string actualTitle = ds.Tables[0].Rows[0]["Title"].ToString(); string actualAuthor = ds.Tables[0].Rows[0]["Author"].ToString(); string actualPublisher = ds.Tables[0].Rows[0]["Publisher"].ToString(); string actualDescription = ds.Tables[0].Rows[0]["Description"].ToString(); Assert.AreEqual(expectedCategoryID, actualCategoryID); Assert.AreEqual(expectedSupplierID, actualSupplierID); Assert.AreEqual(expectedYear, actualYear); Assert.AreEqual(expectedEdition, actualEdition); Assert.AreEqual(expectedPrice, actualPrice); Assert.AreEqual(expectedISBN, actualISBN); Assert.AreEqual(expectedTitle, actualTitle); Assert.AreEqual(expectedAuthor, actualAuthor); Assert.AreEqual(expectedPublisher, actualPublisher); Assert.AreEqual(expectedDescription, actualDescription); }