// Show the rooms
private void roomsToolStripMenuItem_Click(object sender, EventArgs e)
{
showPanel("Students");
lbl_Students.Text = ("Rooms");
listViewStudents.Items.Clear();
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());
listViewStudents.Items.Add(li);
}
}
private void showPanel(string panelName)
{
if (panelName == "Dashboard")
{
// hide all other panels
pnl_Students.Hide();
pnl_Rooms.Hide();
// show dashboard
pnl_Dashboard.Show();
img_Dashboard.Show();
}
else if (panelName == "Students")
{
// hide all other panels
pnl_Dashboard.Hide();
img_Dashboard.Hide();
pnl_Rooms.Hide();
// show students
pnl_Students.Show();
// fill the students listview within the students panel with a list of students
SomerenLogic.Student_Service studService = new SomerenLogic.Student_Service();
List <Student> studentList = studService.GetStudents();
// clear the listview before filling it again
listViewStudents.Clear();
foreach (SomerenModel.Student s in studentList)
{
ListViewItem li = new ListViewItem(s.Name);
listViewStudents.Items.Add(li);
}
}
else if (panelName == "Rooms")
{
// hiding other panels except for rooms
pnl_Dashboard.Hide();
img_Dashboard.Hide();
pnl_Students.Hide();
// show room panel
pnl_Rooms.Show();
// filling rooms listview with a list of rooms (from room 201 - 225)
SomerenLogic.Room_Service roService = new SomerenLogic.Room_Service();
List <Room> roomList = roService.GetRooms();
// clear the listview, also add columns
listView_room.Clear();
listView_room.Columns.Add("Number");
listView_room.Columns.Add("Type");
listView_room.Columns.Add("Capacity");
foreach (SomerenModel.Room r in roomList)
{
ListViewItem li = new ListViewItem(r.Number.ToString());
if (r.Type == false)
{
string x = "student";
li.SubItems.Add(x);
}
else
{
string y = "lecturer";
li.SubItems.Add(y);
}
li.SubItems.Add(r.Capacity.ToString());
listView_room.Items.Add(li);
}
}
}
private void showPanel(string panelName)
{
if (panelName == "Dashboard")
{
// hide all other panels
pnl_Students.Hide();
pnl_teachers.Hide();
pnl_Rooms.Hide();
pnl_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)
{
try
{
if (panelName == "Dashboard")
{
hideAllPanels();
// show dashboard
pnl_Dashboard.Show();
img_Dashboard.Show();
}
else if (panelName == "Revenue")
{
hideAllPanels();
pnl_Revenue.Show();
//pnl_Revenue.Show();
//lstvw_Revenue.Clear();
pnl_Revenue.Show();
mntclndr_Revenue.MaxDate = DateTime.Today;
}
else if (panelName == "Rooms")
{
hideAllPanels();
pnl_Rooms.Show();
// fill the rooms listview within the students panel with a list of students
SomerenLogic.Room_Service rmService = new SomerenLogic.Room_Service();
List <Room> roomList = rmService.GetRooms();
// clear the listview before filling it again
listViewRooms.Items.Clear();
foreach (SomerenModel.Room r in roomList)
{
ListViewItem li = new ListViewItem(r.Number.ToString());
li.SubItems.Add(r.Capacity.ToString());
li.SubItems.Add(r.Type);
listViewRooms.Items.Add(li);
}
}
else if (panelName == "Students")
{
// hide all other panels
hideAllPanels();
pnl_Students.Show();
// fill the students listview within the students panel with a list of students
SomerenLogic.Student_Service studService = new SomerenLogic.Student_Service();
studentList = studService.GetStudents();
// clear the listview before filling it again
listViewStudents.Items.Clear();
fillListViewStudents(studentList);
}
else if (panelName == "Teachers")
{
hideAllPanels();
pnl_Teachers.Show();
Teacher_Service lecService = new Teacher_Service();
List <Teacher> lectList = lecService.GetTeachers();
listViewTeachers.Items.Clear();
foreach (Teacher t in lectList)
{
ListViewItem item = new ListViewItem(t.Number.ToString());
item.SubItems.Add(t.Name);
listViewTeachers.Items.Add(item);
}
}
else if (panelName == "Activities")
{
hideAllPanels();
pnl_Activities.Show();
ResetModifyActivity();
}
else if (panelName == "RoomLayout")
{
hideAllPanels();
pnl_kamerindeling.Show();
// fill the Combobox within the kamerindeling panel with a list of the roomnumbers
SomerenLogic.Student_Service indelingService = new SomerenLogic.Student_Service();
List <Student> kamers = indelingService.GetKamers();
foreach (Student kamer in kamers)
{
comboBoxKamerindeling.Items.Add(kamer.RoomNumber);
}
}
else if (panelName == "Stock")
{
hideAllPanels();
pnl_Stock.Show();
Stock_Service stockService = new Stock_Service();
List <Stock> stockList = stockService.GetStocksCondition();
stockList = stockList.OrderBy(stockpile => stockpile.Name).ToList();
listViewStock.Items.Clear();
foreach (Stock stock in stockList)
{
ListViewItem item = new ListViewItem(stock.Name.ToString());
// ENOUGHT IN STOCK?
string icon;
if (stock.Stockpile >= 10)
{
icon = "✔ ";
}
else
{
icon = "❌ ";
}
item.SubItems.Add(icon + stock.Stockpile.ToString());
item.SubItems.Add(stock.Sellprice.ToString());
listViewStock.Items.Add(item);
}
}
else if (panelName == "ModifyStock")
{
hideAllPanels();
pnl_ModifyStock.Show();
ResetModifyStock();
}
else if (panelName == "Log")
{
hideAllPanels();
pnl_Log.Show();
listViewLogs.Items.Clear();
foreach (Log log in logList)
{
ListViewItem item = new ListViewItem(log.Date.ToString());
item.SubItems.Add(log.Message);
item.SubItems.Add(log.Source);
item.SubItems.Add(log.Method);
item.SubItems.Add(log.Fullname);
listViewLogs.Items.Add(item);
}
}
else if (panelName == "Cash Register")
{
hideAllPanels();
pnl_CashRegister.Show();
lvDrink.View = View.Details;
lvDrink.Columns.Add("ID", 30);
lvDrink.Columns.Add("Name");
lvDrink.Columns.Add("Kind", 100);
lvDrink.Columns.Add("Price");
lvDrink.Columns.Add("Amount Left", 75);
lvStudent.View = View.Details;
lvStudent.Columns.Add("ID", 30);
lvStudent.Columns.Add("Name", 100);
lvDrink.Items.Clear();
Stock_Service stockservice = new Stock_Service();
Student_Service studentService = new Student_Service();
foreach (Stock stock in stockservice.GetStocks())
{
//de lijst vullen met alle data in de juiste volgorde.
ListViewItem item = new ListViewItem(stock.Number.ToString());
item.SubItems.Add(stock.Name);
item.SubItems.Add(stock.Kind);
item.SubItems.Add((stock.Sellprice * ((decimal)stock.Tax / 100 + 1)).ToString("0.00"));
item.SubItems.Add(stock.SellAmounts.ToString());
lvDrink.Items.Add(item);
//"\u20AC " +
}
lvDrink.Select();
lvStudent.Items.Clear();
foreach (Student student in studentService.GetStudents())
{
ListViewItem item = new ListViewItem(student.Number.ToString());
item.SubItems.Add(student.Name);
lvStudent.Items.Add(item);
}
lvStudent.Select();
}
else if (panelName == "VAT Calculation")
{
hideAllPanels();
pnl_BTWBerekenen.Show();
}
}
catch (Exception exception)
{
Catch(exception);
}
}
private void showPanel(string panelName)
{
if (panelName == "Dashboard")
{
// hide all other panels
pnl_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 (IamAdmin == false)
{
btnAdd.Hide();
btnChange.Hide();
btnRemove.Hide();
btnSubmit.Hide();
btn_EditDrinks.Hide();
btn_saveDrink.Hide();
btn_Add.Hide();
btn_Remove.Hide();
}
DisplayActivityID();
//normally hidden stuff:
//filter panel
pnl_Filter.Hide();
if (panelName == "Dashboard")
{
// hide all other panels
pnl_Students.Hide();
btn_Filter.Hide();
btn_RemoveFilter.Hide();
pnl_Activity.Hide();
// show dashboard
pnl_Dashboard.Show();
img_Dashboard.Show();
}
else if (panelName == "Activities")
{
//
pnl_Dashboard.Hide();
img_Dashboard.Hide();
//pnl_Students.Hide();
pnl_EditDrink.Hide();
pnl_Drinks.Hide();
panel1Activity.Hide();
panel3Activity.Hide();
//
pnl_Activity.Show();
pnl_Students.Show();
//
DisplayListViewActivity();
}
else if (panelName == "Students")
{
// hide all other panels
pnl_Dashboard.Hide();
img_Dashboard.Hide();
btn_Filter.Hide();
btn_RemoveFilter.Hide();
pnl_Drinks.Hide();
pnl_EditDrink.Hide();
pnl_Activity.Hide();
// show students
lbl_Students.Text = "Students";
pnl_Students.Show();
// fill the students listview within the students panel with a list of students
SomerenLogic.Student_Service studService = new SomerenLogic.Student_Service();
List <Student> studentList = studService.GetStudents();
// clear the listview before filling it again
listViewStudents.Clear();
//add columns and allign
listViewStudents.Columns.Add("Student number");
listViewStudents.Columns[0].Width = 100;
listViewStudents.Columns.Add("First Name");
listViewStudents.Columns[1].Width = 125;
listViewStudents.Columns.Add("Last Name");
listViewStudents.Columns[2].Width = 125;
foreach (SomerenModel.Student s in studentList)
{
ListViewItem li = new ListViewItem(s.Number.ToString());
li.SubItems.Add(s.FirstName);
li.SubItems.Add(s.LastName);
listViewStudents.Items.Add(li);
}
}
else if (panelName == "Teachers")
{
//hiding the dashboard
pnl_Dashboard.Hide();
img_Dashboard.Hide();
btn_Filter.Hide();
pnl_Drinks.Hide();
pnl_EditDrink.Hide();
btn_RemoveFilter.Hide();
pnl_Activity.Hide();
//show teachers
lbl_Students.Text = "Teachers";
pnl_Students.Show();
// fill the Teachers listview within the Teachers panel with a list of lecturers
SomerenLogic.Lecturers_Service lecService = new SomerenLogic.Lecturers_Service();
List <Teacher> lecturersList = lecService.GetLecturers();
// clear the listview before filling it again
listViewStudents.Clear();
//Adding columns
listViewStudents.View = View.Details;
listViewStudents.Columns.Add("Teacher Number");
listViewStudents.Columns[0].Width = 100;
listViewStudents.Columns.Add("Name");
listViewStudents.Columns[1].Width = 125;
foreach (SomerenModel.Teacher s in lecturersList)
{
ListViewItem li = new ListViewItem(s.Number.ToString());
li.SubItems.Add(s.Name.ToString());
listViewStudents.Items.Add(li);
}
}
else if (panelName == "Rooms")
{
// hide all other panels
pnl_Dashboard.Hide();
img_Dashboard.Hide();
btn_Filter.Hide();
pnl_Drinks.Hide();
pnl_EditDrink.Hide();
btn_RemoveFilter.Hide();
pnl_Activity.Hide();
//show rooms
pnl_Students.Show();
lbl_Students.Text = "Rooms ";
//filling the roomList a list of rooms
SomerenLogic.Room_Service roomService = new SomerenLogic.Room_Service();
List <Room> roomList = roomService.GetRooms();
//clearing listView
listViewStudents.Clear();
//add columns and allign
listViewStudents.Columns.Add("Room Number");
listViewStudents.Columns[0].Width = 100;
listViewStudents.Columns.Add("Type");
listViewStudents.Columns[1].Width = 125;
listViewStudents.Columns.Add("Capacity");
listViewStudents.Columns[2].Width = 125;
foreach (SomerenModel.Room s in roomList)
{
ListViewItem li = new ListViewItem(s.Number.ToString());
if (s.Type == true)
{
li.SubItems.Add("teacher");
}
else
{
li.SubItems.Add("student");
}
li.SubItems.Add(s.Capacity.ToString());
listViewStudents.Items.Add(li);
//li.SubItems.Add(s.Type.ToString());
//saved for potential later use
}
}
else if (panelName == "Drinks")
{
//hiding the dashboard and other panels
pnl_Dashboard.Hide();
img_Dashboard.Hide();
pnl_Students.Hide();
pnl_EditDrink.Hide();
btn_Filter.Hide();
btn_RemoveFilter.Hide();
pnl_Activity.Hide();
//show drinks
lbl_Drinks.Text = "Drinks";
pnl_Drinks.Show();
// clear the listview before filling it again
listViewDrinks.Clear();
// fill the drinks listview within the drinks panel with a list of drinks
SomerenLogic.Drinks_Service drinkService = new SomerenLogic.Drinks_Service();
List <Drinks> drinksList = drinkService.GetDrinks();
//Adding columns
listViewDrinks.View = View.Details;
listViewDrinks.Columns.Add("Name");
listViewDrinks.Columns[0].Width = 100;
listViewDrinks.Columns.Add("Stock");
listViewDrinks.Columns[1].Width = 100;
listViewDrinks.Columns.Add("Price");
listViewDrinks.Columns[2].Width = 100;
foreach (SomerenModel.Drinks d in drinksList)
{
ListViewItem li = new ListViewItem(d.DrinkName.ToString());
if (d.Stock >= 10)
{
li.SubItems.Add("✔️" + " (" + d.Stock.ToString() + ")");
}
else
{
li.SubItems.Add("⚠️" + " (" + d.Stock.ToString() + ")");
}
li.SubItems.Add(d.Price.ToString());
listViewDrinks.Items.Add(li);
}
}
else if (panelName == "Edit drinks")
{
//hiding the dashboard
pnl_Dashboard.Hide();
img_Dashboard.Hide();
pnl_Drinks.Hide();
pnl_Students.Hide();
btn_Filter.Hide();
btn_RemoveFilter.Hide();
pnl_Activity.Hide();
//show datagridview drinks
pnl_EditDrink.Show();
}
else if (panelName == "RevenueReport")
{
//hide all other panels
pnl_Dashboard.Hide();
img_Dashboard.Hide();
pnl_Activity.Hide();
//show report
pnl_Students.Show();
btn_Filter.Show();
btn_RemoveFilter.Show();
lbl_Students.Text = "Revenue Report";
//clearing listView
listViewStudents.Clear();
//prep
listViewStudents.GridLines = false;
//calling the list with drinks
SomerenLogic.Drinks_Service drinkService = new SomerenLogic.Drinks_Service();
List <Drinks> drinksList = drinkService.GetDrinks();
//calling the list of students from the register
SomerenLogic.SomerenDAL CashService = new SomerenLogic.SomerenDAL();
List <Register> registerList = CashService.GetRegister();
//calculating sales and turnover
int Sales = 0, Customers = 0;
decimal Turnover = 0m;
foreach (SomerenModel.Drinks s in drinksList)
{
Sales += s.DrinkSold;
Turnover += (s.Price * s.DrinkSold);
}
//calculating the amount of customers
List <string> TempCustomerList = new List <string>();
foreach (Register s in registerList)
{
if (!TempCustomerList.Contains(s.StudentName))
{
TempCustomerList.Add(s.StudentName);
Customers++;
}
}
//displaying report
listViewStudents.Columns.Add("Sales");
listViewStudents.Columns[0].Width = 100;
listViewStudents.Columns.Add("Turnover");
listViewStudents.Columns[1].Width = 100;
listViewStudents.Columns.Add("Num of Customers");
listViewStudents.Columns[2].Width = 100;
ListViewItem li = new ListViewItem(Sales.ToString());
li.SubItems.Add("€ " + Turnover.ToString("0.00"));
li.SubItems.Add(Customers.ToString());
listViewStudents.Items.Add(li);
}
else if (panelName == "Supervisors")
{
//hiding the dashboard
pnl_Dashboard.Hide();
img_Dashboard.Hide();
pnl_Drinks.Hide();
pnl_EditDrink.Hide();
pnl_Students.Hide();
btn_Filter.Hide();
btn_RemoveFilter.Hide();
comboBoxAdd.Items.Clear();
comboBoxDelete.Items.Clear();
//show supervisor panel
pnl_Supervisor.Show();
// clear the listview before filling it again
listViewSupervisor.Clear();
// fill the drinks listview within the supervisor panel with a list of supervisor
SomerenLogic.Supervisor_Service supervisor_Service = new SomerenLogic.Supervisor_Service();
List <Supervisor> supervisors = supervisor_Service.GetSupervisors();
//Adding columns
listViewSupervisor.View = View.Details;
listViewSupervisor.Columns.Add("Name");
listViewSupervisor.Columns[0].Width = 100;
listViewSupervisor.Columns.Add("ID");
listViewSupervisor.Columns[1].Width = 100;
foreach (SomerenModel.Supervisor s in supervisors)
{
ListViewItem li = new ListViewItem(s.name);
li.SubItems.Add(s.LecturerID.ToString());
listViewSupervisor.Items.Add(li);
}
DisplayTeachersComboBox();
DisplaySupervisorsComboBox();
}
else if (panelName == "WeeklyTimetable")
{
//hiding all the other stuff
pnl_Dashboard.Hide();
img_Dashboard.Hide();
pnl_Drinks.Hide();
pnl_EditDrink.Hide();
pnl_Students.Hide();
btn_Filter.Hide();
btn_RemoveFilter.Hide();
//show report
pnl_Students.Show();
lbl_Students.Text = "Weekly Timetable";
//clearing listView
listViewStudents.Clear();
//calling the timetable list
SomerenLogic.Timetable_Service timetable_Service = new SomerenLogic.Timetable_Service();
List <Timetable> timetables = timetable_Service.GetTimetables();
//displaying timetable
listViewStudents.Columns.Add("Date");
listViewStudents.Columns[0].Width = 100;
listViewStudents.Columns.Add("Day of Week");
listViewStudents.Columns[1].Width = 100;
listViewStudents.Columns.Add("Activities");
listViewStudents.Columns[2].Width = 100;
listViewStudents.Columns.Add("Supervisors");
listViewStudents.Columns[3].Width = 100;
int counter = 0;
foreach (SomerenModel.Timetable s in timetables)
{
ListViewItem li = new ListViewItem(s.Date.ToShortDateString().ToString());
li.SubItems.Add(s.Date.DayOfWeek.ToString());
li.SubItems.Add(s.Activity);
li.SubItems.Add(s.Supervisor);
listViewStudents.Items.Add(li);
counter++;
if (counter == 7)
{
return;
}
}
}
}
private void showPanel(string panelName)
{
if (panelName == "Dashboard")
{
// 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();
}
}