app.js

const express = require('express');
const bodyParser = require('body-parser');
const path = require('path');
const db = require('./database'); 

const app = express();
const port = 5000;


app.set('view engine', 'ejs');
app.set('views', path.join(__dirname, 'views'));


app.use(bodyParser.urlencoded({ extended: false }));
app.use(express.static(path.join(__dirname, 'public')));



// Home Page
app.get('/', (req, res) => {
  res.render('index');
});

// Course Listings Page
app.get('/courses', (req, res) => {
  db.all('SELECT * FROM courses', [], (err, rows) => {
    if (err) {
      console.error(err.message);
      return res.status(500).send('Database Error');
    }
    res.render('courses', { courses: rows });
  });
});

// Search Courses API Endpoint (AJAX)
app.get('/search/courses', (req, res) => {
    const searchTerm = req.query.q;

    if (!searchTerm) {
        return res.json([]);
    }

    const query = `SELECT * FROM courses WHERE name LIKE ? COLLATE NOCASE`;
    const params = [`%${searchTerm}%`]; 

    db.all(query, params, (err, rows) => {
        if (err) {
            console.error('Error searching courses:', err.message);
            return res.status(500).json({ error: 'Database search failed' });
        }
        res.json(rows);
    });
});


// Instructor Profiles Page
app.get('/instructors', (req, res) => {
  db.all('SELECT * FROM instructors', [], (err, rows) => {
    if (err) {
      console.error(err.message);
      return res.status(500).send('Database Error');
    }
    res.render('instructors', { instructors: rows });
  });
});

// Live Sessions & Special Events Schedule Page
app.get('/events', (req, res) => {
  db.all('SELECT * FROM events', [], (err, rows) => {
    if (err) {
      console.error(err.message);
      return res.status(500).send('Database Error');
    }
    res.render('events', { events: rows });
  });
});

app.get('/pythonpath', (req, res) => {
    res.render('pythonpath'); 
});

app.get("/faqs", (req, res) => {
    const query = "SELECT id, question, answer FROM faqs ORDER BY id ASC";
    db.all(query, [], (err, faqs) => {
        if (err) {
            console.error("Error fetching FAQs:", err.message);
            res.status(500).send("Internal Server Error");
        } else {
            res.render("faqs", { faqs: faqs });
        }
    });
});

// Contact Form Page
app.get('/contact', (req, res) => {
  res.render('contact');
});


app.post('/contact', (req, res) => {
  const { name, email, message } = req.body;
  db.run(`INSERT INTO contact_submissions (name, email, message) VALUES (?, ?, ?)`, [name, email, message], function(err) {
    if (err) {
      console.error(err.message);
      return res.status(500).send('Failed to submit query.');
    }
    res.send('Thank you for your query! We will get back to you soon.'); 
  });
});

// Start the server
app.listen(port, () => {
  console.log(`Server is running on http://localhost:${port}`);
});