/* Read all allergens */ public async Task <List <Allergen> > readAllergens(int chartId) { try { string query = $@" SELECT allergen.id as allergenId, allergen.patient_chart as allergenPatientChartId, medicament.id as medicamentId, medicament.name as medicamentName FROM {DBTables.ALLERGEN} as allergen INNER JOIN {DBTables.MEDICAMENT} as medicament ON {DBTables.ALLERGEN}.medicament = {DBTables.MEDICAMENT}.id WHERE allergen.patient_chart = @chartId"; MySqlConnection connection = new MySqlConnection(DB.connectionString); connection.Open(); MySqlCommand cmd = new MySqlCommand(query, connection); cmd.Parameters.AddWithValue("@chartId", chartId); cmd.Prepare(); DbDataReader reader = await cmd.ExecuteReaderAsync(); List <Allergen> allergens = new List <Allergen>(); while (reader.Read()) { PatientChart chart = new PatientChart( reader.GetInt32(reader.GetOrdinal("allergenPatientChartId")), DateTime.Now, null ); Medicament medicament = new Medicament( reader.GetInt32(reader.GetOrdinal("medicamentId")), reader.GetString(reader.GetOrdinal("medicamentName")), "", DateTime.Now, "" ); Allergen allergen = new Allergen( reader.GetInt32(reader.GetOrdinal("allergenId")), chart, medicament ); allergens.Add(allergen); } return(allergens); } catch (Exception e) { throw e; } }
public ChartDocument() { this.Id = 0; this.Name = ""; this.Type = ""; this.URL = ""; this.DateCreated = DateTime.Now; this.PatientChart = null; }
public Allergen( int id, PatientChart patientChart, Medicament medicament ) { this.Id = id; this.PatientChart = patientChart; this.Medicament = medicament; }
/* Read one patient chart by patient id */ public async Task <PatientChart> readPatientChart(int patientId) { try { string query = $@" SELECT * FROM {DBTables.PATIENT_CHART} WHERE {DBTables.PATIENT_CHART}.patient = @patientId"; MySqlConnection connection = new MySqlConnection(DB.connectionString); connection.Open(); MySqlCommand cmd = new MySqlCommand(query, connection); cmd.Parameters.AddWithValue("@patientId", patientId); cmd.Prepare(); DbDataReader reader = await cmd.ExecuteReaderAsync(); PatientChart patientChart = new PatientChart(); while (reader.Read()) { Patient currentPatient = new Patient( reader.GetInt32(reader.GetOrdinal("patient")), "", "", "", "", DateTime.Now, "" ); PatientChart chart = new PatientChart( reader.GetInt32(reader.GetOrdinal("id")), reader.GetDateTime(reader.GetOrdinal("date_created")), currentPatient ); return(chart); } return(null); } catch (Exception e) { Console.Write(e); throw e; } }
public ChartDocument( int id, string name, string type, string url, DateTime dateCreated, PatientChart patientChart ) { this.Id = id; this.DateCreated = dateCreated; this.Name = name; this.Type = type; this.URL = url; this.PatientChart = patientChart; }
/* Read all chart documents */ public async Task <List <ChartDocument> > readChartDocuments(int chartId) { try { string query = $@" SELECT * FROM {DBTables.CHART_DOCUMENT} WHERE patient_chart = @chartId"; MySqlConnection connection = new MySqlConnection(DB.connectionString); connection.Open(); MySqlCommand cmd = new MySqlCommand(query, connection); cmd.Parameters.AddWithValue("@chartId", chartId); cmd.Prepare(); DbDataReader reader = await cmd.ExecuteReaderAsync(); List <ChartDocument> docs = new List <ChartDocument>(); while (reader.Read()) { PatientChart chart = new PatientChart( reader.GetInt32(reader.GetOrdinal("patient_chart")), DateTime.Now, null ); ChartDocument doc = new ChartDocument( reader.GetInt32(reader.GetOrdinal("id")), reader.GetString(reader.GetOrdinal("name")), reader.GetString(reader.GetOrdinal("type")), reader.GetString(reader.GetOrdinal("url")), reader.GetDateTime(reader.GetOrdinal("date_created")), chart ); docs.Add(doc); } return(docs); } catch (Exception e) { throw e; } }