// Made By: Davut Demir // voert het proces van een nieuwe begeleider toevoegen uit // ververst ook het scherm public void BegeleiderInsertEvent(object sender, EventArgs e) { SomerenDB db = new SomerenDB(); db.BegeleiderInsert(txt_id.Text); begeleidersToolStripMenuItem.PerformClick(); }
public static Control showStudents() { // make a list for retrieving data from it List <SomerenModel.Student> students = new List <SomerenModel.Student>(); // linking the list to the DB connection in order to get data from it students = SomerenDB.DB_getStudents(); // Making a list and editing its format ListView studentsListView = new ListView(); studentsListView.Height = 370; studentsListView.Width = 370; studentsListView.View = View.Details; studentsListView.FullRowSelect = true; // adding colums to the list studentsListView.Columns.Add("ID", -2, HorizontalAlignment.Left); studentsListView.Columns.Add("First Name", -2, HorizontalAlignment.Left); studentsListView.Columns.Add("Last Name", -2, HorizontalAlignment.Left); studentsListView.Columns.Add("Room Number", -2, HorizontalAlignment.Left); // storing data into the list foreach (SomerenModel.Student student in students) { ListViewItem entryListItem = studentsListView.Items.Add(student.getId().ToString()); entryListItem.SubItems.Add(student.getFirstName().ToString()); entryListItem.SubItems.Add(student.getLastName().ToString()); entryListItem.SubItems.Add(student.getRoomNumber().ToString()); } // return a list view return(studentsListView); }
public static Control showStudents() { List <SomerenModel.Student> sl = SomerenDB.DB_gettudents(); ListViewItem li = new ListViewItem(); ListView c = new ListView(); foreach (var item in sl) { SomerenModel.Student Student = new SomerenModel.Student(); Student.setNaam(item.getNaam()); li.SubItems.Add(Student.getNaam()); li.SubItems.Add(Student.getId().ToString()); c.Items.Add(Student.getNaam()); c.Items.Add(li); } int aantal = sl.Count(); c.Height = 1000; return(c); }
public static void AddSuper(string add_supervisor) { List <SomerenModel.Supervisor> supervisors = new List <SomerenModel.Supervisor>(); // to get data from DataBase supervisors = SomerenDB.DB_getSupervisors(); List <string> supervisorsStrings = new List <string>(); foreach (SomerenModel.Supervisor supervisor in supervisors) { supervisorsStrings.Add(supervisor.getLastName().ToLower()); } // validation if the teacher is a supervisor if (supervisorsStrings.Contains(add_supervisor.ToLower())) { // show a message MessageBox.Show("This teacher is already a supervisor! Choose another one!", "Warning", MessageBoxButtons.OK, MessageBoxIcon.Error); } else { SomerenDB.DB_AddSupervisor(add_supervisor); } }
private static void Click_TimetableSaveButton(object sender, EventArgs e) { // find the controls again based on the tag Button button = (Button)sender; Control[] allControls = (Control[])button.Tag; ListView activitiesListView = (ListView)allControls[0]; DateTimePicker datePicker = (DateTimePicker)allControls[1]; ComboBox timePicker = (ComboBox)allControls[2]; // make sure we have a selected activity if (activitiesListView.SelectedItems.Count != 1) { MessageBox.Show("Please select exactly one activity.", "Error!", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } // find the new values from the controls int activityId = int.Parse(activitiesListView.SelectedItems[0].Text); DateTime date = datePicker.Value.Date; int startTime = 9 + (timePicker.SelectedIndex * 2); int endTime = startTime + 2; // store in database SomerenDB.DB_setTimeslotForActivity(activityId, date, startTime, endTime); }
public static Control showTeachers() { List <SomerenModel.Docent> dl = new List <SomerenModel.Docent>(); //SomerenDB. SomerenDB db = new SomerenDB(); dl = db.DB_getteachers(); SomerenModel.Docent[] docenten = dl.ToArray(); ListView c = new ListView(); c.View = View.Details; c.BackColor = System.Drawing.SystemColors.ControlLight; c.Columns.Add("ID", -2, HorizontalAlignment.Left); c.Columns.Add("Naam", -2, HorizontalAlignment.Left); c.Columns.Add("Achternaam", -2, HorizontalAlignment.Left); c.Height = 500; c.Width = 500; for (int i = 0; i < docenten.Length; i++) { ListViewItem lv = new ListViewItem(docenten[i].getId().ToString()); lv.SubItems.Add(docenten[i].getNaam()); lv.SubItems.Add(docenten[i].getAchternaam()); c.Items.Add(lv); } return(c); }
public static Control showKamers() { List <SomerenModel.Kamers> sl = new List <SomerenModel.Kamers>(); //SomerenDB. SomerenDB db = new SomerenDB(); sl = db.DB_getKamers(); SomerenModel.Kamers[] kamers = sl.ToArray(); ListView c = new ListView(); c.View = View.Details; c.BackColor = System.Drawing.SystemColors.ControlLight; c.Columns.Add("Kamer nummer", -2, HorizontalAlignment.Left); c.Columns.Add("Aantal bedden", -2, HorizontalAlignment.Left); c.Columns.Add("Docenten kamer", -2, HorizontalAlignment.Left); c.Height = 500; c.Width = 500; for (int i = 0; i < kamers.Length; i++) { ListViewItem lv = new ListViewItem(kamers[i].getKamerNr().ToString()); lv.SubItems.Add(kamers[i].getAantalBedden().ToString()); lv.SubItems.Add(kamers[i].getKamerDocent()); c.Items.Add(lv); } return(c); }
public static Control showActivity() { // make a list for retrieving data from it List <SomerenModel.Activities> activities = new List <SomerenModel.Activities>(); // linking the list to the DB connection in order to get data from it activities = SomerenDB.DB_getActivities(); // Making a list and editing its format ListView activityListView = new ListView(); activityListView.Height = 370; activityListView.Width = 370; activityListView.View = View.Details; activityListView.FullRowSelect = true; // add columns to the list view activityListView.Columns.Add("ID", -2, HorizontalAlignment.Left); activityListView.Columns.Add("Activity Description", -2, HorizontalAlignment.Left); activityListView.Columns.Add("Number of Students", -2, HorizontalAlignment.Left); activityListView.Columns.Add("Number of Supervisors", -2, HorizontalAlignment.Left); // store data to the list view foreach (SomerenModel.Activities activity in activities) { ListViewItem entryListItem = activityListView.Items.Add(activity.getId().ToString()); entryListItem.SubItems.Add(activity.getActivity_desc().ToString()); entryListItem.SubItems.Add(activity.getNumOfStudents().ToString()); entryListItem.SubItems.Add(activity.getNumOfSupervisors().ToString()); } // return a list view return(activityListView); }
public static Control showStudents() { List <SomerenModel.Student> sl = new List <SomerenModel.Student>(); //SomerenDB. SomerenDB db = new SomerenDB(); sl = db.DB_getstudents(); SomerenModel.Student[] studenten = sl.ToArray(); ListView c = new ListView(); c.View = View.Details; c.BackColor = System.Drawing.SystemColors.ControlLight; c.Columns.Add("Student ID ", -2, HorizontalAlignment.Left); c.Columns.Add("Voornaam ", -2, HorizontalAlignment.Left); c.Columns.Add("Achternaam ", -2, HorizontalAlignment.Left); c.Height = 1000; c.Width = 1000; for (int i = 0; i < studenten.Length; i++) { ListViewItem lv = new ListViewItem(studenten[i].getId().ToString()); lv.SubItems.Add(studenten[i].getNaam()); lv.SubItems.Add(studenten[i].getAchternaam()); c.Items.Add(lv); } return(c); }
public static ListView ShowBegeleiders() { List <SomerenModel.Begeleider> bl = new List <SomerenModel.Begeleider>(); SomerenDB somerendb = new SomerenDB(); // hier halen we de drankjes op van de database bl = somerendb.BegeleiderSelect(); ListView c = new ListView(); c.Height = 1000; c.Width = 200; c.View = View.Details; c.Columns.Add("Begeleider Naam", 100, HorizontalAlignment.Left); c.Columns.Add("Begeleider Id", 100, HorizontalAlignment.Left); foreach (SomerenModel.Begeleider begeleider in bl) { string naam = begeleider.getNaam(); string id = begeleider.getId().ToString(); ListViewItem li = new ListViewItem(naam); li.SubItems.Add(id, System.Drawing.Color.Black, System.Drawing.Color.Black, null); c.Items.Add(li); } return(c); }
//Door Juan //06-04-17, opdracht 6, variant A public static ListView showActiviteiten() { List <SomerenModel.Activiteit> a1 = new List <SomerenModel.Activiteit>(); SomerenDB somerendb = new SomerenDB(); a1 = somerendb.DB_getActiviteit(); ListView c = new ListView(); c.Height = 900; c.Width = 400; c.View = View.Details; c.Columns.Add("Activiteiten", 100, HorizontalAlignment.Left); c.Columns.Add("Aantal studenten", 200, HorizontalAlignment.Left); c.Columns.Add("Aantal begeleiders", 300, HorizontalAlignment.Left); foreach (SomerenModel.Activiteit activiteit in a1) { ListViewItem li = new ListViewItem(activiteit.getOmschrijving()); li.Tag = activiteit; li.SubItems.Add(activiteit.getAStudenten().ToString()); li.SubItems.Add(activiteit.getABegeleiders().ToString()); c.Items.Add(li); } return(c); }
public static Control showListSupervisors() { List <SomerenModel.Supervisor> supervisors = new List <SomerenModel.Supervisor>(); // to get data from DataBase supervisors = SomerenDB.DB_getSupervisors(); // Making a list and editing its format ListView supervisorListView = new ListView(); supervisorListView.Height = 370; supervisorListView.Width = 370; supervisorListView.View = View.Details; supervisorListView.FullRowSelect = true; // adding colums to the list supervisorListView.Columns.Add("First Name", -2, HorizontalAlignment.Left); supervisorListView.Columns.Add("Last Name", -2, HorizontalAlignment.Left); // storing data into the list foreach (SomerenModel.Supervisor record in supervisors) { ListViewItem entryListItem = supervisorListView.Items.Add(record.getFirstName().ToString()); entryListItem.SubItems.Add(record.getLastName().ToString()); } return(supervisorListView); }
public static Control showLimitedRevenueReport(DateTime start, DateTime end) { List <SomerenModel.Report> report = new List <SomerenModel.Report>(); // to get data from DataBase report = SomerenDB.DB_getLimitedRevenueReport(start, end); // Making a list and editing its format ListView reportListView = new ListView(); reportListView.Height = 370; reportListView.Width = 370; reportListView.View = View.Details; reportListView.FullRowSelect = true; // adding colums to the list reportListView.Columns.Add("Sales", -2, HorizontalAlignment.Left); reportListView.Columns.Add("Turnover", -2, HorizontalAlignment.Left); reportListView.Columns.Add("Number of customers", -2, HorizontalAlignment.Left); // storing data into the list foreach (SomerenModel.Report record in report) { ListViewItem entryListItem = reportListView.Items.Add(record.getNumberOfDrinks().ToString()); entryListItem.SubItems.Add(record.getTurnover().ToString()); entryListItem.SubItems.Add(record.getNumberOfCustomers().ToString()); } return(reportListView); }
private static void Handle_CheckoutButtonClicked(object sender, EventArgs eventArgs) { // find the button Button checkoutButton = (Button)sender; // find the other controls Control[] otherControls = (Control[])checkoutButton.Tag; // find the two lists ListView studentsListView = (ListView)otherControls[0]; ListView barServiceListView = (ListView)otherControls[1]; // we only support one student per order if (studentsListView.CheckedItems.Count != 1) { MessageBox.Show("Please select exactly one student.", "Error!", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } // get the selected student int studentId = int.Parse(studentsListView.CheckedItems[0].Text); // get the selected drinks List <int> drinkIds = new List <int>(); foreach (ListViewItem checkedDrink in barServiceListView.CheckedItems) { int drinkId = int.Parse(checkedDrink.Text); drinkIds.Add(drinkId); } SomerenModel.CashRegisterList cashLines = new SomerenModel.CashRegisterList(); // add each of the drinks to the list foreach (int drinkId in drinkIds) { SomerenModel.CashRegister cashLine = new SomerenModel.CashRegister(); cashLine.setDrinkId(drinkId); cashLine.setStudentId(studentId); cashLines.addList(cashLine); } // invoke database query to store the stuff SomerenDB.DB_updateCashRegister(cashLines); // reset the view foreach (ListViewItem student in studentsListView.Items) { student.Checked = false; } foreach (ListViewItem drink in barServiceListView.Items) { drink.Checked = false; } }
public static void deleteBarServiceUI(int id) { // make a new variable of type SomerenModel.BarService in order to store data to it SomerenModel.BarService newBarService = new SomerenModel.BarService(); // store data to the newBarSrvice variable newBarService.setDrinkId(id); // passing data to the DB layer SomerenDB.DB_deleteBarService(newBarService); }
public static void deleteActivity(int id) { // make a new variable of type SomerenModel.Activities in order to store data to it SomerenModel.Activities newActivity = new SomerenModel.Activities(); // store data to the newActivity variable newActivity.setId(id); // passing data to the DB layer SomerenDB.DB_deleteActivity(newActivity); }
//Door Joost public static void getOmzetrapportage(ref Label label, DateTime from, DateTime to) { SomerenDB somerendb = new SomerenDB(); int aantalKlanten = somerendb.aantalKlanten(from, to); int afzet = somerendb.afzet(from, to); double omzet = somerendb.omzet(from, to); label.Text = String.Format( "aantal klanten : {0}\n" + "afzet : {1}\n" + "omzet: {2:C2}", aantalKlanten, afzet, omzet); }
public static void addBarServiceUI(string name, decimal price, int amount) { // make a new variable of type SomerenModel.BarService in order to store data to it SomerenModel.BarService newBarService = new SomerenModel.BarService(); // store data to the newBarSrvice variable newBarService.setDrinkName(name); newBarService.setDrinkPrice(price); newBarService.setStockAmount(amount); // passing data to the DB layer SomerenDB.DB_addBarService(newBarService); }
// Made By: Davut Demir // voert het proces van een begeleider verwijderen uit // ververst ook het scherm public void BegeleiderDeleteEvent(object sender, EventArgs e) { SomerenDB db = new SomerenDB(); // een waarschuwings popup toegevoegd DialogResult dialogResult = MessageBox.Show("Weet u zeker dat u deze begeleider wilt verwijderen??", "Verwijderen", MessageBoxButtons.YesNo); if (dialogResult == DialogResult.No) { return; } db.BegeleiderDelete(txt_id.Text); begeleidersToolStripMenuItem.PerformClick(); }
public static void uppdateActivity(int id, string desc, int numOfStudents, int numberOfSupervisor) { // make a new variable of type SomerenModel.Activities in order to store data to it SomerenModel.Activities newActivity = new SomerenModel.Activities(); // store data to the newActivity variable newActivity.setId(id); newActivity.setActivity_desc(desc); newActivity.setNumOfStudents(numOfStudents); newActivity.setNumOfSupervisors(numberOfSupervisor); // passing data to the DB layer SomerenDB.DB_uppdateActivity(newActivity); }
private void afrekenenEvent(object sender, EventArgs e) { foreach (ListViewItem sitem in studentenList.SelectedItems) { SomerenModel.Student student = (SomerenModel.Student)sitem.Tag; foreach (ListViewItem vitem in drankenList.SelectedItems) { SomerenModel.DrankVoorraad voorraad = (SomerenModel.DrankVoorraad)vitem.Tag; SomerenDB somerenDB = new SomerenDB(); somerenDB.bestel(student, voorraad); } } }
public static Control showBarService() { // make a list for retrieving data from it List <SomerenModel.BarService> barServices = new List <SomerenModel.BarService>(); // linking the list to the DB connection in order to get data from it barServices = SomerenDB.DB_getBarServices(); // Making a list and editing its format ListView barServiceListView = new ListView(); barServiceListView.Height = 370; barServiceListView.Width = 370; barServiceListView.View = View.Details; barServiceListView.FullRowSelect = true; // add columns to the list view barServiceListView.Columns.Add("ID", -2, HorizontalAlignment.Left); barServiceListView.Columns.Add("Drink Name", -2, HorizontalAlignment.Left); barServiceListView.Columns.Add("Drink Price", -2, HorizontalAlignment.Left); barServiceListView.Columns.Add("Amount (In Stock)", -2, HorizontalAlignment.Left); // declare a string variable for adding new text to stock amount data string StockState; // store data to the list view foreach (SomerenModel.BarService barService in barServices) { ListViewItem entryListItem = barServiceListView.Items.Add(barService.getDrinkId().ToString()); entryListItem.SubItems.Add(barService.getDrinkName().ToString()); entryListItem.SubItems.Add(barService.getDrinkPrice().ToString()); // adding new text to stock amount data depending on its value if (barService.getStockAmount() < 10) { StockState = barService.getStockAmount() + " (Stock nearly depleted)"; } else { StockState = barService.getStockAmount() + " (Stock sufficient)"; } entryListItem.SubItems.Add(StockState.ToString()); } // return a list view return(barServiceListView); }
public static Control showDocenten() { List <SomerenModel.Docent> dl = new List <SomerenModel.Docent>(); SomerenDB somerendb = new SomerenDB(); dl = somerendb.DB_getdocenten(); ListView c = new ListView(); c.Height = 1000; foreach (SomerenModel.Docent docent in dl) { ListViewItem li = new ListViewItem(docent.getNaam()); li.SubItems.Add(docent.getId().ToString()); c.Items.Add(li); } return(c); }
private void addEvent(object sender, EventArgs e) { string omschrijving = tb_naamActiviteit.Text; int aStudenten; Int32.TryParse(tb_aantalStudenten.Text, out aStudenten); int aBegeleiders; Int32.TryParse(tb_aantalBegeleiders.Text, out aBegeleiders); SomerenDB somerenb = new SomerenDB(); somerenb.DB_toevoegenActiviteit(omschrijving, aStudenten, aBegeleiders); activiteitenlijstToolStripMenuItem.PerformClick(); }
private void wijzig(object sender, EventArgs e) { string omschrijving = tbw_naamActiviteit.Text; int aStudenten; Int32.TryParse(tbw_aantalStudenten.Text, out aStudenten); int aBegeleiders; Int32.TryParse(tbw_aantalBegeleiders.Text, out aBegeleiders); SomerenDB somerenb = new SomerenDB(); somerenb.DB_wijzigActiviteit(huidigeBewerking.getActiviteitId(), omschrijving, aStudenten, aBegeleiders); activiteitenlijstToolStripMenuItem.PerformClick(); }
internal static Control showTeachers() { List <SomerenModel.Teacher> teachers = new List <SomerenModel.Teacher>(); teachers = SomerenDB.DB_getTeachers(); // we will add this list view to the panel later so the UI updates ListView teacherListView = new ListView(); teacherListView.Height = 370; teacherListView.Width = 370; teacherListView.View = View.Details; teacherListView.FullRowSelect = true; // add columns to the list view teacherListView.Columns.Add("ID", -2, HorizontalAlignment.Left); teacherListView.Columns.Add("First Name", -2, HorizontalAlignment.Left); teacherListView.Columns.Add("Last Name", -2, HorizontalAlignment.Left); teacherListView.Columns.Add("Supervisor", -2, HorizontalAlignment.Left); teacherListView.Columns.Add("Room Number", -2, HorizontalAlignment.Left); // store data to the list view foreach (SomerenModel.Teacher teacher in teachers) { ListViewItem entryListItem = teacherListView.Items.Add(teacher.getId().ToString()); entryListItem.SubItems.Add(teacher.getFirstName()); entryListItem.SubItems.Add(teacher.getLastName()); if (teacher.getIsSupervisor() == true) { entryListItem.SubItems.Add("yes"); } else { entryListItem.SubItems.Add("no"); } entryListItem.SubItems.Add(teacher.getRoomNumber().ToString()); } // return a list view return(teacherListView); }
private void deleteEvent(object sender, EventArgs e) { DialogResult dialogResult = MessageBox.Show("Weet u zeker dat u de geselecteerde activiteit wilt verwijderen??", "Verwijderen", MessageBoxButtons.YesNo); if (dialogResult == DialogResult.No) { return; } foreach (ListViewItem sitem in activiteit.SelectedItems) { SomerenModel.Activiteit activiteit = (SomerenModel.Activiteit)sitem.Tag; SomerenDB somerenDB = new SomerenDB(); somerenDB.DB_deleteActiviteit(activiteit.getActiviteitId()); } activiteitenlijstToolStripMenuItem.PerformClick(); }
public static void addActivity(string desc, int numOfStudents, int numberOfSupervisor) { // make a list for retrieving data from it List <SomerenModel.Activities> activities = new List <SomerenModel.Activities>(); // linking the list to the DB connection in order to get data from it activities = SomerenDB.DB_getActivities(); // make a new variable of type SomerenModel.Activities in order to store data to it SomerenModel.Activities newActivity = new SomerenModel.Activities(); // make a list to store avtivity description in it List <string> activityDesc = new List <string>(); // add avtivity description to the activityDesc list foreach (SomerenModel.Activities activity in activities) { activityDesc.Add(activity.getActivity_desc().ToLower()); } // make a validation to know if the data entered is diffrenet from DB data if (activityDesc.Contains(desc.ToLower())) { // show a message if the entered data exists in the DB MessageBox.Show("You can not add the same activity twice, please enter another activity name!", "Warning", MessageBoxButtons.OK, MessageBoxIcon.Error); } else { //store data to the newActivity variable newActivity.setActivity_desc(desc); newActivity.setNumOfStudents(numOfStudents); newActivity.setNumOfSupervisors(numberOfSupervisor); // passing data to the DB layer SomerenDB.DB_addActivity(newActivity); // show a messagebox after a successfull addition MessageBox.Show("You have successfully added a new activity!!\n" + "Enter Refresh the list to see the changes", "", MessageBoxButtons.OK, MessageBoxIcon.Information); } }
// that's output stuff public static Control showRooms() { List <SomerenModel.Rooms> rl = new List <SomerenModel.Rooms>(); //SomerenDB. rl = SomerenDB.DB_getRooms(); int aantal = rl.Count(); ListView c = new ListView(); c.Height = 1000; // ListViewItem li = new ListViewItem(); foreach (SomerenModel.Rooms room in rl) { c.Items.Add("RoomNumber: " + room.getRoomNumber().ToString()); c.Items.Add("RoomCapacity: " + room.getRoomCapacity().ToString()); c.Items.Add(room.getRoomType().ToString()); } return(c); }
public static Control showRooms() { List <SomerenModel.Rooms> rooms = new List <SomerenModel.Rooms>(); // linking the list to the DB connection in order to get data from it rooms = SomerenDB.DB_getRooms(); // Making a list and editing its format //int aantal = rooms.Count(); ListView roomsListView = new ListView(); roomsListView.Height = 370; roomsListView.Width = 370; roomsListView.View = View.Details; roomsListView.FullRowSelect = true; // adding colums to the list roomsListView.Columns.Add("Room Number", -2, HorizontalAlignment.Left); roomsListView.Columns.Add("Room Capacity", -2, HorizontalAlignment.Left); roomsListView.Columns.Add("Room Type", -2, HorizontalAlignment.Left); // storing data into the list foreach (SomerenModel.Rooms room in rooms) { ListViewItem entryListItem = roomsListView.Items.Add(room.getRoomNumber().ToString()); entryListItem.SubItems.Add(room.getRoomCapacity().ToString()); if (room.getRoomType() == true) { entryListItem.SubItems.Add("Teachers Room"); } else { entryListItem.SubItems.Add("Students Room"); } } return(roomsListView); }