Advertisement
4_2005-2006 Data Structures #169647

N-tier Sample (Employee Records) NEW VERSION!

This is an improved version of my submission here http://www.planetsourcecode.com/vb/scripts/ShowCode.asp?txtCodeId=4531&lngWId=10&txtForceRefresh=310200723573814627. It's architecture is now greatly improved. Comments, feedbacks and recommendations are highly appreciated. BTW, this is done using C# Express. This small app is a demo of N-Tier using C#. The base class in DAL uses Factory Class to create a connection object base on the type of derived class, whether it is MS Access or SQL Server; reusabilty is what I have in mind when I decided to go on this design. The DAL also have support for transaction which can be triggered by method SetTransaction, CommitTransaction and RollbackTransaction. I have added in DAL the most common functions I use when dealing with database. The BLL contains the Entity representation of an Employee and the CRUD operations. It also got an AuditLog where all CRUD operations will be logged in another database; when updating records all changed columns will also be logged. In BLL there is also stuff for Compacting, Repairing and backing-up Access database. There are little thing that I did in the UI that may serve useful to 'newbies' out there like changing the color of the textbox in focus, moving to the next control when hitting the Enter key and moving to the previous control when hitting the Up key, etc... This also have an Exception Logger where any exceptions can be logged in the Event Log and in a text file. So check this out! Any comments/criticisms/feedbacks will be highly appreciated. :-) BTW, just place the two MS Access database in your C:\Drive...

AI

AI Summary: This codebase represents a historical implementation of the logic described in the metadata. Our preservation engine analyzes the structure to provide context for modern developers.

Source Code
original-source
Upload
Original Comments (3)
Recovered from Wayback Machine