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.idcardadmin
{
    public partial class Dashboard : System.Web.UI.Page
    {
        Class1 obj=new Class1();
        protected void Page_Load(object sender, EventArgs e)
        {
            if (!IsPostBack)
            {
                if (Session["idcard"] != null)
                {
                    totalmembermm();
                    totalmembermm1();
                }
                else
                {
                    Response.Redirect("Default.aspx");
                }
            }
        }
        void totalmembermm()
        {
            string qrajneeti = "select count(id) from Memberslist where I_card_no='New'";
            DataSet dsrajneeti = obj.ReturnDataSet(qrajneeti);
            if (dsrajneeti != null && dsrajneeti.Tables[0].Rows.Count > 0)
            {
                Literal1.Text = dsrajneeti.Tables[0].Rows[0][0].ToString();
            }

        }
        void totalmembermm1()
        {
            string qrajneeti = "select count(id) from Memberslist where Ceased='Uploaded'";
            DataSet dsrajneeti = obj.ReturnDataSet(qrajneeti);
            if (dsrajneeti != null && dsrajneeti.Tables[0].Rows.Count > 0)
            {
                Literal1.Text = dsrajneeti.Tables[0].Rows[0][0].ToString();
            }

        }
    }
}