public int DataBind2() { HttpCookie cookie = Request.Cookies["BrowserDate"]; DateTime isn = DateTime.Now; DateTime.TryParse(cookie.Value.ToString().Replace("%20", " ").Replace("%3A", ":"), out isn); DateTime isNow = isn; Data dat = new Data(isn); Hashtable hash = new Hashtable(); int countInHash = 0; string featureDate = isNow.Month.ToString() +"/"+isNow.Day.ToString()+"/"+isNow.Year.ToString(); if (eventsDS != null) { try { if (Request.QueryString["page"] != null) { //Clear(); int eventCount = 0; if (eventsDS.Tables.Count > 0) eventCount = eventsDS.Tables[0].Rows.Count; ArrayList a = new ArrayList(eventCount); int searchTo = eventCount; if (dat.SearchCutOffNumber < eventCount) { searchTo = dat.SearchCutOffNumber; } DataView dv = new DataView(eventsDS.Tables[0], "", "", DataViewRowState.CurrentRows); DataView dvEvent; int lastPage = dv.Count / num_of_pages; int pageNum = int.Parse(Request.QueryString["page"].ToString()); if(pageNum > lastPage ) { pageNum = lastPage; } char[] delim = { '?' }; string url = Request.Url.AbsoluteUri; string[] tokens = url.Split(delim); url = tokens[0]; //Add prev and next buttons Label next; if (pageNum == 1 && pageNum != lastPage) { next = new Label(); next.Text = "<a class=\"NavyLink\" href=\"" + url + "?page=" + (pageNum + 1).ToString() + "\">Next ></a>"; SearchElementsPanel.Controls.Add(next); } else if (pageNum == lastPage && pageNum != 1) { next = new Label(); next.Text = "<a class=\"NavyLink\" href=\"" + url + "?page=" + (pageNum - 1).ToString() + "\">< Prev</a>"; SearchElementsPanel.Controls.Add(next); } else { next = new Label(); next.Text = "<a class=\"NavyLink\" href=\"" + url + "?page=" + (pageNum - 1).ToString() + "\">< Prev</a>"; SearchElementsPanel.Controls.Add(next); next = new Label(); next.Text = "<a class=\"NavyLink\" href=\"" + url + "?page=" + (pageNum + 1).ToString() + "\">Next ></a>"; SearchElementsPanel.Controls.Add(next); } int startIndex = (pageNum - 1) * num_of_pages; int endIndex = pageNum * num_of_pages; if (endIndex > dv.Count) endIndex = dv.Count; if (Request.Url.AbsolutePath.ToLower() == "/eventsearch.aspx") { dv.Sort = "colOrder ASC"; } else if (Request.Url.AbsolutePath.ToLower() == "/eventcategorysearch.aspx") { } else if (Request.Url.AbsolutePath.ToLower() == "/friend.aspx") { } int mapCount = 0; bool isEvent = true; DateTime dateOfEvent; for (int i = startIndex; i < endIndex; i++) { try { ASP.controls_searchelement_ascx searchElement = new ASP.controls_searchelement_ascx(); if (dv.Table.Columns.Contains("Type")) { if (dv[i]["Type"].ToString() == "V") isEvent = false; else isEvent = true; } else { isEvent = true; } if (isEvent) { dvEvent = dat.GetDataDV("SELECT *, EO.ID AS ReoccurrID FROM Events E, Event_Occurance EO WHERE E.ID=EO.EventID AND E.ID=" + dv[i]["EID"].ToString()); if (bool.Parse(dvEvent[0]["Featured"].ToString())) { if (dvEvent[0]["DaysFeatured"].ToString().Contains(";" + featureDate + ";")) searchElement.IS_FEATURED = true; else searchElement.IS_FEATURED = false; } else { searchElement.IS_FEATURED = false; } searchElement.NUM_OF_ALL_RESULTS = countOfUniqueVenues; searchElement.SEARCH_LABEL = dv[i]["Header"].ToString(); string toolTipID = ""; searchElement.VENUE_LABEL = dv[i]["Name"].ToString(); searchElement.EVENT_ID = int.Parse(dv[i]["EID"].ToString()); searchElement.IS_WINDOW = false; if (doMap) { searchElement.SEARCH_MAP_NUM = dv[i]["SearchNum"].ToString(); } if (isEvent) { dateOfEvent = DateTime.Parse(dv[i]["DateTimeStart"].ToString()); searchElement.DATE_LABEL = dateOfEvent.DayOfWeek.ToString().Substring(0, 3) + " " + dv[i]["DateTimeStart"].ToString().Replace(":00", "").Trim().Replace(" PM", "p").Replace(" AM", "a").Replace("/" + dateOfEvent.Year.ToString(), ""); toolTipID = "False" + dv[i]["EID"].ToString() + dv[i]["ReoccurrID"].ToString(); } if (dv.Count > 1) searchElement.DATE_LABEL += "+"; if (dv[i]["VID"].ToString() != "NONE") searchElement.VENUE_ID = int.Parse(dv[i]["VID"].ToString()); searchElement.TOOL_TIP_ID = toolTipID; if (isConnectTo) { searchElement.IS_CONNECT_TO = bool.Parse(dv[i]["isConnect"].ToString()); searchElement.WIDTH = 417; } } else { dvEvent = dat.GetDataDV("SELECT * FROM Venues E WHERE E.ID=" + dv[i]["VID"].ToString()); if (bool.Parse(dvEvent[0]["Featured"].ToString())) { if (dvEvent[0]["DaysFeatured"].ToString().Contains(";" + featureDate + ";")) searchElement.IS_FEATURED = true; else searchElement.IS_FEATURED = false; } else { searchElement.IS_FEATURED = false; } searchElement.NUM_OF_ALL_RESULTS = countOfUniqueVenues; searchElement.SEARCH_LABEL = dv[i]["Header"].ToString(); string toolTipID = ""; searchElement.DATE_LABEL = ""; searchElement.VENUE_LABEL = dv[i]["Name"].ToString(); searchElement.VENUE_ID = int.Parse(dv[i]["VID"].ToString()); searchElement.IS_WINDOW = false; searchElement.IS_VENUE = true; if (doMap) { searchElement.SEARCH_MAP_NUM = dv[i]["SearchNum"].ToString(); } toolTipID = "False" + dv[i]["VID"].ToString(); searchElement.TOOL_TIP_ID = toolTipID; } searchElement.COLOR = "#ebe7e7"; SearchElementsPanel.Controls.Add(searchElement); } catch (Exception ex) { Label lab = new Label(); lab.Text = ex.ToString(); SearchElementsPanel.Controls.Add(lab); } } } else { } } catch (Exception ex) { ErrorLabel.Text = ex.ToString(); } } return countInHash; }
public int DataBind2() { HttpCookie cookie = Request.Cookies["BrowserDate"]; Data dat = new Data(DateTime.Parse(cookie.Value.ToString().Replace("%20", " ").Replace("%3A", ":"))); Hashtable hash = new Hashtable(); int countInHash = 0; if (eventsDS != null) { try { Clear(); int eventCount = 0; if (eventsDS.Tables.Count > 0) eventCount = eventsDS.Tables[0].Rows.Count; ArrayList a = new ArrayList(eventCount); int searchTo = eventCount; if (dat.SearchCutOffNumber < eventCount) { searchTo = dat.SearchCutOffNumber; } DataView dv = new DataView(eventsDS.Tables[0], "", "", DataViewRowState.CurrentRows); if (Session["sortString"] != null) { if (Session["sortString"] != "") { dv.Sort = Session["sortString"].ToString(); sortString = Session["sortString"].ToString(); } } int countGotten = 0; int i = 0; Hashtable actualHash = new Hashtable(); while (countInHash < searchTo && i < dv.Count) { if (!hash.Contains(dv[i]["HashID"].ToString())) { hash.Add(dv[i]["HashID"].ToString(), ""); actualHash.Add(countInHash, dv[i]["HashID"].ToString()); countInHash++; } i++; } int somecount = 0; ASP.controls_pager_test_ascx pagerPanel = new ASP.controls_pager_test_ascx(); pagerPanel.NUMBER_OF_ITEMS_PER_PAGE = num_of_pages; pagerPanel.ID = "PagerPanel"; if (Request.Url.AbsolutePath.ToLower() == "/searchresults.aspx") { pagerPanel.RUN_FUNCTION = "initialize"; pagerPanel.PANEL_NAME = "EventSearchElements_PagerPanel_Panel"; } else if (Request.Url.AbsolutePath.ToLower() == "/eventcategorysearch.aspx") { pagerPanel.PANEL_NAME = "ctl00_ContentPlaceHolder1_SearchElements_PagerPanel_Panel"; } else if (Request.Url.AbsolutePath.ToLower() == "/Friend.aspx") { pagerPanel.PANEL_NAME = "ctl00_ContentPlaceHolder1_EventsCtrl_PagerPanel_Panel"; } int mapCount = 0; if (countInHash > theCutOff) countInHash = theCutOff; for (int j = 0; j < countInHash;j++ ) { try { string str = actualHash[j].ToString(); dv.RowFilter = "HashID = '" + str + "'"; ASP.controls_searchelement_ascx searchElement = new ASP.controls_searchelement_ascx(); //if (j % num_of_pages == 0) //{ // if (mapStrings != null) // { // searchElement.IMAGE_LITERAL += mapStrings[mapCount]; // mapCount++; // } //} if (doCalendar) { searchElement.CALENDAR_LETTER = dv[0]["CalendarNum"].ToString(); } searchElement.NUM_OF_ALL_RESULTS = countOfUniqueVenues; searchElement.SEARCH_LABEL = dv[0]["Header"].ToString(); string toolTipID = ""; if (bool.Parse(dv[0]["isGroup"].ToString())) { searchElement.EVENT_ID = int.Parse(dv[0]["EID"].ToString()); searchElement.IS_GROUP = true; searchElement.IS_WINDOW = windowT; toolTipID = "True" + dv[0]["EID"].ToString() + dv[0]["ReoccurrID"].ToString(); if (doMap) { searchElement.SEARCH_MAP_NUM = dv[0]["SearchNum"].ToString(); } foreach (DataRowView row in dv) { searchElement.DATE_LABEL += row["DateTimeStart"].ToString() + "<span style='font-family: Arial; font-size: 14px; font-weight: bold; color: #1fb6e7;'>, </span>"; } DataView dvEventOccurance = dat.GetDataDV("SELECT * FROM GroupEvent_Occurance WHERE GroupEventID=" + dv[0]["EID"].ToString() + " AND ID=" + dv[0]["ReoccurrID"].ToString()); DataView dvGroupEvent = dat.GetDataDV("SELECT * FROM GroupEvents WHERE ID=" + dv[0]["EID"].ToString()); bool getAddress = false; if (dvEventOccurance[0]["VenueID"] != null) { if (dvEventOccurance[0]["VenueID"].ToString() != "") { DataView dvVenue = dat.GetDataDV("SELECT * FROM Venues WHERE ID=" + dvEventOccurance[0]["VenueID"].ToString()); searchElement.VENUE_LABEL = dvVenue[0]["Name"].ToString(); searchElement.VENUE_ID = int.Parse(dvVenue[0]["ID"].ToString()); } else getAddress = true; } else getAddress = true; if (getAddress) { bool isInter = false; if (dvEventOccurance[0]["Country"].ToString() != "223") isInter = true; string address = ""; if (dvEventOccurance[0]["Country"].ToString() == "223") { address = dvEventOccurance[0]["StreetNumber"].ToString() + " " + dvEventOccurance[0]["StreetName"].ToString() + " " + dvEventOccurance[0]["StreetDrop"].ToString(); } else { address = dvEventOccurance[0]["Location"].ToString(); } searchElement.ADDRESS = address; } } else { searchElement.VENUE_LABEL = dv[0]["Name"].ToString(); searchElement.NUM_LABEL = ", " + dv[0]["EventGoersCount"].ToString() + " Peeps attending"; searchElement.EVENT_ID = int.Parse(dv[0]["EID"].ToString()); searchElement.IS_WINDOW = windowT; toolTipID = "False" + dv[0]["EID"].ToString() + dv[0]["ReoccurrID"].ToString(); if (doMap) { searchElement.SEARCH_MAP_NUM = dv[0]["SearchNum"].ToString(); } foreach (DataRowView row in dv) { searchElement.DATE_LABEL += row["DateTimeStart"].ToString() + "<span style='font-family: Arial; font-size: 14px; font-weight: bold; color: #1fb6e7;'>, </span>"; } searchElement.VENUE_ID = int.Parse(dv[0]["VID"].ToString()); } searchElement.TOOL_TIP_ID = toolTipID; if (isConnectTo) { searchElement.IS_CONNECT_TO = bool.Parse(dv[0]["isConnect"].ToString()); searchElement.WIDTH = 417; } if (somecount % 2 != 0) searchElement.COLOR = "#1b1b1b"; somecount++; a.Add(searchElement); //pagerPanel.Add(searchElement); } catch (Exception ex) { Label lab = new Label(); lab.Text = ex.ToString(); a.Add(lab); } } pagerPanel.DATA = a; pagerPanel.WIDTH = 420; pagerPanel.DataBind2(); SearchElementsPanel.Controls.Add(pagerPanel); } catch (Exception ex) { ErrorLabel.Text = ex.ToString(); } } return countInHash; }
public int DataBind2() { HttpCookie cookie = Request.Cookies["BrowserDate"]; DateTime isn = DateTime.Now; DateTime.TryParse(cookie.Value.ToString().Replace("%20", " ").Replace("%3A", ":"), out isn); DateTime isNow = isn; Data dat = new Data(isn); Hashtable hash = new Hashtable(); int countInHash = 0; string featureDate = isNow.Month.ToString() +"/"+isNow.Day.ToString()+"/"+isNow.Year.ToString(); if (eventsDS != null) { try { Clear(); int eventCount = 0; if (eventsDS.Tables.Count > 0) eventCount = eventsDS.Tables[0].Rows.Count; ArrayList a = new ArrayList(eventCount); int searchTo = eventCount; if (dat.SearchCutOffNumber < eventCount) { searchTo = dat.SearchCutOffNumber; } DataView dv = new DataView(eventsDS.Tables[0], "", "", DataViewRowState.CurrentRows); DataView dvEvent; int countGotten = 0; int i = 0; ASP.controls_pager_ascx pagerPanel = new ASP.controls_pager_ascx(); pagerPanel.NUMBER_OF_ITEMS_PER_PAGE = num_of_pages; if (Request.Url.AbsolutePath.ToLower() == "/eventsearch.aspx") { pagerPanel.ID = "PagerPanel"; pagerPanel.RUN_FUNCTION = "initialize"; dv.Sort = "colOrder ASC"; } else if (Request.Url.AbsolutePath.ToLower() == "/eventcategorysearch.aspx") { pagerPanel.PANEL_NAME = "ctl00_ContentPlaceHolder1_SearchElements_PagerPanel_Panel"; } else if (Request.Url.AbsolutePath.ToLower() == "/friend.aspx") { pagerPanel.ID = "PagerPanel"; pagerPanel.PANEL_NAME = "ctl00_ContentPlaceHolder1_EventsCtrl_PagerPanel_Panel"; } int mapCount = 0; bool isEvent = true; DateTime dateOfEvent; foreach(DataRowView row in dv) { if (countGotten < searchTo) { try { ASP.controls_searchelement_ascx searchElement = new ASP.controls_searchelement_ascx(); if (dv.Table.Columns.Contains("Type")) { if (row["Type"].ToString() == "V") isEvent = false; else isEvent = true; } else { isEvent = true; } if (isEvent) { dvEvent = dat.GetDataDV("SELECT *, EO.ID AS ReoccurrID FROM Events E, Event_Occurance EO WHERE E.ID=EO.EventID AND E.ID=" + row["EID"].ToString()); if (bool.Parse(dvEvent[0]["Featured"].ToString())) { if (dvEvent[0]["DaysFeatured"].ToString().Contains(";" + featureDate + ";")) searchElement.IS_FEATURED = true; else searchElement.IS_FEATURED = false; } else { searchElement.IS_FEATURED = false; } searchElement.NUM_OF_ALL_RESULTS = countOfUniqueVenues; searchElement.SEARCH_LABEL = row["Header"].ToString(); string toolTipID = ""; searchElement.VENUE_LABEL = row["Name"].ToString(); searchElement.EVENT_ID = int.Parse(row["EID"].ToString()); searchElement.IS_WINDOW = false; if (doMap) { searchElement.SEARCH_MAP_NUM = row["SearchNum"].ToString(); } if (isEvent) { dateOfEvent = DateTime.Parse(row["DateTimeStart"].ToString()); searchElement.DATE_LABEL = dateOfEvent.DayOfWeek.ToString().Substring(0, 3) + " " + row["DateTimeStart"].ToString().Replace(":00", "").Trim().Replace(" PM", "p").Replace(" AM", "a").Replace("/" + dateOfEvent.Year.ToString(), ""); toolTipID = "False" + row["EID"].ToString() + row["ReoccurrID"].ToString(); } if (dv.Count > 1) searchElement.DATE_LABEL += "+"; if (row["VID"].ToString() != "NONE") searchElement.VENUE_ID = int.Parse(row["VID"].ToString()); searchElement.TOOL_TIP_ID = toolTipID; if (isConnectTo) { searchElement.IS_CONNECT_TO = bool.Parse(row["isConnect"].ToString()); searchElement.WIDTH = 417; } } else { dvEvent = dat.GetDataDV("SELECT * FROM Venues E WHERE E.ID=" + row["VID"].ToString()); if (bool.Parse(dvEvent[0]["Featured"].ToString())) { if (dvEvent[0]["DaysFeatured"].ToString().Contains(";" + featureDate + ";")) searchElement.IS_FEATURED = true; else searchElement.IS_FEATURED = false; } else { searchElement.IS_FEATURED = false; } searchElement.NUM_OF_ALL_RESULTS = countOfUniqueVenues; searchElement.SEARCH_LABEL = row["Header"].ToString(); string toolTipID = ""; searchElement.DATE_LABEL = ""; searchElement.VENUE_LABEL = row["Name"].ToString(); searchElement.VENUE_ID = int.Parse(row["VID"].ToString()); searchElement.IS_WINDOW = false; searchElement.IS_VENUE = true; if (doMap) { searchElement.SEARCH_MAP_NUM = row["SearchNum"].ToString(); } toolTipID = "False" + row["VID"].ToString(); searchElement.TOOL_TIP_ID = toolTipID; } //if (somecount % 2 != 0) searchElement.COLOR = "#ebe7e7"; a.Add(searchElement); //pagerPanel.Add(searchElement); countGotten++; } catch (Exception ex) { Label lab = new Label(); lab.Text = ex.ToString(); a.Add(lab); } } else { break; } } SearchElementsPanel.Controls.Add(pagerPanel); pagerPanel.PANEL_NAME = pagerPanel.ClientID + "_Panel"; pagerPanel.DATA = a; pagerPanel.WIDTH = 429; pagerPanel.DataBind2(); } catch (Exception ex) { ErrorLabel.Text = ex.ToString(); } } return countInHash; }