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());
}
