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

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

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

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

            Mail_Server.sendPasswordCode(random, Command.EMail);

            PasswordCodesSafe.addData(Command.EMail, random);

            Result.statusCode = 201;

            return(JsonConvert.SerializeObject(Result));
        }
        public static string ResetPassword(string CommandPara)
        {
            SQLManager.Connection.Close();

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

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

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

            if (tmp == null)
            {
                Result.statusCode = 202;
                return(JsonConvert.SerializeObject(Result));
            }

            if (Command.Code == tmp.Code)
            {
                PasswordCodesSafe.RemoveData(Command.EMail);
                using (MySqlCommand mysqlCommand = SQLManager.Connection.CreateCommand())
                {
                    SQLManager.Connection.Open();
                    mysqlCommand.CommandText = "UPDATE `users` SET `Password` = '" + Command.NewHash + "' WHERE `EMail` = '" + Command.EMail + "'";

                    mysqlCommand.ExecuteNonQuery();

                    SQLManager.Connection.Close();
                }

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

            return(JsonConvert.SerializeObject(Result));
        }