Beispiel #1
0
def employee_insert():
    data = request.json
    c1 = bo.Employee(LastName=data['LastName'],
                     FirstName=data['FirstName'],
                     Birthdate=data['Birthdate'],
                     Photo=data['Photo'],
                     Notes=data['Notes'])
    c2 = do.Employee(ConnectionData)
    s1 = c2.insert(c1)
    result = {}
    result['message'] = s1
    return jsonify(result), 200
Beispiel #2
0
def handle_employee(employee_id):
    if request.method == 'GET':
        c = bo.Employee(EmployeeID=employee_id)
        result = do.Employee(ConnectionData).get_by_id(c)
        if result[1] != 200:
            return jsonify({'message': result[0]}), result[1]
        return jsonify(result[0].to_json()), 200
    elif request.method == 'PUT':
        data = request.json
        c = bo.Employee(EmployeeID=employee_id,
                        LastName=data['LastName'],
                        FirstName=data['FirstName'],
                        Birthdate=data['Birthdate'],
                        Photo=data['Photo'],
                        Notes=data['Notes'])
        result = do.Employee(ConnectionData).update(c)
        return jsonify({'message': result[0]}), result[1]
    elif request.method == 'DELETE':
        c = bo.Employee(EmployeeID=employee_id)
        result = do.Employee(ConnectionData).delete(c)
        return jsonify({'message': result[0]}), result[1]
Beispiel #3
0
def test_insert():
    c2 = do.Employee(ConnectionData)
    c1 = bo.Employee(1, 'Thanh', 'Le', '1999', 'Da Nang', 'VietNam')
    s1 = c2.insert(c1)
    return s1
Beispiel #4
0
def get_all_employee():
    result = do.Employee(ConnectionData).get_all()
    return jsonify(result), 200