Esempio n. 1
0
        public void changePassword()
        {
            string    newPasswordEncrypt;
            MD5Sample oMD5 = new MD5Sample();

            oMD5._source       = _password;
            newPasswordEncrypt = oMD5.GetMd5Hash();
            cMySQLCommands cMySQLChangePassword = new cMySQLCommands();

            cMySQLChangePassword._tblName = "usertab";

            cMySQLChangePassword._fields    = "usertab.usr_pass";
            cMySQLChangePassword._values    = "'" + newPasswordEncrypt + "'";
            cMySQLChangePassword._condition = ("usertab.usr_login = '******'");
            cMySQLChangePassword.updateQuery();
        }
Esempio n. 2
0
        public bool verifyLogin()
        {
            MySqlDataReader reader;
            MD5Sample       oMD5 = new MD5Sample();

            oMD5._source = _password;
            cMySQLCommands cMySQLVerify = new cMySQLCommands();

            cMySQLVerify._tblName = "usertab";
            cMySQLVerify._fields  = "";


            cMySQLVerify._condition = "usertab.usr_login = '******' and usertab.usr_pass= '******'";
            //oMD5.GetMd5Hash()
            reader = cMySQLVerify.selectQueryWhere();
            if (reader.HasRows)
            {
                while (reader.Read())
                {
                    _userlogin      = reader.GetString(1);
                    _fullname       = reader.GetString(2);
                    _location       = reader.GetString(6);
                    _department     = reader.GetString(7);
                    _passEncrypt    = reader.GetString(3);
                    _position       = reader.GetString(8);
                    _locationName   = getLocation();
                    _departmentName = getCompany();
                }
                return(true);
            }
            else
            {
                reader.Dispose();
                return(false);
            }
        }