public DdtXRay GetById(string id)
{
using (dynamic connection = connectionFactory.GetConnection())
{
String sql = String.Format("SELECT r_object_id, dsdt_analysis_date, dss_mskt, r_creation_date, dss_kt, dsid_parent, dss_chest_xray, dsid_doctor, dsid_patient, dsid_hospitality_session, r_modify_date, dss_parent_type, dss_mrt, dss_control_radiography, dsdt_kt_date FROM ddt_xray 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())
{
DdtXRay obj = new DdtXRay();
obj.ObjectId = reader.IsDBNull(0) ? null : reader.GetString(0);
obj.AnalysisDate = reader.IsDBNull(1) ? DateTime.MinValue : reader.GetDateTime(1);
obj.Mskt = reader.IsDBNull(2) ? null : reader.GetString(2);
obj.CreationDate = reader.IsDBNull(3) ? DateTime.MinValue : reader.GetDateTime(3);
obj.Kt = reader.IsDBNull(4) ? null : reader.GetString(4);
obj.Parent = reader.IsDBNull(5) ? null : reader.GetString(5);
obj.ChestXray = reader.IsDBNull(6) ? null : reader.GetString(6);
obj.Doctor = reader.IsDBNull(7) ? null : reader.GetString(7);
obj.Patient = reader.IsDBNull(8) ? null : reader.GetString(8);
obj.HospitalitySession = reader.IsDBNull(9) ? null : reader.GetString(9);
obj.ModifyDate = reader.IsDBNull(10) ? DateTime.MinValue : reader.GetDateTime(10);
obj.ParentType = reader.IsDBNull(11) ? null : reader.GetString(11);
obj.Mrt = reader.IsDBNull(12) ? null : reader.GetString(12);
obj.ControlRadiography = reader.IsDBNull(13) ? null : reader.GetString(13);
obj.KtDate = reader.IsDBNull(14) ? DateTime.MinValue : reader.GetDateTime(14);
return(obj);
}
}
}
return(null);
}
private void initControls()
{
DdtXRay xRay = service.GetDdtXrayService().GetById(objectId);
refreshObject(xRay);
chestXRayTxt.Enabled = isEditable;
controlRadiographyTxt.Enabled = isEditable;
ktTxt.Enabled = isEditable;
mrtTxt.Enabled = isEditable;
}
public object getObject()
{
DdtXRay xRay = service.GetDdtXrayService().GetById(objectId);
if (xRay == null)
{
xRay = new DdtXRay();
}
xRay.ChestXray = chestXRayTxt.Text;
xRay.ControlRadiography = controlRadiographyTxt.Text;
xRay.Kt = ktTxt.Text;
xRay.Mrt = mrtTxt.Text;
xRay.AnalysisDate = CommonUtils.ConstructDateWIthTime(ktDateTxt.Value, ktTimeTxt.Value);
return(xRay);
}
public void refreshObject(object obj)
{
if (obj != null && obj is DdtXRay)
{
DdtXRay xRay = (DdtXRay)obj;
ktDateTxt.Value = xRay.AnalysisDate;
ktTimeTxt.Value = xRay.AnalysisDate;
chestXRayTxt.Text = xRay.ChestXray;
controlRadiographyTxt.Text = xRay.ControlRadiography;
ktTxt.Text = xRay.Kt;
mrtTxt.Text = xRay.Mrt;
objectId = xRay.ObjectId;
isNew = string.IsNullOrEmpty(objectId);
hasChanges = false;
}
}
public IList <DdtXRay> GetByParentId(string parentId)
{
IList <DdtXRay> list = new List <DdtXRay>();
if (parentId == null)
{
return(list);
}
using (dynamic connection = connectionFactory.GetConnection())
{
String sql = String.Format("SELECT zr.r_object_id, dsdt_analysis_date, dss_mskt, r_creation_date, dss_kt, rel.dsid_parent, dss_chest_xray, " +
"dsid_doctor, dsid_patient, dsid_hospitality_session, r_modify_date, zr.dss_parent_type, dss_mrt, dss_control_radiography, dsdt_kt_date " +
"FROM ddt_xray zr, ddt_relation rel WHERE rel.dsid_parent = '{0}' AND rel.dsid_child=zr.r_object_id", parentId);
Logger.Debug(CultureInfo.CurrentCulture, "SQL: {0}", sql);
Npgsql.NpgsqlCommand command = new Npgsql.NpgsqlCommand(sql, connection);
using (DbDataReader reader = command.ExecuteReader())
{
while (reader.Read())
{
DdtXRay obj = new DdtXRay();
obj.ObjectId = reader.IsDBNull(0) ? null : reader.GetString(0);
obj.AnalysisDate = reader.IsDBNull(1) ? DateTime.MinValue : reader.GetDateTime(1);
obj.Mskt = reader.IsDBNull(2) ? null : reader.GetString(2);
obj.CreationDate = reader.IsDBNull(3) ? DateTime.MinValue : reader.GetDateTime(3);
obj.Kt = reader.IsDBNull(4) ? null : reader.GetString(4);
obj.Parent = reader.IsDBNull(5) ? null : reader.GetString(5);
obj.ChestXray = reader.IsDBNull(6) ? null : reader.GetString(6);
obj.Doctor = reader.IsDBNull(7) ? null : reader.GetString(7);
obj.Patient = reader.IsDBNull(8) ? null : reader.GetString(8);
obj.HospitalitySession = reader.IsDBNull(9) ? null : reader.GetString(9);
obj.ModifyDate = reader.IsDBNull(10) ? DateTime.MinValue : reader.GetDateTime(10);
obj.ParentType = reader.IsDBNull(11) ? null : reader.GetString(11);
obj.Mrt = reader.IsDBNull(12) ? null : reader.GetString(12);
obj.ControlRadiography = reader.IsDBNull(13) ? null : reader.GetString(13);
obj.KtDate = reader.IsDBNull(14) ? DateTime.MinValue : reader.GetDateTime(14);
list.Add(obj);
}
}
}
return(list);
}
private void saveXRayTab(DataService service)
{
if (isNeedSaveTab(4))
{
if (xRay == null)
{
xRay = new DdtXRay();
xRay.DsidHospitalitySession = hospitalitySession.ObjectId;
xRay.DsidDoctor = hospitalitySession.DsidCuringDoctor;
xRay.DsidPatient = hospitalitySession.DsidPatient;
}
xRay.DssChestXray = chestXRayTxt.Text;
xRay.DssControlRadiography = controlRadiographyTxt.Text;
xRay.DssKt = ktTxt.Text;
xRay.DssMrt = mrtTxt.Text;
xRay.DssMskt = msktTxt.Text;
string id = updateObject <DdtXRay>(service, xRay, DdtXRay.TABLE_NAME, xRay.ObjectId);
patientAnalysis.DsidXray = id;
}
}
public Analizi(DdtHospital hospitalitySession, DdtPatientAnalysis analysis)
{
this.hospitalitySession = hospitalitySession;
this.patientAnalysis = analysis;
InitializeComponent();
if (patientAnalysis != null)
{
DataService service = new DataService();
uziObj = service.queryObject <DdtUzi>(@"select * from " + DdtUzi.TABLE_NAME + " WHERE r_object_id ='" + patientAnalysis.DsisUzi + "'");
specialistConclusion = service.queryObject <DdtSpecialistConclusion>(@"select * from " + DdtSpecialistConclusion.TABLE_NAME + " WHERE r_object_id ='" + patientAnalysis.DsidSpecialistConclusion + "'");
holter = service.queryObject <DdtHolter>(@"select * from " + DdtHolter.TABLE_NAME + " WHERE r_object_id ='" + patientAnalysis.DsidHolter + "'");
xRay = service.queryObject <DdtXRay>(@"select * from " + DdtXRay.TABLE_NAME + " WHERE r_object_id ='" + patientAnalysis.DsidXray + "'");
urineAnalysis = service.queryObject <DdtUrineAnalysis>(@"select * from " + DdtUrineAnalysis.TABLE_NAME + " WHERE r_object_id ='" + patientAnalysis.DsisUrineAnalysis + "'");
initUziTab();
intSpecialistConslusionTab();
initHolterTab();
initXRay();
initUrineAnalysis();
}
}
public void saveObject(DdtHospital hospitalitySession, string parentId, string parentType)
{
if (isEditable && (isNew && getIsValid() || isDirty()))
{
DdtXRay xRay = (DdtXRay)getObject();
xRay.HospitalitySession = hospitalitySession.ObjectId;
xRay.Doctor = hospitalitySession.CuringDoctor;
xRay.Patient = hospitalitySession.Patient;
if (parentId != null)
{
xRay.Parent = parentId;
}
if (parentType != null)
{
xRay.ParentType = parentType;
}
objectId = service.GetDdtXrayService().Save(xRay);
isNew = false;
hasChanges = false;
}
}
public string Save(DdtXRay obj)
{
using (dynamic connection = connectionFactory.GetConnection())
{
if (GetById(obj.ObjectId) != null)
{
string sql = "UPDATE ddt_xray SET " +
"dsid_hospitality_session = @HospitalitySession, " +
"dsid_patient = @Patient, " +
"dsid_doctor = @Doctor, " +
"dsdt_analysis_date = @AnalysisDate, " +
"dss_chest_xray = @ChestXray, " +
"dss_control_radiography = @ControlRadiography, " +
"dss_mskt = @Mskt, " +
"dss_kt = @Kt, " +
"dss_mrt = @Mrt, " +
"dsdt_kt_date = @KtDate, " +
"dsid_parent = @Parent, " +
"dss_parent_type = @ParentType " +
"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("@ChestXray", obj.ChestXray == null ? "" : obj.ChestXray);
cmd.Parameters.AddWithValue("@ControlRadiography", obj.ControlRadiography == null ? "" : obj.ControlRadiography);
cmd.Parameters.AddWithValue("@Mskt", obj.Mskt == null ? "" : obj.Mskt);
cmd.Parameters.AddWithValue("@Kt", obj.Kt == null ? "" : obj.Kt);
cmd.Parameters.AddWithValue("@Mrt", obj.Mrt == null ? "" : obj.Mrt);
cmd.Parameters.AddWithValue("@KtDate", obj.KtDate);
cmd.Parameters.AddWithValue("@Parent", obj.Parent == null ? "0000000000000000" : obj.Parent);
cmd.Parameters.AddWithValue("@ParentType", obj.ParentType == null ? "" : obj.ParentType);
cmd.Parameters.AddWithValue("@ObjectId", obj.ObjectId);
cmd.ExecuteNonQuery();
}
return(obj.ObjectId);
}
else
{
string sql = "INSERT INTO ddt_xray(dsid_hospitality_session,dsid_patient,dsid_doctor,dsdt_analysis_date,dss_chest_xray,dss_control_radiography,dss_mskt,dss_kt,dss_mrt,dsdt_kt_date,dsid_parent,dss_parent_type) " +
"VALUES(@HospitalitySession,@Patient,@Doctor,@AnalysisDate,@ChestXray,@ControlRadiography,@Mskt,@Kt,@Mrt,@KtDate,@Parent,@ParentType) 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("@ChestXray", obj.ChestXray == null ? "" : obj.ChestXray);
cmd.Parameters.AddWithValue("@ControlRadiography", obj.ControlRadiography == null ? "" : obj.ControlRadiography);
cmd.Parameters.AddWithValue("@Mskt", obj.Mskt == null ? "" : obj.Mskt);
cmd.Parameters.AddWithValue("@Kt", obj.Kt == null ? "" : obj.Kt);
cmd.Parameters.AddWithValue("@Mrt", obj.Mrt == null ? "" : obj.Mrt);
cmd.Parameters.AddWithValue("@KtDate", obj.KtDate);
cmd.Parameters.AddWithValue("@Parent", obj.Parent == null ? "0000000000000000" : obj.Parent);
cmd.Parameters.AddWithValue("@ParentType", obj.ParentType == null ? "" : obj.ParentType);
return((string)cmd.ExecuteScalar());
}
}
}
}
