public string GetCompanyName(int CodePeigiri) { string msg = "0"; if (new MainDataModuleTableAdapters.tbl_ones_haghighiTableAdapter().GetDataBy4(CodePeigiri).Rows.Count != 0) { DataRow dr = new MainDataModuleTableAdapters.tbl_ones_haghighiTableAdapter().GetDataBy4(CodePeigiri)[0]; XmlDocument doc_address = new XmlDocument(); doc_address.InnerXml = dr["oh_personal_inf"].ToString(); XmlNode xnl = doc_address.ChildNodes[0]; XmlNode xms = xnl.ChildNodes[2]; msg = xms.InnerText; } else { if (new MainDataModuleTableAdapters.tbl_ones_hoghoghiTableAdapter().GetDataBy3(CodePeigiri).Rows.Count != 0) { DataRow dr = new MainDataModuleTableAdapters.tbl_ones_hoghoghiTableAdapter().GetDataBy3(CodePeigiri)[0]; msg = dr["oho_name"].ToString(); } } return msg; }
protected void btn_add_new_person_Click(object sender, EventArgs e) { /**/ // فیلدهای ثابت بروز می شوند // جداول خارجی فیلدها حذف شده و مجددا ایجاد می شوند try { XmlDocument doc_person = new XmlDocument(); XmlDocument doc_address = new XmlDocument(); doc_person.InnerXml = pnl_personal_information_form1.get_frm_xml_with_value(); doc_address.InnerXml = pnl_address_information_form1.get_frm_xml_with_value(); if (txt_oh_international_code.Text == "") { txt_oh_international_code.Text = pnl_personal_information_form1.GetInternationalCode(); } string idcode = ""; if (Session["IsInEditingMode"] != null) { string cdpeig = Session["IsInEditingMode"].ToString(); new MainDataModuleTableAdapters.tbl_ones_haghighiTableAdapter().Update ( txt_oh_international_code.Text, Convert.ToInt32(drp_oh_link_to_context_of_activity.SelectedValue), Convert.ToInt32(DropDownList1.SelectedValue), txt_oh_tax_code.Text, txt_oh_insurace_kargah.Text, doc_address.InnerXml, doc_person.InnerXml, Convert.ToInt32(cdpeig) ); frm_one_add_utilities1.update(cdpeig); frm_one_employers1.update(cdpeig); frm_one_equipments_in_hand1.update(cdpeig); idcode = cdpeig; } else { new MainDataModuleTableAdapters.tbl_ones_haghighiTableAdapter().Insert( txt_oh_international_code.Text, Convert.ToInt32(drp_oh_link_to_context_of_activity.SelectedValue), Convert.ToInt32(DropDownList1.SelectedValue), txt_oh_tax_code.Text, txt_oh_insurace_kargah.Text, doc_address.InnerXml, doc_person.InnerXml); idcode = new MainDataModuleTableAdapters.tbl_ones_haghighiTableAdapter().Get_id_from_international_code(txt_oh_international_code.Text).Value.ToString(); frm_one_add_utilities1.insert(idcode); frm_one_employers1.insert(idcode); frm_one_equipments_in_hand1.insert(idcode); } string ur = "http://" + Request.Url.Authority; for (int i = 0; (i + 1) < Request.Url.Segments.Length; i++) { ur += Request.Url.Segments[i]; } string srf = ur; //ur = "http://*****:*****@"" + cmplurl); //websiteToImage.Generate(); // ScriptManager.RegisterClientScriptBlock(this, Page.GetType(), "j01", "window.open('" + srf + "uploadedfiles/" + crf + "','_blank')", true); ScriptManager.RegisterClientScriptBlock(this, Page.GetType(), "j01", "window.open('" + ur + "','_blank');window.location.href=window.location.href;", true); //*Response.Redirect(Request.Url.AbsoluteUri); // ScriptManager.RegisterStartupScript(this, this.GetType(), "j03", "alert('ثبت گردید');", true); } catch (Exception __e) { string errmsg = __e.Message; errmsg = errmsg.Replace("'", " "); new main_class().execute_command("insert into tbl_errors(e_err,e_uri) values ('" + errmsg + "','" + Request.Url.AbsoluteUri + "')"); ScriptManager.RegisterStartupScript(this, this.GetType(), "j03", "alert('لطفا در ورود کد ملی دقت نمایید');", true); } }