public static List <User> ReadUsersFromDB() { var users = new List <User>(); DBOperations.OpenDBConnection(); MySqlCommand cmd = DBOperations.myConn.CreateCommand(); cmd.CommandText = "SELECT * FROM user"; try { MySqlDataReader rdr = cmd.ExecuteReader(); while (rdr.Read()) { var user = new User(rdr); users.Add(user); } rdr.Close(); } catch (MySqlException ex) { MessageLogger.Add("Error reading users from DB " + ex.ToString(), MessageLogger.MsgLevel.critical); return(null); } if (users.Count == 0) { var user = new User("001"); user.name = "Administrator"; user.password = CryptoSystem.Encrypt("12345"); user.accessUserAdmin = true; users.Add(user); user = new User("002"); user.name = "Packer 1"; user.password = CryptoSystem.Encrypt("1234"); user.accessPackCarton = true; users.Add(user); } return(users); }
public User(string _userId, string _userName, string _password) { userId = _userId; name = _userName; password = CryptoSystem.Encrypt(_password); }
public bool CheckPassword(string passwordEntered) { return(password.Equals(CryptoSystem.Encrypt(passwordEntered))); }
public bool UpdatePassword(string newPassword) { password = CryptoSystem.Encrypt(newPassword); return(UpdateOnDB()); }