@RequestMapping(
value = "/debitAndCredit",
method = {RequestMethod.POST, RequestMethod.GET})
public ModelAndView creditAndDebit(HttpServletRequest request, HttpSession session) {
ModelAndView model = new ModelAndView();
String userName = "";
LoginHandler handler = new LoginHandler();
userName = (String) session.getAttribute("USERNAME");
String role = (String) session.getAttribute("Role");
try {
if (role != null
&& !role.isEmpty()
&& (role.equalsIgnoreCase("USER") || role.equalsIgnoreCase("MERCHANT"))) {
getAccountNumbers(model, userName, session);
model.setViewName("creditAndDebit");
} else {
if (!userName.isEmpty() || !userName.equalsIgnoreCase(null)) {
handler.updateLoggedInFlag(userName, 0);
}
session.invalidate();
model.setViewName("index");
}
} catch (Exception e) {
session.invalidate();
model.setViewName("index");
}
return model;
}
@RequestMapping(
value = "/viewBal",
method = {RequestMethod.POST, RequestMethod.GET})
public ModelAndView viewBalance(HttpServletRequest request, HttpSession session) {
ModelAndView model = new ModelAndView();
LoginHandler handler = new LoginHandler();
String userName = "";
userName = (String) session.getAttribute("USERNAME");
String role = (String) session.getAttribute("Role");
try {
if (role != null
&& !role.isEmpty()
&& (role.equalsIgnoreCase("USER") || role.equalsIgnoreCase("MERCHANT"))) {
ResultSet rs = handler.requestBalance(userName);
List<AccountDetails> acntdetails = new ArrayList<AccountDetails>();
try {
while (rs.next()) {
AccountDetails details = new AccountDetails();
details.setAccountNumber(rs.getString("accountnumber"));
details.setAccountType(rs.getString("accounttype"));
details.setBalance(rs.getDouble("balance"));
acntdetails.add(details);
}
model.addObject("accountDetails", acntdetails);
rs.close();
} catch (SQLException e) {
model.addObject("accountDetails", "");
try {
if (!userName.isEmpty() || !userName.equalsIgnoreCase(null)) {
handler.updateLoggedInFlag(userName, 0);
}
} catch (Exception e1) {
session.invalidate();
model.setViewName("index");
}
session.invalidate();
model.setViewName("index");
e.printStackTrace();
}
model.setViewName("viewBalance");
} else {
if (!userName.isEmpty() || !userName.equalsIgnoreCase(null)) {
handler.updateLoggedInFlag(userName, 0);
}
session.invalidate();
model.setViewName("index");
}
} catch (Exception e) {
session.invalidate();
model.setViewName("index");
}
return model;
}
@RequestMapping(
value = "**/home",
method = {RequestMethod.POST, RequestMethod.GET})
public ModelAndView homePage(
HttpServletRequest request, HttpServletResponse response, HttpSession session)
throws SQLException {
ModelAndView model = new ModelAndView();
String role = (String) request.getSession().getAttribute("Role");
String userName = (String) request.getSession().getAttribute("USERNAME");
LoginHandler handler = new LoginHandler();
ResultSet rs = handler.getEmail(userName);
while (rs.next()) {
role = rs.getString("usertype");
}
if (role.equalsIgnoreCase("USER")) {
model.setViewName("customerhome");
} else if (role.equalsIgnoreCase("MERCHANT")) {
model.setViewName("merchanthome");
}
rs.close();
return model;
}
@RequestMapping(
value = "**/downloadStatement",
method = {RequestMethod.POST, RequestMethod.GET})
public ModelAndView downloadStatement(
HttpServletRequest request, HttpServletResponse response, HttpSession session)
throws IOException, SQLException {
LoginHandler handler = new LoginHandler();
String userName = (String) session.getAttribute("USERNAME");
ResultSet rs = handler.requestTrasactionDetails(userName);
List<TransactionRequestDetails> transactionDetails = new ArrayList<TransactionRequestDetails>();
while (rs.next()) {
TransactionRequestDetails details = new TransactionRequestDetails();
details.setTransactionID(rs.getString("transactionid"));
details.setTransactionAmount(rs.getString("transactionamount"));
details.setSourceAccount(rs.getString("sourceaccountnumber"));
details.setDestAccount(rs.getString("destinationaccountnumber"));
details.setDateandTime(rs.getString("dateandtime"));
details.setTransferType(rs.getString("transfertype"));
details.setStatus(rs.getString("status"));
transactionDetails.add(details);
}
rs.close();
return new ModelAndView("WritePDF", "transactionDetails", transactionDetails);
}
private void getAccountNumbers(ModelAndView model, String userName, HttpSession session) {
LoginHandler handler = new LoginHandler();
ResultSet rs = handler.requestBalance(userName);
List<String> accountNumbers = new ArrayList<String>();
try {
while (rs.next()) {
accountNumbers.add(rs.getString("accountnumber"));
}
model.addObject("accountNumbers", accountNumbers);
rs.close();
} catch (SQLException e) {
try {
if (!userName.isEmpty() || !userName.equalsIgnoreCase(null)) {
handler.updateLoggedInFlag(userName, 0);
}
} catch (Exception e1) {
session.invalidate();
model.setViewName("index");
}
session.invalidate();
model.setViewName("index");
e.printStackTrace();
}
}
@RequestMapping(
value = {"/login/**/editPII**"},
method = {RequestMethod.POST, RequestMethod.GET})
public ModelAndView editPII(
HttpServletRequest request, HttpServletResponse response, HttpSession session)
throws IOException, SQLException {
ModelAndView model = new ModelAndView();
LoginHandler handler = new LoginHandler();
String userName = (String) session.getAttribute("USERNAME");
if (request.getParameter("submit") != null) {
String changeColumn = request.getParameter("PII");
String currentInfo = request.getParameter("curInfo");
String newInfo = request.getParameter("newInfo");
String confirmNewInfo = request.getParameter("cnfrmNewInfo");
String otp = request.getParameter("otpCode");
String otpString = (String) session.getAttribute("OTP");
otpEnterTime =
TimeUtility.generateSysDateMethod()
+ " "
+ TimeUtility.generateSysHoursMethod()
+ ":"
+ TimeUtility.generateSysMinutesMethod()
+ ":"
+ TimeUtility.generateSysSecondsMethod();
// long diff = System.currentTimeMillis() - startTime;
int random = (new Random()).nextInt(900000) + 100000;
// int minutes = (int) ((diff / (1000*60)) % 60);
long genSec = TimeUtility.getDifferenceinSeconds(modelTime, otpGenerateTime);
long enterSec = TimeUtility.getDifferenceinSeconds(modelTime, otpEnterTime);
if ((enterSec - genSec) > 180) {
otpString = "";
}
if (currentInfo.isEmpty() || newInfo.isEmpty() || confirmNewInfo.isEmpty() || otp.isEmpty()) {
model.addObject("emptyFields", "All fields are mandatory");
model.setViewName("editPII");
} else if (!otp.equalsIgnoreCase(otpString)) {
model.addObject("wrongOtp", "Otp code does not match");
model.setViewName("editPII");
} else if (changeColumn.equalsIgnoreCase("Phone Number")) {
Pattern pattern = Pattern.compile("\\d{10}");
Matcher matcher1 = pattern.matcher(currentInfo);
Matcher matcher2 = pattern.matcher(newInfo);
if (matcher1.matches() && matcher2.matches()) {
handler.personalInfoChange(userName, random, changeColumn, currentInfo, newInfo);
model.setViewName("customerhome");
} else {
model.addObject(
"phoneNum",
"Valid phone number should be numeric, 10 digit and no special charaecters");
model.setViewName("editPII");
}
} else {
handler.personalInfoChange(userName, random, changeColumn, currentInfo, newInfo);
model.setViewName("customerhome");
}
} else if (request.getParameter("otpButton") != null) {
startTime = System.currentTimeMillis();
otpGenerateTime =
TimeUtility.generateSysDateMethod()
+ " "
+ TimeUtility.generateSysHoursMethod()
+ ":"
+ TimeUtility.generateSysMinutesMethod()
+ ":"
+ TimeUtility.generateSysSecondsMethod();
OtpUtility otp = new OtpUtility();
String email = null;
ResultSet rs = handler.getEmail(userName);
while (rs.next()) {
email = rs.getString("email");
}
otp.sendOtp(request, email);
model.setViewName("editPII");
}
return model;
}
@RequestMapping(
value = "**/creditAndDebitFull**",
method = {RequestMethod.POST, RequestMethod.GET})
public ModelAndView editCreditAndDebit(HttpServletRequest request, HttpSession session) {
ModelAndView model = null;
model = new ModelAndView();
String userName = "";
userName = (String) session.getAttribute("USERNAME");
if (request.getParameter("submit") != null) {
String option = request.getParameter("transaction");
String accountNum = request.getParameter("transactions");
String amount = request.getParameter("amount");
try {
double am = Double.parseDouble(amount);
if (am > 0) {
LoginHandler handler = new LoginHandler();
ResultSet rs = handler.requestBalance(userName);
double balance = 0;
try {
while (rs.next()) {
if (rs.getString("accountNumber").equals(accountNum)) {
balance = rs.getDouble("balance");
}
}
double finalBalance = balance;
if (option.equalsIgnoreCase("debit") && (Double.parseDouble(amount) > finalBalance)) {
model.addObject("insuffFunds", "The Account has insufficient funds");
getAccountNumbers(model, userName, session);
model.setViewName("creditAndDebit");
} else {
int random = (new Random()).nextInt(900000) + 100000;
// Date date=new Date();
boolean flag1 = false;
boolean flag2 = false;
if (option.equalsIgnoreCase("debit")) {
logger.error(
"Insereting the requested debit transacation for the user "
+ userName
+ " for amount:"
+ amount);
flag1 =
handler.insertTransactionDetails(
userName,
random,
amount,
accountNum,
"",
TimeUtility.generateSysDateMethod(),
option,
"pendingapproval");
logger.error(
"Succesfully inserted the requested debit transacation for the user "
+ userName
+ " for amount:"
+ amount);
balance = balance - Double.parseDouble(amount);
flag2 = handler.updateBalance(accountNum, balance, userName);
logger.error("Successfully updated the balance of the user:"******"credit")) {
logger.error(
"Insereting the requested debit transacation for the user "
+ userName
+ " for amount:"
+ amount);
flag1 =
handler.insertTransactionDetails(
userName,
random,
amount,
"",
accountNum,
TimeUtility.generateSysDateMethod(),
option,
"pendingapproval");
logger.error(
"Succesfully inserted the requested debit transacation for the user "
+ userName
+ " for amount:"
+ amount);
balance = balance + Double.parseDouble(amount);
// flag2=handler.updateBalance(accountNum,balance,userName);
logger.error("Successfully updated the balance of the user:"******"Transaction is Sucess");
model.setViewName("customerhome");
} else {
logger.error("Transaction is failed");
model.setViewName("customerhome");
}
}
rs.close();
} catch (SQLException e) {
try {
if (!userName.isEmpty() || !userName.equalsIgnoreCase(null)) {
handler.updateLoggedInFlag(userName, 0);
}
} catch (Exception e1) {
session.invalidate();
model.setViewName("index");
}
session.invalidate();
model.setViewName("index");
e.printStackTrace();
}
} else {
model.addObject("emptyFields", "Amount Field has invalid input");
getAccountNumbers(model, userName, session);
model.setViewName("creditAndDebit");
}
} catch (NumberFormatException nfe) {
model.addObject("emptyFields", "Amount Field has invalid input");
getAccountNumbers(model, userName, session);
model.setViewName("creditAndDebit");
}
}
return model;
}
