genevieve de la cruz .net portfolio
TRANSCRIPT
(Table of Contents)
• Library Application• Windows Communication Foundation
Application• Final Project Application
(Library Application)
• Introduction: Design and Implement an ASP.NET library application where a librarian could perform functions such as:
– Add an adult member.– Add a juvenile member. – Check in books.– Check out books.– Add new books or new copy numbers to the database.– Obtain member book loan information.– Renew an adult membership if it had expired.– Upgrade juvenile membership to adult once they reach the age of 18.
(Library Application)
• Project Goals:– Design and implement a 4 tier application: User Interface, Business Layer,
Data Access Layer and a Data Entities Layer.– Use LINQ, LINQToSql and ADO.NET’s rapid code development and
abstraction techniques to access the SQL Database. – Use the LinqToSql designer to build and model the Item and Member
classes (Member, Adult, and Juvenile) for the Member View created in SQL.– Use of the Datacontext to get data from the Database and return the
appropriate class.– Write Stored Procedures to send data back to the Database.
Project Screenshots
• We created a library application using ASP.NET as our front-end application. It required the use of Forms Authentication. We were required to create user roles, in this case a Librarian role. Only the user with a Librarian role was granted access to the application in order to use the library functions.
Project Screenshots
• Default Page – Contained all the functions such as “add adult member”, “add juvenile member”, “get member information”, “check out book”, “check in book” and “add book”.
Library functions:
Project Screenshots
• In order to add an adult member, there were several validation requirements that had to be met in order for a successful add to the database. Validations required were: 1. No blank fields for first name, last name, city, street, state and zip code. 2. Only alpha characters for name fields. 3. Zip code had to be in a “55555” or “55555-1234” format. 4. Telephone number had to be in a “(123)123-1212” format.
Validator summary results
Project Screenshots
• Upon successful addition of an adult member, a newly created member ID is populated back onto the screen. The member ID is an auto-incremented primary key field in the database.
Member ID
Project Screenshots
• In order to create a juvenile member, an adult membership is required. The juvenile member receives his/her own member ID, however the address and expiration date is the same as its adult member. The juvenile membership requires a birth date validation to make sure that he/she is under the age of 18 and that this person has been born.
Birth Date Validation
Project Screenshots
• When getting the member’s information, the member ID is the only required field. Validation is done on the member ID to make sure the member exists in the database. If the member does exist, information is populated on the screen. The member’s book loan information is then bound to a Grid View.
Member information
Grid View
Project Screenshots
• The Grid View gives the user an option to check the selected book back in, if the librarian chooses to do so. If a book is selected, a Yes Confirmation Radio Button is enabled, if it is checked, the Check-In Button is then enabled to allow book check in
Book Check in
Project Screenshots
• The Items Grid also highlights the rows when the books have passed their due dates. This allows the librarian to be aware of what items need to be returned immediately or re-checked out.
Rows highlighted
Project Screenshots
• When a member checks out a book, validation is done to ensure that the ISBN and Copy Number fields are not left blank. The book must also exists in the database, if not it must be added. Once the book has been found, the Yes Confirmation Radio Button is enabled, and if it is checked, then the Check Out Button is enabled.
Check Out Book
Project Screenshots
• Aside from the Grid View, there is a separate Check-In Page. When a search is done on a book’s ISBN and Copy Number, information is sent back with regard to the member who has the book checked out along with the book title, author, check out date and due date.
Project Screenshots
• A librarian can also choose to add a new book to the library. If the book already exists, then a new copy number is added to the database. ISBN, Title, Author, Translation are required fields for this form. Once added, a message is displayed to inform the librarian whether a book or new copy was added.
A new copy in
this case
Project Code Samples
• Use of Regular Expression Validation and Custom Validators.
Project Code Samples
• Created our own Library Exception class. Caught Generic Exceptions, along with exceptions such as member not found, item already on loan, item not found, missing adult member.
Project Code Samples
• Created entities – 1. Member which consisted of adult and juvenile 2. Book. Also created several stored procedures which were used to sent and retrieve data from the SQL database.
Stored Procedures
Entities
Project Code Samples
• Add Adult Stored Procedure:
Project Code Samples
• Created 2 views which joined several tables together. Member View which joined member, adult and juvenile tables. Book View which joined title, author, loan history, on loan tables.
Project Code Samples