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 button1_Click(object sender, EventArgs e)
{
try
{
//the message above the listview
lblmsg.Text = "Transaction of the date selected..";
//this is for the buttons
SomerenLogic.Revenue_Service revenueService = new SomerenLogic.Revenue_Service();
//List<Revenue> rList = revenueService.GetRevenue();
//this is when the list is clicked.
List <Revenue> rDate = revenueService.GetDate(StartCalendar.SelectionStart, StartCalendar.SelectionEnd);
//to clear the list.
listViewRevenue.Clear();
//the display when a date is selected.
foreach (SomerenModel.Revenue r in rDate)
{
ListViewItem ListofRev = new ListViewItem((r.Students).ToString());
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);
//this part for the calculations of sales, turnover and number of customer.
int sales = 0;
int turnover = 0;
foreach (Revenue r in rDate)
{
//if (r.Date >= StartCalendar.SelectionStart && r.Date <= StartCalendar.SelectionEnd)
//{
turnover += r.Turnover;
sales = r.Prod_Sold + sales;
//}
}
txt_Sales.Text = sales.ToString();
txt_Turnover.Text = turnover.ToString();
//amount of student counter.
txt_TotalCust.Text = Revenue.NumbOfStudent.ToString();
Revenue.NumbOfStudent = 0;
}
catch (Exception d)
{
MessageBox.Show(d.Message);
StreamWriter writer = new StreamWriter($"errorLog.txt", true);
writer.WriteLine($"{ DateTime.Now}, error message: {d.Message}");
writer.Close();
}
}
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)
{
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();
}
}
