This was a project I previously posted on RAC, but didn't specify the language. It was executed in VB, but I really need it in C#. I am attaching the previous coders work + sample data.
The original project description follows:
Original Project Description - [login to view URL]
This is prototype for a 'report builder' part of a website. The basic functionality is to login, query a set of data, and save the 'view' of that report (selected columns, sorted column) so that it appears as a link in "Your Saved Reports".
Tables will need to be created to represent the data as follows
User (login/pass)
Saved Reports
Report Data
Ad Types/User
The query functionality in this prototype is to limited to selecting records relevant to a prticular user, the important part of this job is the user interface.
Plse refer to the state_a and state_b jpeg supplied.
The bottom half of the page is a seperate div (id=report), so that we can update just that div.
After login, the user is presented with state_a, makes certain selections. When they click "Show Report" the bottom half shows the report. You can ignore the "Ad Type" selector, and Network A Netowrkd B and Date Range.
On query to the database, only display those which have check bxes. As well, the columns are client-side sortable. See the following article:
<[login to view URL]>
If the user clicks Save, the report is saved and appears under "your saved reports" as a link, stored in a Table called "saved_reports" associated with their userid. (please see attaached document for the rest ...) The sort column and order is saved along with the columns viewed.
As well, the connection to the DB must be done with a DataSet, to allow for SQL result caching in memory.
## Deliverables
C# Asp code Code, zipped in a folder, and database tables for sample data, ready to be imported into SQL server
## Platform
ASP.NET using .NET 2.0 and either ATLAS or [login to view URL] for asynchronous, non page reloading features. Other libraries or components may be used.