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

namespace Newdelhibarassocia.dhadmin
{
    public partial class shoplist : System.Web.UI.Page
    {
        protected void Page_Load(object sender, EventArgs e)
        {
            if (!IsPostBack)
            {
                BindChambers();
                if (Request.QueryString["del"] != null)
                {
                    int id = Convert.ToInt32(Request.QueryString["del"]);

                    string cs = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;

                    using (SqlConnection con = new SqlConnection(cs))
                    {
                        SqlCommand cmd = new SqlCommand("DELETE FROM Shops WHERE ShopID=@Id", con);
                        cmd.Parameters.AddWithValue("@Id", id);

                        con.Open();
                        cmd.ExecuteNonQuery();
                    }

                    Response.Redirect("Shop-list.aspx");
                }
            }
        }
        protected void Repeater1_ItemDataBound(object sender, RepeaterItemEventArgs e)
        {
            if (e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem)
            {
                string status = DataBinder.Eval(e.Item.DataItem, "Status").ToString();
            }
        }
        int pageSize = 10;
        int pageIndex = 1;
        protected void btnNext_Click(object sender, EventArgs e)
        {
            pageIndex++;
            BindChambers();
        }

        protected void btnPrev_Click(object sender, EventArgs e)
        {
            if (pageIndex > 1)
                pageIndex--;

            BindChambers();
        }

        protected void btnGo_Click(object sender, EventArgs e)
        {
            int page;
            if (int.TryParse(txtGoPage.Text, out page))
            {
                pageIndex = page;
                BindChambers();
            }
        }
        void BindChambers()
        {
            string cs = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;

            using (SqlConnection con = new SqlConnection(cs))
            {
                string query = @"
        SELECT * FROM (
            SELECT ROW_NUMBER() OVER (ORDER BY ShopID DESC) AS RowNum, *
            FROM Shops
        ) AS T
        WHERE RowNum BETWEEN @Start AND @End";

                SqlCommand cmd = new SqlCommand(query, con);

                cmd.Parameters.AddWithValue("@Start", (pageIndex - 1) * pageSize + 1);
                cmd.Parameters.AddWithValue("@End", pageIndex * pageSize);

                SqlDataAdapter da = new SqlDataAdapter(cmd);
                DataTable dt = new DataTable();
                da.Fill(dt);

                Repeater1.DataSource = dt;
                Repeater1.DataBind();
            }

            lblPageInfo.Text = "Page " + pageIndex;
        }
    }
}