예제 #1
0
파일: Tools.cs 프로젝트: Hunv/beRemote
        public static void AddUser(FTClasses.User user)
        {
            if (_conn == null)
            {
                InitConn();
            }

            FTClasses.DBTools.AddUserInformation(_conn, user);
        }
예제 #2
0
        public static void AddUserInformation(MySqlConnection conn, FTClasses.User user)
        {
            if (conn.State != ConnectionState.Open)
            {
                conn.Open();
            }

            DeleteUserInformation(conn, user.UserName.ToUpper());

            MySqlCommand cmd = conn.CreateCommand();

            cmd.CommandText = "INSERT INTO users (name, token, expires, clientip, clientbuild) VALUES (@name, @token, @expires, @clientip, @clientbuild)";
            cmd.Parameters.Add("@name", user.UserName.ToUpper());
            cmd.Parameters.Add("@token", user.Password.Substring(0, 8));
            cmd.Parameters.Add("@expires", DateTime.Now.AddMinutes(5));
            cmd.Parameters.Add("@clientip", user.ClientIP);
            cmd.Parameters.Add("@clientbuild", user.BuildInfo);

            cmd.ExecuteNonQuery();
        }