public void BindGrid()
        {
            DataSet  ds = NegahdariClass.GetList(null, null, null, null, null);
            DataView dv = new DataView(ds.Tables[0]);

            //if (Securenamespace.SecureData.CheckSecurity(ViewState["Negahdari"].ToString()) == null)
            //{
            //    ViewState["Negahdari"] = "id Desc";
            //}
            //dv.Sort = Securenamespace.SecureData.CheckSecurity(ViewState["Negahdari"].ToString()).ToString();
            GridView1.DataSource = dv;
            GridView1.DataBind();
        }
        protected void BtnSerach_Click1(object sender, EventArgs e)
        {
            DataSet  ds      = NegahdariClass.GetList(null, null, null, null, null);
            DataView dv      = new DataView(ds.Tables[0]);
            String   StrSort = Securenamespace.SecureData.CheckSecurity(ViewState["Negahdari"].ToString());

            if (StrSort != null)
            {
                dv.Sort = StrSort;
            }
            GridView1.DataSource = dv;
            GridView1.DataBind();
        }
        public void DeleteItem(object sender, System.EventArgs e)
        {
            String id = ((HtmlAnchor)sender).HRef.ToString();
            int    i  = NegahdariClass.Delete(Convert.ToInt32(id));

            if (i == 0)
            {
                LblMsg.Text = " error ";
                ScriptManager.RegisterClientScriptBlock(Page, Page.GetType(), Guid.NewGuid().ToString(), "alert('خطا در حذف');", true);
            }
            else
            {
                BindGrid();
            }
            LightBox.Value = "0";
        }
        protected void BtnUpdate_Click1(object sender, EventArgs e)
        {
            int i = NegahdariClass.Update(TXTid.Text, TXTTekrarSalane.Text, TXTmony.Text.Replace(",", "").ToString(), DDAmaliatTypeId.SelectedValue.ToString(), DDyear.SelectedValue.ToString());

            if (i == 0)
            {
                LblMsg.ForeColor = System.Drawing.Color.Red;
                LblMsg.Text      = "خطا";
            }
            else
            {
                LblMsg.ForeColor = System.Drawing.Color.Green;
                LblMsg.Text      = "ویرایش انجام شد";
                BindGrid();
            }
        }
        protected void BtnInsert_Click(Object sender, System.EventArgs e)
        {
            int t = NegahdariClass.insert(TXTTekrarSalane.Text, TXTmony.Text.Replace(",", "").ToString(), DDAmaliatTypeId.SelectedValue.ToString(), DDyear.SelectedValue.ToString());

            if (t == 0)
            {
                LblMsg.ForeColor = System.Drawing.Color.Red;
                LblMsg.Text      = "خطا در ثبت";
            }
            else
            {
                LblMsg.ForeColor = System.Drawing.Color.Green;
                LblMsg.Text      = "ثبت  انجام شد.";
                BindGrid();
            }
        }
        public void UpItem(object sender, EventArgs e)
        {
            String  id = ((HtmlAnchor)sender).HRef.ToString();
            DataSet ds = NegahdariClass.GetList(id, null, null, null, null);
            DataRow dr = ds.Tables[0].Rows[0];

            TXTid.Text                    = id;
            TXTmony.Text                  = dr["mony"].ToString();
            TXTTekrarSalane.Text          = dr["TekrarSalane"].ToString();
            DDyear.SelectedValue          = dr["year"].ToString();
            DDAmaliatTypeId.SelectedValue = dr["AmaliatTypeId"].ToString();

            EmptyLight();
            LightBox.Value    = "1";
            BtnInsert.Visible = false;
            BtnSerach.Visible = false;
            BtnUpdate.Visible = true;
        }