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);
}
