using System;
using System.Collections.Generic;
using System.Configuration;
using System.Data.SqlClient;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Security.Cryptography;
using System.Xml.Linq;

namespace Newdelhibarassocia.dhadmin
{
    public partial class Dueentry : System.Web.UI.Page
    {
        Class1 obj = new Class1();
        SqlConnection connect = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString);
        SqlDataAdapter adp;
        SqlCommand cmd;
        protected void Page_Load(object sender, EventArgs e)
        {

        }
        protected void DataGrid2_ItemCommand1(object source, DataGridCommandEventArgs e)
        {

            if (e.CommandName == "Edit")
            {
                HiddenField idn = (HiddenField)e.Item.FindControl("HiddenField5");
                TextBox stno = (TextBox)e.Item.FindControl("Label3");
                // HiddenField2.Value = idn.Value;
                connect.Open();
                cmd = new SqlCommand("update Memberslist set Sticker_no=@Sticker_no where id='" + idn.Value + "' ", connect);
                cmd.Parameters.Add("@Sticker_no", System.Data.SqlDbType.VarChar);
                cmd.Parameters["@Sticker_no"].Value = stno.Text;

                cmd.ExecuteNonQuery();
                connect.Close();
                RegisterStartupScript("12", "<script>alert('Sticker Added.')</script>");
            }


        }

        protected void Button2_Click(object sender, EventArgs e)
        {
            string empty = "";

            if (TextBox71.Text != "")
            {
                empty = empty + " and Mobile_1 = '" + TextBox71.Text + "'";
            }
            if (TextBox121.Text != "")
            {
                empty = empty + " and Bcdenroll = '" + TextBox121.Text + "'";
            }
            if (TextBox31.Text != "")
            {
                empty = empty + " and Ndbano = '" + TextBox31.Text + "'";
            }
            string qrajneeti = "select * from Memberslist where id!='0' " + 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;
                Panel1.Visible = true;
            }
            else
            {
                DataGrid2.Visible = false;
            }
        }

        protected void DataGrid2_PageIndexChanged(object source, DataGridPageChangedEventArgs e)
        {

        }

        protected void Button1_Click(object sender, EventArgs e)
        {
            for (int i = 0; i < DataGrid2.Items.Count; i++)
            {
                Label bnn = (Label)DataGrid2.Items[i].FindControl("Label1");
                Label namobileme = (Label)DataGrid2.Items[i].FindControl("Label2");
                Label Bcdenroll = (Label)DataGrid2.Items[i].FindControl("Label3");
                Label ndbano = (Label)DataGrid2.Items[i].FindControl("Labels3");

                if (obj.RecordExist("Select * from Membersduelist where Ndbano='" + ndbano.Text + "'") == true)
                {


                    connect.Open();
                    cmd = new SqlCommand("update Membersduelist set Ndbadate=@Ndbadate,Paid=@Paid, dues=@dues where Ndbano='" + ndbano.Text + "' ", connect);
                    cmd.Parameters.Add("@dues", System.Data.SqlDbType.VarChar);
                    cmd.Parameters["@dues"].Value = TextBox1.Text;
                    cmd.Parameters.Add("@Ndbadate", System.Data.SqlDbType.VarChar);
                    cmd.Parameters["@Ndbadate"].Value = TextBox3.Text;
                    cmd.Parameters.Add("@Paid", System.Data.SqlDbType.VarChar);
                    cmd.Parameters["@Paid"].Value = TextBox2.Text;

                    cmd.ExecuteNonQuery();
                    connect.Close();
                    RegisterStartupScript("12", "<script>alert('Update')</script>");
                }
                else
                {

                    connect.Open();
                    cmd = new SqlCommand("insert into Membersduelist (M_Type,Ndbano,mdate,Ndbadate,Bcdenroll,F_name,dues,Paid) values (@M_Type,@Ndbano,@mdate,@Ndbadate,@Bcdenroll,@F_name,@dues,@Paid)", connect);
                    cmd.Parameters.Add("@M_Type", System.Data.SqlDbType.VarChar);
                    cmd.Parameters["@M_Type"].Value = "";
                    cmd.Parameters.Add("@Ndbano", System.Data.SqlDbType.VarChar);
                    cmd.Parameters["@Ndbano"].Value = ndbano.Text;
                    cmd.Parameters.Add("@mdate", System.Data.SqlDbType.VarChar);
                    cmd.Parameters["@mdate"].Value = System.DateTime.Now.ToString("MM/dd/yyyy");
                    cmd.Parameters.Add("@Ndbadate", System.Data.SqlDbType.VarChar);
                    cmd.Parameters["@Ndbadate"].Value = TextBox3.Text;
                    cmd.Parameters.Add("@Bcdenroll", System.Data.SqlDbType.VarChar);
                    cmd.Parameters["@Bcdenroll"].Value = Bcdenroll.Text;
                    cmd.Parameters.Add("@F_name", System.Data.SqlDbType.VarChar);
                    cmd.Parameters["@F_name"].Value = bnn.Text;
                    cmd.Parameters.Add("@dues", System.Data.SqlDbType.VarChar);
                    cmd.Parameters["@dues"].Value = TextBox1.Text;
                    cmd.Parameters.Add("@Paid", System.Data.SqlDbType.VarChar);
                    cmd.Parameters["@Paid"].Value = TextBox2.Text;

                    //flags
                    cmd.ExecuteNonQuery();
                    connect.Close();

                    RegisterStartupScript("12", "<script>alert('Inserted Succssesfully.')</script>");
                }
            }
        }
    }
}