Hi,
I recently started learning C# in my spare time and as my first project I would like to try to code a very simple vacation planner. So I have 4 tables within my SQLite file:
Table 1: Departments (lets say "Production", "HR" and "Sales")
Table 2: Employees (each Employee is member of a Department)
Table 3: VacationTypes (lets say "Holiday", "Military" and "Sick Leave")
Table 4: LeaveData ("Employee1 has holiday from 11/10/2019 - 18/10/2019")
I was looking for an idea to create the overview mask and think that the "Scheduler" might be an option. My idea is to show the data like a gantt chart (left side = departments incl. the associated employees || top = timeline (maybe half day wise, show always a full week) || Context = coloured stripes )
|
| 11/06/2019 | 11/07/2019 | 11/08/2019 | 11/09/2019 | 11/10/2019 | 11/11/2019 | 11/12/2019 |
Production |
|
|
|
|
|
|
|
|
| Employee 1 |
|
|
|
|
|
|
|
| Employee 2 |
|
|
|
|
|
|
|
HR |
|
|
|
|
|
|
|
|
| Employee 1 |
|
|
|
|
|
|
|
| Employee 2 |
|
|
|
|
|
|
|
| Employee 3 |
|
|
|
|
|
|
|
Hope you get the idea. Does anyone have done something like this?
Would appreciate any help :)
Best regards
Moritz