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