Beispiel #1
0
    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;
    }
Beispiel #2
0
    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);

        }
    }