using System;
using System.Collections.Generic;
using System.Data;
using System.Linq;
using System.Reflection.Emit;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;

namespace BCD.admin
{
    public partial class paymenthistory : System.Web.UI.Page
    {
        Class1 obj = new Class1();
        protected void Page_Load(object sender, EventArgs e)
        {
            if (!IsPostBack)
            {
                HealthNewsdata();
                string qrajneetis = "select sum(CAST(amount AS DECIMAL(10,2))) from Ad_Paymentdetails ";
                DataSet dsrajneetis = obj.ReturnDataSet(qrajneetis);
                if (dsrajneetis != null && dsrajneetis.Tables[0].Rows.Count > 0)
                {
                    Label6.Text = dsrajneetis.Tables[0].Rows[0][0].ToString();
                }
                string qrajneetiss = "select count(id) from Ad_Paymentdetails ";
                DataSet dsrajneetiss = obj.ReturnDataSet(qrajneetiss);
                if (dsrajneetiss != null && dsrajneetiss.Tables[0].Rows.Count > 0)
                {
                    Label5.Text = dsrajneetiss.Tables[0].Rows[0][0].ToString();
                }
            }
        }
        public void HealthNewsdata()
        {
            string qrajneeti = "select top 100 * from Ad_Paymentdetails order by id desc";
            DataSet dsrajneeti = obj.ReturnDataSet(qrajneeti);
            if (dsrajneeti != null && dsrajneeti.Tables[0].Rows.Count > 0)
            {
                //Label5.Text = dsrajneeti.Tables[0].Rows.Count.ToString();

                DataGrid2.DataSource = dsrajneeti;
                DataGrid2.DataBind();
                DataGrid2.Visible = true;
                DataGrid1.DataSource = dsrajneeti;
                DataGrid1.DataBind();
            }
            else
            {
                DataGrid2.Visible = false;
            }
        }

        protected void DataGrid2_PageIndexChanged(object source, DataGridPageChangedEventArgs e)
        {
            if (DataGrid2.Items.Count >= 0)
            {
                DataGrid2.CurrentPageIndex = e.NewPageIndex;
                HealthNewsdata();
            }
        }

        protected void Button1_Click(object sender, EventArgs e)
        {
            string empty = "";
            if (TextBox1.Text != "")
            {
                empty = empty + " and Name like '%" + TextBox1.Text + "%'";
            }
            if (TextBox2.Text != "")
            {
                empty = empty + " and Mobileno = '" + TextBox2.Text + "'";
            }
            if (TextBox3.Text != "")
            {
                empty = empty + " and Enrollednumber = '" + TextBox3.Text + "'";
            }
            string qrajneeti = "select * from Ad_Paymentdetails where  id!='' " + empty + "   order by id desc";
            DataSet dsrajneeti = obj.ReturnDataSet(qrajneeti);
            if (dsrajneeti != null && dsrajneeti.Tables[0].Rows.Count > 0)
            {
                DataGrid2.DataSource = dsrajneeti;
                DataGrid2.DataBind();
                DataGrid2.Visible = true;
                DataGrid1.DataSource = dsrajneeti;
                DataGrid1.DataBind();
                
            }
            else
            {
                DataGrid2.Visible = false;
            }
        }

        protected void Button2_Click(object sender, EventArgs e)
        {
            string qrajneeti = "select * from Ad_Paymentdetails where paymentstatus='" + DropDownList1.SelectedValue + "' and  daten between '" + TextBox4.Text + "' and '" + TextBox5.Text + "'  order by id desc";
            DataSet dsrajneeti = obj.ReturnDataSet(qrajneeti);
            if (dsrajneeti != null && dsrajneeti.Tables[0].Rows.Count > 0)
            {
                Label5.Text = dsrajneeti.Tables[0].Rows.Count.ToString();
                DataGrid2.DataSource = dsrajneeti;
                DataGrid2.DataBind();
                DataGrid2.Visible = true;
                DataGrid1.DataSource = dsrajneeti;
                DataGrid1.DataBind();
            }
            else
            {
                DataGrid2.Visible = false;
            }

            string qrajneetis = "select sum(CAST(amount AS DECIMAL(10,2))) from Ad_Paymentdetails where paymentstatus='" + DropDownList1.SelectedValue + "' and  daten between '" + TextBox4.Text + "' and '" + TextBox5.Text + "'  ";
            DataSet dsrajneetis = obj.ReturnDataSet(qrajneetis);
            if (dsrajneetis != null && dsrajneetis.Tables[0].Rows.Count > 0)
            {
                Label6.Text= dsrajneetis.Tables[0].Rows[0][0].ToString();
            }
        }

        protected void DataGrid2_ItemCommand(object source, DataGridCommandEventArgs e)
        {
            if(e.CommandName == "cp")
            {
                HiddenField hf = (HiddenField)e.Item.FindControl("HiddenField5");
                System.Web.UI.WebControls.Label yyys = (System.Web.UI.WebControls.Label)e.Item.FindControl("Labels4");
                System.Web.UI.WebControls.Label enn = (System.Web.UI.WebControls.Label)e.Item.FindControl("Label3");
                string up = "update Ad_Paymentdetails set paymentstatus='Success' where id='" + hf.Value + "'";
                obj.ReturnDataSet(up);
                string qrajneeti = "select name_of_advocate,Enroll_id,Enrolled_Year,convert(varchar, subscription_upto, 105) as subscription_upto,NewMobile_No from Memberslist where  Enroll_id='" + enn.Text + "' order by id desc";
                DataSet dsrajneeti = obj.ReturnDataSet(qrajneeti);
                string[] hhds;
                string hhdss = "";
                if (dsrajneeti != null && dsrajneeti.Tables[0].Rows.Count > 0)
                {

                    hhds = dsrajneeti.Tables[0].Rows[0]["subscription_upto"].ToString().Split('-');
                    if(hhds.Length>0)
                    {
                        int yys = Convert.ToInt32(Convert.ToInt32(hhds[2])+ Convert.ToInt32(yyys.Text));
                        hhdss = hhds[1] + "/" + hhds[0]+"/"+ yys.ToString();
                    }
                    
                }
                string up1 = "update Memberslist set subscription_upto='"+ hhdss + "' where Enroll_id='" + enn.Text + "'";
                obj.ReturnDataSet(up1);
                HealthNewsdata();

            }
            if (e.CommandName == "notcp")
            {
                HiddenField hf = (HiddenField)e.Item.FindControl("HiddenField5");
                
                string up = "update Ad_Paymentdetails set paymentstatus='Fail' where id='" + hf.Value + "'";
                obj.ReturnDataSet(up);
                HealthNewsdata();
            }
        }

        protected void Button5_Click(object sender, EventArgs e)
        {
            Response.Clear();
            Response.Buffer = true;
            Response.ContentType = "application/vnd.ms-excel";
            Response.AddHeader("Content-Disposition", "inline;filename=payment.xls");
            Response.Charset = "";
            this.EnableViewState = false;
            System.IO.StringWriter oStringWriter = new System.IO.StringWriter();
            System.Web.UI.HtmlTextWriter oHtmlTextWriter = new System.Web.UI.HtmlTextWriter(oStringWriter);
            DataGrid1.RenderControl(oHtmlTextWriter);
            Response.Write(oStringWriter.ToString());
            Response.End();
        }
    }
}