Secure AI-Based Email Payment System

This project integrates a C++ Smart Email Organizer with a C++ Banking System to securely process payments and detect fraud.

---

How the System Works

1. Email Organizer

   • Fetches emails and detects messages related to payments.
   • Extracts invoice details and stores them in a MySQL database.

2. Banking System

   • Reads pending payment requests from the database.
   • Verifies transactions and performs fraud detection.
   • Processes payments and updates the database.
   • Notifies users about successful transactions.

---

Integration Approach

Primary Method: Shared MySQL Database

• The Email Organizer saves payment requests in the database.
• The Banking System reads, validates, and updates the transaction status.

Optional Integration: REST API or Message Queues

• A REST API or RabbitMQ can be used for real-time communication between the components.

---

Basic Implementation

The system consists of two C++ programs that interact with a MySQL database.

Setting Up the Environment

1. Install MySQL Connector for C++

   • Required for interacting with the MySQL database.

2. Create a MySQL Database and Payments Table

CREATE DATABASE SecurePayments;
USE SecurePayments;

CREATE TABLE payments (
    id INT AUTO_INCREMENT PRIMARY KEY,
    sender_email VARCHAR(255),
    amount DECIMAL(10,2),
    status ENUM('pending', 'processed', 'fraud_detected') DEFAULT 'pending'
);

---

Email Organizer (C++ Program)

This program simulates fetching emails and storing payment details in the database.

C++ Code (email_fetcher.cpp)

#include <iostream>
#include <mysql/mysql.h>

void insertPayment(const std::string& sender_email, double amount) {
    MYSQL* conn;
    conn = mysql_init(0);
    conn = mysql_real_connect(conn, "localhost", "root", "password", "SecurePayments", 3306, NULL, 0);

    if (conn) {
        std::string query = "INSERT INTO payments (sender_email, amount) VALUES ('" + sender_email + "', " + std::to_string(amount) + ")";
        mysql_query(conn, query.c_str());

        std::cout << "Payment request from " << sender_email << " stored successfully.\n";

        mysql_close(conn);
    } else {
        std::cerr << "Database connection failed.\n";
    }
}

int main() {
    // Simulating email fetching with payment details
    insertPayment("user@example.com", 150.75);
    return 0;
}

---

Banking System (C++ Program)

This program processes payments, performs fraud detection, and updates the transaction status.

C++ Code (banking_system.cpp)

#include <iostream>
#include <mysql/mysql.h>

void processPayments() {
    MYSQL* conn;
    MYSQL_RES* res;
    MYSQL_ROW row;

    conn = mysql_init(0);
    conn = mysql_real_connect(conn, "localhost", "root", "password", "SecurePayments", 3306, NULL, 0);

    if (conn) {
        std::string query = "SELECT * FROM payments WHERE status = 'pending'";
        mysql_query(conn, query.c_str());
        res = mysql_store_result(conn);

        while ((row = mysql_fetch_row(res))) {
            int id = std::stoi(row[0]);
            std::string email = row[1];
            double amount = std::stod(row[2]);

            // Simple fraud detection: Flag transactions over $500
            std::string new_status = (amount > 500) ? "fraud_detected" : "processed";

            std::string update_query = "UPDATE payments SET status = '" + new_status + "' WHERE id = " + std::to_string(id);
            mysql_query(conn, update_query.c_str());

            std::cout << "Payment ID " << id << " from " << email << " marked as " << new_status << ".\n";
        }

        mysql_close(conn);
    } else {
        std::cerr << "Database connection failed.\n";
    }
}

int main() {
    processPayments();
    return 0;
}

---

How the System Works in Action

1. Run email_fetcher.cpp

   • Simulates receiving emails with payment requests.
   • Stores payment details in the MySQL database.

2. Run banking_system.cpp

   • Reads pending payments from the database.
   • Flags payments above $500 as fraud.
   • Updates the transaction status in the database.

---

Future Enhancements

• Real Email Fetching: Use IMAP/POP3 to fetch emails instead of simulation.
• Advanced Fraud Detection: Implement machine learning for better fraud analysis.
• REST API Integration: Connect the banking system with external services.

This Secure AI-Based Email Payment System provides an efficient way to automate payment processing while ensuring fraud detection and security.