private ProfileController NewController() { List <Claim> claims = new List <Claim>() { // Passing in username as parameter new Claim(ClaimTypes.Name, "Ted"), }; ClaimsIdentity identity = new ClaimsIdentity(claims, "TestAuthType"); ClaimsPrincipal claimsPrincipal = new ClaimsPrincipal(identity); UserSqlDAO userDao = new UserSqlDAO(ConnectionString); ProfileSqlDAO profileDao = new ProfileSqlDAO(ConnectionString); ProfileController controller = new ProfileController(userDao, profileDao) { ControllerContext = new ControllerContext() { HttpContext = new DefaultHttpContext() { User = claimsPrincipal } } }; return(controller); }
// This unit test is designed to verify the AddFoodItem method is adding a new row on the user db table public void AddFoodItem_ShouldAddNewRowItem() { //ARRANGE FoodSqlDAO foodItemDAO = new FoodSqlDAO("Server=.\\SQLEXPRESS;Database=DemoDB;Trusted_Connection=True;"); UserSqlDAO userDAO = new UserSqlDAO("Server=.\\SQLEXPRESS;Database=DemoDB;Trusted_Connection=True;"); //ACT User user = new User() { Username = "******", Password = "******", Salt = "salt", Role = "role" }; userDAO.CreateUser(user); Food item = new Food() { Calories = 1000, Name = "Salami", Fat = 20, Carbs = 10, Protein = 30, MealType = "Lunch", Servings = 3, Date = DateTime.Now, ndbno = 200 }; foodItemDAO.AddFoodItem(user.Id, item); int actual = this.GetRowCount("food_entries"); //ASSERT Assert.AreEqual(2, actual); }
// This is an integration test comparing ability of adding an associated profile to a user public void CreateProfile_ShouldAddNewRowItem() { //ARRANGE ProfileSqlDAO profileDAO = new ProfileSqlDAO("Server=.\\SQLEXPRESS;Database=DemoDB;Trusted_Connection=True;"); UserSqlDAO userDAO = new UserSqlDAO("Server=.\\SQLEXPRESS;Database=DemoDB;Trusted_Connection=True;"); //ACT User user = new User() { Username = "******", Password = "******", Salt = "salt", Role = "role" }; user.Id = (userDAO.CreateUser(user)).Id; Profile profile = new Profile() { UserId = user.Id, Name = "Name", CurrentWeight = 100, GoalWeight = 200, BirthDate = DateTime.Today, Feet = 6, Inches = 9, ActivityLevel = "moderate", Gender = 'F', Timeline = "Maintain", UserImage = "" }; profileDAO.CreateProfile(profile); int actual = this.GetRowCount("user_profiles"); //ASSERT Assert.AreEqual(2, actual); }
public void CreateTransfer_test(string senderUsername, string receiverUsername, int transferType, double amount) { //todo this should be in the TransferController test. If we knew how to test controllers that is... //arrange AccountSqlDAO accountDao = new AccountSqlDAO(connectionString); UserSqlDAO userDao = new UserSqlDAO(connectionString); int senderAccountId = (int)accountDao.GetDefaultAccountIdForUserId(userDao.GetApiUser(senderUsername).UserId); int receiverAccountId = (int)accountDao.GetDefaultAccountIdForUserId(userDao.GetApiUser(receiverUsername).UserId); TransferStatus transferStatus = transferType == (int)TransferType.Send ? TransferStatus.Approved : TransferStatus.Pending; Transfer transferToCreate = new Transfer() { AccountFromId = senderAccountId, AccountToId = receiverAccountId, TransferType = (TransferType)transferType, TransferStatus = transferStatus, Amount = (decimal)amount }; //act Transfer actualTransfer = dao.CreateTransfer(transferToCreate); //assert Assert.IsNotNull(actualTransfer); Assert.AreEqual(transferToCreate.AccountFromId, actualTransfer.AccountFromId); Assert.AreEqual(senderUsername, actualTransfer.UsernameFrom); Assert.AreEqual(transferToCreate.AccountToId, actualTransfer.AccountToId); Assert.AreEqual(receiverUsername, actualTransfer.UsernameTo); Assert.AreEqual(transferToCreate.TransferType, actualTransfer.TransferType); Assert.AreEqual(transferToCreate.TransferStatus, actualTransfer.TransferStatus); Assert.AreEqual(transferToCreate.Amount, actualTransfer.Amount); }
public void TestInitializer() { this.transaction = new TransactionScope(); connectionString = "Data Source=.\\SQLEXPRESS;Initial Catalog=DemoDB;Integrated Security=True"; dao = new UserSqlDAO(connectionString); }
public void Test_DeleteUser() { UserSqlDAO testDAO = new UserSqlDAO(connectionString); AddTestUser(); User testUser = testDAO.GetUser("usernameTest"); Assert.AreEqual(true, testDAO.DeleteUser(testUser)); }
public void GetUserTest() { UserSqlDAO access = new UserSqlDAO(connectionString); User user = access.GetUser("notauser"); Assert.IsNotNull(user); Assert.AreEqual("user", user.Role); }
public void Test_GetUser() { UserSqlDAO testDAO = new UserSqlDAO(connectionString); int newUserId = AddTestUser(); Assert.AreEqual("usernameTest", testDAO.GetUser("usernameTest").Username); Assert.AreEqual("passwordTest", testDAO.GetUser("usernameTest").Password); Assert.AreEqual("roleTest", testDAO.GetUser("usernameTest").Role); Assert.AreEqual("saltTest", testDAO.GetUser("usernameTest").Salt); }
public void Test_CreateUser() { UserSqlDAO testDAO = new UserSqlDAO(connectionString); User testUser = new User(); testUser.Password = "******"; testUser.Username = "******"; testUser.Role = "role"; testUser.Salt = "salt"; Assert.AreEqual(true, testDAO.CreateUser(testUser)); }
public void AddUserTest() { UserSqlDAO access = new UserSqlDAO(connectionString); User user = access.AddUser("anotheruser", "password", "admin"); Assert.IsNotNull(user); Assert.AreEqual("admin", user.Role); user = access.GetUser("anotheruser"); Assert.IsNotNull(user); Assert.AreEqual("admin", user.Role); }
// This unit test is designed to verify the CreateUser method is adding a new row on the user db table public void CreateUser_ShouldAddNewRowItem() { //ARRANGE UserSqlDAO userDAO = new UserSqlDAO("Server=.\\SQLEXPRESS;Database=DemoDB;Trusted_Connection=True;"); //ACT User user = new User() { Username = "******", Password = "******", Salt = "salt", Role = "role" }; userDAO.CreateUser(user); int actual = this.GetRowCount("users"); //ASSERT Assert.AreEqual(2, actual); }
public MyHangmanController(UserSqlDAO userDAO) { this.userDAO = userDAO; }
public void ArrangeForEachTest() { this.dao = new UserSqlDAO(connectionString); SetupDB(); }
public static void Main(string[] args) { IUserDAO userDAO = new UserSqlDAO(@"Data Source =.\SQLEXPRESS;Initial Catalog = tenmo; Integrated Security = True"); CreateWebHostBuilder(args).Build().Run(); }
public override void Setup() { base.Setup(); dao = new UserSqlDAO(connectionString); }