protected void Page_Load(object sender, EventArgs e) { restaurantmenus.restaurant_menus r1 = new restaurantmenus.restaurant_menus(); string emailid = Session["main_res"].ToString(); ArrayList a = new ArrayList(r1.category_retrieve(emailid)); ArrayList b = new ArrayList(); b.Clear(); b = (ArrayList)a; foreach (string c in b) { string[] row = c.Split('^'); // Adds the category name dropdown ListItem f = new ListItem(); f.Value = row[0]; f.Text = row[0]; category.Items.Add(f); // Adds the category type dropdown ListItem g = new ListItem(); g.Value = row[1]; g.Text = row[1]; cattype.Items.Add(g); } }
protected void Page_Load(object sender, EventArgs e) { restaurantmenus.restaurant_menus r1 = new restaurantmenus.restaurant_menus(); string main_res = Session["main_res"].ToString(); ArrayList a = new ArrayList(r1.category_retrieve(main_res)); ArrayList b = new ArrayList(); b = (ArrayList)a; string[,] data = new string[100, 3]; int iterator = 0; foreach (string c in b) { string[] row = c.Split('^'); data[iterator, 0] = row[0]; data[iterator, 1] = row[1]; data[iterator, 2] = row[2]; iterator++; } DataTable newsDataTable = new DataTable(); // add some columns to our datatable newsDataTable.Columns.Add("categoryname"); newsDataTable.Columns.Add("categorytype"); newsDataTable.Columns.Add("categoryimg"); // adding new rows for (int i = 0; i < iterator; i++) { DataRow newsDataRow = newsDataTable.NewRow(); newsDataRow["categoryname"] = data[i, 0]; newsDataRow["categorytype"] = data[i, 1]; newsDataRow["categoryimg"] = data[i, 2]; newsDataTable.Rows.Add(newsDataRow); } // bind our datatable to our repeater c11.DataSource = newsDataTable; c11.DataBind(); }
protected void Page_Load(object sender, EventArgs e) { restaurantmenus.restaurant_menus r1 = new restaurantmenus.restaurant_menus(); string main_res = Session["main_res"].ToString(); ArrayList a = new ArrayList(r1.category_retrieve(main_res)); ArrayList b = new ArrayList(); b = (ArrayList)a; string[,] data = new string[100,3]; int iterator = 0; foreach (string c in b) { string[] row = c.Split('^'); data[iterator,0] = row[0]; data[iterator,1] = row[1]; data[iterator, 2] = row[2]; iterator++; } DataTable newsDataTable = new DataTable(); // add some columns to our datatable newsDataTable.Columns.Add("categoryname"); newsDataTable.Columns.Add("categorytype"); newsDataTable.Columns.Add("categoryimg"); // adding new rows for (int i = 0; i < iterator; i++) { DataRow newsDataRow = newsDataTable.NewRow(); newsDataRow["categoryname"] = data[i,0]; newsDataRow["categorytype"] = data[i,1]; newsDataRow["categoryimg"] = data[i, 2]; newsDataTable.Rows.Add(newsDataRow); } // bind our datatable to our repeater c11.DataSource = newsDataTable; c11.DataBind(); }
protected void Page_Load(object sender, EventArgs e) { string main_res = Session["main_res"].ToString(); //string main_res = "*****@*****.**"; restaurantmenus.restaurant_menus r = new restaurantmenus.restaurant_menus(); ArrayList a1 = new ArrayList(r.category_retrieve(main_res)); ArrayList b1 = new ArrayList(); b1.Clear(); b1 = (ArrayList)a1; foreach (string c in b1) { string[] row = c.Split('^'); // Adds the category name dropdown ListItem f = new ListItem(); f.Value = row[0]; f.Text = row[0]; category.Items.Add(f); // Adds the category type dropdown ListItem g = new ListItem(); g.Value = row[1]; g.Text = row[1]; cattype.Items.Add(g); } restaurantmenus.restaurant_menus r1 = new restaurantmenus.restaurant_menus(); int id = Convert.ToInt32(Request.QueryString["id"]); if (id == null) { id = 0; } ArrayList a = new ArrayList(r1.menu_retrieve_update(main_res, id)); ArrayList b = new ArrayList(); b = (ArrayList)a; string[,] data = new string[100, 7]; int iterator = 0; foreach (string c in b) { string[] row = c.Split('^'); data[iterator, 0] = row[0]; data[iterator, 1] = row[1]; data[iterator, 2] = row[2]; data[iterator, 3] = row[3]; data[iterator, 4] = row[4]; data[iterator, 5] = row[5]; data[iterator, 6] = row[6]; iterator++; } if (!IsPostBack) { name.Text = data[0, 0]; price.Text = data[0, 1]; category.Text = data[0, 2]; cattype.Text = data[0, 3]; desc.Text = data[0, 5]; } }
protected void Page_Load(object sender, EventArgs e) { string main_res = Session["main_res"].ToString(); //string main_res = "*****@*****.**"; restaurantmenus.restaurant_menus r = new restaurantmenus.restaurant_menus(); ArrayList a1 = new ArrayList(r.category_retrieve(main_res)); ArrayList b1 = new ArrayList(); b1.Clear(); b1= (ArrayList)a1; foreach (string c in b1) { string[] row = c.Split('^'); // Adds the category name dropdown ListItem f = new ListItem(); f.Value = row[0]; f.Text = row[0]; category.Items.Add(f); // Adds the category type dropdown ListItem g = new ListItem(); g.Value = row[1]; g.Text = row[1]; cattype.Items.Add(g); } restaurantmenus.restaurant_menus r1 = new restaurantmenus.restaurant_menus(); int id = Convert.ToInt32(Request.QueryString["id"]); if(id == null) { id = 0; } ArrayList a = new ArrayList(r1.menu_retrieve_update(main_res,id)); ArrayList b = new ArrayList(); b = (ArrayList)a; string[,] data = new string[100, 7]; int iterator = 0; foreach (string c in b) { string[] row = c.Split('^'); data[iterator, 0] = row[0]; data[iterator, 1] = row[1]; data[iterator, 2] = row[2]; data[iterator, 3] = row[3]; data[iterator, 4] = row[4]; data[iterator, 5] = row[5]; data[iterator, 6] = row[6]; iterator++; } if (!IsPostBack) { name.Text = data[0,0]; price.Text = data[0,1]; category.Text = data[0,2]; cattype.Text = data[0,3]; desc.Text = data[0,5]; } }
protected void Page_Load(object sender, EventArgs e) { string param1 = ""; param1 = Request.QueryString["email"]; try { /*param1 = "*****@*****.**";*/ loginwebservice.login l1 = new loginwebservice.login(); string[] a = l1.restaurant_profile_retrieve(param1); string img = a[8]; name.Text = a[0]; contact.Text = a[2]; street.Text = a[3]; city.Text = a[4]; zipcode.Text = a[5]; minamount.Text = a[6]; category1.Text = a[9]; timings.Text = a[7]; gimg.Text = "<a class='details' data-fancybox-type='iframe' href='google.aspx?address=" + street.Text + "," + city.Text + "," + zipcode.Text + "'><img src='images/google-map.png'></a>"; restaurantmenus.restaurant_menus r = new restaurantmenus.restaurant_menus(); ArrayList b = new ArrayList(r.category_retrieve(param1)); ArrayList c = new ArrayList(); c = (ArrayList)b; string[,] data = new string[100, 4]; int iterator = 0; foreach (string d in c) { string[] row = d.Split('^'); data[iterator, 0] = row[0]; data[iterator, 1] = row[1]; data[iterator, 2] = row[2]; data[iterator, 3] = row[3]; iterator++; } DataTable newsDataTable = new DataTable(); // add some columns to our datatable newsDataTable.Columns.Add("cat_name"); newsDataTable.Columns.Add("cat_type"); newsDataTable.Columns.Add("cat_img"); newsDataTable.Columns.Add("id"); // adding new rows for (int i = 0; i < iterator; i++) { DataRow newsDataRow = newsDataTable.NewRow(); newsDataRow["cat_name"] = data[i, 0]; newsDataRow["cat_type"] = data[i, 1]; newsDataRow["cat_img"] = data[i, 2]; newsDataRow["id"] = data[i, 3]; newsDataTable.Rows.Add(newsDataRow); } Label1.Text = "<a title='Send Mail to Restaurant' href='mailto:" + param1 + "'><img src ='images/email-to.png'></a>"; // bind our datatable to our repeater category.DataSource = newsDataTable; category.DataBind(); // string email = "*****@*****.**"; commentsweb.comments r1 = new commentsweb.comments(); ArrayList p = new ArrayList(r1.retrieve_comments(param1)); ArrayList q = new ArrayList(); q = (ArrayList)p; string[,] data1 = new string[100, 3]; int iterator1 = 0; string abcd = ""; foreach (string d in q) { string[] row = d.Split('^'); data1[iterator1, 0] = row[0]; data1[iterator1, 1] = row[1]; data1[iterator1, 2] = abcd; abcd = "children"; iterator1++; } DataTable newsDataTable1 = new DataTable(); // add some columns to our datatable newsDataTable1.Columns.Add("author"); newsDataTable1.Columns.Add("comment"); newsDataTable1.Columns.Add("abc"); // adding new rows for (int i = 0; i < iterator1; i++) { DataRow newsDataRow1 = newsDataTable1.NewRow(); newsDataRow1["author"] = data1[i, 0]; newsDataRow1["comment"] = data1[i, 1]; newsDataRow1["abc"] = data1[i, 2]; newsDataTable1.Rows.Add(newsDataRow1); } // bind our datatable to our repeater commentsec.DataSource = newsDataTable1; commentsec.DataBind(); } catch (Exception e1) { error.Visible = true; error.Text = "error"; int abc = 1; } }
protected void Page_Load(object sender, EventArgs e) { string param1 = ""; param1 = Request.QueryString["email"]; try { /*param1 = "*****@*****.**";*/ loginwebservice.login l1 = new loginwebservice.login(); string[] a = l1.restaurant_profile_retrieve(param1); string img = a[8]; name.Text = a[0]; contact.Text = a[2]; street.Text = a[3]; city.Text = a[4]; zipcode.Text = a[5]; minamount.Text = a[6]; category1.Text = a[9]; timings.Text = a[7]; gimg.Text = "<a class='details' data-fancybox-type='iframe' href='google.aspx?address=" +street.Text + "," + city.Text + "," + zipcode.Text + "'><img src='images/google-map.png'></a>"; restaurantmenus.restaurant_menus r = new restaurantmenus.restaurant_menus(); ArrayList b = new ArrayList(r.category_retrieve(param1)); ArrayList c = new ArrayList(); c = (ArrayList)b; string[,] data = new string[100, 4]; int iterator = 0; foreach (string d in c) { string[] row = d.Split('^'); data[iterator, 0] = row[0]; data[iterator, 1] = row[1]; data[iterator, 2] = row[2]; data[iterator, 3] = row[3]; iterator++; } DataTable newsDataTable = new DataTable(); // add some columns to our datatable newsDataTable.Columns.Add("cat_name"); newsDataTable.Columns.Add("cat_type"); newsDataTable.Columns.Add("cat_img"); newsDataTable.Columns.Add("id"); // adding new rows for (int i = 0; i < iterator; i++) { DataRow newsDataRow = newsDataTable.NewRow(); newsDataRow["cat_name"] = data[i, 0]; newsDataRow["cat_type"] = data[i, 1]; newsDataRow["cat_img"] = data[i, 2]; newsDataRow["id"] = data[i, 3]; newsDataTable.Rows.Add(newsDataRow); } Label1.Text = "<a title='Send Mail to Restaurant' href='mailto:" + param1 + "'><img src ='images/email-to.png'></a>"; // bind our datatable to our repeater category.DataSource = newsDataTable; category.DataBind(); // string email = "*****@*****.**"; commentsweb.comments r1 = new commentsweb.comments(); ArrayList p = new ArrayList(r1.retrieve_comments(param1)); ArrayList q = new ArrayList(); q = (ArrayList)p; string[,] data1 = new string[100, 3]; int iterator1 = 0; string abcd= ""; foreach (string d in q) { string[] row = d.Split('^'); data1[iterator1, 0] = row[0]; data1[iterator1, 1] = row[1]; data1[iterator1, 2] = abcd; abcd = "children"; iterator1++; } DataTable newsDataTable1 = new DataTable(); // add some columns to our datatable newsDataTable1.Columns.Add("author"); newsDataTable1.Columns.Add("comment"); newsDataTable1.Columns.Add("abc"); // adding new rows for (int i = 0; i < iterator1; i++) { DataRow newsDataRow1 = newsDataTable1.NewRow(); newsDataRow1["author"] = data1[i, 0]; newsDataRow1["comment"] = data1[i, 1]; newsDataRow1["abc"] = data1[i, 2]; newsDataTable1.Rows.Add(newsDataRow1); } // bind our datatable to our repeater commentsec.DataSource = newsDataTable1; commentsec.DataBind(); } catch (Exception e1) { error.Visible = true; error.Text = "error"; int abc = 1; } }