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

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

                    BindReceipt(id);
                }
            }
        }

        void BindReceipt(int id)
        {
            string cs = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;

            using (SqlConnection con = new SqlConnection(cs))
            {
                string query = "SELECT * FROM Shops WHERE ShopID=@Id";

                SqlCommand cmd = new SqlCommand(query, con);

                cmd.Parameters.AddWithValue("@Id", id);

                con.Open();

                SqlDataReader dr = cmd.ExecuteReader();

                if (dr.Read())
                {
                    lblShopName.Text = dr["ShopName"].ToString();
                    lblShopNo.Text = dr["ShopNo"].ToString();
                    lblMobile.Text = dr["MobileNo"].ToString();
                    lblStatus.Text = dr["Status"].ToString();
                    lblRent.Text = dr["Rent"].ToString();
                    lblBalance.Text = dr["Balance"].ToString();
                    lblOwner.Text = dr["OwnerName"].ToString();
                    lblAddress.Text = dr["ShopAddress"].ToString();
                }
            }
        }
    }
}