This project keeps track of student/parent and teacher information for a music school. The project is written in C# using WPF. We currently have a completed XAML file and a database structure. We need back end code that allows us to add/delete/update student and teacher information as well as save, open, and write billing information to a text file in a specific format. A detailed description follows:
On the main page is a tab structure that has three tabs. There is a student tab, a teacher tab, and a billing tab.
On the student tab is a gridview, an add student button, and a search field. Clicking on the add student button takes the user to a form where new student information can be entered. The gridview is populated with all of the students in the school with their name, phone number, and teacher as the columns. Clicking on a student will open the student form with all of that student's personal information. The search field, takes a string of characters and orders the gridview according to the characters.
The student form contains fields that correspond to the database. There is an option to edit or delete the current student in the upper right corner in a combobox. There is a combobox field that is populated with all of the current teachers. Selecting a teacher links the teacher with the student.
The Teacher tab is similar. There is a gridview, an add teacher button and a search field. The functionality is the same as the student tab. When the user double clicks on a teacher, the user is taken to the teacher form. The add teacher button takes the user to the empty teacher form.
The teacher form contains fields that correspond to the database. There is an option to edit or delete the current student in the upper right corner in a combobox.
The Billing tab has a new, open, and save button, as well as a treeview that is populated by all of the teachers as parent nodes (root level nodes) and each teacher's students as the child nodes (1st level nodes). Each child level node contains a textbox that corresponds to how many lessons that student received in a month. A user clicks the new button and the tree view populates. The user then enters the number of lessons each student received for the month, expanding and collapsing each teacher until all are entered. Upon completion, the user then clicks the "save and compile" button and all of that lesson information is combined with the credit card information (stored in the database) and written to a .txt file in a specific format as defined by a credit card processing company. The saved file will then be uploaded outside of the application by the user. If the user wishes to save an incomplete file they may click the save button and the information is saved but not compiled with the credit card information. The user may then open up that file to complete it at a later date.
Membership and log in information: Upon launching the application from the desktop, the user is prompted for a username and password. Correct information allows the user to proceed to the application. Incorrect information prohibits the user from entering the application.