public PatientChart(int id, DateTime createdAt, Patient patient) { this.Id = id; this.CreatedAt = createdAt; this.Patient = patient; }
/** * Method to read reservations from the database */ public async Task <List <Reservation> > readReservations() { try { string query = $@" SELECT reservation.id as reservationId, reservation.start_datetime as reservationStart, reservation.end_datetime as reservationEnd, service.id as serviceId, service.name as serviceName, service.fee as serviceFee, service.description as serviceDescription, operator.id as operatorId, operator.first_name as operatorFirstName, operator.last_name as operatorLastName, patient.id as patientId, patient.first_name as patientFirstName, patient.last_name as patientLastName, nurse.id as nurseId, nurseEmployee.first_name as nurseFirstName, nurseEmployee.last_name as nurseLastName, doctor.id as doctorId, doctorEmployee.first_name as doctorFirstName, doctorEmployee.last_name as doctorLastName FROM {DBTables.RESERVATION} as reservation INNER JOIN {DBTables.SERVICE} as service ON {DBTables.RESERVATION}.service = {DBTables.SERVICE}.id INNER JOIN {DBTables.OPERATOR} as operator ON {DBTables.RESERVATION}.created_by = {DBTables.OPERATOR}.id INNER JOIN {DBTables.PATIENT} as patient ON {DBTables.RESERVATION}.patient = {DBTables.PATIENT}.id INNER JOIN ( {DBTables.NURSE} as nurse INNER JOIN {DBTables.EMPLOYEE} as nurseEmployee ON {DBTables.NURSE}.employee = nurseEmployee.id ) ON {DBTables.RESERVATION}.nurse = {DBTables.NURSE}.id INNER JOIN ( {DBTables.DOCTOR} as doctor INNER JOIN {DBTables.EMPLOYEE} as doctorEmployee ON {DBTables.DOCTOR}.employee = doctorEmployee.id ) ON {DBTables.RESERVATION}.doctor = {DBTables.DOCTOR}.id"; MySqlConnection connection = new MySqlConnection(DB.connectionString); connection.Open(); MySqlCommand cmd = new MySqlCommand(query, connection); cmd.Prepare(); DbDataReader reader = await cmd.ExecuteReaderAsync(); List <Reservation> reservations = new List <Reservation>(); while (reader.Read()) { Service currentService = new Service( reader.GetInt32(reader.GetOrdinal("serviceId")), reader.GetString(reader.GetOrdinal("serviceName")), reader.GetInt32(reader.GetOrdinal("serviceFee")), reader.GetString(reader.GetOrdinal("serviceDescription")) ); Operator currentOperator = new Operator( null, reader.GetInt32(reader.GetOrdinal("operatorId")), reader.GetString(reader.GetOrdinal("operatorFirstName")), reader.GetString(reader.GetOrdinal("operatorLastName")), DateTime.Now ); Patient currentPatient = new Patient( reader.GetInt32(reader.GetOrdinal("patientId")), reader.GetString(reader.GetOrdinal("patientFirstName")), reader.GetString(reader.GetOrdinal("patientLastName")), "", "", DateTime.Now, "" ); Employee nurseEmployee = new Employee( -1, reader.GetString(reader.GetOrdinal("nurseFirstName")), reader.GetString(reader.GetOrdinal("nurseLastName")), "", "", DateTime.Now, null ); Nurse currentNurse = new Nurse( reader.GetInt32(reader.GetOrdinal("nurseId")), nurseEmployee ); Employee doctorEmployee = new Employee( -1, reader.GetString(reader.GetOrdinal("doctorFirstName")), reader.GetString(reader.GetOrdinal("doctorLastName")), "", "", DateTime.Now, null ); Doctor currentDoctor = new Doctor( reader.GetInt32(reader.GetOrdinal("doctorId")), doctorEmployee, "" ); Reservation currentReservation = new Reservation( reader.GetInt32(reader.GetOrdinal("reservationId")), reader.GetDateTime(reader.GetOrdinal("reservationStart")), reader.GetDateTime(reader.GetOrdinal("reservationEnd")), currentService, currentOperator, currentPatient, currentNurse, currentDoctor ); reservations.Add(currentReservation); } return(reservations); } catch (Exception e) { throw e; } }
public PatientChart() { this.Id = 0; this.CreatedAt = DateTime.Now; this.Patient = null; }