Is this a good solution?

[patrick24601]

I have to write a rather small project quickly, and I am trying to keep every clean and OO. I am fairly new to .NET. I'd like your comments on my proposed solution.

 

Request:

Display a list of summary information (hospitals) with some columns of information next to each one. The columns represent how many database records are present, and some other math is done is show statistics of parts based on whole. No record detail is needed, just summary information about the records.

 

Example:

Hospital | totals records | type A records | type B records | % of records that are type A | % of records that are type B

Walter Reed Hospital | 100 | 10 | 90 | 10% | 90%

 

I then need to click on the hospital and get the department detail with the same columns, but (obviously) just for that department.

 

The data that is being given to me (from an outside product - I have no choice in the design) has 20 tables. 1 table each for the hospital and record type (A or B). 10 hospitals, 2 record types = 20 tables. I am creating my own tables with the hospital and department names.

 

I have the detailed numbers but I need to calculate the percentages.

 

Proposed Solution:

Write 2 methods to return the summary information and detail information. The Summary method will return all of the records from the hospital table joined with its data and the calculated percentages. The detail method will take in the hospital number and return all of the records - again with all of the appropriate columns.

 

As I typed this out I realized that I am not sure if I should return a dataset from each method or an array/array list. Even though my database has 4 columns of data, my presentation layer has to display more than 4 columns. It also has to display my calculated percentages.

 

Thanks,

Patrick

[HJB417]

 

I then need to click on the hospital and get the department detail with the same columns, but (obviously) just for that department.

 

A datagrid will do this.