//jobseeker password or admin 2
public void chgpwdjswkey(string keyval, string pwds)
{
//recalc password hash
CLPwdhash clpdh = new CLPwdhash();
string hashedpwd = clpdh.getMd5Hash(pwds);
//
using (MySqlConnection con = new MySqlConnection())
{
//Clconnect kenect = new Clconnect();
con.ConnectionString = Clconnect.makeconn();
con.Open();
using (MySqlCommand com = con.CreateCommand())
{
com.CommandType = System.Data.CommandType.Text;
com.CommandText = "UPDATE users set uPassword = '******' where uPasswordresetcode= '" + keyval + "' and uUserType = 2; ";
com.Parameters.Add("@keyval", MySqlDbType.VarChar).Value = keyval;
int reslt = com.ExecuteNonQuery();
}
con.Close();
}
}
//jobseeker user
//2 is jobseeker
public string getjobuser(string usns, string pwds)
{
MySqlConnection connreader = new MySqlConnection();
//Clconnect kenect = new Clconnect();
connreader.ConnectionString = Clconnect.makeconn();
//get hashcode
//
CLPwdhash passhash = new CLPwdhash();
string pdhash = string.Empty;
using (connreader)
{
MySqlCommand command = new MySqlCommand("SELECT uUsername FROM users where upassword = '******' and uusername='******' and uusertype=2; ", connreader);
connreader.Open();
MySqlDataReader reader = command.ExecuteReader();
if (reader.HasRows)
{
while (reader.Read())
{
pdhash = reader.GetString(0);
}
}
else
{
return(null);
}
reader.Close();
}
return(pdhash);
}
