public DdtHormones GetById(string id)
{
using (dynamic connection = connectionFactory.GetConnection())
{
String sql = String.Format("SELECT dsid_hospitality_session, r_object_id, dss_ttg, dsdt_analysis_date, dss_t3, r_modify_date, dss_t4, r_creation_date, dsid_doctor, dsid_patient FROM ddt_hormones 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())
{
DdtHormones obj = new DdtHormones();
obj.HospitalitySession = reader.IsDBNull(0) ? null : reader.GetString(0);
obj.ObjectId = reader.IsDBNull(1) ? null : reader.GetString(1);
obj.Ttg = reader.IsDBNull(2) ? null : reader.GetString(2);
obj.AnalysisDate = reader.IsDBNull(3) ? DateTime.MinValue : reader.GetDateTime(3);
obj.T3 = reader.IsDBNull(4) ? null : reader.GetString(4);
obj.ModifyDate = reader.IsDBNull(5) ? DateTime.MinValue : reader.GetDateTime(5);
obj.T4 = reader.IsDBNull(6) ? null : reader.GetString(6);
obj.CreationDate = reader.IsDBNull(7) ? DateTime.MinValue : reader.GetDateTime(7);
obj.Doctor = reader.IsDBNull(8) ? null : reader.GetString(8);
obj.Patient = reader.IsDBNull(9) ? null : reader.GetString(9);
return(obj);
}
}
}
return(null);
}
private void initControls()
{
DdtHormones hormones = DbDataService.GetInstance().GetDdtHormonesService().GetById(objectId);
refreshObject(hormones);
admissionDateTxt.Enabled = isEditable;
t4Txt.Enabled = isEditable;
ttgTxt.Enabled = isEditable;
t3Txt.Enabled = isEditable;
}
public string Save(DdtHormones obj)
{
using (dynamic connection = connectionFactory.GetConnection())
{
if (GetById(obj.ObjectId) != null)
{
string sql = "UPDATE ddt_hormones SET " +
"dsid_hospitality_session = @HospitalitySession, " +
"dsid_patient = @Patient, " +
"dsid_doctor = @Doctor, " +
"dsdt_analysis_date = @AnalysisDate, " +
"dss_t3 = @T3, " +
"dss_t4 = @T4, " +
"dss_ttg = @Ttg " +
"WHERE r_object_id = @ObjectId";
Logger.Debug(CultureInfo.CurrentCulture, "SQL: {0}", sql);
using (Npgsql.NpgsqlCommand cmd = new Npgsql.NpgsqlCommand(sql, connection))
{
cmd.CommandType = CommandType.Text;
cmd.Parameters.AddWithValue("@HospitalitySession", obj.HospitalitySession);
cmd.Parameters.AddWithValue("@Patient", obj.Patient);
cmd.Parameters.AddWithValue("@Doctor", obj.Doctor);
cmd.Parameters.AddWithValue("@AnalysisDate", obj.AnalysisDate);
cmd.Parameters.AddWithValue("@T3", obj.T3 == null ? "" : obj.T3);
cmd.Parameters.AddWithValue("@T4", obj.T4 == null ? "" : obj.T4);
cmd.Parameters.AddWithValue("@Ttg", obj.Ttg == null ? "" : obj.Ttg);
cmd.Parameters.AddWithValue("@ObjectId", obj.ObjectId);
cmd.ExecuteNonQuery();
}
return(obj.ObjectId);
}
else
{
string sql = "INSERT INTO ddt_hormones(dsid_hospitality_session,dsid_patient,dsid_doctor,dsdt_analysis_date,dss_t3,dss_t4,dss_ttg) " +
"VALUES(@HospitalitySession,@Patient,@Doctor,@AnalysisDate,@T3,@T4,@Ttg) RETURNING r_object_id";
Logger.Debug(CultureInfo.CurrentCulture, "SQL: {0}", sql);
using (Npgsql.NpgsqlCommand cmd = new Npgsql.NpgsqlCommand(sql, connection))
{
cmd.CommandType = CommandType.Text;
cmd.Parameters.AddWithValue("@HospitalitySession", obj.HospitalitySession);
cmd.Parameters.AddWithValue("@Patient", obj.Patient);
cmd.Parameters.AddWithValue("@Doctor", obj.Doctor);
cmd.Parameters.AddWithValue("@AnalysisDate", obj.AnalysisDate);
cmd.Parameters.AddWithValue("@T3", obj.T3 == null ? "" : obj.T3);
cmd.Parameters.AddWithValue("@T4", obj.T4 == null ? "" : obj.T4);
cmd.Parameters.AddWithValue("@Ttg", obj.Ttg == null ? "" : obj.Ttg);
return((string)cmd.ExecuteScalar());
}
}
}
}
public void saveObject(DdtHospital hospitalitySession, string parentId, string parentType)
{
if (isEditable && (isNew && getIsValid() || isDirty()))
{
DdtHormones hormones = (DdtHormones)getObject();
hormones.HospitalitySession = hospitalitySession.ObjectId;
hormones.Doctor = hospitalitySession.CuringDoctor;
hormones.Patient = hospitalitySession.Patient;
objectId = DbDataService.GetInstance().GetDdtHormonesService().Save(hormones);
isNew = false;
hasChanges = false;
}
}
public object getObject()
{
DdtHormones hormones = DbDataService.GetInstance().GetDdtHormonesService().GetById(objectId);
if (hormones == null)
{
hormones = new DdtHormones();
}
hormones.AnalysisDate = admissionDateTxt.Value;
hormones.T3 = t3Txt.Text;
hormones.T4 = t4Txt.Text;
hormones.Ttg = ttgTxt.Text;
return(hormones);
}
public void refreshObject(object obj)
{
if (obj != null && obj is DdtHormones)
{
DdtHormones hormones = (DdtHormones)obj;
admissionDateTxt.Value = hormones.AnalysisDate;
t4Txt.Text = hormones.T4;
ttgTxt.Text = hormones.Ttg;
t3Txt.Text = hormones.T3;
hormonesPnl.Text = "Гормоны за " + hormones.AnalysisDate.ToShortDateString();
objectId = hormones.ObjectId;
isNew = string.IsNullOrEmpty(objectId);
hasChanges = false;
}
}
public IList <DdtHormones> GetByParentId(string parentId)
{
IList <DdtHormones> list = new List <DdtHormones>();
if (parentId == null)
{
return(list);
}
using (dynamic connection = connectionFactory.GetConnection())
{
String sql = "SELECT dsid_hospitality_session, ho.r_object_id, dss_ttg, dsdt_analysis_date, dss_t3, r_modify_date, dss_t4, r_creation_date, " +
"dsid_doctor, dsid_patient FROM ddt_hormones ho, ddt_relation rel WHERE rel.dsid_parent = '{0}' AND rel.dsid_child=ho.r_object_id";
Logger.Debug(CultureInfo.CurrentCulture, "SQL: {0}", sql);
Npgsql.NpgsqlCommand command = new Npgsql.NpgsqlCommand(sql, connection);
using (DbDataReader reader = command.ExecuteReader())
{
while (reader.Read())
{
DdtHormones obj = new DdtHormones();
obj.HospitalitySession = reader.IsDBNull(0) ? null : reader.GetString(0);
obj.ObjectId = reader.IsDBNull(1) ? null : reader.GetString(1);
obj.Ttg = reader.IsDBNull(2) ? null : reader.GetString(2);
obj.AnalysisDate = reader.IsDBNull(3) ? DateTime.MinValue : reader.GetDateTime(3);
obj.T3 = reader.IsDBNull(4) ? null : reader.GetString(4);
obj.ModifyDate = reader.IsDBNull(5) ? DateTime.MinValue : reader.GetDateTime(5);
obj.T4 = reader.IsDBNull(6) ? null : reader.GetString(6);
obj.CreationDate = reader.IsDBNull(7) ? DateTime.MinValue : reader.GetDateTime(7);
obj.Doctor = reader.IsDBNull(8) ? null : reader.GetString(8);
obj.Patient = reader.IsDBNull(9) ? null : reader.GetString(9);
list.Add(obj);
}
}
}
return(list);
}
