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