Beispiel #1
0
        public bool chgAdmPass(string name, string passStr)
        {
            bool   ret    = false;
            string md5Str = MyMd5.getMd5EncryptedStr(passStr);
            string encode = PsEnDecode.encode(md5Str);

            if (con != null)
            {
                try
                {
                    if (con.State != ConnectionState.Open)
                    {
                        con.Open();
                    }

                    string       query = @"update tabadmins set admPass=@pass where admName=@name;";
                    MySqlCommand cmd   = new MySqlCommand();
                    cmd.Connection  = con;
                    cmd.CommandText = query;
                    cmd.Parameters.AddWithValue("@pass", encode);
                    cmd.Parameters.AddWithValue("@name", name);

                    try
                    {
                        cmd.ExecuteNonQuery();
                        ret = true;
                    }catch (Exception ex)
                    {
                        throw new Exception(ex.Message);
                    }
                }
                catch (Exception ex)
                {
                    Console.WriteLine(ex.Message);
                }
            }
            return(ret);
        }