public List <string> PatientLogin(string prefix, string profix)
{
string Mobile = prefix.Trim();
int Id = int.Parse(profix.Trim());
List <string> Doc = new List <string>();
try
{
PATIENT d = db.PATIENTS.Where(a => a.MobaileNumber == Mobile && a.Id == Id).FirstOrDefault();
Doc.Add(d.Id.ToString());
Doc.Add(d.FirstName);
}
catch { Doc.Add("error"); }
return(Doc);
}
//Delete Pasien
private void btnDelete_Click(object sender, RoutedEventArgs e)
{
object item = dgPasien.SelectedItem;
string temp_id = (dgPasien.SelectedCells[0].Column.GetCellContent(item) as TextBlock).Text;
int id = Convert.ToInt32(temp_id);
PATIENT pasien = SearchByIdPasien(id);
et.Entry(pasien).State = System.Data.Entity.EntityState.Deleted;
et.SaveChanges();
clearTextPasien();
this.viewPasien(dgPasien);
MessageBox.Show("Data Pasien Berhasil di hapus !", "Informasi", MessageBoxButton.OK, MessageBoxImage.Information);
}
private void LoadForm(int id)
{
ResetForm();
listSurveyName.Enabled = false;
SURVEYS survey = ServiceInterfaceManager.SURVEYS_GET(HttpContext.Current.User.Identity.Name, UserSession.CurrentRegistryId, id);
if (survey != null)
{
hideSurveyId.Value = survey.SURVEYS_ID.ToString();
//TODO: Patient ID should not be null or 0 here, but may need to add logic
//here at some point in case it is.
if (survey.PATIENT_ID != null && survey.PATIENT_ID > 0)
{
PATIENT p = ServiceInterfaceManager.PATIENT_GET(HttpContext.Current.User.Identity.Name, UserSession.CurrentRegistryId, survey.PATIENT_ID.Value);
if (p != null)
{
hidePatientId.Value = p.PATIENT_ID.ToString();
if (!string.IsNullOrEmpty(p.LAST_NAME) && !string.IsNullOrEmpty(p.FIRST_NAME))
{
txtPatientName.Text = p.LAST_NAME + ", " + p.FIRST_NAME;
}
else if (!string.IsNullOrEmpty(p.LAST_NAME))
{
txtPatientName.Text = p.LAST_NAME;
}
else if (!string.IsNullOrEmpty(p.FIRST_NAME))
{
txtPatientName.Text = p.FIRST_NAME;
}
}
}
foreach (ListItem li in listSurveyName.Items)
{
if (li.Value == survey.STD_SURVEY_TYPE_ID.ToString())
{
li.Selected = true;
break;
}
}
txtSurveyDate.Text = survey.SURVEY_DATE.ToString("MM/dd/yyyy");
}
}
private void Button_Click_Ok(object sender, RoutedEventArgs e)
{
if (TextBoxFirstName.Text != "" && TextBoxLastName.Text != "" && TextBoxAddress.Text != "" && cldSample.SelectedDate != null)
{
string gender = "";
if (FemaleCheckBox.IsChecked == true)
{
gender = "F";
}
else if (MaleCheckBox.IsChecked == true)
{
gender = "M";
}
else
{
MessageBox.Show("Select your gender", "Exception", MessageBoxButton.OK, MessageBoxImage.Warning);
return;
}
if (AddEditPatientLabel.Text == "Create Patient")
{
patientToEdit = new PATIENT
{
NAME = TextBoxFirstName.Text,
SURNAME = TextBoxLastName.Text,
ADDRESS = TextBoxAddress.Text,
GENDER = gender,
DATEOFBIRTH = cldSample.SelectedDate.Value
};
main_.AddFinished(patientToEdit);
this.Close();
}
else if (AddEditPatientLabel.Text == "Edit Patient")
{
patientToEdit.NAME = TextBoxFirstName.Text;
patientToEdit.SURNAME = TextBoxLastName.Text;
patientToEdit.ADDRESS = TextBoxAddress.Text;
patientToEdit.GENDER = gender;
patientToEdit.DATEOFBIRTH = cldSample.DisplayDate;
main_.EditFinished(patientToEdit);
this.Close();
}
}
else
{
MessageBox.Show("Error. Choose all the properties for the patient");
}
}
public ActionResult Edit()
{
int userid = Global.CurrentUserID;
if (userid < 0)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
PATIENT p = db.PATIENT.Find(userid);
if (p == null)
{
return(HttpNotFound());
}
return(View(p));
}
public void updatePatient(PATIENT toEdit, PATIENT newpatient)
{
PATIENT query = (from patient in context.PATIENTs
where patient.IDP == toEdit.IDP
select patient).First();
query.NAME = newpatient.NAME;
query.SURNAME = newpatient.SURNAME;
query.DATEOFBIRTH = newpatient.DATEOFBIRTH;
query.ADDRESS = newpatient.ADDRESS;
query.GENDER = newpatient.GENDER;
context.SaveChanges();
}
private void ResetForm()
{
hideSurveyId.Value = string.Empty;
listSurveyName.ClearSelection();
listSurveyName.Items.Clear();
listSurveyName.Enabled = true;
List <STD_SURVEY_TYPE> surveys = ServiceInterfaceManager.STD_SURVEY_TYPE_GET_ALL_BY_REGISTRY(HttpContext.Current.User.Identity.Name, UserSession.CurrentRegistryId);
listSurveyName.Items.Add(new ListItem("", "0"));
listSurveyName.AppendDataBoundItems = true;
if (surveys != null)
{
listSurveyName.DataSource = surveys;
listSurveyName.DataBind();
}
if (UserSession.CurrentPatientId > 0)
{
PATIENT p = ServiceInterfaceManager.PATIENT_GET(HttpContext.Current.User.Identity.Name, UserSession.CurrentRegistryId, UserSession.CurrentPatientId);
if (p != null)
{
hidePatientId.Value = p.PATIENT_ID.ToString();
if (!string.IsNullOrEmpty(p.LAST_NAME) && !string.IsNullOrEmpty(p.FIRST_NAME))
{
txtPatientName.Text = p.LAST_NAME + ", " + p.FIRST_NAME;
}
else if (!string.IsNullOrEmpty(p.LAST_NAME))
{
txtPatientName.Text = p.LAST_NAME;
}
else if (!string.IsNullOrEmpty(p.FIRST_NAME))
{
txtPatientName.Text = p.FIRST_NAME;
}
}
}
else
{
txtPatientName.Text = string.Empty;
}
txtSurveyDate.Text = string.Empty;
}
//[ValidateAntiForgeryToken]
public ActionResult Edit(
[Bind(Include = "PATIENT_ID,INSDATE,PATIENT_NM,AGE,GENDER,TEL,TEL2,EMAIL,ADDRESS,ALLERGIC_HISTORY,GENETIC_HISTORY,CAPITAL_OPERATION,EMERGENCY_NAME,EMERGENCY_TEL,COMMENT")]
PATIENT info)
{
if (string.IsNullOrEmpty(info.PATIENT_NM))
{
ModelState.AddModelError("PATIENT_NM", "姓名不能为空");
return(View(info));
}
if (info.AGE == null)
{
ModelState.AddModelError("AGE", "年龄不能为空");
return(View(info));
}
if (string.IsNullOrEmpty(info.TEL) || string.IsNullOrEmpty(info.TEL2))
{
ModelState.AddModelError("TEL", "联系方式不能为空");
return(View(info));
}
var p = new PATIENT()
{
PATIENT_ID = info.PATIENT_ID,
PATIENT_NM = info.PATIENT_NM,
AGE = info.AGE,
GENDER = info.GENDER,
TEL = info.TEL,
TEL2 = info.TEL2,
EMAIL = info.EMAIL,
ADDRESS = info.ADDRESS,
ALLERGIC_HISTORY = info.ALLERGIC_HISTORY,
GENETIC_HISTORY = info.GENETIC_HISTORY,
CAPITAL_OPERATION = info.CAPITAL_OPERATION,
EMERGENCY_NAME = info.EMERGENCY_NAME,
EMERGENCY_TEL = info.EMERGENCY_TEL,
COMMENT = info.COMMENT,
INSDATE = DateTime.Now
};
if (ModelState.IsValid)
{
db.Entry(p).State = EntityState.Modified;
db.Entry(p).Property(m => m.INSDATE).IsModified = false;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(p));
}
//get a patient by id
public Patient getPatient(string id)
{
Patient p = new Patient();
PATIENT selectPatient = LinqToSQL.selectPatientById(id);
p.userName = selectPatient.user_name;
p.weight = selectPatient.weight;
//listpa.ForEach(c => {
// if (c.id == id)
// {
// p = c;
// }
//});
return p;
}
public JObject getPatientInfo(string email, string id)
{
PATIENT tmp = (PATIENT)dao.getOnlyPatient(email)[0];
PATIENT patient = tmp;
DateTime birthday = patient.BIRTHDAY;
string newtime = birthday.Year.ToString() + "年" + birthday.Month.ToString() + "月" + birthday.Day.ToString()
+ "日";
JObject result = new JObject();
result.Add(new JProperty("id", id));
result.Add(new JProperty("name", patient.NAME));
result.Add(new JProperty("explanation", patient.EXPLANATION));
result.Add(new JProperty("patid", patient.ID));
result.Add(new JProperty("age", ((int)patient.AGE).ToString()));
result.Add(new JProperty("email", patient.E_MAIL));
result.Add(new JProperty("birthday", newtime));
return(result);
}
public JsonResult PatientAjaxRegistration1(string Mobile, string FirstName, string LastName, string FatherName)
{
PATIENT pat = new PATIENT()
{
FirstName = FirstName,
LastName = LastName,
FatherName = FatherName,
MobaileNumber = Mobile
};
try
{
db.PATIENTS.Add(pat);
db.SaveChanges();
int PatId = db.PATIENTS.Max(a => a.Id);
return(Json(PatId, JsonRequestBehavior.AllowGet));
}
catch { return(Json("فشل التسجيل !!", JsonRequestBehavior.AllowGet)); }
}
private void LoadPatient(int id)
{
PATIENT patient = ServiceInterfaceManager.PATIENT_GET(HttpContext.Current.User.Identity.Name, UserSession.CurrentRegistryId, id);
if (patient != null)
{
hidePatientId.Value = patient.PATIENT_ID.ToString();
if (!string.IsNullOrEmpty(patient.LAST_NAME) && !string.IsNullOrEmpty(patient.FIRST_NAME))
{
txtPatient.Text = patient.LAST_NAME + ", " + patient.FIRST_NAME;
}
else if (!string.IsNullOrEmpty(patient.LAST_NAME))
{
txtPatient.Text = patient.LAST_NAME;
}
else if (!string.IsNullOrEmpty(patient.FIRST_NAME))
{
txtPatient.Text = patient.FIRST_NAME;
}
}
}
//Update Pasien
private void btnEdit_Click(object sender, RoutedEventArgs e)
{
object item = dgPasien.SelectedItem;
string temp_id = (dgPasien.SelectedCells[0].Column.GetCellContent(item) as TextBlock).Text;
int id = Convert.ToInt32(temp_id);
PATIENT pasien = SearchByIdPasien(id);
pasien.NAME = txtNamaP.Text;
pasien.ADDRESS = txtAlamatP.Text;
pasien.BIRTH = Convert.ToDateTime(dtTanggalLahirP.Text);
pasien.AGE = Convert.ToInt32(txtUmurP.Text);
pasien.GENDER = getJenisKelaminPasien();
et.Entry(pasien).State = System.Data.Entity.EntityState.Modified;
et.SaveChanges();
clearTextPasien();
this.viewPasien(dgPasien);
MessageBox.Show("Update Data Pasien Berhasil !", "Informasi", MessageBoxButton.OK, MessageBoxImage.Information);
}
//create a patient
public Boolean CreatPatient(Patient patient)
{
var result = true;
if (login.Exists(t => t.userName == patient.userName))
{
result = false;
}
else
{
//listpa.Add(patient);
PATIENT newPatient = new PATIENT();
newPatient.id = patient.id;
newPatient.user_name = patient.userName;
newPatient.native_name = patient.nativeName;
newPatient.password = patient.password";
newPatient.gender = patient.gender;
LinqToSQL.insert2patient(newPatient)
login.Add(new LoginRequest { userName = patient.userName, password = patient.password });
}
return result;
}
public static bool updatePatientById(string str_id, PATIENT newPatient)
{
bool result = true;
string connectString = System.Configuration.ConfigurationManager.ConnectionStrings["LinqToSQLDBConnectionString"].ToString();
ECMSDataContext db = new ECMSDataContext(connectString);
try
{
//Get Patient for update
PATIENT oldPatient = db.PATIENT.FirstOrDefault(e => e.id.Equals(str_id));
oldPatient = newPatient;
//Save changes to Database.
db.SubmitChanges();
}
catch
{
result = false;
}
return(result);
}
public static bool deletePatient(string str_id)
{
bool result = true;
string connectString = System.Configuration.ConfigurationManager.ConnectionStrings["LinqToSQLDBConnectionString"].ToString();
ECMSDataContext db = new ECMSDataContext(connectString);
try {
//Get PATIENT to Delete
PATIENT deletePATIENT = db.PATIENT.FirstOrDefault(e => e.id.Equals(str_id));
//Delete PATIENT
db.PATIENT.DeleteOnSubmit(deletePATIENT);
//Save changes to Database.
db.SubmitChanges();
}
catch
{
result = false;
}
return(result);
}
public void LoadForm(int id)
{
ResetForm();
PATIENT patient = ServiceInterfaceManager.PATIENT_GET_COMPLETE(HttpContext.Current.User.Identity.Name, UserSession.CurrentRegistryId, id);
if (patient != null)
{
lblLastName.Text = patient.LAST_NAME;
lblFirstName.Text = patient.FIRST_NAME;
if (patient.BIRTH_DATE != null)
{
lblDateOfBirth.Text = patient.BIRTH_DATE.Value.ToString("MM/dd/yyyy");
}
if (patient.OEFOIF_IND != null)
{
lblOefOif.Text = (patient.OEFOIF_IND.Value) ? "Yes" : "No";
}
if (patient.SPATIENT != null)
{
lblIcn.Text = patient.SPATIENT.PatientICN;
lblLastFour.Text = patient.SPATIENT.PatientLastFour;
if (patient.SPATIENT.LastServiceSeparationDate != null)
{
lblServiceSeparation.Text = patient.SPATIENT.LastServiceSeparationDate.Value.ToString("MM/dd/yyyy");
}
}
}
else
{
linkViewDetails.Visible = false;
}
}
public PATIENT ParseReaderCustom(DataRow row)
{
PATIENT objReturn = new PATIENT
{
BIRTH_DATE = (DateTime?)GetNullableObject(row.Field <object>("PATIENT_BIRTH_DATE")),
CELL_PHONE = (string)GetNullableObject(row.Field <object>("PATIENT_CELL_PHONE")),
CREATED = (DateTime?)GetNullableObject(row.Field <object>("PATIENT_CREATED")),
CREATEDBY = (string)GetNullableObject(row.Field <object>("PATIENT_CREATEDBY")),
DEATH_DATE = (DateTime?)GetNullableObject(row.Field <object>("PATIENT_DEATH_DATE")),
EMAIL_ADDRESS = (string)GetNullableObject(row.Field <object>("PATIENT_EMAIL_ADDRESS")),
FIRST_NAME = (string)GetNullableObject(row.Field <object>("PATIENT_FIRST_NAME")),
LAST_NAME = (string)GetNullableObject(row.Field <object>("PATIENT_LAST_NAME")),
MIDDLE_NAME = (string)GetNullableObject(row.Field <object>("PATIENT_MIDDLE_NAME")),
OEFOIF_IND = (bool?)GetNullableObject(row.Field <object>("PATIENT_OEFOIF_IND")),
PATIENT_ID = (Int32)GetNullableObject(row.Field <object>("PATIENT_PATIENT_ID")),
PATIENTSID = (Int32?)GetNullableObject(row.Field <object>("PATIENT_PATIENTSID")),
PERFERRED_ADDRESS_TYPE = (string)GetNullableObject(row.Field <object>("PATIENT_PERFERRED_ADDRESS_TYPE")),
UPDATED = (DateTime?)GetNullableObject(row.Field <object>("PATIENT_UPDATED")),
UPDATEDBY = (string)GetNullableObject(row.Field <object>("PATIENT_UPDATEDBY")),
PatientICN = (string)GetNullableObject(row.Field <object>("PATIENT_PatientICN"))
};
return(objReturn);
}
public void startListening()
{
//socket.Emit("java_database", new object[] { "record" });
Console.WriteLine("login listening");
socket.On("login_apply", (data) =>
{
try
{
/*Console.WriteLine("received login");
* socket.Emit("login_reply", new Object[] { "success"});*/
JObject jobe = (JObject)data;
string id = (string)jobe.GetValue("id");
string email = (string)jobe.GetValue("email");
string password = (string)jobe.GetValue("password");
string random = (string)jobe.GetValue("random");
string type = (string)jobe.GetValue("type");
PATIENT user = hospitalService.Login(email, password, random);
JObject result = new JObject();
if (user == null)
{
result.Add(new JProperty("id", id));
result.Add(new JProperty("userId", ""));
result.Add(new JProperty("result", "failed"));
socket.Emit("login_reply", result);
}
else
{
result.Add(new JProperty("id", id));
result.Add(new JProperty("userId", ((int)user.ID).ToString()));
result.Add(new JProperty("result", "success"));
result.Add(new JProperty("lastLogintime", user.LASTLOGIN_TIME.ToString()));
result.Add(new JProperty("createTime", user.CREATION_TIME.ToString()));
result.Add(new JProperty("type", type));
socket.Emit("login_reply", result);
hospitalService.updLastLogin(user);
}
}
catch (Exception e)
{
Console.WriteLine("login_apply: \n");
Console.WriteLine(e);
}
});
socket.On("web_login_doctor_apply", (data) =>
{
try
{
/*Console.WriteLine("received login");
* socket.Emit("login_reply", new Object[] { "success"});*/
JObject jobe = (JObject)data;
string id = (string)jobe.GetValue("id");
string email = (string)jobe.GetValue("email");
string password = (string)jobe.GetValue("password");
string random = (string)jobe.GetValue("random");
string type = (string)jobe.GetValue("type");
DOCTOR user = hospitalService.DoctorLogin(email, password, random);
JObject result = new JObject();
if (user == null)
{
result.Add(new JProperty("id", id));
result.Add(new JProperty("result", "failed"));
socket.Emit("web_login_doctor_reply", result);
}
else
{
result.Add(new JProperty("id", id));
result.Add(new JProperty("userId", ((int)user.ID).ToString()));
result.Add(new JProperty("result", "success"));
result.Add(new JProperty("lastLogintime", user.LASTLOGIN_TIME.ToString()));
result.Add(new JProperty("createTime", user.CREATION_TIME.ToString()));
result.Add(new JProperty("type", type));
socket.Emit("web_login_doctor_reply", result);
hospitalService.updDoctorLastLogin(user);
}
}
catch (Exception e)
{
Console.WriteLine("web_login_doctor_apply: \n");
Console.WriteLine(e);
}
});
socket.On(" web_login_nurse_apply", (data) =>
{
try
{
/*Console.WriteLine("received login");
* socket.Emit("login_reply", new Object[] { "success"});*/
JObject jobe = (JObject)data;
string id = (string)jobe.GetValue("id");
string email = (string)jobe.GetValue("email");
string password = (string)jobe.GetValue("password");
string random = (string)jobe.GetValue("random");
string type = (string)jobe.GetValue("type");
NURSE user = hospitalService.NurseLogin(email, password, random);
JObject result = new JObject();
if (user == null)
{
result.Add(new JProperty("id", id));
result.Add(new JProperty("result", "failed"));
socket.Emit("web_login_nurse_reply", result);
}
else
{
result.Add(new JProperty("id", id));
result.Add(new JProperty("userId", ((int)user.ID).ToString()));
result.Add(new JProperty("result", "success"));
result.Add(new JProperty("lastLogintime", user.LASTLOGIN_TIME.ToString()));
result.Add(new JProperty("createTime", user.CREATION_TIME.ToString()));
result.Add(new JProperty("type", type));
socket.Emit("web_login_nurse_reply", result);
hospitalService.updNurserLastLogin(user);
}
}
catch (Exception e)
{
Console.WriteLine("web_login_nurse_apply: \n");
Console.WriteLine(e);
}
});
//data 已改变
socket.On("signup_apply", (data) =>
{
try
{
JObject jobe = (JObject)data;
string id = (string)jobe.GetValue("id");
string name = (string)jobe.GetValue("name");
string password = (string)jobe.GetValue("password");
string email = (string)jobe.GetValue("email");
string year = (string)jobe.GetValue("year");
string month = (string)jobe.GetValue("month");
string day = (string)jobe.GetValue("day");
string identity = (string)jobe.GetValue("identity");
string gender = (string)jobe.GetValue("gender");
var result = hospitalService.Register(name, password, email, year, month, day, identity, gender);
// todo email may has been used
JObject jobj = new JObject();
jobj.Add(new JProperty("id", id));
jobj.Add(new JProperty("result", result ? "success" : "failed"));
socket.Emit("signup_reply", jobj);
}
catch (Exception e)
{
Console.WriteLine("signup_apply: \n");
Console.WriteLine(e);
}
});
socket.On("web_get_department_apply", (data) =>
{
try
{
JObject jobe = (JObject)data;
string id = (string)jobe.GetValue("id");
socket.Emit("web_get_department_reply", hospitalService.getAllDepartments(id));
}
catch (Exception e)
{
Console.WriteLine("web_get_department_apply: \n");
Console.WriteLine(e);
}
});
socket.On("web_get_expert_apply", (data) =>
{
try
{
JObject jobe = (JObject)data;
string id = (string)jobe.GetValue("id");
ArrayList professors = hospitalService.findProfessor();
JArray res = new JArray();
for (int i = 0; i < professors.Count; i++)
{
JObject temp = new JObject();
temp.Add(new JProperty("name", ((DOCTOR)professors[i]).NAME));
temp.Add(new JProperty("position", ((DOCTOR)professors[i]).POSITION));
temp.Add(new JProperty("email", ((DOCTOR)professors[i]).E_MAIL));
temp.Add(new JProperty("department", ((DOCTOR)professors[i]).DEPT_NAME));
res.Add(temp);
}
JObject result = new JObject();
result.Add(new JProperty("id", id));
result.Add(new JProperty("result", res));
socket.Emit("web_get_expert_reply", result);
}
catch (Exception e)
{
Console.WriteLine("web_get_expert_apply: \n");
Console.WriteLine(e);
}
});
/*socket.On("web_add_expert_appoint_apply", (data) =>
* {
* try
* {
* JObject jobe = (JObject)data;
* string id = (string)jobe.GetValue("id");
* string email = (string)jobe.GetValue("email");
* string expertemail = (string)jobe.GetValue("expert");
* bool res = hospitalService.bookCertainProfessor(email, expertemail);
* JObject result = new JObject();
* result.Add(new JProperty("id", id));
*
* if (res)
* {
* result.Add(new JProperty("res", "success"));
* socket.Emit("web_add_expert_appoint_reply", result);
* }
* else
* {
* result.Add(new JProperty("res", "fail"));
* socket.Emit("web_add_expert_appoint_reply", result);
* }
* }
* catch (Exception e)
* {
* Console.WriteLine("web_add_expert_appoint_apply: \n");
* Console.WriteLine(e);
* }
*
* });*/
socket.On("web_add_booking_apply", (data) =>
{
try
{
JObject jobe = (JObject)data;
string id = (string)jobe.GetValue("id");
string email = (string)jobe.GetValue("email");
bool res = hospitalService.commonbook(email);
JObject result = new JObject();
result.Add(new JProperty("id", id));
if (res)
{
result.Add(new JProperty("res", "success"));
socket.Emit("web_add_booking_reply", result);
}
else
{
result.Add(new JProperty("book_result", "fail"));
socket.Emit("web_add_booking_reply", result);
}
}
catch (Exception e)
{
Console.WriteLine("web_add_booking_apply: \n");
Console.WriteLine(e);
}
});
socket.On("show_treatementRecord_apply", (data) =>
{
try
{
JObject jobe = (JObject)data;
string id = (string)jobe.GetValue("id");
int patientID = (int)jobe.GetValue("pID");
var records = hospitalService.getMedicalRecordOfPatient(patientID);
JObject result = new JObject();
result.Add(new JProperty("id", id));
JArray res = new JArray();
for (int i = 0; i < records.Count; i++)
{
JObject temp = new JObject();
temp.Add(new JProperty("TIME", ((MEDICAL_RECORD)records[i]).TIME));
temp.Add(new JProperty("DISEASE", ((MEDICAL_RECORD)records[i]).DISEASE));
temp.Add(new JProperty("DESCRIPTION", ((MEDICAL_RECORD)records[i]).DESCRIPTION));
temp.Add(new JProperty("DIAGNOSIS", ((MEDICAL_RECORD)records[i]).DIAGNOSIS));
temp.Add(new JProperty("STATE", ((MEDICAL_RECORD)records[i]).TREAT_STATE));
res.Add(temp);
}
result.Add(new JProperty("medical_record", res));
socket.Emit("show_treatementRecord_reply", result);
}
catch (Exception e)
{
Console.WriteLine("show_treatementRecord_apply: \n");
Console.WriteLine(e);
}
});
socket.On("web_pick_medicine_apply", (data) =>
{
try
{
JObject jobe = (JObject)data;
string id = (string)jobe.GetValue("id");
string email = (string)jobe.GetValue("patient");
string medicine = (string)jobe.GetValue("medicine");
int number = (int)jobe.GetValue("count");
JObject res = new JObject();
res.Add(new JProperty("id", id));
//if (hospitalService.getMedicineByCount(medicine, number))
//{
socket.Emit("web_pick_medicine_reply", res);
socket.Emit("java_drug_alert_reply", jobe);
//}
//else
//{
// Console.WriteLine("fail");
//}
//查找病人和相关信息返回给JAVA
}
catch (Exception e)
{
Console.WriteLine("web_pick_medicine_apply: \n");
Console.WriteLine(e);
}
});
socket.On("web_get_medicine_list_apply", (data) =>
{
try
{
JObject jobe = (JObject)data;
string id = (string)jobe.GetValue("id");
string email = (string)jobe.GetValue("patient");
socket.Emit("web_get_medicine_list_reply", hospitalService.getDrugByPatient(email, id));
}
catch (Exception e)
{
Console.WriteLine("web_get_medicine_list_apply: \n");
Console.WriteLine(e);
}
});
socket.On("web_get_exam_apply", (data) =>
{
try
{
JObject jobe = (JObject)data;
string id = (string)jobe.GetValue("id");
string email = (string)jobe.GetValue("patient");
JObject result = new JObject();
result.Add(new JProperty("id", id));
result.Add(new JProperty("result", hospitalService.getExam(email)));
socket.Emit("web_get_exam_reply", result);
}
catch (Exception e)
{
Console.WriteLine("web_get_exam_apply: \n");
Console.WriteLine(e);
}
});
socket.On("web_get_fee_apply", (data) =>
{
try
{
JObject jobe = (JObject)data;
string id = (string)jobe.GetValue("id");
string email = (string)jobe.GetValue("email");
socket.Emit("web_get_fee_reply", hospitalService.getFee(email, id));
}
catch (Exception e)
{
Console.WriteLine("web_get_fee_apply: \n");
Console.WriteLine(e);
}
});
socket.On("web_get_patient_apply", (data) =>
{
try
{
JObject jobe = (JObject)data;
string email = (string)jobe.GetValue("email");
string id = (string)jobe.GetValue("id");
socket.Emit("web_get_patient_reply", hospitalService.getPatientInfo(email, id));
}
catch (Exception e)
{
Console.WriteLine("web_get_patient_apply: \n");
Console.WriteLine(e);
}
});
socket.On("web_get_all_patient_apply", (data) =>
{
try
{
JObject jobe = (JObject)data;
string id = (string)jobe.GetValue("id");
socket.Emit("web_get_all_patient_reply", hospitalService.getAllPatient(id));
}
catch (Exception e)
{
Console.WriteLine("web_get_all_patient_apply: \n");
Console.WriteLine(e);
}
});
/*socket.On("web_change_right_apply", (data) =>
* {
* try
* {
* JObject jobe = (JObject)data;
* string id = (string)jobe.GetValue("id");
* string email = (string)jobe.GetValue("email");
* string position = (string)jobe.GetValue("position");
* string department = (string)jobe.GetValue("department");
* socket.Emit("web_change_right_reply", hospitalService.changePatientToDoc(email, position, department, id));
* }catch(Exception e)
* {
* Console.WriteLine("web_change_right_apply: \n");
* Console.WriteLine(e);
* }
* });*/
socket.On("web_get_all_special_apply", (data) =>
{
try
{
JObject jobe = (JObject)data;
string id = (string)jobe.GetValue("id");
socket.Emit("web_get_all_special_reply", hospitalService.getAllSpecial(id));
}
catch (Exception e)
{
Console.WriteLine("web_get_all_special_apply: \n");
Console.WriteLine(e);
}
});
socket.On("web_add_doctor_apply", (data) =>
{
try
{
JObject jobe = (JObject)data;
string id = (string)jobe.GetValue("id");
string name = (string)jobe.GetValue("name");
string password = (string)jobe.GetValue("password");
string email = (string)jobe.GetValue("email");
string dept_name = (string)jobe.GetValue("dept_name");
string position = (string)jobe.GetValue("position");
string age = (string)jobe.GetValue("age");
string gender = (string)jobe.GetValue("gender");
var result = hospitalService.DoctorRegister(name, password, email, dept_name, position, gender, age);
// todo email may has been used
JObject jobj = new JObject();
jobj.Add(new JProperty("id", id));
jobj.Add(new JProperty("result", result ? "SUCCESS" : "FAIL"));
socket.Emit("web_add_doctor_reply", jobj);
}
catch (Exception e)
{
Console.WriteLine("web_add_doctor_apply: \n");
Console.WriteLine(e);
}
});
socket.On("web_add_nurse_apply", (data) =>
{
try
{
JObject jobe = (JObject)data;
string id = (string)jobe.GetValue("id");
string name = (string)jobe.GetValue("name");
string password = (string)jobe.GetValue("password");
string email = (string)jobe.GetValue("email");
string dept_name = (string)jobe.GetValue("dept_name");
string age = (string)jobe.GetValue("age");
string gender = (string)jobe.GetValue("gender");
var result = hospitalService.NurserRegister(name, password, email, dept_name, gender, age);
// todo email may has been used
JObject jobj = new JObject();
jobj.Add(new JProperty("id", id));
jobj.Add(new JProperty("result", result ? "SUCCESS" : "FAIL"));
socket.Emit("web_add_nurse_reply", jobj);
}
catch (Exception e)
{
Console.WriteLine("web_add_nurse_apply: \n");
Console.WriteLine(e);
}
});
socket.On("web_rem_doctor_apply", (data) =>
{
try
{
JObject jobe = (JObject)data;
string id = (string)jobe.GetValue("id");
string email = (string)jobe.GetValue("doctor");
JObject jobj = new JObject();
var result = hospitalService.RemoveDoctor(email);
jobj.Add(new JProperty("id", id));
jobj.Add(new JProperty("result", result ? "SUCCESS" : "FAIL"));
socket.Emit("web_rem_doctor_reply", jobj);
}
catch (Exception e)
{
Console.WriteLine("web_rem_doctor_apply: \n");
Console.WriteLine(e);
}
});
socket.On("web_rem_nurse_apply", (data) =>
{
try
{
JObject jobe = (JObject)data;
string id = (string)jobe.GetValue("id");
string email = (string)jobe.GetValue("nurse");
JObject jobj = new JObject();
var result = hospitalService.RemoveNurse(email);
jobj.Add(new JProperty("id", id));
jobj.Add(new JProperty("result", result ? "SUCCESS" : "FAIL"));
socket.Emit("web_rem_nurse_reply", jobj);
}
catch (Exception e)
{
Console.WriteLine("web_rem_nurse_apply: \n");
Console.WriteLine(e);
}
});
socket.On("web_rem_doctor_apply", (data) =>
{
try
{
JObject jobe = (JObject)data;
string id = (string)jobe.GetValue("id");
string email = (string)jobe.GetValue("doctor");
string password = (string)jobe.GetValue("password");
JObject jobj = new JObject();
var result = hospitalService.changeDoctorPW(email, password);
jobj.Add(new JProperty("id", id));
jobj.Add(new JProperty("result", result ? "SUCCESS" : "FAIL"));
socket.Emit("web_rem_doctor_reply", jobj);
}
catch (Exception e)
{
Console.WriteLine("web_rem_doctor_apply: \n");
Console.WriteLine(e);
}
});
socket.On("web_rem_nurser_apply", (data) =>
{
try
{
JObject jobe = (JObject)data;
string id = (string)jobe.GetValue("id");
string email = (string)jobe.GetValue("nurse");
string password = (string)jobe.GetValue("password");
JObject jobj = new JObject();
var result = hospitalService.changeNursePW(email, password);
jobj.Add(new JProperty("id", id));
jobj.Add(new JProperty("result", result ? "SUCCESS" : "FAIL"));
socket.Emit("web_rem_nurser_reply", jobj);
}
catch (Exception e)
{
Console.WriteLine("web_rem_nurser_apply: \n");
Console.WriteLine(e);
}
});
}
public static bool PRPA_IN201305UV02(string CURRENT_USER, Int32 CURRENT_REGISTRY_ID, Int32 CURRENT_PATIENT_ID)
{
bool objReturn = false;
MviDB objDB = new MviDB();
PATIENT p = PATIENTManager.GetItemComplete(CURRENT_USER, CURRENT_REGISTRY_ID, CURRENT_PATIENT_ID);
if (p != null)
{
if (p.SPATIENT == null)
{
p.SPATIENT = new SPATIENT()
{
PatientICN = p.PatientICN
};
}
PRPA_IN201306UV02 prpaItem = objDB.PRPA_IN201305UV02(CURRENT_USER, CURRENT_REGISTRY_ID, p);
if (prpaItem != null)
{
if (prpaItem.controlActProcess != null && prpaItem.controlActProcess.queryAck != null && prpaItem.controlActProcess.queryAck.queryResponseCode != null && !string.IsNullOrEmpty(prpaItem.controlActProcess.queryAck.queryResponseCode.code))
{
switch (prpaItem.controlActProcess.queryAck.queryResponseCode.code.Trim().ToUpper())
{
case "OK":
int resultCurrentQuantity = 0;
int.TryParse(prpaItem.controlActProcess.queryAck.resultCurrentQuantity.value, out resultCurrentQuantity);
if (resultCurrentQuantity == 1) //TODO: may need to handle multiple results at some point???...display list to user or something
{
if (prpaItem.controlActProcess.subject != null &&
prpaItem.controlActProcess.subject[0].registrationEvent != null &&
prpaItem.controlActProcess.subject[0].registrationEvent.subject1 != null &&
prpaItem.controlActProcess.subject[0].registrationEvent.subject1.patient != null)
{
//TODO: ID's
if (prpaItem.controlActProcess.subject[0].registrationEvent.subject1.patient.Item != null)
{
if (prpaItem.controlActProcess.subject[0].registrationEvent.subject1.patient.Item is PRPA_MT201310UV02Person)
{
PRPA_MT201310UV02Person person = (PRPA_MT201310UV02Person)prpaItem.controlActProcess.subject[0].registrationEvent.subject1.patient.Item;
//NAMES (First and Last)
if (person.name != null && person.name.Length > 0 && person.name[0].Items != null && person.name[0].Items.Length > 0)
{
int givenCount = 0;
for (int i = 0; i < person.name[0].Items.Length; i++)
{
if (person.name[0].ItemsElementName.Length > i)
{
switch (person.name[0].ItemsElementName[i])
{
case ItemsChoiceType8.given:
if (givenCount == 0)
{
p.FIRST_NAME = p.SPATIENT.PatientFirstName = person.name[0].Items[i];
}
else if (givenCount > 0)
{
p.MIDDLE_NAME = person.name[0].Items[i];
}
givenCount++;
break;
case ItemsChoiceType8.family:
p.LAST_NAME = p.SPATIENT.PatientLastName = person.name[0].Items[i];
break;
default:
break;
}
}
}
}
//PHONES
if (person.telecom != null && person.telecom.Length > 0)
{
foreach (TEL tel in person.telecom)
{
if (!string.IsNullOrEmpty(tel.value) && tel.use != null && tel.use.Length > 0)
{
switch (tel.use[0])
{
case "HP":
p.SPATIENT.PhoneResidence = RemoveChars(tel.value);
break;
default:
break;
}
}
}
}
//GENDER
if (person.administrativeGenderCode != null && !string.IsNullOrEmpty(person.administrativeGenderCode.code))
{
p.SPATIENT.Gender = person.administrativeGenderCode.code.Trim().ToUpper().Substring(0, 1);
}
//DOB
if (person.birthTime != null && !string.IsNullOrEmpty(person.birthTime.value))
{
int y = 0;
int m = 0;
int d = 0;
if (person.birthTime.value.Length >= 4)
{
int.TryParse(person.birthTime.value.Substring(0, 4), out y);
}
if (person.birthTime.value.Length >= 6)
{
int.TryParse(person.birthTime.value.Substring(4, 2), out m);
}
if (person.birthTime.value.Length >= 8)
{
int.TryParse(person.birthTime.value.Substring(6, 2), out d);
}
DateTime?dob = null;
if (p.SPATIENT.DateOfBirth != null)
{
dob = p.SPATIENT.DateOfBirth;
}
else if (p.BIRTH_DATE != null)
{
dob = p.BIRTH_DATE;
}
if (y == 0 && dob != null)
{
y = dob.Value.Year;
}
if (m == 0 && dob != null)
{
m = dob.Value.Month;
}
if (d == 0 && dob != null)
{
d = dob.Value.Day;
}
if (y > 0 && m > 0 && d > 0 && dob != null)
{
p.BIRTH_DATE = p.SPATIENT.DateOfBirth = new DateTime(y, m, d, dob.Value.Hour, dob.Value.Minute, dob.Value.Second);
}
else if (y > 0 && m > 0 && d > 0)
{
p.BIRTH_DATE = p.SPATIENT.DateOfBirth = new DateTime(y, m, d);
}
}
//ADDRESSES
if (person.addr != null && person.addr.Length > 0)
{
foreach (AD a in person.addr)
{
if (a.use != null && a.use.Length > 0)
{
if (a.use[0] == "PHYS") //TODO: CRSe DB only stores one address, should we check for other MVI address types here???
{
if (a.Items != null && a.Items.Length > 0)
{
for (int i = 0; i < a.Items.Length; i++)
{
switch (a.ItemsElementName[i])
{
case ItemsChoiceType7.streetAddressLine:
p.SPATIENT.StreetAddress1 = a.Items[i].ToString();
break;
case ItemsChoiceType7.city:
p.SPATIENT.City = a.Items[i].ToString();
break;
case ItemsChoiceType7.state:
p.SPATIENT.State = a.Items[i].ToString();
break;
case ItemsChoiceType7.postalCode:
p.SPATIENT.PostalCode = a.Items[i].ToString();
break;
case ItemsChoiceType7.country:
p.SPATIENT.Country = a.Items[i].ToString();
break;
default:
break;
}
}
}
}
}
}
}
//OTHER IDS (SSN)
if (person.asOtherIDs != null && person.asOtherIDs.Length > 0)
{
foreach (PRPA_MT201310UV02OtherIDs id in person.asOtherIDs)
{
if (id.id != null && id.id.Length > 0)
{
if (id.classCode == "SSN")
{
p.SPATIENT.PatientSSN = id.id[0].extension;
}
}
}
}
}
}
}
p.PATIENT_ID = PATIENTManager.SaveComplete(CURRENT_USER, CURRENT_REGISTRY_ID, p);
objReturn = true;
}
break;
case "NF":
break;
default:
break;
}
}
}
}
objDB.Dispose();
return(objReturn);
}
public void deletePatient(PATIENT patToDel)
{
context.PATIENTs.Remove(patToDel);
context.SaveChanges();
}
public bool updPatientLastLoginTime(PATIENT patient)
{
return(basedao.setPatient((int)patient.ID, patient.PASSWORD, patient.EXPLANATION, patient.NAME, patient.LASTLOGIN_TIME, patient.CREATION_TIME, patient.E_MAIL, patient.BIRTHDAY, patient.IDENTITY, patient.GENDER, (int)patient.COUNT));
}
private PRPA_MT201306UV02ParameterList GetDemographicParameters(PATIENT p)
{
PRPA_MT201306UV02ParameterList objReturn = null;
if (p != null)
{
objReturn = new PRPA_MT201306UV02ParameterList();
if (p.SPATIENT != null)
{
if (!string.IsNullOrEmpty(p.SPATIENT.Gender))
{
objReturn.livingSubjectAdministrativeGender = new PRPA_MT201306UV02LivingSubjectAdministrativeGender[]
{
new PRPA_MT201306UV02LivingSubjectAdministrativeGender()
{
value = new CE[] { new CE()
{
code = p.SPATIENT.Gender.Trim().ToUpper().Substring(0, 1)
} },
semanticsText = "Gender"
}
};
}
DateTime?dob = null;
if (p.SPATIENT.DateOfBirth != null)
{
dob = p.SPATIENT.DateOfBirth;
}
else if (p.BIRTH_DATE != null)
{
dob = p.BIRTH_DATE;
}
if (dob != null)
{
objReturn.livingSubjectBirthTime = new PRPA_MT201306UV02LivingSubjectBirthTime[]
{
new PRPA_MT201306UV02LivingSubjectBirthTime()
{
value = new IVL_TS[] { new IVL_TS()
{
value = dob.Value.ToString("yyyyMMdd")
} },
semanticsText = "Date of Birth"
}
};
}
if (!string.IsNullOrEmpty(p.SPATIENT.PatientSSN))
{
//TODO: May need to add additional SSN validation at some point
objReturn.livingSubjectId = new PRPA_MT201306UV02LivingSubjectId[]
{
new PRPA_MT201306UV02LivingSubjectId()
{
value = new II[] { new II()
{
extension = p.SPATIENT.PatientSSN.Trim().ToUpper(), root = "2.16.840.1.113883.4.1"
} },
semanticsText = "SSN"
}
};
}
string firstName = string.Empty;
//string middleName = string.Empty;
string lastName = string.Empty;
if (!string.IsNullOrEmpty(p.SPATIENT.PatientFirstName))
{
firstName = p.SPATIENT.PatientFirstName;
}
else if (!string.IsNullOrEmpty(p.FIRST_NAME))
{
firstName = p.FIRST_NAME;
}
//if (!string.IsNullOrEmpty(p.MIDDLE_NAME))
// middleName = p.MIDDLE_NAME;
if (!string.IsNullOrEmpty(p.SPATIENT.PatientLastName))
{
lastName = p.SPATIENT.PatientLastName;
}
else if (!string.IsNullOrEmpty(p.LAST_NAME))
{
lastName = p.LAST_NAME;
}
objReturn.livingSubjectName = new PRPA_MT201306UV02LivingSubjectName[]
{
new PRPA_MT201306UV02LivingSubjectName()
{
value = new EN[]
{
new EN()
{
use = new string[] { "L" },
ItemsElementName = new ItemsChoiceType8[] { ItemsChoiceType8.given, ItemsChoiceType8.family },
Items = new string[] { firstName, lastName }
}
},
semanticsText = "Legal Name"
}
};
}
}
return(objReturn);
}
public void insertPatient(PATIENT patient)
{
service.insertPatient(patient);
}
public void updLastLogin(PATIENT patient)
{
patient.LASTLOGIN_TIME = DateTime.Now;
dao.updPatientLastLoginTime(patient);
}
public bool changePatientCount(int patID, int count)
{
PATIENT pat = (PATIENT)(getPatientById(patID)[0]);
return(basedao.setPatient(patID, pat.PASSWORD, pat.EXPLANATION, pat.NAME, pat.LASTLOGIN_TIME, pat.CREATION_TIME, pat.E_MAIL, pat.BIRTHDAY, pat.IDENTITY, pat.GENDER, count));
}
private void ResetForm()
{
hideWorkstreamId.Value = string.Empty;
listWorkstreamName.ClearSelection();
listWorkstreamName.Items.Clear();
listWorkstreamName.Enabled = true;
List <STD_WKFCASETYPE> cases = ServiceInterfaceManager.STD_WKFCASETYPE_GET_ALL_BY_REGISTRY(HttpContext.Current.User.Identity.Name, UserSession.CurrentRegistryId);
listWorkstreamName.Items.Add(new ListItem("", "0"));
listWorkstreamName.AppendDataBoundItems = true;
if (cases != null)
{
listWorkstreamName.DataSource = cases;
listWorkstreamName.DataBind();
}
if (UserSession.CurrentReferralId > 0)
{
REFERRAL r = ServiceInterfaceManager.REFERRAL_GET(HttpContext.Current.User.Identity.Name, UserSession.CurrentRegistryId, UserSession.CurrentReferralId);
if (r != null)
{
hideReferralId.Value = r.REFERRAL_ID.ToString();
if (r.REFERRAL_DATE != null)
{
txtReferralDate.Text = r.REFERRAL_DATE.Value.ToString("MM/dd/yyyy");
}
if (UserSession.CurrentPatientId <= 0)
{
UserSession.CurrentPatientId = r.PATIENT_ID;
}
}
}
else
{
txtReferralDate.Text = string.Empty;
}
if (UserSession.CurrentPatientId > 0)
{
PATIENT p = ServiceInterfaceManager.PATIENT_GET(HttpContext.Current.User.Identity.Name, UserSession.CurrentRegistryId, UserSession.CurrentPatientId);
if (p != null)
{
hidePatientId.Value = p.PATIENT_ID.ToString();
if (!string.IsNullOrEmpty(p.LAST_NAME) && !string.IsNullOrEmpty(p.FIRST_NAME))
{
txtPatientName.Text = p.LAST_NAME + ", " + p.FIRST_NAME;
}
else if (!string.IsNullOrEmpty(p.LAST_NAME))
{
txtPatientName.Text = p.LAST_NAME;
}
else if (!string.IsNullOrEmpty(p.FIRST_NAME))
{
txtPatientName.Text = p.FIRST_NAME;
}
}
}
else
{
txtPatientName.Text = string.Empty;
}
txtCaseNumber.Text = string.Empty;
txtCaseStartDate.Text = string.Empty;
txtCaseDueDate.Text = string.Empty;
}
private void btnTambahTransaksi_Click(object sender, RoutedEventArgs e)
{
try
{
TRANSACTION transaksi = new TRANSACTION()
{
PATIENT_ID = Convert.ToInt32(txtIdPasienTransaksi.Text),
TRANSACTION_DATE = Convert.ToDateTime(dtTanggalTransaksi.Text),
};
et.TRANSACTIONs.Add(transaksi);
et.SaveChanges();
PATIENT pasien = SearchByIdPasienTransaksi(Convert.ToInt32(txtIdPasienTransaksi.Text));
pasien.STATUS = 1;
et.Entry(pasien).State = System.Data.Entity.EntityState.Modified;
et.SaveChanges();
ROOM ruangan = SearchByIdRoomTransaksi(Convert.ToInt32(cmbNamaRuanganTransaksi.SelectedValue));
MEDICINE obat = SearchByIdObatTransaksi(Convert.ToInt32(cmbNamaObatTransaksi.SelectedValue));
DOCTOR dokter = SearchByIdDokterTransaksi(Convert.ToInt32(cmbNamaDokterTransaksi.SelectedValue));
NURSE perawat = SearchByIdPerawatTransaksi(Convert.ToInt32(cmbNamaPerawatTransaksi.SelectedValue));
TRANSACTION_DETAIL detil_transaksi = new TRANSACTION_DETAIL()
{
ARRIVAL_DATE = Convert.ToDateTime(dtKedatanganTransaksi.Text),
LEAVING_DATE = Convert.ToDateTime(dtKepergianTransaksi.Text),
ROOM_ID = Convert.ToInt32(cmbNamaRuanganTransaksi.SelectedValue),
TRANSACTION_ID = Convert.ToInt32(transaksi.TRANSACTION_ID),
PRICE_ROOM = Convert.ToDouble(ruangan.TYPE_ROOM.PRICE),
QTY_MEDICINE = Convert.ToInt32(txtQtyObat.Text),
TOTAL_PRICE = totalPrice()
};
et.TRANSACTION_DETAIL.Add(detil_transaksi);
/*detil_transaksi.MEDICINEs.Add(new MEDICINE { MEDICINE_ID = SearchByIdObatTransaksi(Convert.ToInt32(cmbNamaObatTransaksi.SelectedValue)).MEDICINE_ID });
* detil_transaksi.DOCTORs.Add(new DOCTOR { DOCTOR_ID = SearchByIdDokterTransaksi(Convert.ToInt32(cmbNamaDokterTransaksi.SelectedValue)).DOCTOR_ID });
* detil_transaksi.NURSEs.Add(new NURSE { NURSE_ID = SearchByIdPerawatTransaksi(Convert.ToInt32(cmbNamaPerawatTransaksi.SelectedValue)).NURSE_ID });*/
TRANSACTION_DETAIL detil_transaksi1 = new TRANSACTION_DETAIL {
TRANSACTION_DETAIL_ID = detil_transaksi.TRANSACTION_DETAIL_ID
};
et.TRANSACTION_DETAIL.Add(detil_transaksi1);
et.TRANSACTION_DETAIL.Attach(detil_transaksi1);
MEDICINE obat1 = new MEDICINE {
MEDICINE_ID = obat.MEDICINE_ID
};
et.MEDICINEs.Add(obat1);
//et.MEDICINEs.Attach(obat1);
DOCTOR dokter1 = new DOCTOR {
DOCTOR_ID = dokter.DOCTOR_ID
};
et.DOCTORs.Add(dokter1);
//et.DOCTORs.Attach(dokter1);
NURSE perawat1 = new NURSE {
NURSE_ID = perawat.NURSE_ID
};
et.NURSEs.Add(perawat1);
//et.NURSEs.Attach(perawat1);
detil_transaksi1.MEDICINEs.Add(obat1);
detil_transaksi1.DOCTORs.Add(dokter1);
detil_transaksi1.NURSEs.Add(perawat1);
et.SaveChanges();
MEDICINE mEDICINE = SearchByIdObatTransaksi(Convert.ToInt32(cmbNamaObatTransaksi.SelectedValue));
mEDICINE.STOCK = obat.STOCK - detil_transaksi.QTY_MEDICINE;
et.Entry(mEDICINE).State = System.Data.Entity.EntityState.Modified;
et.SaveChanges();
clearTextTransaksi();
this.viewBlmTransaksiPasien(dgTransaksiPasien);
MessageBox.Show("Transaksi Berhasil !", "Informasi", MessageBoxButton.OK, MessageBoxImage.Information);
}
catch (Exception ex)
{
}
//TRANSACTION_DETAIL detil_transaksi1 = new TRANSACTION_DETAIL { TRANSACTION_DETAIL_ID = detil_transaksi.TRANSACTION_DETAIL_ID };
//detil_transaksi1.MEDICINEs.Add(new MEDICINE { MEDICINE_ID = obat.MEDICINE_ID });
//et.TRANSACTION_DETAIL.Add(detil_transaksi1);
//et.SaveChanges();
}
public PRPA_IN201306UV02 PRPA_IN201305UV02(string CURRENT_USER, Int32 CURRENT_REGISTRY_ID, PATIENT p)
{
PRPA_IN201306UV02 objReturn = null;
try
{
PRPA_MT201306UV02ParameterList patientParameters = GetDemographicParameters(p);
if (patientParameters == null)
{
return(null);
}
QUQI_MT021001UV01DataEnterer[] currentUser = GetDataEnterer(CURRENT_USER, CURRENT_REGISTRY_ID);
if (rsMain == null)
{
InitProxy();
}
string createDateTime = DateTime.Now.ToString("yyyyMMddhhmmss");
PRPA_IN201305UV02 PRPA_IN201305UV021 = new PRPA_IN201305UV02()
{
id = new II()
{
root = vaRoot, extension = string.Format("{0}-{1}", "MCID", createDateTime)
},
creationTime = new TS()
{
value = createDateTime
},
versionCode = new CS()
{
code = verCode
},
interactionId = new II()
{
extension = "PRPA_IN201305UV02", root = iiRoot
},
processingCode = new CS()
{
code = prcCode
},
processingModeCode = new CS()
{
code = "T"
},
acceptAckCode = new CS()
{
code = "AL"
},
receiver = new MCCI_MT000100UV01Receiver[]
{
new MCCI_MT000100UV01Receiver()
{
typeCode = CommunicationFunctionType.RCV,
device = new MCCI_MT000100UV01Device()
{
determinerCode = "INSTANCE",
classCode = EntityClassDevice.DEV,
id = new II[] { new II()
{
root = vaRoot
} }
}
}
},
sender = new MCCI_MT000100UV01Sender()
{
typeCode = CommunicationFunctionType.SND,
device = new MCCI_MT000100UV01Device()
{
determinerCode = "INSTANCE",
classCode = EntityClassDevice.DEV,
id = new II[] { new II()
{
root = vaRoot, extension = "200CRSE"
} }
}
},
controlActProcess = new PRPA_IN201305UV02QUQI_MT021001UV01ControlActProcess()
{
dataEnterer = currentUser,
classCode = ActClassControlAct.CACT,
moodCode = x_ActMoodIntentEvent.EVN,
code = new CD()
{
code = "PRPA_TE201305UV02", codeSystem = iiRoot
},
queryByParameter = new PRPA_MT201306UV02QueryByParameter()
{
queryId = new II()
{
root = vaRoot, extension = createDateTime
},
statusCode = new CS()
{
code = "new"
},
modifyCode = new CS()
{
code = "MVI.COMP1"
},
initialQuantity = new INT()
{
value = "1"
},
parameterList = patientParameters
},
}
};
////Used for debugging request
//SoapEnvelope envelope = new SoapEnvelope();
//envelope.body = new Body();
//envelope.body.PRPA_IN201305UV02 = PRPA_IN201305UV021;
//XmlSerializer ser = new XmlSerializer(typeof(SoapEnvelope));
//TextWriter writer = new StreamWriter("C:\\temp\\PRPA_IN201305UV02.xml");
//ser.Serialize(writer, envelope);
//writer.Close();
LogDetails logDetails = new LogDetails(String.Format("{0}.{1}", System.Reflection.MethodBase.GetCurrentMethod().DeclaringType.FullName, System.Reflection.MethodBase.GetCurrentMethod().Name), CURRENT_USER, CURRENT_REGISTRY_ID);
objReturn = rsMain.PRPA_IN201305UV02(PRPA_IN201305UV021);
LogManager.LogTiming(logDetails);
////Used for debugging response
//if (objReturn != null)
//{
// envelope = new SoapEnvelope();
// envelope.body = new Body();
// envelope.body.PRPA_IN201306UV02 = objReturn;
// ser = new XmlSerializer(typeof(SoapEnvelope));
// writer = new StreamWriter("C:\\temp\\PRPA_IN201306UV02.xml");
// ser.Serialize(writer, envelope);
// writer.Close();
//}
}
catch (WebException ex)
{
LogManager.LogError(ex.Message, String.Format("{0}.{1}", System.Reflection.MethodBase.GetCurrentMethod().DeclaringType.FullName, System.Reflection.MethodBase.GetCurrentMethod().Name), CURRENT_USER, CURRENT_REGISTRY_ID);
throw ex;
}
catch (Exception ex)
{
LogManager.LogError(ex.Message, String.Format("{0}.{1}", System.Reflection.MethodBase.GetCurrentMethod().DeclaringType.FullName, System.Reflection.MethodBase.GetCurrentMethod().Name), CURRENT_USER, CURRENT_REGISTRY_ID);
throw ex;
}
return(objReturn);
}
public PATIENT GetItemComplete(string CURRENT_USER, Int32 CURRENT_REGISTRY_ID, Int32 PATIENT_ID)
{
PATIENT objReturn = null;
SqlConnection sConn = null;
SqlCommand sCmd = null;
SqlDataAdapter sAdapter = null;
DataSet objTemp = null;
try
{
sConn = new SqlConnection(SqlConnectionString);
sConn.Open();
sCmd = new SqlCommand("CRS.usp_PATIENT_getitemComplete", sConn);
sCmd.CommandTimeout = SqlCommandTimeout;
sCmd.CommandType = CommandType.StoredProcedure;
sCmd.Parameters.AddWithValue("@CURRENT_USER", CURRENT_USER);
sCmd.Parameters.AddWithValue("@CURRENT_REGISTRY_ID", CURRENT_REGISTRY_ID);
sCmd.Parameters.AddWithValue("@PATIENT_ID", PATIENT_ID);
objTemp = new DataSet();
sAdapter = new SqlDataAdapter(sCmd);
LogDetails logDetails = new LogDetails(String.Format("{0}.{1}", System.Reflection.MethodBase.GetCurrentMethod().DeclaringType.FullName, System.Reflection.MethodBase.GetCurrentMethod().Name), CURRENT_USER, CURRENT_REGISTRY_ID);
sAdapter.Fill(objTemp);
LogManager.LogTiming(logDetails);
CheckDataSet(objTemp);
if (objTemp != null && objTemp.Tables.Count > 0 && objTemp.Tables[0].Rows.Count > 0)
{
objReturn = ParseReaderComplete(objTemp.Tables[0].Rows[0]);
}
sConn.Close();
}
catch (Exception ex)
{
LogManager.LogError(ex.Message, String.Format("{0}.{1}", System.Reflection.MethodBase.GetCurrentMethod().DeclaringType.FullName, System.Reflection.MethodBase.GetCurrentMethod().Name), CURRENT_USER, CURRENT_REGISTRY_ID);
throw ex;
}
finally
{
if (sAdapter != null)
{
sAdapter.Dispose();
sAdapter = null;
}
if (sCmd != null)
{
sCmd.Dispose();
sCmd = null;
}
if (sConn != null)
{
if (sConn.State != ConnectionState.Closed)
{
sConn.Close();
}
sConn.Dispose();
sConn = null;
}
}
return(objReturn);
}
