private void OrderForm_Load(object sender, EventArgs e)
{
//fill the combo boxes
List <Student> students = studentService.GetStudents();
foreach (Student S in students)
{
cmbOrdStudents.Items.Add(S.Name);
}
List <Drink> drinks = drinkService.GetDrinks();
foreach (Drink D in drinks)
{
cmbOrdDrinks.Items.Add(D.Name);
}
}
private void ReloadForm()
{
List <Student> students = studentService.GetStudents();
cmbDrinks.Items.Clear();
cmbStudents.Items.Clear();
cmbDrinks.SelectedIndex = -1;
cmbStudents.SelectedIndex = -1;
foreach (Student student in students)
{
cmbStudents.Items.Add(student.FullName);
}
List <Drink> drinks = drinkService.GetDrinks();
foreach (Drink drink in drinks)
{
cmbDrinks.Items.Add(drink.DrinkName);
}
}
private void RefreshDrinkPanel()
{
Drink_Service drinkService = new Drink_Service();
List <Drink> drinks = drinkService.GetDrinks();
//clear listview before filling it
listViewDrinks.Items.Clear();
//fill up list view
foreach (Drink d in drinks)
{
ListViewItem li = new ListViewItem(d.DrinkID.ToString(), 0);
li.SubItems.Add(d.DrinkName);
li.SubItems.Add(d.VATID.ToString());
li.SubItems.Add(d.DrinkPrice.ToString());
li.SubItems.Add(d.StockAmount.ToString());
//if(d.StockAmount< 10)
//{
// li.SubItems.Add(d.StockAmount.ToString());
// li.SubItems.Add("Nearly depleted");
//}else if (d.StockAmount == 0)
//{
// li.SubItems.Add(d.StockAmount.ToString());
// li.SubItems.Add("is empty");
//}
//else
//{
// li.SubItems.Add("stock sufficient");
//}
li.SubItems.Add(d.SalesCount.ToString());
li.Tag = d;
listViewDrinks.Items.Add(li);
}
}
//private to internal because we will reference it from the other form
internal void showPanel(string panelName)
{
//hide all panels
pnl_Dashboard.Hide();
img_Dashboard.Hide();
pnl_Students.Hide();
pnl_Teachers.Hide();
pnl_Drinks.Hide();
pnl_CashRegister.Hide();
pnl_Supervisors.Hide();
if (panelName == "Dashboard")
{
// show dashboard
pnl_Dashboard.Show();
img_Dashboard.Show();
}
else if (panelName == "Students")
{
//Check if the listview already exist, if not create one.
if (viewStudentList == null)
{
viewStudentList = CreateStudentListView();
pnl_Students.Controls.Add(viewStudentList);
}
// show students
pnl_Students.Show();
// fill the students listview within the students panel with a list of students
Student_Service studService = new Student_Service();
List <Student> studentList = studService.GetStudents();
// clear the listview before filling it again
viewStudentList.Items.Clear();
foreach (Student s in studentList)
{
ListViewItem student = new ListViewItem(new string[] { s.Number.ToString(), s.FirstName, s.LastName });
viewStudentList.Items.Add(student);
}
}
else if (panelName == "Lecturers")
{
// show teachers panel
pnl_Teachers.Show();
// fill the teachers listview within the teacher panel with a list of teachers
Teacher_Service teacherService = new Teacher_Service();
List <Teacher> teacherList = teacherService.GetTeachers();
// clear the items in listview
listViewTeachers.Items.Clear();
// fill list
foreach (Teacher s in teacherList)
{
ListViewItem teacher = new ListViewItem(s.Number.ToString());
teacher.SubItems.Add(s.FirstName);
teacher.SubItems.Add(s.LastName);
listViewTeachers.Items.Add(teacher);
}
}
//this is part of variant A from assignment 3
//this is part of variant A from assignment 3
else if (panelName == "Drinks Supplies")
{
//show drinks panel
pnl_Drinks.Show();
//fill the drinks listview wihin the drink panel with a list of drinks
Drink_Service drinkService = new Drink_Service();
List <Drink> drinkList = drinkService.GetDrinks();
//clear the items in listview
listViewDrinks.Items.Clear();
//fill list
foreach (Drink d in drinkList)
{
ListViewItem drink = new ListViewItem(new string[] { d.DrinkName, String.Format("{0:0.00}", d.Price), d.StockAmount.ToString() });
drink.Tag = d;
if (d.StockAmount < 10)
{
//show half bottle icon
drink.ImageIndex = 1;
}
else
{
//show full bottle icon
drink.ImageIndex = 0;
}
listViewDrinks.Items.Add(drink);
}
this.Refresh();
}
//this is a part of variant B from assignment 3
//this is a part of variant B from assignment 3
else if (panelName == "CashRegister")
{
//show panel
pnl_CashRegister.Show();
//get list of drinks and students
Student_Service studService = new Student_Service();
List <Student> studentList = studService.GetStudents();
Drink_Service drinkService = new Drink_Service();
List <Drink> drinkList = drinkService.GetDrinks();
//clear the listview before filling it again
lv_Cash_Student.Items.Clear();
lv_Cash_Drinks.Items.Clear();
//get students
foreach (Student s in studentList)
{
ListViewItem student = new ListViewItem(s.Number.ToString());
student.SubItems.Add(s.FullName);
lv_Cash_Student.Items.Add(student);
}
//get drinks
foreach (Drink d in drinkList)
{
ListViewItem drink = new ListViewItem(d.DrinkNumber.ToString());
drink.SubItems.Add(d.DrinkName);
drink.SubItems.Add(d.Price.ToString("0.00"));
drink.SubItems.Add(d.StockAmount.ToString());
lv_Cash_Drinks.Items.Add(drink);
}
}
//this is a part of variant B from assignment 4
//this is a part of variant B from assignment 4
else if (panelName == "Supervisors")
{
//show supervisor panek
pnl_Supervisors.Show();
//fill the supervisors listview within the supervisor panel with list of supervisors
Supervisor_Service supervisorService = new Supervisor_Service();
List <Supervisor> supervisorList = supervisorService.GetSupervisors();
//clear items in listview
listViewSupervisors.Items.Clear();
//fill list
foreach (Supervisor s in supervisorList)
{
ListViewItem supervisor = new ListViewItem(new string[] { s.LecturerID.ToString(), s.FirstName, s.LastName });
supervisor.Tag = s;
listViewSupervisors.Items.Add(supervisor);
}
}
}
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)
{
switch (panelName)
{
case "Students":
Student_Service studService = new Student_Service();
List <Student> studentList = studService.GetStudents();
ListViewStuPrint(listViewStudents, studentList);
break;
case "Lecturers":
Lecturer_Service lecService = new Lecturer_Service();
List <Teacher> lecList = lecService.GetTeachers();
ListViewLecPrint(listView_Lec, lecList);
break;
case "Supervisors":
Supervisor_Service supService = new Supervisor_Service();
List <Supervisor> supList = supService.GetSupervisors();
PrintSup(listView_Sup, supList);
Activity_Service actService = new Activity_Service();
List <Activity> actList = actService.GetActivities();
cmb_ActivityID.DataSource = actList;
cmb_ActivityID.DisplayMember = "Name";
cmb_ActivityID.ValueMember = "ID";
break;
case "Rooms":
Room_Service roomService = new Room_Service();
List <Room> roomList = roomService.GetRooms();
ListViewRoomPrint(listViewRooms, roomList);
break;
case "DrinkSup":
Btn_Supplies_Save.Enabled = false;
Txt_Supplies_Id.Text = string.Empty;
Txt_Supplies_NewName.Text = string.Empty;
Txt_Supplies_NewStock.Text = string.Empty;
Txt_Supplies_Price.Text = string.Empty;
Txt_Supplies_Sold.Text = string.Empty;
// fill the students listview within the students panel with a list of students
Drink_Service drinkService = new Drink_Service();
List <Drink> DrinkList = drinkService.GetDrinks();
ListViewStockPrint(Lst_Supplies, DrinkList);
break;
case "Activities":
Dtp_Activities_TimePart.Format = DateTimePickerFormat.Custom;
Dtp_Activities_TimePart.CustomFormat = "hh:mm tt";
Dtp_Activities_TimePart.ShowUpDown = true;
Txt_Activities_Id.Text = "";
Txt_Activities_Description.Text = "";
Txt_Activities_Location.Text = "";
Txt_Activities_Name.Text = "";
Dtp_Activities_DatePart.Value = DateTime.Today;
Dtp_Activities_TimePart.Value = DateTime.UtcNow;
Activity_Service actServe = new Activity_Service();
List <Activity> ActivityList = actServe.GetActivities();
ListViewActivitiesPrint(Lst_Activities, ActivityList);
break;
case "CashRegister":
FillRegistryStudents();
FillRegistryDrinks();
Btn_Register_Checkout.Enabled = false;
break;
case "RevRep":
mcRev.MaxDate = DateTime.Today;
PrintReport();
break;
case "Timetable":
Timetable_Service timeServ = new Timetable_Service();
List <Timetable> TimetableList = timeServ.GetTimetable();
ListViewTimetablePrint(listViewTimetable, TimetableList);
break;
default:
break;
}
}
