- Application works with data in local SQL Server, connection string to database has to be easy modifiable (should be located in configuration file)
- As a data source Northwind database is used
- Application works in disconnected scenarion
- All employees are listed in the combobox in left upper corner of the form, both first name and last name is displayed
- Below the combobox detailed information are presented: First name, Last name, Title, Birth date and Superiors
- First name, Last name, Title and Birth date are editable, changes have to be visible in the application and persisted in the database after application closure
- Superiors are all other employees related, directly or indirectly, through "ReportsTo" field
- Photo stored in "Photo" field is displeyed in right upper corner of the form (see hint below)
- At the bottom of the form list of all orders related with selected employee are presented
- All columns except "Value" come from "Orders" table
- "Value" is an aggregated value of a single order, technically it is a sum of order details ("Order Details" table) for given order (OrderID), where value of each detail is calclated as UnitPrice*Quantity*(1-Discount)
- All rows with value greater than 1000 have modified background color
- combobox with employees: 2.0
- detailed informations (including superiors): 2.0
- photo: 1.5
- order list: 4.5