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

namespace Newdelhibarassocia.dhadmin
{
    public partial class addsticker : 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 (TextBox31.Text != "")
            {
                empty = empty + " and F_name like '%" + TextBox31.Text + "%'";
            }
            if (TextBox71.Text != "")
            {
                empty = empty + " and Mobile_1 = '" + TextBox71.Text + "'";
            }
            if (TextBox121.Text != "")
            {
                empty = empty + " and Bcdenroll = '" + TextBox121.Text + "'";
            }
            if (TextBox4.Text != "")
            {
                empty = empty + " and Ndbano = '" + TextBox4.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("Label3");
                Label namobileme = (Label)DataGrid2.Items[i].FindControl("Label2");
                Label ndbano = (Label)DataGrid2.Items[i].FindControl("Label4");


                connect.Open();
                cmd = new SqlCommand("insert into Memberssticker (mdate,Bcdenroll,Mobile_1,Sticker_no,Vehicle_no,Ndbano,daten,receivername) values (@mdate,@Bcdenroll,@Mobile_1,@Sticker_no,@Vehicle_no,@Ndbano,@daten,@receivername)", connect);

                cmd.Parameters.Add("@mdate", System.Data.SqlDbType.VarChar);
                cmd.Parameters["@mdate"].Value = System.DateTime.Now.ToString("MM/dd/yyyy");

                cmd.Parameters.Add("@Bcdenroll", System.Data.SqlDbType.VarChar);
                cmd.Parameters["@Bcdenroll"].Value = bnn.Text;


                cmd.Parameters.Add("@Mobile_1", System.Data.SqlDbType.VarChar);
                cmd.Parameters["@Mobile_1"].Value = namobileme.Text;

                cmd.Parameters.Add("@Sticker_no", System.Data.SqlDbType.VarChar);
                cmd.Parameters["@Sticker_no"].Value = TextBox1.Text;
                cmd.Parameters.Add("@Vehicle_no", System.Data.SqlDbType.VarChar);
                cmd.Parameters["@Vehicle_no"].Value = TextBox2.Text;
                cmd.Parameters.Add("@Ndbano", System.Data.SqlDbType.VarChar);
                cmd.Parameters["@Ndbano"].Value = ndbano.Text;
                cmd.Parameters.Add("@daten", System.Data.SqlDbType.VarChar);
                cmd.Parameters["@daten"].Value = TextBox3.Text;
                cmd.Parameters.Add("@receivername", System.Data.SqlDbType.VarChar);
                cmd.Parameters["@receivername"].Value = TextBox5.Text;


                //flags

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

                connect.Open();
                cmd = new SqlCommand("update Memberslist set Sticker_no=@Sticker_no,Vehicle_no=@Vehicle_no where Ndbano='" + ndbano.Text + "' ", connect);
                cmd.Parameters.Add("@Sticker_no", System.Data.SqlDbType.VarChar);
                cmd.Parameters["@Sticker_no"].Value = TextBox1.Text;
                cmd.Parameters.Add("@Vehicle_no", System.Data.SqlDbType.VarChar);
                cmd.Parameters["@Vehicle_no"].Value = TextBox2.Text;
                cmd.ExecuteNonQuery();
                connect.Close();
                RegisterStartupScript("12", "<script>alert('Inserted Succssesfully.')</script>");
            }
        }
    }
}