def searchAccount():
if request.method == 'POST':
if 'aid' in request.form:
aid = request.form['aid']
if 'ssnid' in request.form:
ssnid = request.form['aid']
if len(aid) > 0:
if db.isAccountIdExist(aid):
account_data = db.getAccountIdDetils(aid)
session['aid'] = aid
return render_template('accountdetails.html', account_data)
else:
flash("account does not exist")
return redirect(url_for('searchAccount'))
else:
if db.isCustomerSsnidExist(ssnid):
accounts = db.getSsnidAccounts(ssnid)
return render_template('accountlist.html', accounts)
else:
flash("customer does not exist")
return redirect(url_for('searchAccount'))
else:
return render_template('searchAccount.html')
def createCustomer():
if request.method == 'POST':
ssnid = request.form['ssnid']
name = request.form['name']
age = request.form['age']
address = request.form['address']
city = request.form['city']
state = request.form['state']
if db.isCustomerSsnidExist(ssnid):
flash("customer already exist", 'danger')
return redirect(url_for("createCustomer"))
response = db.createCustomer(ssnid, name, age, address, city, state)
if response[0]:
flash("Customer creation initiated successfully", 'success')
return redirect(url_for("index"))
else:
flash(response[1], 'danger')
return redirect(url_for("createCustomer"))
elif request.method == 'GET':
form = RegistrationForm()
return render_template('createCustomer.html', form=form)
def preUpdateCustomer():
if request.method == 'POST':
if 'ssnid' in request.form:
ssnid = request.form['ssnid']
if db.isCustomerSsnidExist(ssnid):
customer_data = db.getCustomerSsnidDetails(ssnid)
form = RegistrationForm()
return render_template("updateCustomer.html",
cd=customer_data[0],
form=form)
else:
flash("customer does not exist", 'danger')
return redirect(url_for('preUpdateCustomer'))
elif 'cid' in request.form:
cid = request.form['cid']
if db.isCustomerIdExist(cid):
customer_data = db.getCustomerIdDetails(cid)
form = RegistrationForm()
return render_template('updateCustomer.html',
cd=customer_data[0],
form=form)
else:
flash("customer does not exist", 'danger')
return redirect(url_for('preUpdateCustomer'))
elif request.method == 'GET':
return render_template('preUpdateCustomer.html')
def preDeleteCustomer():
if request.method == 'POST':
if 'ssnid' in request.form:
ssnid = request.form['ssnid']
if db.isCustomerSsnidExist(ssnid):
customer_data = db.getCustomerSsnidDetails(ssnid)
return render_template('deleteCustomer.html',
cd=customer_data[0])
else:
return redirect(url_for('preDeleteCustomer'))
elif request.method == 'GET':
return render_template('preDeleteCustomer.html')