public IList <DdvAllDiagnosis> GetAll()
{
IList <DdvAllDiagnosis> list = new List <DdvAllDiagnosis>();
using (dynamic connection = connectionFactory.GetConnection())
{
String sql = "SELECT dsid_hospitality_session, r_object_id, object_type, dss_diagnosis FROM ddv_all_diagnosis";
Logger.Debug(CultureInfo.CurrentCulture, "SQL: {0}", sql);
Npgsql.NpgsqlCommand command = new Npgsql.NpgsqlCommand(sql, connection);
using (DbDataReader reader = command.ExecuteReader())
{
while (reader.Read())
{
DdvAllDiagnosis obj = new DdvAllDiagnosis();
obj.HospitalitySession = reader.IsDBNull(0) ? null : reader.GetString(0);
obj.ObjectId = reader.IsDBNull(1) ? null : reader.GetString(1);
obj.Type = reader.IsDBNull(2) ? null : reader.GetString(2);
obj.Diagnosis = reader.IsDBNull(3) ? null : reader.GetString(3);
list.Add(obj);
}
}
}
return(list);
}
public DdvAllDiagnosis GetById(string id)
{
using (dynamic connection = connectionFactory.GetConnection())
{
String sql = String.Format("SELECT dsid_hospitality_session, r_object_id, object_type, dss_diagnosis FROM ddv_all_diagnosis WHERE r_object_id = '{0}'", id);
Logger.Debug(CultureInfo.CurrentCulture, "SQL: {0}", sql);
Npgsql.NpgsqlCommand command = new Npgsql.NpgsqlCommand(sql, connection);
using (DbDataReader reader = command.ExecuteReader())
{
if (reader.Read())
{
DdvAllDiagnosis obj = new DdvAllDiagnosis();
obj.HospitalitySession = reader.IsDBNull(0) ? null : reader.GetString(0);
obj.ObjectId = reader.IsDBNull(1) ? null : reader.GetString(1);
obj.Type = reader.IsDBNull(2) ? null : reader.GetString(2);
obj.Diagnosis = reader.IsDBNull(3) ? null : reader.GetString(3);
return(obj);
}
}
}
return(null);
}
