/// <summary>
/// Laat je allemaal verschillende lijsten zien met gegevens uit de database over het crm systeem
/// </summary>
/// <param name="UserList"></param>
private void PopulateList(tableToDisplay choice)
{
ListViewActors.Clear();
CurrentChoice = choice;
comboBoxSearch.Items.Clear();
isManaging();
// Laat de user tab zien
if (choice == tableToDisplay.user)
{
comboBoxSearch.Items.Add("Weergeef Alles");
comboBoxSearch.Items.Add("Gebruikersnaam");
comboBoxSearch.Items.Add("Voornaam");
comboBoxSearch.Items.Add("Volledige Achternaam");
comboBoxSearch.Items.Add("Type");
comboBoxSearch.SelectedItem = "Weergeef Alles";
textBoxSearch.Enabled = false;
// Voeg de columns toe
ListViewActors.Columns.Add("ID");
ListViewActors.Columns.Add("Gebruikersnaam");
ListViewActors.Columns.Add("Voornaam");
ListViewActors.Columns.Add("Tussenvoegsel");
ListViewActors.Columns.Add("Achternaam");
ListViewActors.Columns.Add("Type");
ListViewActors.Columns.Add("Emailadres");
foreach (var item in UserList)
{
ListViewItem ListViewItem = new ListViewItem(item.id.ToString());
ListViewItem.SubItems.Add(item.username);
ListViewItem.SubItems.Add(item.firstname);
ListViewItem.SubItems.Add(item.insertion);
ListViewItem.SubItems.Add(item.lastname);
ListViewItem.SubItems.Add(item.type);
ListViewItem.SubItems.Add(item.email);
ListViewActors.Items.Add(ListViewItem);
}
if (isManage == false)
{
ListViewActors.Columns.RemoveAt(0);
}
}
// Laat de company table zien
else if (choice == tableToDisplay.contactperson)
{
comboBoxSearch.Items.Add("Weergeef Alles");
comboBoxSearch.Items.Add("Voornaam");
comboBoxSearch.Items.Add("Volledige Achternaam");
if (isManage == false)
{
comboBoxSearch.Items.Add("Bedrijfsnaam");
}
comboBoxSearch.SelectedItem = "Weergeef Alles";
textBoxSearch.Enabled = false;
// Voeg de columns toe
ListViewActors.Columns.Add("ID");
ListViewActors.Columns.Add("Voornaam");
ListViewActors.Columns.Add("Tussenvoegsel");
ListViewActors.Columns.Add("Achternaam");
ListViewActors.Columns.Add("Emailadres");
ListViewActors.Columns.Add("Telefoonnummer");
ListViewActors.Columns.Add("Bedrijfsnaam");
ListViewActors.Columns.Add("Functie");
ListViewActors.Columns.Add("Volgende keer");
ListViewActors.Columns.Add("HHS Contact");
ListViewActors.Columns.Add("Gemaakt door");
// Voeg de data van ListViewActors toe (De columns die docent mag zien)
foreach (var item in ContactpersonList)
{
ListViewItem ListViewItem = new ListViewItem(item.id.ToString());
ListViewItem.SubItems.Add(item.firstname);
ListViewItem.SubItems.Add(item.insertion);
ListViewItem.SubItems.Add(item.lastname);
ListViewItem.SubItems.Add(item.email);
ListViewItem.SubItems.Add(item.phonenumber.ToString());
foreach (var company in CompanyList)
{
if (item.company_id == company.id)
{
ListViewItem.SubItems.Add(company.name);
}
}
ListViewItem.SubItems.Add(item.function);
ListViewItem.SubItems.Add(item.next_time);
foreach (var user in UserList)
{
if (item.contact_hhs == user.id)
{
ListViewItem.SubItems.Add(user.lastname + ", " + user.firstname[0] + ". " + user.insertion);
}
}
foreach (var user in UserList)
{
if (item.created_by == user.id)
{
ListViewItem.SubItems.Add(user.lastname + ", " + user.firstname[0] + ". " + user.insertion);
}
}
ListViewActors.Items.Add(ListViewItem);
}
if (isManage == false)
{
ListViewActors.Columns.RemoveAt(0);
}
}
// Laat de contactperson table zien
else if (choice == tableToDisplay.company)
{
comboBoxSearch.Items.Add("Weergeef Alles");
comboBoxSearch.Items.Add("Stage");
comboBoxSearch.Items.Add("Afstudeerstage");
comboBoxSearch.Items.Add("Stage en Afstudeerstage");
comboBoxSearch.SelectedItem = "Weergeef Alles";
textBoxSearch.Enabled = false;
ListViewActors.Columns.Add("ID");
ListViewActors.Columns.Add("Bedrijfsnaam");
ListViewActors.Columns.Add("Adres");
ListViewActors.Columns.Add("Soort stage");
ListViewActors.Columns.Add("Differentiatie");
ListViewActors.Columns.Add("Contactpersoon");
ListViewActors.Columns.Add("Email");
ListViewActors.Columns.Add("HHS Contact");
ListViewActors.Columns.Add("HHS Email");
// Voeg de data van listViewUsers toe (De columns die docent mag zien)
foreach (var item in CompanyList)
{
ListViewItem ListViewItem = new ListViewItem(item.id.ToString());
ListViewItem.SubItems.Add(item.name);
ListViewItem.SubItems.Add(item.address);
ListViewItem.SubItems.Add(item.internship);
ListViewItem.SubItems.Add(item.internship_differentiation);
foreach (var contactperson in ContactpersonList)
{
if (item.id == contactperson.company_id)
{
ListViewItem.SubItems.Add(contactperson.lastname + ", " + contactperson.firstname[0] + ". " + contactperson.insertion);
ListViewItem.SubItems.Add(contactperson.email);
foreach (var user in UserList)
{
ListViewItem.SubItems.Add(user.lastname + ", " + user.firstname[0] + ". " + user.insertion);
ListViewItem.SubItems.Add(user.email);
}
}
}
if (firstTime == false)
{
ListViewItem.SubItems.RemoveAt(0);
}
ListViewActors.Items.Add(ListViewItem);
}
if (isManage == false)
{
firstTime = true;
ListViewActors.Columns.RemoveAt(0);
}
else
{
ListViewActors.Columns.RemoveAt(8);
ListViewActors.Columns.RemoveAt(7);
ListViewActors.Columns.RemoveAt(6);
ListViewActors.Columns.RemoveAt(5);
}
}
else if (choice == tableToDisplay.contactperson_period)
{
comboBoxSearch.Items.Add("Weergeef Alles");
comboBoxSearch.Items.Add("Periode");
comboBoxSearch.Items.Add("Differentiatie");
comboBoxSearch.Items.Add("Jaar");
comboBoxSearch.SelectedItem = "Weergeef Alles";
textBoxSearch.Enabled = false;
// Voeg de columns toe
ListViewActors.Columns.Add("Periode");
ListViewActors.Columns.Add("Contactpersoon");
ListViewActors.Columns.Add("Differentiatie");
ListViewActors.Columns.Add("Jaar");
ListViewActors.Columns.Add("Geholpen met");
// Voeg de data van ListViewActors toe (De columns die docent mag zien)
foreach (var item in ContactpersonPeriodList)
{
ListViewItem ListViewItem = new ListViewItem(item.period_name);
if (isManage == true)
{
ListViewItem.SubItems.Add(item.contactperson_id.ToString());
}
else
{
foreach (var contactperson in ContactpersonList)
{
if (item.contactperson_id == contactperson.id)
{
ListViewItem.SubItems.Add(contactperson.lastname + ", " + contactperson.firstname[0] + ". " + contactperson.insertion);
}
}
}
ListViewItem.SubItems.Add(item.differentiation);
ListViewItem.SubItems.Add(item.year.ToString());
ListViewItem.SubItems.Add(item.helped_with);
ListViewActors.Items.Add(ListViewItem);
}
}
ListViewActors.AutoResizeColumns(ColumnHeaderAutoResizeStyle.ColumnContent);
ListViewActors.AutoResizeColumns(ColumnHeaderAutoResizeStyle.HeaderSize);
}
// Bekijkt wat je zoekt en filtert daarop
public void SearchItems(tableToDisplay CurrentChoice, string comboBoxSearch, string textBoxSearch, List <User> UserList, List <Company> CompanyList, List <Contactperson> ContactpersonList, List <ContactpersonPeriod> ContactpersonPeriodList, List <Period> PeriodList)
{
ListViewActors.Items.Clear();
// Kijkt op welk gedeelte van de pagina je bent
if (CurrentChoice == tableToDisplay.user)
{
foreach (var item in UserList)
{
// Bekijkt wat je precies wilt zoeken
if (comboBoxSearch.ToString().Equals("Weergeef Alles"))
{
searchShow(item, UserList, CompanyList, ContactpersonList, ContactpersonPeriodList, PeriodList);
}
else if (comboBoxSearch.Equals("Gebruikersnaam") && textBoxSearch.Equals(item.username, StringComparison.InvariantCultureIgnoreCase)) // als de combobox niet leeg is
{
searchShow(item, UserList, CompanyList, ContactpersonList, ContactpersonPeriodList, PeriodList);
}
else if (comboBoxSearch.Equals("Voornaam") && textBoxSearch.Equals(item.firstname, StringComparison.InvariantCultureIgnoreCase)) // als de combobox niet leeg is
{
searchShow(item, UserList, CompanyList, ContactpersonList, ContactpersonPeriodList, PeriodList);
}
else if (comboBoxSearch.Equals("Type") && textBoxSearch.Equals(item.type, StringComparison.InvariantCultureIgnoreCase)) // als de combobox niet leeg is
{
searchShow(item, UserList, CompanyList, ContactpersonList, ContactpersonPeriodList, PeriodList);
}
else if (comboBoxSearch.Equals("Volledige Achternaam") && textBoxSearch.Equals(item.insertion + " " + item.lastname, StringComparison.InvariantCultureIgnoreCase)) // als de combobox niet leeg is
{
searchShow(item, UserList, CompanyList, ContactpersonList, ContactpersonPeriodList, PeriodList);
}
}
}
if (CurrentChoice == tableToDisplay.company)
{
foreach (var item in CompanyList)
{
if (comboBoxSearch.Equals("Weergeef Alles"))
{
searchShow(item, UserList, CompanyList, ContactpersonList, ContactpersonPeriodList, PeriodList);
}
else if (comboBoxSearch != null && textBoxSearch.Equals("")) // als de combobox niet leeg is
{
if (comboBoxSearch.Equals(item.internship))
{
searchShow(item, UserList, CompanyList, ContactpersonList, ContactpersonPeriodList, PeriodList);
}
}
else if (comboBoxSearch != null && textBoxSearch != null) // op beide kunnen zoeken
{
if (comboBoxSearch == item.internship)
{
if (textBoxSearch.Equals(item.internship_differentiation, StringComparison.InvariantCultureIgnoreCase) || textBoxSearch.Equals(item.name, StringComparison.InvariantCultureIgnoreCase)) // met zoekveld zoeken
{
searchShow(item, UserList, CompanyList, ContactpersonList, ContactpersonPeriodList, PeriodList);
}
}
}
}
}
if (CurrentChoice == tableToDisplay.contactperson_period)
{
foreach (var item in ContactpersonPeriodList)
{
if (comboBoxSearch.Equals("Weergeef Alles"))
{
searchShow(item, UserList, CompanyList, ContactpersonList, ContactpersonPeriodList, PeriodList);
}
else if (comboBoxSearch.Equals("Periode") && textBoxSearch.Equals(item.period_name, StringComparison.InvariantCultureIgnoreCase)) // als de combobox niet leeg is
{
searchShow(item, UserList, CompanyList, ContactpersonList, ContactpersonPeriodList, PeriodList);
}
else if (comboBoxSearch.Equals("Differentiatie") && textBoxSearch.Equals(item.differentiation, StringComparison.InvariantCultureIgnoreCase)) // als de combobox niet leeg is
{
searchShow(item, UserList, CompanyList, ContactpersonList, ContactpersonPeriodList, PeriodList);
}
else if (comboBoxSearch.Equals("Jaar") && textBoxSearch.Equals(item.year.ToString(), StringComparison.InvariantCultureIgnoreCase)) // als de combobox niet leeg is
{
searchShow(item, UserList, CompanyList, ContactpersonList, ContactpersonPeriodList, PeriodList);
}
}
}
if (CurrentChoice == tableToDisplay.contactperson)
{
foreach (var item in ContactpersonList)
{
if (comboBoxSearch.Equals("Weergeef Alles"))
{
searchShow(item, UserList, CompanyList, ContactpersonList, ContactpersonPeriodList, PeriodList);
}
else if (comboBoxSearch.Equals("Voornaam") && textBoxSearch.Equals(item.firstname, StringComparison.InvariantCultureIgnoreCase)) // als de combobox niet leeg is
{
searchShow(item, UserList, CompanyList, ContactpersonList, ContactpersonPeriodList, PeriodList);
}
else if (comboBoxSearch.Equals("Volledige Achternaam") && textBoxSearch.Equals(item.insertion + " " + item.lastname, StringComparison.InvariantCultureIgnoreCase)) // als de combobox niet leeg is
{
searchShow(item, UserList, CompanyList, ContactpersonList, ContactpersonPeriodList, PeriodList);
}
else
{
foreach (var company in CompanyList)
{
if (item.company_id == company.id) // als de combobox niet leeg is
{
if (comboBoxSearch.Equals("Bedrijfsnaam") && textBoxSearch.Equals(company.name, StringComparison.InvariantCultureIgnoreCase))
{
searchShow(item, UserList, CompanyList, ContactpersonList, ContactpersonPeriodList, PeriodList);
}
}
}
}
}
}
}
