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) { string email = Request.QueryString["email"]; string cat = Request.QueryString["cat"]; restaurantmenus.restaurant_menus r1 = new restaurantmenus.restaurant_menus(); goback.Text = "<a href='restaurant_single.aspx?email=" + email + "' class='green'> Go Back</a>"; ArrayList a = new ArrayList(r1.menu_category_retrieve(email, cat)); 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++; } DataTable newsDataTable = new DataTable(); // add some columns to our datatable newsDataTable.Columns.Add("itemname"); newsDataTable.Columns.Add("itemprice"); newsDataTable.Columns.Add("itemcategory"); newsDataTable.Columns.Add("itemtype"); newsDataTable.Columns.Add("itempath"); newsDataTable.Columns.Add("itemdesc"); newsDataTable.Columns.Add("itemid"); // adding new rows for (int i = 0; i < iterator; i++) { DataRow newsDataRow = newsDataTable.NewRow(); newsDataRow["itemname"] = data[i, 0]; newsDataRow["itemprice"] = data[i, 1]; newsDataRow["itemcategory"] = data[i, 2]; newsDataRow["itemtype"] = data[i, 3]; newsDataRow["itempath"] = data[i, 4]; newsDataRow["itemdesc"] = data[i, 5]; newsDataRow["itemid"] = data[i, 6]; newsDataTable.Rows.Add(newsDataRow); } // bind our datatable to our repeater menu1.DataSource = newsDataTable; menu1.DataBind(); }
protected void Page_Load(object sender, EventArgs e) { string email = Request.QueryString["email"]; string cat = Request.QueryString["cat"]; restaurantmenus.restaurant_menus r1 = new restaurantmenus.restaurant_menus(); goback.Text = "<a href='restaurant_single.aspx?email=" + email + "' class='green'> Go Back</a>"; ArrayList a = new ArrayList(r1.menu_category_retrieve(email,cat)); 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++; } DataTable newsDataTable = new DataTable(); // add some columns to our datatable newsDataTable.Columns.Add("itemname"); newsDataTable.Columns.Add("itemprice"); newsDataTable.Columns.Add("itemcategory"); newsDataTable.Columns.Add("itemtype"); newsDataTable.Columns.Add("itempath"); newsDataTable.Columns.Add("itemdesc"); newsDataTable.Columns.Add("itemid"); // adding new rows for (int i = 0; i < iterator; i++) { DataRow newsDataRow = newsDataTable.NewRow(); newsDataRow["itemname"] = data[i, 0]; newsDataRow["itemprice"] = data[i, 1]; newsDataRow["itemcategory"] = data[i, 2]; newsDataRow["itemtype"] = data[i, 3]; newsDataRow["itempath"] = data[i, 4]; newsDataRow["itemdesc"] = data[i, 5]; newsDataRow["itemid"] = data[i, 6]; newsDataTable.Rows.Add(newsDataRow); } // bind our datatable to our repeater menu1.DataSource = newsDataTable; menu1.DataBind(); }
protected void update_Click(object sender, EventArgs e) { restaurantmenus.restaurant_menus r1 = new restaurantmenus.restaurant_menus(); int x = Convert.ToInt32(Request.QueryString["id"]); string img = ""; int y = r1.menu_update_update(x,name.Text,price.Text,category.Text,cattype.Text,img,desc.Text); Response.Redirect("restaurant_menus.aspx"); }
protected void update_Click(object sender, EventArgs e) { restaurantmenus.restaurant_menus r1 = new restaurantmenus.restaurant_menus(); int x = Convert.ToInt32(Request.QueryString["id"]); string img = ""; int y = r1.menu_update_update(x, name.Text, price.Text, category.Text, cattype.Text, img, desc.Text); Response.Redirect("restaurant_menus.aspx"); }
protected void add_Click(object sender, EventArgs e) { restaurantmenus.restaurant_menus r1 = new restaurantmenus.restaurant_menus(); string catname = cat_name.Text; string cattype = cat_type.Text; string main_res = Session["main_res"].ToString(); string path = "C:\\Users\\pramod\\Desktop\\ase project\\FIRST INCREMENT\\eathub_webservice\\images\\" + main_res + "\\category\\"; if (catimg.HasFile) { try { if (!Directory.Exists(path)) { Directory.CreateDirectory(path); } catimg.SaveAs(path + catimg.FileName); path = "http://localhost:51966/eathub_webservice/images/" + main_res + "/category/" + catimg.FileName; } catch { // Label1.Visible = true; // Label1.Text = "Unable to save file"; } } int a = r1.category_add(main_res, catname, cattype, path); if (a == 1) { status.Visible = true; status.Text = "Category created successfully"; cat_name.Text = null; cat_type.Text = null; } else { status.Visible = true; status.Text = "Error"; } }
protected void Button1_Click(object sender, EventArgs e) { string emailid = Session["main_res"].ToString(); string path = "C:\\Users\\pramod\\Desktop\\ase project\\FIRST INCREMENT\\eathub_webservice\\images\\" + emailid + "\\"; if (FileUpload1.HasFile) { try { if (!Directory.Exists(path)) { Directory.CreateDirectory(path); Label1.Text = "path created"; } FileUpload1.SaveAs(path + FileUpload1.FileName); Label1.Visible = true; Label1.Text = "File uploaded"; path = "http://localhost:51966/eathub_webservice/images/" + emailid + "/"+ FileUpload1.FileName; Label1.Text = path; } catch { Label1.Visible = true; Label1.Text = "Unable to save file"; } } restaurantmenus.restaurant_menus r2 = new restaurantmenus.restaurant_menus(); int status = r2.item_add(emailid, name.Text, price.Text, category.Text, cattype.Text, path, desc.Text); if (status == 1) { Label1.Visible = true; Label1.Text = "Item Added Successfully"; } else { Label1.Text = "try again"; } }
protected void Button1_Click(object sender, EventArgs e) { string emailid = Session["main_res"].ToString(); string path = "C:\\Users\\pramod\\Desktop\\ase project\\FIRST INCREMENT\\eathub_webservice\\images\\" + emailid + "\\"; if (FileUpload1.HasFile) { try { if (!Directory.Exists(path)) { Directory.CreateDirectory(path); Label1.Text = "path created"; } FileUpload1.SaveAs(path + FileUpload1.FileName); Label1.Visible = true; Label1.Text = "File uploaded"; path = "http://localhost:51966/eathub_webservice/images/" + emailid + "/" + FileUpload1.FileName; Label1.Text = path; } catch { Label1.Visible = true; Label1.Text = "Unable to save file"; } } restaurantmenus.restaurant_menus r2 = new restaurantmenus.restaurant_menus(); int status = r2.item_add(emailid, name.Text, price.Text, category.Text, cattype.Text, path, desc.Text); if (status == 1) { Label1.Visible = true; Label1.Text = "Item Added Successfully"; } else { Label1.Text = "try again"; } }
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 category = Request.QueryString["cat"]; if (category != null) { restaurantmenus.restaurant_menus r1 = new restaurantmenus.restaurant_menus(); ArrayList a = new ArrayList(r1.res_category(category)); ArrayList b = new ArrayList(); b = (ArrayList)a; string[,] data = new string[100, 10]; 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]; data[iterator, 7] = row[7]; data[iterator, 8] = row[8]; data[iterator, 9] = row[9]; iterator++; } DataTable newsDataTable = new DataTable(); // add some columns to our datatable newsDataTable.Columns.Add("restaurant_name"); newsDataTable.Columns.Add("contact_no"); newsDataTable.Columns.Add("street"); newsDataTable.Columns.Add("city"); newsDataTable.Columns.Add("zipcode"); newsDataTable.Columns.Add("logopath"); newsDataTable.Columns.Add("restaurant_category"); newsDataTable.Columns.Add("minamount"); newsDataTable.Columns.Add("deliverytimings"); newsDataTable.Columns.Add("email"); // adding new rows for (int i = 0; i < iterator; i++) { DataRow newsDataRow = newsDataTable.NewRow(); newsDataRow["restaurant_name"] = data[i, 0]; newsDataRow["contact_no"] = data[i, 1]; newsDataRow["street"] = data[i, 2]; newsDataRow["city"] = data[i, 3]; newsDataRow["zipcode"] = data[i, 4]; newsDataRow["logopath"] = data[i, 5]; newsDataRow["restaurant_category"] = data[i, 6]; newsDataRow["minamount"] = data[i, 7]; newsDataRow["deliverytimings"] = data[i, 8]; newsDataRow["email"] = data[i, 9]; newsDataTable.Rows.Add(newsDataRow); } // bind our datatable to our repeater rescat.DataSource = newsDataTable; rescat.DataBind(); if (iterator != 0) { } else { dis.Text = "No Restaurants"; } } else { dis.Visible = true; dis.Text = "No Restaurants"; } }
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) { restaurantmenus.restaurant_menus r1 = new restaurantmenus.restaurant_menus(); string main_res = ""; if (Session["main_res"] == null) { Response.Redirect("login.aspx"); } else { main_res = Session["main_res"].ToString(); } ArrayList a = new ArrayList(r1.menu_retrieve(main_res)); 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++; } DataTable newsDataTable = new DataTable(); // add some columns to our datatable newsDataTable.Columns.Add("itemname"); newsDataTable.Columns.Add("itemprice"); newsDataTable.Columns.Add("itemcategory"); newsDataTable.Columns.Add("itemtype"); newsDataTable.Columns.Add("itempath"); newsDataTable.Columns.Add("itemdesc"); newsDataTable.Columns.Add("itemid"); // adding new rows for (int i = 0; i < iterator; i++) { DataRow newsDataRow = newsDataTable.NewRow(); newsDataRow["itemname"] = data[i, 0]; newsDataRow["itemprice"] = data[i, 1]; newsDataRow["itemcategory"] = data[i, 2]; newsDataRow["itemtype"] = data[i, 3]; newsDataRow["itempath"] = data[i, 4]; newsDataRow["itemdesc"] = data[i, 5]; newsDataRow["itemid"] = data[i, 6]; newsDataTable.Rows.Add(newsDataRow); } // bind our datatable to our repeater menu.DataSource = newsDataTable; menu.DataBind(); }
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 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]; } }