public void PatientHistory(MySqlConnection conn, Patient patient) { MySqlDataReader Reader = DB.getRequests(conn, "patient_username", patient.getUsername(), true); int i = 1; while (Reader.Read()) { Console.Write(i + " " + Reader["doctor_username"] + " " + "\n"); i++; } }
public void MyRequest(MySqlConnection conn, Patient patient) { MySqlDataReader Reader = DB.getRequests(conn, "patient_username", patient.getUsername(), true); List <int> requests = new List <int>(); while (Reader.Read()) { requests.Add((int)Reader["id"]); Console.Write(Reader["doctor_username"] + " " + Convert.ToDateTime(Reader["date"]).ToString("yyyy-MM-dd H:mm") + "\n"); } Reader.Close(); Console.WriteLine(); conn.Close(); }
public void RequestForConsultation(MySqlConnection conn, Patient patient) { MySqlDataReader Reader = DB.getUsers(conn, "doctor"); List <string> doctors = new List <string>(); int i = 1; while (Reader.Read()) { doctors.Add((string)Reader["username"]); Console.Write(i + " " + Reader["username"] + "\n"); i++; } Reader.Close(); int line = Convert.ToInt16(Console.ReadLine()); TypeDate(conn, doctors[line - 1], patient.getUsername()); }