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

namespace Newdelhibarassocia
{
    public partial class ViewMember : System.Web.UI.Page
    {
        SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ToString());

        protected void Page_Load(object sender, EventArgs e)
        {
            if (!IsPostBack)
            {
                detailsmember();
            }
        }
        public void detailsmember()
        {
            if (Request.QueryString["id"] != null)
            {
                string sel = "select * from Memberslist where id= '" + Request.QueryString["id"].ToString() + "'";
                SqlDataAdapter da = new SqlDataAdapter(sel, con);
                DataTable dt = new DataTable();
                da.Fill(dt);
                if (dt.Rows.Count > 0)
                {
                    lblname.Text = dt.Rows[0]["F_name"].ToString() + " " + dt.Rows[0]["M_name"].ToString() + " " + dt.Rows[0]["L_name"].ToString();
                    lblbcd.Text = dt.Rows[0]["Bcdenroll"].ToString();
                    lblfathername.Text = dt.Rows[0]["Father_name"].ToString();
                    lblmoileno.Text = dt.Rows[0]["Mobile_1"].ToString();
                    lblchamber.Text = dt.Rows[0]["Chamber_no"].ToString();
                    Image1.ImageUrl = dt.Rows[0]["Photo"].ToString();
                   // Image2.ImageUrl = dt.Rows[0]["SIGNFILE"].ToString();
                    if (Image1.ImageUrl != null)
                    {
                        Image1.Visible = true;
                    }
                    //if (Image2.ImageUrl != null)
                    //{
                    //    Image2.Visible = true;
                    //}

                }
                else
                {

                }
            }
            else
            {
                Response.Redirect("Member_Directory.aspx");
            }

        }
    }
}