private void btn_afrekene_Click(object sender, EventArgs e)
{
SomerenLogic.CashRegister_Service cashRegisterService = new SomerenLogic.CashRegister_Service();
List <CashRegister> cashRegisters = cashRegisterService.GetCashRegisters();
SomerenLogic.Student_Service studService = new SomerenLogic.Student_Service();
List <Student> studentList = studService.GetStudents();
ListViewItem student = listViewCRStudents.SelectedItems[0];
ListViewItem drankje = listViewCRDrank.SelectedItems[0];
cashRegisterService.Db_Bar_Update_verkoop(int.Parse(drankje.Text), int.Parse(student.Text));
}
void DisplayStudents()
{
SomerenLogic.Student_Service studService = new SomerenLogic.Student_Service();
List <Student> studentList = studService.GetStudents();
foreach (SomerenModel.Student item in studentList)
{
if (item != null)
{
comboBoxCashRegister.Items.Add(item.FirstName);
}
}
}
private void showPanel(string panelName)
{
if (panelName == "Dashboard")
{
// hide all other panels
pnl_Students.Hide();
// show dashboard
pnl_Dashboard.Show();
img_Dashboard.Show();
}
else if (panelName == "Students")
{
// hide all other panels
pnl_Dashboard.Hide();
img_Dashboard.Hide();
// show students
pnl_Students.Show();
// fill the students listview within the students panel with a list of students
SomerenLogic.Student_Service studService = new SomerenLogic.Student_Service();
List <Student> studentList = studService.GetStudents();
// clear the listview before filling it again
listViewStudents.Clear();
//add columns and allign
listViewStudents.Columns.Add("Student number");
listViewStudents.Columns[0].Width = 100;
listViewStudents.Columns.Add("First Name");
listViewStudents.Columns[1].Width = 110;
listViewStudents.Columns.Add("Last Name");
listViewStudents.Columns[2].Width = 110;
foreach (SomerenModel.Student s in studentList)
{
ListViewItem li = new ListViewItem(s.Number.ToString());
li.SubItems.Add(s.FirstName);
li.SubItems.Add(s.LastName);
listViewStudents.Items.Add(li);
}
}
}
private void showPanel(string panelName)
{
if (panelName == "Dashboard")
{
// hide all other panels
pnl_Students.Hide();
// show dashboard
pnl_Dashboard.Show();
img_Dashboard.Show();
}
else if (panelName == "Students")
{
// hide all other panels
pnl_Dashboard.Hide();
img_Dashboard.Hide();
// show students
pnl_Students.Show();
// fill the students listview within the students panel with a list of students
SomerenLogic.Student_Service studService = new SomerenLogic.Student_Service();
List <Student> studentList = studService.GetStudents();
// clear the listview before filling it again
listViewStudents.Clear();
foreach (SomerenModel.Student s in studentList)
{
ListViewItem li = new ListViewItem(s.Name);
listViewStudents.Items.Add(li);
}
}
}
private void showPanel(string panelName)
{
if (panelName == "Dashboard")
{
// hide all other panels
pnl_Teachers.Hide();
imgTeachersLogo.Hide();
pnl_Students.Hide();
imgStudentsLogo.Hide();
pnl_Rooms.Hide();
imgRoomsLogo.Hide();
pnl_DrinkSupply.Hide();
pnl_Revenue.Hide();
pnl_CashRegister.Hide();
pnl_Activity.Hide();
pnl_Schedule.Hide();
pnl_Registratie.Hide();
// show dashboard
pnl_Dashboard.Show();
imgDashboardLogo.Show();
}
else if (panelName == "Students")
{
// hide all other panels
pnl_Dashboard.Hide();
imgDashboardLogo.Hide();
pnl_Teachers.Hide();
imgTeachersLogo.Hide();
pnl_Rooms.Hide();
imgRoomsLogo.Hide();
pnl_DrinkSupply.Hide();
pnl_Revenue.Hide();
pnl_CashRegister.Hide();
pnl_Activity.Hide();
pnl_Schedule.Hide();
pnl_Registratie.Hide();
// show students
pnl_Students.Show();
imgStudentsLogo.Show();
// fill the students listview within the students panel with a list of students
SomerenLogic.Student_Service studService = new SomerenLogic.Student_Service();
List <Student> studentList = studService.GetStudents();
// clear the listview before filling it again
listViewStudents.Items.Clear();
foreach (SomerenModel.Student s in studentList)
{
ListViewItem li = new ListViewItem(s.Number.ToString());
li.SubItems.Add(s.Name);
li.SubItems.Add(s.BirthDate.ToString());
listViewStudents.Items.Add(li);
}
}
else if (panelName == "Teachers")
{
// hide all other panels
pnl_Dashboard.Hide();
imgDashboardLogo.Hide();
pnl_Students.Hide();
imgStudentsLogo.Hide();
pnl_Rooms.Hide();
imgRoomsLogo.Hide();
pnl_DrinkSupply.Hide();
pnl_Revenue.Hide();
pnl_CashRegister.Hide();
pnl_Activity.Hide();
pnl_Schedule.Hide();
pnl_Registratie.Hide();
// show Teachers
pnl_Teachers.Show();
imgTeachersLogo.Show();
// fill the teacher listview within the teacher panel with a list of teacher
SomerenLogic.Teacher_Service teachService = new SomerenLogic.Teacher_Service();
List <Teacher> teacherList = teachService.GetTeachers();
// clear the listview before filling it again
listViewTeachers.Items.Clear();
foreach (SomerenModel.Teacher t in teacherList)
{
string supervisor;
if (t.IsSupervisor == true)
{
supervisor = "Yes";
}
else
{
supervisor = "No";
}
ListViewItem list = new ListViewItem(t.Number.ToString());
list.SubItems.Add(t.Name);
list.SubItems.Add(supervisor);
listViewTeachers.Items.Add(list);
}
}
else if (panelName == "Rooms")
{
// hide all other panels
pnl_Dashboard.Hide();
imgDashboardLogo.Hide();
pnl_Teachers.Hide();
imgTeachersLogo.Hide();
pnl_Students.Hide();
imgStudentsLogo.Hide();
pnl_DrinkSupply.Hide();
pnl_Revenue.Hide();
pnl_CashRegister.Hide();
pnl_Activity.Hide();
pnl_Schedule.Hide();
pnl_Registratie.Hide();
// show Rooms
pnl_Rooms.Show();
imgRoomsLogo.Show();
// fill the rooms listview within the rooms panel with a list of rooms
SomerenLogic.Room_Service roomService = new SomerenLogic.Room_Service();
List <Room> roomList = roomService.GetRooms();
// clear the listview before filling it again
listViewRooms.Items.Clear();
foreach (SomerenModel.Room r in roomList)
{
ListViewItem li = new ListViewItem(r.Number.ToString());
listViewRooms.Items.Add(li);
li.SubItems.Add(r.Capacity.ToString());
li.SubItems.Add(r.Type.ToString());
}
}
else if (panelName == "DrinkSupply")
{
// hide all other panels
pnl_Dashboard.Hide();
imgDashboardLogo.Hide();
pnl_Teachers.Hide();
imgTeachersLogo.Hide();
pnl_Students.Hide();
imgStudentsLogo.Hide();
pnl_Rooms.Hide();
imgRoomsLogo.Hide();
pnl_Revenue.Hide();
pnl_CashRegister.Hide();
pnl_Activity.Hide();
pnl_Schedule.Hide();
pnl_Registratie.Hide();
// show Rooms
pnl_DrinkSupply.Show();
// fill the drank listview within the drank panel with a list of drank
SomerenLogic.Drank_Service drank_Service = new SomerenLogic.Drank_Service();
List <Drank> drankList = drank_Service.GetDrank();
// clear the listview before filling it again
listViewDrankVoorraad.Items.Clear();
foreach (SomerenModel.Drank d in drankList)
{
ListViewItem li = new ListViewItem(d.Name);
listViewDrankVoorraad.Items.Add(li);
li.SubItems.Add(d.Number.ToString());
li.SubItems.Add(d.Voorraad.ToString());
li.SubItems.Add(d.Prijs.ToString());
if (d.Voorraad < 10)
{
li.SubItems.Add("te laag");
}
else
{
li.SubItems.Add("Genoeg");
}
}
}
else if (panelName == "DrinkSupply")
{
// hide all other panels
pnl_Dashboard.Hide();
imgDashboardLogo.Hide();
pnl_Teachers.Hide();
imgTeachersLogo.Hide();
pnl_Students.Hide();
imgStudentsLogo.Hide();
pnl_Rooms.Hide();
imgRoomsLogo.Hide();
pnl_Revenue.Hide();
pnl_CashRegister.Hide();
pnl_Activity.Hide();
pnl_Schedule.Hide();
pnl_Registratie.Hide();
// show Rooms
pnl_DrinkSupply.Show();
}
else if (panelName == "Revenue")
{
pnl_Dashboard.Hide();
imgDashboardLogo.Hide();
pnl_Teachers.Hide();
imgTeachersLogo.Hide();
pnl_Students.Hide();
imgStudentsLogo.Hide();
pnl_Rooms.Hide();
imgRoomsLogo.Hide();
pnl_DrinkSupply.Hide();
pnl_CashRegister.Hide();
pnl_Activity.Hide();
pnl_Schedule.Hide();
pnl_Registratie.Hide();
pnl_Revenue.Show();
DateTime startDate = dateTimePickerStartDate.Value;
DateTime endDate = dateTimePickerEndDate.Value;
DateTime startDateOnly = startDate.Date;
DateTime endDateOnly = endDate.Date;
SomerenLogic.Revenue_Service revenueService = new SomerenLogic.Revenue_Service();
List <Revenue> revenueList = revenueService.GetRevenue();
listViewRevenue.Items.Clear();
if (startDate <= endDate)
{
int totalSales = 0, totalRevenue = 0, numberOfStudents = 0;
List <int> studentList = new List <int>();
foreach (SomerenModel.Revenue r in revenueList)
{
if (startDateOnly == r.Date || endDateOnly == r.Date)
{
totalSales++;
totalRevenue += r.Price;
if (studentList.IndexOf(r.StudentNumber) < 0)
{
studentList.Add(r.StudentNumber);
numberOfStudents++;
}
}
}
ListViewItem list = new ListViewItem(totalSales.ToString());
list.SubItems.Add(totalRevenue.ToString());
list.SubItems.Add(numberOfStudents.ToString());
listViewRevenue.Items.Add(list);
}
else
{
MessageBox.Show("Start date can't be higher than end date", "Error");
}
}
else if (panelName == "CashRegister")
{
pnl_Dashboard.Hide();
imgDashboardLogo.Hide();
pnl_Teachers.Hide();
imgTeachersLogo.Hide();
pnl_Students.Hide();
imgStudentsLogo.Hide();
pnl_Rooms.Hide();
imgRoomsLogo.Hide();
pnl_DrinkSupply.Hide();
pnl_Revenue.Hide();
pnl_Activity.Hide();
pnl_Schedule.Hide();
pnl_Registratie.Hide();
pnl_CashRegister.Show();
SomerenLogic.CashRegister_Service cashRegisterService = new SomerenLogic.CashRegister_Service();
List <CashRegister> cashRegisters = cashRegisterService.GetCashRegisters();
SomerenLogic.Student_Service studService = new SomerenLogic.Student_Service();
List <Student> studentList = studService.GetStudents();
listViewCRStudents.Items.Clear();
foreach (SomerenModel.Student s in studentList)
{
ListViewItem li = new ListViewItem(s.Number.ToString());
listViewCRStudents.Items.Add(li);
li.SubItems.Add(s.Name);
}
listViewCRDrank.Items.Clear();
foreach (SomerenModel.CashRegister c in cashRegisters)
{
ListViewItem li = new ListViewItem(c.DrankID.ToString());
listViewCRDrank.Items.Add(li);
li.SubItems.Add(c.DrankNaam);
}
} //meneer otter kan geen dammen bouwen want hij is geen bever
else if (panelName == "Activity")
{
pnl_Dashboard.Hide();
imgDashboardLogo.Hide();
pnl_Teachers.Hide();
imgTeachersLogo.Hide();
pnl_Students.Hide();
imgStudentsLogo.Hide();
pnl_Rooms.Hide();
imgRoomsLogo.Hide();
pnl_DrinkSupply.Hide();
pnl_Revenue.Hide();
pnl_CashRegister.Hide();
pnl_Schedule.Hide();
pnl_Registratie.Hide();
pnl_Activity.Show();
SomerenLogic.Activity_Service activityService = new SomerenLogic.Activity_Service();
List <Activity> activities = activityService.GetActivities();
listViewActivity.Items.Clear();
foreach (SomerenModel.Activity A in activities)
{
ListViewItem li = new ListViewItem(A.activityID.ToString());
listViewActivity.Items.Add(li);
li.SubItems.Add(A.activityName);
li.SubItems.Add(A.numberOfStudents.ToString());
li.SubItems.Add(A.numerOfDocents.ToString());
}
}
else if (panelName == "Schedule")
{
pnl_Dashboard.Hide();
imgDashboardLogo.Hide();
pnl_Teachers.Hide();
imgTeachersLogo.Hide();
pnl_Students.Hide();
imgStudentsLogo.Hide();
pnl_Rooms.Hide();
imgRoomsLogo.Hide();
pnl_DrinkSupply.Hide();
pnl_Revenue.Hide();
pnl_CashRegister.Hide();
pnl_Activity.Hide();
pnl_Registratie.Hide();
pnl_Schedule.Show();
SomerenLogic.Schedule_Service scheduleService = new SomerenLogic.Schedule_Service();
List <Schedule> schedules = scheduleService.GetSchedules();
listViewSchedule.Items.Clear();
foreach (SomerenModel.Schedule S in schedules)
{
ListViewItem li = new ListViewItem(S.RoosterID.ToString());
//li.SubItems.Add(S.RoosterID.ToString());
li.SubItems.Add(S.Supervisors.ToString());
DateTime date = S.StartDate.Date;
string dateString = date.ToString("dd-MM-yyyy");
li.SubItems.Add(dateString);
string timeString = S.StartTime.ToString(@"hh\:mm");
li.SubItems.Add(timeString);
timeString = S.EndTime.ToString(@"hh\:mm");
li.SubItems.Add(timeString);
listViewSchedule.Items.Add(li);
}
}
else if (panelName == "Registratie")
{
pnl_Dashboard.Hide();
imgDashboardLogo.Hide();
pnl_Teachers.Hide();
imgTeachersLogo.Hide();
pnl_Students.Hide();
imgStudentsLogo.Hide();
pnl_Rooms.Hide();
imgRoomsLogo.Hide();
pnl_DrinkSupply.Hide();
pnl_Revenue.Hide();
pnl_CashRegister.Hide();
pnl_Activity.Hide();
pnl_Schedule.Hide();
pnl_Registratie.Show();
}
}
private void showPanel(string panelName)
{
if (panelName == "Dashboard")
{
// hide all other panels
pnl_Teachers.Hide();
imgTeachersLogo.Hide();
pnl_Students.Hide();
imgStudentsLogo.Hide();
pnl_Rooms.Hide();
imgRoomsLogo.Hide();
pnl_DrinkSupply.Hide();
pnl_Revenue.Hide();
pnl_CashRegister.Hide();
// show dashboard
pnl_Dashboard.Show();
imgDashboardLogo.Show();
}
else if (panelName == "Students")
{
// hide all other panels
pnl_Dashboard.Hide();
imgDashboardLogo.Hide();
pnl_Teachers.Hide();
imgTeachersLogo.Hide();
pnl_Rooms.Hide();
imgRoomsLogo.Hide();
pnl_DrinkSupply.Hide();
pnl_Revenue.Hide();
pnl_CashRegister.Hide();
// show students
pnl_Students.Show();
imgStudentsLogo.Show();
// fill the students listview within the students panel with a list of students
SomerenLogic.Student_Service studService = new SomerenLogic.Student_Service();
List<Student> studentList = studService.GetStudents();
// clear the listview before filling it again
listViewStudents.Items.Clear();
foreach (SomerenModel.Student s in studentList)
{
ListViewItem li = new ListViewItem(s.Name);
listViewStudents.Items.Add(li);
}
}
else if (panelName == "Teachers")
{
// hide all other panels
pnl_Dashboard.Hide();
imgDashboardLogo.Hide();
pnl_Students.Hide();
imgStudentsLogo.Hide();
pnl_Rooms.Hide();
imgRoomsLogo.Hide();
pnl_DrinkSupply.Hide();
pnl_Revenue.Hide();
pnl_CashRegister.Hide();
// show Teachers
pnl_Teachers.Show();
imgTeachersLogo.Show();
// fill the teacher listview within the teacher panel with a list of teacher
SomerenLogic.Teacher_Service teachService = new SomerenLogic.Teacher_Service();
List<Teacher> teacherList = teachService.GetTeachers();
// clear the listview before filling it again
listViewTeachers.Items.Clear();
foreach (SomerenModel.Teacher t in teacherList)
{
string supervisor;
if (t.IsSupervisor == true)
{
supervisor = "Yes";
}
else
{
supervisor = "no";
}
ListViewItem list = new ListViewItem(t.Number.ToString());
list.SubItems.Add(t.Name);
list.SubItems.Add(supervisor);
listViewTeachers.Items.Add(list);
}
}
else if (panelName == "Rooms")
{
// hide all other panels
pnl_Dashboard.Hide();
imgDashboardLogo.Hide();
pnl_Teachers.Hide();
imgTeachersLogo.Hide();
pnl_Students.Hide();
imgStudentsLogo.Hide();
pnl_DrinkSupply.Hide();
pnl_Revenue.Hide();
pnl_CashRegister.Hide();
// show Rooms
pnl_Rooms.Show();
imgRoomsLogo.Show();
// fill the rooms listview within the rooms panel with a list of rooms
SomerenLogic.Room_Service roomService = new SomerenLogic.Room_Service();
List<Room> roomList = roomService.GetRooms();
// clear the listview before filling it again
listViewRooms.Items.Clear();
foreach (SomerenModel.Room r in roomList)
{
ListViewItem li = new ListViewItem(r.Number.ToString());
listViewRooms.Items.Add(li);
li.SubItems.Add(r.Capacity.ToString());
li.SubItems.Add(r.Type.ToString());
}
}
else if (panelName == "DrinkSupply")
{
// hide all other panels
pnl_Dashboard.Hide();
imgDashboardLogo.Hide();
pnl_Teachers.Hide();
imgTeachersLogo.Hide();
pnl_Students.Hide();
imgStudentsLogo.Hide();
pnl_Rooms.Hide();
imgRoomsLogo.Hide();
pnl_Revenue.Hide();
pnl_CashRegister.Hide();
// show Rooms
pnl_DrinkSupply.Show();
// fill the drank listview within the drank panel with a list of drank
SomerenLogic.Drank_Service drank_Service = new SomerenLogic.Drank_Service();
List<Drank> drankList = drank_Service.GetDrank();
// clear the listview before filling it again
listViewDrankVoorraad.Items.Clear();
foreach (SomerenModel.Drank d in drankList)
{
ListViewItem li = new ListViewItem(d.Name);
listViewDrankVoorraad.Items.Add(li);
li.SubItems.Add(d.Number.ToString());
li.SubItems.Add(d.Voorraad.ToString());
li.SubItems.Add(d.Prijs.ToString());
if (d.Voorraad < 10)
{
li.SubItems.Add("te laag");
}
else
{
li.SubItems.Add("Genoeg");
}
}
}
else if (panelName == "DrinkSupply")
{
// hide all other panels
pnl_Dashboard.Hide();
imgDashboardLogo.Hide();
pnl_Teachers.Hide();
imgTeachersLogo.Hide();
pnl_Students.Hide();
imgStudentsLogo.Hide();
pnl_Rooms.Hide();
imgRoomsLogo.Hide();
pnl_Revenue.Hide();
pnl_CashRegister.Hide();
// show Rooms
pnl_DrinkSupply.Show();
}
else if (panelName == "Revenue")
{
pnl_Dashboard.Hide();
imgDashboardLogo.Hide();
pnl_Teachers.Hide();
imgTeachersLogo.Hide();
pnl_Students.Hide();
imgStudentsLogo.Hide();
pnl_Rooms.Hide();
imgRoomsLogo.Hide();
pnl_DrinkSupply.Hide();
pnl_CashRegister.Hide();
pnl_Revenue.Show();
SomerenLogic.Revenue_Service revenueService = new SomerenLogic.Revenue_Service();
List<Revenue> revenueList = revenueService.GetRevenue();
int totalSales = 0, totalRevenue = 0, numberOfStudents = 0;
List<int> studentList = new List<int>();
foreach (SomerenModel.Revenue r in revenueList)
{
totalSales++;
totalRevenue += r.Price;
if (studentList.IndexOf(r.StudentNumber) < 0)
{
studentList.Add(r.StudentNumber);
numberOfStudents++;
}
}
ListViewItem list = new ListViewItem(totalSales.ToString());
list.SubItems.Add(totalRevenue.ToString());
list.SubItems.Add(numberOfStudents.ToString());
listViewRevenue.Items.Add(list);
}
else if (panelName == "CashRegister")
{
pnl_Dashboard.Hide();
imgDashboardLogo.Hide();
pnl_Teachers.Hide();
imgTeachersLogo.Hide();
pnl_Students.Hide();
imgStudentsLogo.Hide();
pnl_Rooms.Hide();
imgRoomsLogo.Hide();
pnl_DrinkSupply.Hide();
pnl_Revenue.Hide();
pnl_CashRegister.Show();
SomerenLogic.CashRegister_Service cashRegisterService = new SomerenLogic.CashRegister_Service();
List<CashRegister> cashRegisters = cashRegisterService.GetCashRegisters();
SomerenLogic.Student_Service studService = new SomerenLogic.Student_Service();
List<Student> studentList = studService.GetStudents();
foreach (SomerenModel.Student s in studentList)
{
ListViewItem li = new ListViewItem(s.Number.ToString());
listViewCRStudents.Items.Add(li);
li.SubItems.Add(s.Name);
}
foreach (SomerenModel.CashRegister c in cashRegisters)
{
ListViewItem li = new ListViewItem(c.DrankID.ToString());
listViewCRDrank.Items.Add(li);
li.SubItems.Add(c.DrankNaam);
}
} //meneer otter kan geen dammen bouwen want hij is geen bever
}
public void showPanel(string panelName)
{
if (panelName == "Dashboard")
{
pnl_Students.Hide();
pnl_Lecturer.Hide();
pnl_Drinks.Hide();
pnl_Dashboard.Show();
img_Dashboard.Show();
pnl_Activities.Hide();
}
else if (panelName == "Students")
{
pnl_Dashboard.Hide();
img_Dashboard.Hide();
pnl_Drinks.Hide();
pnl_Activities.Hide();
pnl_Lecturer.Hide();
pnl_Students.Show();
List <Student> studentList = studService.GetStudents();
listViewStudents.Items.Clear();
foreach (SomerenModel.Student s in studentList)
{
ListViewItem item = new ListViewItem(s.Name);
item.SubItems.Add(s.Number.ToString());
item.SubItems.Add(s.BirthDate.ToString());
listViewStudents.Items.Add(item);
}
}
else if (panelName == "Drinks")
{
pnl_Dashboard.Hide();
img_Dashboard.Hide();
pnl_Students.Hide();
pnl_Activities.Hide();
pnl_Lecturer.Hide();
pnl_Drinks.Show();
List <Drink> drinkList = drinkService.GetDrinks();
drinks = drinkList;
listViewDrinks.Items.Clear();
foreach (SomerenModel.Drink d in drinkList)
{
ListViewItem item = new ListViewItem(d.Name);
item.SubItems.Add(d.Price.ToString());
item.SubItems.Add(d.Supply.ToString());
listViewDrinks.Items.Add(item);
}
}
else if (panelName == "Activities")
{
pnl_Dashboard.Hide();
img_Dashboard.Hide();
pnl_Students.Hide();
pnl_Drinks.Hide();
pnl_Lecturer.Hide();
pnl_Activities.Show();
List <Activity> activityList = actService.GetActivities();
activities = activityList;
listViewActivities.Items.Clear();
foreach (SomerenModel.Activity a in activityList)
{
ListViewItem item = new ListViewItem(a.countStudents.ToString());
item.SubItems.Add(a.countMentors.ToString());
item.SubItems.Add(a.Id.ToString());
item.SubItems.Add(a.Description);
listViewActivities.Items.Add(item);
}
}
else if (panelName == "Teachers")
{
pnl_Dashboard.Hide();
img_Dashboard.Hide();
pnl_Students.Hide();
pnl_Drinks.Hide();
pnl_Activities.Hide();
pnl_Lecturer.Show();
List <Teacher> teachers = lectService.Get_All_lecturers();
listViewteachers.Clear();
foreach (SomerenModel.Teacher t in teachers)
{
ListViewItem row = new ListViewItem(t.Vak);
row.SubItems.Add(t.Name);
row.SubItems.Add(t.Leeftijd.ToString());
row.SubItems.Add(t.Number.ToString());
listViewStudents.Items.Add(row);
}
}
}
private void showPanel(string panelName)
{
if (panelName == "Dashboard")
{
// hide all other panels
pnl_Students.Hide();
pnl_teachers.Hide();
pnl_Rooms.Hide();
pnl_Products.Hide();
pnl_Orders.Hide();
pnl_Sales.Hide();
// show dashboard
pnl_Dashboard.Show();
}
else if (panelName == "Students")
{
// hide all other panels
pnl_Dashboard.Hide();
pnl_Products.Hide();
pnl_Orders.Hide();
pnl_Sales.Hide();
pnl_teachers.Hide();
pnl_Rooms.Hide();
// show students
pnl_Students.Show();
// fill the students listview within the students panel with a list of students
SomerenLogic.Student_Service studService = new SomerenLogic.Student_Service();
List <Student> studentList = studService.GetStudents();
// clear the listview before filling it again
listViewStudents.Items.Clear();
foreach (SomerenModel.Student s in studentList)
{
ListViewItem li = new ListViewItem(s.StudentID.ToString());
li.SubItems.Add(s.FirstName);
li.SubItems.Add(s.LastName);
li.SubItems.Add(s.EmailAddress);
li.SubItems.Add(s.PhoneNumber);
listViewStudents.Items.Add(li);
}
}
else if (panelName == "Teachers")
{
// hide all other panels
pnl_Dashboard.Hide();
pnl_Products.Hide();
pnl_Orders.Hide();
pnl_Sales.Hide();
pnl_Students.Hide();
pnl_Rooms.Hide();
// show teachers
pnl_teachers.Show();
SomerenLogic.Teacher_Service teacherService = new SomerenLogic.Teacher_Service();
List <Teacher> teacherList = teacherService.GetTeachers();
// clear the listview before filling it again
listViewteachers.Items.Clear();
foreach (SomerenModel.Teacher t in teacherList)
{
ListViewItem li = new ListViewItem(t.TeacherID.ToString());
li.SubItems.Add(t.FirstName);
li.SubItems.Add(t.LastName);
li.SubItems.Add(t.EmailAddress);
li.SubItems.Add(t.PhoneNumber);
listViewteachers.Items.Add(li);
}
}
else if (panelName == "Rooms")
{
// hide all other panels
pnl_Dashboard.Hide();
pnl_Products.Hide();
pnl_Orders.Hide();
pnl_Sales.Hide();
pnl_Students.Hide();
pnl_teachers.Hide();
// show rooms
pnl_Rooms.Show();
SomerenLogic.Room_Service roomService = new SomerenLogic.Room_Service();
List <Room> roomList = roomService.GetRoom();
// clear the listview before filling it again
listViewRooms.Items.Clear();
foreach (SomerenModel.Room r in roomList)
{
ListViewItem li = new ListViewItem(r.RoomID.ToString());
li.SubItems.Add(r.RoomType);
li.SubItems.Add(r.Capacity.ToString());
listViewRooms.Items.Add(li);
}
}
else if (panelName == "Products")
{
// hide all other panels
pnl_Dashboard.Hide();
pnl_Rooms.Hide();
pnl_Students.Hide();
pnl_teachers.Hide();
pnl_Orders.Hide();
pnl_Sales.Hide();
//show product panel
pnl_Products.Show();
SomerenLogic.Product_Service productService = new SomerenLogic.Product_Service();
List <Product> productList = productService.GetProducts();
// clear the listview before filling it again
listViewProducts.Items.Clear();
foreach (SomerenModel.Product p in productList)
{
ListViewItem li = new ListViewItem(p.Id.ToString());
li.SubItems.Add(p.Name);
li.SubItems.Add(p.PriceIncl.ToString("€0.00"));
li.SubItems.Add(p.Amount.ToString());
li.SubItems.Add(p.Description);
if (p.Amount < 10)
{
li.SubItems.Add("Voorraad bijna op");
}
else
{
li.SubItems.Add("Voldoende voorraad");
}
listViewProducts.Items.Add(li);
}
}
else if (panelName == "Orders")
{
//hide all other panels
pnl_Dashboard.Hide();
pnl_Rooms.Hide();
pnl_Students.Hide();
pnl_teachers.Hide();
pnl_Products.Hide();
pnl_Sales.Hide();
//show order panel
pnl_Orders.Show();
SomerenLogic.Student_Service studService = new SomerenLogic.Student_Service();
List <Student> studentList = studService.GetStudents();
foreach (SomerenModel.Student s in studentList)
{
combo_Students.Items.Add(s.StudentID + " - " + s.FirstName + " " + s.LastName);
}
//fill products
SomerenLogic.Product_Service productService = new SomerenLogic.Product_Service();
List <Product> productList = productService.GetProducts();
foreach (SomerenModel.Product p in productList)
{
combo_Products.Items.Add(p.Id + " - " + p.Name);
}
}
else if (panelName == "Sales")
{
// hide all others
pnl_Dashboard.Hide();
pnl_Rooms.Hide();
pnl_Students.Hide();
pnl_teachers.Hide();
pnl_Products.Hide();
pnl_Orders.Hide();
// show sales
pnl_Sales.Show();
}
}
private void showPanel(string panelName)
{
if (panelName == "Dashboard")
{
selectPanel(panelName);
}
else if (panelName == "Students")
{
selectPanel(panelName); //hide other panels and show relevant
// fill the students listview within the students panel with a list of students
SomerenLogic.Student_Service studService = new SomerenLogic.Student_Service();
List <Student> studentList = studService.GetStudents();
// clear the listview before filling it again
listViewStudents.Clear();
listViewStudents.View = View.Details; // Enable rows
listViewStudents.Columns.Add("Student ID"); // Add colums
listViewStudents.Columns.Add("First Name");
listViewStudents.Columns.Add("Last Name");
listViewStudents.Columns.Add("Date Of Birth");
foreach (SomerenModel.Student s in studentList)
{
ListViewItem li = new ListViewItem(new String[] { s.Number.ToString(), s.FName, s.LName, s.BirthDate.ToString() });
listViewStudents.Items.Add(li); // Add each student to new listitem row
}
listViewStudents.AutoResizeColumns(ColumnHeaderAutoResizeStyle.ColumnContent); //Auto resize colums to fit data
listViewStudents.AutoResizeColumns(ColumnHeaderAutoResizeStyle.HeaderSize); // Make sure headers fit
}
else if (panelName == "Teachers")
{
selectPanel(panelName);
// fill the teachers listview within the teacher panel with a list of lecturers
SomerenLogic.Teacher_Service teacService = new SomerenLogic.Teacher_Service();
List <Teacher> TeacherList = teacService.GetTeachers();
// clear the listview before filling it again
listViewTeachers.Clear();
listViewTeachers.View = View.Details;
listViewTeachers.Columns.Add("Teacher_ID");
listViewTeachers.Columns.Add("First Name");
listViewTeachers.Columns.Add("Subject");
foreach (SomerenModel.Teacher t in TeacherList)
{
ListViewItem li = new ListViewItem(new String[] { t.Id.ToString(), t.TName, t.Subject });
listViewTeachers.Items.Add(li);
}
listViewTeachers.AutoResizeColumns(ColumnHeaderAutoResizeStyle.ColumnContent); //Auto resize colums to fit data
listViewTeachers.AutoResizeColumns(ColumnHeaderAutoResizeStyle.HeaderSize); // Make sure headers fit
}
else if (panelName == "Cash_Register")
{
selectPanel(panelName);
SomerenLogic.Student_Service studService = new SomerenLogic.Student_Service();
List <Student> studentList = studService.GetStudents();
//SomerenLogic.Drink_Service drink_Service = new SomerenLogic.Drink_Service();
//List<Drinks> drinkList = drink_Service.GetDrinks();
List <Drinks> drinkList = new List <Drinks>();
Drinks drink = new Drinks();
{
drink.Drinkid = 1;
drink.DrinkName = "Test Drink";
drink.Stock = 10;
drink.DrinkType = "Alcohlic";
drink.Price = 2;
drink.TotalSales = 200;
}
drinkList.Add(drink);
foreach (SomerenModel.Student s in studentList)
{
ListViewItem li = new ListViewItem(new String[] { s.Number.ToString(), s.FName, s.LName, s.BirthDate.ToString() });
registerListStudents.Items.Add($"{s.Number} {s.FName} {s.LName}");
}
foreach (SomerenModel.Drinks d in drinkList)
{
ListViewItem li = new ListViewItem(new String[] { d.DrinkName }, d.Price.ToString());
registerListDrinks.Items.Add($"{d.Drinkid} {d.DrinkName} - {d.Price} Tokens");
}
}
else if (panelName == "Activities")
{
selectPanel(panelName);
// fill the teachers listview within the teacher panel with a list of lecturers
SomerenLogic.Activity_Service activityService = new SomerenLogic.Activity_Service();
List <Activity> ActivityList = activityService.GetActivities();
// clear the listview before filling it again
groupBoxEdit.Hide();//hide edit box
textBoxActivityName.Clear();
textBoxActivityDescription.Clear();
textBoxActivityStudents.Value = 0;
textBoxActivitySupervisors.Value = 0;
listViewActivities.Clear();
listViewActivities.View = View.Details;
listViewActivities.Columns.Add("ID");
listViewActivities.Columns.Add("Name");
listViewActivities.Columns.Add("Description");
listViewActivities.Columns.Add("No. of Students");
listViewActivities.Columns.Add("No. of Teachers");
foreach (SomerenModel.Activity a in ActivityList)
{
ListViewItem li = new ListViewItem(new String[] { a.ID.ToString(), a.Name, a.Description, a.NumberOfStudents.ToString(), a.NumberOfSupervisors.ToString() });
li.Tag = "act_" + a.Name;
listViewActivities.Items.Add(li);
}
listViewActivities.AutoResizeColumns(ColumnHeaderAutoResizeStyle.ColumnContent); //Auto resize colums to fit data
listViewActivities.AutoResizeColumns(ColumnHeaderAutoResizeStyle.HeaderSize); // Make sure headers fit
}
}
private void showPanel(string panelName)
{
if (panelName == "Dashboard")
{
// hide all other panels
pnl_Students.Hide();
pnl_CashRegister.Hide();
// show dashboard
pnl_Dashboard.Show();
img_Dashboard.Show();
}
else if (panelName == "Students")
{
// hide all other panels
pnl_Dashboard.Hide();
img_Dashboard.Hide();
pnl_CashRegister.Hide();
// show students
pnl_Students.Show();
// fill the students listview within the students panel with a list of students
SomerenLogic.Student_Service studService = new SomerenLogic.Student_Service();
List <Student> studentList = studService.GetStudents();
// clear the listview before filling it again
listViewStudents.Items.Clear();
// TODO: Listview Aanpassen
foreach (SomerenModel.Student s in studentList)
{
ListViewItem li = new ListViewItem(s.Name);
listViewStudents.Items.Add(li);
}
}
else if (panelName == "Cash Register")
{
// hide all other panels
pnl_Dashboard.Hide();
img_Dashboard.Hide();
//pnl_Students.Hide();
// show Cash Register
pnl_Students.Show();
pnl_CashRegister.Show();
//pnl_Students.Show();
SomerenLogic.Student_Service studService = new SomerenLogic.Student_Service();
List <Student> studentList = studService.GetStudents();
lv_RegisterStudent.Clear();
lv_RegisterStock.Clear();
foreach (SomerenModel.Student s in studentList)
{
ListViewItem li = new ListViewItem(s.Name);
lv_RegisterStudent.Items.Add(li);
}
SomerenLogic.Stock_Service stockService = new SomerenLogic.Stock_Service();
List <Stock> stockList = stockService.GetStock();
foreach (SomerenModel.Stock v in stockList)
{
ListViewItem li = new ListViewItem(v.Name);
lv_RegisterStock.Items.Add(li);
}
}
}
private void showPanel(string panelName)
{
if (panelName == "Dashboard")
{
// hide all other panels
pnl_Students.Hide();
// show dashboard
pnl_Dashboard.Show();
img_Dashboard.Show();
}
else if (panelName == "Students")
{
// hide all other panels
pnl_Dashboard.Hide();
img_Dashboard.Hide();
// show students
pnl_Students.Show();
// fill the students listview within the students panel with a list of students
SomerenLogic.Student_Service studService = new SomerenLogic.Student_Service();
List <Student> studentList = studService.GetStudents();
// clear the listview before filling it again
listViewStudents.Clear();
foreach (SomerenModel.Student s in studentList)
{
ListViewItem li = new ListViewItem(s.Name);
li.SubItems.Add(s.Number.ToString());
li.SubItems.Add(s.Name.ToString());
listViewStudents.Items.Add(li);
}
}
else if (panelName == "Teachers")
{
pnl_Dashboard.Hide();
img_Dashboard.Hide();
pnl_Students.Hide();
//Program.ShowTeachers().Show();
//this.pnl_Students.Controls.Clear();
lbl_Students.Text = "Teachers";
// show students
pnl_Students.Show();
//this.pnl_Students.Controls.Add(Program.ShowTeachers());
// fill the Teachers listview within the Teachers panel with a list of lecturers
SomerenLogic.Lecturers_Service lecService = new SomerenLogic.Lecturers_Service();
List <Teacher> lecturersList = lecService.GetLecturers();
// clear the listview before filling it again
listViewStudents.Clear();
//Adding columns
listViewStudents.View = View.Details;
listViewStudents.Columns.Add("Name", -2, HorizontalAlignment.Center);
listViewStudents.Columns.Add("Id", -2, HorizontalAlignment.Center);
foreach (SomerenModel.Teacher s in lecturersList)
{
ListViewItem li = new ListViewItem(s.Name);
li.SubItems.Add(s.Number.ToString());
li.SubItems.Add(s.Name.ToString());
listViewStudents.Items.Add(li);
// listViewLecturers.Items.Add(li);
}
}
}
private void showPanel(string panelName)
{
if (IamAdmin == false)
{
btnAdd.Hide();
btnChange.Hide();
btnRemove.Hide();
btnSubmit.Hide();
btn_EditDrinks.Hide();
btn_saveDrink.Hide();
btn_Add.Hide();
btn_Remove.Hide();
}
DisplayActivityID();
//normally hidden stuff:
//filter panel
pnl_Filter.Hide();
if (panelName == "Dashboard")
{
// hide all other panels
pnl_Students.Hide();
btn_Filter.Hide();
btn_RemoveFilter.Hide();
pnl_Activity.Hide();
// show dashboard
pnl_Dashboard.Show();
img_Dashboard.Show();
}
else if (panelName == "Activities")
{
//
pnl_Dashboard.Hide();
img_Dashboard.Hide();
//pnl_Students.Hide();
pnl_EditDrink.Hide();
pnl_Drinks.Hide();
panel1Activity.Hide();
panel3Activity.Hide();
//
pnl_Activity.Show();
pnl_Students.Show();
//
DisplayListViewActivity();
}
else if (panelName == "Students")
{
// hide all other panels
pnl_Dashboard.Hide();
img_Dashboard.Hide();
btn_Filter.Hide();
btn_RemoveFilter.Hide();
pnl_Drinks.Hide();
pnl_EditDrink.Hide();
pnl_Activity.Hide();
// show students
lbl_Students.Text = "Students";
pnl_Students.Show();
// fill the students listview within the students panel with a list of students
SomerenLogic.Student_Service studService = new SomerenLogic.Student_Service();
List <Student> studentList = studService.GetStudents();
// clear the listview before filling it again
listViewStudents.Clear();
//add columns and allign
listViewStudents.Columns.Add("Student number");
listViewStudents.Columns[0].Width = 100;
listViewStudents.Columns.Add("First Name");
listViewStudents.Columns[1].Width = 125;
listViewStudents.Columns.Add("Last Name");
listViewStudents.Columns[2].Width = 125;
foreach (SomerenModel.Student s in studentList)
{
ListViewItem li = new ListViewItem(s.Number.ToString());
li.SubItems.Add(s.FirstName);
li.SubItems.Add(s.LastName);
listViewStudents.Items.Add(li);
}
}
else if (panelName == "Teachers")
{
//hiding the dashboard
pnl_Dashboard.Hide();
img_Dashboard.Hide();
btn_Filter.Hide();
pnl_Drinks.Hide();
pnl_EditDrink.Hide();
btn_RemoveFilter.Hide();
pnl_Activity.Hide();
//show teachers
lbl_Students.Text = "Teachers";
pnl_Students.Show();
// fill the Teachers listview within the Teachers panel with a list of lecturers
SomerenLogic.Lecturers_Service lecService = new SomerenLogic.Lecturers_Service();
List <Teacher> lecturersList = lecService.GetLecturers();
// clear the listview before filling it again
listViewStudents.Clear();
//Adding columns
listViewStudents.View = View.Details;
listViewStudents.Columns.Add("Teacher Number");
listViewStudents.Columns[0].Width = 100;
listViewStudents.Columns.Add("Name");
listViewStudents.Columns[1].Width = 125;
foreach (SomerenModel.Teacher s in lecturersList)
{
ListViewItem li = new ListViewItem(s.Number.ToString());
li.SubItems.Add(s.Name.ToString());
listViewStudents.Items.Add(li);
}
}
else if (panelName == "Rooms")
{
// hide all other panels
pnl_Dashboard.Hide();
img_Dashboard.Hide();
btn_Filter.Hide();
pnl_Drinks.Hide();
pnl_EditDrink.Hide();
btn_RemoveFilter.Hide();
pnl_Activity.Hide();
//show rooms
pnl_Students.Show();
lbl_Students.Text = "Rooms ";
//filling the roomList a list of rooms
SomerenLogic.Room_Service roomService = new SomerenLogic.Room_Service();
List <Room> roomList = roomService.GetRooms();
//clearing listView
listViewStudents.Clear();
//add columns and allign
listViewStudents.Columns.Add("Room Number");
listViewStudents.Columns[0].Width = 100;
listViewStudents.Columns.Add("Type");
listViewStudents.Columns[1].Width = 125;
listViewStudents.Columns.Add("Capacity");
listViewStudents.Columns[2].Width = 125;
foreach (SomerenModel.Room s in roomList)
{
ListViewItem li = new ListViewItem(s.Number.ToString());
if (s.Type == true)
{
li.SubItems.Add("teacher");
}
else
{
li.SubItems.Add("student");
}
li.SubItems.Add(s.Capacity.ToString());
listViewStudents.Items.Add(li);
//li.SubItems.Add(s.Type.ToString());
//saved for potential later use
}
}
else if (panelName == "Drinks")
{
//hiding the dashboard and other panels
pnl_Dashboard.Hide();
img_Dashboard.Hide();
pnl_Students.Hide();
pnl_EditDrink.Hide();
btn_Filter.Hide();
btn_RemoveFilter.Hide();
pnl_Activity.Hide();
//show drinks
lbl_Drinks.Text = "Drinks";
pnl_Drinks.Show();
// clear the listview before filling it again
listViewDrinks.Clear();
// fill the drinks listview within the drinks panel with a list of drinks
SomerenLogic.Drinks_Service drinkService = new SomerenLogic.Drinks_Service();
List <Drinks> drinksList = drinkService.GetDrinks();
//Adding columns
listViewDrinks.View = View.Details;
listViewDrinks.Columns.Add("Name");
listViewDrinks.Columns[0].Width = 100;
listViewDrinks.Columns.Add("Stock");
listViewDrinks.Columns[1].Width = 100;
listViewDrinks.Columns.Add("Price");
listViewDrinks.Columns[2].Width = 100;
foreach (SomerenModel.Drinks d in drinksList)
{
ListViewItem li = new ListViewItem(d.DrinkName.ToString());
if (d.Stock >= 10)
{
li.SubItems.Add("✔️" + " (" + d.Stock.ToString() + ")");
}
else
{
li.SubItems.Add("⚠️" + " (" + d.Stock.ToString() + ")");
}
li.SubItems.Add(d.Price.ToString());
listViewDrinks.Items.Add(li);
}
}
else if (panelName == "Edit drinks")
{
//hiding the dashboard
pnl_Dashboard.Hide();
img_Dashboard.Hide();
pnl_Drinks.Hide();
pnl_Students.Hide();
btn_Filter.Hide();
btn_RemoveFilter.Hide();
pnl_Activity.Hide();
//show datagridview drinks
pnl_EditDrink.Show();
}
else if (panelName == "RevenueReport")
{
//hide all other panels
pnl_Dashboard.Hide();
img_Dashboard.Hide();
pnl_Activity.Hide();
//show report
pnl_Students.Show();
btn_Filter.Show();
btn_RemoveFilter.Show();
lbl_Students.Text = "Revenue Report";
//clearing listView
listViewStudents.Clear();
//prep
listViewStudents.GridLines = false;
//calling the list with drinks
SomerenLogic.Drinks_Service drinkService = new SomerenLogic.Drinks_Service();
List <Drinks> drinksList = drinkService.GetDrinks();
//calling the list of students from the register
SomerenLogic.SomerenDAL CashService = new SomerenLogic.SomerenDAL();
List <Register> registerList = CashService.GetRegister();
//calculating sales and turnover
int Sales = 0, Customers = 0;
decimal Turnover = 0m;
foreach (SomerenModel.Drinks s in drinksList)
{
Sales += s.DrinkSold;
Turnover += (s.Price * s.DrinkSold);
}
//calculating the amount of customers
List <string> TempCustomerList = new List <string>();
foreach (Register s in registerList)
{
if (!TempCustomerList.Contains(s.StudentName))
{
TempCustomerList.Add(s.StudentName);
Customers++;
}
}
//displaying report
listViewStudents.Columns.Add("Sales");
listViewStudents.Columns[0].Width = 100;
listViewStudents.Columns.Add("Turnover");
listViewStudents.Columns[1].Width = 100;
listViewStudents.Columns.Add("Num of Customers");
listViewStudents.Columns[2].Width = 100;
ListViewItem li = new ListViewItem(Sales.ToString());
li.SubItems.Add("€ " + Turnover.ToString("0.00"));
li.SubItems.Add(Customers.ToString());
listViewStudents.Items.Add(li);
}
else if (panelName == "Supervisors")
{
//hiding the dashboard
pnl_Dashboard.Hide();
img_Dashboard.Hide();
pnl_Drinks.Hide();
pnl_EditDrink.Hide();
pnl_Students.Hide();
btn_Filter.Hide();
btn_RemoveFilter.Hide();
comboBoxAdd.Items.Clear();
comboBoxDelete.Items.Clear();
//show supervisor panel
pnl_Supervisor.Show();
// clear the listview before filling it again
listViewSupervisor.Clear();
// fill the drinks listview within the supervisor panel with a list of supervisor
SomerenLogic.Supervisor_Service supervisor_Service = new SomerenLogic.Supervisor_Service();
List <Supervisor> supervisors = supervisor_Service.GetSupervisors();
//Adding columns
listViewSupervisor.View = View.Details;
listViewSupervisor.Columns.Add("Name");
listViewSupervisor.Columns[0].Width = 100;
listViewSupervisor.Columns.Add("ID");
listViewSupervisor.Columns[1].Width = 100;
foreach (SomerenModel.Supervisor s in supervisors)
{
ListViewItem li = new ListViewItem(s.name);
li.SubItems.Add(s.LecturerID.ToString());
listViewSupervisor.Items.Add(li);
}
DisplayTeachersComboBox();
DisplaySupervisorsComboBox();
}
else if (panelName == "WeeklyTimetable")
{
//hiding all the other stuff
pnl_Dashboard.Hide();
img_Dashboard.Hide();
pnl_Drinks.Hide();
pnl_EditDrink.Hide();
pnl_Students.Hide();
btn_Filter.Hide();
btn_RemoveFilter.Hide();
//show report
pnl_Students.Show();
lbl_Students.Text = "Weekly Timetable";
//clearing listView
listViewStudents.Clear();
//calling the timetable list
SomerenLogic.Timetable_Service timetable_Service = new SomerenLogic.Timetable_Service();
List <Timetable> timetables = timetable_Service.GetTimetables();
//displaying timetable
listViewStudents.Columns.Add("Date");
listViewStudents.Columns[0].Width = 100;
listViewStudents.Columns.Add("Day of Week");
listViewStudents.Columns[1].Width = 100;
listViewStudents.Columns.Add("Activities");
listViewStudents.Columns[2].Width = 100;
listViewStudents.Columns.Add("Supervisors");
listViewStudents.Columns[3].Width = 100;
int counter = 0;
foreach (SomerenModel.Timetable s in timetables)
{
ListViewItem li = new ListViewItem(s.Date.ToShortDateString().ToString());
li.SubItems.Add(s.Date.DayOfWeek.ToString());
li.SubItems.Add(s.Activity);
li.SubItems.Add(s.Supervisor);
listViewStudents.Items.Add(li);
counter++;
if (counter == 7)
{
return;
}
}
}
}
private void showPanel(string panelName)
{
if (panelName == "Dashboard")
{
HideAllPanels();
// show dashboard
pnl_Dashboard.Show();
img_Dashboard.Show();
}
else if (panelName == "Students")
{
// hide all other panels
HideAllPanels();
// show students
pnl_Students.Show();
// fill the students listview within the students panel with a list of students
SomerenLogic.Student_Service studService = new SomerenLogic.Student_Service();
List <Student> studentList = studService.GetStudents();
// clear the listview before filling it again
listViewStudents.Clear();
//add columns
listViewStudents.Columns.Add("Student number");
listViewStudents.Columns[0].Width = 100;
listViewStudents.Columns.Add("First name");
listViewStudents.Columns[1].Width = 100;
listViewStudents.Columns.Add("Last name");
listViewStudents.Columns[2].Width = 100;
foreach (SomerenModel.Student s in studentList)
{
ListViewItem li = new ListViewItem(s.Number.ToString());
li.SubItems.Add(s.FirstName);
li.SubItems.Add(s.LastName);
listViewStudents.Items.Add(li);
}
}
else if (panelName == "Lecturers")
{
// Hide other panels
HideAllPanels();
// Show lecturers panel; clear listView
pnl_Lecturers.Show();
listViewLecturers.Clear();
// Add columns
listViewLecturers.Columns.Add("Lecturer ID");
listViewLecturers.Columns[0].Width = 100;
listViewLecturers.Columns.Add("First Name");
listViewLecturers.Columns[1].Width = 100;
listViewLecturers.Columns.Add("Last Name");
listViewLecturers.Columns[2].Width = 100;
listViewLecturers.Columns.Add("Is Supervisor");
listViewLecturers.Columns[3].Width = 100;
// Fill the lecturers listview within the lecturers panel with a list of lecturers
SomerenLogic.Lecturer_Service lecService = new SomerenLogic.Lecturer_Service();
List <Teacher> lecturerList = lecService.GetTeachers();
// Iterate over teachers
foreach (SomerenModel.Teacher t in lecturerList)
{
ListViewItem li = new ListViewItem(t.Number.ToString());
li.SubItems.Add(t.FirstName);
li.SubItems.Add(t.LastName);
// Parse supervisor status which is either 0 or 1.
if (t.Supervisor == 1)
{
li.SubItems.Add("Yes");
}
else
{
li.SubItems.Add("No");
}
listViewLecturers.Items.Add(li);
}
}
else if (panelName == "Drinks Supplies")
{
HideAllPanels();
//Show the panel
pnl_Drinks.Show();
listViewDrinks.Clear();
//Add columns
listViewDrinks.Columns.Add("Drink");
listViewDrinks.Columns[0].Width = 100;
listViewDrinks.Columns.Add("Token");
listViewDrinks.Columns[1].Width = 100;
listViewDrinks.Columns.Add("Stock");
listViewDrinks.Columns[2].Width = 100;
listViewDrinks.Columns.Add("Amount");
listViewDrinks.Columns[3].Width = 50;
// Fill the lecturers listview within the lecturers panel with a list of lecturers
SomerenLogic.Drink_Service drinkService = new SomerenLogic.Drink_Service();
List <Drink> drinksList = drinkService.GetDrinks();
foreach (SomerenModel.Drink d in drinksList)
{
ListViewItem li = new ListViewItem(d.Name);
li.SubItems.Add(d.Token.ToString());
li.SubItems.Add(d.Stock.ToString());
d.Amount = d.Stock;
//listing the sufficiency
if (d.Amount >= 10)
{
li.SubItems.Add("✔️");
}
else
{
li.SubItems.Add("⚠️");
}
li.SubItems.Add(d.DrinksSold.ToString());
listViewDrinks.Items.Add(li);
}
}
else if (panelName == "Edit drinks")
{
pnl_Drinks.Hide();
//show panel
pnl_UpdateDrinks.Show();
}
else if (panelName == "Revenue Report")
{
HideAllPanels();
SomerenLogic.Report_Service reportService = new SomerenLogic.Report_Service();
List <Report> reportsList = reportService.GetReports();
pnl_Report.Show();
}
else if (panelName == "Activities")
{
HideAllPanels();
pnl_Activities.Show();
// fill the students listview within the students panel with a list of students
SomerenLogic.Activity_Service actService = new SomerenLogic.Activity_Service();
List <Activity> studentList = actService.GetActivities();
// clear the listview before filling it again
listViewActivities.Clear();
//add columns
listViewActivities.Columns.Add("activity_id");
listViewActivities.Columns[0].Width = 100;
listViewActivities.Columns.Add("name");
listViewActivities.Columns[1].Width = 100;
listViewActivities.Columns.Add("number of students");
listViewActivities.Columns[2].Width = 100;
listViewActivities.Columns.Add("number of supervisors");
listViewActivities.Columns[2].Width = 100;
foreach (SomerenModel.Activity s in studentList)
{
ListViewItem li = new ListViewItem(s.activity_id.ToString());
li.SubItems.Add(s.name);
li.SubItems.Add(s.numberofstudents.ToString());
li.SubItems.Add(s.numberofsupervisors.ToString());
listViewActivities.Items.Add(li);
}
}
else if (panelName == "Supervisors")
{
HideAllPanels();
//show panel
pnl_Supervisor.Show();
listViewSupervisors.Clear();
DisplayAddCB();
DisplayRemoveCB();
SomerenLogic.Supervisor_Service supservice = new SomerenLogic.Supervisor_Service();
List <Supervisor> supList = supservice.GetSupervisors();
//Add columns
listViewSupervisors.View = View.Details;
listViewSupervisors.Columns.Add("Lecturer ID");
listViewSupervisors.Columns[0].Width = 80;
listViewSupervisors.Columns.Add("Name");
listViewSupervisors.Columns[1].Width = 120;
foreach (SomerenModel.Supervisor s in supList)
{
ListViewItem li = new ListViewItem(s.SupervisorID.ToString());
li.SubItems.Add(s.Name);
listViewSupervisors.Items.Add(li);
}
}
else if (panelName == "Time Table")
{
HideAllPanels();
clearTimetable();
SomerenLogic.Timetable_Service ttService = new SomerenLogic.Timetable_Service();
List <Activity> activities = ttService.GetTimetableData();
Dictionary <int, string> teacherNames = ttService.GetTeacherNames();
// Sort activities by day
DateTime actdate = activities[0].date;
foreach (Activity act in activities)
{
//int teacher1Id = (int)act.supervisor1;
string t1name = TeacherLookup(teacherNames, act.supervisor1);
string t2name = TeacherLookup(teacherNames, act.supervisor2);
// Check if no supervisor is assigned
if (t1name == "" && t2name == "")
{
t1name = "UNSUPERVISED!";
}
string day = act.date.DayOfWeek.ToString();
int month = act.date.Month;
int year = act.date.Year;
// Only check activities that are within the correct year and month.
if (year == 2016 && month == 4)
{
// Create a list view item
string time = act.date.ToString("H:mm");
ListViewItem item = new ListViewItem(time);
item.SubItems.Add(act.name);
item.SubItems.Add(t1name);
item.SubItems.Add(t2name);
// Switch case that filters activities by weekday. Since only monday and tuesday are relevant,
// those values are hardcoded as well.
switch (day)
{
case "Monday":
lv_mon.Items.Add(item);
break;
case "Tuesday":
lv_tue.Items.Add(item);
break;
}
}
}
SetColumnSizes();
pnl_Timetable.Show();
}
}
private void showPanel(string panelName)
{
if (panelName == "Dashboard")
{
// hide all other panels
pnl_Students.Hide();
pnl_Lecturers.Hide();
pnl_Room.Hide();
pnl_Beverage.Hide();
pnl_Revenue.Hide();
pnl_Register.Hide();
pnl_Guidance.Hide();
// show dashboard
pnl_Dashboard.Show();
img_Dashboard.Show();
}
else if (panelName == "Students")
{
// hide all other panels
pnl_Dashboard.Hide();
img_Dashboard.Hide();
pnl_Lecturers.Hide();
pnl_Room.Hide();
pnl_Beverage.Hide();
pnl_Revenue.Hide();
pnl_Register.Hide();
pnl_Guidance.Hide();
// show students
pnl_Students.Show();
pnl_Students.BringToFront();
// fill the students listview within the students panel with a list of students
SomerenLogic.Student_Service studService = new SomerenLogic.Student_Service();
List <Student> studentList = studService.GetStudents();
// clear the listview before filling it again
listViewStudents.View = View.Details;
listViewStudents.Clear();
listViewStudents.Columns.Add("Id");
listViewStudents.Columns.Add("First Name");
listViewStudents.Columns.Add("Last Name");
listViewStudents.Columns.Add("Birthdate");
foreach (SomerenModel.Student s in studentList)
{
ListViewItem li = new ListViewItem(s.Number.ToString());
var names = s.Name.Split(' ');
string firstName = names[0];
string lastName = "";
if (names.Count() > 0 && names[1] != null)
{
lastName = names[1];
}
li.SubItems.Add(firstName);
li.SubItems.Add(lastName);
li.SubItems.Add(s.BirthDate.ToString("dd/MM/yyyy"));
listViewStudents.Items.Add(li);
}
}
else if (panelName == "Lecturers")
{
pnl_Dashboard.Hide();
img_Dashboard.Hide();
pnl_Students.Hide();
pnl_Room.Hide();
pnl_Beverage.Hide();
pnl_Revenue.Hide();
pnl_Register.Hide();
pnl_Guidance.Hide();
pnl_Lecturers.Show();
// pnl_Lecturers.BringToFront();
SomerenLogic.Teacher_Service teachService = new SomerenLogic.Teacher_Service();
List <Teacher> teacherList = teachService.GetTeachers();
listViewTeachers.View = View.Details;
// clear the listview before filling it again
listViewTeachers.Clear();
// Maakt collums aan
listViewTeachers.Columns.Add("Id");
listViewTeachers.Columns.Add("First name");
listViewTeachers.Columns.Add("Last name");
listViewTeachers.Columns.Add("Guidance");
foreach (SomerenModel.Teacher t in teacherList)
{
ListViewItem li = new ListViewItem(t.Number.ToString());
//De naam splitsen naar voor naam en achter naam
var names = t.Name.Split(' ');
string firstName = names[0];
string lastName = "";
if (names.Count() > 0 && names[1] != null)
{
lastName = names[1];
}
li.SubItems.Add(firstName);
li.SubItems.Add(lastName);
//Bit naar duidelijke tekst
if (t.Guide == true)
{
li.SubItems.Add("Yes");
}
else
{
li.SubItems.Add("No");
}
listViewTeachers.Items.Add(li);
}
}
else if (panelName == "Rooms")
{
// hide all other panels
pnl_Dashboard.Hide();
img_Dashboard.Hide();
pnl_Lecturers.Hide();
pnl_Students.Hide();
pnl_Beverage.Hide();
pnl_Revenue.Hide();
pnl_Register.Hide();
pnl_Guidance.Hide();
// show rooms
pnl_Room.Show();
// fill the rooms listview within the rooms panel with a list of rooms
SomerenLogic.Room_Service romService = new SomerenLogic.Room_Service();
List <Room> roomList = romService.GetRooms();
listViewRooms.View = View.Details;
// clear the listview before filling it again
listViewRooms.Clear();
listViewRooms.Columns.Add("Nummer");
listViewRooms.Columns.Add("Type");
listViewRooms.Columns.Add("Capaciteit");
foreach (SomerenModel.Room s in roomList)
{
ListViewItem li = new ListViewItem(s.Number.ToString());
if (s.Type == true)
{
li.SubItems.Add("Teachers' room");
}
else
{
li.SubItems.Add("Students' room");
}
li.SubItems.Add(s.Capacity.ToString());
listViewRooms.Items.Add(li);
}
}
else if (panelName == "Beverages")
{
// hide all other panels
pnl_Dashboard.Hide();
img_Dashboard.Hide();
pnl_Lecturers.Hide();
pnl_Students.Hide();
pnl_Rooms.Hide();
pnl_Revenue.Hide();
pnl_Register.Hide();
pnl_Guidance.Hide();
// show rooms
pnl_Beverage.Show();
// fill the rooms listview within the rooms panel with a list of rooms
SomerenLogic.Beverage_Service bevService = new SomerenLogic.Beverage_Service();
List <Beverage> beverageList = bevService.GetBeverages();
listViewBeverages.View = View.Details;
// clear the listview before filling it again
listViewBeverages.Clear();
listViewBeverages.Columns.Add("Id");
listViewBeverages.Columns.Add("Name");
listViewBeverages.Columns.Add("Price");
listViewBeverages.Columns.Add("Alcoholic");
//listViewBeverages.Columns.Add("Total Sold");
//listViewBeverages.Columns.Add("Revenue");
//listViewBeverages.Columns.Add("Total Tax");
listViewBeverages.Columns.Add("Stock");
foreach (SomerenModel.Beverage s in beverageList)
{
ListViewItem li = new ListViewItem(s.Id.ToString());
li.SubItems.Add(s.Name);
li.SubItems.Add(s.Price.ToString());
if (s.Alcoholic == true)
{
li.SubItems.Add("Alcoholic Beverage");
}
else
{
li.SubItems.Add("Non Alcoholic Beverage");
}
//li.SubItems.Add(s.TotalSold.ToString());
//li.SubItems.Add(s.Revenue.ToString());
//li.SubItems.Add(s.TotalTax.ToString());
li.SubItems.Add(s.Stock.ToString());
listViewBeverages.Items.Add(li);
}
}
else if (panelName == "Revenue")
{
// hide all other panels
pnl_Dashboard.Hide();
img_Dashboard.Hide();
pnl_Lecturers.Hide();
pnl_Students.Hide();
pnl_Room.Hide();
pnl_Beverage.Hide();
pnl_Guidance.Hide();
//show Revenue
pnl_Revenue.Show();
// clear the listview before filling it again
SomerenLogic.Beverage_Service bevService = new SomerenLogic.Beverage_Service();
List <Beverage> beverageList = bevService.GetBeverages();
listViewRevenue.View = View.Details;
listViewRevenue.Clear();
listViewRevenue.Columns.Add("Beverage ID");
listViewRevenue.Columns.Add("Name");
listViewRevenue.Columns.Add("Total Sold");
listViewRevenue.Columns.Add("Revenue");
listViewRevenue.Columns.Add("Total Tax");
foreach (SomerenModel.Beverage s in beverageList)
{
ListViewItem li = new ListViewItem(s.Id.ToString());
li.SubItems.Add(s.Name);
li.SubItems.Add(s.TotalSold.ToString());
li.SubItems.Add(s.Revenue.ToString());
li.SubItems.Add(s.TotalTax.ToString());
listViewRevenue.Items.Add(li);
}
monthCalendarStartDate.Show();
monthCalendarEndDate.Show();
}
else if (panelName == "Register")
{
// hide all other panels
pnl_Dashboard.Hide();
img_Dashboard.Hide();
pnl_Lecturers.Hide();
pnl_Students.Hide();
pnl_Rooms.Hide();
pnl_Beverage.Hide();
pnl_Revenue.Hide();
pnl_Guidance.Hide();
// show register
pnl_Register.Show();
listViewRegisterB.View = View.Details;
listViewRegisterB.Clear();
listViewRegisterB.Columns.Add("Beverage ID");
listViewRegisterB.Columns.Add("Name");
listViewRegisterB.Columns.Add("Price");
listViewRegisterB.Columns.Add("Stock");
SomerenLogic.Beverage_Service becService = new SomerenLogic.Beverage_Service();
List <Beverage> beverageList = becService.GetBeverages();
foreach (SomerenModel.Beverage b in beverageList)
{
ListViewItem li = new ListViewItem(b.Id.ToString());
li.Tag = b;
li.SubItems.Add(b.Name);
li.SubItems.Add(b.Price.ToString());
li.SubItems.Add(b.Stock.ToString());
listViewRegisterB.Items.Add(li);
}
listViewRegister.View = View.Details;
// clear the listview before filling it again
listViewRegister.Clear();
listViewRegister.Columns.Add("Id");
listViewRegister.Columns.Add("Student name");
SomerenLogic.Student_Service studService = new SomerenLogic.Student_Service();
List <Student> studentList = studService.GetStudents();
foreach (SomerenModel.Student s in studentList)
{
ListViewItem li = new ListViewItem(s.Number.ToString());
li.Tag = s;
li.SubItems.Add(s.Name);
listViewRegister.Items.Add(li);
}
}
else if (panelName == "Guidance")
{
// hide all other panels
pnl_Dashboard.Hide();
img_Dashboard.Hide();
pnl_Lecturers.Hide();
pnl_Students.Hide();
pnl_Rooms.Hide();
pnl_Beverage.Hide();
pnl_Revenue.Hide();
pnl_Register.Hide();
pnl_Guidance.Show();
pnlGuidanceAdd.Hide();
pnlGuidanceDelete.Show();
listViewGuidance.View = View.Details;
listViewGuidance.Clear();
listViewGuidance.Columns.Add("Teacher ID");
listViewGuidance.Columns.Add("First name");
listViewGuidance.Columns.Add("Last name");
SomerenLogic.Guidance_Service guiService = new SomerenLogic.Guidance_Service();
List <Guidance> guidanceList = guiService.GetGuidances();
foreach (SomerenModel.Guidance g in guidanceList)
{
var names = g.TeacherName.Split(' ');
string firstName = names[0];
string lastName = "";
if (names.Count() > 0 && names[1] != null)
{
lastName = names[1];
}
ListViewItem li = new ListViewItem(g.TeacherId.ToString());
li.Tag = g;
li.SubItems.Add(g.TeacherName);
li.SubItems.Add(firstName);
li.SubItems.Add(lastName);
listViewGuidance.Items.Add(li);
}
listViewTeachersToGuidance.View = View.Details;
listViewTeachersToGuidance.Clear();
listViewTeachersToGuidance.Columns.Add("Teacher ID");
listViewTeachersToGuidance.Columns.Add("First name");
listViewTeachersToGuidance.Columns.Add("Last name");
SomerenLogic.Guidance_Service teachService = new SomerenLogic.Guidance_Service();
List <Guidance> teacherList = teachService.GetNotGuidance();
foreach (SomerenModel.Guidance g in teacherList)
{
var names = g.TeacherName.Split(' ');
string firstName = names[0];
string lastName = "";
if (names.Count() > 0 && names[1] != null)
{
lastName = names[1];
}
ListViewItem li = new ListViewItem(g.TeacherId.ToString());
li.Tag = g;
li.SubItems.Add(g.TeacherName);
li.SubItems.Add(firstName);
li.SubItems.Add(lastName);
listViewTeachersToGuidance.Items.Add(li);
}
}
}
private void showPanel(string panelName)
{
try
{
if (panelName == "Dashboard")
{
hideAllPanels();
// show dashboard
pnl_Dashboard.Show();
img_Dashboard.Show();
}
else if (panelName == "Revenue")
{
hideAllPanels();
pnl_Revenue.Show();
//pnl_Revenue.Show();
//lstvw_Revenue.Clear();
pnl_Revenue.Show();
mntclndr_Revenue.MaxDate = DateTime.Today;
}
else if (panelName == "Rooms")
{
hideAllPanels();
pnl_Rooms.Show();
// fill the rooms listview within the students panel with a list of students
SomerenLogic.Room_Service rmService = new SomerenLogic.Room_Service();
List <Room> roomList = rmService.GetRooms();
// clear the listview before filling it again
listViewRooms.Items.Clear();
foreach (SomerenModel.Room r in roomList)
{
ListViewItem li = new ListViewItem(r.Number.ToString());
li.SubItems.Add(r.Capacity.ToString());
li.SubItems.Add(r.Type);
listViewRooms.Items.Add(li);
}
}
else if (panelName == "Students")
{
// hide all other panels
hideAllPanels();
pnl_Students.Show();
// fill the students listview within the students panel with a list of students
SomerenLogic.Student_Service studService = new SomerenLogic.Student_Service();
studentList = studService.GetStudents();
// clear the listview before filling it again
listViewStudents.Items.Clear();
fillListViewStudents(studentList);
}
else if (panelName == "Teachers")
{
hideAllPanels();
pnl_Teachers.Show();
Teacher_Service lecService = new Teacher_Service();
List <Teacher> lectList = lecService.GetTeachers();
listViewTeachers.Items.Clear();
foreach (Teacher t in lectList)
{
ListViewItem item = new ListViewItem(t.Number.ToString());
item.SubItems.Add(t.Name);
listViewTeachers.Items.Add(item);
}
}
else if (panelName == "Activities")
{
hideAllPanels();
pnl_Activities.Show();
ResetModifyActivity();
}
else if (panelName == "RoomLayout")
{
hideAllPanels();
pnl_kamerindeling.Show();
// fill the Combobox within the kamerindeling panel with a list of the roomnumbers
SomerenLogic.Student_Service indelingService = new SomerenLogic.Student_Service();
List <Student> kamers = indelingService.GetKamers();
foreach (Student kamer in kamers)
{
comboBoxKamerindeling.Items.Add(kamer.RoomNumber);
}
}
else if (panelName == "Stock")
{
hideAllPanels();
pnl_Stock.Show();
Stock_Service stockService = new Stock_Service();
List <Stock> stockList = stockService.GetStocksCondition();
stockList = stockList.OrderBy(stockpile => stockpile.Name).ToList();
listViewStock.Items.Clear();
foreach (Stock stock in stockList)
{
ListViewItem item = new ListViewItem(stock.Name.ToString());
// ENOUGHT IN STOCK?
string icon;
if (stock.Stockpile >= 10)
{
icon = "✔ ";
}
else
{
icon = "❌ ";
}
item.SubItems.Add(icon + stock.Stockpile.ToString());
item.SubItems.Add(stock.Sellprice.ToString());
listViewStock.Items.Add(item);
}
}
else if (panelName == "ModifyStock")
{
hideAllPanels();
pnl_ModifyStock.Show();
ResetModifyStock();
}
else if (panelName == "Log")
{
hideAllPanels();
pnl_Log.Show();
listViewLogs.Items.Clear();
foreach (Log log in logList)
{
ListViewItem item = new ListViewItem(log.Date.ToString());
item.SubItems.Add(log.Message);
item.SubItems.Add(log.Source);
item.SubItems.Add(log.Method);
item.SubItems.Add(log.Fullname);
listViewLogs.Items.Add(item);
}
}
else if (panelName == "Cash Register")
{
hideAllPanels();
pnl_CashRegister.Show();
lvDrink.View = View.Details;
lvDrink.Columns.Add("ID", 30);
lvDrink.Columns.Add("Name");
lvDrink.Columns.Add("Kind", 100);
lvDrink.Columns.Add("Price");
lvDrink.Columns.Add("Amount Left", 75);
lvStudent.View = View.Details;
lvStudent.Columns.Add("ID", 30);
lvStudent.Columns.Add("Name", 100);
lvDrink.Items.Clear();
Stock_Service stockservice = new Stock_Service();
Student_Service studentService = new Student_Service();
foreach (Stock stock in stockservice.GetStocks())
{
//de lijst vullen met alle data in de juiste volgorde.
ListViewItem item = new ListViewItem(stock.Number.ToString());
item.SubItems.Add(stock.Name);
item.SubItems.Add(stock.Kind);
item.SubItems.Add((stock.Sellprice * ((decimal)stock.Tax / 100 + 1)).ToString("0.00"));
item.SubItems.Add(stock.SellAmounts.ToString());
lvDrink.Items.Add(item);
//"\u20AC " +
}
lvDrink.Select();
lvStudent.Items.Clear();
foreach (Student student in studentService.GetStudents())
{
ListViewItem item = new ListViewItem(student.Number.ToString());
item.SubItems.Add(student.Name);
lvStudent.Items.Add(item);
}
lvStudent.Select();
}
else if (panelName == "VAT Calculation")
{
hideAllPanels();
pnl_BTWBerekenen.Show();
}
}
catch (Exception exception)
{
Catch(exception);
}
}
private void showPanel(string panelName)
{
if (panelName == "Dashboard")
{
// hide all other panels
pnl_Students.Hide();
// show dashboard
pnl_Dashboard.Show();
img_Dashboard.Show();
}
else if (panelName == "Students")
{
// hide all other panels
pnl_Dashboard.Hide();
img_Dashboard.Hide();
lbl_checkedview.Text = "Students";
// show students
pnl_Students.Show();
// fill the students listview within the students panel with a list of students
SomerenLogic.Student_Service studService = new SomerenLogic.Student_Service();
List <Student> studentList = studService.GetStudents();
// clear the listview before filling it again
listView.Clear();
listView.Columns.Add("ID", 30);
listView.Columns.Add("Name", 100);
listView.Columns.Add("DayOfBirth", 200);
foreach (SomerenModel.Student student in studentList)
{
ListViewItem li = new ListViewItem(student.Number.ToString());
li.Tag = student;
li.SubItems.Add(student.Name);
li.SubItems.Add(student.BirthDate.ToString("dd/mm/yyyy"));
listView.Items.Add(li);
}
}
else if (panelName == "Lecturers")
{
//hide all other panels
pnl_Dashboard.Hide();
img_Dashboard.Hide();
//show students
pnl_Students.Show();
lbl_checkedview.Text = "Lecturers";
// fill the students listview within the students panel with a list of students
SomerenLogic.Teacher_Service TeacherService = new SomerenLogic.Teacher_Service();
List <Teacher> teacherList = TeacherService.GetTeachers();
//clear the listview before filling it again
listView.Clear();
listView.Columns.Add("ID", 30);
listView.Columns.Add("Name", 100);
//listView.Columns.Add("DayOfBirth", 200);
foreach (SomerenModel.Teacher t in teacherList)
{
ListViewItem li = new ListViewItem(t.Number.ToString());
li.SubItems.Add(t.Name);
listView.Items.Add(li);
}
}
else if (panelName == "Room")
{
// hide all other panels
pnl_Dashboard.Hide();
img_Dashboard.Hide();
//show students
pnl_Students.Show();
lbl_checkedview.Text = "Room";
//fill the students listview within the students panel with a list of students
SomerenLogic.Room_Service RoomService = new SomerenLogic.Room_Service();
List <Room> roomList = RoomService.GetRooms();
//clear the listview before filling it again
listView.Clear();
// Add columns
listView.Columns.Add("Number", 30);
listView.Columns.Add("Capacity", 40);
listView.Columns.Add("Type", 200);
foreach (SomerenModel.Room r in roomList)
{
ListViewItem li = new ListViewItem(r.Number.ToString());
li.SubItems.Add(r.Capacity.ToString());
if (r.Type == true)
{
li.SubItems.Add("Teacher");
}
else
{
li.SubItems.Add("Student");
}
listView.Items.Add(li);
}
}
}
private void showPanel(string panelName)
{
//dashboard
if (panelName == "Dashboard")
{
// hide all other panels
HidingPanels();
// show dashboard
pnl_Dashboard.Show();
img_Dashboard.Show();
}
//for students
else if (panelName == "Students")
{
// hide all other panels
HidingPanels();
// show students
pnl_Students.Show();
// fill the students listview within the students panel with a list of students
SomerenLogic.Student_Service studService = new SomerenLogic.Student_Service();
List <Student> studentList = studService.GetStudents();
// clear the listview before filling it again
listViewStudents.Clear();
///////remove this
listViewStudents.Columns.Add("Id");
listViewStudents.Columns.Add("First Name");
listViewStudents.Columns.Add("Last Name");
listViewStudents.Columns.Add("Year");
foreach (SomerenModel.Student s in studentList)
{
ListViewItem li = new ListViewItem(s.StudentNumber.ToString());
li.SubItems.Add(s.FirstName.ToString());
li.SubItems.Add(s.LastName.ToString());
li.SubItems.Add(s.Year.ToString());
listViewStudents.Items.Add(li);
}
}
//for lecturers
else if (panelName == "Lecturers")
{
HidingPanels();
PNL_TEACHERS.Show();
// fill the students listview within the students panel with a list of students
SomerenLogic.Teacher_Service teachService = new SomerenLogic.Teacher_Service();
List <Teacher> teacherList = teachService.GetTeachers();
// clear the listview before filling it again
listViewTeachers.Items.Clear();
foreach (SomerenModel.Teacher s in teacherList)
{
ListViewItem li = new ListViewItem(s.TeacherNumber.ToString());
li.SubItems.Add(s.FirstName.ToString());
li.SubItems.Add(s.LastName.ToString());
li.SubItems.Add(s.Speciality.ToString());
listViewTeachers.Items.Add(li);
}
}
// for rooms
else if (panelName == "Rooms")
{
//hiding the panels you dont wanna show
HidingPanels();
//showing Rooms
PNL_Rooms.Show();
//filling the rooms listview within the srooms panel with a list of rooms
SomerenLogic.Room_Service roomService = new SomerenLogic.Room_Service();
List <Room> roomList = roomService.GetRooms();
foreach (SomerenModel.Room r in roomList)
{
ListViewItem li = new ListViewItem(r.Number.ToString());
li.SubItems.Add(r.Capacity.ToString());
if (r.Type == true)
{
li.SubItems.Add("Teacher");
}
else
{
li.SubItems.Add("Student");
}
LV_Rooms.Items.Add(li);
}
}
//for drinks
if (panelName == "Drinks")
{
//hide panels
HidingPanels();
//Show the panel
Pnl_Drinks.Show();
listViewsDrinks.Items.Clear();
//Add columns
listViewsDrinks.Columns.Add("Id");
listViewsDrinks.Columns.Add("NameOfDrink");
listViewsDrinks.Columns[1].Width = 100;
listViewsDrinks.Columns.Add("Price");
listViewsDrinks.Columns.Add("Stock");
//listViewsDrinks.Columns.Add("studentId");
////listViewsDrinks.Columns[5].Width = 50;
listViewsDrinks.Columns.Add(" ");
listViewsDrinks.Columns.Add("Alcoholic");
// Fill the drink
LoadDrinks();
}
//for register
if (panelName == "Register")
{
//hide panels
HidingPanels();
//show pnl register
PNL_Register.Show();
Student_Service studentService = new Student_Service();
List <Student> studentList = studentService.GetStudents();
Drink_Service drinkService = new Drink_Service();
List <Drinks> drinkList = drinkService.GetDrinks();
listViewStudent.Items.Clear();
listViewStudent.Columns.Add("Student ID", 100);
listViewStudent.Columns.Add("Student Name", 200);
listViewDrink.Items.Clear();
//listViewDrink.Items.Add("DrinkID", 60);
listViewDrink.Columns.Add("DrinkID", 80);
listViewDrink.Columns.Add("DrinkName", 100);
listViewDrink.Columns.Add("Price", 80);
foreach (Student s in studentList)
{
ListViewItem li = new ListViewItem(s.StudentNumber.ToString());
li.SubItems.Add(s.FullName);
listViewStudent.Items.Add(li);
}
foreach (Drinks d in drinkList)
{
ListViewItem li = new ListViewItem(d.Id.ToString());
//li.SubItems.Add(d.NameOfDrink);
li.SubItems.Add(d.NameOfDrink);
li.SubItems.Add(d.Price.ToString());
listViewDrink.Items.Add(li);
}
}
//for revenue --> RETAKE
else if (panelName == "Revenue")
{
//hiding all other panels
HidingPanels();
//showing the revenue panel
PNL_Revenue.Show();
//generating the revenue table from database
ShowRevenue();
}
//for activities
if (panelName == "Activities")
{
//showing activities panel
PnlActivities.Show();
// clear the listview before filling it again
listViewActivities.Clear();
//add columns
listViewActivities.Columns.Add("Id");
listViewActivities.Columns[0].Width = 30;
listViewActivities.Columns.Add("ActivityName");
listViewActivities.Columns[1].Width = 100;
listViewActivities.Columns.Add("NumberofStudents");
listViewActivities.Columns[2].Width = 100;
listViewActivities.Columns.Add("NumberofSupervisors");
listViewActivities.Columns[3].Width = 130;
LoadActivities();
}
//for supervisors
else if (panelName == "Supervisors")
{
HidingPanels();
SomerenLogic.Teacher_Service teachService = new SomerenLogic.Teacher_Service();
List <Teacher> teacherList = teachService.GetSupervisors();
// clear the listview before filling it again
listViewSupervisors.Items.Clear();
foreach (SomerenModel.Teacher s in teacherList)
{
ListViewItem li = new ListViewItem(s.TeacherNumber.ToString());
li.SubItems.Add(s.FirstName.ToString());
li.SubItems.Add(s.LastName.ToString());
li.SubItems.Add(s.Speciality.ToString());
li.SubItems.Add(s.Supervisor.ToString());
listViewSupervisors.Items.Add(li);
}
}
//for timetbale
else if (panelName == "Timetable")
{
HidingPanels();
PNL_timetable.Show();
LV_Timetable.Items.Clear();
}
}
private void showPanel(string panelName)
{
try
{
if (panelName == "Dashboard")
{
// hide all other panels
pnl_Students.Hide();
//thigns i added
pnl_Teachers.Hide();
pnl_Students.Hide();
pnl_Rooms.Hide();
pnl_Sales.Hide();
pnl_Drinks.Hide();
pnl_Activities.Hide();
panel_TimeTable.Hide();
pnl_Supervisors.Hide();
//this is for the barservice
pnl_BarService.Hide();
// show dashboard
pnl_Dashboard.Show();
img_Dashboard.Show();
}
else if (panelName == "Students")
{
// hide all other panels
pnl_Dashboard.Hide();
img_Dashboard.Hide();
//things i added
pnl_Teachers.Hide();
pnl_Rooms.Hide();
pnl_Sales.Hide();
pnl_Drinks.Hide();
pnl_Activities.Hide();
panel_TimeTable.Hide();
pnl_Supervisors.Hide();
// show students
pnl_Students.Show();
// fill the students listview within the students panel with a list of students
SomerenLogic.Student_Service studService = new SomerenLogic.Student_Service();
List <Student> studentList = studService.GetStudents();
listViewStudents.Clear();
listViewStudents.View = View.Details;
listViewStudents.Columns.Add("Student Id", 100, HorizontalAlignment.Left);
listViewStudents.Columns.Add("First Name", 100, HorizontalAlignment.Left);
listViewStudents.Columns.Add("Last Name", 100, HorizontalAlignment.Left);
listViewStudents.Columns.Add("Class", 100, HorizontalAlignment.Left);
listViewStudents.Columns.Add("Contact Info", 100, HorizontalAlignment.Left);
// clear the listview before filling it again
foreach (SomerenModel.Student s in studentList)
{
ListViewItem li = new ListViewItem(s.Number.ToString());
li.SubItems.Add(s.FirstName);
li.SubItems.Add(s.LastName);
li.SubItems.Add(s.Group);
li.SubItems.Add(s.Contact);
listViewStudents.Items.Add(li);
}
}
else if (panelName == "Teachers")
{
// hide all other panels
pnl_Dashboard.Hide();
img_Dashboard.Hide();
//things that i added -stephen
pnl_Students.Hide();
pnl_Rooms.Hide();
pnl_BarService.Hide();
pnl_Sales.Hide();
pnl_Drinks.Hide();
pnl_Activities.Hide();
panel_TimeTable.Hide();
pnl_Supervisors.Hide();
// show Teachers
pnl_Teachers.Show();
// fill the teacher listview within the teacher panel with a list of teachers
SomerenLogic.Teacher_Service teacherService = new SomerenLogic.Teacher_Service();
List <Teacher> teacherList = teacherService.GetTeachers();
// clear the listview before filling it again
listViewTeachers.Clear();
foreach (SomerenModel.Teacher t in teacherList)
{
ListViewItem ListofT = new ListViewItem(t.Number.ToString());
ListofT.SubItems.Add(t.firstName);
ListofT.SubItems.Add(t.lastName);
ListofT.SubItems.Add(t.supervisor);
ListofT.SubItems.Add(t.Department);
ListofT.SubItems.Add(t.Contact.ToString());
listViewTeachers.Items.Add(ListofT);
}
// this is for the display
listViewTeachers.GridLines = true;
listViewTeachers.FullRowSelect = true;
listViewTeachers.View = View.Details;
listViewTeachers.Columns.Add("Teacher ID", 100, HorizontalAlignment.Left);
listViewTeachers.Columns.Add("First Name", 100, HorizontalAlignment.Left);
listViewTeachers.Columns.Add("Last Name", 100, HorizontalAlignment.Left);
listViewTeachers.Columns.Add("Supervisor", 100, HorizontalAlignment.Left);
listViewTeachers.Columns.Add("Department", 100, HorizontalAlignment.Left);
listViewTeachers.Columns.Add("Contact info.", 100, HorizontalAlignment.Left);
}
else if (panelName == "Rooms")
{
// hide all other panels
pnl_Dashboard.Hide();
img_Dashboard.Hide();
pnl_Students.Hide();
pnl_Teachers.Hide();
pnl_BarService.Hide();
pnl_Sales.Hide();
pnl_Drinks.Hide();
pnl_Activities.Hide();
panel_TimeTable.Hide();
pnl_Supervisors.Hide();
//show rooms
pnl_Rooms.Show();
//fill the rooms listview within rooms panel with a list of rooms
SomerenLogic.Room_Service studService = new SomerenLogic.Room_Service();
List <Room> roomList = studService.GetRooms();
// clear the listview before filling it again
listViewRooms.Clear();
listViewRooms.View = View.Details;
listViewRooms.Columns.Add("Room Id", 100, HorizontalAlignment.Left);
listViewRooms.Columns.Add("TypeOfRoom", 100, HorizontalAlignment.Left);
listViewRooms.Columns.Add("Taken/Not-Taken", 100, HorizontalAlignment.Left);
listViewRooms.Columns.Add("Size", 100, HorizontalAlignment.Left);
foreach (SomerenModel.Room r in roomList)
{
ListViewItem li = new ListViewItem(r.Room_Id.ToString());
li.SubItems.Add(r.Type);
li.SubItems.Add(r.Occupied);
li.SubItems.Add(r.Size.ToString());
listViewRooms.Items.Add(li);
}
}
else if (panelName == "Cash Register")
{
pnl_Dashboard.Hide();
pnl_Students.Hide();
pnl_Teachers.Hide();
pnl_Rooms.Hide();
pnl_Sales.Show();
pnl_Drinks.Hide();
panel_TimeTable.Hide();
pnl_Supervisors.Hide();
SomerenLogic.Cash_Service studService = new SomerenLogic.Cash_Service();
//List<CashRegister> drList = studService.GetDrinks();
SomerenLogic.Student_Service ss = new SomerenLogic.Student_Service();
List <Student> stList = ss.GetStudents();
comboBoxStudents.DataSource = stList;
comboBoxStudents.DisplayMember = "Name";
//checkedListBoxDrinks.DataSource = drList;
checkedListBoxDrinks.DisplayMember = "Name";
}
else if (panelName == "Bar Service")
{
// hide all other panels
pnl_Dashboard.Hide();
img_Dashboard.Hide();
pnl_Students.Hide();
pnl_Teachers.Hide();
pnl_Rooms.Hide();
pnl_Sales.Hide();
pnl_Drinks.Hide();
pnl_Activities.Hide();
//show the
//pnl_BarService.Show();
}
else if (panelName == "Drinks")
{
pnl_Dashboard.Hide();
img_Dashboard.Hide();
pnl_Students.Hide();
pnl_Teachers.Hide();
pnl_Rooms.Hide();
pnl_Sales.Hide();
pnl_BarService.Hide();
pnl_Activities.Hide();
panel_TimeTable.Hide();
pnl_Supervisors.Hide();
pnl_Drinks.Show();
ShowData();
}
else if (panelName == "Sales Report")
{
// hide all other panels
pnl_Dashboard.Hide();
img_Dashboard.Hide();
pnl_Students.Hide();
pnl_Teachers.Hide();
pnl_Rooms.Hide();
pnl_Sales.Hide();
pnl_Drinks.Hide();
pnl_Activities.Hide();
panel_TimeTable.Hide();
pnl_Supervisors.Hide();
StartCalendar.MaxDate = DateTime.Today;//this is for the calendar to only show the dates til today.
//show the
pnl_BarService.Show();
//this is to show all the transaction.. with no specific date, just all the current transaction in the
//the database.
SomerenLogic.Revenue_Service revenueService = new SomerenLogic.Revenue_Service();
List <Revenue> revenueList = revenueService.GetRevenue();
// clear the listview before filling it again
listViewRevenue.Clear();
foreach (SomerenModel.Revenue r in revenueList)
{
ListViewItem ListofRev = new ListViewItem((r.Students).ToString());//(r.Date.ToString("yyyy-dd-MM"));
//ListViewItem ListofRev = new ListViewItem((r.Date).ToString("dd-MM-yyyy"));
ListofRev.SubItems.Add((r.Price).ToString());
ListofRev.SubItems.Add((r.Prod_Sold).ToString());
ListofRev.SubItems.Add((r.Date).ToString("dd-MM-yyyy"));
ListofRev.SubItems.Add((r.Turnover).ToString());
listViewRevenue.Items.Add(ListofRev);
}
listViewRevenue.GridLines = true;
listViewRevenue.FullRowSelect = true;
listViewRevenue.View = View.Details;
listViewRevenue.Columns.Add("Student", 100, HorizontalAlignment.Left);
listViewRevenue.Columns.Add("Price", 100, HorizontalAlignment.Left);
listViewRevenue.Columns.Add("Amount product Sold", 120, HorizontalAlignment.Left);
listViewRevenue.Columns.Add("Date", 100, HorizontalAlignment.Left);
listViewRevenue.Columns.Add("Turnover", 100, HorizontalAlignment.Left);
//clear the list after for the display when the date is selecteds
lblmsg.Text = "General overview of transaction";
lblStart.Text = "";
lblEnd.Text = "";
}
else if (panelName == "Activities")
{
//hide
// hide all other panels
pnl_Dashboard.Hide();
img_Dashboard.Hide();
pnl_Students.Hide();
pnl_Teachers.Hide();
pnl_Rooms.Hide();
pnl_Sales.Hide();
pnl_Drinks.Hide();
panel_TimeTable.Hide();
pnl_Supervisors.Hide();
//show
pnl_Activities.Show();
SomerenLogic.Activities_Service activityService = new SomerenLogic.Activities_Service();
List <Activity> activityList = activityService.GetActivity();
//clear listview before filling in the informations
listViewActivity.Clear();
//the informations that needs to be shown
foreach (SomerenModel.Activity a in activityList)
{
ListViewItem ListofActivities = new ListViewItem(a.ID.ToString());
ListofActivities.SubItems.Add((a.Description));
ListofActivities.SubItems.Add(a.numbOfStudent.ToString());
ListofActivities.SubItems.Add(a.numbOfTeacher.ToString());
ListofActivities.Tag = a;
listViewActivity.Items.Add(ListofActivities);
}
listViewActivity.GridLines = true;
listViewActivity.FullRowSelect = true;
listViewActivity.View = View.Details;
listViewActivity.Columns.Add("Activity ID", 100, HorizontalAlignment.Left);
listViewActivity.Columns.Add("Description", 100, HorizontalAlignment.Left);
listViewActivity.Columns.Add("Number Of Students", 100, HorizontalAlignment.Left);
listViewActivity.Columns.Add("Number Of Supervisors", 100, HorizontalAlignment.Left);
}
else if (panelName == "Supervisors")
{
pnl_Dashboard.Hide();
img_Dashboard.Hide();
pnl_Students.Hide();
pnl_Teachers.Hide();
pnl_Rooms.Hide();
pnl_Sales.Hide();
pnl_Drinks.Hide();
pnl_BarService.Hide();
pnl_Activities.Hide();
panel_TimeTable.Hide();
pnl_Supervisors.Show();
//displaying datagridview in another method
DisplayDataSup();
//to get all the info from teacher's table
SomerenLogic.Teacher_Service teacherdb = new SomerenLogic.Teacher_Service();
List <Teacher> TeacherList = teacherdb.GetTeachers();
combo_Teacher.DataSource = TeacherList;
//only displaying the first name in the combo box
combo_Teacher.DisplayMember = "FirstName";
}
//time table
else if (panelName == "Time Table")
{
pnl_Dashboard.Hide();
img_Dashboard.Hide();
pnl_Students.Hide();
pnl_Teachers.Hide();
pnl_Rooms.Hide();
pnl_Sales.Hide();
pnl_Drinks.Hide();
pnl_Activities.Hide();
pnl_BarService.Hide();
pnl_Activities.Hide();
pnl_Supervisors.Hide();
//to show
panel_TimeTable.Show();
}
}
catch (Exception e)
{
MessageBox.Show(e.Message);
StreamWriter writer = new StreamWriter($"errorLog.txt", true);
writer.WriteLine($"{ DateTime.Now}, error message: {e.Message}");
writer.Close();
}
}
private void showPanel(string panelName)
{
if (panelName == "Dashboard")
{
// hide all other panels
pnl_Students.Hide();
pnl_Rooms.Hide();
// show dashboard
pnl_Dashboard.Show();
img_Dashboard.Show();
}
else if (panelName == "Students")
{
// hide all other panels
pnl_Dashboard.Hide();
img_Dashboard.Hide();
pnl_Rooms.Hide();
// show students
pnl_Students.Show();
// fill the students listview within the students panel with a list of students
SomerenLogic.Student_Service studService = new SomerenLogic.Student_Service();
List <Student> studentList = studService.GetStudents();
// clear the listview before filling it again
listViewStudents.Clear();
foreach (SomerenModel.Student s in studentList)
{
ListViewItem li = new ListViewItem(s.Name);
listViewStudents.Items.Add(li);
}
}
else if (panelName == "Rooms")
{
// hiding other panels except for rooms
pnl_Dashboard.Hide();
img_Dashboard.Hide();
pnl_Students.Hide();
// show room panel
pnl_Rooms.Show();
// filling rooms listview with a list of rooms (from room 201 - 225)
SomerenLogic.Room_Service roService = new SomerenLogic.Room_Service();
List <Room> roomList = roService.GetRooms();
// clear the listview, also add columns
listView_room.Clear();
listView_room.Columns.Add("Number");
listView_room.Columns.Add("Type");
listView_room.Columns.Add("Capacity");
foreach (SomerenModel.Room r in roomList)
{
ListViewItem li = new ListViewItem(r.Number.ToString());
if (r.Type == false)
{
string x = "student";
li.SubItems.Add(x);
}
else
{
string y = "lecturer";
li.SubItems.Add(y);
}
li.SubItems.Add(r.Capacity.ToString());
listView_room.Items.Add(li);
}
}
}
private void showPanel(string panelName)
{
if (panelName == "Dashboard")
{
// hide all other panels
pnl_Students.Hide();
pnl_Teachers.Hide();
pnl_Rooms.Hide();
pnl_StockDrinks.Hide();
pnl_CheckOut.Hide();
// show dashboard
pnl_Dashboard.Show();
img_Dashboard.Show();
}
else if (panelName == "Students")
{
// hide all other panels
pnl_Dashboard.Hide();
img_Dashboard.Hide();
pnl_Teachers.Hide();
pnl_Rooms.Hide();
pnl_StockDrinks.Hide();
pnl_CheckOut.Hide();
// show students
pnl_Students.Show();
// fill the students listview within the students panel with a list of students
List <Student> studentList = studService.GetStudents();
// clear the listview before filling it again
listViewStudents.Clear();
listViewStudents.View = View.Details;
listViewStudents.GridLines = true;
listViewStudents.FullRowSelect = true;
// Aanmaken van kolommen
listViewStudents.Columns.Add("Student Number", 100);
listViewStudents.Columns.Add("First Name", 100);
listViewStudents.Columns.Add("Last Name", 100);
string[] students = new string[3];
ListViewItem itm;
foreach (SomerenModel.Student s in studentList)
{
students[0] = s.Number.ToString();
students[1] = s.FirstName;
students[2] = s.LastName;
itm = new ListViewItem(students);
listViewStudents.Items.Add(itm);
}
}
else if (panelName == "Teachers")
{
// hide all other panels
pnl_Dashboard.Hide();
img_Dashboard.Hide();
pnl_Students.Hide();
pnl_Rooms.Hide();
pnl_StockDrinks.Hide();
pnl_CheckOut.Hide();
// show students
pnl_Teachers.Show();
// fill the students listview within the students panel with a list of students
SomerenLogic.Teacher_Service teachService = new SomerenLogic.Teacher_Service();
List <Teacher> teacherList = teachService.GetTeachers();
// clear the listview before filling it again
listViewTeachers.Clear();
listViewTeachers.View = View.Details;
listViewTeachers.GridLines = true;
listViewTeachers.FullRowSelect = true;
// Aanmaken van kollomen
listViewTeachers.Columns.Add("Teacher Number", 100);
listViewTeachers.Columns.Add("First Name", 100);
listViewTeachers.Columns.Add("Last Name", 100);
listViewTeachers.Columns.Add("Guide", 50);
string[] teachers = new string[4];
ListViewItem itm;
foreach (SomerenModel.Teacher t in teacherList)
{
// Items toevoegen aan een lijst
teachers[0] = t.Number.ToString();
teachers[1] = t.FirstName;
teachers[2] = t.LastName;
teachers[3] = t.Guide;
itm = new ListViewItem(teachers);
listViewTeachers.Items.Add(itm);
}
}
else if (panelName == "Rooms")
{
// hide all other panels
pnl_Dashboard.Hide();
img_Dashboard.Hide();
pnl_Students.Hide();
pnl_Teachers.Hide();
pnl_StockDrinks.Hide();
pnl_CheckOut.Hide();
// show rooms
pnl_Rooms.Show();
// fill the rooms listview within the rooms panel with a list of rooms
SomerenLogic.Room_Service roomService = new SomerenLogic.Room_Service();
List <Room> roomList = roomService.GetRooms();
// clear the listview before filling it again
listViewRooms.Clear();
listViewRooms.View = View.Details;
listViewRooms.GridLines = true;
listViewRooms.FullRowSelect = true;
// Aanmaken van kolommen
listViewRooms.Columns.Add("Room Number", 80);
listViewRooms.Columns.Add("Capacity", 80);
listViewRooms.Columns.Add("Room Type", 80);
string[] rooms = new string[3];
ListViewItem itm;
foreach (SomerenModel.Room r in roomList)
{
rooms[0] = r.Number.ToString();
rooms[1] = r.Capacity.ToString();
rooms[2] = r.Type;
itm = new ListViewItem(rooms);
listViewRooms.Items.Add(itm);
}
}
else if (panelName == "StockDrinks")
{
// hide all other panels
pnl_Dashboard.Hide();
img_Dashboard.Hide();
pnl_Students.Hide();
pnl_Teachers.Hide();
pnl_Rooms.Hide();
pnl_CheckOut.Hide();
// show stock
pnl_StockDrinks.Show();
// fill the listview with a list of the stock
List <StockDrinks> stockList = stockDrinksService.GetStock();
// clear the listview first before filling it again
listViewStockDrinks.Clear();
// laten zien van de tabel
listViewStockDrinks.View = View.Details;
listViewStockDrinks.GridLines = true;
listViewStockDrinks.FullRowSelect = true;
// Aanmaken van kollomen
listViewStockDrinks.Columns.Add("Name of drink");
listViewStockDrinks.Columns.Add("Stock");
listViewStockDrinks.Columns.Add("Voucher price");
}
else if (panelName == "CheckOut")
{
// hide all other panels
pnl_Dashboard.Hide();
img_Dashboard.Hide();
pnl_Students.Hide();
pnl_Teachers.Hide();
pnl_Rooms.Hide();
pnl_StockDrinks.Hide();
// show checkout
pnl_CheckOut.Show();
// lijsten
List <Student> studentList = studService.GetStudents();
List <StockDrinks> drinkList = stockDrinksService.GetStock();
// listview students
listViewStudentsCO.Clear();
listViewStudentsCO.View = View.Details;
listViewStudentsCO.GridLines = true;
listViewStudentsCO.CheckBoxes = true;
listViewStudentsCO.Columns.Add("Student Number", 80);
listViewStudentsCO.Columns.Add("First Name", 80);
listViewStudentsCO.Columns.Add("Last Name", 100);
string[] students = new string[3];
ListViewItem itm;
foreach (SomerenModel.Student s in studentList)
{
students[0] = s.Number.ToString();
students[1] = s.FirstName;
students[2] = s.LastName;
itm = new ListViewItem(students);
listViewStudentsCO.Items.Add(itm);
}
// listview drinks
listViewDrinksCO.Clear();
listViewDrinksCO.View = View.Details;
listViewDrinksCO.GridLines = true;
listViewDrinksCO.CheckBoxes = true;
listViewDrinksCO.Columns.Add("Name", 80);
listViewDrinksCO.Columns.Add("Price", 70);
listViewDrinksCO.Columns.Add("Stock", 70);
string[] drinks = new string[3];
foreach (SomerenModel.StockDrinks d in drinkList)
{
drinks[0] = d.Name;
drinks[1] = d.Price.ToString();
drinks[2] = d.Stock.ToString();
itm = new ListViewItem(drinks);
listViewDrinksCO.Items.Add(itm);
}
}
}
private void ShowPanel(string panelName)
{
if (panelName == "Dashboard")
{
// hide all other panels
pnl_Students.Hide();
pnl_Lecturers.Hide();
pnl_Rooms.Hide();
pnl_Activiteitenlijst.Hide();
pnl_Drank.Hide();
pnl_Kassa.Hide();
pnl_Omzetrapportage.Hide();
pnl_Begeleiders.Hide();
// show dashboard
pnl_Dashboard.Show();
img_Dashboard.Show();
}
else if (panelName == "Students")
{
// hide all other panels
pnl_Dashboard.Hide();
img_Dashboard.Hide();
pnl_Lecturers.Hide();
pnl_Rooms.Hide();
pnl_Activiteitenlijst.Hide();
pnl_Drank.Hide();
pnl_Kassa.Hide();
pnl_Omzetrapportage.Hide();
pnl_Begeleiders.Hide();
// show students
pnl_Students.Show();
// fill the students listview within the students panel with a list of students
SomerenLogic.Student_Service studService = new SomerenLogic.Student_Service();
List <Student> studentList = studService.GetStudents();
// clear the listview before filling it again
listViewStudents.Clear();
foreach (SomerenModel.Student s in studentList)
{
ListViewItem li = new ListViewItem(s.Studentname, s.Studentnumber);
listViewStudents.Items.Add(li);
}
}
else if (panelName == "Lecturers")
{
//hide all other panels
pnl_Dashboard.Hide();
img_Dashboard.Hide();
pnl_Students.Hide();
pnl_Rooms.Hide();
pnl_Activiteitenlijst.Hide();
pnl_Drank.Hide();
pnl_Kassa.Hide();
pnl_Omzetrapportage.Hide();
pnl_Begeleiders.Hide();
pnl_Lecturers.Show();
Teacher_Service teachService = new Teacher_Service();
List <Teacher> teacherList = teachService.GetTeachers();
listViewLecturers.Clear();
foreach (Teacher t in teacherList)
{
ListViewItem li = new ListViewItem(t.Teachername, t.Teachernumber);
listViewLecturers.Items.Add(li);
}
}
else if (panelName == "Rooms")
{
pnl_Dashboard.Hide();
img_Dashboard.Hide();
pnl_Students.Hide();
pnl_Lecturers.Hide();
pnl_Activiteitenlijst.Hide();
pnl_Drank.Hide();
pnl_Kassa.Hide();
pnl_Omzetrapportage.Hide();
pnl_Begeleiders.Hide();
pnl_Rooms.Show();
Room_Service roomService = new Room_Service();
List <Room> roomList = roomService.GetRooms();
ListRoomBox.Items.Clear();
foreach (Room r in roomList)
{
ListRoomBox.Items.Add(r.RoomToString());
}
}
else if (panelName == "Activities")
{
pnl_Dashboard.Hide();
img_Dashboard.Hide();
pnl_Students.Hide();
pnl_Lecturers.Hide();
pnl_Rooms.Hide();
pnl_Drank.Hide();
pnl_Kassa.Hide();
pnl_Omzetrapportage.Hide();
pnl_Begeleiders.Hide();
pnl_Activiteitenlijst.Show();
Activity_Service activityService = new Activity_Service();
List <Activity> activityList = activityService.GetActivities();
lv_Activiteitenlijst.Items.Clear();
cmb_Activiteiten.Items.Clear();
foreach (Activity a in activityList)
{
ListViewItem li = new ListViewItem(a.Number.ToString());
li.SubItems.Add(a.Description.ToString());
li.SubItems.Add(a.StartTime.ToString());
li.SubItems.Add(a.NumberofStudents.ToString());
li.SubItems.Add(a.NumberofLecturers.ToString());
lv_Activiteitenlijst.Items.Add(li);
cmb_Activiteiten.Items.Add(a.ActiviteitcmbBoxToString());
}
cmb_Activiteiten.SelectedIndex = 0;
}
else if (panelName == "Drank")
{
//Hide all other panels (once again)
pnl_Dashboard.Hide();
img_Dashboard.Hide();
pnl_Students.Hide();
pnl_Lecturers.Hide();
pnl_Rooms.Hide();
pnl_Activiteitenlijst.Hide();
pnl_Kassa.Hide();
pnl_Omzetrapportage.Hide();
pnl_Begeleiders.Hide();
//show the Drinks panel
pnl_Drank.Show();
Drank_Service drankService = new Drank_Service();
List <Drank> drankList = drankService.GetDrinks();
lv_Drank.Items.Clear();
foreach (Drank d in drankList)
{
//drankService.StockCheck(d);
ListViewItem li = new ListViewItem(d.DrankName.ToString());
li.SubItems.Add(d.StockAmount.ToString());
li.SubItems.Add(d.Price.ToString());
li.SubItems.Add(drankService.StockCheck(d));
lv_Drank.Items.Add(li);
}
}
else if (panelName == "Kassa")
{
//Hide all the other panels
pnl_Dashboard.Hide();
img_Dashboard.Hide();
pnl_Students.Hide();
pnl_Lecturers.Hide();
pnl_Rooms.Hide();
pnl_Activiteitenlijst.Hide();
pnl_Drank.Hide();
pnl_Omzetrapportage.Hide();
pnl_Begeleiders.Hide();
//show the Kassa panel
pnl_Kassa.Show();
cmb_Students.Items.Clear();
Student_Service studentService = new Student_Service();
List <Student> studentList = studentService.GetStudents();
foreach (Student s in studentList)
{
cmb_Students.Items.Add(s.Studentname);
}
//eerste student selecteren als standaard.
cmb_Students.SelectedIndex = 0;
cmb_Drinks.Items.Clear();
Drank_Service drinksService = new Drank_Service();
List <Drank> drankList = drinksService.GetAllDrinks();
foreach (Drank d in drankList)
{
cmb_Drinks.Items.Add(d.DrankName);
}
//eerste drank selecteren als standaard.
cmb_Drinks.SelectedIndex = 0;
Bestelling_Kassa_Service bestellingService = new Bestelling_Kassa_Service();
List <Bestelling> orderList = bestellingService.GetOrders();
//hier de listview van de bestellingen leegmaken om daarna weer te kunnen vullen
lv_Bestelling.Items.Clear();
foreach (Bestelling b in orderList)
{
//drankService.StockCheck(d);
ListViewItem Order = new ListViewItem(b.Bestellingsnummer.ToString());
Order.SubItems.Add(b.Datum.ToString());
Drank Ordereddrank = drinksService.GetDrankById(b.Dranknummer);
Order.SubItems.Add(Ordereddrank.DrankName.ToString());
Student OrderedStudent = studentService.GetStudentById(b.Studentnummer);
Order.SubItems.Add(OrderedStudent.Studentname.ToString());
lv_Bestelling.Items.Add(Order);
}
}
else if (panelName == "Omzetrapportage")
{
//Hide all the other panels
pnl_Dashboard.Hide();
img_Dashboard.Hide();
pnl_Students.Hide();
pnl_Lecturers.Hide();
pnl_Rooms.Hide();
pnl_Activiteitenlijst.Hide();
pnl_Drank.Hide();
pnl_Kassa.Hide();
pnl_Begeleiders.Hide();
//show this panel
pnl_Omzetrapportage.Show();
}
else if (panelName == "Begeleiders")
{
//Hide all the other panels
pnl_Dashboard.Hide();
img_Dashboard.Hide();
pnl_Students.Hide();
pnl_Lecturers.Hide();
pnl_Rooms.Hide();
pnl_Activiteitenlijst.Hide();
pnl_Drank.Hide();
pnl_Kassa.Hide();
pnl_Omzetrapportage.Hide();
//show this panel
pnl_Begeleiders.Show();
Begeleider_Service begeleiderService = new Begeleider_Service();
List <Begeleider> begeleiderList = begeleiderService.GetBegeleiders();
lv_Begeleiders.Items.Clear();
cmb_Begeleiders.Items.Clear();
foreach (Begeleider b in begeleiderList)
{
ListViewItem li = new ListViewItem(b.Begeleidernummer.ToString());
li.SubItems.Add(b.Teachernumber.ToString());
li.SubItems.Add(b.Teachername.ToString());
li.SubItems.Add(b.Subject.ToString());
li.SubItems.Add(b.Teacherroomnumber.ToString());
lv_Begeleiders.Items.Add(li);
cmb_Begeleiders.Items.Add(b.Begeleidernummer.ToString());
}
cmb_Begeleiders.SelectedIndex = 0;
Teacher_Service teacherService = new Teacher_Service();
List <Teacher> teacherList = teacherService.GetTeachers();
cmb_Docenten.Items.Clear();
foreach (Teacher t in teacherList)
{
cmb_Docenten.Items.Add(t.Teachernumber);
}
cmb_Docenten.SelectedIndex = 0;
}
}
private void showPanel(string panelName)
{
pnl_Dashboard.Hide();
img_Dashboard.Hide();
pnl_Teachers.Hide();
pnl_Verkoop.Hide();
pnl_rooms.Hide();
pnl_Students.Hide();
if (panelName == "Dashboard")
{
// show dashboard
pnl_Dashboard.Show();
img_Dashboard.Show();
}
else if (panelName == "Students")
{
// show students
pnl_Students.Show();
// fill the students listview within the students panel with a list of students
SomerenLogic.Student_Service studService = new SomerenLogic.Student_Service();
List <Student> studentList = studService.GetStudents();
// clear the listview before filling it again
listViewStudents.Items.Clear();
foreach (SomerenModel.Student s in studentList)
{
ListViewItem li = new ListViewItem(s.Name);
listViewStudents.Items.Add(li);
}
}
else if (panelName == "Teachers")
{
// show
pnl_Teachers.Show();
// fill the students listview within the students panel with a list of students
SomerenLogic.Teacher_Service teacherService = new SomerenLogic.Teacher_Service();
List <Teacher> teacherList = teacherService.GetTeachers();
// clear the listview before filling it again
listViewTeacher.Items.Clear();
foreach (SomerenModel.Teacher t in teacherList)
{
ListViewItem li = new ListViewItem(t.Name);
listViewTeacher.Items.Add(li);
}
}
else if (panelName == "Rooms")
{
// show
pnl_rooms.Show();
// fill the students listview within the students panel with a list of students
SomerenLogic.Room_Service roomService = new SomerenLogic.Room_Service();
List <Room> roomList = roomService.GetRooms();
// clear the listview before filling it again
listViewRooms.Items.Clear();
foreach (SomerenModel.Room t in roomList)
{
string type = "student";
if (t.Type)
{
type = "student";
}
else
{
type = "teacher";
}
ListViewItem li = new ListViewItem(t.Number.ToString() + " " + t.Capacity.ToString() + " " + type);
listViewRooms.Items.Add(li);
}
}
else if (panelName == "kassa")
{
pnl_Dashboard.Hide();
img_Dashboard.Hide();
pnl_Teachers.Hide();
pnl_Verkoop.Hide();
pnl_rooms.Hide();
pnl_Students.Hide();
pnl_kassa.Show();
Kassa_Service kassa_Service = new Kassa_Service();
List <Kassa> KassaList = kassa_Service.GetKassa();
lst_kassa.Items.Clear();
lst_kassa.View = View.Details;
lst_kassa.Columns.Add("Voornaam", 100, HorizontalAlignment.Left);
lst_kassa.Columns.Add("Drankje", 100, HorizontalAlignment.Left);
foreach (Kassa i in KassaList)
{
string[] buffer = new string[] {
i.Naam.ToString(), i.DrankjeNaam.ToString()
};
ListViewItem li = new ListViewItem(buffer);
lst_kassa.Items.Add(li);
}
lst_kassa.LabelEdit = true;
}
else if (panelName == "Verkoop")
{
// show
pnl_Verkoop.Show();
UpdateInventoryListView();
}
}