def insertUserJson(self, json):
accounttypenumber = json['AccountTypeNumber']
firstname = json['FirstName']
lastname = json['LastName']
phone = json['Phone']
email = json['Email']
majornumber = json['MajorNumber']
aboutme = json['AboutMe']
yearofenrollment = json['YearofEnrollment']
creationdate = json['CreationDate']
lastlogin = json['LastLogin']
status = json['Status']
if accounttypenumber and firstname and lastname and phone and email and majornumber and aboutme and yearofenrollment and creationdate and lastlogin and status:
dao = UserDao.UserDAO()
userid = dao.insert(accounttypenumber, firstname, lastname, phone,
email, majornumber, aboutme, yearofenrollment,
creationdate, lastlogin, status)
result = self.build_users_attributes(userid, accounttypenumber,
firstname, lastname, phone,
email, majornumber, aboutme,
yearofenrollment,
creationdate, lastlogin,
status)
return jsonify(Users=result), 201
else:
return jsonify(Error="Unexpected attributes in post request"), 400
def updateUserJson(self, userid, json):
dao = UserDao.UserDAO()
if not dao.getUserById(userid):
return jsonify(Error="Admin not found."), 404
else:
accounttypenumber = json['AccountTypeNumber']
firstname = json['FirstName']
lastname = json['LastName']
phone = json['Phone']
email = json['Email']
majornumber = json['MajorNumber']
aboutme = json['AboutMe']
yearofenrollment = json['YearofEnrollment']
creationdate = json['CreationDate']
lastlogin = json['LastLogin']
status = json['Status']
if accounttypenumber and firstname and lastname and phone and email and majornumber and aboutme and yearofenrollment and creationdate and lastlogin and status:
dao.update(accounttypenumber, firstname, lastname, phone,
email, majornumber, aboutme, yearofenrollment,
creationdate, lastlogin, status)
result = self.build_users_attributes(userid, accounttypenumber,
firstname, lastname,
phone, email, majornumber,
aboutme, yearofenrollment,
creationdate, lastlogin,
status)
return jsonify(Users=result), 200
def deleteUser(self, userid):
dao = UserDao.UserDAO()
if not dao.getUserById(userid):
return jsonify(Error="User not found."), 404
else:
dao.delete(userid)
return jsonify(DeleteStatus="OK"), 200
def getUserById(self, UserID):
dao = UserDao.UserDAO()
row = dao.getUserById(UserID)
if not row:
return jsonify(Error="User Not Found"), 404
else:
users = self.build_users_dict(row)
return jsonify(Users=users)
def getAllUsers(self):
dao = UserDao.UserDAO()
users_list = dao.getAllUsers()
result_list = []
for row in users_list:
result = self.build_users_dict(row)
result_list.append(result)
return jsonify(Users=result_list)
def insertUserSignUpJson(self, json):
accounttypenumber = 1
firstname = json['FirstName']
lastname = json['LastName']
email = json['Email']
if firstname and lastname and email:
phone = 0000000000
majornumber = 0
aboutme = ''
yearofenrollment = 0000
creationdate = 0000
lastlogin = 0000
status = 1
dao = UserDao.UserDAO()
userid = dao.insert(accounttypenumber, firstname, lastname, phone,
email, majornumber, aboutme, yearofenrollment,
creationdate, lastlogin, status)
result = self.build_usersSignUp_attributes(userid)
return jsonify(Users=result), 201
else:
return jsonify(Error="Unexpected attributes in post request"), 400
