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

namespace Newdelhibarassocia.dhadmin
{
    public partial class mcertificateviews : System.Web.UI.Page
    {
        Class1 obj = new Class1();
        protected void Page_Load(object sender, EventArgs e)
        {
            if (!IsPostBack)
            {
                if (Request.QueryString["id"] != null)
                {
                    string qrajneeti = "select * from Memberslist where Ndbano='" + Request.QueryString["id"].ToString() + "' order by id desc";
                    DataSet dsrajneeti = obj.ReturnDataSet(qrajneeti);
                    if (dsrajneeti != null && dsrajneeti.Tables[0].Rows.Count > 0)
                    {

                        Literal5.Text = dsrajneeti.Tables[0].Rows[0]["Ndbano"].ToString();

                        Literal2.Text = dsrajneeti.Tables[0].Rows[0]["Bcdenroll"].ToString();


                        Literal10.Text = dsrajneeti.Tables[0].Rows[0]["Resid_1"].ToString();

                        Literal3.Text = dsrajneeti.Tables[0].Rows[0]["F_name"].ToString() + " " + dsrajneeti.Tables[0].Rows[0]["M_name"].ToString() + " " + dsrajneeti.Tables[0].Rows[0]["L_name"].ToString();
                      

                    }
                    string qra = "select * from tb_members where Post='President' order by id desc";
                    DataSet dsra = obj.ReturnDataSet(qra);
                    if (dsra != null && dsra.Tables[0].Rows.Count > 0)
                    {

                        Literal1.Text = dsra.Tables[0].Rows[0]["Name"].ToString();
                       // Literal7.Text = dsra.Tables[0].Rows[0]["Post"].ToString();
                       // Image1.ImageUrl = dsra.Tables[0].Rows[0]["Photo"].ToString();


                        Image2.ImageUrl = dsra.Tables[0].Rows[0]["Signature"].ToString();



                    }
                    string qra1 = "select * from tb_members where Post='Hony. Secretary' order by id desc";
                    DataSet dsra11 = obj.ReturnDataSet(qra1);
                    if (dsra11 != null && dsra11.Tables[0].Rows.Count > 0)
                    {

                        Literal8.Text = dsra11.Tables[0].Rows[0]["Name"].ToString();
                      //  Literal9.Text = dsra11.Tables[0].Rows[0]["Post"].ToString();
                        //Image4.ImageUrl = dsra11.Tables[0].Rows[0]["Photo"].ToString();


                        Image3.ImageUrl = dsra11.Tables[0].Rows[0]["Signature"].ToString();



                    }
                }
            }
        }
    }
}