C# 2.0/SQL Server 2005 Development Project

Admin Pages - C# 2.0/SQL Server 2005 Development Project Administration Webpage Arcitecture 4/3/2008 C# Project - Deliver C# project solution SQL Server 2005 Need to see examples of work - in particular the Grid Architecture 1 (one) (Deliver a C#.NET project solution) ------------------------------------------------------------------------------- Master Page(s) Master Page has three sections: 1) Header with graphic - 2) Horizontal menu below graphic 3) Vertical menu on left hand side Active Directory Security Graphic across the top with a horizontal menu below it Vertical menu along the left hand side Master/Detail Admin Webpage that services the table structure below: Object Oriented 1) class(es) to support the Pilot entity. 2) Class(es) to encapsulate the ADO insert/update/delete functionality (stored procedures). 3) Webpage should be master (grid) and detail on the same page with add/save/delete functionality and validation listed below. Master grid should list all Pilots in the tbl_piot table and associated location. Master grid should have filtering. Master grid should have sort on each column. (Any other features added to this list would help you get the project awarded to you.) Detail section should allow Location to be changed in a dropdown. Detail section 4) Clicking on different row in master grid should automatically save the current record changes after running validation. 5) Validation should be on webpage in javascript (i.e. client side) and on the database (i.e. server side codebehind). - Location is not required - Logged On, true or false, required, default false 6) Use SQL Server Stored procedures for add/save/delete functionality. Architecture 2 (two) (Deliver a C#.NET project solution) ------------------------------------------------------------------------------- User your best architecture to provide Add/Save/Delete functionality for the table structure below. Alter the table structure if needed. Table Structure (SQL Server 2000 or 2005) ------------------------------------------------------------------------------- dbo.tbl_pilot ID (PK, int, not null) LName (varchar(25), null) FName (varchar(50), null) Location_ID (int, null) (foriegn key - [login to view URL]) User_Name (char(25), null) Password (char(25), null) Pilot_Auth (char(8), null) Logged_On (bit, null) dbo.tbl_location ID (PK, int, not null) Location_Code (varchar(4), not null) Loction_Name (varchar(50), not null) Acct_Code (char(3), null) Short_Name (varchar(10), not null) Open_Date (datetime, null) Close_Date (datetime, null) Type (nchar(10), null) Time_Zone (nchar(10), null) Ad_Name (varchar(50), null) Trad_Ind (nchar(10), null) State (nchar(20), null) Location_Code_Old (char(3), null)