public void PatientHistory(MySqlConnection conn, Doctor doctor) { MySqlDataReader Reader = DB.getRequests(conn, "doctor_username", doctor.getUsername(), true); int i = 1; while (Reader.Read()) { Console.Write(i + " " + Reader["patient_username"] + " " + "\n"); i++; } }
public void MyRequest(MySqlConnection conn, Doctor doctor) { MySqlDataReader Reader = DB.getRequests(conn, "doctor_username", doctor.getUsername(), false); List <int> requests = new List <int>(); int i = 1; while (Reader.Read()) { requests.Add((int)Reader["id"]); Console.Write(i + " " + Reader["patient_username"] + " requested for consultation in " + Convert.ToDateTime(Reader["date"]).ToString("yyyy-MM-dd H:mm") + "\n"); i++; } Reader.Close(); int line = Convert.ToInt16(Console.ReadLine()); DB.AcceptRequest(conn, requests[line - 1]); Console.ReadLine(); conn.Close(); }