private void btnRetreiveLab_Click(object sender, EventArgs e) { try { using (frmBGScreen frmbg = new frmBGScreen()) { frmbg.Show(); using (Service.WS_CheckupCls ws = new Service.WS_CheckupCls()) { ws.getCheckUpLabResult("", Program.CurrentRegis.tpr_id); } } } catch (Exception ex) { Program.MessageError(this.Name, "btnRetreiveLab_Click", ex, false); } }
public StatusTransaction importPatient(int tpr_id) { try { using (InhCheckupDataContext contxt = new InhCheckupDataContext()) { DateTime dateNow = Program.GetServerDateTime(); //List<trn_RefreshLabHistory> his = contxt.trn_RefreshLabHistories.Where(x => x.tpr_id == tpr_id).ToList(); //his.ForEach(x => x.status = true); //contxt.SubmitChanges(); trn_patient_regi patient_regis = contxt.trn_patient_regis.Where(x => x.tpr_id == tpr_id).FirstOrDefault(); //using (Service.WS_CheckupCls wsCheckup = new Service.WS_CheckupCls()) //{ // wsCheckup.InsertDBEmrCheckupResultXray(patient_regis.trn_patient.tpt_hn_no, patient_regis.tpr_en_no, dateNow.AddYears(-5), dateNow, true); //} } using (InhCheckupDataContext cdc = new InhCheckupDataContext()) { try { string username = Program.CurrentUser == null ? "" : Program.CurrentUser.mut_username; DateTime dateNow = Program.GetServerDateTime(); cdc.Connection.Open(); DbTransaction trans = cdc.Connection.BeginTransaction(); cdc.Transaction = trans; trn_patient_regi patient_regis = cdc.trn_patient_regis.Where(x => x.tpr_id == tpr_id).FirstOrDefault(); patient_regis.trn_patient_queues.ToList().ForEach(x => { x.tps_status = "ED"; x.tps_ns_status = null; x.tps_update_by = username; x.tps_update_date = dateNow; }); int enRowID = Convert.ToInt32(patient_regis.tpr_en_rowid); EmrClass.GetPTPackageCls PackageCls = new EmrClass.GetPTPackageCls(); EnumerableRowCollection <DataRow> getPTPackage = PackageCls.GetPTPackage(enRowID); PackageCls.AddPatientOrderItem(ref patient_regis, username, dateNow, getPTPackage); PackageCls.AddPatientOrderSet(ref patient_regis, username, dateNow, getPTPackage); List <MapOrderEvent> mapOrder = PackageCls.MapEvent(getPTPackage); PackageCls.AddPatientEvent(ref patient_regis, username, dateNow, mapOrder); PackageCls.AddPatientPlan(ref patient_regis, username, dateNow, mapOrder); PackageCls.skipReqDoctorOutDepartment(ref patient_regis); PackageCls.CompleteEcho(ref patient_regis); PackageCls.skipChangeEstToEcho(ref patient_regis, patient_regis.mhs_id); PackageCls.checkOrderPMR(ref patient_regis, patient_regis.mhs_id); patient_regis.tpr_status = "WB"; patient_regis.tpr_pe_status = "RS"; try { cdc.SubmitChanges(); } catch (System.Data.Linq.ChangeConflictException) { foreach (System.Data.Linq.ObjectChangeConflict occ in cdc.ChangeConflicts) { cdc.Refresh(System.Data.Linq.RefreshMode.KeepChanges, occ.Object); } cdc.SubmitChanges(); } PackageCls.setRelationOrderSet(ref patient_regis); cdc.SubmitChanges(); cdc.Transaction.Commit(); using (Service.WS_CheckupCls ws = new Service.WS_CheckupCls()) { ws.retrieveVitalSign(tpr_id, username); ws.getCheckUpLabResult("", tpr_id); } return(StatusTransaction.True); } catch (Exception ex) { //cdc.Transaction.Rollback(); Program.MessageError("ImportPatientToBookCls", "importPatient", ex, false); return(StatusTransaction.Error); } finally { //cdc.Connection.Close(); } } } catch (Exception ex) { Program.MessageError("ImportPatientToBookCls", "importPatient", ex, false); return(StatusTransaction.Error); } }