private void load_trn_report_med_cer(int tpt_id, string en) { using (InhCheckupDataContext dbc = new InhCheckupDataContext()) { if (Program.CurrentRegis != null) { trn_report_med_cer trmc = (from t1 in dbc.trn_report_med_cers where t1.trmc_en == en && t1.tpt_id == tpt_id select t1).FirstOrDefault(); if (trmc != null) { txtfullname.Text = trmc.trmc_full_name; txtaddress.Text = trmc.trmc_address; txtdob.Text = String.Format("{0:dd/MM/yyyy}", trmc.trmc_dob); txtnation.Text = trmc.trmc_nation; txtlicence.Text = trmc.trmc_licence_no; cbmedical_standard_class.SelectedIndex = Convert.ToInt16(trmc.trmc_med_std); cbame_signature.SelectedValue = Convert.ToInt16(trmc.trmc_ame_signature); dtpexam.Value = trmc.trmc_date_exam.Value.Date; dtpvalid_until.Value = trmc.trmc_valid_until.Value.Date; } else { trn_patient tpt = Program.CurrentRegis.trn_patient; //find aviation licence trn_ques_aviation tqa = (from t1 in dbc.trn_ques_aviations where t1.tpr_id == Program.CurrentRegis.tpr_id select t1).FirstOrDefault(); txtfullname.Text = tpt.tpt_othername; txtaddress.Text = Program.CurrentRegis.tpr_main_address; txtdob.Text = tpt.tpt_dob_text; // String.Format("{0:dd/MM/yyyy}", tpt.tpt_dob); txtnation.Text = tpt.tpt_nation_desc; txtlicence.Text = tqa.tqa_license_no; cbmedical_standard_class.SelectedIndex = 0; cbame_signature.SelectedValue = 0; dtpexam.Value = Program.CurrentRegis.tpr_arrive_date.Value.Date; } } } }
private void Update(char doctype) { trn_ques_aviation currentquest = (trn_ques_aviation)trnquesavaitionBindingSource.Current; currentquest.tpr_id = Program.CurrentRegis.tpr_id; currentquest.tqa_type = doctype; currentquest.tqa_doc_type = Program.CurrentRegis.tpr_aviation_type; currentquest.tqa_update_by = Program.CurrentUser.mut_username; currentquest.tqa_update_date = Program.GetServerDateTime(); if (doctype == 'N') { currentquest.tqa_confirm_doctor = Program.CurrentUser.mut_username; currentquest.tqa_confirm_date = Program.GetServerDateTime(); } currentquest.tqa_place_exam = txtplace.Text; currentquest.tqa_th_fullname = txtname_th.Text; currentquest.tqa_en_fullname = txtname_en.Text; currentquest.tqa_th_nation = txtnation_th.Text; currentquest.tqa_en_nation = txtnation_en.Text; currentquest.tqa_age_yrs = Convert.ToDouble(txtage.Text); currentquest.tqa_age_month = Convert.ToDouble(txtmonth.Text); currentquest.tqa_th_address = txtaddress.Text; //find dob DateTime dob = (DateTime)(from t1 in dbc.trn_patients where t1.tpt_id == Program.CurrentRegis.tpt_id select t1.tpt_dob).FirstOrDefault(); currentquest.tqa_dob = dob; //currentquest.tqa_dob = Program.CurrentRegis.trn_patient.tpt_dob; //tab 1 currentquest.tqa_sex = Program.GetValueGroupBox(grbgender); currentquest.tqa_avia_type = Program.GetValueRadioTochar(pnlaviatype); currentquest.tqa_prev_exam_deca = Program.GetValueRadioTochar(pnlprev_exam_decla); currentquest.tqa_use_medicine = Program.GetValueRadioTochar(pnluse_med); currentquest.tqa_med_amount = txtmed_amt.Text; currentquest.tqa_med_reason = txtmed_reason.Text; currentquest.tqa_med_name = txtmed_name.Text; currentquest.tqa_avia_oths = txtavia_oth.Text; //tab 2 currentquest.tqa_chis_freq = Program.GetValueRadioTochar(pnlchis_freq); currentquest.tqa_chis_freq_rmk = txtfreq.Text; currentquest.tqa_chis_dizz = Program.GetValueRadioTochar(pnlchis_dizz); currentquest.tqa_chis_dizz_rmk = txtdizz.Text; currentquest.tqa_chis_unco = Program.GetValueRadioTochar(pnlchis_unco); currentquest.tqa_chis_unco_rmk = txtunco.Text; currentquest.tqa_chis_eyet = Program.GetValueRadioTochar(pnlchis_eyes); currentquest.tqa_chis_eyet_rmk = txteye.Text; currentquest.tqa_chis_hayf = Program.GetValueRadioTochar(pnlchis_hayf); currentquest.tqa_chis_hayf_rmk = txtalle.Text; currentquest.tqa_chis_lung = Program.GetValueRadioTochar(pnlchis_lung); currentquest.tqa_chis_lung_rmk = txtlung.Text; currentquest.tqa_chis_kidn = Program.GetValueRadioTochar(pnlchis_kind); currentquest.tqa_chis_kidn_rmk = txtkind.Text; currentquest.tqa_chis_ment = Program.GetValueRadioTochar(pnlchis_mental); currentquest.tqa_chis_ment_rmk = txtmental.Text; currentquest.tqa_chis_alco = Program.GetValueRadioTochar(pnlchis_alco); currentquest.tqa_chis_alco_rmk = txtalco.Text; currentquest.tqa_chis_hert = Program.GetValueRadioTochar(pnlchis_heart); currentquest.tqa_chis_hert_rmk = txtheart.Text; currentquest.tqa_chis_high = Program.GetValueRadioTochar(pnlchis_high); currentquest.tqa_chis_high_rmk = txthigh.Text; currentquest.tqa_chis_stom = Program.GetValueRadioTochar(pnlchis_stomach); currentquest.tqa_chis_stom_rmk = txtstomach.Text; currentquest.tqa_chis_nurv = Program.GetValueRadioTochar(pnlchis_nurv); currentquest.tqa_chis_nurv_rmk = txtneur.Text; currentquest.tqa_chis_drug = Program.GetValueRadioTochar(pnlchis_drug); currentquest.tqa_chis_drug_rmk = txtdrug.Text; currentquest.tqa_chis_suic = Program.GetValueRadioTochar(pnlchis_suic); currentquest.tqa_chis_suic_rmk = txtsuic.Text; currentquest.tqa_chis_moti = Program.GetValueRadioTochar(pnlchis_moti); currentquest.tqa_chis_moti_rmk = txtmotion.Text; currentquest.tqa_chis_adms = Program.GetValueRadioTochar(pnlchis_adm); currentquest.tqa_chis_adms_rmk = txtadm.Text; currentquest.tqa_chis_avia = Program.GetValueRadioTochar(pnlchis_avia); currentquest.tqa_chis_avia_rmk = txtavia.Text; currentquest.tqa_chis_otha = Program.GetValueRadioTochar(pnlchis_otha); currentquest.tqa_chis_otha_rmk = txtotha.Text; currentquest.tqa_chis_gyna = Program.GetValueRadioTochar(pnlchis_gyna); currentquest.tqa_chis_gyna_rmk = txtgyne.Text; currentquest.tqa_chis_othi = Program.GetValueRadioTochar(pnlchis_othi); currentquest.tqa_chis_othi_rmk = txtothi.Text; currentquest.tqa_chis_conviction = Program.GetValueRadioTochar(pnlconviction); currentquest.tqa_chis_conv_rmk = txtconvic.Text; currentquest.tqa_chge_address = Program.GetValueRadioTochar(pnlchkaddr); currentquest.tqa_avia_oths = txtavia_oth.Text; currentquest.tqa_tot_fling_time = textBox12.Text == String.Empty ? 0 : Convert.ToDouble(textBox12.Text); currentquest.tqa_last_six_time = textBox13.Text == String.Empty ? 0 : Convert.ToDouble(textBox13.Text); trnquesavaitionBindingSource.EndEdit(); try { dbc.SubmitChanges(); } catch (System.Data.Linq.ChangeConflictException) { foreach (System.Data.Linq.ObjectChangeConflict occ in dbc.ChangeConflicts) { dbc.Refresh(System.Data.Linq.RefreshMode.KeepChanges, occ.Object); } dbc.SubmitChanges(); } }
private void LoadTransaction() { if (Program.CurrentRegis != null) { //find HN var objHN1 = (from t1 in dbc.trn_patient_regis join t2 in dbc.trn_patients on t1.tpt_id equals t2.tpt_id where t1.tpt_id == Program.CurrentRegis.tpt_id select new { t1, t2 }).OrderByDescending(c => c.t1.tpr_create_date).FirstOrDefault(); //EN No Lastest string objHN2 = Program.CurrentRegis.tpr_en_no; if (objHN1.t1.tpr_en_no == objHN2) { var objnew = (from q in dbc.trn_ques_aviations where q.tpr_id == Program.CurrentRegis.tpr_id select q).OrderByDescending(c => c.tqa_update_date).FirstOrDefault(); if (objnew != null) { trnquesavaitionBindingSource.DataSource = objnew; trn_ques_aviation CurrentQuestion = (trn_ques_aviation)trnquesavaitionBindingSource.Current; //tab 1 Program.SetValueRadioGroupBox(grbgender, CurrentQuestion.tqa_sex); Program.SetValueRadioGroup(pnlaviatype, CurrentQuestion.tqa_avia_type); Program.SetValueRadioGroup(pnluse_med, CurrentQuestion.tqa_use_medicine); txtmed_amt.Text = CurrentQuestion.tqa_med_amount; txtmed_reason.Text = CurrentQuestion.tqa_med_reason; txtmed_name.Text = CurrentQuestion.tqa_med_name; txtavia_oth.Text = CurrentQuestion.tqa_avia_oths; txtaircraft_name.Text = CurrentQuestion.tqa_aircraft_name; Program.SetValueRadioGroup(pnlchkaddr, CurrentQuestion.tqa_chge_address); //tab 2 Program.SetValueRadioGroup(pnlchis_freq, CurrentQuestion.tqa_chis_freq); Program.SetValueRadioGroup(pnlchis_dizz, CurrentQuestion.tqa_chis_dizz); Program.SetValueRadioGroup(pnlchis_unco, CurrentQuestion.tqa_chis_unco); Program.SetValueRadioGroup(pnlchis_eyes, CurrentQuestion.tqa_chis_eyet); Program.SetValueRadioGroup(pnlchis_hayf, CurrentQuestion.tqa_chis_hayf); Program.SetValueRadioGroup(pnlchis_lung, CurrentQuestion.tqa_chis_lung); Program.SetValueRadioGroup(pnlchis_heart, CurrentQuestion.tqa_chis_hert); Program.SetValueRadioGroup(pnlchis_high, CurrentQuestion.tqa_chis_high); Program.SetValueRadioGroup(pnlchis_stomach, CurrentQuestion.tqa_chis_stom); Program.SetValueRadioGroup(pnlchis_kind, CurrentQuestion.tqa_chis_kidn); Program.SetValueRadioGroup(pnlchis_gyna, CurrentQuestion.tqa_chis_gyna); Program.SetValueRadioGroup(pnlchis_nurv, CurrentQuestion.tqa_chis_nurv); Program.SetValueRadioGroup(pnlchis_moti, CurrentQuestion.tqa_chis_moti); Program.SetValueRadioGroup(pnlchis_mental, CurrentQuestion.tqa_chis_ment); Program.SetValueRadioGroup(pnlchis_suic, CurrentQuestion.tqa_chis_suic); Program.SetValueRadioGroup(pnlchis_alco, CurrentQuestion.tqa_chis_alco); Program.SetValueRadioGroup(pnlchis_drug, CurrentQuestion.tqa_chis_drug); Program.SetValueRadioGroup(pnlchis_adm, CurrentQuestion.tqa_chis_adms); Program.SetValueRadioGroup(pnlchis_avia, CurrentQuestion.tqa_chis_avia); Program.SetValueRadioGroup(pnlchis_otha, CurrentQuestion.tqa_chis_otha); Program.SetValueRadioGroup(pnlconviction, CurrentQuestion.tqa_chis_conviction); Program.SetValueRadioGroup(pnlchis_othi, CurrentQuestion.tqa_chis_othi); Program.SetValueRadioGroup(pnlprev_exam_decla, CurrentQuestion.tqa_prev_exam_deca); textBox12.Text = CurrentQuestion.tqa_tot_fling_time.ToString(); textBox13.Text = CurrentQuestion.tqa_last_six_time.ToString(); txtaddress.Text = CurrentQuestion.tqa_th_address; txtplace.Text = CurrentQuestion.tqa_place_exam; txtname_th.Text = CurrentQuestion.tqa_th_fullname; txtname_en.Text = CurrentQuestion.tqa_en_fullname; txtnation_th.Text = CurrentQuestion.tqa_th_nation; txtnation_en.Text = CurrentQuestion.tqa_en_nation; if (objHN1.t2.tpt_nation_code == "TH") { lblpdate_dob.Text = Program.ConvertDateTimeToThai((DateTime)objHN1.t2.tpt_dob); } else { lblpdate_dob.Text = CurrentQuestion.tqa_dob == null ? null : String.Format("{0:dd/MM/yyyy}", objHN1.t2.tpt_dob); } txtage.Text = CurrentQuestion.tqa_age_yrs.ToString(); txtmonth.Text = CurrentQuestion.tqa_age_month.ToString(); //if (((DateTime)CurrentQuestion.tqa_update_date).Date < DateTime.Now.Date) //{ //trnNewquesavaitionBindingSource.DataSource = dbc.trn_ques_aviations; //trnNewquesavaitionBindingSource.AddNew(); //} } else { //Load Default Data this.LoadNewDefaultData(); trnquesavaitionBindingSource.DataSource = (from t1 in dbc.trn_ques_aviations select t1).Take(0); trnquesavaitionBindingSource.AddNew(); } } else { //Load Default Data this.LoadNewDefaultData(); trnquesavaitionBindingSource.DataSource = (from t1 in dbc.trn_ques_aviations select t1).Take(0); trnquesavaitionBindingSource.AddNew(); } } }
private void SaveNew(char doctype) { trn_ques_aviation currentquest = (trn_ques_aviation)trnquesavaitionBindingSource.Current; trn_ques_aviation Newcurrentquest = (trn_ques_aviation)trnNewquesavaitionBindingSource.Current; Newcurrentquest.tpr_id = Program.CurrentHDR.tpr_id; Newcurrentquest.tqa_place_exam = txtplace.Text; Newcurrentquest.tqa_type = doctype; Newcurrentquest.tqa_doc_type = Program.CurrentRegis.tpr_aviation_type; Newcurrentquest.tqa_update_by = Program.CurrentUser.mut_username; Newcurrentquest.tqa_update_date = Program.GetServerDateTime(); Newcurrentquest.tqa_place_exam = currentquest.tqa_place_exam; Newcurrentquest.tqa_th_fullname = txtname_th.Text; Newcurrentquest.tqa_en_fullname = txtname_en.Text; Newcurrentquest.tqa_th_nation = txtnation_th.Text; Newcurrentquest.tqa_en_nation = txtnation_en.Text; if (doctype == 'N') { Newcurrentquest.tqa_confirm_doctor = Program.CurrentUser.mut_username; Newcurrentquest.tqa_confirm_date = Program.GetServerDateTime(); } //find dob DateTime dob = (DateTime)(from t1 in dbc.trn_patients where t1.tpt_id == Program.CurrentRegis.tpt_id select t1.tpt_dob).FirstOrDefault(); Newcurrentquest.tqa_dob = dob; //Newcurrentquest.tqa_dob =Program.CurrentRegis.trn_patient.tpt_dob; Newcurrentquest.tqa_age_yrs = Convert.ToDouble(txtage.Text); Newcurrentquest.tqa_age_month = Convert.ToDouble(txtmonth.Text); Newcurrentquest.tqa_avia_type = Program.GetValueRadioTochar(pnlaviatype); Newcurrentquest.tqa_avia_oths = currentquest.tqa_avia_oths; Newcurrentquest.tqa_license_no = currentquest.tqa_license_no; Newcurrentquest.tqa_prev_exam_deca = Program.GetValueRadioTochar(pnlprev_exam_decla); //Newcurrentquest.tqa_chge_address = txtaddress.Text; Newcurrentquest.tqa_prev_exam_loc = currentquest.tqa_prev_exam_loc; Newcurrentquest.tqa_use_medicine = Program.GetValueRadioTochar(pnluse_med); Newcurrentquest.tqa_med_name = currentquest.tqa_med_name; //tab 1 Newcurrentquest.tqa_sex = Program.GetValueGroupBox(grbgender); Newcurrentquest.tqa_prev_exam_deca = Program.GetValueRadioTochar(pnlprev_exam_decla); Newcurrentquest.tqa_med_reason = txtmed_reason.Text; Newcurrentquest.tqa_med_amount = txtmed_amt.Text; Newcurrentquest.tqa_med_name = txtmed_name.Text; Newcurrentquest.tqa_avia_oths = txtavia_oth.Text; //tab 2 Newcurrentquest.tqa_chis_freq = Program.GetValueRadioTochar(pnlchis_freq); Newcurrentquest.tqa_chis_dizz = Program.GetValueRadioTochar(pnlchis_dizz); Newcurrentquest.tqa_chis_unco = Program.GetValueRadioTochar(pnlchis_unco); Newcurrentquest.tqa_chis_eyet = Program.GetValueRadioTochar(pnlchis_eyes); Newcurrentquest.tqa_chis_hayf = Program.GetValueRadioTochar(pnlchis_hayf); Newcurrentquest.tqa_chis_hert = Program.GetValueRadioTochar(pnlchis_heart); Newcurrentquest.tqa_chis_lung = Program.GetValueRadioTochar(pnlchis_lung); Newcurrentquest.tqa_chis_high = Program.GetValueRadioTochar(pnlchis_high); Newcurrentquest.tqa_chis_stom = Program.GetValueRadioTochar(pnlchis_stomach); Newcurrentquest.tqa_chis_alco = Program.GetValueRadioTochar(pnlchis_alco); Newcurrentquest.tqa_chis_nurv = Program.GetValueRadioTochar(pnlchis_nurv); Newcurrentquest.tqa_chis_drug = Program.GetValueRadioTochar(pnlchis_drug); Newcurrentquest.tqa_chis_suic = Program.GetValueRadioTochar(pnlchis_suic); Newcurrentquest.tqa_chis_moti = Program.GetValueRadioTochar(pnlchis_moti); Newcurrentquest.tqa_chis_adms = Program.GetValueRadioTochar(pnlchis_adm); Newcurrentquest.tqa_chis_avia = Program.GetValueRadioTochar(pnlchis_avia); Newcurrentquest.tqa_chis_otha = Program.GetValueRadioTochar(pnlchis_otha); Newcurrentquest.tqa_chis_gyna = Program.GetValueRadioTochar(pnlchis_gyna); Newcurrentquest.tqa_chis_othi = Program.GetValueRadioTochar(pnlchis_othi); Newcurrentquest.tqa_chis_conviction = Program.GetValueRadioTochar(pnlconviction); Newcurrentquest.tqa_chis_freq_rmk = currentquest.tqa_chis_freq_rmk; Newcurrentquest.tqa_chis_dizz_rmk = currentquest.tqa_chis_dizz_rmk; Newcurrentquest.tqa_chis_unco_rmk = currentquest.tqa_chis_unco_rmk; Newcurrentquest.tqa_chis_eyet_rmk = currentquest.tqa_chis_eyet_rmk; Newcurrentquest.tqa_chis_lung_rmk = currentquest.tqa_chis_lung_rmk; Newcurrentquest.tqa_chis_alco_rmk = currentquest.tqa_chis_alco_rmk; Newcurrentquest.tqa_chis_hayf_rmk = currentquest.tqa_chis_hayf_rmk; Newcurrentquest.tqa_chis_hert_rmk = currentquest.tqa_chis_hert_rmk; Newcurrentquest.tqa_chis_chst_rmk = currentquest.tqa_chis_chst_rmk; Newcurrentquest.tqa_chis_high_rmk = currentquest.tqa_chis_high_rmk; Newcurrentquest.tqa_chis_stom_rmk = currentquest.tqa_chis_stom_rmk; Newcurrentquest.tqa_chis_jaun_rmk = currentquest.tqa_chis_jaun_rmk; Newcurrentquest.tqa_chis_kidn_rmk = currentquest.tqa_chis_kidn_rmk; Newcurrentquest.tqa_chis_suga_rmk = currentquest.tqa_chis_suga_rmk; Newcurrentquest.tqa_chis_epil_rmk = currentquest.tqa_chis_epil_rmk; Newcurrentquest.tqa_chis_nurv_rmk = currentquest.tqa_chis_nurv_rmk; Newcurrentquest.tqa_chge_address = Program.GetValueRadioTochar(pnlchkaddr); Newcurrentquest.tqa_chis_temp_rmk = currentquest.tqa_chis_temp_rmk; Newcurrentquest.tqa_chis_drug_rmk = currentquest.tqa_chis_drug_rmk; Newcurrentquest.tqa_chis_suic_rmk = currentquest.tqa_chis_suic_rmk; Newcurrentquest.tqa_chis_losw_rmk = currentquest.tqa_chis_losw_rmk; Newcurrentquest.tqa_chis_moti_rmk = currentquest.tqa_chis_moti_rmk; Newcurrentquest.tqa_chis_reje_rmk = currentquest.tqa_chis_reje_rmk; Newcurrentquest.tqa_chis_adms_rmk = currentquest.tqa_chis_adms_rmk; Newcurrentquest.tqa_chis_avia_rmk = currentquest.tqa_chis_avia_rmk; Newcurrentquest.tqa_chis_otha_rmk = currentquest.tqa_chis_otha_rmk; Newcurrentquest.tqa_chis_gyna_rmk = currentquest.tqa_chis_gyna_rmk; Newcurrentquest.tqa_chis_othi_rmk = currentquest.tqa_chis_othi_rmk; Newcurrentquest.tqa_chis_heth_rmk = currentquest.tqa_chis_heth_rmk; Newcurrentquest.tqa_tot_fling_time = textBox12.Text == String.Empty ? 0 : Convert.ToDouble(textBox12.Text); Newcurrentquest.tqa_last_six_time = textBox13.Text == String.Empty ? 0 : Convert.ToDouble(textBox13.Text); trnNewquesavaitionBindingSource.EndEdit(); dbc.SubmitChanges(); }
private void AviationToolStripMenuItem_Click(object sender, EventArgs e) { trn_ques_aviation quesAviation = paRegis.trn_ques_aviations.FirstOrDefault(); cdc.Refresh(System.Data.Linq.RefreshMode.OverwriteCurrentValues, quesAviation); }