protected static int getNextID(string sqlName, string primaryKey)
{
SQL.CustomDBDataReader customDBReader = SQL.SQL_Connector.sendRequest($"SELECT max({primaryKey}) FROM {sqlName}");
customDBReader.Read();
try { int result = customDBReader.reader.GetInt32(0);
customDBReader.Close();
return(result + 1); }
catch (System.Data.SqlTypes.SqlNullValueException e)
{
customDBReader.Close();
return(0);
}
}
public static List <Patientenbesuch> getPatientenbesuche(Patient patient)
{
List <Patientenbesuch> patientenListe = new List <Patientenbesuch>();
List <int> idListe = new List <int>();
SQL.CustomDBDataReader dbReaderAllPatients = SQL.SQL_Connector.sendRequest("select idPatientenbesuch from patientenbesuch where idPatient = " + patient.Id);
while (dbReaderAllPatients.Read())
{
idListe.Add(dbReaderAllPatients.getInt("idPatientenbesuch"));
}
dbReaderAllPatients.Close();
foreach (int id in idListe)
{
patientenListe.Add(Patientenbesuch.getPatientenbesuch(id));
}
return(patientenListe);
}
public static List <Patient> getAllePatienten()
{
List <Patient> patientenListe = new List <Patient>();
List <int> idListe = new List <int>();
SQL.CustomDBDataReader dbReaderAllPatients = SQL.SQL_Connector.sendRequest("SELECT idPatient FROM PATIENTEN");
while (dbReaderAllPatients.Read())
{
idListe.Add(dbReaderAllPatients.getInt("idPatient"));
}
dbReaderAllPatients.Close();
foreach (int id in idListe)
{
patientenListe.Add(Patient.getPatient(id));
}
return(patientenListe);
}
