private void show_pnl_Order()
{
// only accesible when logged in as admin
if (role == "admin")
{
pnl_Order.Show();
}
// get all the drinks and students
SomerenLogic.Drink_Service drinkService = new SomerenLogic.Drink_Service();
List <Drink> drinkList = drinkService.GetDrinks();
SomerenLogic.Student_Service studService = new SomerenLogic.Student_Service();
List <Student> studentList = studService.GetStudents();
// Fill each combobox with either drinks or students
cmbDrinks.Items.Clear();
cmbStudents.Items.Clear();
foreach (Drink drink in drinkList)
{
cmbDrinks.Items.Add(drink.type);
}
cmbDrinks.SelectedIndex = 0; // selected index to 0
foreach (Student student in studentList)
{
cmbStudents.Items.Add(student.Name);
}
cmbStudents.SelectedIndex = 0; // selected index to 0
}
// Fill combobox with Student options
private void StudentInit()
{
SomerenLogic.Student_Service studService = new SomerenLogic.Student_Service();
List <Student> studentList = studService.GetStudents();
foreach (SomerenModel.Student s in studentList)
{
cmb_Student.Items.Add(s.FirstName + " " + s.LastName);
}
}
private void show_pnl_Students()
{
pnl_DisplayData.Show();
// fill a list with students by calling a function from the service layer
SomerenLogic.Student_Service studService = new SomerenLogic.Student_Service();
List <Student> studentList = studService.GetStudents();
// clear the DataGridView and fill the column names
ClearDataGridView();
generateGridLayout(studentList.FirstOrDefault().dataGridList());
// Fill the DatagridView with all the students using a foreach
foreach (var student in studentList)
{
FillDataInGridView(student.dataGrid(student));
}
}
private void radbtn_Lecturers_CheckedChanged(object sender, EventArgs e)
{
if (radbtn_Students.Checked)
{
SomerenLogic.Student_Service studService = new SomerenLogic.Student_Service();
List <Student> studList = studService.GetStudents();
cmbbox_Role.DataSource = studList;
cmbbox_Role.DisplayMember = "FirstName";
}
else
{
SomerenLogic.Teacher_Service teachService = new SomerenLogic.Teacher_Service();
List <Teacher> teachList = teachService.GetTeachers();
cmbbox_Role.DataSource = teachList;
cmbbox_Role.DisplayMember = "FirstName";
}
}
// Send payment to database (amount -1)
private void buttonPay_Click(object sender, EventArgs e)
{
SomerenLogic.Stock_Service stockService = new SomerenLogic.Stock_Service();
SomerenLogic.Student_Service studService = new SomerenLogic.Student_Service();
List <Student> studentList = studService.GetStudents();
// Get the name from the selected items
string studentName = cmb_Student.SelectedItem.ToString();
string drinkName = cmb_Drink.SelectedItem.ToString();
// Give a message that the payment has succeeded
testLabel.Text = studentName + " Has purchased " + drinkName;
stockService.SellItem(drinkName);
// Match the right studentnumber with the right name, then add a purchase to that student.
foreach (Student s in studentList)
{
string fullName = s.FirstName + " " + s.LastName;
if (fullName == studentName)
{
studService.AddPurchase(s.Number);
}
}
}
private void showPanel(string panelName)
{
if (panelName == "Dashboard")
{
// hide all other panels
pnl_Students.Hide();
pnl_Teachers.Hide();
pnl_Cash.Hide();
pnl_Drink.Hide();
//pnl_Rooms etc.. ******************************************* Add the rest
// show dashboard
pnl_Dashboard.Show();
picbox_Someren4.Show();
}
else if (panelName == "Students")
{
// hide all other panels
pnl_Dashboard.Hide();
picbox_Someren4.Hide();
pnl_Teachers.Hide();
pnl_Cash.Hide();
pnl_Drink.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();
listViewStudents.Columns.Add("Name");
foreach (SomerenModel.Student s in studentList)
{
// Add the name to the list
ListViewItem li = new ListViewItem(s.Firstname);
listViewStudents.Items.Add(li);
}
/* ************************************************* RADIO BUTTONS! Switch between detailed and compact
* listViewStudents.View = View.Details; ************************** Second option with first and last name: detailed view
*
* listViewStudents.Columns.Add("FirstName");
* listViewStudents.Columns.Add("LastName");
* foreach (SomerenModel.Student s in studentList)
* {
* ListViewItem li = new ListViewItem(s.Firstname);
* listViewStudents.Items.Add(li);
* li.SubItems.Add(s.Lastname);
* }
*/
}
else if (panelName == "Teachers")
{
// hide all other panels
pnl_Dashboard.Hide();
picbox_Someren4.Hide();
pnl_Students.Hide();
pnl_Cash.Hide();
pnl_Drink.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.Items.Clear();
listViewTeachers.Columns.Add("Teachers", 100, HorizontalAlignment.Left);
foreach (SomerenModel.Teacher t in teacherList)
{
ListViewItem li = new ListViewItem(t.FirstName);
listViewTeachers.Items.Add(li);
}
/*
* listViewTeachers.View = View.Details; ************************** Second option with first and last name: detailed view
*
* listViewTeachers.Columns.Add(" TeacherID", 100, HorizontalAlignment.Left);
* listViewTeachers.Columns.Add("FirstName", 100, HorizontalAlignment.Left);
* listViewTeachers.Columns.Add("LastName", 100, HorizontalAlignment.Left);
* listViewTeachers.Columns.Add("Supervisor", 100, HorizontalAlignment.Left);
*
* 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.Supervisor);
* listViewTeachers.Items.Add(li);
* }
*/
}
// ********************************************** have one list of rooms
else if (panelName == "StudentRoom")
{
// hide all other panels
pnl_Dashboard.Hide();
picbox_Someren4.Hide();
pnl_Cash.Hide();
pnl_Drink.Hide();
lbl_Students.Text = "Student's Room";
// show students
pnl_Students.Show();
// fill the students listview within the students panel with a list of students
SomerenLogic.Sroom_Service roomService = new SomerenLogic.Sroom_Service();
List <Room> roomList = roomService.GetRoom();
// clear the listview before filling it again
listViewStudents.Clear();
//Adding columns
listViewStudents.View = View.Details;
listViewStudents.Columns.Add("ID", -2, HorizontalAlignment.Left);
listViewStudents.Columns.Add("student/student", -2, HorizontalAlignment.Left);
listViewStudents.Columns.Add("capacity", -2, HorizontalAlignment.Left);
foreach (SomerenModel.Room s in roomList)
{
ListViewItem li = new ListViewItem(s.Number.ToString());
li.SubItems.Add(s.student);
li.SubItems.Add(s.Capacity.ToString());
listViewStudents.Items.Add(li);
}
}
else if (panelName == "TeacherRoom")
{
// hide all other panels
pnl_Dashboard.Hide();
picbox_Someren4.Hide();
pnl_Cash.Hide();
pnl_Drink.Hide();
lbl_Students.Text = "Teacher's Room";
// show students
pnl_Students.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.GetRoom();
// clear the listview before filling it again
listViewStudents.Clear();
//Adding columns
listViewStudents.View = View.Details;
listViewStudents.Columns.Add("ID", -2, HorizontalAlignment.Left);
listViewStudents.Columns.Add("teacher/student", -2, HorizontalAlignment.Left);
listViewStudents.Columns.Add("capacity", -2, HorizontalAlignment.Left);
foreach (SomerenModel.Room s in roomList)
{
ListViewItem li = new ListViewItem(s.Number.ToString());
li.SubItems.Add(s.teacher.ToString());
li.SubItems.Add(s.Capacity.ToString());
listViewStudents.Items.Add(li);
}
}
else if (panelName == "Drink Supplies")
{
pnl_Dashboard.Hide();
picbox_Someren4.Hide();
pnl_Students.Hide();
pnl_Teachers.Hide();
pnl_Cash.Hide();
// show drink panel
pnl_Drink.Show();
}
else if (panelName == "Cash Register")
{
// hide all other panels
pnl_Dashboard.Hide();
picbox_Someren4.Hide();
pnl_Students.Hide();
pnl_Teachers.Hide();
pnl_Drink.Hide();
// show cash panel
pnl_Cash.Show();
// ************************************ get list of drinks
//SomerenLogic.Drinks_Service drinksService = new SomerenLogic.Drinks_Service();
//List<Drinks> drinksList = drinksService.GetDrinkSupplies();
radbtn_Lecturers.Checked = true;
if (radbtn_Students.Checked)
{
SomerenLogic.Student_Service studService = new SomerenLogic.Student_Service();
List <Student> studList = studService.GetStudents();
cmbbox_Role.DataSource = studList;
cmbbox_Role.DisplayMember = "FirstName";
}
else
{
SomerenLogic.Teacher_Service teachService = new SomerenLogic.Teacher_Service();
List <Teacher> teachList = teachService.GetTeachers();
cmbbox_Role.DataSource = teachList;
cmbbox_Role.DisplayMember = "FirstName";
}
//((ListBox)list_Drinks).DataSource = drinksList;
//((ListBox)list_Drinks).DisplayMember = "Name";
}
}
private void showPanel(string panelName)
{
if (panelName == "Dashboard")
{
// hide all other panels
pnl_Students.Hide();
pnl_Teachers.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();
// 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();
listViewStudents.View = View.Details;
listViewStudents.Columns.Add(" StudentID", 100, HorizontalAlignment.Left);
listViewStudents.Columns.Add("Firstname", 100, HorizontalAlignment.Left);
listViewStudents.Columns.Add("Lastname", 100, HorizontalAlignment.Left);
foreach (SomerenModel.Student s in studentList)
{
//ListViewItem li = new ListViewItem(s.FirstName);
//listViewStudents.Items.Add(li);
ListViewItem li = new ListViewItem(s.studentID.ToString());
li.SubItems.Add(s.Firstname);
li.SubItems.Add(s.Lastname);
listViewStudents.Items.Add(li);
}
}
else if (panelName == "Teachers")
{
// hide all other panels
pnl_Dashboard.Hide();
img_Dashboard.Hide();
pnl_Students.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.Items.Clear();
listViewTeachers.View = View.Details;
listViewTeachers.Columns.Add(" TeacherID", 100, HorizontalAlignment.Left);
listViewTeachers.Columns.Add("FirstName", 100, HorizontalAlignment.Left);
listViewTeachers.Columns.Add("LastName", 100, HorizontalAlignment.Left);
listViewTeachers.Columns.Add("Supervisor", 100, HorizontalAlignment.Left);
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.Supervisor);
listViewTeachers.Items.Add(li);
}
}
else if (panelName == "StudentRoom")
{
// hide all other panels
pnl_Dashboard.Hide();
img_Dashboard.Hide();
lbl_Students.Text = "Student's Room";
// show students
pnl_Students.Show();
// fill the students listview within the students panel with a list of students
SomerenLogic.Sroom_Service roomService = new SomerenLogic.Sroom_Service();
List <Room> roomList = roomService.GetRoom();
// clear the listview before filling it again
listViewStudents.Clear();
//Adding columns
listViewStudents.View = View.Details;
listViewStudents.Columns.Add("ID", -2, HorizontalAlignment.Left);
listViewStudents.Columns.Add("student/student", -2, HorizontalAlignment.Left);
listViewStudents.Columns.Add("capacity", -2, HorizontalAlignment.Left);
foreach (SomerenModel.Room s in roomList)
{
ListViewItem li = new ListViewItem(s.Number.ToString());
li.SubItems.Add(s.student);
li.SubItems.Add(s.Capacity.ToString());
listViewStudents.Items.Add(li);
}
}
else if (panelName == "TeacherRoom")
{
// hide all other panels
pnl_Dashboard.Hide();
img_Dashboard.Hide();
lbl_Students.Text = "Teacher's Room";
// show students
pnl_Students.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.GetRoom();
// clear the listview before filling it again
listViewStudents.Clear();
//Adding columns
listViewStudents.View = View.Details;
listViewStudents.Columns.Add("ID", -2, HorizontalAlignment.Left);
listViewStudents.Columns.Add("teacher/student", -2, HorizontalAlignment.Left);
listViewStudents.Columns.Add("capacity", -2, HorizontalAlignment.Left);
foreach (SomerenModel.Room s in roomList)
{
ListViewItem li = new ListViewItem(s.Number.ToString());
li.SubItems.Add(s.teacher.ToString());
li.SubItems.Add(s.Capacity.ToString());
listViewStudents.Items.Add(li);
}
}
else if (panelName == "Revenue")
{
lbl_Students.Text = "Revenue";
pnl_Students.Show();
}
}
private void showPanel(string panelName)
{
if (panelName == "Dashboard")
{
// hide all other panels
HidePanels();
// show dashboard
pnl_Dashboard.Show();
img_Dashboard.Show();
}
else if (panelName == "Students")
{
// hide all other panels
HidePanels();
// show students
pnl_Students.Show();
// fill the students listview within the students panel with a list of students
SomerenLogic.Student_Service studService = new SomerenLogic.Student_Service();
List <Student> studentList = studService.GetStudents();
// clear the listview before filling it again
listViewStudents.Items.Clear();
// TODO: Listview Aanpassen
foreach (SomerenModel.Student s in studentList)
{
string studentName = (s.FirstName + " " + s.LastName);
ListViewItem li = new ListViewItem();
li.Text = s.Number.ToString();
li.SubItems.Add(studentName);
li.SubItems.Add(s.Class);
listViewStudents.Items.Add(li);
}
}
else if (panelName == "Lecturers")
{
// hide all other panels
HidePanels();
// show lecturers
pnl_Lecturers.Show();
SomerenLogic.Lecturer_Service lectureService = new SomerenLogic.Lecturer_Service();
List <Lecturer> lecturerList = lectureService.GetTeachers();
listViewLecturers.Items.Clear();
foreach (Lecturer l in lecturerList)
{
String lecturerName = (l.FirstName + " " + l.LastName);
ListViewItem li = new ListViewItem();
li.Text = l.Number.ToString();
li.SubItems.Add(lecturerName);
li.SubItems.Add(l.Course);
listViewLecturers.Items.Add(li);
}
}
else if (panelName == "Rooms")
{
// hide all other panels
HidePanels();
// show rooms
panelRooms.Show();
SomerenLogic.Room_Service roomService = new SomerenLogic.Room_Service();
List <Room> roomList = roomService.GetRooms();
listViewRooms.Items.Clear();
foreach (Room r in roomList)
{
ListViewItem li = new ListViewItem();
li.Text = r.Number.ToString();
li.SubItems.Add(r.Capacity.ToString());
li.SubItems.Add(r.Kind);
listViewRooms.Items.Add(li);
}
}
else if (panelName == "Stock")
{
// hide all other panels
HidePanels();
// show rooms
pnl_Stock.Show();
SomerenLogic.Stock_Service stockService = new SomerenLogic.Stock_Service();
List <Stock> stockList = stockService.GetStock();
listViewStock.Items.Clear();
foreach (Stock s in stockList)
{
ListViewItem li = new ListViewItem();
li.Text = s.Name;
li.SubItems.Add(s.Amount.ToString());
li.SubItems.Add(s.Price.ToString());
listViewStock.Items.Add(li);
}
}
else if (panelName == "Cash Register")
{
HidePanels();
// show register
pnl_CashRegister.Show();
StudentInit();
DrinkInit();
}
}
private void showPanel(string panelName)
{
if (panelName == "Dashboard")
{
// hide all other panels
HidePanels();
// show dashboard
pnl_Dashboard.Show();
img_Dashboard.Show();
}
else if (panelName == "Students")
{
// hide all other panels
HidePanels();
// show students
pnl_Students.Show();
// fill the students listview within the students panel with a list of students
SomerenLogic.Student_Service studService = new SomerenLogic.Student_Service();
List <Student> studentList = studService.GetStudents();
// clear the listview before filling it again
listViewStudents.Items.Clear();
// TODO: Listview Aanpassen
foreach (SomerenModel.Student s in studentList)
{
string studentName = (s.FirstName + " " + s.LastName);
ListViewItem li = new ListViewItem();
li.Text = s.Number.ToString();
li.SubItems.Add(studentName);
li.SubItems.Add(s.Class);
listViewStudents.Items.Add(li);
}
}
else if (panelName == "Lecturers")
{
// hide all other panels
HidePanels();
// show lecturers
pnl_Lecturers.Show();
SomerenLogic.Lecturer_Service lectureService = new SomerenLogic.Lecturer_Service();
List <Lecturer> lecturerList = lectureService.GetTeachers();
listViewLecturers.Items.Clear();
foreach (Lecturer l in lecturerList)
{
String lecturerName = (l.FirstName + " " + l.LastName);
ListViewItem li = new ListViewItem();
li.Text = l.Number.ToString();
li.SubItems.Add(lecturerName);
li.SubItems.Add(l.Course);
listViewLecturers.Items.Add(li);
}
}
else if (panelName == "Rooms")
{
// hide all other panels
HidePanels();
// show rooms
panelRooms.Show();
SomerenLogic.Room_Service roomService = new SomerenLogic.Room_Service();
List <Room> roomList = roomService.GetRooms();
listViewRooms.Items.Clear();
foreach (Room r in roomList)
{
ListViewItem li = new ListViewItem();
li.Text = r.Number.ToString();
li.SubItems.Add(r.Capacity.ToString());
li.SubItems.Add(r.Kind);
listViewRooms.Items.Add(li);
}
}
else if (panelName == "Stock")
{
// hide all other panels
HidePanels();
// show rooms
pnl_Stock.Show();
SomerenLogic.Stock_Service stockService = new SomerenLogic.Stock_Service();
List <Stock> stockList = stockService.GetStock();
listViewStock.Items.Clear();
foreach (Stock s in stockList)
{
ListViewItem li = new ListViewItem();
li.Text = s.Name;
li.SubItems.Add(s.Amount.ToString());
li.SubItems.Add(s.Price.ToString());
listViewStock.Items.Add(li);
}
}
else if (panelName == "Cash Register")
{
HidePanels();
// show register
pnl_CashRegister.Show();
cmb_Drink.Items.Clear();
cmb_Student.Items.Clear();
StudentInit();
DrinkInit();
}
else if (panelName == "Analysis")
{
HidePanels();
pnl_Analysis.Show();
SomerenLogic.Stock_Service stockService = new SomerenLogic.Stock_Service();
List <Stock> stockList = stockService.GetStock();
listViewAnalysis.Items.Clear();
foreach (Stock s in stockList)
{
ListViewItem li = new ListViewItem();
if (s.Sold >= 1)
{
li.Text = s.Name;
li.SubItems.Add(s.Amount.ToString());
li.SubItems.Add(s.Price.ToString());
listViewAnalysis.Items.Add(li);
}
}
}
else if (panelName == "Activities")
{
HidePanels();
pnl_Activities.Show();
listViewActivities.Items.Clear();
ShowActivities();
}
else if (panelName == "Attendants")
{
HidePanels();
pnl_Attendants.Show();
// show all current attendants
SomerenLogic.Attendant_Service AttendantService = new SomerenLogic.Attendant_Service();
List <Attendant> attendantList = AttendantService.GetAttendants();
listViewAttendants.Items.Clear();
foreach (Attendant a in attendantList)
{
String attendantName = (a.voornaam + " " + a.achternaam);
ListViewItem li = new ListViewItem();
li.Text = a.Id.ToString();
li.SubItems.Add(attendantName);
listViewAttendants.Items.Add(li);
}
}
else if (panelName == "DeleteAttendant")
{
pnl_DeleteAttendant.Show();
// show all current attendants
SomerenLogic.Attendant_Service AttendantService = new SomerenLogic.Attendant_Service();
List <Attendant> attendantList = AttendantService.GetAttendants();
listViewDeleteAttendant.Items.Clear();
foreach (Attendant a in attendantList)
{
String attendantName = (a.voornaam + " " + a.achternaam);
ListViewItem li = new ListViewItem();
li.Text = a.Id.ToString();
li.SubItems.Add(attendantName);
listViewDeleteAttendant.Items.Add(li);
}
}
else if (panelName == "AddAttendants")
{
pnl_AddAttendant.Show();
// show all non attendants
SomerenLogic.Attendant_Service AttendantService = new SomerenLogic.Attendant_Service();
List <Attendant> attendantList = AttendantService.GetNonAttendants();
listViewAddAttendant.Items.Clear();
foreach (Attendant a in attendantList)
{
String attendantName = (a.voornaam + " " + a.achternaam);
ListViewItem li = new ListViewItem();
li.Text = a.Id.ToString();
li.SubItems.Add(attendantName);
listViewAddAttendant.Items.Add(li);
}
}
else if (panelName == "Schedule")
{
HidePanels();
pnl_Schedule.Show();
ShowMonday();
}
}
