public User GetUserByUsernme(string username) { User result = null; SQLiteConnection con; SQLiteDataReader reader = _sqliteHelper.ExecuteCommand("Select * FROM User where Username='******'", out con); while (reader.Read()) { result = new User { ID = Convert.ToInt32(reader["ID"]), Username = reader["Username"].ToString(), Email = reader["Email"].ToString(), Password = reader["Password"].ToString() }; } con.Close(); return result; }
public User GetUserByEmail(string email) { User result = null; SQLiteConnection con; SQLiteDataReader reader = _sqliteHelper.ExecuteCommand("Select * FROM User where Email='" + email + "'", out con); while (reader.Read()) { result = new User { Username = reader["Username"].ToString(), Email = reader["Email"].ToString(), Password = reader["Password"].ToString() }; } con.Close(); return result; }
public void CreteUser(User user) { if (string.IsNullOrWhiteSpace(user.Username)) throw new MembershipException("Username cannot be empty."); else if (user.Username.Length < 4 || user.Username.Length > 8) throw new MembershipException("Username must be 4 to 8 charcters long."); else if (!_inputValidtor.IsAlphaNumeric(user.Username)) throw new MembershipException("Username must contain only alpha-numeric characters."); else if (string.IsNullOrWhiteSpace(user.Email)) throw new MembershipException("Email cannot be empty."); else if (!_inputValidtor.IsEmail(user.Email)) throw new MembershipException("Invalid email."); else if (string.IsNullOrWhiteSpace(user.Password)) throw new MembershipException("Password cannot be empty."); else if (user.Username.Length < 4 || user.Username.Length > 6) throw new MembershipException("Username must be 4 to 6 charcters long."); else if (_userRepository.GetUserByEmail(user.Email) != null) throw new MembershipException("Email address already exist."); else if (_userRepository.GetUserByUsernme(user.Username) != null) throw new MembershipException("Username already exist."); _userRepository.Insert(user); }
public void CreteUser(RegisterViewModel viewmodel) { User entity = new User { Email = viewmodel.Email, Username = viewmodel.UserName, Password = viewmodel.Password }; _membershipService.CreteUser(entity); }
public void Update(User entity) { throw new NotImplementedException(); }
public void Insert(User entity) { _sqliteHelper.ExecuteNonQuery("INSERT INTO User (Username,Email,Password) Values ('" + entity.Username + "','" + entity.Email + "','" + entity.Password + "')"); }