private void ClearContent() { txtcompany_code.Text = String.Empty; txtname_th.Text = String.Empty; txtname_en.Text = String.Empty; txtlegal.Text = String.Empty; txtaddress.Text = String.Empty; txtsubdistrict.Text = String.Empty; txtdistrict.Text = String.Empty; txtpostcode.Text = String.Empty; txtprovince.Text = String.Empty; txttelephone.Text = String.Empty; txtfax.Text = String.Empty; txtemail.Text = String.Empty; txtsearch.Text = String.Empty; //lblStatus.Text = ""; //lblStatus.Visible = false; PanelContent.Enabled = false; btnedit.Enabled = false; _objdelcontact = null; _objaddcontact = null; _objaddcontact = new List <AddContact>(); _objdelcontact = new List <Delcontact>(); RepeaterContact.DataSource = _objaddcontact; RepeaterContact.DataBind(); }
protected void RepeaterContact_ItemCommand(object source, RepeaterCommandEventArgs e) { switch (e.CommandName) { case "Edit": HiddenFieldRowContact.Value = e.Item.ItemIndex.ToString(); ddltype.SelectedValue = ((HiddenField)e.Item.FindControl("HiddenFieldType")).Value; ddlcontact_type.SelectedValue = ((HiddenField)e.Item.FindControl("HiddenFieldTypeId")).Value; txtcontact_person.Text = ((Label)e.Item.FindControl("lblcontact_name")).Text; txtcontact_person_tel.Text = ((Label)e.Item.FindControl("lblcontact_tel")).Text; txtcontact_fax.Text = ((Label)e.Item.FindControl("lblcontact_fax")).Text; txtcontact_person_email.Text = ((Label)e.Item.FindControl("lblcontact_email")).Text; btncontact_add.Text = "แก้ไข"; break; case "Del": _objdelcontact.Add(new Delcontact { contact_id = Convert.ToInt16(((HiddenField)e.Item.FindControl("HiddenFieldContact_id")).Value) }); _objaddcontact.RemoveAt(e.Item.ItemIndex); RepeaterContact.DataSource = _objaddcontact; RepeaterContact.DataBind(); break; } }
protected void btncontact_add_Click(object sender, EventArgs e) { if (HiddenFieldRowContact.Value == "-1") { _objaddcontact.Add(new AddContact() { contact_type_id = Convert.ToInt16(ddlcontact_type.SelectedValue), type_id = Convert.ToInt16(ddltype.SelectedValue), type_name = ddltype.SelectedItem.Text, contact_type = ddlcontact_type.SelectedItem.Text, contact_id = 0, contact_name = txtcontact_person.Text, contact_tel = txtcontact_person_tel.Text, contact_email = txtcontact_person_email.Text, contact_fax = txtcontact_fax.Text }); } else { _objaddcontact[Convert.ToInt16(HiddenFieldRowContact.Value)].type_id = Convert.ToInt16(ddltype.SelectedValue); _objaddcontact[Convert.ToInt16(HiddenFieldRowContact.Value)].type_name = ddltype.SelectedItem.Text; _objaddcontact[Convert.ToInt16(HiddenFieldRowContact.Value)].contact_type_id = Convert.ToInt16(ddlcontact_type.SelectedValue); _objaddcontact[Convert.ToInt16(HiddenFieldRowContact.Value)].contact_type = ddlcontact_type.SelectedItem.Text; _objaddcontact[Convert.ToInt16(HiddenFieldRowContact.Value)].contact_name = txtcontact_person.Text; _objaddcontact[Convert.ToInt16(HiddenFieldRowContact.Value)].contact_tel = txtcontact_person_tel.Text; _objaddcontact[Convert.ToInt16(HiddenFieldRowContact.Value)].contact_fax = txtcontact_fax.Text; _objaddcontact[Convert.ToInt16(HiddenFieldRowContact.Value)].contact_email = txtcontact_person_email.Text; HiddenFieldRowContact.Value = "-1"; btncontact_add.Text = "เพิ่ม"; } RepeaterContact.DataSource = _objaddcontact; RepeaterContact.DataBind(); ClearContact(); }
private void LoadDataContact(int mco_id) { _objaddcontact = new List <AddContact>(); var objcontact = (from contact in dbc.mst_contact_persons where contact.mco_id.Equals(mco_id) select contact).ToList(); foreach (var data in objcontact) { _objaddcontact.Add(new AddContact() { contact_type_id = (int)data.mct_id, type_id = (int)data.mst_id, type_name = LoadType((int)data.mst_id), contact_type = LoadContactType((int)data.mct_id), contact_id = data.mcp_id, contact_name = data.mcp_name, contact_tel = data.mcp_tel, contact_email = data.mcp_email, contact_fax = data.mcp_fax }); } RepeaterContact.DataSource = _objaddcontact; RepeaterContact.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(); } } }