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
{
    public partial class WebForm1 : System.Web.UI.Page
    {
        Class1 obj = new Class1();
        protected void Page_Load(object sender, EventArgs e)
        {
            try
            {
                string qrdue = "select * from Membersduelist where  Ndbano='987148'  order by id desc";
                DataSet dsdue = obj.ReturnDataSet(qrdue);
                string ddue = "0";
                int k = 0;
                int kk = 0;
                if (dsdue != null && dsdue.Tables[0].Rows.Count > 0)
                {
                    ddue = dsdue.Tables[0].Rows[0]["dues"].ToString();
                    DateTime dt2 = Convert.ToDateTime(dsdue.Tables[0].Rows[0]["Ndbadate"].ToString());

                    DateTime dt1 = DateTime.Now.AddDays(-1);
                    var monthCount = dt1.Year != dt1.Year ? ((dt1.Year - dt2.Year - 1) * 12) + (13 - dt2.Month + dt1.Month) : dt1.Month - dt2.Month;
                    k = 100 * monthCount;
                    string qra = "select * from newdelhibar_bill where Billno='ND668884' and Status='SUCCESS'";
                    DataSet dsra = obj.ReturnDataSet(qra);
                    if (dsra != null && dsra.Tables[0].Rows.Count > 0)
                    {
                        int dueson = 0;
                        int amms = Convert.ToInt32(dsra.Tables[0].Rows[0]["totalamount"].ToString());


                        if (monthCount > 0)
                        {
                            dueson = Convert.ToInt32(ddue) + k;
                            kk = Convert.ToInt32(dueson) - Convert.ToInt32(amms);
                        }
                        else
                        {
                            kk = Convert.ToInt32(ddue) - Convert.ToInt32(amms); 
                        }

                        if (kk >= 0)
                        {
                            string updue = "update Membersduelist set dues='" + kk + "' where Ndbano='987148'";
                            obj.SaveRecord(updue);
                        }
                        else
                        {
                            int result = kk / 100;
                            string kj = result.ToString().Replace("-", "");

                            dt2 = dt2.AddMonths(Convert.ToInt32(kj) + monthCount);
                            string updue = "update Membersduelist set dues='0' , Ndbadate='" + dt2.ToString() + "' where Ndbano='987148'";
                            obj.SaveRecord(updue);
                        }
                        // HealthNewsdata();
                        // string updue = "update Membersduelist set dues='" + kk + "' where Ndbano='" + nd.Text + "'";
                        // obj.SaveRecord(updue);

                    }
                }
            }
            catch { }
        }
    }
}