def store(self, Name, Amount):
self.Name = Name
self.Amount = Amount
with app.app_context():
db.session.merge(self)
db.session.commit()
def store(self, typeId):
self.typeId = typeId
self.action = 'untested'
with app.app_context():
db.session.merge(self)
db.session.commit()
def storeLabPayment(self, visitId, f):
self.visitId = visitId
self.testId = f
self.amountStatus = "unpaid"
with app.app_context():
db.session.merge(self)
db.session.commit()
def update(self, visitId, doctorId):
self.visitId = visitId
self.doctorId = doctorId
with app.app_context():
db.session.merge(self)
db.session.commit()
def storeDoctorPayment(self, visitId):
self.visitId = visitId
self.amountStatus = 'paid'
with app.app_context():
db.session.merge(self)
db.session.commit()
def store(self, patientId, doctorId):
self.patientId = patientId
self.doctorId = doctorId
self.action = "unvisited"
with app.app_context():
db.session.merge(self)
db.session.commit()
def update(self, Id, Name, Amount):
self.Id = Id
self.Name = Name
self.Amount = Amount
with app.app_context():
db.session.merge(self)
db.session.commit()
def update(self, testId, typeId):
self.testId = testId
self.typeId = typeId
self.action = 'tested'
with app.app_context():
db.session.merge(self)
db.session.commit()
def update(self, paymentId, testId):
record = self.query.get(paymentId)
record.testId = testId
record.amountStatus = "paid"
with app.app_context():
db.session.merge(record)
db.session.commit()
def store(self, employeeID, month, amount, status):
self.employeeID = employeeID
self.month = month
self.amount = amount
self.status = status
with app.app_context():
db.session.merge(self)
db.session.commit()
def store(self, employeeId, profession, roomNumber, fee):
self.employeeId = employeeId
self.profession = profession
self.roomNumber = roomNumber
self.fee = fee
with app.app_context():
db.session.merge(self)
db.session.commit()
def store(self, saleId, purchasePrice, drugQuantity, returnDate):
self.saleId = saleId
self.purchasePrice = purchasePrice
self.drugQuantity = drugQuantity
self.returnDate = returnDate
with app.app_context():
db.session.merge(self)
db.session.commit()
def update(self, patientId, patientName, patientAge, gender, phoneNumber):
self.patientId = patientId
self.patientName = patientName
self.patientAge = patientAge
self.gender = gender
self.phoneNumber = phoneNumber
with app.app_context():
db.session.merge(self)
db.session.commit()
def store(self, patientName, patientAge, gender, phoneNumber):
self.patientName = patientName
self.patientAge = patientAge
self.gender = gender
self.phoneNumber = phoneNumber
# self.visitDate=visitDate
with app.app_context():
db.session.merge(self)
db.session.commit()
def store(self, drugId, drugPrice, drugQuantity, billNo, userId):
self.drugId = drugId
self.drugPrice = drugPrice
self.drugQuantity = drugQuantity
self.billNo = billNo
self.userId = userId
with app.app_context():
db.session.merge(self)
db.session.commit()
def update(self, salaryId, employeeID, month, amount, status):
self.salaryId = salaryId
self.employeeID = employeeID
self.month = month
self.amount = amount
self.status = status
with app.app_context():
db.session.merge(self)
db.session.commit()
def store(self, drugName, drugType, companyName, categoryName, barcode):
self.drugName = drugName
self.drugType = drugType
self.companyName = companyName
self.categoryName = categoryName
self.barcode = barcode
with app.app_context():
db.session.merge(self)
db.session.commit()
def store(self, drugId, drugPrice, drugQuantity, purchaseDate,
drugExpirDate):
self.drugId = drugId
self.drugPrice = drugPrice
self.drugQuantity = drugQuantity
self.purchaseDate = purchaseDate
self.drugExpirDate = drugExpirDate
with app.app_context():
db.session.merge(self)
db.session.commit()
def store(self, employeeName, phoneNumber, homeAddress, NIC_No,
employeeJob, employeeEmail):
self.employeeName = employeeName
self.phoneNumber = phoneNumber
self.homeAddress = homeAddress
self.NIC_No = NIC_No
self.employeeJob = employeeJob
self.employeeEmail = employeeEmail
with app.app_context():
db.session.merge(self)
db.session.commit()
def store(self, name):
self.name = name.encode('utf-8')
with app.app_context():
db.session.merge(self)
db.session.commit()
def store(self, name):
self.name = name
with app.app_context():
db.session.merge(self)
db.session.commit()
