app.js

/**
* Module dependencies.
*/
var express = require('express')
  busboy = require("then-busboy"),
  fileUpload = require('express-fileupload')
  , routes = require('./routes')
  , user = require('./routes/user')
  , register = require('./routes/register')
  , http = require('http')
  , path = require('path');
//var methodOverride = require('method-override');
var session = require('express-session');
var flash = require('connect-flash');
var app = express();
var mysql = require('mysql');
var bodyParser=require("body-parser");

//var cookieParser = require('cookie-parser');
var connection = mysql.createConnection({
            host     : 'localhost', 
            user     : 'tkche870302',
            password : 'Mq870955677765',
            database : 'test'
            //socketPath : '/tmp/mysql.sock'
            });
connection.connect();
global.db = connection;
 
// all environments
app.set('port', process.env.PORT || 8080);
app.set('views', __dirname + '/views');
app.set('view engine', 'ejs');
app.use(bodyParser.urlencoded({ extended: false }));
app.use(flash());
//app.use(flash(app));
app.use(bodyParser.json());
app.use(express.static(path.join(__dirname, 'public')));
app.use(fileUpload());
app.use(session({
              secret: 'keyboard cat',
              resave: false,
              saveUninitialized: false,
              cookie: { maxAge: 60000*60 }
            }))
app.use(function(req, res, next) {
  res.locals.login = req.session.login;
  res.locals.uid = req.session.uid;
  res.locals.user = req.session.user;
  res.locals.valid_reg = req.session.valid_reg;
  res.locals.admin = req.session.admin;
  next();
});
 
// development only
app.get('/anncs/add', user.anncadd);
app.post('/anncs/add', user.anncadd);

app.get('/', user.index);//call for main index page
app.get('/signup', user.signup);//call for signup page
app.post('/signup', user.signup);//call for signup post 
app.get('/login', user.login);//call for login page
app.post('/login', user.login);//call for login post
app.get('/logout', user.logout);//call for logout page
app.get('/home/dashboard', user.dashboard);//call for dashboard page after login
app.get('/home/logout', user.logout);//call for logout
app.get('/home/profile',user.profile);//to render users profile
app.get('/events',user.events);//to render eventlist
app.get('/anncs/:annc_id',user.anncs);//to render eventlist
app.get('/rule/:event_id',user.rule); //to render event's rule
app.get('/register/:event_id',register.register);
app.post('/register/:event_id',register.register);
app.get('/events/status',user.status);
app.get('/events/status/:event_id',user.eventstatus);

app.get('/profile',user.profile);

app.get('/register/delete/:event_id',user.cancle);

app.get('/register/edit/:event_id/:user_id',user.edit);
app.post('/register/edit/:event_id/:user_id',user.edit);

app.get('/anncs/delete/:annc_id', user.anncDelete);//to delete the announce with annc_id
app.get('/anncs/edit/:annc_id', user.anncedit);//to delete the announce with annc_id
app.post('/anncs/edit/:annc_id', user.anncedit);//to delete the announce with annc_id


app.get('/events/delete/:event_id', user.eventDelete);//to delete the announce with annc_id

app.get('/events/add', user.eventadd);
app.post('/events/add', user.eventadd);

app.get('/events/edit/:event_id', user.eventedit);
app.post('/events/edit/:event_id', user.eventedit);


//Middleware
app.listen(8080)