MICROSOFT.NET MVC WEB APPLICATION

The CDU Centre for Youth and Community Music require a web application to record lessons and send out invoices. A copy of the invoice letter is available on Learnline. Student model (will require CRUD, sort by all fields):

• Student first name (text field 200 characters) • Student last name (text field 400 characters) • Student DOB (datefield) • Student Age (calculated from today’s date – DOB) • Student Gender (male/female/non-binary) • Parent/Guardian name (text field 200 characters) • Payment Contact email address (email field) • Payment Contact number (telephone field – if mobile test number) • Link to lesson list with search by that student

Lesson model (will require CRUD, sort by all fields, and student name search field):

• Student ID (see above) • Instrument ID (see below) • Tutor ID (see below) • Lesson Term & Year • Lesson Date & Time • Duration ID (see below) • Letter ID (see below) • PAID/NOT PAID (based on letter)

…also require on list: • Checkbox on each item • Calculate letter button at header (uses items selected by checkbox) • PAID button on each item

Related models (have their own CRUD lists that are referenced by the list above):

• Instrument • Tutor • Duration – 30min, 45min or 60min with Cost

Letter List Fields (for letters already sent):

• Unique Letter ID (calculated when creating letter, must auto-count) • Reference (calculated: Year+StudentLastName+UniqueLetterID) • PAID/NOT PAID • SEND (to gather the below fields and send letter)

Letter dynamic Fields when producing letter:

• Beginning comment (paragraph size) • Signature of email (paragraph size) – should remember and change if needed • Bank and Account Name – should remember and change if needed • BSB (6 digit code) – should remember and change if needed • Account number (30 digit code, trim whitespace) – should remember and change if needed • Current Term (1,2,3,4) – should remember and change if needed • Current Semester (1,2) – should remember and change if needed • Current Year (year field) – should remember and change if needed • Term Start dates (datefield) – should remember and change if needed • List of payment items for this letter (autofilled from currently selected) • Total cost (calculated)

When you send a letter, store the reference number from the letter against each item in the letter. Need to replace the letter reference on a lesson if another letter is sent out. Requires a warning.