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;
}
}
