exports.payBill = function(req, res) {
console.log("Inside payBill");
billPayment = new BillPayment();
billPayment.createFromRequest(req);
var errors = billPayment.validateAll();
if(!errors[Constants.STATUS]) {
utility.writeCustomFailureJSON(res, errors);
} else {
console.log(billPayment.getValuesMap());
db.insert(DbConstants.BILL_PAYMENT_TABLE, billPayment.getValuesMap(), function(err, result) {
if(!err) {
// Mark payment done in issue_movies
var issueMovie = new CustomerMovie();
issueMovie.createFromRequest(req);
db.update(issueMovie.getUpdateAmountPaidQuery(), issueMovie.getUpdateAmountPaidMap(), function(err, result) {
if(!err) {
utility.writeSuccessJSON(res, {}, 'Payment successful');
} else {
utility.writeFailureJSON(res, err.message);
}
});
} else {
utility.writeFailureJSON(res, "Unable to complete payment");
}
});
}
};
exports.getMemberInfo = function(req, res) {
console.log("Inside getMemberInfo");
response = res;
p = new Person();
p.createFromRequest(req);
db.execSQL(p.getMemberInfoQuery(), onAllPersonsListFetched);
};
exports.editPersonInfo = function(req, res) {
console.log("Inside edit person info");
response = res;
p = new Person();
p.createFromRequest(req);
// Validate all the details
var errors = p.validateUpdateInfo();
// If details are invalid then return error message
if(!errors[Constants.STATUS]) {
utility.writeCustomFailureJSON(res, errors);
} else {
// Update password
var userLogin = p.getUserLogin();
db.update(userLogin.getUpdateUserLoginQuery(), userLogin.getUpdateUserLoginValuesMap(), function(err, result){
if(!err) {
db.update(p.getUpdatePersonInfoQuery(), p.getUpdateValuesMap(), onPersonDetailsUpdated);
} else {
var errorMessage;
if(err.message.indexOf("ER_DUP_ENTRY") > -1) {
errorMessage = "Email id is already present. Please use other email id.";
} else {
errorMessage = err.message;
}
utility.writeFailureJSON(res, errorMessage);
}
});
}
};
exports.deleteMember = function(req, res) {
console.log("Inside delete member");
response = res;
var userLogin = new UserLogin();
console.log(req.body);
userLogin.createFromRequest(req);
console.log(userLogin.id);
db.execSQL(userLogin.getDisablePersonQuery(), onPersonDeleted);
};
exports.enableMember = function(req, res) {
console.log("Inside enableMember");
response = res;
var userLogin = new UserLogin();
userLogin.createFromRequest(req);
//console.log(userLogin.id);
db.execSQL(userLogin.getEnablePersonQuery(), function(err, result) {
console.log(result);
if(err) {
utility.writeFailureJSON(res, err.message);
} else {
utility.writeSuccessJSON(res, {}, "Member status marked as active");
}
});
};
exports.signIn = function(req, res) {
console.log("Inside sign in person");
response = res;
userLogin = new UserLogin();
userLogin.createFromRequest(req);
var errors = userLogin.validateAll();
// If details are invalid then return error message
if(!errors[Constants.STATUS]) {
utility.writeCustomFailureJSON(res, errors);
} else {
db.execSQL(userLogin.getSignInQuery(), isSignIn);
}
};
db.insert(DbConstants.BILL_PAYMENT_TABLE, billPayment.getValuesMap(), function(err, result) {
if(!err) {
// Mark payment done in issue_movies
var issueMovie = new CustomerMovie();
issueMovie.createFromRequest(req);
db.update(issueMovie.getUpdateAmountPaidQuery(), issueMovie.getUpdateAmountPaidMap(), function(err, result) {
if(!err) {
utility.writeSuccessJSON(res, {}, 'Payment successful');
} else {
utility.writeFailureJSON(res, err.message);
}
});
} else {
utility.writeFailureJSON(res, "Unable to complete payment");
}
});
exports.signUp = function(req, res) {
console.log("Inside sign up");
response = res;
p = new Person();
p.createFromRequest(req);
// Validate all the details
var errors = p.validateAll();
// If details are invalid then return error message
if(!errors[Constants.STATUS]) {
utility.writeCustomFailureJSON(res, errors);
} else {
var userLogin = p.getUserLogin();
var insertUserLoginValueMap = userLogin.getValuesMap();
db.insert(DbConstants.USER_LOGIN_TABLE, insertUserLoginValueMap, onInsertLoginDetailsResponse);
}
};