public Client GetClientById(string id) { var connectionString = ConfigurationManager.ConnectionStrings["AvatarDBPM"].ConnectionString; var client = new Client(); #region commandText var commandText = "SELECT demo.PATID as ClientId," + "demo.patient_name as ClientName, " + "demo.patient_sex_code as GenderCode, " + "demo.patient_sex_value as GenderValue, " + "demo.date_of_birth as DateOfBirth, " + "demo.patient_add_city as City," + "demo.race_code as RaceCode, " + "demo.race_value as RaceValue " + "FROM SYSTEM.patient_current_demographics demo " + "WHERE demo.PATID=? "; #endregion try { using (var connection = new OdbcConnection(connectionString)) { connection.Open(); using (var dbcommand = new OdbcCommand(commandText, connection)) { dbcommand.Parameters.Add(new OdbcParameter("PATID", id)); using (var reader = dbcommand.ExecuteReader()) { if (reader.Read()) { #region ReadInValues client.Id = reader["ClientId"].ToString(); client.Name = reader["ClientName"].ToString(); client.GenderCode = reader["GenderCode"].ToString(); client.GenderValue = reader["GenderValue"].ToString(); client.DateOfBirth = reader.GetDate(reader.GetOrdinal("DateOfBirth")); client.RaceCode = reader["RaceCode"].ToString(); client.RaceValue = reader["RaceValue"].ToString(); client.City = reader["City"].ToString(); #endregion } else { client = null; } } } connection.Close(); } } catch (Exception ex) { } return client; }
public ClientDBData() { ConnectionStringPM = ConfigurationManager.ConnectionStrings["AvatarDBPM"].ConnectionString; client = new Client(); }
public ClientFormData() { client = new Client(); }
public Client GetClientByIdWithEpisode(string ClientId, double Episode) { var connectionString = ConfigurationManager.ConnectionStrings["AvatarDBPM"].ConnectionString; var client = new Client(); #region commandText var commandText = "SELECT demo.PATID as ClientId," + "demo.patient_name as ClientName, " + "demo.patient_sex_code as GenderCode, " + "demo.patient_sex_value as GenderValue, " + "demo.date_of_birth as DateOfBirth, " + "demo.race_code as RaceCode, " + "demo.race_value as RaceValue, " + "ep.program_code as ProgramCode, " + "ep.program_value as ProgramValue, " + "ep.EPISODE_NUMBER as Episode, " + "ep.date_of_discharge as DischargeDate, " + "ep.preadmit_admission_date as AdmissionDate, " + "ep.last_date_of_service as LastServiceDate " + "FROM SYSTEM.patient_current_demographics demo " + "INNER JOIN SYSTEM.episode_history ep " + "ON demo.PATID = ep.PATID " + "AND demo.FACILITY = ep.FACILITY " + "WHERE demo.PATID=? " + "AND ep.EPISODE_NUMBER=? "; #endregion try { using (var connection = new OdbcConnection(connectionString)) { connection.Open(); using (var dbcommand = new OdbcCommand(commandText, connection)) { dbcommand.Parameters.Add(new OdbcParameter("PATID", ClientId)); dbcommand.Parameters.Add(new OdbcParameter("EPISODE_NUMBER", Episode.ToString())); using (var reader = dbcommand.ExecuteReader()) { if (reader.Read()) { #region ReadInValues client.EpisodeInformation.Episode = reader["Episode"].ToString(); client.EpisodeInformation.ProgramCode = reader["ProgramCode"].ToString(); client.EpisodeInformation.ProgramValue = reader["ProgramValue"].ToString(); client.EpisodeInformation.AdmitDate = reader.GetDate(reader.GetOrdinal("AdmitDate")); client.EpisodeInformation.DischargeDate = Helper.GetNullableDatetime(reader, "DischargeDate"); client.EpisodeInformation.LastServiceDate = Helper.GetNullableDatetime(reader, "LastServiceDate"); client.Id = reader["ClientId"].ToString(); client.Name = reader["ClientName"].ToString(); client.GenderCode = reader["GenderCode"].ToString(); client.GenderValue = reader["GenderValue"].ToString(); client.DateOfBirth = reader.GetDate(reader.GetOrdinal("DateOfBirth")); client.RaceCode = reader["RaceCode"].ToString(); client.RaceValue = reader["RaceValue"].ToString(); #endregion } else { client = null; } } } connection.Close(); } } catch (Exception ex) { } return client; }