var express = require('express');
var router = express.Router();
var orm = require('orm');

var User=require('../models/user');

/* GET home page. */
router.get('/', function(req, res, next) {
  var user=new User({
    name:"Sadio",
    surname:"Mane"
  })
  user.save(function(error,data){
    if(error){
      console.log(error)
    }
  })
  User.find({surname:"Mane"},function(err,data){
    if(data)
    console.log(data)
  })
  res.render('blank-sidebar0', { title: 'Express' });
});

var orm = require("orm");

db=orm.connect("mysql://root@localhost/test", function (err,data) {
  if (!err)
    console.log(data);
    var Person = db.define("person", {
        name      : String,
        surname   : String,
        age       : Number, // FLOAT
        male      : Boolean,
        continent : [ "Europe", "America", "Asia", "Africa", "Australia", "Antartica" ], // ENUM type
        photo     : Buffer, // BLOB/BINARY
        data      : Object // JSON encoded
    }, {
        methods: {
            fullName: function () {
                return this.name + ' ' + this.surname;
            }
        },
        validations: {
            age: orm.enforce.ranges.number(18, undefined, "under-age")
        }
    });
});
module.exports=Person;

/**
 * Created by ESSEL on 27/08/15.
 */
var mongoose = require('mongoose');
var bcrypt   = require('bcrypt-nodejs');
var Schema = mongoose.Schema;

var GuestUserSchema = new Schema({

    GuestID: {type:String},
    FirstName: {type: String},
    Surname:{type:String},
    MiddleName:{type:String},
    EmailAddress: {type: String, unique: true , required:true},
    Password: {type: String, required:true},
    UserType:{type:String,default:'Guest'},
    JoinedDate: {type:Date ,default: Date.now()},
    AvatarImage: {type: String, default: 'profileavatar.png'},
    ContactNumber: {type:String},
    Address:{type:String},
    Biography:{type: String, trim: true}

 });
// generating a hash
GuestUserSchema.methods.generateHash = function(password) {
    return bcrypt.hashSync(password, bcrypt.genSaltSync(8), null);
};
// checking if password is valid
GuestUserSchema.methods.validPassword = function(password) {
    return bcrypt.compareSync(password, this.Password);
};

var GuestUsers = mongoose.model('GuestUsers', GuestUserSchema);

module.exports = GuestUsers;

var GuestUser = require('../model/GuestUserModel');
/* GET users listing. */
router.get('/user', checkloggedIn.isLoggedIn, function (req, res) {
    if (req.user.UserType == 'Guest') {
        GuestUser.findOne({_id: req.user._id}, function (err, result) {
            if (result) {
                res.render('GuestProfile', {user: result, SuccessMessage: req.flash('SuccessMessage'), ErrorMessage: req.flash('ValidationError')});
            } else {
                res.render('Errorpage');
                console.log("An Error Occurred" + error)
            }
        })
    } else {
        User.findOne({_id: req.user._id}, function (error, data) {
            if (data) {
                res.render('UserProfile', {user: data, SuccessMessage: req.flash('SuccessMessage'), ErrorMessage: req.flash('ValidationError')});
            } else {
                res.render('Errorpage');
                console.log("An Error Occurred" + error)
            }
        })
    }
});