server.js

var mysql = require('mysql');
const express = require("express");
const app = express();
const bodyparser = require('body-parser');
var methodOverride = require('method-override');

var session  = require('express-session');
var passport = require('passport');
var flash    = require('connect-flash');
var cookieParser = require('cookie-parser');
app.use(cookieParser());
require('./rename/passport')(passport);
app.use(session({
	secret: 'boomboomboom',
	resave: true,
	saveUninitialized: true
 } )); // session secret
app.use(passport.initialize());
app.use(passport.session());
app.use(flash());


app.set('view engine','ejs');
app.use('/',express.static('public'));

app.use(bodyparser.urlencoded({
	extended: true
}));
//var urlencodedParser = bodyparser.urlencoded({ extended: false });
app.use(bodyparser.json());

var con = mysql.createConnection({
  host: "localhost",
  user: "root",
  password: "password",
  database:"eventman"
});

con.connect(function(err) {
  if(err)
    console.log(err);
  else {
    console.log('success');
  }
  });

app.get ('/city/:city', function(req , res) {

    con.query( `SELECT e.eid,e.ename,e.venue, e.edate FROM eventlist AS e,location AS l where e.lid=l.lid and l.city='${req.params.city}'`, function(err,rows,fields) {
      if(err)
        console.log(err);
      else {
      //  console.log(rows);
        res.render('city',{ data:rows , title : req.params.city });
        }
    })
  })

app.get('/category/:category', function(req, res){
  con.query(`SELECT e.eid,e.ename,e.venue,e.edate from eventlist e,category c where e.cid=c.cid and c.cname='${req.params.category}'`,function(err,rows,fields){
    if(err)
      console.log(err);
    else {
    //  console.log(rows);
      res.render('category', { data : rows , title : req.params.category});
    }
  })
} )

app.get('/event', function(req , res){
  con.query(`SELECT eid,ename,venue,edate from eventlist where edate>CURDATE() order by edate limit 5`,function(err,rows,fields){
    if(err)
      console.log(err);
    else {
      res.render('index',{ data : rows });
  //    console.log(rows);
    }
  });
})

app.get('/event/add', isLoggedIn, function(req, res){
	 res.render('add');
})

 app.post('/event/add' , function(req , res ){
    /*  con.query(`insert into eventlist(ename,venue,cid,edate,oid) values(?,?,?,?,?)`,[ req.body.ename ,req.body.venue, req.body.cid, req.body.edate , req.body.oid ], function(err,rows,fields){
        if(err)
          console.log(err);
        else
            console.log("success insert");
      }
    );
    con.query(`select eid from eventlist where ename="${req.body.ename}"`, function(err,rows,fields) {
        con.query(`insert into location values(?,?)`, [ rows[0].eid , req.body.city]);
        con.query(`insert into eventdisc(eid,disc,ename,venue) values(?,?,?,?)`,[rows[0].eid, req.body.comment , req.body.ename, req.body.venue]);
    }); */

    con.query(`CALL tresin(?,?,?,?,?,?,?,?,?)`,[req.body.oname,req.body.ophone,req.body.oemail, req.body.ename ,req.body.venue, req.body.cid , req.body.edate , req.body.city , req.body.comment], function(err,rows){
      if(err)
        console.log(err);
      else {
          console.log('succ insert');
        }
    })

//     console.log(req.body);
      res.redirect('/event');


})

app.get('/event/eventdisc/:eventid', function(req,res){
  con.query(`select e.ename,e.venue,d.disc,e.edate from eventdisc d , eventlist e where e.eid=d.eid and d.eid=${req.params.eventid}`,function(err,rows,fields){
    if(err)
      console.log(err);
    else {
      res.render('desc',{ data : rows[0] });
    }
  })
})
app.get('/event/edit/:eid', isLoggedIn ,function(req,res){
  con.query(`select o.oname,o.ophone,o.oemail,e.eid,e.ename,e.venue,d.disc,e.edate from organiser o,eventdisc d , eventlist e where e.eid=d.eid and e.oid=o.oid and e.eid=${req.params.eid}`,function(err,rows,fields){
    if(err)
      console.log(err);
    else {
      res.render('edit',{ data : rows[0] });
  //    console.log(rows);
    }
  })

})
app.use(methodOverride('_method'));
app.put('/event/edit', function (req , res) {
   con.query(`update eventlist set ename="${req.body.ename}",edate="${req.body.edate}",cid="${req.body.cid}",venue="${req.body.venue}" where eid=?`,[req.query.person], function(err,fields){
    if(err)
      console.log(err);
      else {
      //  console.log(fields);
      }

  });

  con.query(`update eventdisc set disc="${req.body.comment}" where eid=? `,[req.query.person]);
  con.query(`update organiser set oname="${req.body.oname}",ophone="${req.body.ophone}",oemail="${req.body.oemail}" where oid=(select oid from eventlist where eid=?)`,[req.query.person] , function(err , result){
    if(err)
      console.log(err);
    else
      res.redirect('/event/deletion');
  });

  //console.log(req.body);
})

app.get('/event/deletion', isLoggedIn , function(req,res){
  con.query(`SELECT eid,ename,venue,edate from eventlist order by edate`,function(err,rows,fields){
    if(err)
      console.log(err);
    else {
      res.render('deletion',{ data : rows });
    }
 })
})


app.delete('/resource', function(req , res){
  con.query(`DELETE from eventlist where eid=?`,[req.query.person],function(err,rows,fields){
    if(err)
      console.log(err);
    else {
      console.log("deletion succ");
    }
  })
 //  console.log(req.query.person);
  res.redirect('/event/deletion');
})


app.get('/login', function(req, res) {


		res.render('login', { message: req.flash('loginMessage') });
	});


	app.post('/login', passport.authenticate('local-login', {
            successRedirect : '/event',
            failureRedirect : '/login',
            failureFlash : true
		}),
        function(req, res) {
            console.log("hello");

            if (req.body.remember) {
              req.session.cookie.maxage = 1000 * 60 * 3;
            } else {
              req.session.cookie.expires = false;
            }
        res.redirect('/event');
    });


	app.get('/signup', function(req, res) {

		res.render('signup', { message: req.flash('signupMessage') });
	});


	app.post('/signup', passport.authenticate('local-signup', {
		successRedirect : '/login',
		failureRedirect : '/signup',
		failureFlash : true
	}));
  app.get('/logout', function(req, res) {
		req.logout();
		res.redirect('/event');
	});
  function isLoggedIn(req, res, next) {

	if (req.isAuthenticated())
		return next();


	res.redirect('/login');
}



app.listen(3000, () => {
  console.log("Server running up on port 3000");
})