private void button_Update_Click(object sender, EventArgs e) { if ((textBox_Name.Text != "") && (textBox_Price.Text != "") && (textBox_Stock.Text != "")) { Decimal VAT = 0; if (radioButton_No.Checked) { SomerenLogic.Drinks_Service drink_Db = new SomerenLogic.Drinks_Service(); drink_Db.UpdateDrinks(ID, textBox_Name.Text, Convert.ToInt32(textBox_Price.Text), Convert.ToInt32(textBox_Stock.Text), radioButton_No.Text, VAT); ShowData(); ClearData(); } else { SomerenLogic.Drinks_Service drink_Db = new SomerenLogic.Drinks_Service(); drink_Db.UpdateDrinks(ID, textBox_Name.Text, Convert.ToInt32(textBox_Price.Text), Convert.ToInt32(textBox_Stock.Text), radioButton_Yes.Text, VAT); ShowData(); ClearData(); } } else { MessageBox.Show("Select Field to Update"); } }
private void ShowData() { //used a datagridview since it was an easier way to display the data, also watched a few youtube videos where they showed it in a datagrid view. SomerenLogic.Drinks_Service drinks_db = new SomerenLogic.Drinks_Service(); List <Drinks> drinkList = drinks_db.GetDrinks(); dataGridViewDrinks.AutoGenerateColumns = true; dataGridViewDrinks.DataSource = drinkList; }
void DisplayDrinks() { SomerenLogic.Drinks_Service drinkService = new SomerenLogic.Drinks_Service(); List <Drinks> drinksList = drinkService.GetDrinks(); foreach (SomerenModel.Drinks item in drinksList) { if (item != null) { comboBoxDrinks.Items.Add(item.DrinkName); } } }
private void button_Delete_Click(object sender, EventArgs e) { if (textBox_Name.Text != "" && textBox_Price.Text != "" && textBox_Stock.Text != "") { SomerenLogic.Drinks_Service studService = new SomerenLogic.Drinks_Service(); studService.DeleteDrinks(ID); ShowData(); ClearData(); } else { MessageBox.Show("Please Select Record to Update"); } }
public double BerekenBTWHoog(DateTime beginDatum, DateTime eindDatum) { List <DrinkOrders> alleOrders = GetDrinkOrders(); Drinks_Service d = new Drinks_Service(); List <Drinks> alleDranken = d.GetDrinks(); //Drinks dranken = new Drinks(); double totaalprijs = 0; double totaalBtwHoog = 0; foreach (DrinkOrders order in alleOrders) { if (order.dateTime >= beginDatum && order.dateTime < eindDatum) { string drankNaam = order.DrinkName; double hoeveel = order.Amount; int btw = 21; double prijs = 0; double orderprijs; foreach (Drinks drink in alleDranken) { if (drink.Naam == drankNaam && drink.BTW == 21) { prijs += drink.Prijs; orderprijs = hoeveel * prijs; totaalprijs += orderprijs; totaalBtwHoog = totaalBtwHoog + (btw * 0.01 * orderprijs); } } } } return(totaalBtwHoog); }
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; } } } }