Food Bank Exercises Overview and Prerequisites (Data Lists)

Here is a link to the Food Bank Source Code.

Overview

The overall objective of these exercise is to build a sub-application within Blackbaud CRM that is a food bank management tool that allows a charitable organization/food bank to receive, distribute, manage, and track food inventory.

The list below describes the requirements for the food bank sub-application.

  1. The system allows you to create, edit, and delete food banks.

  2. The system tracks the donation of food items by constituents and the distribution of food items to constituents in need.

  3. The system maintains a list of individual food items.

  4. The system tracks individual food bank transactions. A transaction consists of the donation or distribution of a food item. Individual transactions (transaction detail) can be grouped together and managed under a single transaction header.

  5. The system allows you to add, edit, update, delete, and view food banks.

  6. The system allows you to add, edit, update, delete, and view food items.

  7. The system allows you to add, edit, update, delete, and view food bank transactions for a given food bank. The system allows you to enter food bank transactions in bulk through batch import.

  8. The system tracks the current state of food item inventories for each food bank.

  9. The system indicates low inventory levels for each food item.

Prerequisites

A working software development environment that includes:

Before you attempt the step by step data form exercises, you need to add the following Table Specs and Code Table Spec to your Visual Studio catalog project and load the specs into your Infinity database. The food bank exercises manage data to and from these tables. For more information about how to add these Table Specs, see Lab: Build the Food Bank Tables.

CodeTableSpec for Foodbank Types

TableSpec for Food Banks

TableSpec for Food Items

TableSpec for Food Bank Transaction Headers

TableSpec for Food Bank Transaction Details