public List <Team> GetTeams(string vereniging)
{
DatabaseAcces Data = new DatabaseAcces();
List <Team> Teams = new List <Team>();
Teams = Data.WhereTeamRequest("Naam", "Team", "VerenigingIDFK", vereniging);
return(Teams);
}
//Methods
public List <Vereniging> FindVereniging()
{
DatabaseAcces Data = new DatabaseAcces();
List <Vereniging> Verenigingen = new List <Vereniging>();
Verenigingen = Data.GetVereniging("Vereniging");
return(Verenigingen);
}
//Methods
public static List <Speler> GetSpelers(string TeamID)
{
DatabaseAcces Data = new DatabaseAcces();
List <Speler> info1 = new List <Speler>();
Team Team1 = new Team();
info1 = Data.SelectSpelers("Speler", "TeamIDFK", TeamID);
return(info1);
}
public int GetTeamID(string team)
{
DatabaseAcces Data = new DatabaseAcces();
int Teams;
Teams = Data.WhereRequestInner("TeamID", "Team", "Naam", team);
return(Teams);
}
//methods
public static Team GetTeams1(string Teamnaam)
{
DatabaseAcces Data = new DatabaseAcces();
List <string> info1 = new List <string>();
List <string> info2 = new List <string>();
Team Team1 = new Team();
info1 = Data.WhereRequest("Naam", "Team", "Naam", Teamnaam);
info2 = Data.WhereRequest("TeamID", "Team", "Naam", Teamnaam);
Team1.Naam = info1[0];
Team1.TeamID = Convert.ToInt32(info2[0]);
return(Team1);
}
public void getinfo(List <int> ID, ListView list)
{
List <Lid> leden = new List <Lid>();
foreach (int item in ID)
{
leden.Add(data.getinfoLid("LidID", item.ToString()));
}
foreach (Lid item in leden)
{
int Rugnummer = 0;
DatabaseAcces data = new DatabaseAcces();
string[] row1 = { item.Naam, item.NevoboNummer };
Rugnummer = data.getrugnummer("lidIDFK", item.LidNummer.ToString());
list.Items.Add(Rugnummer.ToString()).SubItems.AddRange(row1);
}
}