// 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);
}
