Beispiel #1
0
def insert_order_detail():
    data = request.json
    orderr = bo.OrderDetail(OrderID=data['OrderID'],
                            ProductID=data['ProductID'],
                            Quantity=data['Quantity'])
    result = do.OrderDetail(ConnectionData).insert(orderr)
    return jsonify({'message': result}), 200
Beispiel #2
0
def update_order_detail_by_id(odd_id):
    data = request.json
    orderr = bo.OrderDetail(OrderDetailID=odd_id,
                            OrderID=data['OrderID'],
                            ProductID=data['ProductID'],
                            Quantity=data['Quantity'])
    result = do.OrderDetail(ConnectionData).update(orderr)
    return jsonify({'message': result[0]}), result[1]
Beispiel #3
0
def delete_order_detail_by_id(odd_id):
    c = bo.OrderDetail(OrderDetailID=odd_id)
    result = do.OrderDetail(ConnectionData).delete(c)
    return jsonify({'message': result[0]}), result[1]
Beispiel #4
0
def get_order_detail_by_id(odd_id):
    orderr = bo.OrderDetail(OrderDetailID=odd_id)
    result = do.OrderDetail(ConnectionData).get_by_id(orderr)
    if result[1] != 200:
        return jsonify({'message': result[0]}), result[1]
    return jsonify(result[0].to_json()), 200
Beispiel #5
0
def get_all_order_detail():
    c = do.OrderDetail(ConnectionData).get_all()
    return jsonify(c), 200