public List <DdtConsiliumRelation> GetByQuery(string sql)
{
List <DdtConsiliumRelation> list = new List <DdtConsiliumRelation>();
using (dynamic connection = connectionFactory.GetConnection())
{
Logger.Debug(CultureInfo.CurrentCulture, "SQL: {0}", sql);
Npgsql.NpgsqlCommand command = new Npgsql.NpgsqlCommand(sql, connection);
using (DbDataReader reader = command.ExecuteReader())
{
while (reader.Read())
{
DdtConsiliumRelation obj = new DdtConsiliumRelation();
obj.ObjectId = reader.IsDBNull(0) ? null : reader.GetString(0);
obj.ModifyDate = reader.IsDBNull(1) ? DateTime.MinValue : reader.GetDateTime(1);
obj.Consilium = reader.IsDBNull(2) ? null : reader.GetString(2);
obj.CreationDate = reader.IsDBNull(3) ? DateTime.MinValue : reader.GetDateTime(3);
obj.Member = reader.IsDBNull(4) ? null : reader.GetString(4);
list.Add(obj);
}
}
}
return(list);
}
public IList <DdtConsiliumRelation> GetConsiliumRelationsByConsiliumId(string consiliumId)
{
IList <DdtConsiliumRelation> list = new List <DdtConsiliumRelation>();
using (dynamic connection = connectionFactory.GetConnection())
{
String sql = String.Format("SELECT r_object_id, r_modify_date, dsid_consilium, r_creation_date, dsid_member FROM ddt_consilium_relation WHERE dsid_consilium = '{0}'", consiliumId);
Logger.Debug(CultureInfo.CurrentCulture, "SQL: {0}", sql);
Npgsql.NpgsqlCommand command = new Npgsql.NpgsqlCommand(sql, connection);
using (DbDataReader reader = command.ExecuteReader())
{
while (reader.Read())
{
DdtConsiliumRelation obj = new DdtConsiliumRelation();
obj.ObjectId = reader.IsDBNull(0) ? null : reader.GetString(0);
obj.ModifyDate = reader.IsDBNull(1) ? DateTime.MinValue : reader.GetDateTime(1);
obj.Consilium = reader.IsDBNull(2) ? null : reader.GetString(2);
obj.CreationDate = reader.IsDBNull(3) ? DateTime.MinValue : reader.GetDateTime(3);
obj.Member = reader.IsDBNull(4) ? null : reader.GetString(4);
list.Add(obj);
}
}
}
return(list);
}
public string Save(DdtConsiliumRelation obj)
{
using (dynamic connection = connectionFactory.GetConnection())
{
if (GetById(obj.ObjectId) != null)
{
string sql = "UPDATE ddt_consilium_relation SET " +
"dsid_consilium = @Consilium, " +
"dsid_member = @Member " +
"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("@Consilium", obj.Consilium);
cmd.Parameters.AddWithValue("@Member", obj.Member);
cmd.Parameters.AddWithValue("@ObjectId", obj.ObjectId);
cmd.ExecuteNonQuery();
}
return(obj.ObjectId);
}
else
{
string sql = "INSERT INTO ddt_consilium_relation(dsid_consilium, dsid_member) " +
"VALUES(@Consilium, @Member) 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("@Consilium", obj.Consilium);
cmd.Parameters.AddWithValue("@Member", obj.Member);
return((string)cmd.ExecuteScalar());
}
}
}
}
public bool Save()
{
if (!getIsValid())
{
return(false);
}
hospitalitySession.Diagnosis = getSafeStringValue(diagnosisTxt1);
service.GetDdtHospitalService().Save(hospitalitySession);
DdtConsilium consilium = null;
if (!string.IsNullOrEmpty(consiliumId))
{
consilium = service.GetDdtConsiliumService().GetById(consiliumId);
}
else
{
consilium = new DdtConsilium
{
ConsiliumDate = DateTime.Now,
HospitalitySession = hospitalitySession.ObjectId,
Patient = hospitalitySession.Patient,
Doctor = hospitalitySession.CuringDoctor
};
}
consilium.Decision = getSafeStringValue(decisionTxt);
consilium.Diagnosis = getSafeStringValue(diagnosisTxt0);
consilium.DutyAdminName = getSafeStringValue(adminTxt);
consilium.Dynamics = getSafeStringValue(dynamicsTxt);
consilium.Goal = getSafeStringValue(goalTxt);
consiliumId = service.GetDdtConsiliumService().Save(consilium);
foreach (Control doctorInfoPnl in doctorsContainer.Controls)
{
DdtConsiliumRelation consiliumRelation = null;
String doctorInfoPnlName = getSafeObjectValueUni <string>(doctorInfoPnl, new getValue <string>((ctrl) => (ctrl.Name)));
string indexstr = string.Intern(doctorInfoPnlName.Substring(CommonUtils.GetFirstDigitIndex(doctorInfoPnlName)));
int indx = Int32.Parse(indexstr);
Control objectIdCtrl = CommonUtils.FindControl(doctorsContainer, "objectIdLbl" + indx);
if (!string.IsNullOrEmpty(objectIdCtrl.Text))
{
consiliumRelation = service.GetDdtConsiliumRelationService().GetById(objectIdCtrl.Text);
}
else
{
consiliumRelation = new DdtConsiliumRelation();
consiliumRelation.Consilium = consiliumId;
}
Control appCb = CommonUtils.FindControl(doctorsContainer, "appointmentTxt" + indx);
DdtConsiliumGroup group = getSafeObjectValueUni <DdtConsiliumGroup>(appCb, (ctrl) => ((DdtConsiliumGroup)((ComboBox)ctrl).SelectedItem));
Control docCb = CommonUtils.FindControl(doctorsContainer, "doctorWho" + indx);
DdvDoctor doctor = getSafeObjectValueUni <DdvDoctor>(docCb, (ctrl) => ((DdvDoctor)((ComboBox)ctrl).SelectedItem));
if (group != null && doctor != null)
{
DdtConsiliumGroupMember consiliumGroupMember = service.GetDdtConsiliumGroupMemberService().GetByDoctorAndGroupId(doctor.ObjectId, group.ObjectId);
consiliumRelation.Member = consiliumGroupMember.ObjectId;
service.GetDdtConsiliumRelationService().Save(consiliumRelation);
}
}
foreach (String consiliumRelationId in consiliumRelationToRemove)
{
service.Delete(DdtConsiliumRelation.NAME, consiliumRelationId);
}
analysisTabControl1.save(consiliumId, DdtConsilium.NAME); SetConsiliumIdToTransfusion(); return(true);
}
