using System;
using System.Collections.Generic;
using System.Configuration;
using System.Data;
using System.Data.SqlClient;
using System.Linq;
using System.Runtime.Remoting.Contexts;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;

namespace Newdelhibarassocia.dhadmin
{
    public partial class stickerlist : System.Web.UI.Page
    {
        Class1 obj = new Class1();
        SqlConnection connect = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString);
        SqlDataAdapter adp;
        SqlCommand cmd;
        protected void Page_Load(object sender, EventArgs e)
        {
            if (!IsPostBack)
            {
               // HealthNewsdata();
            }
        }
        public void HealthNewsdata()
        {
            string qrajneeti = "select top 100 * from Memberslist  order by id desc";
            DataSet dsrajneeti = obj.ReturnDataSet(qrajneeti);
            if (dsrajneeti != null && dsrajneeti.Tables[0].Rows.Count > 0)
            {
                DataGrid2.DataSource = dsrajneeti;
                DataGrid2.DataBind();
                DataGrid2.Visible = true;
            }
            else
            {
                DataGrid2.Visible = false;
            }
        }

        protected void DataGrid2_PageIndexChanged(object source, DataGridPageChangedEventArgs e)
        {
            if (DataGrid2.Items.Count >= 0)
            {
                DataGrid2.CurrentPageIndex = e.NewPageIndex;
                HealthNewsdata();
            }
        }
      

        protected void Button1_Click(object sender, EventArgs e)
        {
            string empty = "";
            
            if (TextBox2.Text != "")
            {
                empty = empty + " and Mobile_1 = '" + TextBox2.Text + "'";
            }
            if (TextBox3.Text != "")
            {
                empty = empty + " and Bcdenroll = '" + TextBox3.Text + "'";
            }
            string qrajneeti = "select * from Memberssticker where id!='0' " + empty + "  order by id desc";
            DataSet dsrajneeti = obj.ReturnDataSet(qrajneeti);
            if (dsrajneeti != null && dsrajneeti.Tables[0].Rows.Count > 0)
            {
                DataGrid2.DataSource = dsrajneeti;
                DataGrid2.DataBind();
                DataGrid2.Visible = true;
            }
            else
            {
                DataGrid2.Visible = false;
            }
        }

        protected void DataGrid2_ItemCommand(object source, DataGridCommandEventArgs e)
        {
            if (e.CommandName == "Delete")
            {
                HiddenField hf = (HiddenField)e.Item.FindControl("HiddenField1");
                string query = "Delete from Memberssticker where id='" + hf.Value + "'";
                obj.DeleteRecord(query);
                RegisterStartupScript("12", "<script>alert('Deleted')</script>");
                string empty = "";

                if (TextBox2.Text != "")
                {
                    empty = empty + " and Mobile_1 = '" + TextBox2.Text + "'";
                }
                if (TextBox3.Text != "")
                {
                    empty = empty + " and Bcdenroll = '" + TextBox3.Text + "'";
                }
                string qrajneeti = "select * from Memberssticker where id!='0' " + empty + "  order by id desc";
                DataSet dsrajneeti = obj.ReturnDataSet(qrajneeti);
                if (dsrajneeti != null && dsrajneeti.Tables[0].Rows.Count > 0)
                {
                    DataGrid2.DataSource = dsrajneeti;
                    DataGrid2.DataBind();
                    DataGrid2.Visible = true;
                }
                else
                {
                    DataGrid2.Visible = false;
                }
            }
        }
    }
}