public static Model.Persoon GetPersoon(int PersoonId, Model.Persoon p)
{
SqlConnection connection = DALConnection.openConnectieDB();
DALConnection.openConnectieDB();
StringBuilder sbquery = new StringBuilder();
sbquery.Append("SELECT * FROM Persoon WHERE PersoonId = " + PersoonId + "");
String sql = sbquery.ToString();
SqlCommand command = new SqlCommand(sql, connection);
SqlDataReader reader = command.ExecuteReader();
while (reader.Read())
{
p.Persoonid = (int)reader["PersoonId"];
p.Naam = (string)reader["Naam"];
p.Achternaam = (string)reader["Achternaam"];
p.Categorie = (Model.DeelnemerCategorie)reader["Categorie"];
p.Geboortedatum = (DateTime)reader["GeboorteDatum"];
}
reader.Close();
DALConnection.sluitConnectieDB(connection);
return(p);
}
public static Model.Persoon checkCredentials(Model.Login user)
{
Model.Persoon p = new Model.Persoon();
int Persoonid = GetLogin(user);
GetPersoon(Persoonid, p);
return(p);
}
public static Model.Persoon GetLoginId(int loginId, string pwdhash)
{
Model.Persoon p = new Model.Persoon();
SqlConnection connection = DALConnection.openConnectieDB();
DALConnection.openConnectieDB();
StringBuilder sbquery = new StringBuilder();
sbquery.Append("SELECT * FROM Login WHERE LoginId = " + loginId + ";");
String sql = sbquery.ToString();
SqlCommand command = new SqlCommand(sql, connection);
SqlDataReader reader = command.ExecuteReader();
while (reader.Read())
{
p.Persoonid = (int)reader["PersoonId"];
p.Naam = (string)reader["AanmeldNaam"];
}
reader.Close();
DALConnection.sluitConnectieDB(connection);
return(p);
}
