protected void Btn_Sodor_Click(object sender, EventArgs e)
        {
            if (Lts_Inherited.Tb_Inquiries.SingleOrDefault(n => n.Tb_InquiryType.xInqType.Contains("مالیات") && n.xDedId_fk == Tb_Dead1.xDedId_pk) != null)
            {
                Lbl_Msg.Text      = "!استعلام صادر گردیده است";
                Lbl_Msg.Visible   = true;
                Lbl_Msg.ForeColor = System.Drawing.Color.Red;
                return;
            }
            Tb_InquiryType Tb_InquiryType1 = Lts_Inherited.Tb_InquiryTypes.SingleOrDefault(n => n.xInqType.Contains("مالیات"));

            Tb_Inquiry Tb_Inquiry1 = new Tb_Inquiry();

            Tb_Inquiry1.Tb_Dead = Tb_Dead1;
            //Tb_Inquiry1.xInqDate = Class_ShamsiDateTime.MilladiToShamsi(DateTime.Now.Date).ToString();
            Tb_Inquiry1.xInqDate       = Tdp_InqDate.Date;
            Tb_Inquiry1.xInqRegNo      = Txt_InqNo.Text;
            Tb_Inquiry1.Tb_InquiryType = Tb_InquiryType1;
            Lts_Inherited.Tb_Inquiries.InsertOnSubmit(Tb_Inquiry1);

            foreach (ListItem EstItem in Chk_Estates.Items)
            {
                if (EstItem.Selected)
                {
                    Tb_InqEstate Tb_InqEstate1 = new Tb_InqEstate();
                    Tb_InqEstate1.Tb_Inquiry = Tb_Inquiry1;
                    Tb_InqEstate1.xEstId_fk  = int.Parse(EstItem.Value);
                    Lts_Inherited.Tb_InqEstates.InsertOnSubmit(Tb_InqEstate1);
                }
            }
            try
            {
                Lts_Inherited.SubmitChanges();
                Session["Office_DeadId"]   = Tb_Dead1.xDedId_pk.ToString();
                Session["Office_InqDate"]  = Tb_Inquiry1.xInqDate;
                Session["Office_InqNo"]    = Tb_Inquiry1.xInqRegNo;
                Session["Office_Name"]     = Txt_Office.Text;
                Session["Office_EstateId"] = null;
                foreach (ListItem EstItem in Chk_Estates.Items)
                {
                    if (EstItem.Selected)
                    {
                        Session["Office_EstateId"] += EstItem.Value + "&";
                    }
                }
                Response.Redirect("~/Int_Inquiries/TaxOffice/Rpt_TaxOffice.aspx", true);
            }
            catch
            {
                Alarm.ShowMesseage("!خطا", this.Page);
            }
        }
        protected void Btn_Sodor_Click(object sender, EventArgs e)
        {
            if (Lts_Inherited.Tb_Inquiries.SingleOrDefault(n => n.Tb_InquiryType.xInqType.Contains("اسناد") && n.xDedId_fk == Tb_Dead1.xDedId_pk) != null)
            {
                Lbl_Msg.Text      = "!استعلام صادر گردیده است";
                Lbl_Msg.Visible   = true;
                Lbl_Msg.ForeColor = System.Drawing.Color.Red;
                return;
            }
            Tb_InquiryType Tb_InquiryType1 = Lts_Inherited.Tb_InquiryTypes.SingleOrDefault(n => n.xInqType.Contains("اسناد"));

            Tb_Inquiry Tb_Inquiry1 = new Tb_Inquiry();

            Tb_Inquiry1.Tb_Dead = Tb_Dead1;
            //Tb_Inquiry1.xInqDate = Class_ShamsiDateTime.MilladiToShamsi(DateTime.Now.Date).ToString();
            Tb_Inquiry1.xInqDate       = Tdp_InqDate.Date;
            Tb_Inquiry1.xInqRegNo      = Txt_InqNo.Text;
            Tb_Inquiry1.Tb_InquiryType = Tb_InquiryType1;
            Lts_Inherited.Tb_Inquiries.InsertOnSubmit(Tb_Inquiry1);

            foreach (ListItem EstItem in Chk_Estates.Items)
            {
                if (EstItem.Selected)
                {
                    Tb_InqEstate Tb_InqEstate1 = new Tb_InqEstate();
                    Tb_InqEstate1.Tb_Inquiry = Tb_Inquiry1;
                    Tb_InqEstate1.xEstId_fk  = int.Parse(EstItem.Value);
                    Lts_Inherited.Tb_InqEstates.InsertOnSubmit(Tb_InqEstate1);
                }
            }
            try
            {
                Lts_Inherited.SubmitChanges();
                Session["Asnad_DeadId"]   = Tb_Dead1.xDedId_pk.ToString();
                Session["Asnad_EstateId"] = null;
                Session["Asnad_InqDate"]  = Tdp_InqDate.Date;
                Session["Asnad_InqNo"]    = Txt_InqNo.Text;

                foreach (ListItem EstItem in Chk_Estates.Items)
                {
                    if (EstItem.Selected)
                    {
                        Session["Asnad_EstateId"] += EstItem.Value + "&";
                    }
                }
            }
            catch
            {
                Alarm.ShowMesseage("!خطا", this.Page);
            }

            List <Tb_Inquiry> Lst_Inquiries = Lts_Inherited.Tb_Inquiries.Where(n => n.Tb_InquiryType.xInqType.Contains("اسناد") &&
                                                                               n.xDedId_fk == Tb_Dead1.xDedId_pk).ToList();

            Gvw_InqAsnad.DataSource = Lst_Inquiries;
            Gvw_InqAsnad.DataBind();
            Gvw_InqAsnad.Visible = true;

            Lbl_Msg.Text      = "استعلام صادر گردید ";
            Lbl_Msg.Visible   = true;
            Lbl_Msg.ForeColor = System.Drawing.Color.Green;

            Txt_InqNo.Text   = "";
            Tdp_InqDate.Text = "";
            foreach (ListItem item in Chk_Estates.Items)
            {
                item.Selected = false;
            }
        }