def deposit_money(id):
try:
acc_no = int(input("Enter your account No\n"))
except:
print("Invalid Account No")
return
account = database.get_all_info_account(acc_no,id,"deposit")
if account is not None:
try:
amount = int(input("Enter amount to Deposit\n"))
except:
print("Invalid Amount")
return
if account.deposit(amount) == True:
try:
database.money_deposit_customer(account,amount)
except cx_Oracle.DatabaseError as e:
print("Sorry something went Wrong")
print(e)
con.rollback()
return
print("Rs ",amount,"Successfully deposited");
print("Balance : Rs ",account.get_balance())
else:
print("Sorry Account No doesn't match")
def open_new_account(id):
account = None
print("\n --- Menu --- ")
print("1. Open Savings Account")
print("2. Open Current Account")
print("3. Open Fixed Deposit Account")
try:
ch = int(input())
except:
print("Invalid Choice")
return
account = get_new_account(ch,id)
if account is not None:
try:
database.open_new_account_customer(account,id)
except cx_Oracle.DatabaseError as e:
print("Sorry something went Wrong")
print(e)
con.rollback()
return
if ch == 3:
res = db_admin.get_fd_report(id)
print("Account No \t\t\t\t Amount \t\t\t\t Deposit Term")
for i in range(0,len(res)):
print(res[i][0]," \t\t\t\t\t ",res[i][1]," \t\t\t\t ",res[i][2])
else:
print("Invalid Choice")
def change_address(id):
ch = 1
addr = ""
print("-- Menu --")
print("1. Change Address Line 1")
print("2. Change Address Line 2")
print("3. Change State")
print("4. Change City")
print("5. Change Pincode")
print("6. Quit")
while ch != 6:
try:
ch = int(input())
except:
print("Invalid Choice")
ch = 1
continue
if ch == 1:
addr = input("Enter New Address Line 1\n")
elif ch == 2:
addr = input("Enter New Address Line 2\n")
elif ch == 3:
addr = input("Enter New State\n")
elif ch == 4:
addr = input("Enter New City\n")
elif ch == 5:
try:
addr = int(input("Enter New Pincode\n"))
if addr < 100000 or addr > 999999 :
print("Invalid Pincode")
break
except:
print("Invalid Pincode")
break
elif ch == 6:
break
if type(addr) != int and len(addr) == 0:
print("Field can't be blank")
break
try:
database.change_address_customer(ch,id,addr)
except cx_Oracle.DatabaseError as e:
print("Sorry something went Wrong")
print(e)
con.rollback()
return
def avail_loan(id):
try:
acc_no = int(input("\nEnter Your Savings Account No : "))
except:
print("Invalid Account No")
return
account = database.get_all_info_account(acc_no,id,"loan")
if account is not None:
max_loan = 2*account.get_balance()
msg = "\nEnter loan amount (Max Amount : Rs "+ str(max_loan) + " ) (in multiples of 1000) : "
try:
loan_amt = int(input(msg))
except:
print("Invalid Amount")
return
if loan_amt <= max_loan and loan_amt > 0 and loan_amt % 1000 == 0 :
try:
loan_term = int(input("\nEnter repayment term (in months) : "))
except:
print("Invalid repayment term")
return
if loan_term > 0:
try:
database.get_loan_customer(account.get_account_no(),loan_amt,loan_term)
except cx_Oracle.DatabaseError as e:
print("Sorry something went wrong")
print(e)
con.rollback()
return
res = db_admin.get_loan_report(id)
print("Account No \t\t\t\t Amount \t\t\t\t Repay Term")
for i in range(0,len(res)):
print(res[i][0]," \t\t\t\t\t ",res[i][1]," \t\t\t\t ",res[i][2])
else:
print("Sorry ! Invalid Loan Term")
else:
print("Sorry ! Invalid Loan Amount")
else:
print("Sorry! Account No Doesn't match")
def sign_up():
customer = Customer()
first_name = input("Enter First Name\n")
if len(first_name) == 0:
print("Field can't be blank")
return
last_name = input("Enter Last Name\n")
if len(last_name) == 0:
print("Field can't be blank")
return
add_line1 = input("Enter Address Line 1\n")
if len(add_line1) == 0:
print("Field can't be blank")
return
add_line2 = input("Enter Address Line 2\n")
if len(add_line2) == 0:
print("Field can't be blank")
return
city = input("Enter City\n")
if len(city) == 0:
print("Field can't be blank")
return
state = input("Enter State\n")
if len(state) == 0:
print("Field can't be blank")
return
try:
pincode = int(input("Enter Pincode\n"))
if pincode < 100000 or pincode > 999999:
print("Invalid Pincode")
return
except:
print("Invalid Pincode")
return
password = input("Enter password (min 8 char and max 20 char)\n")
while len(password) < 8 or len(password) > 20:
print("Please Enter password in given range\n")
password = input()
customer.set_first_name(first_name)
customer.set_last_name(last_name)
customer.set_password(password)
customer.set_status("open")
customer.set_login_attempts(3)
addr = Address()
addr.set_line_1(add_line1)
addr.set_line_2(add_line2)
addr.set_city(city)
addr.set_state(state)
addr.set_pincode(pincode)
customer.set_address(addr)
try:
database.sign_up_customer(customer)
except cx_Oracle.DatabaseError as e:
print("Sorry something went Wrong")
print(e)
con.rollback()
return