def inputorderdetails(id, pkg, mm, pd, km, ct, tt, ctk, am, hj, co, mix, epkg,
emm, epd, ekm, ect, ett, ectk, eam, ehj, eco, emix, bpkg,
bmm, bpd, bkm, bct, btt, bctk, bam, bhj, bco, bmix):
sqlquery = "EXEC InsertOrderDetails @id='" + str(id) + "', @pkg='" + str(
pkg) + "', @mm=" + str(mm) + ", @pd=" + str(pd) + ", @km=" + str(
km) + ", @ct=" + str(ct) + ", @tt=" + str(tt) + ", @ctk=" + str(
ctk
) + ", @am=" + str(am) + ", @hj=" + str(hj) + ", @co=" + str(
co
) + ", @mix=" + str(mix) + ", @epkg='" + str(
epkg
) + "', @emm=" + str(emm) + ", @epd=" + str(epd) + ", @ekm=" + str(
ekm) + ", @ect=" + str(ect) + ", @ett=" + str(
ett
) + ", @ectk=" + str(ectk) + ", @eam=" + str(
eam) + ", @ehj=" + str(ehj) + ", @eco=" + str(
eco
) + ", @emix=" + str(emix) + ", @bpkg='" + str(
bpkg) + "', @bmm=" + str(bmm) + ", @bpd=" + str(
bpd) + ", @bkm=" + str(bkm) + ", @bct=" + str(
bct) + ", @btt=" + str(btt) + ", @bctk=" + str(
bctk) + ", @bam=" + str(
bam) + ", @bhj=" + str(
bhj) + ", @bco=" + str(
bco) + ", @bmix=" + str(bmix)
return fn.updatedata(sqlquery)
def setlogin(id):
sqlquery = "EXEC SetLogin @id='" + str(id) + "'"
return fn.updatedata(sqlquery)
def logout(inp, id):
sqlquery = "EXEC LogOut @input=" + str(inp) + ", @id='" + str(id) + "'"
return fn.updatedata(sqlquery)
def updateordauth(ip, rem, oid, uname, utype):
sqlquery = "EXEC UpdateOrdAuthorization @auth='" + str(
ip) + "', @remark='" + str(rem) + "', @ordid='" + str(
oid) + "', @uname='" + str(uname) + "', @utype='" + str(
utype) + "'"
return fn.updatedata(sqlquery)
def deleteord(oid, id):
sqlquery = "EXEC DeleteOrder @ordid='" + str(oid) + "', @id='" + str(
id) + "'"
return fn.updatedata(sqlquery)
def updateauth(ip, rem, oid):
sqlquery = "EXEC UpdateAuth @auth='" + str(ip) + "', @remark='" + str(
rem) + "', @ordid='" + str(oid) + "'"
return fn.updatedata(sqlquery)
def updatedailybalance(id, ledger, date, added):
sqlquery = "EXEC UpdateDailyBalance @ledger=" + str(
ledger) + ", @uid='" + str(id) + "', @added=" + str(
added) + ", @date='" + str(date) + "'"
return fn.updatedata(sqlquery)
def updateledger(id, ledger):
sqlquery = "EXEC UpdateLedger @ledger=" + str(ledger) + ", @uid='" + str(
id) + "'"
return fn.updatedata(sqlquery)
def inputbasket(id, basket):
sqlquery = "EXEC inputBasket @id='" + str(id) + "', @amt=" + str(basket)
return fn.updatedata(sqlquery)
def updatebalance(id, ledger):
sqlquery = "EXEC UpdateBalance @ledger=" + str(ledger) + ", @uid='" + str(
id) + "'"
return fn.updatedata(sqlquery)
def ippaymentdetails(uid, date, utr, amt):
sqlquery = "EXEC InsertPayment @uid='" + str(uid) + "', @date='" + str(
date) + "', @utr='" + str(utr) + "', @amt=" + str(amt)
return fn.updatedata(sqlquery)