private void LoadData(int compid)
{
var objcomp = (from cus in dbc.trn_company_details where cus.tcd_id == compid select cus).FirstOrDefault(); //where form?
if (objcomp != null)
{
lblremark_compname_th.Text = objcomp.tcd_tname;
lblremark_compname_en.Text = objcomp.tcd_ename;
lbldoccode.Text = objcomp.tcd_document_no;
lblcompcode.Text = objcomp.tcd_code;
lblcompany_th.Text = objcomp.tcd_tname;
lblcompany_en.Text = objcomp.tcd_ename;
lbldeptowner.Text = objcomp.tcd_type;
//check-up location
var objmcl = (from mst_mcl in dbc.mst_checkup_locations
join trn_mcl in dbc.trn_checkup_locations on mst_mcl.mcl_id equals trn_mcl.mcl_id
where trn_mcl.tcd_id == objcomp.tcd_id
select new
{
ename = mst_mcl.mcl_ename,
tname = mst_mcl.mcl_tname
}).ToList();
List <string> tempLocation = new List <string>();
if (objmcl.Count > 0)
{
tempLocation.Add(string.Join(", ", objmcl.Select(x => x.ename + "/" + x.tname)));
}
if (!string.IsNullOrEmpty(objcomp.tcd_location_remark))
{
tempLocation.Add(objcomp.tcd_location_remark);
}
lblchk_location.Text = string.Join(", ", tempLocation);
/*
* if (objmcl != null)
* {
* lblchk_location.Text = objmcl.mcl_tname; //+ "/" + objmcl.mcl_ename;
* }
*/
lbldate_s_contract.Text = String.Format("{0:dd/MM/yyyy}", objcomp.tcd_date_from);
lbldate_e_contract.Text = String.Format("{0:dd/MM/yyyy}", objcomp.tcd_date_to);
//package and option
//var objpackage = (from package in dbc.trn_package_details
// where package.tcd_id == objcomp.tcd_id
// select new
// {
// package_order = package.tpd_order_desc,
// package_price = package.tpd_price,
// package_payment = (from mpt in dbc.mst_payment_types
// where mpt.mpt_id == package.mpt_id
// select mpt.mpt_tname).FirstOrDefault(),
// package_credit = package.tpd_limit_credit,
// package_s_date = String.Format("{0:dd/MM/yyyy}", package.tpd_date_from),
// package_e_date = String.Format("{0:dd/MM/yyyy}",package.tpd_date_to),
// package_rd = (from rd in dbc.trn_package_request_doctors where rd.tpd_id == package.tpd_id select rd.trd_doc_tname).FirstOrDefault(),
// package_dc = (from dc in dbc.trn_package_doctor_cats where dc.tpd_id == package.tpd_id select dc.mst_doctor_cat.mdc_tname).FirstOrDefault()
// }).ToList();
//if (objpackage != null)
//{
// RepeaterPackage.DataSource = objpackage;
// RepeaterPackage.DataBind();
//}
//package and option Order set
var objpackage = (from package in dbc.trn_package_details
where package.tcd_id == objcomp.tcd_id
select new
{
package_order = package.tpd_order_desc,
package_price = package.tpd_price,
package_payment = (from mpt in dbc.mst_payment_types
where mpt.mpt_id == package.mpt_id
select mpt.mpt_tname).FirstOrDefault(),
package_credit = package.tpd_limit_credit,
package_s_date = String.Format("{0:dd/MM/yyyy}", package.tpd_date_from),
package_e_date = String.Format("{0:dd/MM/yyyy}", package.tpd_date_to),
package_rd = (from rd in dbc.trn_package_request_doctors where rd.tpd_id == package.tpd_id select rd.trd_doc_tname).FirstOrDefault(),
package_dc = (from dc in dbc.trn_package_doctor_cats where dc.tpd_id == package.tpd_id select dc.mst_doctor_cat.mdc_tname).FirstOrDefault(),
package_type = package.tpd_order_type
}).ToList();
if (objpackage != null)
{
RepeaterPackage.DataSource = objpackage.Where(c => c.package_type == "Order Set");
RepeaterPackage.DataBind();
RepeaterOption.DataSource = objpackage.Where(c => c.package_type == "Option");
RepeaterOption.DataBind();
}
var old_paymentType = (from t1 in dbc.trn_payments
where t1.tcd_id == objcomp.tcd_id
select new
{
mst_id = t1.mst_id,
mst_nameTh = (t1.mst_type != null) ? t1.mst_type.mst_tname : "",
mst_nameEn = (t1.mst_type != null) ? t1.mst_type.mst_ename : "",
mpt_id = t1.mpt_id,
mpt_nameTh = (t1.mst_payment_type != null) ? t1.mst_payment_type.mpt_tname : "",
mpt_nameEn = (t1.mst_payment_type != null) ? t1.mst_payment_type.mpt_ename : "",
tpa_mpt_credit = t1.tpa_mpt_credit,
tpa_mpt_remark = t1.tpa_mpt_remark,
mbm_id = t1.mbm_id,
mbm_nameTh = (t1.mst_billing_method != null) ? t1.mst_billing_method.mbm_tname : "",
mbm_nameEn = (t1.mst_billing_method != null) ? t1.mst_billing_method.mbm_ename : "",
mpm_id = t1.mpm_id,
mpm_nameTh = (t1.mst_payment_main != null) ? t1.mst_payment_main.mpm_tname : "",
mpm_nameEn = (t1.mst_payment_main != null) ? t1.mst_payment_main.mpm_ename : "",
mpr_id = t1.mpr_id,
mpr_nameTh = (t1.mst_payment_rate != null) ? t1.mst_payment_rate.mpr_tname : "",
mpr_nameEn = (t1.mst_payment_rate != null) ? t1.mst_payment_rate.mpr_ename : "",
mpq_id = t1.mpq_id,
mpq_nameTh = (t1.mst_payment_quatation != null) ? t1.mst_payment_quatation.mpq_tname : "",
mpq_nameEn = (t1.mst_payment_quatation != null) ? t1.mst_payment_quatation.mpq_ename : "",
tpa_mpq_credit = t1.tpa_mpq_credit,
mpn_id = t1.mpn_id,
mpn_nameTh = (t1.mst_payment_nquatation != null) ? t1.mst_payment_nquatation.mpn_tname : "",
mpn_nameEn = (t1.mst_payment_nquatation != null) ? t1.mst_payment_nquatation.mpn_ename : "",
tpa_mpn_credit = t1.tpa_mpn_credit,
mrm_id = t1.mrm_id,
mrm_nameTh = (t1.mst_receive_medicine != null) ? t1.mst_receive_medicine.mrm_tname : "",
mrm_nameEn = (t1.mst_receive_medicine != null) ? t1.mst_receive_medicine.mrm_ename : "",
tpa_coupon = t1.tpa_coupon,
coupon_name = (t1.tpa_coupon == 'I') ? "ให้" : "ไม่ให้",
tpa_coupon_remark = t1.tpa_coupon_remark,
Status = "O",
tpa_id = t1.tpa_id
}).ToList();
_paymentType = (from t1 in old_paymentType
select new PaymentType_ctc
{
mst_name = t1.mst_nameTh + "/" + t1.mst_nameEn,
mpt_name = t1.mpt_nameTh + "/" + t1.mpt_nameEn,
tpa_mpt_credit = t1.tpa_mpt_credit,
tpa_mpt_remark = t1.tpa_mpt_remark,
mbm_name = t1.mbm_nameTh + "/" + t1.mbm_nameEn,
mpm_name = t1.mpm_nameTh + "/" + t1.mpm_nameEn,
mpr_name = t1.mpr_nameTh + "/" + t1.mpr_nameEn,
mpq_name = t1.mpq_nameTh + "/" + t1.mpq_nameEn,
tpa_mpq_credit = t1.tpa_mpq_credit,
mpn_name = t1.mpn_nameTh + "/" + t1.mpn_nameEn,
tpa_mpn_credit = t1.tpa_mpn_credit,
mrm_name = t1.mrm_nameTh + "/" + t1.mrm_nameEn,
tpa_coupon = t1.tpa_coupon,
coupon_name = (t1.tpa_coupon == 'I') ? "ให้" : "ไม่ให้",
tpa_coupon_remark = t1.tpa_coupon_remark,
}).ToList();
RepeaterPaymentType.DataSource = _paymentType;
RepeaterPaymentType.DataBind();
lblwelfare.Text = objcomp.tcd_family_welfare;
//condition service employee, executive (edit code by morn)
var objCond = (from mst_mcs in dbc.mst_condition_services
join trn_mcs in dbc.trn_condition_services on mst_mcs.mcs_id equals trn_mcs.mcs_id
where mst_mcs.mcs_status == 'A' && (trn_mcs.tcd_id == objcomp.tcd_id) && (trn_mcs.tcs_type == "EM" || trn_mcs.tcs_type == "EX")
select new
{
type = trn_mcs.tcs_type,
ename = mst_mcs.mcs_ename,
tname = mst_mcs.mcs_tname
}).ToList();
lblcond_service.Text = string.Join(", ", objCond.Where(x => x.type == "EM").Select(x => x.ename + '/' + x.tname));
lblcond_service_executive.Text = string.Join(", ", objCond.Where(x => x.type == "EX").Select(x => x.ename + '/' + x.tname));
List <trn_company_request_doctor> tcrd = dbc.trn_company_request_doctors.Where(x => x.tcd_id == objcomp.tcd_id).ToList();
lbldoctor.Text = String.Join(", ", tcrd.Select(x => x.tcr_doc_ename + '/' + x.tcr_doc_tname));
//doctor type (edit code by morn)
var objmdc = (from mst_mdc in dbc.mst_doctor_cats
join trn_mdc in dbc.trn_package_doctor_cats on mst_mdc.mdc_id equals trn_mdc.mdc_id
where trn_mdc.trn_package_detail.tcd_id == objcomp.tcd_id
select new
{
ename = mst_mdc.mdc_ename,
tname = mst_mdc.mdc_tname
}).ToList();
lbldoctor_type.Text = String.Join(", ", objmdc.Select(x => x.ename + '/' + x.tname));
/*
* if (objmdc != null)
* {
* lbldoctor_type.Text = objmdc.mdc_tname; // + "/" + objmdc.mdc_ename;
* }
*/
//สถานที่ตรวจ
var objchklocation = (from location in dbc.trn_checkup_locations
join mstlocation in dbc.mst_checkup_locations on location.mcl_id equals mstlocation.mcl_id
where location.tcd_id == objcomp.tcd_id
select new { tname_location = mstlocation.mcl_tname }).ToList();
if (objchklocation.Count > 0)
{
foreach (var data in objchklocation)
{
lblloc_remark.Text = objcomp.tcd_location_remark;
switch (data.tname_location)
{
case "IMS":
chkims.Checked = true;
break;
case "OBG":
chkbcancer.Checked = true;
break;
case "JMS":
chkjms.Checked = true;
break;
case "HPC1":
chkhpc1.Checked = true;
break;
case "HPC2":
chkhpc2.Checked = true;
break;
case "HPC3":
chkhpc3.Checked = true;
break;
default:
chkoth.Checked = true;
break;
}
}
}
//mtk staff name
var objtcp = (from tcp in dbc.trn_contact_persons
where tcp.tcd_id == objcomp.tcd_id && tcp.mst_contact_type.mct_code == 'M'
select new
{
mtk_name = tcp.tcp_name,
mtk_tel = tcp.tcp_tel,
mtk_fax = tcp.tcp_fax,
mtk_email = tcp.tcp_email
}).ToList();
if (objtcp.Count > 0)
{
RepeaterMTK.DataSource = objtcp;
RepeaterMTK.DataBind();
}
lbllastupdate.Text = String.Format("{0:dd/MM/yyyy}", objcomp.tcd_update_date);
lbllastupdateby.Text = objcomp.mul_user_login;
var objattach = Constant.GetObjAttachFile(objcomp.tcd_id, "CTC");//(from file in dbc.trn_attach_files where file.taf_user_type == 'H' && file.tcd_id == objcomp.tcd_id select new { file_name = file.taf_file_name, file_path = file.taf_path_name }).ToList();
if (objattach.Count > 0)
{
RepeaterFile.DataSource = objattach;
RepeaterFile.DataBind();
}
divremark.InnerHtml = Server.HtmlDecode(objcomp.tcd_remark);
//search name check
objnchk_list = (from tnc in dbc.trn_name_checks
where tnc.tcd_id == objcomp.tcd_id
select tnc).ToList();
if (objnchk_list != null)
{
RepeaterPatient.DataSource = objnchk_list;
RepeaterPatient.DataBind();
}
}
}
private void LoadData(int compid)
{
var objcomp = (from cus in dbc.trn_company_details where cus.tcd_id == compid select cus).FirstOrDefault(); //where form?
if (objcomp != null)
{
lblremark_compname_th.Text = objcomp.tcd_tname;
lblremark_compname_en.Text = objcomp.tcd_ename;
lblcompany_Code.Text = objcomp.tcd_code;
lbldeptowner.Text = objcomp.tcd_type;
lbDocumentNo.Text = objcomp.tcd_document_no;
lblcompany_th.Text = objcomp.tcd_tname;
lblcompany_en.Text = objcomp.tcd_ename;
//สถานที่ตรวจ
var objchklocation = (from location in dbc.trn_checkup_locations
join mstlocation in dbc.mst_checkup_locations on location.mcl_id equals mstlocation.mcl_id
where location.tcd_id == objcomp.tcd_id
select new { tname_location = mstlocation.mcl_tname }).ToList();
if (objchklocation.Count > 0)
{
lblloc_remark.Text = objcomp.tcd_location_remark;
foreach (var data in objchklocation)
{
lblnolocation.Text = "";
switch (data.tname_location)
{
case "IMS":
chkims.Checked = true;
chkims.Visible = true;
break;
case "OBG":
chkbcancer.Checked = true;
chkbcancer.Visible = true;
break;
case "JMS":
chkjms.Checked = true;
chkjms.Visible = true;
break;
case "HPC1":
chkhpc1.Checked = true;
chkhpc1.Visible = true;
break;
case "HPC2":
chkhpc2.Checked = true;
chkhpc2.Visible = true;
break;
case "HPC3":
chkhpc3.Checked = true;
chkhpc3.Visible = true;
break;
case "Other":
chkOth.Checked = true;
chkOth.Visible = true;
break;
}
}
}
else
{
lblnolocation.Text = "-";
}
lbldate_s_contract.Text = String.Format("{0:dd/MM/yyyy}", objcomp.tcd_date_from);
lbldate_e_contract.Text = String.Format("{0:dd/MM/yyyy}", objcomp.tcd_date_to);
//package and option Order set
var objpackage = (from package in dbc.trn_package_details
where package.tcd_id == objcomp.tcd_id
select new
{
package_order = package.tpd_order_desc,
package_price = package.tpd_price,
package_payment = (from mpt in dbc.mst_payment_types
where mpt.mpt_id == package.mpt_id
select mpt.mpt_tname).FirstOrDefault(),
package_credit = package.tpd_limit_credit,
package_s_date = String.Format("{0:dd/MM/yyyy}", package.tpd_date_from),
package_e_date = String.Format("{0:dd/MM/yyyy}", package.tpd_date_to),
package_type = package.tpd_order_type
}).ToList();
if (objpackage != null)
{
RepeaterPackage.DataSource = objpackage.Where(c => c.package_type == "Order Set");
RepeaterPackage.DataBind();
RepeaterOption.DataSource = objpackage.Where(c => c.package_type == "Option");
RepeaterOption.DataBind();
}
var old_paymentType = (from t1 in dbc.trn_payments
where t1.tcd_id == objcomp.tcd_id
select new
{
mst_id = t1.mst_id,
mst_nameTh = (t1.mst_type != null) ? t1.mst_type.mst_tname : "",
mst_nameEn = (t1.mst_type != null) ? t1.mst_type.mst_ename : "",
mpt_id = t1.mpt_id,
mpt_nameTh = (t1.mst_payment_type != null) ? t1.mst_payment_type.mpt_tname : "",
mpt_nameEn = (t1.mst_payment_type != null) ? t1.mst_payment_type.mpt_ename : "",
tpa_mpt_credit = t1.tpa_mpt_credit,
tpa_mpt_remark = t1.tpa_mpt_remark,
mbm_id = t1.mbm_id,
mbm_nameTh = (t1.mst_billing_method != null) ? t1.mst_billing_method.mbm_tname : "",
mbm_nameEn = (t1.mst_billing_method != null) ? t1.mst_billing_method.mbm_ename : "",
mpm_id = t1.mpm_id,
mpm_nameTh = (t1.mst_payment_main != null) ? t1.mst_payment_main.mpm_tname : "",
mpm_nameEn = (t1.mst_payment_main != null) ? t1.mst_payment_main.mpm_ename : "",
mpr_id = t1.mpr_id,
mpr_nameTh = (t1.mst_payment_rate != null) ? t1.mst_payment_rate.mpr_tname : "",
mpr_nameEn = (t1.mst_payment_rate != null) ? t1.mst_payment_rate.mpr_ename : "",
mpq_id = t1.mpq_id,
mpq_nameTh = (t1.mst_payment_quatation != null) ? t1.mst_payment_quatation.mpq_tname : "",
mpq_nameEn = (t1.mst_payment_quatation != null) ? t1.mst_payment_quatation.mpq_ename : "",
tpa_mpq_credit = t1.tpa_mpq_credit,
mpn_id = t1.mpn_id,
mpn_nameTh = (t1.mst_payment_nquatation != null) ? t1.mst_payment_nquatation.mpn_tname : "",
mpn_nameEn = (t1.mst_payment_nquatation != null) ? t1.mst_payment_nquatation.mpn_ename : "",
tpa_mpn_credit = t1.tpa_mpn_credit,
mrm_id = t1.mrm_id,
mrm_nameTh = (t1.mst_receive_medicine != null) ? t1.mst_receive_medicine.mrm_tname : "",
mrm_nameEn = (t1.mst_receive_medicine != null) ? t1.mst_receive_medicine.mrm_ename : "",
tpa_coupon = t1.tpa_coupon,
coupon_name = (t1.tpa_coupon == 'I') ? "ให้" : "ไม่ให้",
tpa_coupon_remark = t1.tpa_coupon_remark,
Status = "O",
tpa_id = t1.tpa_id
}).ToList();
_paymentType = (from t1 in old_paymentType
select new PaymentType_hpc
{
mst_name = t1.mst_nameTh + "/" + t1.mst_nameEn,
mpt_name = t1.mpt_nameTh + "/" + t1.mpt_nameEn,
tpa_mpt_credit = t1.tpa_mpt_credit,
tpa_mpt_remark = t1.tpa_mpt_remark,
mbm_name = t1.mbm_nameTh + "/" + t1.mbm_nameEn,
mpm_name = t1.mpm_nameTh + "/" + t1.mpm_nameEn,
mpr_name = t1.mpr_nameTh + "/" + t1.mpr_nameEn,
mpq_name = t1.mpq_nameTh + "/" + t1.mpq_nameEn,
tpa_mpq_credit = t1.tpa_mpq_credit,
mpn_name = t1.mpn_nameTh + "/" + t1.mpn_nameEn,
tpa_mpn_credit = t1.tpa_mpn_credit,
mrm_name = t1.mrm_nameTh + "/" + t1.mrm_nameEn,
tpa_coupon = t1.tpa_coupon,
coupon_name = (t1.tpa_coupon == 'I') ? "ให้" : "ไม่ให้",
tpa_coupon_remark = t1.tpa_coupon_remark,
}).ToList();
RepeaterPaymentType.DataSource = _paymentType;
RepeaterPaymentType.DataBind();
lblpayor.Text = objcomp.tcd_payor;
//condition service employee
var objmcs = (from mst_mcs in dbc.mst_condition_services
join trn_mcs in dbc.trn_condition_services on mst_mcs.mcs_id equals trn_mcs.mcs_id
where mst_mcs.mcs_status == 'A' && (trn_mcs.tcd_id == objcomp.tcd_id) && (trn_mcs.tcs_type == "EM" || trn_mcs.tcs_type == "EX")
select new{
Namex = mst_mcs.mcs_tname + "/" + mst_mcs.mcs_ename,
Typex = trn_mcs.tcs_type
}).ToList();
if (objmcs.Count > 0)
{
foreach (var data in objmcs)
{
if (data.Typex == "EM")
{
if (lblcondition_service.Text == "")
{
lblcondition_service.Text += data.Namex;
}
else
{
lblcondition_service.Text += "," + data.Namex;
}
}
if (data.Typex == "EX")
{
if (lblcondition_serviceEmployee.Text == "")
{
lblcondition_serviceEmployee.Text += data.Namex;
}
else
{
lblcondition_serviceEmployee.Text += "," + data.Namex;
}
}
}
}
//family welfa
lblfam_welfa.Text = objcomp.tcd_family_welfare;
//contact
var objcontact = (from tcp in dbc.trn_contact_persons
where tcp.mst_contact_type.mct_code == 'C' && tcp.tcd_id == objcomp.tcd_id
select new
{
contact_name = tcp.tcp_name,
contact_tel = tcp.tcp_tel,
contact_fax = tcp.tcp_fax,
contact_email = tcp.tcp_email
}).ToList();
if (objcontact.Count > 0)
{
RepeaterContact.DataSource = objcontact;
RepeaterContact.DataBind();
}
lblresult_address.Text = objcomp.tcd_address;
lblresult_subdistrict.Text = objcomp.tcd_district;
lblresult_district.Text = objcomp.tcd_tambon;
lblresult_province.Text = objcomp.tcd_province;
lblresult_zipcode.Text = objcomp.tcd_postcode;
//List<string>
List <string> medicalRpt = (from tmr in dbc.trn_medical_reports
join mmr in dbc.mst_medical_reports
on tmr.mmr_id equals mmr.mmr_id
where tmr.tcd_id == compid
select(mmr.mmr_tname.Trim() + "/" + mmr.mmr_ename.Trim()) + " " + tmr.tmr_rep_remark).ToList();
lblresult.Text = string.Join(", ", medicalRpt);
switch (objcomp.tcd_send_rep_real)
{
case "Y":
lblsend_ref_real.Text = "รับกลับ";
break;
case "N":
lblsend_ref_real.Text = "ไม่รับกลับ";
if (objcomp.tcd_send_rep_flag == "C")
{
lblsend_ref_real.Text += "(ส่งบริษัท)";
}
else
{
lblsend_ref_real.Text += "(ส่งบ้าน)";
}
break;
}
switch (objcomp.tcd_send_rep_copy)
{
case "H":
lblsend_rep_copy.Text = "ส่งบ้าน";
break;
case "N":
lblsend_rep_copy.Text = "ไม่ต้องการ";
break;
case "C":
lblsend_rep_copy.Text = "ส่งบริษัท";
break;
}
//emp mtk name
var objtcp = (from tcp in dbc.trn_contact_persons
where tcp.tcd_id == objcomp.tcd_id && tcp.mst_contact_type.mct_code == 'M'
select new
{
mtk_name = tcp.tcp_name,
mtk_tel = tcp.tcp_tel,
mtk_fax = tcp.tcp_fax,
mtk_email = tcp.tcp_email
}).ToList();
if (objtcp.Count > 0)
{
RepeaterMTK.DataSource = objtcp;
RepeaterMTK.DataBind();
}
lbllastupdate.Text = String.Format("{0:dd/MM/yyyy}", objcomp.tcd_update_date);
lblupdatebyname.Text = objcomp.mul_user_login;
//attach file
var objattach = Constant.GetObjAttachFile(objcomp.tcd_id, "HPC");//(from file in dbc.trn_attach_files where file.taf_user_type == 'H' && file.tcd_id == objcomp.tcd_id select new { file_name = file.taf_file_name, file_path = file.taf_path_name }).ToList();
if (objattach.Count > 0)
{
RepeaterFile.DataSource = objattach;
RepeaterFile.DataBind();
}
divremark.InnerHtml = Server.HtmlDecode(objcomp.tcd_remark);
//search name check
objnchk_list = (from tnc in dbc.trn_name_checks
where tnc.tcd_id == objcomp.tcd_id
select tnc).ToList();
if (objnchk_list != null)
{
RepeaterPatient.DataSource = objnchk_list;
RepeaterPatient.DataBind();
}
}
}
private void LoadData(int compid)
{
//,DateTime compdateform,int type
//sel company detail from code
//&& (cus.tcd_date_from >= compdateform && cus.tcd_date_to <= compdateform) && cus.mst_id == type
var objcomp = (from cus in dbc.trn_company_details
where cus.tcd_id == compid
select cus).FirstOrDefault(); //where form?
if (objcomp != null)
{
lblremark_compname_th.Text = objcomp.tcd_tname;
lblremark_compname_en.Text = objcomp.tcd_ename;
lbldoccode.Text = objcomp.tcd_document_no;
lblcompcode.Text = objcomp.tcd_code;
lblcompany_th.Text = objcomp.tcd_tname;
lblcompany_en.Text = objcomp.tcd_ename;
lbldeptowner.Text = objcomp.tcd_type;
lblcompany_address.Text = objcomp.tcd_address;
lblcompany_amphur.Text = objcomp.tcd_district;
lblcompany_tumbon.Text = objcomp.tcd_tambon;
lblcompany_province.Text = objcomp.tcd_province;
lblcompany_postcode.Text = objcomp.tcd_postcode;
//contact
var objcontact = (from tcp in dbc.trn_contact_persons
where tcp.mst_contact_type.mct_code == 'C' && tcp.tcd_id == objcomp.tcd_id
select new { contact_name = tcp.tcp_name,
contact_tel = tcp.tcp_tel,
contact_fax = tcp.tcp_fax,
contact_email = tcp.tcp_email }).ToList();
if (objcontact.Count > 0)
{
RepeaterContact.DataSource = objcontact;
RepeaterContact.DataBind();
}
//emp mtk name
var objtcp = (from tcp in dbc.trn_contact_persons
where tcp.tcd_id == objcomp.tcd_id && tcp.mst_contact_type.mct_code == 'M'
select new
{
mtk_name = tcp.tcp_name,
mtk_tel = tcp.tcp_tel,
mtk_fax = tcp.tcp_fax,
mtk_email = tcp.tcp_email
}).ToList();
if (objtcp.Count > 0)
{
RepeaterMTK.DataSource = objtcp;
RepeaterMTK.DataBind();
}
lblcontact_s.Text = String.Format("{0:dd/MM/yyyy}", objcomp.tcd_date_from);
lblcontact_e.Text = String.Format("{0:dd/MM/yyyy}", objcomp.tcd_date_to);
lblpayor.Text = objcomp.tcd_payor;
//plan
var objplan = (from plan in dbc.trn_plans where plan.tcd_id == objcomp.tcd_id select new { plan_name = plan.tpl_name, plan_action = "..." }).ToList();
if (objplan.Count > 0)
{
RepeaterPlan.DataSource = objplan;
RepeaterPlan.DataBind();
}
//comp name billing
lblcomp_name_bill.Text = objcomp.tcd_bill_company;
//comp address billing
lblcomp_addr_bill.Text = objcomp.tcd_bill_address + " " + objcomp.tcd_bill_tambon + " " + objcomp.tcd_bill_district + " " + objcomp.tcd_bill_province + " " + objcomp.tcd_bill_postcode;
//contact person billing
var objcontactbill = (from tcp in dbc.trn_contact_persons
where tcp.mst_contact_type.mct_code == 'B' && tcp.tcd_id == objcomp.tcd_id
select new { contact_bill_name = tcp.tcp_name,
contact_bill_tel = tcp.tcp_tel,
contact_bill_fax = tcp.tcp_fax,
contact_bill_email = tcp.tcp_email }).ToList();
if (objcontactbill.Count > 0)
{
RepeaterContactBill.DataSource = objcontactbill;
RepeaterContactBill.DataBind();
}
var old_paymentType = (from t1 in dbc.trn_payments
where t1.tcd_id == objcomp.tcd_id
select new
{
mst_id = t1.mst_id,
mst_nameTh = (t1.mst_type != null) ? t1.mst_type.mst_tname : "",
mst_nameEn = (t1.mst_type != null) ? t1.mst_type.mst_ename : "",
mpt_id = t1.mpt_id,
mpt_nameTh = (t1.mst_payment_type != null) ? t1.mst_payment_type.mpt_tname : "",
mpt_nameEn = (t1.mst_payment_type != null) ? t1.mst_payment_type.mpt_ename : "",
tpa_mpt_credit = t1.tpa_mpt_credit,
tpa_mpt_remark = t1.tpa_mpt_remark,
mbm_id = t1.mbm_id,
mbm_nameTh = (t1.mst_billing_method != null) ? t1.mst_billing_method.mbm_tname : "",
mbm_nameEn = (t1.mst_billing_method != null) ? t1.mst_billing_method.mbm_ename : "",
mpm_id = t1.mpm_id,
mpm_nameTh = (t1.mst_payment_main != null) ? t1.mst_payment_main.mpm_tname : "",
mpm_nameEn = (t1.mst_payment_main != null) ? t1.mst_payment_main.mpm_ename : "",
mpr_id = t1.mpr_id,
mpr_nameTh = (t1.mst_payment_rate != null) ? t1.mst_payment_rate.mpr_tname : "",
mpr_nameEn = (t1.mst_payment_rate != null) ? t1.mst_payment_rate.mpr_ename : "",
mpq_id = t1.mpq_id,
mpq_nameTh = (t1.mst_payment_quatation != null) ? t1.mst_payment_quatation.mpq_tname : "",
mpq_nameEn = (t1.mst_payment_quatation != null) ? t1.mst_payment_quatation.mpq_ename : "",
tpa_mpq_credit = t1.tpa_mpq_credit,
mpn_id = t1.mpn_id,
mpn_nameTh = (t1.mst_payment_nquatation != null) ? t1.mst_payment_nquatation.mpn_tname : "",
mpn_nameEn = (t1.mst_payment_nquatation != null) ? t1.mst_payment_nquatation.mpn_ename : "",
tpa_mpn_credit = t1.tpa_mpn_credit,
mrm_id = t1.mrm_id,
mrm_nameTh = (t1.mst_receive_medicine != null) ? t1.mst_receive_medicine.mrm_tname : "",
mrm_nameEn = (t1.mst_receive_medicine != null) ? t1.mst_receive_medicine.mrm_ename : "",
tpa_coupon = t1.tpa_coupon,
coupon_name = (t1.tpa_coupon == 'I') ? "ให้" : "ไม่ให้",
tpa_coupon_remark = t1.tpa_coupon_remark,
Status = "O",
tpa_id = t1.tpa_id
}).ToList();
_paymentType = (from t1 in old_paymentType
select new PaymentType
{
mst_name = t1.mst_nameTh + "/" + t1.mst_nameEn,
mpt_name = t1.mpt_nameTh + "/" + t1.mpt_nameEn,
tpa_mpt_credit = t1.tpa_mpt_credit,
tpa_mpt_remark = t1.tpa_mpt_remark,
mbm_name = t1.mbm_nameTh + "/" + t1.mbm_nameEn,
mpm_name = t1.mpm_nameTh + "/" + t1.mpm_nameEn,
mpr_name = t1.mpr_nameTh + "/" + t1.mpr_nameEn,
mpq_name = t1.mpq_nameTh + "/" + t1.mpq_nameEn,
tpa_mpq_credit = t1.tpa_mpq_credit,
mpn_name = t1.mpn_nameTh + "/" + t1.mpn_nameEn,
tpa_mpn_credit = t1.tpa_mpn_credit,
mrm_name = t1.mrm_nameTh + "/" + t1.mrm_nameEn,
tpa_coupon = t1.tpa_coupon,
coupon_name = (t1.tpa_coupon == 'I') ? "ให้" : "ไม่ให้",
tpa_coupon_remark = t1.tpa_coupon_remark,
}).ToList();
RepeaterPaymentType.DataSource = _paymentType;
RepeaterPaymentType.DataBind();
//package and option Order set
var objpackage = (from package in dbc.trn_package_details
where package.tcd_id == objcomp.tcd_id
select new
{
package_order = package.tpd_order_desc,
package_price = package.tpd_price,
package_payment = (from mpt in dbc.mst_payment_types
where mpt.mpt_id == package.mpt_id
select mpt.mpt_tname).FirstOrDefault(),
package_credit = package.tpd_limit_credit,
package_s_date = String.Format("{0:dd/MM/yyyy}", package.tpd_date_from),
package_e_date = String.Format("{0:dd/MM/yyyy}", package.tpd_date_to),
package_type = package.tpd_order_type
}).ToList();
if (objpackage != null)
{
RepeaterPackage.DataSource = objpackage.Where(c => c.package_type == "Order Set");
RepeaterPackage.DataBind();
RepeaterOption.DataSource = objpackage.Where(c => c.package_type == "Option");
RepeaterOption.DataBind();
}
//condition service employee, executive (edit code by morn)
var objCond = (from mst_mcs in dbc.mst_condition_services
join trn_mcs in dbc.trn_condition_services on mst_mcs.mcs_id equals trn_mcs.mcs_id
where mst_mcs.mcs_status == 'A' && (trn_mcs.tcd_id == objcomp.tcd_id) && (trn_mcs.tcs_type == "EM" || trn_mcs.tcs_type == "EX")
select new
{
type = trn_mcs.tcs_type,
ename = mst_mcs.mcs_ename,
tname = mst_mcs.mcs_tname
}).ToList();
lblcondition_emp.Text = string.Join(", ", objCond.Where(x => x.type == "EM").Select(x => x.ename + '/' + x.tname));
lblcondition_exec.Text = string.Join(", ", objCond.Where(x => x.type == "EX").Select(x => x.ename + '/' + x.tname));
var objattach = Constant.GetObjAttachFile(objcomp.tcd_id, "CLT");//(from file in dbc.trn_attach_files where file.taf_user_type == 'H' && file.tcd_id == objcomp.tcd_id select new { file_name = file.taf_file_name, file_path = file.taf_path_name }).ToList();
if (objattach.Count > 0)
{
RepeaterFile.DataSource = objattach;
RepeaterFile.DataBind();
}
divremark.InnerHtml = Server.HtmlDecode(objcomp.tcd_remark);
lbllastupdate.Text = String.Format("{0:dd/MM/yyyy}", objcomp.tcd_update_date);
lbllastupdateby.Text = objcomp.mul_user_login;
//search name check
objnchk_list = (from tnc in dbc.trn_name_checks
where tnc.tcd_id == objcomp.tcd_id
select tnc).ToList();
if (objnchk_list != null)
{
//objnchk_list = objnchk_list;
RepeaterPatient.DataSource = objnchk_list;
RepeaterPatient.DataBind();
}
}
}