public void DataBind2()
{
HttpCookie cookie = Request.Cookies["BrowserDate"];
if (venueDS != null)
{
int venueCount = 0;
if (venueDS.Tables.Count > 0)
venueCount = venueDS.Tables[0].Rows.Count;
ArrayList a = new ArrayList(venueCount);
Data dat = new Data(DateTime.Parse(cookie.Value.ToString().Replace("%20", " ").Replace("%3A", ":")));
int searchTo = venueCount;
if (dat.SearchCutOffNumber < venueCount)
{
searchTo = dat.SearchCutOffNumber;
}
for (int i = 0; i < searchTo; i++)
{
ASP.controls_groupsearchelement_ascx searchElement = new ASP.controls_groupsearchelement_ascx();
searchElement.Venue_ID = int.Parse(venueDS.Tables[0].Rows[i]["Group_ID"].ToString());
searchElement.SEARCH_LABEL = venueDS.Tables[0].Rows[i]["Header"].ToString();
searchElement.CITY = venueDS.Tables[0].Rows[i]["City"].ToString();
searchElement.STATE = venueDS.Tables[0].Rows[i]["State"].ToString();
searchElement.IS_WINDOW = windowT;
if (i % 2 != 0)
searchElement.COLOR = "#1b1b1b";
a.Add(searchElement);
//pagerPanel.Add(searchElement);
}
ASP.controls_pager_ascx pagerPanel = new ASP.controls_pager_ascx();
pagerPanel.NUMBER_OF_ITEMS_PER_PAGE = 10;
pagerPanel.DATA = a;
pagerPanel.WIDTH = 420;
pagerPanel.DataBind2();
SearchElementsPanel.Controls.Add(pagerPanel);
}
}
protected void GetAds()
{
AdPanel.Controls.Clear();
HttpCookie cookie = Request.Cookies["BrowserDate"];
Data dat = new Data(DateTime.Parse(cookie.Value.ToString().Replace("%20", " ").Replace("%3A", ":")));
DataSet dsAds = dat.GetData("SELECT * FROM Ads WHERE User_ID=" + Session["User"].ToString() + " ORDER BY Header");
DataView dvAdds = new DataView(dsAds.Tables[0], "", "", DataViewRowState.CurrentRows);
Panel panel;
ASP.controls_pager_ascx pagerPanel = new ASP.controls_pager_ascx();
if (dvAdds.Count > 0)
{
pagerPanel.NUMBER_OF_ITEMS_PER_PAGE = 10;
pagerPanel.WIDTH = 576;
pagerPanel.NUMBER_OF_VISIBLE_PAGES = 4;
ArrayList a = new ArrayList(dvAdds.Count);
int pagecount = 1;
for (int i = 0; i < dvAdds.Count; i++)
{
string featured = "False";
if (bool.Parse(dvAdds[i]["Featured"].ToString()))
featured = "True";
Literal label = new Literal();
label.Text = "<tr><td><a class=\"AddGreyLinkAlt\" style=\"padding-left: 10px;\" " +
"href=\"" + dat.MakeNiceName(dvAdds[i]["Header"].ToString()) + "_" +
dvAdds[i]["Ad_ID"].ToString() + "_Ad\">" + dvAdds[i]["Header"].ToString() +
"</a></td><td><label class=\"AddGreenLink\">" + featured + "</label></td>";
string disableStr = "";
if (bool.Parse(dvAdds[i]["LIVE"].ToString()))
{
disableStr = "<td><a class=\"PageButtons\" onclick=\"OpenRadDeleteAd(" + dvAdds[i]["Ad_ID"].ToString() +
")\">Disable</a></td>";
}
else
{
disableStr = "<td><a class=\"PageButtons\" onclick=\"OpenRadEnableAd(" + dvAdds[i]["Ad_ID"].ToString() +
")\">Enable</a></td>";
}
if (featured == "True")
{
label.Text += "<td><a class=\"AddGreyLinkAlt\" href=\"AdStatistics.aspx?Ad=" +
dvAdds[i]["Ad_ID"].ToString() + "\">View Statistics</a></td><td width=\"50px\"><a " +
"class=\"PageButtons\" href=\"PostAnAd.aspx?copy=true&ID=" +
dvAdds[i]["Ad_ID"].ToString() + "\">Copy</a></td>"+disableStr+"</tr>";
}
else
{
label.Text += "<td></td><td width=\"50px\"><a " +
"class=\"PageButtons\" href=\"PostAnAd.aspx?copy=true&ID=" +
dvAdds[i]["Ad_ID"].ToString() + "\">Copy</a></td>"+disableStr+"</tr>";
}
//panel = new Panel();
//Literal lNew = new Literal();
if ((i % pagerPanel.NUMBER_OF_ITEMS_PER_PAGE) == 0)
{
label.Text = "<table width=\"576px\"><tbody style=\"opacity: .7; filter: alpha(opacity = 70);background-color: #603E6A;\"><tr><td width=\"400px\"><label>Ad Name</label></td><td><label>Featured?</label></td><td></td><td></td><td></td></tr>"
+ label.Text;
//panel.Controls.Add(lNew);
}
//Literal lOld = new Literal();
//panel.Controls.Add(label);
if ((i + 1) == 10 * pagecount || i == dvAdds.Count - 1)
{
label.Text = label.Text + "</tbody></table>";
pagecount++;
//panel.Controls.Add(lOld);
}
a.Add(label);
}
pagerPanel.DATA = a;
pagerPanel.DataBind2();
AdPanel.Controls.Add(pagerPanel);
}
else
{
pagerPanel.NUMBER_OF_ITEMS_PER_PAGE = 1;
pagerPanel.WIDTH = 576;
pagerPanel.NUMBER_OF_VISIBLE_PAGES = 1;
ArrayList a = new ArrayList(1);
Literal lit = new Literal();
lit.Text = "<label>You are not an owner of any ads. To post ads go to <a href=\"PostAnAd.aspx\" class=\"AddLink\">Post An Ad page</a>.</label>";
a.Add(lit);
pagerPanel.DATA = a;
pagerPanel.DataBind2();
AdPanel.Controls.Add(pagerPanel);
}
}
protected void GetVenues()
{
VenuesPanel.Controls.Clear();
HttpCookie cookie = Request.Cookies["BrowserDate"];
Data dat = new Data(DateTime.Parse(cookie.Value.ToString().Replace("%20", " ").Replace("%3A", ":")));
DataSet dsAds = dat.GetData("SELECT * FROM Venues WHERE Owner=" + Session["User"].ToString() + " ORDER BY Name");
DataView dvAdds = new DataView(dsAds.Tables[0], "", "", DataViewRowState.CurrentRows);
ASP.controls_pager_ascx pagerPanel = new ASP.controls_pager_ascx();
if (dvAdds.Count > 0)
{
pagerPanel.NUMBER_OF_ITEMS_PER_PAGE = 10;
pagerPanel.WIDTH = 576;
pagerPanel.NUMBER_OF_VISIBLE_PAGES = 4;
ArrayList a = new ArrayList(dvAdds.Count);
int pagecount = 1;
for (int i = 0; i < dvAdds.Count; i++)
{
Literal label = new Literal();
//label.CssClass = "AddLink";
if (i % 10 == 0)
label.Text = "<table width=\"576px\"><tbody style=\"opacity: .8; filter: alpha(opacity = 80);background-color: #603E6A;\">";
label.Text += "<tr><td><a class=\"AddGreyLinkAlt\" style=\"padding-left: 10px;\" href=\"" +
dat.MakeNiceName(dvAdds[i]["Name"].ToString()) + "_" + dvAdds[i]["ID"].ToString() +
"_Venue\">" +
dvAdds[i]["Name"].ToString() + "</a></td></tr>";
if ((i + 1) == 10 * pagecount || i == dvAdds.Count - 1)
{
label.Text += "</tbody></table>";
pagecount++;
}
//panel = new Panel();
//panel.Controls.Add(label);
a.Add(label);
}
pagerPanel.DATA = a;
pagerPanel.DataBind2();
VenuesPanel.Controls.Add(pagerPanel);
}
else
{
pagerPanel.NUMBER_OF_ITEMS_PER_PAGE = 1;
pagerPanel.WIDTH = 576;
pagerPanel.NUMBER_OF_VISIBLE_PAGES = 1;
ArrayList a = new ArrayList(1);
Literal lit = new Literal();
lit.Text = "<label>You are not an owner of any venues. To post venues go to <a href=\"EnterVenueIntro.aspx\" class=\"AddLink\">Post A Venue page</a>.</label>";
a.Add(lit);
pagerPanel.DATA = a;
pagerPanel.DataBind2();
VenuesPanel.Controls.Add(pagerPanel);
}
}
protected void GetEvents()
{
EventsPanel.Controls.Clear();
HttpCookie cookie = Request.Cookies["BrowserDate"];
Data dat = new Data(DateTime.Parse(cookie.Value.ToString().Replace("%20", " ").Replace("%3A", ":")));
DataSet dsAds = dat.GetData("SELECT * FROM Events WHERE Owner=" + Session["User"].ToString() + " ORDER BY Header");
DataView dvAdds = new DataView(dsAds.Tables[0], "", "", DataViewRowState.CurrentRows);
Panel panel;
ASP.controls_pager_ascx pagerPanel = new ASP.controls_pager_ascx();
if (dvAdds.Count > 0)
{
pagerPanel.NUMBER_OF_ITEMS_PER_PAGE = 10;
pagerPanel.WIDTH = 576;
pagerPanel.NUMBER_OF_VISIBLE_PAGES = 4;
ArrayList a = new ArrayList(dvAdds.Count);
int pagecount = 1;
for (int i = 0; i < dvAdds.Count; i++)
{
Literal label = new Literal();
//label.CssClass = "AddLink";
string disableStr = "";
if (bool.Parse(dvAdds[i]["LIVE"].ToString()))
{
disableStr = "<td width=\"50px\"><a class=\"PageButtons\" onclick=\"OpenRadDeleteEvent(" + dvAdds[i]["ID"].ToString() +
")\">Disable</a></td>";
}
else
{
disableStr = "<td width=\"50px\"><a class=\"PageButtons\" onclick=\"OpenRadEnableEvent(" + dvAdds[i]["ID"].ToString() +
")\">Enable</a></td>";
}
if (i % 10 == 0)
label.Text = "<table width=\"576px\"><tbody style=\"background-color: #628E02;opacity: .8; filter:alpha(opacity = 80);\">";
label.Text += "<tr><td><a class=\"AddGreyLinkAlt\" style=\"padding-left: 10px;\" href=\"" +
dat.MakeNiceName(dvAdds[i]["Header"].ToString()) + "_" + dvAdds[i]["ID"].ToString() + "_Event\">" +
dvAdds[i]["Header"].ToString() + "</a></td><td width=\"50px\"><a style=\"font-family: Arial; font-size: 14px;text-decoration: none; color: #cccccc; font-weight: bold;\" href=\"BlogEvent.aspx?copy=true&ID=" +
dvAdds[i]["ID"].ToString() + "\">Copy</a></td>"+disableStr+"</tr>";
if ((i + 1) == 10 * pagecount || i == dvAdds.Count - 1)
{
label.Text += "</tbody></table>";
pagecount++;
}
//panel = new Panel();
//panel.Controls.Add(label);
a.Add(label);
}
pagerPanel.DATA = a;
pagerPanel.DataBind2();
EventsPanel.Controls.Add(pagerPanel);
}
else
{
pagerPanel.NUMBER_OF_ITEMS_PER_PAGE = 1;
pagerPanel.WIDTH = 576;
pagerPanel.NUMBER_OF_VISIBLE_PAGES = 1;
ArrayList a = new ArrayList(1);
Literal lit = new Literal();
lit.Text = "<label>You are not an owner of any events. To post events go to <a href=\"EnterEvent.aspx\" class=\"AddLink\">Post An Event page</a>.</label>";
a.Add(lit);
pagerPanel.DATA = a;
pagerPanel.DataBind2();
EventsPanel.Controls.Add(pagerPanel);
}
}
protected void GetVenues()
{
VenuesPanel.Controls.Clear();
HttpCookie cookie = Request.Cookies["BrowserDate"];
Data dat = new Data(DateTime.Parse(cookie.Value.ToString().Replace("%20", " ").Replace("%3A", ":")));
DataSet dsAds = dat.GetData("SELECT * FROM Venues WHERE Owner=" + Session["User"].ToString() + " ORDER BY Name");
DataView dvAdds = new DataView(dsAds.Tables[0], "", "", DataViewRowState.CurrentRows);
ASP.controls_pager_ascx pagerPanel = new ASP.controls_pager_ascx();
VenuesPanel.Controls.Add(pagerPanel);
pagerPanel.PANEL_NAME = pagerPanel.ClientID + "_Panel";
if (dvAdds.Count > 0)
{
pagerPanel.NUMBER_OF_ITEMS_PER_PAGE = 10;
pagerPanel.WIDTH = 700;
pagerPanel.NUMBER_OF_VISIBLE_PAGES = 4;
ArrayList a = new ArrayList(dvAdds.Count);
int pagecount = 1;
for (int i = 0; i < dvAdds.Count; i++)
{
Literal label = new Literal();
//label.CssClass = "AddLink";
if (i % 10 == 0)
label.Text = "<table cellpadding=\"5px\" width=\"700px\"><tbody>";
label.Text += "<tr><td><a class=\"NavyLink12\" style=\"padding-left: 10px;\" href=\"" +
dat.MakeNiceName(dvAdds[i]["Name"].ToString()) + "_" + dvAdds[i]["ID"].ToString() +
"_Venue\">" +
dvAdds[i]["Name"].ToString() + "</a></td>";
//if (!bool.Parse(dvAdds[i]["Featured"].ToString()))
//{
label.Text += "<td align=\"center\" width=\"100px\"><div style=\"width: 65px\" align=\"center\">" +
"<div style=\"width: 100px;\" onclick=\"window.location = 'enter-locale?edit=true&ID=" + dvAdds[i]["ID"].ToString() + "';\">" +
"<div class=\"topDiv\" style=\"clear: both;\">" +
" <img style=\"float: left;\" src=\"NewImages/ButtonLeft.png\" height=\"27px\" /> " +
" <div class=\"NavyLink\" style=\"font-size: 12px; text-decoration: none; padding-top: 5px;" +
"padding-left: 6px; padding-right: 6px;height: 27px;float: left;background: url('NewImages/ButtonPixel.png'); background-repeat: repeat-x;\">" +
" Edit " +
"</div>" +
" <img style=\"float: left;\" src=\"NewImages/ButtonRight.png\" height=\"27px\" /> " +
"</div>" +
"</div>" +
"</div></td><td></td></tr>";
//}
//else
//{
// char[] delim = { ';' };
// string[] tokens = dvAdds[i]["DaysFeatured"].ToString().Split(delim, StringSplitOptions.RemoveEmptyEntries);
// label.Text += "<td align=\"center\" width=\"100px\"><label>Featured on ";
// foreach (string token in tokens)
// {
// label.Text += token + ", ";
// }
// label.Text = label.Text.Trim().Substring(0, label.Text.Trim().Length - 1) + "</label></td>";
// label.Text += "<td align=\"center\" width=\"170px\"><div style=\"width: 158px\" align=\"center\">" +
// "<div style=\"width: 160px;\" onclick=\"window.location = 'enter-locale?edit=true&Feature=true&ID=" + dvAdds[i]["ID"].ToString() + "';\">" +
// "<div class=\"topDiv\" style=\"clear: both;\">" +
// " <img style=\"float: left;\" src=\"NewImages/ButtonLeft.png\" height=\"27px\" /> " +
// " <div class=\"NavyLink\" style=\"font-size: 12px; text-decoration: none; padding-top: 5px;" +
// "padding-left: 6px; padding-right: 6px;height: 27px;float: left;background: url('NewImages/ButtonPixel.png'); background-repeat: repeat-x;\">" +
// "Add More Feature Dates" +
// "</div>" +
// " <img style=\"float: left;\" src=\"NewImages/ButtonRight.png\" height=\"27px\" /> " +
// "</div>" +
// "</div>" +
// "</div></td>";
// label.Text += "</tr>";
//}
if ((i + 1) == 10 * pagecount || i == dvAdds.Count - 1)
{
label.Text += "</tbody></table>";
pagecount++;
}
//panel = new Panel();
//panel.Controls.Add(label);
a.Add(label);
}
pagerPanel.DATA = a;
pagerPanel.DataBind2();
}
else
{
pagerPanel.NUMBER_OF_ITEMS_PER_PAGE = 1;
pagerPanel.WIDTH = 700;
pagerPanel.NUMBER_OF_VISIBLE_PAGES = 1;
ArrayList a = new ArrayList(1);
Literal lit = new Literal();
lit.Text = "<div style=\"padding: 10px;\"><label>You are not an owner of any venues. To post venues go to <a href=\"EnterVenueIntro.aspx\" class=\"NavyLink12\">Post A Venue page</a>.</label></div>";
a.Add(lit);
pagerPanel.DATA = a;
pagerPanel.DataBind2();
}
}
//protected void GetAds()
//{
// AdPanel.Controls.Clear();
// HttpCookie cookie = Request.Cookies["BrowserDate"];
// Data dat = new Data(DateTime.Parse(cookie.Value.ToString().Replace("%20", " ").Replace("%3A", ":")));
// DataSet dsAds = dat.GetData("SELECT * FROM Ads WHERE User_ID=" + Session["User"].ToString() + " ORDER BY Header");
// DataView dvAdds = new DataView(dsAds.Tables[0], "", "", DataViewRowState.CurrentRows);
// Panel panel;
// ASP.controls_pager_ascx pagerPanel = new ASP.controls_pager_ascx();
// AdPanel.Controls.Add(pagerPanel);
// pagerPanel.PANEL_NAME = pagerPanel.ClientID + "_Panel";
// if (dvAdds.Count > 0)
// {
// pagerPanel.NUMBER_OF_ITEMS_PER_PAGE = 10;
// pagerPanel.WIDTH = 700;
// pagerPanel.NUMBER_OF_VISIBLE_PAGES = 4;
// ArrayList a = new ArrayList(dvAdds.Count);
// int pagecount = 1;
// for (int i = 0; i < dvAdds.Count; i++)
// {
// string featured = "False";
// if (bool.Parse(dvAdds[i]["Featured"].ToString()))
// featured = "True";
// Literal label = new Literal();
// label.Text = "<tr><td width=\"400px\"><a class=\"NavyLink12\" style=\"padding-left: 10px;\" " +
// "href=\"" + dat.MakeNiceName(dvAdds[i]["Header"].ToString()) + "_" +
// dvAdds[i]["Ad_ID"].ToString() + "_Ad\">" + dvAdds[i]["Header"].ToString() +
// "</a></td>";
// string disableStr = "";
// if (bool.Parse(dvAdds[i]["LIVE"].ToString()))
// {
// disableStr = "<td><a class=\"PageButtons\" onclick=\"OpenRadDeleteAd(" + dvAdds[i]["Ad_ID"].ToString() +
// ")\">Disable</a></td>";
// }
// else
// {
// disableStr = "<td><a class=\"PageButtons\" onclick=\"OpenRadEnableAd(" + dvAdds[i]["Ad_ID"].ToString() +
// ")\">Enable</a></td>";
// }
// label.Text += "<td width=\"50px\"><a " +
// "class=\"PageButtons\" href=\"post-bulletin?copy=true&ID=" +
// dvAdds[i]["Ad_ID"].ToString() + "\">Copy</a></td>" + disableStr;
// if (!bool.Parse(featured))
// {
// label.Text += "<td align=\"center\" width=\"100px\"><div style=\"width: 65px\" align=\"center\">" +
// "<div style=\"width: 100px;\" onclick=\"window.location = 'post-bulletin?edit=true&Feature=true&ID=" + dvAdds[i]["Ad_ID"].ToString() + "';\">" +
// "<div class=\"topDiv\" style=\"clear: both;\">" +
// " <img style=\"float: left;\" src=\"NewImages/ButtonLeft.png\" height=\"27px\" /> " +
// " <div class=\"NavyLink\" style=\"font-size: 12px; text-decoration: none; padding-top: 5px;" +
// "padding-left: 6px; padding-right: 6px;height: 27px;float: left;background: url('NewImages/ButtonPixel.png'); background-repeat: repeat-x;\">" +
// " Feature " +
// "</div>" +
// " <img style=\"float: left;\" src=\"NewImages/ButtonRight.png\" height=\"27px\" /> " +
// "</div>" +
// "</div>" +
// "</div></td>";
// }
// else
// {
// char[] delim = { ';' };
// string[] tokens = dvAdds[i]["DatesOfAd"].ToString().Split(delim, StringSplitOptions.RemoveEmptyEntries);
// label.Text += "<td align=\"center\" width=\"100px\"><label>Featured on ";
// foreach (string token in tokens)
// {
// label.Text += token + ", ";
// }
// label.Text = label.Text.Trim().Substring(0, label.Text.Trim().Length - 1) + "</label>";
// label.Text += "<td align=\"center\" width=\"170px\"><div style=\"width: 158px\" align=\"center\">" +
// "<div style=\"width: 160px;\" onclick=\"window.location = 'post-bulletin?edit=true&Feature=true&ID=" + dvAdds[i]["Ad_ID"].ToString() + "';\">" +
// "<div class=\"topDiv\" style=\"clear: both;\">" +
// " <img style=\"float: left;\" src=\"NewImages/ButtonLeft.png\" height=\"27px\" /> " +
// " <div class=\"NavyLink\" style=\"font-size: 12px; text-decoration: none; padding-top: 5px;" +
// "padding-left: 6px; padding-right: 6px;height: 27px;float: left;background: url('NewImages/ButtonPixel.png'); background-repeat: repeat-x;\">" +
// "Add More Feature Dates" +
// "</div>" +
// " <img style=\"float: left;\" src=\"NewImages/ButtonRight.png\" height=\"27px\" /> " +
// "</div>" +
// "</div>" +
// "</div></td>";
// label.Text += "</tr>";
// }
// //panel = new Panel();
// //Literal lNew = new Literal();
// if ((i % pagerPanel.NUMBER_OF_ITEMS_PER_PAGE) == 0)
// {
// label.Text = "<table cellpadding=\"5px\" width=\"700px\"><tbody style=\"\">"
// + label.Text;
// //panel.Controls.Add(lNew);
// }
// //Literal lOld = new Literal();
// //panel.Controls.Add(label);
// if ((i + 1) == 10 * pagecount || i == dvAdds.Count - 1)
// {
// label.Text = label.Text + "</tbody></table>";
// pagecount++;
// //panel.Controls.Add(lOld);
// }
// a.Add(label);
// }
// pagerPanel.DATA = a;
// pagerPanel.DataBind2();
// }
// else
// {
// pagerPanel.NUMBER_OF_ITEMS_PER_PAGE = 1;
// pagerPanel.WIDTH = 700;
// pagerPanel.NUMBER_OF_VISIBLE_PAGES = 1;
// ArrayList a = new ArrayList(1);
// Literal lit = new Literal();
// lit.Text = "<div style=\"padding: 10px;\"><label>You are not an owner of any ads. To post ads go to <a href=\"post-bulletin\" class=\"NavyLink12\">Post An Ad page</a>.</label></div>";
// a.Add(lit);
// pagerPanel.DATA = a;
// pagerPanel.DataBind2();
// }
//}
protected void GetEvents()
{
EventsPanel.Controls.Clear();
HttpCookie cookie = Request.Cookies["BrowserDate"];
Data dat = new Data(DateTime.Parse(cookie.Value.ToString().Replace("%20", " ").Replace("%3A", ":")));
DataSet dsAds = dat.GetData("SELECT * FROM Events E WHERE Owner=" + Session["User"].ToString() + " ORDER BY Header");
DataView dvAdds = new DataView(dsAds.Tables[0], "", "", DataViewRowState.CurrentRows);
Panel panel;
ASP.controls_pager_ascx pagerPanel = new ASP.controls_pager_ascx();
EventsPanel.Controls.Add(pagerPanel);
pagerPanel.PANEL_NAME = pagerPanel.ClientID + "_Panel";
DataView dvEvent;
if (dvAdds.Count > 0)
{
pagerPanel.NUMBER_OF_ITEMS_PER_PAGE = 10;
pagerPanel.WIDTH = 700;
pagerPanel.NUMBER_OF_VISIBLE_PAGES = 4;
ArrayList a = new ArrayList(dvAdds.Count);
int pagecount = 1;
for (int i = 0; i < dvAdds.Count; i++)
{
dvEvent = dat.GetDataDV("SELECT * FROM Events E, Event_Occurance EO Where E.ID=EO.EventID AND E.ID=" + dvAdds[i]["ID"].ToString() + " ORDER BY EO.DateTimeEnd");
Literal label = new Literal();
//label.CssClass = "AddLink";
string disableStr = "";
if (bool.Parse(dvAdds[i]["LIVE"].ToString()))
{
disableStr = "<td align=\"center\" width=\"50px\"><a class=\"PageButtons\" onclick=\"OpenRadDeleteEvent(" + dvAdds[i]["ID"].ToString() +
")\">Disable</a></td>";
//if (!bool.Parse(dvAdds[i]["Featured"].ToString()))
//{
if (DateTime.Parse(dvEvent[0]["DateTimeEnd"].ToString()) >= DateTime.Now)
{
disableStr += "<td align=\"center\" width=\"100px\"><div style=\"width: 65px\" align=\"center\">" +
"<div style=\"width: 100px;\" onclick=\"window.location = 'blog-event?edit=true&ID=" + dvAdds[i]["ID"].ToString() + "';\">" +
"<div class=\"topDiv\" style=\"clear: both;\">" +
" <img style=\"float: left;\" src=\"NewImages/ButtonLeft.png\" height=\"27px\" /> " +
" <div class=\"NavyLink\" style=\"font-size: 12px; text-decoration: none; padding-top: 5px;" +
"padding-left: 6px; padding-right: 6px;height: 27px;float: left;background: url('NewImages/ButtonPixel.png'); background-repeat: repeat-x;\">" +
" Edit " +
"</div>" +
" <img style=\"float: left;\" src=\"NewImages/ButtonRight.png\" height=\"27px\" /> " +
"</div>" +
"</div>" +
"</div></td>";
}
else
{
disableStr += "<td align=\"center\" width=\"100px\"><label>This event has passed</label></td>";
}
//}
//else
//{
// char[] delim = { ';' };
// string[] tokens = dvAdds[i]["DaysFeatured"].ToString().Split(delim, StringSplitOptions.RemoveEmptyEntries);
// disableStr += "<td align=\"center\" width=\"100px\"><label>Featured on ";
// foreach (string token in tokens)
// {
// disableStr += token + ", ";
// }
// disableStr = disableStr.Trim().Substring(0, disableStr.Trim().Length - 1) + "</label>";
// if (DateTime.Parse(dvEvent[0]["DateTimeEnd"].ToString()) >= DateTime.Now)
// {
// disableStr += "<td align=\"center\" width=\"170px\"><div style=\"width: 158px\" align=\"center\">" +
// "<div style=\"width: 160px;\" onclick=\"window.location = 'blog-event?edit=true&Feature=true&ID=" + dvAdds[i]["ID"].ToString() + "';\">" +
// "<div class=\"topDiv\" style=\"clear: both;\">" +
// " <img style=\"float: left;\" src=\"NewImages/ButtonLeft.png\" height=\"27px\" /> " +
// " <div class=\"NavyLink\" style=\"font-size: 12px; text-decoration: none; padding-top: 5px;" +
// "padding-left: 6px; padding-right: 6px;height: 27px;float: left;background: url('NewImages/ButtonPixel.png'); background-repeat: repeat-x;\">" +
// "Add More Feature Dates" +
// "</div>" +
// " <img style=\"float: left;\" src=\"NewImages/ButtonRight.png\" height=\"27px\" /> " +
// "</div>" +
// "</div>" +
// "</div></td>";
// }
// else
// {
// disableStr += "<td align=\"center\" width=\"140px\"><label>This event has passed</label></td>";
// }
// disableStr += "</tr>";
//}
}
else
{
disableStr = "<td align=\"center\" width=\"50px\"><a class=\"PageButtons\" onclick=\"OpenRadEnableEvent(" + dvAdds[i]["ID"].ToString() +
")\">Enable</a></td>";
//disableStr += "<td align=\"center\" width=\"100px\"><label>To feature event, enable it first.</label></td>";
}
if (i % 10 == 0)
label.Text = "<table cellpadding=\"5px\" width=\"700px\"><tbody style=\"\">";
label.Text += "<tr><td><a class=\"NavyLink12\" style=\"padding-left: 10px;\" href=\"" +
dat.MakeNiceName(dvAdds[i]["Header"].ToString()) + "_" + dvAdds[i]["ID"].ToString() + "_Event\">" +
dvAdds[i]["Header"].ToString() + "</a></td><td width=\"50px\"><a class=\"PageButtons\" href=\"blog-event?copy=true&ID=" +
dvAdds[i]["ID"].ToString() + "\">Copy</a></td>"+disableStr+"</tr>";
if ((i + 1) == 10 * pagecount || i == dvAdds.Count - 1)
{
label.Text += "</tbody></table>";
pagecount++;
}
//panel = new Panel();
//panel.Controls.Add(label);
a.Add(label);
}
pagerPanel.DATA = a;
pagerPanel.DataBind2();
}
else
{
pagerPanel.NUMBER_OF_ITEMS_PER_PAGE = 1;
pagerPanel.WIDTH = 700;
pagerPanel.NUMBER_OF_VISIBLE_PAGES = 1;
ArrayList a = new ArrayList(1);
Literal lit = new Literal();
lit.Text = "<div style=\"padding: 10px;\"><label>You are not an owner of any events. To post events go to <a href=\"enter-event\" class=\"AddLink\">Post An Event page</a>.</label></div>";
a.Add(lit);
pagerPanel.DATA = a;
pagerPanel.DataBind2();
}
}
protected void LoadControlsNotAJAX()
{
HttpCookie cookie = Request.Cookies["BrowserDate"];
try
{
Data dat = new Data(DateTime.Parse(cookie.Value.ToString().Replace("%20", " ").Replace("%3A", ":")));
DataSet ds = dat.GetData("SELECT TOP 100 UM.MessageSubject, UM.ID, UM.From_UserID, UM.MessageContent, UM.[Read], UM.Date, U.UserName, UM.Mode FROM UserMessages UM, Users U WHERE UM.Live='True' AND UM.To_UserID=" +
Session["User"].ToString() + " AND UM.From_UserID=U.User_ID AND UM.LIVE=1 ORDER BY Date DESC");
ASP.controls_pager_ascx pagerPanel = new ASP.controls_pager_ascx();
pagerPanel.PANEL_NAME = "ctl00_ContentPlaceHolder1_ctl156_Panel";
pagerPanel.NUMBER_OF_ITEMS_PER_PAGE = 1;
pagerPanel.WIDTH = 530;
pagerPanel.NUMBER_OF_VISIBLE_PAGES = 4;
ArrayList a = new ArrayList(ds.Tables[0].Rows.Count);
if (ds.Tables[0].Rows.Count == 0)
{
Literal lit = new Literal();
lit.Text = "<div style=\"border: solid 3px #dedbdb;" +
"float: left; width: 530px;\"><div style=\"width: 530px; display: block; float: left; margin" +
"-left: 5px;\"><table width=\"100%\"><tr><td><span class=\"TextNormal\" "+
"style=\"padding-left: 5px;\">(0 messages)</span></td></tr></table></div>" +
"<div style=\"width: 530px; display: block; float: left; margin-left: 5px; padding-bottom: 5px;\">" +
"</div></div>";
MessagesPanel.Controls.Add(lit);
}
else
{
int unreadCount = AddMessages(ds, ref a, false);
Label label = new Label();
string temp = "messages";
if (ds.Tables[0].Rows.Count == 1)
temp = "message";
if (unreadCount > 0)
{
RadTabStrip3.Tabs[0].Text = "<div style=\"float: left;\">Inbox </div>" +
"<div style=\"float: left;font-size: 12px; vertical-align: " +
"middle; font-weight: normal; padding-bottom: 3px;\" id=\"InboxDiv\">" +
"<div style=\"float: left;\"> (</div><div style=\"float: left;\" id=\"InboxInnerDiv\">" +
unreadCount.ToString() + " </div><div style=\"float: left;\"> New)</div></div>";
//label.Text = "<span style=\"font-family: Arial; font-size: 20px; color: White;\">My Messages</span>"
// + "<span style=\"font-family: Arial; font-size: 12px; padding-left: 5px;\">(" + unreadCount.ToString()
// + " new " + temp + ")</span>";
RadTabStrip3.Tabs[0].Value = unreadCount.ToString();
}
MessagesPanel.Controls.Clear();
//MessagesPanel.Controls.Add(label);
MessagesPanel.Controls.Add(pagerPanel);
pagerPanel.PANEL_NAME = pagerPanel.ClientID + "_Panel";
pagerPanel.DATA = a;
pagerPanel.DataBind2();
}
ds = dat.GetData("SELECT TOP 100 UM.MessageContent, UM.ID, UM.To_UserID AS From_UserID, UM.MessageSubject, UM.[Read], UM.Mode, UM.Date, U.UserName FROM UserMessages UM, Users U WHERE UM.From_UserID=" +
Session["User"].ToString() + " AND U.User_ID=UM.To_UserID AND UM.SentLive=1 ORDER BY Date DESC");
pagerPanel = new ASP.controls_pager_ascx();
pagerPanel.PANEL_NAME = "ctl00_ContentPlaceHolder1_ctl157_Panel";
pagerPanel.NUMBER_OF_ITEMS_PER_PAGE = 1;
pagerPanel.WIDTH = 530;
a = new ArrayList(ds.Tables[0].Rows.Count);
if (ds.Tables[0].Rows.Count == 0)
{
Literal lit = new Literal();
lit.Text = "<div style=\"border: solid 3px #dedbdb;" +
"float: left; width: 530px;\"><div style=\"width: 530px; display: block; float: left; margin" +
"-left: 5px;\"><table width=\"100%\"><tr><td><span class=\"TextNormal\" style=\" "+
"padding-left: 5px;\">(0 sent messages)</span></td></tr></table></div>" +
"<div style=\"width: 530px; display: block; float: left; margin-left: 5px; padding-bottom: 5px;\">" +
"</div></div>";
UsedMessagesPanel.Controls.Add(lit);
}
else
{
AddMessages(ds, ref a, true);
UsedMessagesPanel.Controls.Clear();
UsedMessagesPanel.Controls.Add(pagerPanel);
pagerPanel.PANEL_NAME = pagerPanel.ClientID + "_Panel";
pagerPanel.DATA = a;
pagerPanel.DataBind2();
}
}
catch (Exception ex)
{
UserErrorLabel.Text = ex.ToString();
}
}
protected void LoadControls()
{
HttpCookie cookie = Request.Cookies["BrowserDate"];
TheDiv.InnerHtml = "";
Data dat = new Data(DateTime.Parse(cookie.Value.ToString().Replace("%20", " ").Replace("%3A", ":")));
DataSet ds = dat.GetData("SELECT UM.MessageSubject, UM.MessageContent, U.UserName FROM UserMessages UM, Users U WHERE UM.Live='True' AND UM.To_UserID=" +
Session["User"].ToString() + " AND UM.From_UserID=U.User_ID ORDER BY Date DESC");
System.Drawing.Color greyText = System.Drawing.Color.FromArgb(102, 102, 102);
System.Drawing.Color greyBack = System.Drawing.Color.FromArgb(51, 51, 51);
ASP.controls_pager_ascx pagerPanel = new ASP.controls_pager_ascx();
pagerPanel.PANEL_NAME = "ctl00_ContentPlaceHolder1_ctl14_Panel";
pagerPanel.NUMBER_OF_ITEMS_PER_PAGE = 1;
ArrayList a = new ArrayList(ds.Tables[0].Rows.Count);
int unreadCount = 0;
int count = 0;
int times = 1;
Panel ItemsPanel = new Panel();
ItemsPanel.ID = "PanelM1";
if (ds.Tables.Count > 0)
if (ds.Tables[0].Rows.Count > 0)
{
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
if (count == 10 * times)
{
a.Add(ItemsPanel);
times++;
ItemsPanel = new Panel();
ItemsPanel.ID = "PanelM" + times.ToString();
}
count++;
DataSet dsUsers = dat.GetData("SELECT * FROM Users WHERE User_ID=" +
ds.Tables[0].Rows[i]["From_UserID"].ToString());
if (!bool.Parse(ds.Tables[0].Rows[i]["Read"].ToString()))
unreadCount++;
string boldOrNot = "font-size: 12px;";
if (!bool.Parse(ds.Tables[0].Rows[i]["Read"].ToString()))
boldOrNot = "font-weight:bold;font-size: 14px;";
HtmlGenericControl thediv = new HtmlGenericControl();
thediv.Attributes.Add("class", "MailHeader");
thediv.Attributes.Add("style", boldOrNot);
thediv.Attributes.Add("onclick", "OpenEmail('" + i.ToString() + "');");
//thediv.Attributes.Add("onserverclick", "MarkAsRead2");
thediv.ID = "header" + i.ToString();
string thedivsText = "";
//thedivsText = "<div class=\"MailHeader\" style=\""+boldOrNot+"\" "+
// "onclick=\"OpenEmail('"+i.ToString()+"');\" id=\"header"+i.ToString()+"\">";
//thedivsText += "<div style=\"display: none;\" id=\"readDiv"+i.ToString()+"\">"+
// ds.Tables[0].Rows[i]["Read"].ToString()+"</div>";
//thedivsText += "<div style=\"display: none;\" id=\"idDiv"+i.ToString()+"\">"+
// ds.Tables[0].Rows[i]["ID"].ToString()+"</div>";
//thedivsText += "<div style=\"display: none;\" id=\"userDiv" + i.ToString() + "\">" +
// Session["User"].ToString() + "</div>";
//thedivsText += "<div style=\"display: none;\" id=\"fromDiv" + i.ToString() + "\">" +
// ds.Tables[0].Rows[i]["From_UserID"].ToString() + "</div>";
string tempor2 = "";
string theUser = dsUsers.Tables[0].Rows[0]["UserName"].ToString();
if (ds.Tables[0].Rows[i]["Mode"].ToString() == "1")
{
theUser = "******";
tempor2 = " style=\"display:none;\" ";
}
string acceptHTML = "";
string tempor = "";
if (ds.Tables[0].Rows[i]["Mode"].ToString() == "2")
{
tempor2 = " style=\"display:none;\" ";
tempor = "<a class=\"Green12LinkNF\" href=\"javascript:AcceptFriend('" + i.ToString() + "');\">Accept Friend Request</a>";
DataSet isFirend = dat.GetData("SELECT * FROM User_Friends WHERE UserID="+Session["User"].ToString()+" AND FriendID="+ds.Tables[0].Rows[i]["From_UserID"].ToString());
if (isFirend.Tables.Count > 0)
if (isFirend.Tables[0].Rows.Count > 0)
tempor = "<span class=\"Green12LinkNF\">You are already friends with "+theUser + "</span>";
acceptHTML = "<div class=\"Green12LinkNF\" id=\"accept"+i.ToString()+"\">"+tempor+"</div><br/>";
}
thedivsText += "<table width=\"530px\" cellpadding=\"0\" cellspacing=\"0\"><tr><td><span style=\"padding-left:5px;font-family:Arial; "
+ "\">From: </span><span style=\"color: #1fb6e7; font-family: Arial;\">" + theUser
+ "</span></td><td ><span style=\"padding-top:10px;font-family:Arial;" +
" float:right;padding-right:5px;\">" +
ds.Tables[0].Rows[i]["Date"].ToString() + "</span></td></tr><tr><td colspan=\"3\"><span style=\"font-family:Arial; padding-left: 5px;\">Subject: <span id=\"subject" + i.ToString() + "\">"
+ ds.Tables[0].Rows[i]["MessageSubject"].ToString() +
"</span></span></td></tr></table>";
thedivsText += "</div>";
thediv.InnerHtml = thedivsText;
HtmlGenericControl messageDiv = new HtmlGenericControl();
messageDiv.Attributes.Add("style", "display: none;");
messageDiv.Attributes.Add("class", "MailContent EventBody");
messageDiv.ID = "contentDiv";
string messageDivsText = "";
//thedivsText += "<div style=\"display: none;\" class=\"MailContent EventBody\" id=\"contentDiv"+
// i.ToString()+"\">";
messageDivsText += "<table><tr><td width=\"285px\" valign=\"top\"><label>" +
ds.Tables[0].Rows[i]["MessageContent"].ToString()+" <br/><br/><br/> " +acceptHTML + "</label></td>";
messageDivsText += "<td valign=\"top\"><table ><tr><td width=\"285px\" align=\"right\">" +
"<img alt=\"Delete Message\" name=\"Delete Message\" style=\"cursor: pointer;\" "+
"onclick=\"DeleteEmail('" + i.ToString() + "');\" src=\"image/X.png\" "+
"onmouseover=\"this.src='image/XSelected.png'\" onmouseout=\"this.src='image/X.png'\" />"+
"</td></tr><tr><td " + tempor2 + "><textarea cols=\"30\" rows=\"10\" id=\"textDiv" +
i.ToString() + "\"></textarea></td></tr>";
messageDivsText += "<tr><td " + tempor2 + "><img onclick=\"ReplyMessage('" + i.ToString() +
"');\" src=\"image/ReplyButton.png\" onmouseout=\"this.src='image/ReplyButton.png'\""+
"onmouseover=\"this.src='image/ReplyButtonSelected.png'\" /></td></tr>";
messageDivsText += "<tr><td><div class=\"NavyLink12\" id=\"message" + i.ToString() + "\"></div></td></tr>";
messageDivsText += "</table></td></tr></table>";
//thedivsText += "</div>";
messageDiv.InnerHtml = messageDivsText;
ItemsPanel.Controls.Add(thediv);
//message.DATE = ds.Tables[0].Rows[i]["Date"].ToString();
//MessagePanel.Controls.Add(message);
}
if (ds.Tables[0].Rows.Count % 10 != 0 || ds.Tables[0].Rows.Count == 10)
{
a.Add(ItemsPanel);
}
}
Label label = new Label();
string temp = "messages";
if (ds.Tables[0].Rows.Count == 1)
temp = "message";
label.Text = "<table width=\"570px\"><tr><td><span style=\"font-family: Arial; font-size: 20px; color: White;\">My Messages</span>"
+ "<span style=\"font-family: Arial; font-size: 12px; padding-left: 5px;\">(<span id=\"messagesCount\">" + unreadCount.ToString()
+ "</span> new " + temp + ")</span></td><td align=\"right\"><div class=\"Green12LinkNF\" id=\"globalMessage\"></div></td></tr></table>";
Panel MessagesPanel = (Panel)Tab1.FindControl("MessagesPanel");
MessagesPanel.Controls.Clear();
MessagesPanel.Controls.Add(label);
MessagesPanel.Controls.Add(pagerPanel);
if (a.Count > 0)
{
pagerPanel.DATA = a;
pagerPanel.DataBind2();
}
}
protected void FillVenues()
{
HttpCookie cookie = Request.Cookies["BrowserDate"];
Data dat = new Data(DateTime.Parse(cookie.Value.ToString().Replace("%20", " ").Replace("%3A", ":")));
DataSet ds = dat.GetData("SELECT *, UV.VenueID AS VID FROM UserVenues UV, Venues V "+
"WHERE V.ID=UV.VenueID AND UV.UserID="+
Session["User"].ToString() + " ORDER BY V.Name");
bool noneExist = false;
if (ds.Tables.Count > 0)
if (ds.Tables[0].Rows.Count > 0)
{
ASP.controls_pager_ascx pagerPanel = new ASP.controls_pager_ascx();
pagerPanel.NUMBER_OF_ITEMS_PER_PAGE = 5;
pagerPanel.PANEL_CSSCLASS = "FavoritesPanel";
pagerPanel.WIDTH = 260;
ArrayList a = new ArrayList(ds.Tables[0].Rows.Count * 2);
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
Literal lit = new Literal();
lit.Text = "<div class=\"topDiv\"><div class=\"topDiv\" style=\"padding-top: 20px;\">";
Literal lit2 = new Literal();
lit2.Text = "</div>";
ASP.controls_hipporating_ascx rating = new ASP.controls_hipporating_ascx();
rating.VENUE_ID = ds.Tables[0].Rows[i]["ID"].ToString();
Label label = new Label();
label.Text = "<div style=\"float:left; padding-top: 4px;\"><a class=\"NavyLink12\" href=\"" +
dat.MakeNiceName(ds.Tables[0].Rows[i]["Name"].ToString()) +'_'+ ds.Tables[0].Rows[i]["ID"].ToString() + "_Venue\">" + ds.Tables[0].Rows[i]["Name"].ToString() + "</a></div>";
DataSet dsEvents = dat.GetData("SELECT * FROM Events E, Event_Occurance EO WHERE EO.EventID=E.ID AND "+
"DAY(EO.DateTimeStart) = DAY(GETDATE()) AND MONTH(EO.DateTimeStart) = MONTH(GETDATE()) AND YEAR"+
"(EO.DateTimeStart) = YEAR(GETDATE()) "
+ " AND E.Venue=" + ds.Tables[0].Rows[i]["VID"].ToString());
int count = 0;
if (dsEvents.Tables.Count > 0)
if (dsEvents.Tables[0].Rows.Count > 0)
count = dsEvents.Tables[0].Rows.Count;
string theColor = "";
if (count > 0)
theColor = "color: #ff6b09;";
Label label2 = new Label();
label2.Text = "<div style=\"display: block; padding-top: 3px;" + theColor +
"\">" + count + " event[s] going on today </div></div>";
Panel allP = new Panel();
allP.Controls.Add(lit);
allP.Controls.Add(label);
allP.Controls.Add(rating);
allP.Controls.Add(lit2);
allP.Controls.Add(label2);
a.Add(allP);
}
Literal newLit = new Literal();
newLit.Text = "<div class=\"topDiv\">";
FavoriteVenues.Controls.Add(newLit);
FavoriteVenues.Controls.Add(pagerPanel);
pagerPanel.PANEL_NAME = pagerPanel.ClientID + "_Panel";
pagerPanel.DATA = a;
pagerPanel.DataBind2();
newLit = new Literal();
newLit.Text = "</div>";
FavoriteVenues.Controls.Add(newLit);
}
else
noneExist = true;
else
noneExist = true;
if (noneExist)
{
Label label = new Label();
label.Text = "You have not added any locales to your favorite's list. To search for some awesome locales and make them your favorite visit the <a class=\"Green12LinkNF\" href=\"venue-search\">locale's page.</a>";
FavoriteVenues.Controls.Add(label);
}
}
protected void FillRecommendedEvents()
{
HttpCookie cookie = Request.Cookies["BrowserDate"];
Data dat = new Data(DateTime.Parse(cookie.Value.ToString().Replace("%20", " ").Replace("%3A", ":")));
//only show top 10
int topCount = 10;
//Put the sets together
DataSet dsAll = dat.RetrieveRecommendedEvents(topCount, true);
bool noneMessage = false;
if (dsAll.Tables.Count > 0)
if (dsAll.Tables[0].Rows.Count > 0)
{
//insert link to all recommended events
Session["RecomDS"] = dsAll;
Literal link = new Literal();
link.Text = "<h4 style=\"margin-bottom: 5px;\">Top 10 Recommended Events</h4><div><a class=\"NavyLink12\" onclick=\"OpenRadRecom();\">See All</a></div>";
RecommendedEvents.Controls.Add(link);
Hashtable hash = new Hashtable();
ASP.controls_pager_ascx pagerPanel = new ASP.controls_pager_ascx();
pagerPanel.PANEL_NAME = "ctl00_ContentPlaceHolder1_ctl13_Panel";
pagerPanel.NUMBER_OF_ITEMS_PER_PAGE = 3;
pagerPanel.PANEL_CSSCLASS = "FavoritesPanel";
pagerPanel.WIDTH = 260;
ArrayList a = new ArrayList(topCount);
for (int i = 0; i < topCount; i++)
{
dat.InsertOneEvent(dsAll, i, ref a, false);
}
RecommendedEvents.Controls.Add(pagerPanel);
pagerPanel.DATA = a;
pagerPanel.DataBind2();
}
else
{
noneMessage = true;
}
else
noneMessage = true;
if (noneMessage)
{
Label lab = new Label();
lab.Text = "There are no recommended events here this month. There are a few reasons for this. "+
"There simply is no events that fit your recommendation criteria, or you have selected not to "+
"recommend any events. To modify your preferences please visit the 'My Preferences' tab on this page.";
RecommendedEvents.Controls.Add(lab);
}
}
protected void FillEvents(DataSet dsAll)
{
HttpCookie cookie = Request.Cookies["BrowserDate"];
Data dat = new Data(DateTime.Parse(cookie.Value.ToString().Replace("%20", " ").Replace("%3A", ":")));
int count = dsAll.Tables[0].Rows.Count;
Encryption decrypt = new Encryption();
//if (Request.QueryString["message"] != null)
// MessageLabel.Text = decrypt.decrypt(Request.QueryString["message"].ToString());
//else if (Session["Message"] != null)
//{
// MessageLabel.Text = Session["Message"].ToString();
//}
if (count > 0)
{
ASP.controls_pager_ascx pagerPanel = new ASP.controls_pager_ascx();
pagerPanel.NUMBER_OF_ITEMS_PER_PAGE = 6;
pagerPanel.PANEL_NAME = "ctl02_Panel";
pagerPanel.PANEL_CSSCLASS = "FavoritesPanel";
pagerPanel.WIDTH = 650;
ArrayList a = new ArrayList(count * 4);
for (int i = 0; i < count; i++)
{
dat.InsertOneEvent(dsAll, i, ref a, true);
}
RecommendedEvents.Controls.Clear();
RecommendedEvents.Controls.Add(pagerPanel);
pagerPanel.DATA = a;
pagerPanel.DataBind2();
}
else
{
Label lab = new Label();
lab.CssClass = "EventBody";
lab.Text = "<br/>No Recommended events in this time frame.";
RecommendedEvents.Controls.Clear();
RecommendedEvents.Controls.Add(lab);
}
}
public void DataBind2()
{
HttpCookie cookie = Request.Cookies["BrowserDate"];
if (pollID != -1)
{
int pollCount = 0;
Data dat = new Data(DateTime.Parse(cookie.Value.ToString().Replace("%20", " ").Replace("%3A", ":")));
DataSet pollsDS;
if (Session["User"] != null)
{
string commentPrefs = dat.GetData("SELECT * FROM UserPreferences WHERE UserID=" + Session["User"].ToString()).Tables[0].Rows[0]["PollPreferences"].ToString();
if (commentPrefs == "1")
{
pollsDS = dat.GetData("SELECT * FROM PollAnswers WHERE PollID=" + pollID.ToString() + " AND UserID <> " + Session["User"].ToString());
}
else
{
pollsDS = dat.GetData("SELECT * FROM PollAnswers PA, Users U, User_Friends UF WHERE UF.UserID=" + Session["User"].ToString() + " AND UF.FriendID=U.User_ID AND U.User_ID=PA.UserID AND PA.PollID=" + pollID.ToString());
}
}
else
{
pollsDS = dat.GetData("SELECT * FROM PollAnswers WHERE PollID=" + pollID.ToString() + " AND UserID <> " + Session["User"].ToString());
}
if (pollsDS.Tables.Count > 0)
{
pollCount = pollsDS.Tables[0].Rows.Count;
Label title = new Label();
title.CssClass = "EventHeader";
title.Text = "Answers:";
PollElementsPanel.Controls.Add(title);
}
ArrayList a = new ArrayList(pollCount);
for (int i = 0; i < pollCount; i++)
{
if (pollsDS.Tables[0].Rows[i]["Answer"].ToString() == "" && pollsDS.Tables[0].Rows[i]["MediaCategory"].ToString() == "0")
{
}
else
{
ASP.controls_pollanswer_ascx pollElement = new ASP.controls_pollanswer_ascx();
pollElement.ANSWER_ID = int.Parse(pollsDS.Tables[0].Rows[i]["AnswerID"].ToString());
pollElement.POLL_ID = pollID;
pollElement.USER_ID = int.Parse(pollsDS.Tables[0].Rows[i]["UserID"].ToString());
a.Add(pollElement);
}
//pagerPanel.Add(searchElement);
}
ASP.controls_pager_ascx pagerPanel = new ASP.controls_pager_ascx();
pagerPanel.NUMBER_OF_ITEMS_PER_PAGE = 10;
pagerPanel.DATA = a;
pagerPanel.DataBind2();
PollElementsPanel.Controls.Add(pagerPanel);
}
}
public int DataBind2()
{
HttpCookie cookie = Request.Cookies["BrowserDate"];
DateTime isn = DateTime.Now;
if (!DateTime.TryParse(cookie.Value.ToString().Replace("%20", " ").Replace("%3A", ":"), out isn))
isn = DateTime.Now;
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;
pagerPanel.ID = "PagerPanel";
if (Request.Url.AbsolutePath.ToLower() == "/tripsearch.aspx")
{
dv.Sort = "colOrder ASC";
pagerPanel.RUN_FUNCTION = "initialize";
pagerPanel.PANEL_NAME = "ctl00_ContentPlaceHolder1_EventSearchElements_PagerPanel_Panel";
}
else if (Request.Url.AbsolutePath.ToLower() == "/tripcategorysearch.aspx")
{
pagerPanel.PANEL_NAME = "ctl00_ContentPlaceHolder1_SearchElements_PagerPanel_Panel";
}
int mapCount = 0;
string means = "";
foreach(DataRowView row in dv)
{
if (countGotten < searchTo)
{
try
{
ASP.controls_tripsearchelement_ascx searchElement = new ASP.controls_tripsearchelement_ascx();
if (bool.Parse(row["Featured"].ToString()))
{
if (row["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();
means = "";
if (row["Means"].ToString().Contains(";1"))
{
means += "Car, ";
}
if (row["Means"].ToString().Contains(";2"))
{
means += "Walking, ";
}
if (row["Means"].ToString().Contains(";3"))
{
means += "Hiking, ";
}
if (row["Means"].ToString().Contains(";4"))
{
means += "Biking, ";
}
if (row["Means"].ToString().Contains(";5"))
{
means += "Flying, ";
}
if (row["PriceRange"].ToString().Trim() != "")
means = row["PriceRange"].ToString() + ", " + means;
searchElement.PRICE_MEANS_TIMEFRAME = means + row["TimeFrame"].ToString();
string toolTipID = "";
searchElement.EVENT_ID = int.Parse(row["EID"].ToString());
searchElement.IS_WINDOW = false;
if (doMap)
{
searchElement.SEARCH_MAP_NUM = row["SearchNum"].ToString();
}
toolTipID = "False" + row["EID"].ToString();
searchElement.TOOL_TIP_ID = toolTipID;
if (isConnectTo)
{
searchElement.IS_CONNECT_TO = bool.Parse(row["isConnect"].ToString());
searchElement.WIDTH = 417;
}
//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;
}
public void DataBind2()
{
if (adDS != null)
{
int adCount = 0;
if (adDS.Tables.Count > 0)
adCount = adDS.Tables[0].Rows.Count;
ArrayList a = new ArrayList(adCount);
HttpCookie cookie = Request.Cookies["BrowserDate"];
DateTime isn = DateTime.Now;
if (!DateTime.TryParse(cookie.Value.ToString().Replace("%20", " ").Replace("%3A", ":"), out isn))
isn = DateTime.Now;
DateTime isNow = isn;
Data dat = new Data(isn);
string featureDate = isNow.Month.ToString() + "/" + isNow.Day.ToString() + "/" + isNow.Year.ToString();
int searchTo = adCount;
if (dat.SearchCutOffNumber < adCount)
{
searchTo = dat.SearchCutOffNumber;
}
DataView dvAd;
DataView dvAds = new DataView(adDS.Tables[0], "", "", DataViewRowState.CurrentRows);
ASP.controls_pager_ascx pagerPanel = new ASP.controls_pager_ascx();
if (Request.Url.AbsolutePath.ToLower() == "/adsearch.aspx")
{
pagerPanel.PANEL_NAME = "AdSearchElements_ctl00_Panel";
dvAds.Sort = "colOrder ASC";
}
else
{
pagerPanel.PANEL_NAME = "ctl00_ContentPlaceHolder1_SearchElements_ctl00_Panel";
}
foreach(DataRowView ad in dvAds)
{
ASP.controls_adsearchelement_ascx searchElement = new ASP.controls_adsearchelement_ascx();
searchElement.AD_ID = int.Parse(ad["VID"].ToString());
searchElement.SEARCH_LABEL = ad["Header"].ToString();
searchElement.IS_WINDOW = windowT;
dvAd = dat.GetDataDV("SELECT * FROM Ads WHERE Ad_ID=" + ad["VID"].ToString());
if (bool.Parse(dvAd[0]["Featured"].ToString()))
{
if (dvAd[0]["DatesOfAd"].ToString().Contains(";" + featureDate + ";"))
searchElement.IS_FEATURED = true;
else
searchElement.IS_FEATURED = false;
}
else
{
searchElement.IS_FEATURED = false;
}
a.Add(searchElement);
//pagerPanel.Add(searchElement);
}
SearchElementsPanel.Controls.Add(pagerPanel);
pagerPanel.NUMBER_OF_ITEMS_PER_PAGE = 10;
pagerPanel.DATA = a;
pagerPanel.WIDTH = 420;
pagerPanel.PANEL_NAME = pagerPanel.ClientID + "_Panel";
pagerPanel.DataBind2();
}
}
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;
}
public void DataBind2()
{
HttpCookie cookie = Request.Cookies["BrowserDate"];
if (venueDS != null)
{
int venueCount = 0;
if (venueDS.Tables.Count > 0)
venueCount = venueDS.Tables[0].Rows.Count;
ArrayList a = new ArrayList(venueCount);
DateTime isn = DateTime.Now;
if (!DateTime.TryParse(cookie.Value.ToString().Replace("%20", " ").Replace("%3A", ":"), out isn))
isn = DateTime.Now;
DateTime isNow = isn;
Data dat = new Data(isn);
string featureDate = isNow.Month.ToString() + "/" + isNow.Day.ToString() + "/" + isNow.Year.ToString();
int searchTo = venueCount;
if (dat.SearchCutOffNumber < venueCount)
{
searchTo = dat.SearchCutOffNumber;
}
int mapCount = 0;
DataView dv = new DataView(venueDS.Tables[0], "", "", DataViewRowState.CurrentRows);
ASP.controls_pager_ascx pagerPanel = new ASP.controls_pager_ascx();
pagerPanel.NUMBER_OF_ITEMS_PER_PAGE = num_of_pages;
if (Request.Url.AbsolutePath.ToLower() == "/venuesearch.aspx")
{
pagerPanel.PANEL_NAME = "ctl00_ContentPlaceHolder1_VenueSearchElements_ctl00_Panel";
pagerPanel.RUN_FUNCTION = "initialize";
dv.Sort = "colOrder ASC";
}
else if (Request.Url.AbsolutePath.ToLower() == "/venuecategorysearch.aspx")
{
pagerPanel.PANEL_NAME = "ctl00_ContentPlaceHolder1_SearchElements_ctl00_Panel";
}
int countGotten = 0;
foreach (DataRowView row in dv)
{
if (countGotten < searchTo)
{
ASP.controls_venuesearchelement_ascx searchElement = new ASP.controls_venuesearchelement_ascx();
searchElement.Venue_ID = int.Parse(row["VID"].ToString());
searchElement.SEARCH_LABEL = dat.stripHTML(row["Name"].ToString());
searchElement.CITY = row["City"].ToString();
searchElement.STATE = row["State"].ToString();
searchElement.NUM_OF_ALL_RESULTS = searchTo;
if (bool.Parse(row["Featured"].ToString()))
{
if (row["DaysFeatured"].ToString().Contains(";" + featureDate + ";"))
searchElement.IS_FEATURED = true;
else
searchElement.IS_FEATURED = false;
}
else
{
searchElement.IS_FEATURED = false;
}
if (doMap)
{
searchElement.SEARCH_MAP_NUM = row["SearchNum"].ToString();
}
a.Add(searchElement);
}
else
{
break;
}
}
SearchElementsPanel.Controls.Add(pagerPanel);
pagerPanel.PANEL_NAME = pagerPanel.ClientID + "_Panel";
pagerPanel.DATA = a;
pagerPanel.WIDTH = 420;
pagerPanel.DataBind2();
}
}
