def transfer_money():
form = transferMoney()
customer_ssn_id = form.customer_id.data
source_account_type = form.source_account_type.data
target_account_type = form.target_account_type.data
transfer_amount = form.transfer_amount.data
if form.validate_on_submit():
if Customer_Account.objects(ssn_id = customer_ssn_id):
user = Customer_Account.objects(ssn_id = customer_ssn_id).first()
if (source_account_type == "savings" or source_account_type == "s") and user.s_m >= transfer_amount and source_account_type!=target_account_type :
if Customer_Account.objects(ssn_id = customer_ssn_id ).first():
us = Customer_Account.objects(ssn_id = customer_ssn_id ).first()
Customer_Account.objects(ssn_id = customer_ssn_id ).update(s_m = us.s_m-transfer_amount, c_m = us.c_m+transfer_amount, message = "Money Sucessfully Transfered From Savings Account To Current Account" ,datetime = str(dt.now()))
id_no = Transactions.objects().count()+1
Transactions(id_no = id_no , description = "Transfer",name = customer_ssn_id,datetime = str(dt.now()), amount = transfer_amount ).save()
flash("Money Transfered Successfully From Savings Account to Current Account",'success')
elif (source_account_type == "current" or source_account_type == "c" )and user.c_m >= transfer_amount and source_account_type!=target_account_type :
if Customer_Account.objects(ssn_id = customer_ssn_id ).first():
us = Customer_Account.objects(ssn_id = customer_ssn_id ).first()
Customer_Account.objects(ssn_id = customer_ssn_id ).update(s_m = us.s_m+transfer_amount, c_m = us.c_m-transfer_amount, message = "Money Sucessfully Transfered From Current Account To Savings Account" ,datetime = str(dt.now()))
id_no = Transactions.objects().count()+1
Transactions(id_no = id_no , description = "Transfer",name = customer_ssn_id,datetime = str(dt.now()), amount = transfer_amount ).save()
flash("Money Transfered Successfully From Current Account to Savings Account",'success')
elif (source_account_type == "savings" or source_account_type == "s") and user.s_m < transfer_amount :
flash("You dont have sufficient balance in your Savings account",'danger')
elif (source_account_type == "current" or source_account_type == "c" )and user.c_m < transfer_amount:
flash("You dont have sufficient balance in your Current account",'danger')
elif (source_account_type==target_account_type):
flash("Source Account Type and Target Account Type should not be the same",'danger')
else:
flash("Customer ID dosen't match with Account ID","danger")
return render_template('transfer_money.html',form = form,)
def update_customer():
l=[]
form = updateCustomer()
temp = form.customer_ssn_id.data
if form.validate_on_submit():
if Customer_Account.objects(ssn_id = temp):
user = Customer_Account.objects(ssn_id=temp).first()
else:
user=0
#userc = Customer_Account.objects.all().count()
new_customer_name = form.new_customer_name.data
new_address = form.new_address.data
new_age = form.new_age.data
if user!=0:
Customer_Account.objects(ssn_id = temp).update(customer_name = new_customer_name , age = new_age , address = new_address,message = "Customer Updated Successfully",datetime = str(dt.now()))
flash("Customer Updation successful!",'success')
else:
flash("Customer with the given SSN_ID does not exists",'danger')
return render_template('update_customer.html',form = form, ssn_id = temp)
def customer():
form = customerScreen()
if form.validate_on_submit():
#user_id = Customer_Account.objects.count()
#user_id += 1
ssn_id = form.ssn_id.data
customer_name = form.customer_name.data
age = form.age.data
address = form.address.data
state = form.state.data
city = form.city.data
if Customer_Account.objects(ssn_id = ssn_id) and ssn_id.isnumeric():
flash("Sorry Try Again !",'danger')
else:
customer = Customer_Account(ssn_id = ssn_id, customer_name = customer_name , age = age , address = address,
state = state , city = city,account_type ="", s_m=0,c_m=0,message = "Customer Created Successfully" ,datetime = str(dt.now()))
customer.save()
flash("You are successfully registered!",'success')
return render_template("customer_screen.html",form=form)
def delete_customer():
form = deleteCustomer()
if form.validate_on_submit():
ssn_id = form.ssn_id.data
customer_name = form.customer_name.data
age = form.age.data
address = form.address.data
if Customer_Account.objects(ssn_id = ssn_id):
user = Customer_Account.objects(ssn_id=ssn_id).first()
old_name = user.customer_name
old_age = user.age
else:
user=0
if user!=0 and customer_name==old_name and age==old_age:
Customer_Account.objects(ssn_id=ssn_id).delete()
flash("Customer Deleted successful!",'success')
else:
flash("Customer with the given SSN_ID does not exists",'danger')
return render_template('delete_customer.html',form=form)
def withdraw_money():
form = withdrawMoney()
customer_ssn_id = form.customer_id.data
account_id = form.account_id.data
account_type = form.account_type.data
withdraw_amount = form.withdraw_amount.data
bal = 0
if form.validate_on_submit():
if Customer_Account.objects(ssn_id = customer_ssn_id):
user = Customer_Account.objects(ssn_id = customer_ssn_id).first()
if (account_type == "savings" or account_type=='s') and user.s_m >= withdraw_amount and account_id == customer_ssn_id:
us = Customer_Account.objects(ssn_id = customer_ssn_id ).first()
Customer_Account.objects(ssn_id = customer_ssn_id ).update(s_m = us.s_m-withdraw_amount,message = "Money Withdrawn Successfully From Svaings Account" ,datetime = str(dt.now()))
us = Customer_Account.objects(ssn_id = customer_ssn_id ).first()
bal = us.s_m
id_no = Transactions.objects().count()+1
Transactions(id_no = id_no , description = "Withdraw",name = customer_ssn_id,datetime = str(dt.now()), amount = withdraw_amount ).save()
flash("Money Withdrawn Successfully From Savings Account",'success')
if (account_type == "current" or account_type == "c") and user.c_m >= withdraw_amount and account_id == customer_ssn_id:
us = Customer_Account.objects(ssn_id = customer_ssn_id ).first()
Customer_Account.objects(ssn_id = customer_ssn_id ).update(c_m = us.c_m-withdraw_amount,message = "Money Withdrawn Successfully From Current Account" ,datetime = str(dt.now()))
us = Customer_Account.objects(ssn_id = customer_ssn_id ).first()
bal = us.s_m
id_no = Transactions.objects().count()+1
Transactions(id_no = id_no , description = "Withdraw",name = customer_ssn_id,datetime = str(dt.now()), amount = withdraw_amount ).save()
flash("Money Withdrawn Successfully From Current Account",'success')
elif user.s_m < withdraw_amount:
flash("You dont have sufficient balance in your Savings account",'danger')
elif user.c_m < withdraw_amount:
flash("You dont have sufficient balance in your Current account",'danger')
elif account_id!=customer_ssn_id:
flash("Customer ID dosen't match with Account ID","danger")
else:
flash("Customer with the given SSN_ID does not exists","danger")
return render_template('withdraw_money.html',form = form, data=[bal])
def create_account():
form =createaccount()
customer_ssn_id = form.customer_id.data
account_type = form.account_type.data
deposit_amount = form.deposit_amount.data
if form.validate_on_submit():
if Customer_Account.objects(ssn_id = customer_ssn_id):
user = Customer_Account.objects(ssn_id=customer_ssn_id).first()
else:
user=0
if (account_type=="savings" or account_type=='s') and user != 0:
if Customer_Account.objects(ssn_id = customer_ssn_id ).first():
Customer_Account.objects(ssn_id = customer_ssn_id ).update(account_type = account_type, s_m = deposit_amount, message = "Customer Savings Account Created successfully", datetime = str(dt.now()))
flash("Customer Savings Account Created successfully","success")
elif (account_type=="current" or account_type=='c') and user != 0:
if Customer_Account.objects(ssn_id = customer_ssn_id ).first():
Customer_Account.objects(ssn_id = customer_ssn_id ).update(account_type = account_type, c_m= deposit_amount , message = "Customer Current Account Created successfully" ,datetime = str(dt.now()))
flash("Customer Current Account Created successfully","success")
else:
flash("Customer with the given SSN_ID does not exists",'danger')
return render_template('create_account.html',form=form )
def delete_account():
form = deleteAccount()
account_id = form.account_id.data
account_type = form.account_type.data
if form.validate_on_submit():
if Customer_Account.objects(ssn_id = account_id):
user = Customer_Account.objects(ssn_id=account_id).first()
else:
user=0
if user != 0 and ( account_type=="savings" or account_type=='s') :
Customer_Account.objects(ssn_id = account_id ).update(account_type = "", s_m = 0 ,message = "Savings Account Deleted Successfully" ,datetime = str(dt.now()))
flash("Customer Savings Account Deleted successfully","success")
elif user != 0 and ( account_type=="current" or account_type=='c'):
Customer_Account.objects(ssn_id = account_id ).update(account_type = "", c_m = 0 ,message = "Current Account Deleted Successfully" ,datetime = str(dt.now()))
flash("Customer Current Account Deleted successfully","success")
else:
flash("Customer with the given SSN_ID does not exists",'danger')
return render_template('delete_Account.html',form = form)
def deposit_money():
form = depositMoney()
bal = 0
customer_ssn_id = form.customer_id.data
account_id = form.account_id.data
account_type = form.account_type.data
deposit_amount = form.deposit_amount.data
if form.validate_on_submit():
if Customer_Account.objects(ssn_id = customer_ssn_id):
user = Customer_Account.objects(ssn_id=customer_ssn_id).first()
else:
user=0
if account_type == "savings" or account_type=='s' and user !=0 and customer_ssn_id==account_id:
if Customer_Account.objects(ssn_id = customer_ssn_id ).first():
us = Customer_Account.objects(ssn_id = customer_ssn_id ).first()
Customer_Account.objects(ssn_id = customer_ssn_id ).update(s_m = us.s_m+deposit_amount, message = "Money Deposited Successfully To Savings Account" ,datetime = str(dt.now()))
us = Customer_Account.objects(ssn_id = customer_ssn_id ).first()
bal = us.s_m
id_no = Transactions.objects().count()+1
Transactions(id_no = id_no , description = "Deposit",name = customer_ssn_id,datetime = str(dt.now()), amount = deposit_amount ).save()
flash("Money Deposited Successfully To Savings Account","success")
elif account_type == "current" or account_type=='c' and user!=0 and customer_ssn_id==account_id:
if Customer_Account.objects(ssn_id = customer_ssn_id ).first():
us = Customer_Account.objects(ssn_id = customer_ssn_id ).first()
Customer_Account.objects(ssn_id = customer_ssn_id ).update(c_m = us.c_m+deposit_amount, message = "Money Deposited Successfully To Current Account" ,datetime = str(dt.now()))
us = Customer_Account.objects(ssn_id = customer_ssn_id ).first()
bal = us.c_m
id_no = Transactions.objects().count()+1
Transactions(id_no = id_no , description = "Deposit",name = customer_ssn_id,datetime = str(dt.now()), amount = deposit_amount ).save()
flash("Money Deposited Successfully To Current Account","success")
elif user == 0:
flash("Customer with the given SSN_ID does not exists",'danger')
return render_template('deposit_money.html',form = form, data = [bal])
def account_status():
form = accountStatusSearch()
query= form.search_query.data
acc =Customer_Account.objects(ssn_id=query)
return render_template('account_status.html',form = form,acc=acc)