//supervisor private void but_Addsup_Click(object sender, EventArgs e) { SomerenLogic.Teacher_Service stud = new SomerenLogic.Teacher_Service(); List <Teacher> stList = stud.GetTeachers(); // trying to make button work but it doesn't work int supervisorid = 0; int teacherid = 0; SomerenLogic.Supervisors_Service studService = new SomerenLogic.Supervisors_Service(); studService.Insert_Supervisor_Service(supervisorid, teacherid); DisplayDataSup(); ClearDataSup(); }
//button for adding a supervisor private void ADDSUPERVISOR_Click_1(object sender, EventArgs e) { pnl_SecondTeachers.Show(); SomerenLogic.Teacher_Service teachService = new SomerenLogic.Teacher_Service(); List <Teacher> teacherList = teachService.GetTeachers(); // clear the listview before filling it again listViewSecondTeachers.Items.Clear(); foreach (SomerenModel.Teacher s in teacherList) { ListViewItem li = new ListViewItem(s.FirstName.ToString()); li.SubItems.Add(s.LastName.ToString()); listViewSecondTeachers.Items.Add(li); } }
//button for removing a supervisor from the table private void REMOVESUPERVISOR_Click(object sender, EventArgs e) { SomerenLogic.Teacher_Service teachService = new SomerenLogic.Teacher_Service(); List <Teacher> teacherList = teachService.GetTeachers(); if (listViewSupervisors.Items.Count > 0) { ListViewItem items = listViewSupervisors.SelectedItems[0]; int teacherID = int.Parse(items.SubItems[0].Text); MessageBox.Show("Are you sure you want to delete supervisor?"); teachService.DeleteSupervisor(teacherID); showPanel("Supervisors"); } else { MessageBox.Show("Please select a teacher"); } }
//button for inserting a supervisor private void button2_Click(object sender, EventArgs e) { SomerenLogic.Teacher_Service teachService = new SomerenLogic.Teacher_Service(); // List<Teacher> teacherList = teachService.GetTeachers(); if (listViewSecondTeachers.Items.Count > 0) { ListViewItem items = listViewSecondTeachers.SelectedItems[0]; string firstName = items.SubItems[0].Text; string lastName = items.SubItems[1].Text; teachService.InsertSupervisors(firstName, lastName); showPanel("Supervisors"); } else { MessageBox.Show("Please select a teacher"); } }
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) { //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) { 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 }
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) { 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(); // 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) { 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_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) { 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(); } }