public Model.Patient GetPatientById(int pid)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 p_name, old, gender from [patient_data] ");
strSql.Append("where pid = @pid ");
SqlParameter[] parameters = { new SqlParameter("@pid ", SqlDbType.Int) };
parameters[0].Value = pid;
Model.Patient model = new Model.Patient();
DataTable dt = SqlDbHelper.ExecuteDataTable(strSql.ToString(), CommandType.Text, parameters);
if (dt.Rows.Count > 0)
{
if (dt.Rows[0]["p_name"] != null && dt.Rows[0]["p_name"].ToString() != "")
{
model.P_name = dt.Rows[0]["p_name"].ToString();
}
if (dt.Rows[0]["gender"] != null && dt.Rows[0]["gender"].ToString() != "")
{
model.Gender = dt.Rows[0]["gender"].ToString();
}
if (dt.Rows[0]["old"] != null && dt.Rows[0]["old"].ToString() != "")
{
model.Old = Convert.ToInt16(dt.Rows[0]["old"].ToString());
}
return(model);
}
else
{
return(null);
}
}
private void BtnSave_Click(object sender, EventArgs e)
{
const string argumentNullError = "Der Patient kann nicht gespeichert werden ohne ";
const string strBirthday = "ein gültiges Geburtsdatum.";
const string strGender = "ein Geschlecht.";
const string strAddress = "gültige Adressdaten.";
const string strInsurance = "eine Krankenkasse.";
const string strDoctor = "einen Hausarzt.";
if (dtpBirthday.Text == String.Empty)
{
MessageBox.Show(argumentNullError + strBirthday);
}
else if (tbGender.Text == String.Empty)
{
MessageBox.Show(argumentNullError + strGender);
}
else if (selectedAddress == null)
{
MessageBox.Show(argumentNullError + strAddress);
}
else if (selectedInsurance == null)
{
MessageBox.Show(argumentNullError + strInsurance);
}
else if (selectedDoctor == null)
{
MessageBox.Show(argumentNullError + strDoctor);
}
else
{
if (int.TryParse(tbInsuranceNr.Text, out var insuranceNr))
{
var birthday = dtpBirthday.Value;
var gender = tbGender.Text;
var note = tbNote.Text;
if (patient != null) // edit handover patient
{
patient.Birthday = birthday;
patient.Gender = gender;
patient.InsuranceNr = insuranceNr;
patient.InsuranceAgency = selectedInsurance;
patient.LocalDoctor = selectedDoctor;
patient.Address = selectedAddress;
patient.Note = tbNote.Text;
patient.Update();
}
else
{
patient = new Model.Patient(birthday, gender, selectedInsurance, insuranceNr, selectedDoctor, selectedAddress, note); // create new patient
}
this.DialogResult = DialogResult.OK;
}
else
{
MessageBox.Show("Die Krankenversichertennummer darf nur aus Ziffern bestehen."); //TODO: Maybe not use Integer in the Database? My InsuranceID has letters in it
}
}
}
public virtual List <Model.Patient> Get_unThreeStool()
{
List <Model.Patient> listPatient = new List <Model.Patient>();
string sql = "select Patient_Id as \"PatientID\",VISITID as \"VisitId\",Patient_Name as \"PatientName\",Nurse_Cell_Code as \"NurseCellCode\" from " + Patient + " where 1=1 ";
//sql += " and State='在科'";
sql += " order by Nurse_Cell_Code";
DataTable dt = dbhelper_Interface.MyExecuteQuery(sql);
for (int i = 0; i < dt.Rows.Count; i++)
{
if (Get_isThreeDayUnStool(Convert.ToString(dt.Rows[i]["PatientID"]), Convert.ToString(dt.Rows[i]["VisitId"])))
{
Model.Patient pt = new Model.Patient()
{
PatientID = Convert.ToString(dt.Rows[i]["PatientID"]),
PatientName = Convert.ToString(dt.Rows[i]["PatientName"]),
VisitID = new DAL.Common().StrToInt_N(dt.Rows[i]["VisitId"].ToString()),
NurseCellCode = Convert.ToString(dt.Rows[i]["NurseCellCode"])
};
listPatient.Add(pt);
}
}
return(listPatient);
}
public async Task <IActionResult> Save([FromBody] Model.Patient model)
{
try
{
var message = new Message();
message.BusinessLogic = configuration.GetValue <string>("AppSettings:BusinessLogic:Patient");
message.Connection = configuration.GetValue <string>("ConnectionStrings:appointmentControl");
message.Operation = Operation.Save;
message.MessageInfo = model.SerializeObject();
using (var businessLgic = new DoWorkService())
{
var result = await businessLgic.DoWork(message);
if (result.Status == Status.Failed)
{
return(BadRequest(result.Result));
}
var resultModel = result.DeSerializeObject <Model.Patient>();
return(Ok(resultModel));
}
}
catch (Exception ex)
{
return(StatusCode((int)HttpStatusCode.Ambiguous, new { ex = ex, param = model }));
}
}
public Fiche_PatientViewModel(Model.Patient patient)
{
_liveActionCommand = new RelayCommand(LiveAction);
_addObservation = new RelayCommand(param => AddObs(), param => true);
Patient = patient;
if (Patient.Obs != null && Patient.Obs.Count() > 0)
{
SelectedObservation = Patient.Obs.ElementAt(0);
}
else
{
SelectedObservation = null;
}
View.MainWindow mainwindow = (View.MainWindow)Application.Current.MainWindow;
object datacontext = mainwindow.DataContext;
ViewModel.MainWindow main = (ViewModel.MainWindow)datacontext;
if (main.ConnectedUser.Role.Equals("Medecin"))
{
this._isAdmin = true;
}
else
{
this._isAdmin = false;
}
ListImages = null;
}
private void baocun_btn_Click(object sender, EventArgs e)
{
//将输入的信息封装成类对象，传入bll层
Model.Patient patient = new Model.Patient();
Model.Patient_Tab patient_tab = new Model.Patient_Tab();
patient.P_name = tb_pname.Text.Trim();
//年龄信息出错，提醒用户
try
{
patient.Old = Convert.ToInt16(tb_old.Text.Trim());
}
catch (Exception exp)
{
MessageBoxBuilder.buildbox((exp.Message), "错误！");
return;
}
patient.Tel = tb_tel.Text.Trim();
patient.Idcard = tb_idcard.Text.Trim();
patient.D_ID = UserHelper.id;
//用与得到用户转入的病人照片信息
if (FileName != null && !"".Equals(FileName))
{
if ((pictureBox1.Image != null))
{
pictureBox1.Image.Dispose();
pictureBox1.Image = null;
}
patient.Thumb = Common.Util.GetImageByte(FileName);
}
if (rb_man.Checked)
{
patient.Gender = "男";
}
else if (rb_woman.Checked)
{
patient.Gender = "女";
}
else
{
patient.Gender = "不详";
}
patient_tab.Chufang_count = Convert.ToInt32(tb_jishu.Text.Trim());
patient_tab.Xianbingshi = tb_bingshi.Text.Trim();
patient_tab.Zhengduan = tb_zhenduan.Text.Trim();
string msg = "";
//添加处方信息与病人信息
if (patientInstance.AddPatient(patient, patient_tab, out msg))
{
MessageBoxBuilder.buildbox("保存成功！", "ok");
ShowPhoto();
}
else if (!"".Equals(msg))
{
MessageBoxBuilder.buildbox(msg,"错误");
}
else
{
MessageBoxBuilder.buildbox("未知错误！插入失败!","错误");
}
}
public Model.Patient GetPatientById(int pid)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 p_name, old, gender from [patient_data] ");
strSql.Append("where pid = @pid ");
SqlParameter[] parameters = { new SqlParameter("@pid ", SqlDbType.Int) };
parameters[0].Value = pid;
Model.Patient model = new Model.Patient();
DataTable dt = SqlDbHelper.ExecuteDataTable(strSql.ToString(), CommandType.Text, parameters);
if (dt.Rows.Count > 0)
{
if (dt.Rows[0]["p_name"] != null && dt.Rows[0]["p_name"].ToString() != "")
{
model.P_name = dt.Rows[0]["p_name"].ToString();
}
if (dt.Rows[0]["gender"] != null && dt.Rows[0]["gender"].ToString() != "")
{
model.Gender = dt.Rows[0]["gender"].ToString();
}
if (dt.Rows[0]["old"] != null && dt.Rows[0]["old"].ToString() != "")
{
model.Old = Convert.ToInt16(dt.Rows[0]["old"].ToString());
}
return model;
}
else
{
return null;
}
}
private void CreatePatientMethod()
{
if (Firstname == null || Firstname.Equals("") || Name == null || Name.Equals(""))
{
MaterialMessageBox.ShowError("Le patient doit avoir un nom/prénom !");
return;
}
Model.Patient patient = new Model.Patient()
{
birthday = Birthdate,
firstname = Firstname,
name = Name
};
if (Patients.CreatePatient(patient))
{
lastWindow.UpdatePatientList();
CloseCurrentWindow();
var msg = Utils.Utils.createMessageBox("Patient crée avec succés");
msg.Show();
}
else
{
MaterialMessageBox.ShowError("Impossible de créer un nouveau patient !");
}
}
public bool UpdatePatient(Model.Patient entity)
{
var validation = new PatientValidation.PatientEntityValidate().Validate(entity);
if (!validation.IsValid)
{
throw new ValidationException(validation.Errors);
}
using (var db = new Model.PhysicManagementEntities())
{
var Entity = db.Patient.Find(entity.Id);
Entity.FirstName = entity.FirstName;
Entity.LastName = entity.LastName;
Entity.Mobile = entity.Mobile;
Entity.NationalCode = entity.NationalCode;
Entity.Code = entity.Code;
Entity.Province = entity.Province;
Entity.City = entity.City;
Entity.Address = entity.Address;
Entity.RegisterDate = entity.RegisterDate;
Entity.GenderIsMale = entity.GenderIsMale;
return(db.SaveChanges() == 1);
}
}
public CashRegisterWindow(Model.User userLoggedIn, Model.Statement statement, Model.Patient patient)
{
this.InitializeComponent();
FillPatients();
_userLoggedIn = userLoggedIn;
_statement = statement;
_selectedPatient = patient;
_isStatement = _statement != null;
if (_statement != null)
{
this.Title = "Abonar/Liquidar estado de cuenta";
lblAccountStatusNumber.ToolTip = lblAccountStatusNumber.Content = _statement.StatementId.ToString();
gbAccountStatusNumber.Visibility = System.Windows.Visibility.Visible;
btnClearForm.Visibility = System.Windows.Visibility.Hidden;
cbPatients.IsEnabled = false;
FillTreatments();
FillPayments();
SelectPatient();
}
else
{
gbAccountStatusNumber.Header = "Estado de cuenta activo";
}
UpdateTotals();
}
public bool AddPatient(Model.Patient patient, Model.Patient_Tab patient_tab, out string msg)
{
msg = "";
if (!CheckPatientData(patient, out msg))
{
return(false);
}
int id = pa.AddPatientRetId(patient);
if (id != -1)
{
patient_tab.Pid = id;
if (!CheckPatientTabData(patient_tab, out msg))
{
return(false);
}
if ((paT.AddPatientTab(patient_tab)))
{
return(true);
}
else
{
pa.DeletePatientById(id);
msg = "插入病人诊断信息失败!";
return(false);
}
}
msg = "插入病人信息失败！";
return(false);
}
public ManageProgressNotesWindow(Model.Patient patient)
{
this.InitializeComponent();
_patient = patient;
UpdateGrid();
}
public AppointmentsList(Model.Patient patient, Model.Hospital hospitalIn)
{
InitializeComponent();
using (SqlConnection connection = new SqlConnection())
{
connection.Open();
using (SqlCommand command = new SqlCommand())
{
command.Connection = connection;
command.CommandText = "SELECT apptTime, apptDate, importance, reason FROM Hospital.dbo.Appointments" +
"\n WHERE patientID = @patientID AND hospitalID = @hospitalID;";
SqlDataReader cursor = command.ExecuteReader();
if (cursor.Read())
{
object[] tuple = new object[cursor.FieldCount];
cursor.GetValues(tuple);
DateTime date = (DateTime)tuple[0];
DateTime time = (DateTime)tuple[1];
DateTime schedule = new DateTime(date.Year, date.Month, date.Day, time.Hour, time.Minute, time.Second, DateTimeKind.Local);
Model.Triage importance = (Model.Triage)Enum.Parse(typeof(Model.Triage), (string)tuple[2]);
Model.Specialty specialty = (Model.Specialty)Enum.Parse(typeof(Model.Specialty), (string)tuple[3]);
}
}
}
}
public StatementExpirationDateModal(Model.Statement statement, Model.Patient patient, Model.User user)
{
this.InitializeComponent();
_statement = statement;
_patient = patient;
_user = user;
}
public void CreatePatientInformation(Model.Patient _objPatient)
{
using (var _dbPatient = new PatientDemographicsContext())
{
_dbPatient.Patient.Add(_objPatient);
_dbPatient.SaveChanges();
}
}
public void FillListPatient()
{
ServicePatient.ServicePatientClient service = new ServicePatient.ServicePatientClient();
try
{
ServicePatient.Patient[] listPatient = service.GetListPatient();
this._allPatient = new List <Model.Patient>();
List <Model.Observation> listObs = new List <Model.Observation>();
foreach (ServicePatient.Patient pat in listPatient)
{
Model.Patient patient = new Model.Patient
{
Birth = pat.Birthday,
Firstname = pat.Firstname,
Name = pat.Name,
Id = pat.Id
};
if (pat.Observations != null)
{
foreach (ServicePatient.Observation obs in pat.Observations)
{
Model.Observation observation = new Model.Observation
{
Comments = obs.Comment,
Date = obs.Date,
Pic = obs.Pictures ?? new List <byte[]>().ToArray(),
Prescriptions = obs.Prescription.ToList() ?? new List <string>(),
Pressure = obs.BloodPressure,
Weight = obs.Weight
};
listObs.Add(observation);
}
patient.Obs = listObs;
}
patient.Name = FirstUpper(patient.Name);
patient.Firstname = FirstUpper(patient.Firstname);
patient.Birthday = pat.Birthday.ToString("dd/MM/yyyy");
this._allPatient.Add(patient);
}
ListPatient = new ObservableCollection <Model.Patient>(this._allPatient);
}
catch
{
MainWindow main = new MainWindow();
View.MainWindow mainwindow = (View.MainWindow)Application.Current.MainWindow;
View.Patients view = new colle_tMedecine.View.Patients();
ViewModel.PatientsViewModel vm = new colle_tMedecine.ViewModel.PatientsViewModel();
view.DataContext = vm;
main.navigate((UserControl)mainwindow.contentcontrol.Content, view);
}
}
public ManageUserDentegraAuthorizationsWindow(Model.Patient selectedPatient)
{
this.InitializeComponent();
_selectedPatient = selectedPatient;
lblExpNumber.ToolTip = lblExpNumber.Content = selectedPatient.AssignedId;
lblPatientName.ToolTip = lblPatientName.Content = selectedPatient.FirstName + " " + selectedPatient.LastName;
UpdateGrid();
}
private void baocun_btn_Click(object sender, EventArgs e)
{
Model.Patient patient = new Model.Patient();
Model.Patient_Tab patient_tab = new Model.Patient_Tab();
patient.P_name = tb_pname.Text.Trim();
try
{
patient.Old = Convert.ToInt16(tb_old.Text.Trim());
}
catch (Exception exp)
{
MessageBox.Show(exp.Message);
return;
}
patient.Tel = tb_tel.Text.Trim();
patient.Idcard = tb_idcard.Text.Trim();
patient.D_ID = 10000;
if (FileName != null && !"".Equals(FileName))
{
if ((pictureBox1.Image != null))
{
pictureBox1.Image.Dispose();
}
patient.Thumb = Common.Util.GetImageByte(FileName);
}
if (rb_man.Checked)
{
patient.Gender = "男";
}
else if (rb_woman.Checked)
{
patient.Gender = "女";
}
else
{
patient.Gender = "不详";
}
patient_tab.Chufang_count = Convert.ToInt32(tb_jishu.Text.Trim());
patient_tab.Xianbingshi = tb_bingshi.Text.Trim();
patient_tab.Zhengduan = tb_zhenduan.Text.Trim();
string msg = "";
if (patientInstance.AddPatient(patient, patient_tab, out msg))
{
MessageBox.Show("保存成功！");
}
else if (!"".Equals(msg))
{
MessageBox.Show(msg);
}
else
{
MessageBox.Show("未知错误！插入失败!");
}
}
public AddEditProgressNoteModal(Model.ProgressNote selectedProgressNote, Model.Patient patient)
{
this.InitializeComponent();
_patient = patient;
_selectedProgressNote = selectedProgressNote;
_isUpdateProgressNote = selectedProgressNote != null;
if (_isUpdateProgressNote)
PrepareWindowForUpdates();
}
public NewObservationViewModel(Model.Patient patient)
{
_addCommand = new RelayCommand(param => AddObservation(), param => true);
_addPresc = new RelayCommand(param => AddPrescription(), param => true);
_addImage = new RelayCommand(param => AddImageAction(), param => true);
PatientName = String.Format("{0} {1}", patient.Name, patient.Firstname);
Patient = patient;
Pictures = new ObservableCollection <Image>();
Date = DateTime.Now;
Prescriptions = new List <string>();
}
public AddEditInitialDentalNoteWindow(Model.Patient patientToUpdate)
{
this.InitializeComponent();
FillTreatments();
AddEmptyItemToComboBoxes();
_patientToUpdate = patientToUpdate;
_isUpdateDentalInitialNote = patientToUpdate != null;
if (_isUpdateDentalInitialNote)
PrepareWindowForUpdates();
}
public UpdateClinicHistoryWindow(Model.Patient patient)
{
this.InitializeComponent();
_patient = patient;
_isUpdate = patient.ClinicHistoryId != null;
FillGeneralInfo();
if (_isUpdate)
{
FillAllClinicHistoryInfo();
}
}
public void ShowPatientSheet(object param)
{
View.MainWindow mainwindow = (View.MainWindow)Application.Current.MainWindow;
ViewModel.MainWindow mainwindowVM = (ViewModel.MainWindow)mainwindow.DataContext;
Model.Patient pat = (Model.Patient)param;
View.Fiche_Patient view = new colle_tMedecine.View.Fiche_Patient();
ViewModel.Fiche_PatientViewModel vm = new colle_tMedecine.ViewModel.Fiche_PatientViewModel(pat);
view.DataContext = vm;
mainwindowVM.navigate((UserControl)mainwindow.contentcontrol.Content, view);
}
public bool AddPatient(Model.Patient entity)
{
var validation = new PatientValidation.PatientEntityValidate().Validate(entity);
if (!validation.IsValid)
{
throw new ValidationException(validation.Errors);
}
using (var db = new Model.PhysicManagementEntities())
{
db.Patient.Add(entity);
return(db.SaveChanges() == 1);
}
}
public AddEditDentegraAuthorizationsModal(Model.Patient selectedPatient, Model.DentegraAuthorization selectedElegibility)
{
this.InitializeComponent();
_selectedPatient = selectedPatient;
_selectedElegibility = selectedElegibility;
_isUpdateElegibility = selectedElegibility != null;
lblExpNumber.ToolTip = lblExpNumber.Content = selectedPatient.AssignedId;
lblPatientName.ToolTip = lblPatientName.Content = selectedPatient.FirstName + " " + selectedPatient.LastName;
if (_isUpdateElegibility)
{
PrepareWindowForUpdates();
}
}
public void DeletePatient(object param)
{
Model.Patient patient = (Model.Patient)param;
ServicePatient.ServicePatientClient service = new ServicePatient.ServicePatientClient();
try
{
service.DeletePatient(patient.Id);
this._allPatient.Remove(patient);
ListPatient = new ObservableCollection <Model.Patient>(_allPatient);
}
catch
{
ListPatient = new ObservableCollection <Model.Patient>(_allPatient);
}
}
public async Task <Model.Patient> Get(Model.Patient model)
{
using (var connection = new SqlConnection(ConnectionString))
{
var result = connection.Query <
appointmentControl.Backend.Model.Patient>
("SP_PATIENT_GET",
param: new
{
P_PK_PATIENT = model.Pk_Patient,
P_NAME = model.Name,
P_IDENTITY = model.Identity,
},
commandType: CommandType.StoredProcedure).FirstOrDefault();
return(await Task.FromResult <Model.Patient>(result));
}
}
public CanceledEventsSendEmailModal(List<Model.Event> canceledEventsInARow, List<Model.Event> canceledEventsOfSameTreatment, Model.Patient patient, Model.Treatment treatment)
{
this.InitializeComponent();
_canceledEventsInARow = canceledEventsInARow;
_canceledEventsOfSameTreatment = canceledEventsOfSameTreatment;
_patient = patient;
_treatment = treatment;
lblEmailLogMessage.Content = string.Format("Enviando correo(s) al paciente {1} {2} (Exp. No. {0})\npor los siguientes motivos:\n", _patient.AssignedId, _patient.FirstName, _patient.LastName);
lblEmailLogMessage.Content += _canceledEventsInARow == null
? string.Empty
: "\n- 3 citas canceladas consecutivas.";
lblEmailLogMessage.Content += _canceledEventsOfSameTreatment == null
? string.Empty
: string.Format("\n- 3 citas canceladas para el tratamiento de '{0}'.", _treatment.Name);
}
public async Task SignInAsync(IPlatformParameters context)
{
if (Settings.SecurityEnabled)
{
await MicrosoftGraphService.SignInAsync(context);
Model.Patient currentPatient = await GetPatientInfo();
if (currentPatient != null)
{
AppSettings.CurrentPatientId = currentPatient.PatientId;
MicrosoftGraphService.LoggedUserPhoto = currentPatient.Picture;
}
PublishChanges();
LoadUserPhoto();
}
}
public bool UpdatePatient(Model.Patient patient)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update [patient_data] set");
strSql.Append("p_name=@p_name,gender=@gender,old=@old," +
"tel=@tel,idcard=@idcard,d_id=@d_id,thumb=@thumb where pid=@pid");
int row = SqlDbHelper.ExecuteNonQuery(strSql.ToString(), CommandType.Text, ParsePara(patient));
if (row > 0)
{
return(true);
}
else
{
return(false);
}
}
private Model.Patient ParseData()
{
Model.Patient patient = new Model.Patient();
patient.D_ID = UserHelper.id;
patient.Pid = Convert.ToInt32(id_tb.Text);
patient.P_name = name_tb.Text;
patient.Tel = phone_tb.Text;
if (FileName != null && !"".Equals(FileName))
{
if ((pb_patient.Image != null))
{
pb_patient.Image.Dispose();
}
patient.Thumb = Common.Util.GetImageByte(FileName);
}
patient.P_name = name_tb.Text;
patient.Gender = gender_tb.Text;
return(patient);
}
public static ObservableCollection <Model.Patient> GetAllPatients()
{
ServicePatientClient servicePatient = new ServicePatientClient();
ObservableCollection <Model.Patient> result = new ObservableCollection <Model.Patient>();
try
{
var response = servicePatient.GetListPatient();
foreach (var patient in response)
{
ObservableCollection <Model.Observation> observations = new ObservableCollection <Model.Observation>();
Model.Patient newP = new Model.Patient()
{
birthday = patient.Birthday,
firstname = patient.Firstname,
id = patient.Id,
name = patient.Name
};
if (patient.Observations != null)
{
foreach (var observation in patient.Observations)
{
Model.Observation newOb = new Model.Observation()
{
bloodPressure = observation.BloodPressure,
comment = observation.Comment,
date = observation.Date,
pictures = observation.Pictures,
prescription = observation.Prescription,
weight = observation.Weight
};
observations.Add(newOb);
}
}
newP.observations = observations;
result.Add(newP);
}
}
catch (Exception e) { System.Console.WriteLine(e.Message); }
finally { servicePatient.Close(); }
return(result);
}
public static bool CreatePatient(Model.Patient patient)
{
ServicePatientClient servicePatient = new ServicePatientClient();
bool result = false;
try
{
ServicePatient.Patient patientS = new ServicePatient.Patient()
{
Birthday = patient.birthday,
Firstname = patient.firstname,
Name = patient.name,
Observations = null
};
result = servicePatient.AddPatient(patientS);
}
catch (Exception) { }
finally { servicePatient.Close(); }
return(result);
}
public bool AddPatient(Model.Patient patient)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into [patient_data](p_name,d_id,gender,old," +
"tel,idcard,thumb) values");
strSql.Append("(@p_name,@d_id,@gender,@old,@tel,@idcard,@thumb)");
int row = SqlDbHelper.ExecuteNonQuery(strSql.ToString(), CommandType.Text, ParsePara(patient));
if (row > 0)
{
return(true);
}
else
{
return(false);
}
}
public AddEditPatientsModal(Model.Patient patientToUpdate, bool hasHealthInsurance, bool isDiverse, bool isDentegra, Model.User userLoggedIn)
{
this.InitializeComponent();
_userLoggedIn = userLoggedIn;
_hasHealthInsurance = hasHealthInsurance;
_isDiverse = isDiverse;
_isDentegra = isDentegra;
_patientToUpdate = patientToUpdate;
_isUpdatePatientInfo = patientToUpdate != null;
if (_isUpdatePatientInfo)
{
PrepareWindowForUpdates();
}
else
{
txtExpNumber.Text = Controllers.BusinessController.Instance.GetNextPatientAssignedId().ToString();
}
}
public int AddPatientRetId(Model.Patient patient)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into [patient_data](p_name,d_id,gender,old," +
"tel,idcard,thumb) output inserted.pid values");
strSql.Append("(@p_name,@d_id,@gender,@old,@tel,@idcard,@thumb)");
SqlDataReader reader = SqlDbHelper.ExecuteReader(strSql.ToString(), CommandType.Text, ParsePara(patient));
if (reader.Read())
{
return(Int16.Parse(reader[0].ToString()));
}
else
{
return(-1);
}
}
public SqlParameter[] ParsePara(Model.Patient patient)
{
SqlParameter[] parameters =
{
new SqlParameter("@p_name", SqlDbType.VarChar, 6),
new SqlParameter("@gender", SqlDbType.VarChar, 4),
new SqlParameter("@old", SqlDbType.Int),
new SqlParameter("@tel", SqlDbType.VarChar, 15),
new SqlParameter("@idcard", SqlDbType.VarChar, 18),
new SqlParameter("@d_id", SqlDbType.Int),
new SqlParameter("@thumb", SqlDbType.Image)
};
parameters[0].Value = patient.P_name;
parameters[1].Value = patient.Gender;
parameters[2].Value = patient.Old;
parameters[3].Value = patient.Tel;
parameters[4].Value = patient.Idcard;
parameters[5].Value = patient.D_ID;
parameters[6].Value = patient.Thumb;
return(parameters);
}
public FrmPatient(Model.Patient editPatient)
{
InitializeComponent();
InitializeAdditionalComponents();
patient = editPatient;
selectedAddress = editPatient.Address;
selectedInsurance = editPatient.InsuranceAgency;
selectedDoctor = editPatient.LocalDoctor;
tbGender.Text = editPatient.Gender;
dtpBirthday.Value = editPatient.Birthday;
tbInsuranceNr.Text = Convert.ToString(editPatient.InsuranceNr);
tbNote.Text = editPatient.Note;
InitializeAddresses();
cbInsurance.SelectedIndex = insuranceAgencies.Select(o => o.Id).ToList().IndexOf(selectedInsurance.Id);
cbDoctor.SelectedIndex = doctors.Select(o => o.Id).ToList().IndexOf(selectedDoctor.Id);
InitializeAddresses();
}
private bool CheckPatientData(Model.Patient patient, out string msg)
{
msg = "";
if (patient == null)
{
msg = "未填入用户";
return(false);
}
else if (patient.D_ID < 0)
{
msg = "医生信息出错！";
return(false);
}
else if ("".Equals(patient.Gender) || patient.Gender == null)
{
msg = "未填入性别信息";
return(false);
}
else if ("".Equals(patient.Idcard) || patient.Idcard == null)
{
msg = "未填入身份证信息";
return(false);
}
else if (patient.Old <= 0)
{
msg = "未填入年龄信息";
return(false);
}
else if ("".Equals(patient.P_name) || patient.P_name == null)
{
msg = "未填入病人姓名";
return(false);
}
else if ("".Equals(patient.Tel) || patient.Tel == null)
{
msg = "未填入联系方式";
return(false);
}
return(true);
}
public bool AddPatient(Model.Patient patient, Model.Patient_Tab patient_tab, out string msg)
{
msg = "";
bool isOK = false;
if (!CheckPatientData(patient, out msg))
{
return(isOK);
}
using (TransactionScope tsCope = new TransactionScope())
{
try
{
int id = pa.AddPatientRetId(patient);
if (id != -1)
{
patient_tab.Pid = id;
if (!CheckPatientTabData(patient_tab, out msg))
{
return(false);
}
if ((paT.AddPatientTab(patient_tab)))
{
isOK = true;
}
}
}
catch (Exception exp)
{
msg = exp.Message;
return(false);
}
tsCope.Complete();
}
msg = "插入病人信息失败！";
return(isOK);
}
public void Load()
{
Controller.PatientController PatientController = new Controller.PatientController();
Model.Examination selectedExamination = (Model.Examination)dh.lvDataBinding.SelectedItems[0];
Model.Patient selectedPatient = PatientController.GetOnePatient(selectedExamination.patient.User.Username);
lbAddressPatient.Content = selectedPatient.User.Address;
lbuUsernamePatient.Content = selectedPatient.User.Username;
lbuJMBG.Content = selectedPatient.User.Jmbg;
lbNamePatient.Content = selectedPatient.User.Name;
lbGender.Content = selectedPatient.User.Gender;
lbDateOfBirthPatient.Content = selectedPatient.User.DateOfBirth;
lbSurnamePatient.Content = selectedPatient.User.Surname;
lbNumberPatient.Content = selectedPatient.User.PhoneNumber;
List <Model.Anamnesis> anamneses = anamControl.GetAllAnamnesisPatient(selectedPatient.User.Username);
lvDataBinding.Items.Clear();
foreach (Model.Anamnesis an in anamneses)
{
lvDataBinding.Items.Add(an);
Console.WriteLine(an.DescriptionAnamnesis);
}
}
public List <Model.Patient> LoadPatient()
{
List <Model.Patient> patients = new List <Model.Patient>();
try
{
String line;
StreamReader sr = new StreamReader(FileLocation);
while ((line = sr.ReadLine()) != null)
{
Console.WriteLine(line);
string[] words = line.Split(',');
Model.Patient pa = new Model.Patient(words[0], words[1], words[2], words[3],
Convert.ToDateTime(words[4]), (Model.Gender)Enum.Parse(typeof(Model.Gender),
words[5]), long.Parse(words[6]), words[7], words[8], int.Parse(words[9]),
int.Parse(words[10]));
patients.Add(pa);
}
sr.Close();
}
catch (Exception e)
{
Console.WriteLine("Exception: " + e.Message);
}
finally
{
Console.WriteLine("Executing finally block.");
}
return(patients);
}
private void cbPatientName_SelectionChanged(object sender, System.Windows.Controls.SelectionChangedEventArgs e)
{
_selectedPatient = (cbPatientName.SelectedValue as Controllers.ComboBoxItem).Value as Model.Patient;
FillPatientFields(_selectedPatient);
}
private void cbPatients_SelectionChanged(object sender, System.Windows.Controls.SelectionChangedEventArgs e)
{
_selectedPatient = cbPatients.SelectedValue == null ? null : (cbPatients.SelectedValue as Controllers.ComboBoxItem).Value as Model.Patient;
FillPatientFields();
ShowActiveStatement();
UpdatePositiveBalances();
UpdateTotals();
}
public void FillListPatient()
{
ServicePatient.ServicePatientClient service = new ServicePatient.ServicePatientClient();
try
{
ServicePatient.Patient[] listPatient = service.GetListPatient();
this._allPatient = new List<Model.Patient>();
List<Model.Observation> listObs = new List<Model.Observation>();
foreach (ServicePatient.Patient pat in listPatient)
{
Model.Patient patient = new Model.Patient
{
Birth = pat.Birthday,
Firstname = pat.Firstname,
Name = pat.Name,
Id = pat.Id
};
if (pat.Observations != null)
{
foreach (ServicePatient.Observation obs in pat.Observations)
{
Model.Observation observation = new Model.Observation
{
Comments = obs.Comment,
Date = obs.Date,
Pic = obs.Pictures ?? new List<byte[]>().ToArray(),
Prescriptions = obs.Prescription.ToList() ?? new List<string>(),
Pressure = obs.BloodPressure,
Weight = obs.Weight
};
listObs.Add(observation);
}
patient.Obs = listObs;
}
patient.Name = FirstUpper(patient.Name);
patient.Firstname = FirstUpper(patient.Firstname);
patient.Birthday = pat.Birthday.ToString("dd/MM/yyyy");
this._allPatient.Add(patient);
}
ListPatient = new ObservableCollection<Model.Patient>(this._allPatient);
}
catch
{
MainWindow main = new MainWindow();
View.MainWindow mainwindow = (View.MainWindow)Application.Current.MainWindow;
View.Patients view = new colle_tMedecine.View.Patients();
ViewModel.PatientsViewModel vm = new colle_tMedecine.ViewModel.PatientsViewModel();
view.DataContext = vm;
main.navigate((UserControl)mainwindow.contentcontrol.Content, view);
}
}
public RequestEmailModal(Model.Patient patient)
{
this.InitializeComponent();
_patient = patient;
}
private void btnAddUpdate_Click(object sender, System.Windows.RoutedEventArgs e)
{
if (!_isUpdateDentalInitialNote)
{
_patientToUpdate = new Model.Patient()
{
FullName = txtFullName.Text.Trim(),
IsDCM = false,
IsDeleted = false,
CreatedDate = DateTime.Now
};
if (!Controllers.BusinessController.Instance.Add<Model.Patient>(_patientToUpdate))
{
MessageBox.Show("Error al crear el paciente", "Error", MessageBoxButton.OK, MessageBoxImage.Error);
return;
}
}
if (UpdateInitialDentalNote())
this.Close();
else
MessageBox.Show("Error al guardar la nota inicial dental del paciente", "Error", MessageBoxButton.OK, MessageBoxImage.Error);
}
private void btnAddUpdatePatient_Click(object sender, System.Windows.RoutedEventArgs e)
{
int expNumber;
string expNumberText = txtExpNumber.Text.Trim();
string patientFirstName = txtPatientFirstName.Text.Trim();
string patientLastName = txtPatientLastName.Text.Trim();
string homePhone = txtHomePhone.Text.Trim();
string cellPhone = txtCellPhone.Text.Trim();
string email = txtEmail.Text.Trim();
if (AreValidFields(patientFirstName, patientLastName, homePhone, cellPhone, email, expNumberText, out expNumber) == false)
{
return;
}
if (_isUpdatePatientInfo)
{
_patientToUpdate.AssignedId = expNumber;
_patientToUpdate.FirstName = patientFirstName;
_patientToUpdate.LastName = patientLastName;
_patientToUpdate.HomePhone = homePhone;
_patientToUpdate.CellPhone = cellPhone;
_patientToUpdate.Email = email;
UpdateUser(_patientToUpdate);
}
else
{
Model.Patient patientToAdd = new Model.Patient()
{
AssignedId = expNumber,
FirstName = patientFirstName,
LastName = patientLastName,
HomePhone = homePhone,
CellPhone = cellPhone,
Email = txtEmail.Text.Trim(),
HasHealthInsurance = _hasHealthInsurance,
IsDiverse = _isDiverse,
IsDentegra = _isDentegra,
CaptureDate = DateTime.Now,
IsDeleted = false,
DataCapturerId = _userLoggedIn.UserId
};
AddUser(patientToAdd);
}
}
private Model.Patient ParseData()
{
Model.Patient patient = new Model.Patient();
patient.D_ID = UserHelper.id;
patient.Pid = Convert.ToInt32(id_tb.Text);
patient.P_name = name_tb.Text;
patient.Tel = phone_tb.Text;
if (FileName != null && !"".Equals(FileName))
{
if ((pb_patient.Image != null))
pb_patient.Image.Dispose();
patient.Thumb = Common.Util.GetImageByte(FileName);
}
patient.P_name = name_tb.Text;
patient.Gender = gender_tb.Text;
return patient;
}
