private List <Activity> GetActivities() { Activity_Service activityService = new Activity_Service(); List <Activity> activityList = activityService.GetActivities(); activityList = activityList.OrderBy(activity => activity.ActivityName).ToList(); return(activityList); }
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 ChangeAndAddActivity(string changeoradd) { //NEW GUIDES Activity_Service activity_Service = new Activity_Service(); List <Guide> guideNew = new List <Guide>(); List <string> guideNamesNew = new List <string>(); if (cbSelectGuideName1.Text != string.Empty) { Guide guide = new Guide() { GuideName = cbSelectGuideName1.Text, GuideNumber = int.Parse(lblGuideIdOutput1.Text), }; guideNew.Add(guide); } if (cbSelectGuideName2.Text != string.Empty) { Guide guide = new Guide() { GuideName = cbSelectGuideName2.Text, GuideNumber = int.Parse(lblGuideIdOutput2.Text), }; guideNew.Add(guide); } if (cbSelectGuideName3.Text != string.Empty) { Guide guide = new Guide() { GuideName = cbSelectGuideName3.Text, GuideNumber = int.Parse(lblGuideIdOutput3.Text), }; guideNew.Add(guide); } if (cbSelectGuideName4.Text != string.Empty) { Guide guide = new Guide() { GuideName = cbSelectGuideName4.Text, GuideNumber = int.Parse(lblGuideIdOutput4.Text), }; guideNew.Add(guide); } foreach (Guide guideNameNew in guideNew) { guideNamesNew.Add(guideNameNew.GuideName); } bool isUnique = guideNamesNew.Distinct().Count() == guideNamesNew.Count(); if (isUnique == false) { throw new Exception($"Not all guidenames are unique "); } TimeSpan startTime = dtpActivityStartDate.Value.TimeOfDay; TimeSpan endTime = dtpActivityEndDate.Value.TimeOfDay; DateTime date = dtpActivityDate.Value.Date; string activityName = txtActivityName.Text; int numberOfStudents = int.Parse(txtNumberOfStudents.Text); List <Guide> guideNew2 = new List <Guide>(guideNew); List <Guide> guideNew4 = new List <Guide>(guideNew); string output = ""; // check of de naam al wordt gebruikt activityList = activity_Service.GetActivities(); foreach (Activity activityL in activityList) { if (activityL.ActivityName == activityName) { string exc = $"There is already an activity with name {activityName}"; lblModifyActivityLogOutput.Text = exc; throw new Exception($"There is already an activity with name {activityName}"); } } if (changeoradd == "change") { guides = GetAllGuidesById(int.Parse(lblActivityIdOutput.Text)); string activityNameOld = cbSelectActivity.Text; int activityId = int.Parse(lblActivityIdOutput.Text); //CHANGE ACTIVITY //CHECK OLD WANS for (int i = 0; i < guides.Count; i++) { //als de nieuwe lijst een persoon uit de oude lijst bevat: schrijf de nieuwe info over de oude persoon heen //if (guideNew.Contains(guides[i])) if (guideNew.Any(guiden => guiden.GuideNumber == guides[i].GuideNumber)) { activity_Service.ChangeSchedule(activityId, guides[i].GuideNumber, date, startTime, endTime); //Verwijder uit de nieuwe begeleiderlijst de nog te doorlopen begeleider, je hebt hem hier immers al gecheckt. //CHECK WHO THIS IS AND REMOVE FROM NEW Guide guideSelect = guides[i]; List <Guide> guideNew3 = new List <Guide>(guideNew2); foreach (Guide guideN in guideNew3) { if (guideN.GuideNumber == guideSelect.GuideNumber) { guideNew2.Remove(guideN); } } } //als de nieuwe lijst de persoon uit de oude lijst niet bevat: verwijder de persoon uit de oude lijst else { activity_Service.DeleteFromSchedule(guides[i].GuideNumber); } } for (int i = 0; i < guideNew2.Count; i++) { //Hier zitten nu alleen unieke nieuwe waarden in. activity_Service.AddToSchedule(activityId, guideNew2[i].GuideNumber, date, startTime, endTime); } if (guideNew4.Count == 0) { try { activity_Service.DeleteFromSchedule(0); } catch { }; activity_Service.AddToSchedule(activityId, 0, date, startTime, endTime); } activity_Service.ChangeActivity(activityName, numberOfStudents, guideNamesNew.Count, activityNameOld); output = $"{activityName} has been changed in the database "; ResetModifyActivity(); lblModifyActivityLogOutput.Text = output; } else if (changeoradd == "add") { //ADD ACTIVITY activity_Service.AddToActivities(activityName, numberOfStudents, guideNamesNew.Count); //ADD GUIDES Activity activity = activity_Service.GetActivityByName(activityName); if (guideNew2.Count == 0) { for (int i = 0; i < guideNew2.Count; i++) { activity_Service.AddToSchedule(activity.ActivityNumber, guideNew2[i].GuideNumber, date, startTime, endTime); } } else { activity_Service.AddToSchedule(activity.ActivityNumber, 0, date, startTime, endTime); } lblModifyActivityLogOutput.Text = $"{activityName} has been changed in the database "; output = $"{activityName} has been added in the database "; } ResetModifyActivity(); lblModifyActivityLogOutput.Text = output; }
private void showPanel(string panelName) { hideAllPanels(); 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 List <Student> studentList = studService.GetStudents(); // clear the listview before filling it again listViewStudents.Items.Clear(); foreach (Student s in studentList) { ListViewItem li = new ListViewItem(s.Id.ToString()); li.Tag = s; li.SubItems.Add(s.FirstName); li.SubItems.Add(s.LastName); li.SubItems.Add(s.BirthDate.ToString("dd-mm-yyyy")); listViewStudents.Items.Add(li); } } else if (panelName == "Teachers") { // show teachers pnl_Teachers.Show(); // clear the listview before filling it again listViewTeachers.Items.Clear(); // fill the teachers listview within the teachers panel with a list of teachers List <Teacher> teacherList = teacher_Service.GetTeacher(); foreach (Teacher t in teacherList) { ListViewItem List = new ListViewItem(t.Id.ToString()); List.Tag = t; List.SubItems.Add(t.FirstName); List.SubItems.Add(t.LastName); List.SubItems.Add(t.RoomNumber.ToString()); List.SubItems.Add(t.Lead.ToString()); listViewTeachers.Items.Add(List); } } else if (panelName == "Rooms") { // show rooms pnl_Rooms.Show(); // fill the rooms listview within the rooms panel with a list of rooms List <Room> roomList = room_Service.GetRoom(); // clear the listview before filling it again ListViewRooms.Items.Clear(); foreach (Room t in roomList) { ListViewItem li = new ListViewItem(t.Number.ToString()); li.Tag = t; li.SubItems.Add(t.Capacity.ToString()); ListViewRooms.Items.Add(li); } } else if (panelName == "Activities") { //show activities panel pnl_Activity.Show(); // fill the activities listview within the panel with a list of activities List <Activity> activitiesList = activity_Service.GetActivities(); // clear the listview before filling it again listViewActivities.Items.Clear(); foreach (Activity a in activitiesList) { ListViewItem List = new ListViewItem(a.ActivityID.ToString()); List.Tag = a; List.SubItems.Add(a.Name); List.SubItems.Add(a.Date); List.SubItems.Add(a.NStudent.ToString()); List.SubItems.Add(a.NGuide.ToString()); listViewActivities.Items.Add(List); //List view task (right arrow) then View and then details to see the columns } } else if (panelName == "Register") { // show Register pnl_Register.Show(); // fill the rooms listview within the rooms panel with a list of rooms List <Drink> DrinkList = Drink_Service.GetDrink(); List <Student> StudentList = studService.GetStudents(); // clear the listview before filling it again listView_Register.Items.Clear(); listView_Register2.Items.Clear(); foreach (Drink t in DrinkList) { ListViewItem li = new ListViewItem(t.Id.ToString()); li.Tag = t; li.SubItems.Add(t.Name.ToString()); li.SubItems.Add(t.Price.ToString()); li.SubItems.Add(t.Alcoholic.ToString()); listView_Register.Items.Add(li); } foreach (Student t in StudentList) { ListViewItem li = new ListViewItem(t.Id.ToString()); li.Tag = t; li.SubItems.Add(t.FirstName.ToString()); li.SubItems.Add(t.LastName.ToString()); listView_Register2.Items.Add(li); } } else if (panelName == "Sales") { pnl_Sales.Show(); updateSales(); } else if (panelName == "Stock") { // show Stock pnl_Stock.Show(); // clear the listview before filling it again listViewStock.Items.Clear(); // fill the teachers listview within the teachers panel with a list of teachers List <Stock> stockList = stock_Service.GetStock(); foreach (Stock s in stockList) { ListViewItem List = new ListViewItem(s.DrinkID.ToString()); List.Tag = s; List.SubItems.Add(s.Name); List.SubItems.Add(s.Price.ToString()); List.SubItems.Add(s.Amount.ToString()); listViewStock.Items.Add(List); } } else if (panelName == "Attendants") { // show attendants pnl_Attendants.Show(); // clear the items of the two list views lv_Attendants.Items.Clear(); lv_NonAttendants.Items.Clear(); List <Teacher> attending = teacher_Service.GetAttending(); List <Teacher> non_attending = teacher_Service.GetNonAttending(); foreach (Teacher t in attending) { ListViewItem li = new ListViewItem(t.Id.ToString()); li.Tag = t; li.SubItems.Add(t.FirstName); li.SubItems.Add(t.LastName); li.SubItems.Add(t.RoomNumber.ToString()); lv_Attendants.Items.Add(li); } foreach (Teacher t in non_attending) { ListViewItem li = new ListViewItem(t.Id.ToString()); li.Tag = t; li.SubItems.Add(t.FirstName); li.SubItems.Add(t.LastName); li.SubItems.Add(t.RoomNumber.ToString()); lv_NonAttendants.Items.Add(li); } } else if (panelName == "Activities") { //show activities panel pnl_Activity.Show(); // fill the activities listview within the panel with a list of activities List <Activity> activitiesList = activity_Service.GetActivities(); // clear the listview before filling it again listViewActivities.Items.Clear(); foreach (Activity a in activitiesList) { ListViewItem List = new ListViewItem(a.ActivityID.ToString()); List.Tag = a; List.SubItems.Add(a.Name); List.SubItems.Add(a.Date); List.SubItems.Add(a.NStudent.ToString()); List.SubItems.Add(a.NGuide.ToString()); listViewActivities.Items.Add(List); //List view task (right arrow) then View and then details to see the columns } } else if (panelName == "Roster") { //show Roster panel pnl_Roster.Show(); // fill the Roster listview within the panel with a list of activities List <Activity> RosterList = activity_Service.GetActivities(); // clear the listview before filling it again listViewActivities.Items.Clear(); foreach (Activity a in RosterList) { ListViewItem List = new ListViewItem(a.Name.ToString()); List.SubItems.Add(a.Date); List.SubItems.Add(a.Time.ToString()); listView_Roster.Items.Add(List); //List view task (right arrow) then View and then details to see the columns } } }
private void showPanel(string panelName) { switch (panelName) { case "Students": Student_Service studService = new Student_Service(); List <Student> studentList = studService.GetStudents(); ListViewStuPrint(listViewStudents, studentList); break; case "Lecturers": Lecturer_Service lecService = new Lecturer_Service(); List <Teacher> lecList = lecService.GetTeachers(); ListViewLecPrint(listView_Lec, lecList); break; case "Supervisors": Supervisor_Service supService = new Supervisor_Service(); List <Supervisor> supList = supService.GetSupervisors(); PrintSup(listView_Sup, supList); Activity_Service actService = new Activity_Service(); List <Activity> actList = actService.GetActivities(); cmb_ActivityID.DataSource = actList; cmb_ActivityID.DisplayMember = "Name"; cmb_ActivityID.ValueMember = "ID"; break; case "Rooms": Room_Service roomService = new Room_Service(); List <Room> roomList = roomService.GetRooms(); ListViewRoomPrint(listViewRooms, roomList); break; case "DrinkSup": Btn_Supplies_Save.Enabled = false; Txt_Supplies_Id.Text = string.Empty; Txt_Supplies_NewName.Text = string.Empty; Txt_Supplies_NewStock.Text = string.Empty; Txt_Supplies_Price.Text = string.Empty; Txt_Supplies_Sold.Text = string.Empty; // fill the students listview within the students panel with a list of students Drink_Service drinkService = new Drink_Service(); List <Drink> DrinkList = drinkService.GetDrinks(); ListViewStockPrint(Lst_Supplies, DrinkList); break; case "Activities": Dtp_Activities_TimePart.Format = DateTimePickerFormat.Custom; Dtp_Activities_TimePart.CustomFormat = "hh:mm tt"; Dtp_Activities_TimePart.ShowUpDown = true; Txt_Activities_Id.Text = ""; Txt_Activities_Description.Text = ""; Txt_Activities_Location.Text = ""; Txt_Activities_Name.Text = ""; Dtp_Activities_DatePart.Value = DateTime.Today; Dtp_Activities_TimePart.Value = DateTime.UtcNow; Activity_Service actServe = new Activity_Service(); List <Activity> ActivityList = actServe.GetActivities(); ListViewActivitiesPrint(Lst_Activities, ActivityList); break; case "CashRegister": FillRegistryStudents(); FillRegistryDrinks(); Btn_Register_Checkout.Enabled = false; break; case "RevRep": mcRev.MaxDate = DateTime.Today; PrintReport(); break; case "Timetable": Timetable_Service timeServ = new Timetable_Service(); List <Timetable> TimetableList = timeServ.GetTimetable(); ListViewTimetablePrint(listViewTimetable, TimetableList); break; default: break; } }