public void Assignment_UpdateUser_Test() { //Arrange UserSqlDAL dao = new UserSqlDAL(ConnectionString); User inputUser = new User(); inputUser.Password = "******"; inputUser.Salt = "NuE0Y6FonAI="; inputUser.Role = "Teacher"; inputUser.Username = "******"; dao.CreateUser(inputUser); inputUser = dao.GetUser(inputUser.Username); inputUser.Role = "Admin"; dao.UpdateUser(inputUser); //Action User testUser = dao.GetUser(inputUser.Username); //Assert Assert.AreEqual(testUser.Role, inputUser.Role); }
/// <summary> /// Signs the user in and saves their username in session. /// </summary> /// <param name="username"></param> /// <param name="password"></param> /// <returns></returns> public bool SignIn(string username, string password) { var user = userDAL.GetUser(username); var hashProvider = new HashProvider(); if (user != null && hashProvider.VerifyPasswordMatch(user.UserPassword, password, user.Salt)) { Session.SetString(SessionKey, user.UserEmail); return(true); } return(false); }
public void Assignment_DeleteUser_Test() { //Arrange UserSqlDAL dao = new UserSqlDAL(ConnectionString); User inputUser = new User(); inputUser.Password = "******"; inputUser.Salt = "NuE0Y6FonAI="; inputUser.Role = "Teacher"; inputUser.Username = "******"; dao.CreateUser(inputUser); int test = GetRowCount("users"); inputUser = dao.GetUser(inputUser.Username); //Action dao.DeleteUser(inputUser); int result = GetRowCount("users"); //Assert Assert.AreEqual(result, test - 1); }
public void GetUserTest() { UserSqlDAL dal = new UserSqlDAL(ConnectionString); User user = dal.GetUser("luteMan"); Assert.IsNotNull(user); }
public ActionResult Login(User model) { UserSqlDAL userDal = new UserSqlDAL(connectionString); User user = userDal.GetUser(model.Email); if (user.Email == null || user.Password != model.Password) { ModelState.AddModelError("invalid-credentials", "An invalid email or password was provided"); return(View("Login", model)); } //if user clicked on 'cards' or 'decks' before logging in, take them there now Session["userid"] = user.Id; Session["admin"] = user.IsAdmin; switch (Session["anon"].ToString()) { case "Cards": return(RedirectToAction("Index", "Card")); case "Decks": return(RedirectToAction("Index", "Deck")); default: return(RedirectToAction("Index", "Home")); } }
public void ShouldReturnUser() { UserSqlDAL dao = new UserSqlDAL(connectionString); string username = "******"; User user = dao.GetUser(username); Assert.AreEqual("IvoryUnclerico", user); }
public ActionResult CreateProfile(UserProfile userProfile) { var checkExists = userSqlDAL.GetUser(userProfile.UserEmail); if (checkExists != null) { return(View("CreateProfileUserNameTaken")); } var hashedPasswordAndSalt = hashProvider.HashPassword(userProfile.UserPassword); userProfile.UserPassword = hashedPasswordAndSalt.Password; userProfile.Salt = hashedPasswordAndSalt.Salt; userSqlDAL.CreateUser(userProfile); SaveUserSession(userProfile.UserEmail); return(RedirectToAction("Survey", "Home")); //Jarrod: changed this to redirect to the survey, before it was going to profile and crashing because they hadnt made a profile yet }
public IActionResult Index() { string currentUserName = HttpContext.Session.Get <string>(USERNAMEKEY); User currentUser = userDAL.GetUser(currentUserName); if (currentUser.Role != "admin") { return(RedirectToAction("NotAuthorized")); } else { return(View()); } }
public ActionResult Register(User model) { if (!ModelState.IsValid) { return(View("Register", model)); } UserSqlDAL newUserDAL = new UserSqlDAL(connectionString); //attempt to retrieve provided email - cannot duplicate existing User newUser = newUserDAL.GetUser(model.Email); if (newUser.Email == null) { newUser.Email = model.Email; newUser.Password = model.Password; if (model.DisplayName == null) { newUser.DisplayName = model.Email.Substring(0, model.Email.IndexOf('@')); } else { newUser.DisplayName = model.DisplayName; } newUserDAL.Register(newUser); User retriveUser = newUserDAL.GetUser(newUser.Email); Session["userid"] = retriveUser.Id; Session["admin"] = retriveUser.IsAdmin; } else { ModelState.AddModelError("email-exists", "That email address exists, please contact Admin for password reset if needed."); return(View("Register", model)); } return(RedirectToAction("Index", "Home")); }
public ActionResult Survey(Survey survey) { // // TODO Should we move RetrieveUserSession and SaveUserSession to a helper class? // // Otherwise, code is redundant UserProfile userProfile = userProfileSqlDAL.GetUser(RetrieveUserSession()); SurveyAnswers surveyAnswers = new SurveyAnswers(userProfile.UserEmail, survey.Business1, survey.State2, survey.Experience3, survey.NetWorth4, survey.Staff5, survey.HaveOwnedBusiness6, survey.WorkStyle7, survey.Industry8, survey.Challenges9, survey.Timeframe10); var testIfInDb = surveyAnswerDAL.GetSurveyResult(surveyAnswers.userEmail); if (testIfInDb.experience == null) { surveyAnswerDAL.SaveNewSurveyResult(surveyAnswers); } else { surveyAnswerDAL.UpdateSurveyResult(surveyAnswers); } return(RedirectToAction("ViewProfile", "Profile", userProfile)); }