public bool CheckTrakcarePassword(string username, string password) { try { using (WS_Trakcare.WS_GetDataBytrakSoapClient ws = new WS_Trakcare.WS_GetDataBytrakSoapClient()) { DataTable dt = ws.LogonTrakcare(username, password); if (dt.Rows.Count > 0) { SetLogUser sl = new SetLogUser(); sl.setItem(CheckupAppCode, username); return(true); } else { return(false); } } } catch (Exception ex) { throw ex; } }
public MapPatientResult MappingPatient(int tpr_id, List <int> listID) { try { using (InhCheckupDataContext cdc = new InhCheckupDataContext()) { var patient = cdc.trn_patient_regis .Where(x => x.tpr_id == tpr_id) .Select(x => new { en = x.tpr_en_no, arrived = x.trn_patient_regis_detail.tpr_real_arrived_date, loc = x.mst_hpc_site.mhs_code }).FirstOrDefault(); if (patient != null) { using (WS_Trakcare.WS_GetDataBytrakSoapClient ws = new WS_Trakcare.WS_GetDataBytrakSoapClient()) { var result = ws.GetPTArrivedCheckUpFilter(patient.loc, patient.en, patient.arrived.Value.ToString("yyyy-MM-dd")).AsEnumerable() .Select(x => new { titlename = x.Field <string>("TTL_Desc") == null ? "" : x.Field <string>("TTL_Desc").Trim(), firstname = x.Field <string>("PAPMI_Name") == null ? "" : x.Field <string>("PAPMI_Name").Trim(), lastname = x.Field <string>("PAPMI_Name2") == null ? "" : x.Field <string>("PAPMI_Name2").Trim(), firstname_eng = x.Field <string>("PAPER_Name5") == null ? "" : x.Field <string>("PAPER_Name5").Trim(), middlename_eng = x.Field <string>("PAPER_Name7") == null ? "" : x.Field <string>("PAPER_Name7").Trim(), lastname_eng = x.Field <string>("PAPER_Name6") == null ? "" : x.Field <string>("PAPER_Name6").Trim(), idcard = x.Field <string>("PAPER_ID") == null ? "" : x.Field <string>("PAPER_ID").Trim() }).FirstOrDefault(); if (result != null) { using (InhToDoListDataContext tdc = new InhToDoListDataContext()) { MapPatientResult person; if (!string.IsNullOrEmpty(result.idcard)) { person = tdc.trn_name_checks .Where(x => listID.Contains(x.tcd_id) && x.tnc_personal_id.Trim() == result.idcard) .Select(x => new MapPatientResult { document_no = x.trn_company_detail.tcd_document_no, emp_id = x.tnc_emp_id, position = x.tnc_position, department = x.tnc_department }).FirstOrDefault(); if (person != null) { return(person); } } if (!string.IsNullOrEmpty(result.firstname) && !string.IsNullOrEmpty(result.lastname)) { person = tdc.trn_name_checks .Where(x => listID.Contains(x.tcd_id) && x.tnc_fname.Trim() == result.firstname && x.tnc_lname.Trim() == result.lastname) .Select(x => new MapPatientResult { document_no = x.trn_company_detail.tcd_document_no, emp_id = x.tnc_emp_id, position = x.tnc_position, department = x.tnc_department }).FirstOrDefault(); if (person != null) { return(person); } } if (!string.IsNullOrEmpty(result.firstname_eng) && !string.IsNullOrEmpty(result.lastname_eng)) { person = tdc.trn_name_checks .Where(x => listID.Contains(x.tcd_id) && x.tnc_fname.Trim() == result.firstname_eng && x.tnc_lname.Trim() == result.lastname_eng) .Select(x => new MapPatientResult { document_no = x.trn_company_detail.tcd_document_no, emp_id = x.tnc_emp_id, position = x.tnc_position, department = x.tnc_department }).FirstOrDefault(); if (person != null) { return(person); } } if (!string.IsNullOrEmpty(result.firstname_eng) && !string.IsNullOrEmpty(result.middlename_eng) && !string.IsNullOrEmpty(result.lastname_eng)) { person = tdc.trn_name_checks .Where(x => listID.Contains(x.tcd_id) && x.tnc_fname.Trim() == result.firstname_eng + " " + result.middlename_eng && x.tnc_lname.Trim() == result.lastname_eng) .Select(x => new MapPatientResult { document_no = x.trn_company_detail.tcd_document_no, emp_id = x.tnc_emp_id, position = x.tnc_position, department = x.tnc_department }).FirstOrDefault(); if (person != null) { return(person); } } if (!string.IsNullOrEmpty(result.firstname) && !string.IsNullOrEmpty(result.lastname)) { person = tdc.trn_name_checks .Where(x => listID.Contains(x.tcd_id) && x.tnc_fname.Trim().EndsWith(result.firstname) && x.tnc_lname.Trim() == result.lastname) .Select(x => new MapPatientResult { document_no = x.trn_company_detail.tcd_document_no, emp_id = x.tnc_emp_id, position = x.tnc_position, department = x.tnc_department }).FirstOrDefault(); if (person != null) { return(person); } } if (!string.IsNullOrEmpty(result.firstname_eng) && !string.IsNullOrEmpty(result.lastname_eng)) { person = tdc.trn_name_checks .Where(x => listID.Contains(x.tcd_id) && x.tnc_fname.Trim().EndsWith(result.firstname_eng) && x.tnc_lname.Trim() == result.lastname_eng) .Select(x => new MapPatientResult { document_no = x.trn_company_detail.tcd_document_no, emp_id = x.tnc_emp_id, position = x.tnc_position, department = x.tnc_department }).FirstOrDefault(); if (person != null) { return(person); } } if (!string.IsNullOrEmpty(result.firstname_eng) && !string.IsNullOrEmpty(result.middlename_eng) && !string.IsNullOrEmpty(result.lastname_eng)) { person = tdc.trn_name_checks .Where(x => listID.Contains(x.tcd_id) && x.tnc_fname.Trim().EndsWith(result.firstname_eng + " " + result.middlename_eng) && x.tnc_lname.Trim() == result.lastname_eng) .Select(x => new MapPatientResult { document_no = x.trn_company_detail.tcd_document_no, emp_id = x.tnc_emp_id, position = x.tnc_position, department = x.tnc_department }).FirstOrDefault(); if (person != null) { return(person); } } } } } } return(new MapPatientResult()); } } catch (Exception ex) { return(new MapPatientResult()); } }