I accepted this project as a charity project for a family group a number of months ago.? But I haven't had time to get to it, so I'm willing to pay somebody to help me out.
The? project is a speaking assignment scheduler for a non profit family organization that meets each Sunday.? Usually 2 or 3 speakers chosen from the families are assigned a topic to speak on such as family unity, family finances, etc.? Typically two adults speak and one of the children speak. They need a program that will show who is up next in the rotation for a speaking assignment.?
## Deliverables
Member list is generated each month in csv format. (see attachment)
App needs to import file and update database with new members added or update existing records with any changes.
Some individuals do not wish to accept speaking assignments and the admin needs to be able to mark such people as unable to speak or unwilling to speak.
Some individuals are able and willing to speak but not on the rotation schedule. Admins should be able to substitute other members in and out of the schedule.
children under 12 years old are not given speaking assignments, however, the csv member list does not indicate ages.? Admins need a way to add ages to children so kids under 12 do not get put in the rotation.
It would also be nice to assign topics for a number of months in advance.
The group also would like a color system so that members who have not spoken in awhile have a red background behind their name and members who have recently spoke have a lighter background.
SQL Express is the preferred database, though if it is easier to do with access, that is also ok.
I would like the program to be built using Visual Studio and .NET 2.0 or higher.
The sample csv file has many fields we will not use.? We only need the peoples names that are in name fields name1, name2, name3 etc.? Ignore all other fields.? The persons last name will be the familyname field but will need split after the comma.