// Club //

    protected void DataList1_ItemCommand(object source, DataListCommandEventArgs e)
    {
        DataList7.SelectedIndex = e.Item.ItemIndex;
        LinkButton l1;

        l1 = (LinkButton)DataList7.Items[DataList7.SelectedIndex].FindControl("l1");

        int seatid = Convert.ToInt16(e.CommandArgument);



        if (l1.Text != " ")
        {
            if (l1.BackColor.Name == "CornflowerBlue")
            {
                l1.BackColor = System.Drawing.Color.LightGreen;
            }
            else
            {
                l1.BackColor = System.Drawing.Color.FromName("CornflowerBlue");
            }
        }



        //class       obj       class
        SqlConnection con2 = new SqlConnection(@"Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\userside.mdf;Integrated Security=True;User Instance=True");

        string str2;

        str2 = "update Seat_Master set status='Book' where Seatid=" + seatid + "";

        SqlCommand cmd2 = new SqlCommand(str2, con2);

        con2.Open();

        cmd2.ExecuteNonQuery();

        SqlConnection con1 = new SqlConnection(@"Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\userside.mdf;Integrated Security=True;User Instance=True");

        string str1 = "insert into Booking_master(userid,movieid,TheatreId,Seatid,username,moviename,bookedticket,price,bookingdate,category,Screenname,timing,seatno)values(" + Session["userid"] + "," + Session["movieid"] + "," + ViewState["TheatreId"] + "," + seatid + ",'" + Session["UserName"] + "','" + lblMoviName.Text + "','" + DropDownList2.SelectedItem.Text + "','" + lblRate.Text + "','" + lblMoviesDate.Text + "','" + DropDownList1.SelectedItem.Text + "','" + lblSid.Text + "','" + lblShowtime.Text + "','" + l1.Text + "')";

        con1.Open();

        SqlCommand cmd1 = new SqlCommand(str1, con1);

        cmd1.ExecuteNonQuery();
        m.ExecuteNonQuery1("insert into Total_Seat values(" + seatid + "," + ViewState["TheatreId"] + ",'" + lblScreen.Text + "','" + lblShowtime.Text + "','Book','" + lblMoviesDate.Text + "')");
        Label2.Text = "Seat Booked.";
        //Response.Redirect ( "Seeticket.aspx");

        con1.Close();


        // for getting booking id's
    }
    protected void abtadd_Click(object sender, EventArgs e)
    {
        int r = Convert.ToInt16(txtseat.Text);

        for (int y = 1; y <= r; y++)
        {
            string name;
            name = txtblock.Text + y;

            m.ExecuteNonQuery1("Insert into Seat_Master values(" + drptheater.SelectedItem.Value + "," + drpcity.SelectedValue + ",'" + name + "','" + drpscreen.SelectedItem.Text + "','" + drptype.SelectedItem.Text + "'," + txtamnt0.Text + ",'UnBook')");
        }
        abtadd.Enabled = false;
        GridView1.DataBind();
        Label2.Text = "Seat Detail Inserted Succ...";
    }