public static string SendActivationCode(string CommandPara)
        {
            SQLManager.Connection.Close();

            SendNewActivationCodeCommand Command = new SendNewActivationCodeCommand();
            ResultWithNoData             Result  = new ResultWithNoData();
            Random rand = new Random();

            Command = JsonConvert.DeserializeObject <SendNewActivationCodeCommand>(CommandPara);

            if (CheckUserData(Command.EMail, Command.Hash) == false)
            {
                Result.statusCode = 270;
                return(JsonConvert.SerializeObject(Result));
            }

            int random = rand.Next(0, 999999);

            Mail_Server.sendActivationCode(random, Command.EMail);

            ActivationCodesSafe.addData(Command.EMail, random);

            Result.statusCode = 201;

            string test = JsonConvert.SerializeObject(Result);

            return(test);
        }
        public static string ActivationAccount(string CommandPara)
        {
            SQLManager.Connection.Close();

            ActivateAccountCommand Command = new ActivateAccountCommand();
            ResultWithNoData       Result  = new ResultWithNoData();
            Random rand = new Random();

            Command = JsonConvert.DeserializeObject <ActivateAccountCommand>(CommandPara);

            if (CheckUserData(Command.EMail, Command.Hash) == false)
            {
                Result.statusCode = 270;
                return(JsonConvert.SerializeObject(Result));
            }

            CodeEmailSafe tmp = ActivationCodesSafe.getData(Command.EMail);

            if (Command.Code == tmp.Code)
            {
                ActivationCodesSafe.RemoveData(Command.EMail);
                Result.statusCode = 201;
                using (MySqlCommand mysqlCommand = SQLManager.Connection.CreateCommand())
                {
                    SQLManager.Connection.Open();
                    mysqlCommand.CommandText = "UPDATE `users` SET `HasActivated` = '1' WHERE `EMail` = '" + Command.EMail + "'";

                    mysqlCommand.ExecuteNonQuery();

                    SQLManager.Connection.Close();
                }

                Result.statusCode = 201;
            }
            else
            {
                Result.statusCode = 202;
            }

            return(JsonConvert.SerializeObject(Result));
        }