def mShowData():
mBindData()
savobjbal = SavingAccounts(beobj.mGetAccno(), beobj.mGetAccname(),
beobj.mGetAcctype(), beobj.mGetAmount())
d = savobjbal.mSearchDataBal(beobj.mGetAccno())
textaccno = beobj.mGetAccno()
textname = beobj.mGetAccname()
textacctype = beobj.mGetAcctype()
txtamt = beobj.mGetAmount()
def update():
cbetobj = CBusinessEntities()
cbetobj.mSetAccno(request.form.get(
"Acc_no")) # same as form name in html form, database col name
cbetobj.mSetAccname(request.form.get("AccName"))
cbetobj.mSetAcctype(request.form.get("TranType"))
cbetobj.mSetAmount(request.form.get("Amount"))
savobj = SavingAccounts()
savobj.mUpdateDataBal(cbetobj)
accdetails = savobj.mSearchDataAllBal()
return render_template('ShowAllData.html', accdetails=accdetails)
def mSelectOne():
mBindData()
# beobj.mSetAccno(txtaccno.get())
savobjbal = SavingAccounts(beobj.mGetAccno(), beobj.mGetAccname(),
beobj.mGetAcctype(), beobj.mGetAmount())
# print(beobj.mGetAccno())
d = savobjbal.mSearchDataBal(beobj.mGetAccno())
#txtaccno.insert(0,d["Acc_no"])
txtname.insert(0, d["Acc_Name"])
txtacctype.insert(0, d["Acc_Type"])
txtamt.insert(0, d["Amount"])
def add():
# request.querystring method for get method and request.form for post method
if request.form:
cbetobj = CBusinessEntities()
cbetobj.mSetAccno(request.form.get(
"Acc_no")) # same as form name in html form, database col name
cbetobj.mSetAccname(request.form.get("AccName"))
cbetobj.mSetAcctype(request.form.get("TranType"))
cbetobj.mSetAmount(request.form.get("Amount"))
savobj = SavingAccounts()
savobj.mInsertDataBal(cbetobj)
return render_template('home.html')
def mSelectAll():
savobjbal = SavingAccounts(beobj.mGetAccno(), beobj.mGetAccname(),
beobj.mGetAcctype(), beobj.mGetAmount())
mydata = savobjbal.mSearchDataAllBal()
def mDeleteData():
mBindData()
savobjbal = SavingAccounts(beobj.mGetAccno(), beobj.mGetAccname(),
beobj.mGetAcctype(), beobj.mGetAmount())
mydata = savobjbal.mDeleteDataBal(beobj.mGetAccno())
def mUpdateData():
mBindData()
savobjbal = SavingAccounts(beobj.mGetAccno(), beobj.mGetAccname(),
beobj.mGetAcctype(), beobj.mGetAmount())
savobjbal.mUpdateDataBal(beobj)
def delete():
accno = request.form.get("Acc_no")
savobj = SavingAccounts()
savobj.mDeleteDataBal(accno=accno)
accdetails = savobj.mSearchDataAllBal()
return render_template('ShowAllData.html', accdetails=accdetails)
def DeleteData(accno):
savobj = SavingAccounts()
accdetail = savobj.mSearchDataBal(accno=accno)
return render_template('Delete.html', accdetail=accdetail)
def ShowAllData():
savobj = SavingAccounts()
accdetails = savobj.mSearchDataAllBal()
return render_template('ShowAllData.html', accdetails=accdetails)