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 HomePage : System.Web.UI.Page
    {
        Class1 obj=new Class1();
        protected void Page_Load(object sender, EventArgs e)
        {
            if(!IsPostBack)
            {
                mm();
                totalmembermm();
                totalpayment();
                totalduepayment();
            }
        }
        void mm()
        {
            string qrajneeti = "select top 10 * from newdelhibar_bill where daten=CONVERT(DATE, GETDATE())  order by id desc";
            DataSet dsrajneeti = obj.ReturnDataSet(qrajneeti);
            if (dsrajneeti != null && dsrajneeti.Tables[0].Rows.Count > 0)
            {
                Repeater1.DataSource = dsrajneeti;
                Repeater1.DataBind();
                Repeater1.Visible = true;
            }
            else
            {
                Repeater1.Visible = false;
            }
        }
        void totalmembermm()
        {
            string qrajneeti = "select count(id) from Memberslist";
            DataSet dsrajneeti = obj.ReturnDataSet(qrajneeti);
            if (dsrajneeti != null && dsrajneeti.Tables[0].Rows.Count > 0)
            {
                Literal1.Text = dsrajneeti.Tables[0].Rows[0][0].ToString();
            }
           
        }
        void totalpayment()
        {
            string qrajneeti = "select SUM(CAST(totalamount AS DECIMAL(18,2)))  from newdelhibar_bill where status='SUCCESS'";
            DataSet dsrajneeti = obj.ReturnDataSet(qrajneeti);
            if (dsrajneeti != null && dsrajneeti.Tables[0].Rows.Count > 0)
            {
                Literal2.Text = dsrajneeti.Tables[0].Rows[0][0].ToString();
            }

        }
        void totalduepayment()
        {
            string qrajneeti = "select SUM(TRY_CAST(dues AS DECIMAL(18,2)))  from Membersduelist ";
            DataSet dsrajneeti = obj.ReturnDataSet(qrajneeti);
            if (dsrajneeti != null && dsrajneeti.Tables[0].Rows.Count > 0)
            {
                Literal3.Text = dsrajneeti.Tables[0].Rows[0][0].ToString();
            }

        }

    }
}