Guest Checkin App

Must be in C# using Visual Studio MVC ASP.NET with code first approach This app is used to “checkin” a Guest at the time of their arrival for a special event or party. At the time of their checkin, a PartyDate should be created that is keyed to the Guest establishing the date of their attendance. if this is the second time the Guest has attended an event, then the record PartyDate should be updated to reflect the Guests’ history of visits with all PartyDates recorded in the database for the Guest attendance. The field PartyDate will be NOT be inputed by the user. This field will be generated using [login to view URL] for the partyDate. This app will function as follows: A home page will exist with standard CRUD options. If the user clicks the Create option, the Create View page will appear requesting user to Enter the Guest Information in a text field box using a comma to separate each piece of information . This comma separated information will be saved as GuestInfo String Example Create Enter Guest Information in Box below: 12/21/1970,John,Smith,1234 Main St,Lawrence,KS,66044, K00-70- 4432,72”,195,blue,john@[login to view URL],785-555-1212 //This information will be entered with a driver license scanner that will automatically enter the info into this text box. // After info is entered, submit button will be clicked and the String GuestInfo should then be passed to a method where the string is split into 16 fields coinciding with the Guest Model class as follows: BirthDate, FirstName, LastName, Address, City, State, Zip Code, Driver License, Sex, Height, Weight, Eyes, Email (optional) PhoneNumber (optional), PartyDates, GuestNumber //PartyDate and GuestNumber will NOT be entered by user. These fields will be generated by the App.// The guest model properties should have the appropriate type assigned to each. Like, date time for Birthdate, String for FirstName, INT for Weight and so on. A method named CalcGuestNumber should be called to assign a field in Database named GuestNumber. GuestNumber will be created using the First Letter of FirstName, First Letter of LastName and the last 4 digits of driverLicense all joined together. This should be performed in a method stored in class library A method named CalcGuestAge should be called to calculate the age of the Guest. This method should also be stored in class libray. After the Age is Calculated, the following should be performed Is guest under 18, if true, go to Under18 view and display Guest FirstName and AGE along with the message “ too young to enter this event” a button should appear to redirect user to the home page. the underage guest’ information should be stored in the database reflecting that the guest was denied Entry along with a timestamp of the attempted Entry. // The guest Details page should include a dropdown menu listing all of the attemptedEntry dates for the guest// Is guest over 18 but under 21 if true return Under21 view and display Guest’ FirstName and AGE. Redirect to Under21 view to display a link to a text document named AGREEMENT that is stored in a config file, along with a link to another text document named TOSAGREEMENT that is stored in a config file. Beside each links, there should be a checkbox that is already prechecked for the user. The links to both text documents should show the document if the link is clicked. An Agree Button and a Cancel button should appear below the links . Beneath the AGREE button should be text that says,“I agree to the TOS and the AGREEMENT” Beneath the Cancel button should be “I do NOT agree to the TOS and Agreement”. I ran out of room here to list all of the requirements. please see word document containing all of the requirements.