def get_all_Categories(): c = Categories(connection_data) result = c.get_all_Categories() return jsonify({'data': result})
def get_one_categorie(id): categories = CategoriesEntity(CategoryID=id) c = Categories(connection_data) result = c.get_one_Categories(categories) return jsonify({'data': result})
def add_categories(): data = request.json categories = CategoriesEntity(category_name=data['category_name'], description=data['description'] ) c = Categories(connection_data) message = c.insert(categories) if message is None: return jsonify({ 'message': 'Cannot insert data' }), 500 return jsonify({ 'message': message })
def add_Categories(): data = request.json cate = CategoriesEntity(CategoryName=data['CategoryName'], Description=data['Description']) c = Categories(connection_data) message = c.insert_Categories(cate) if message is None: return jsonify({'message': 'Cannot insert data'}), 500 return jsonify({'message': message})
def delete_category_by_id(id): if request.method == 'DELETE': # Delete user by id cate = CategoriesEntity(CategoryID=id) c = Categories(connection_data) result = c.delete_Categories(cate) return jsonify({'message': result[0]}), result[1] else: # Update user by id data = request.json cate = CategoriesEntity(CategoryID=id, CategoryName=data['CategoryName'], Description=data['Description']) c = Categories(connection_data) result = c.update_Categories(cate) return jsonify({'message': result[0]}), result[1]
def delete_categories_by_id(id): if request.method == 'DELETE': # Delete user by id categories = CategoriesEntity(category_id=id) c = Categories(connection_data) result = c.delete(categories) return jsonify({ 'message': result[0] }), result[1] else: # Update user by id data = request.json categories = CategoriesEntity(category_id=id, category_name=data['category_name'], description=data['description']) c = Categories(connection_data) result = c.update(categories) return jsonify({ 'message': result[0] }), result[1]