def close(self, closing_obj):
try:
# get current closing date
closing_da = ClosingDataAccess()
closing = closing_da.get()
# verify is locked
if closing.audit_lock == False:
raise Exception('You must lock the system before close.')
# close agent movement
self.__close_agent_movement(closing.closing_date)
# close car movement
self.__close_car_movement(closing.closing_date)
# closing
closing_da.close()
except Exception as ex:
da = UserAuditTrailDataAccess()
da.create(closing_obj.user_code, 'Closing',
'Fail. Error=%s' % str(ex))
raise ex
da = UserAuditTrailDataAccess()
da.create(closing_obj.user_code, 'Closing', 'Ok.')
def create(self, vm):
try:
self.validate_code(vm)
self.validate_name(vm)
if vm.pwd == None or len(vm.pwd) < 1:
raise Exception("You must enter a Password.")
self.validate_account_type(vm)
self.validate_comm_per(vm)
# init data
vm.bal_amt = 0
da = AgentDataAccess()
da.create(vm)
except Exception as ex:
audit_da = UserAuditTrailDataAccess()
audit_da.create(vm.user_code, 'Create Agent',
'Fail. Error=%s' % str(ex))
raise ex
audit_da = UserAuditTrailDataAccess()
audit_da.create(vm.user_code, 'Create Agent', 'Ok.')
def revert(self, closing_obj):
try:
# get closing
closing_da = ClosingDataAccess()
closing = closing_da.get()
# verify lock
if closing.audit_lock == False:
raise Exception('You must lock the system before revert.')
# delete agent balance
self.__delete_agent_movement(closing.closing_date)
# delete car balance
self.__delete_car_movement(closing.closing_date)
# update
closing_da.revert()
except Exception as ex:
da = UserAuditTrailDataAccess()
da.create(closing_obj.user_code, 'Closing',
'Fail. Error=%s' % str(ex))
raise ex
da = UserAuditTrailDataAccess()
da.create(closing_obj.user_code, 'Closing', 'Ok.')
def change_pwd(self, vm):
try:
da = UserDataAccess()
da.change_pwd(vm)
except Exception as ex:
audit_da = UserAuditTrailDataAccess()
audit_da.create(vm.user_code, 'Change User Password', 'Fail. Error=%s' % str(ex))
raise ex
audit_da = UserAuditTrailDataAccess()
audit_da.create(vm.user_code, 'Change User Password', 'Ok.')
def unlock(self, closing_obj):
try:
closing_da = ClosingDataAccess()
closing_da.unlock()
except Exception as ex:
da = UserAuditTrailDataAccess()
da.create(closing_obj.user_code, 'Unlock',
'Fail. Error=%s' % str(ex))
raise ex
da = UserAuditTrailDataAccess()
da.create(closing_obj.user_code, 'Unlock', 'Ok.')
def close(self, closing_obj):
try:
# get current closing date
closing_da = ClosingDataAccess()
closing = closing_da.get()
# verify is locked
if closing.audit_lock == False:
raise Exception('You must lock the system before close.')
# close agent movement
self.__close_agent_movement(closing.closing_date)
# close car movement
self.__close_car_movement(closing.closing_date)
# closing
closing_da.close()
except Exception as ex:
da = UserAuditTrailDataAccess()
da.create(closing_obj.user_code, 'Closing', 'Fail. Error=%s' % str(ex))
raise ex
da = UserAuditTrailDataAccess()
da.create(closing_obj.user_code, 'Closing', 'Ok.')
def revert(self, closing_obj):
try:
# get closing
closing_da = ClosingDataAccess()
closing = closing_da.get()
# verify lock
if closing.audit_lock == False:
raise Exception('You must lock the system before revert.')
# delete agent balance
self.__delete_agent_movement(closing.closing_date)
# delete car balance
self.__delete_car_movement(closing.closing_date)
# update
closing_da.revert()
except Exception as ex:
da = UserAuditTrailDataAccess()
da.create(closing_obj.user_code, 'Closing', 'Fail. Error=%s' % str(ex))
raise ex
da = UserAuditTrailDataAccess()
da.create(closing_obj.user_code, 'Closing', 'Ok.')
def update(self, vm):
try:
self.validate_ic(vm)
da = CustomerDataAccess()
da.update(vm)
except Exception as ex:
audit_da = UserAuditTrailDataAccess()
audit_da.create(vm.user_code, 'Update Customer', 'Fail. Error=%s' % str(ex))
raise ex
audit_da = UserAuditTrailDataAccess()
audit_da.create(vm.user_code, 'Update Customer', 'Ok.')
def login(self, vm):
try:
q = User.query(ancestor=ndb.Key(User, vm.code))
q = q.filter(User.pwd==vm.pwd)
obj = q.get()
if obj is None:
raise Exception('Invalid ID or Password.')
except Exception as ex:
audit_da = UserAuditTrailDataAccess()
audit_da.create(vm.user_code, 'Login', 'Fail. Error=%s' % str(ex))
raise ex
audit_da = UserAuditTrailDataAccess()
audit_da.create(vm.user_code, 'Login', 'Ok.')
def update(self, vm):
try:
self.validate_code(vm)
self.validate_name(vm)
self.validate_comm_per(vm)
da = AttendantDataAccess()
da.update(vm)
except Exception as ex:
audit_da = UserAuditTrailDataAccess()
audit_da.create(vm.user_code, 'Update Attendant', 'Fail. Error=%s' % str(ex))
raise ex
audit_da = UserAuditTrailDataAccess()
audit_da.create(vm.user_code, 'Update Attendant', 'Ok.')
def unlock(self, closing_obj):
try:
closing_da = ClosingDataAccess()
closing_da.unlock()
except Exception as ex:
da = UserAuditTrailDataAccess()
da.create(closing_obj.user_code, 'Unlock', 'Fail. Error=%s' % str(ex))
raise ex
da = UserAuditTrailDataAccess()
da.create(closing_obj.user_code, 'Unlock', 'Ok.')
def create(self, vm):
try:
self.validate_code(vm)
self.validate_name(vm)
if vm.pwd == None or len(vm.pwd) < 1:
raise Exception("You must enter a Password.")
self.validate_level(vm)
da = UserDataAccess()
da.create(vm)
except Exception as ex:
audit_da = UserAuditTrailDataAccess()
audit_da.create(vm.user_code, 'Create User', 'Fail. Error=%s' % str(ex))
raise ex
audit_da = UserAuditTrailDataAccess()
audit_da.create(vm.user_code, 'Create User', 'Ok.')
def create(self, vm):
try:
self.validate_code(vm)
self.validate_name(vm)
if vm.pwd == None or len(vm.pwd) < 1:
raise Exception("You must enter a Password.")
self.validate_account_type(vm)
self.validate_comm_per(vm)
# init data
vm.bal_amt = 0
da = AgentDataAccess()
da.create(vm)
except Exception as ex:
audit_da = UserAuditTrailDataAccess()
audit_da.create(vm.user_code, 'Create Agent', 'Fail. Error=%s' % str(ex))
raise ex
audit_da = UserAuditTrailDataAccess()
audit_da.create(vm.user_code, 'Create Agent', 'Ok.')