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 pendingview : 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)
                    {
                        // TextBox1.Text = dsrajneeti.Tables[0].Rows[0]["s_no"].ToString();
                        /* string []hj = dsrajneeti.Tables[0].Rows[0]["mdate"].ToString().Split('/');
                         string[] hj1 = dsrajneeti.Tables[0].Rows[0]["dob"].ToString().Split('/');
                         int jk = hj.Length;
                         int jk1 = hj1.Length;*/
                        ndbano.Text = dsrajneeti.Tables[0].Rows[0]["Ndbano"].ToString();
                        // TextBox3.Text = dsrajneeti.Tables[0].Rows[0]["Bcdenroll"].ToString();
                        /*if (jk>1)
                        {
                            string[] daten = hj[2].Split(' ');
                            TextBox2.Text = daten[0]+"-"+hj[0]+"-"+hj[1];
                        }*/


                        lbname.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();
                       
                        lbmobile.Text = dsrajneeti.Tables[0].Rows[0]["Mobile_1"].ToString();
                        lbvehicle.Text = dsrajneeti.Tables[0].Rows[0]["Vehicle_no"].ToString();

                        string qrdue = "select * from Membersduelist where  Ndbano='" + dsrajneeti.Tables[0].Rows[0]["Ndbano"].ToString() + "'  order by id desc";
                        DataSet dsdue = obj.ReturnDataSet(qrdue);
                        string ddue = "0";
                        if (dsdue != null && dsdue.Tables[0].Rows.Count > 0)
                        {
                            ddue = dsdue.Tables[0].Rows[0]["dues"].ToString();
                            lbamount.Text = ddue;
                            lbduedate.Text= dsdue.Tables[0].Rows[0]["Ndbadate"].ToString();
                        }


                    }
                }
            }
        }
    }
}