public void AddUser(SharedModels.Models.UserModel user) { using (SqlConnection sqlConnection = new SqlConnection(_connectionString)) { sqlConnection.Open(); try { int insertedID = 0; using (SqlCommand command = new SqlCommand("INSERT INTO USERS OUTPUT INSERTED.ID VALUES(@name, @email, @password, @dob, @country, @avatar)", sqlConnection)) { command.Parameters.Add(new SqlParameter("name", user.Name)); command.Parameters.Add(new SqlParameter("email", user.Email)); command.Parameters.Add(new SqlParameter("password", user.Password)); command.Parameters.Add(new SqlParameter("dob", user.BirthDay)); command.Parameters.Add(new SqlParameter("country", user.Country)); command.Parameters.Add(new SqlParameter("avatar", DBNull.Value)); insertedID = (int)command.ExecuteScalar(); } /*if (insertedID > 0) * { * AddRegister(insertedID, sessionID, user.IP); * }*/ } catch (Exception e) { Console.WriteLine("Can't insert de new User"); throw new Exception(@"Can't insert a new User", e); } } }
public ActionResult logIn(SharedModels.Models.UserModel user) { Helpers.Utils.validateUser(user); ConnectionsManager.Users conn = new ConnectionsManager.Users(CONNECTIONSTRING); int idUser = conn.existUser(user.Email, user.Password); if (idUser > 0) { if (_session == null) { _session = new Helpers.SessionManager(); _session.setIsLoggedIn(user.Email); FormsAuthentication.SetAuthCookie(user.Email, false); } else { _session.setIsLoggedIn(user.Email); FormsAuthentication.SetAuthCookie(user.Email, false); } conn.AddRegister(idUser, _session.GetSessionId(), Request.UserHostAddress); return(RedirectToAction("List", "User")); } else { ModelState.AddModelError("", "Login data in incorrect"); } return(View(user)); }
public ActionResult Registration(SharedModels.Models.UserModel user) { if (ModelState.IsValid) { Helpers.Utils.validateUser(user); user.IP = Request.UserHostAddress; ConnectionsManager.Users conn = new ConnectionsManager.Users(CONNECTIONSTRING); if (conn.existUser(user.Email, user.Password) > 0) { ModelState.AddModelError("", "User exist with the same email and password"); return(View()); } else { conn.AddUser(user); } } else { ModelState.AddModelError("", "Login data is incorrect."); return(View()); } return(RedirectToAction("logIn", "User")); }
public static void validateUser(SharedModels.Models.UserModel user) { user.Password = Helpers.SHA1.Encode(user.Password); user.Email = user.Email.ToLower(); }