public DdtConsiliumGroup GetById(string id) { using (dynamic connection = connectionFactory.GetConnection()) { String sql = String.Format("SELECT r_object_id, r_modify_date, r_creation_date, dss_name, dsi_level FROM ddt_consilium_group 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()) { DdtConsiliumGroup obj = new DdtConsiliumGroup(); obj.ObjectId = reader.IsDBNull(0) ? null : reader.GetString(0); obj.ModifyDate = reader.IsDBNull(1) ? DateTime.MinValue : reader.GetDateTime(1); obj.CreationDate = reader.IsDBNull(2) ? DateTime.MinValue : reader.GetDateTime(2); obj.Name = reader.IsDBNull(0) ? null : reader.GetString(3); obj.Level = reader.IsDBNull(4) ? -1 : reader.GetInt16(4); return(obj); } } } return(null); }
public IList <DdtConsiliumGroup> GetAll() { IList <DdtConsiliumGroup> list = new List <DdtConsiliumGroup>(); using (dynamic connection = connectionFactory.GetConnection()) { String sql = "SELECT r_object_id, r_modify_date, r_creation_date, dss_name, dsi_level FROM ddt_consilium_group"; Logger.Debug(CultureInfo.CurrentCulture, "SQL: {0}", sql); Npgsql.NpgsqlCommand command = new Npgsql.NpgsqlCommand(sql, connection); using (DbDataReader reader = command.ExecuteReader()) { while (reader.Read()) { DdtConsiliumGroup obj = new DdtConsiliumGroup(); obj.ObjectId = reader.IsDBNull(0) ? null : reader.GetString(0); obj.ModifyDate = reader.IsDBNull(1) ? DateTime.MinValue : reader.GetDateTime(1); obj.CreationDate = reader.IsDBNull(2) ? DateTime.MinValue : reader.GetDateTime(2); obj.Name = reader.IsDBNull(0) ? null : reader.GetString(3); obj.Level = reader.IsDBNull(4) ? -1 : reader.GetInt16(4); list.Add(obj); } } } return(list); }
private string GetMembersInString(IDbDataService service, string consiliumId) { IList <DdtConsiliumRelation> consiluimRelations = service.GetDdtConsiliumRelationService().GetConsiliumRelationsByConsiliumId(consiliumId); Dictionary <int, String> memberToOrder = new Dictionary <int, String>(); SortedDictionary <String, String> sortedMembers = new SortedDictionary <String, String>(); foreach (DdtConsiliumRelation relation in consiluimRelations) { DdtConsiliumGroupMember groupMember = service.GetDdtConsiliumGroupMemberService().GetById(relation.Member); DdtConsiliumGroup group = service.GetDdtConsiliumGroupService().GetById(groupMember.Group); DdvDoctor doctor = service.GetDdvDoctorService().GetById(groupMember.Doctor); if (!sortedMembers.ContainsKey(group.Level + " " + group.Name + " " + doctor.ShortName)) { sortedMembers.Add(group.Level + " " + group.Name + " " + doctor.ShortName, group.Name + " " + groupMember.Name + " " + doctor.ShortName); } } StringBuilder str = new StringBuilder(); foreach (KeyValuePair <String, String> kvp in sortedMembers) { if (str.Length > 0) { str.Append('\n'); } str.Append(kvp.Value); } return(str.ToString()); }
private void InitDefaultMembers(IDbDataService service, IList <DdtConsiliumGroupMember> defaultGroupMembers) { for (int i = 0; i < defaultGroupMembers.Count; i++) { if (doctorsContainer.Controls.Count <= i) { doctorsContainer.Controls.Add(CommonUtils.CopyControl(dotorInfoPnl0, doctorsContainer.Controls.Count)); } ComboBox cbApp = (ComboBox)CommonUtils.FindControl(doctorsContainer, "appointmentTxt" + i); cbApp.SelectedIndexChanged += new System.EventHandler(this.appointmentTxt0_SelectedIndexChanged); ControlUtils.InitConsiliumGroupsComboboxValues(service.GetDdtConsiliumGroupService(), cbApp); DdtConsiliumGroup group = service.GetDdtConsiliumGroupService().GetById(defaultGroupMembers[i].Group); if (group != null) { cbApp.SelectedIndex = cbApp.FindStringExact(group.Name); ComboBox cbDoctor = (ComboBox)CommonUtils.FindControl(doctorsContainer, "doctorWho" + i); ControlUtils.InitDoctorsByConsiliumGroupId(service.GetDdvDoctorService(), cbDoctor, group.ObjectId); cbDoctor.SelectedValue = defaultGroupMembers[i].Doctor; } //Control c = CommonUtils.FindControl(doctorsContainer, "objectIdLbl" + i); //c.Text = defaultMembers[i].ObjectId; Button b = (Button)CommonUtils.FindControl(doctorsContainer, "removeBtn" + i); b.Visible = true; b.Click += new System.EventHandler(this.removeBtn0_Click); } }
private void appointmentTxt0_SelectedIndexChanged(object sender, EventArgs e) { ComboBox cb = (ComboBox)sender; DdtConsiliumGroup group = (DdtConsiliumGroup)cb.SelectedItem; if (group != null) { string ctrlName = cb.Name; int indxPlace = CommonUtils.GetFirstDigitIndex(ctrlName); int index = Convert.ToInt32(String.Intern(ctrlName.Substring(indxPlace))); ComboBox c = (ComboBox)CommonUtils.FindControl(doctorsContainer, "doctorWho" + index); ControlUtils.InitDoctorsByConsiliumGroupId(service.GetDdvDoctorService(), c, group.ObjectId); if ("duty_cardioreanim".Equals(group.Name, StringComparison.Ordinal)) { c.SelectedIndex = c.FindStringExact(curingDoc?.ShortName); } } }
public string Save(DdtConsiliumGroup obj) { using (dynamic connection = connectionFactory.GetConnection()) { if (GetById(obj.ObjectId) != null) { string sql = "UPDATE ddt_consilium_group SET " + "dss_name = @Name, " + "dsi_level = @Level " + "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("@Name", obj.Name == null ? "" : obj.Name); cmd.Parameters.AddWithValue("@Level", obj.Level); cmd.Parameters.AddWithValue("@ObjectId", obj.ObjectId); cmd.ExecuteNonQuery(); } return(obj.ObjectId); } else { string sql = "INSERT INTO ddt_consilium_group(dss_name,dsi_level) " + "VALUES(@Name,@Level) 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("@Name", obj.Name == null ? "" : obj.Name); cmd.Parameters.AddWithValue("@Level", obj.Level); 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); }