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

namespace Newdelhibarassocia.dhadmin
{
    public partial class mcertificateview : 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)
                    {
                        
                        Literal2.Text = dsrajneeti.Tables[0].Rows[0]["Ndbano"].ToString();
                        DateTime dt;

                        if (DateTime.TryParse(dsrajneeti.Tables[0].Rows[0]["Ndbadate"].ToString(), out dt))
                        {
                            Literal6.Text = dt.ToString("dd-MM-yyyy");
                        }
                        else
                        {
                            Literal6.Text = "";
                        }
                        Literal5.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();
                        Literal4.Text = dsrajneeti.Tables[0].Rows[0]["Father_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();



                    }
                }
            }
        }
    }
}