using System;
using System.Collections.Generic;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;
using System.Text;
using System.IO;
using System.Text.RegularExpressions;

public partial class thankyou : System.Web.UI.Page
{
    cnn cn = new cnn();
    DataSet ds;
    string x;

    DataRow drow;
    int record = 0;

    public void qry(string x)
    {
        try
        {
            ds = new DataSet();
            cn.da = new System.Data.SqlClient.SqlDataAdapter(x, cn.cn);
            cn.cbd.DataAdapter = cn.da;
            cn.da.MissingSchemaAction = MissingSchemaAction.AddWithKey;
            cn.da.Fill(ds);
        }
        catch (Exception)
        {
            //toolStripStatusLabel1.Text = ex.Message.ToString();
        }


    }
    protected void Page_Load(object sender, EventArgs e)
    {
        x = "select * from incr";

        qry(x);

        DataSet cont = new DataSet();
        cn.da.Fill(cont);
        int x1;
        x1 = cont.Tables[0].Rows.Count - 1;

        if (x1 == -1)
        {
            record = 1;
        }
        else
        {

            record = Convert.ToInt32(cont.Tables[0].Rows[x1].ItemArray[1]);
            record += 1;
        }


        lblincr.Text = record.ToString();



        x = "insert visitor_no into incr ='" + lblincr.Text + "'";
        qry(x);

        cn.cmd.CommandType = CommandType.Text;
        cn.cmd.CommandText = "update incr set visitor_no ='" + lblincr.Text + "' where id= 1";
        cn.cn.Open();
        cn.cmd.Connection = cn.cn;
        cn.cmd.ExecuteNonQuery();
        cn.cn.Close();

        if (!IsPostBack)
        {

            GetHMenuData();


        }
    }


    private void GetHMenuData()
    {
        DataTable table = new DataTable();
        x = "select id, menu, parent_id, url from Hmenudetails ORDER by Sequence ASC";
        qry(x);
        cn.da.Fill(table);
        DataView view = new DataView(table);
        view.RowFilter = "parent_id is NULL";
        foreach (DataRowView row in view)
        {
            MenuItem menuItem = new MenuItem(row["menu"].ToString(),
            row["id"].ToString());
            menuItem.NavigateUrl = row["url"].ToString();
            MenuBar.Items.Add(menuItem);
            AddChildItems1(table, menuItem);
        }
    }
    private void AddChildItems1(DataTable table, MenuItem menuItem)
    {
        DataView viewItem = new DataView(table);
        viewItem.RowFilter = "parent_id=" + menuItem.Value;
        foreach (DataRowView childView in viewItem)
        {
            MenuItem childItem = new MenuItem(childView["menu"].ToString(),
            childView["id"].ToString());
            childItem.NavigateUrl = childView["url"].ToString();
            menuItem.ChildItems.Add(childItem);
            AddChildItems1(table, childItem);
        }
    }


    protected override void Render(HtmlTextWriter writer)
    {
        StringBuilder sb = new StringBuilder();
        StringWriter sw = new StringWriter(sb);
        HtmlTextWriter hWriter = new HtmlTextWriter(sw);
        base.Render(hWriter);
        string html = sb.ToString();
        html = Regex.Replace(html, "<input[^>]*id=\"(__VIEWSTATE)\"[^>]*>", string.Empty, RegexOptions.IgnoreCase);
        writer.Write(html);
    }
}