public bool isUserValid()
{
UsersTableModel usersTableModel = new UsersTableModel();
usersTableModel.getUser(this.brugerId);
return(this.brugerId == usersTableModel.brugerId && new Hash().getHashedPassword(this.password, usersTableModel.salt) == usersTableModel.password);
}
public void updateUser(UsersTableModel utm)
{
openConnection();
string hash, salt;
new Hash().getHashedPasswordAndSalt(utm.password, out salt, out hash);
cmd.CommandText = string.Format(
"Update users " +
"set password='******', salt='{1}', email='{2}', prim='{3}', erAdmin='{4}' " +
"where brugerId='{5}'",
hash, salt, utm.email, utm.primChar, utm.erAdminChar, utm.brugerId);
int cnt = cmd.ExecuteNonQuery();
closeConnection();
}
public void createUser(UsersTableModel utm)
{
openConnection();
string hash, salt;
new Hash().getHashedPasswordAndSalt(utm.password, out salt, out hash);
cmd.CommandText = string.Format(
"insert into users(brugerId, createTs, password, salt, email, prim, erAdmin) " +
"values('{0}', current_timestamp,'{1}','{2}','{3}','{4}','{5}');",
utm.brugerId, hash, salt, utm.email, utm.primChar, utm.erAdminChar);
int cnt = cmd.ExecuteNonQuery();
closeConnection();
}
public override bool Equals(object obj)
{
if (obj == null)
{
return(false);
}
UsersTableModel objAsUsersTableModel = obj as UsersTableModel;
if (objAsUsersTableModel == null)
{
return(false);
}
else
{
return(brugerId == objAsUsersTableModel.brugerId);
}
;
}
public List <UsersTableModel> getUserList()
{
List <UsersTableModel> utms = new List <UsersTableModel>();
openConnection();
cmd.CommandText = string.Format("select brugerId, createTs, password, salt, email, prim, erAdmin from users");
MySqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
UsersTableModel utm = new UsersTableModel();
utm.brugerId = reader.GetString("brugerId");
utm.createTs = reader.GetDateTime("createTs");
utm.password = reader.GetString("password");
utm.salt = reader.GetString("salt");
utm.email = reader.GetString("email");
utm.primChar = reader.GetChar("prim");
utm.erAdminChar = reader.GetChar("erAdmin");
utms.Add(utm);
}
closeConnection();
return(utms);
}
public void deleteUser(UsersTableModel utm)
{
deleteUser(utm.brugerId);
}