protected void Page_Load(object sender, EventArgs e)
{
HttpCookie cookie = Request.Cookies["BrowserDate"];
Data dat = new Data(DateTime.Parse(cookie.Value.ToString().Replace("%20", " ").Replace("%3A", ":")));
BeginingLiteral.Text = "<div style=\"background-color:" +
color + "; width: " + width.ToString() + "px; padding: 3px; margin-bottom: 3px;\">";
SearchLabel.Text = searchLabel;
//search = true is disabled here
if (windowT)
{
SearchLabel.Attributes.Add("onclick", "CloseWindow('" + "../" + dat.MakeNiceName(searchLabel) + "_" + adID + "_Ad" + "');");
}
else
{
SearchLabel.NavigateUrl = "../" + dat.MakeNiceName(searchLabel) + "_" + adID + "_Ad";
}
string begining = "<a style=\"color: #b1a812; font-family: Arial; font-size: 11px;\">";
string end = "</a>";
dat.TAG_TYPE = Data.tagType.AD;
string tags = dat.getTags(dat.GetData("SELECT C.ID, C.Name AS CategoryName, ACM.tagSize FROM Ad_Category_Mapping ACM, AdCategories C WHERE ACM.CategoryID=C.ID AND ACM.AdID=" + adID), false, windowT);
TagsLiteral.Text = "<span style=\"color: #b1a812; line-height: 10px; font-size: 11px;\" >" + tags + "</span>";
}
protected void DrawEvents(DataView dvEvents, int cutOff)
{
string eventID = GetEventID();
HttpCookie cookie = Request.Cookies["BrowserDate"];
if (cookie == null)
{
cookie = new HttpCookie("BrowserDate");
cookie.Value = DateTime.Now.ToString();
cookie.Expires = DateTime.Now.AddDays(22);
Response.Cookies.Add(cookie);
}
DateTime isNow = DateTime.Parse(cookie.Value.ToString().Replace("%20", " ").Replace("%3A", ":"));
Data dat = new Data(DateTime.Parse(cookie.Value.ToString().Replace("%20", " ").Replace("%3A", ":")));
Literal lit = new Literal();
int count = 0;
DataView dvEvent;
string contentSub = "";
foreach (DataRowView row in dvEvents)
{
if (count > cutOff - 1)
{
break;
}
else
{
contentSub = dat.stripHTML(row["Content"].ToString().Replace("<br>",
"").Replace("</br>", "").Replace("<br/>", "").Replace("<BR>", "").Replace("<BR/>",
"").Replace("<br />", "").Replace("<BR />", ""));
if (dat.stripHTML(row["Content"].ToString().Replace("<br>",
"").Replace("</br>", "").Replace("<br/>", "").Replace("<BR>", "").Replace("<BR/>",
"").Replace("<br />", "").Replace("<BR />", "")).Length > 100)
contentSub = dat.stripHTML(row["Content"].ToString().Replace("<br>",
"").Replace("</br>", "").Replace("<br/>", "").Replace("<BR>", "").Replace("<BR/>",
"").Replace("<br />", "").Replace("<BR />", "")).Substring(0, 100);
dvEvent = dat.GetDataDV("SELECT * FROM Events E, Event_Occurance EO WHERE E.ID=EO.EventID AND E.ID=" + row["EventID"].ToString());
lit.Text += "<div class=\"SimilarSide\">";
lit.Text += "<a class=\"Blue12Link\" href=\"" + dat.MakeNiceName(row["Header"].ToString()) +
"_" + row["EventID"].ToString() + "_Event\">" + row["Header"].ToString() +
"</a> at " + "<a class=\"Green12LinkNF\" href=\"" + dat.MakeNiceName(row["Name"].ToString()) +
"_" + row["Venue"].ToString() + "_Venue\">" + row["Name"].ToString() + "</a> on " +
DateTime.Parse(dvEvent[0]["DateTimeStart"].ToString()).ToShortDateString() +
". " + dat.BreakUpString(contentSub, 30) +
"... <a class=\"Blue12Link\" href=\"" + dat.MakeNiceName(row["Header"].ToString()) +
"_" + row["EventID"].ToString() + "_Event\">Read More</a>";
lit.Text += "</div>";
count++;
}
}
OtherEventsPanel.Controls.Add(lit);
}
protected void Page_Load(object sender, EventArgs e)
{
Data dat = new Data(DateTime.Now);
DayLabel.Text = day;
MonthLabel.Text = month;
DayNumberLabel.Text = daynumber;
EventNameLabel.Text = eventname;
theTable.Attributes.Add("onclick", "window.location = '" + dat.MakeNiceName(eventname) + "_" + eventID + "_Event'");
EventNameLabel.NavigateUrl = "~/" + dat.MakeNiceName(eventname) + "_" + eventID + "_Event";
SummaryLabel.Text = summary;
ReadMoreLink.NavigateUrl = "~/" + dat.MakeNiceName(eventname) + "_" + eventID + "_Event";
//ReadMoreLink.NavigateUrl = "~/Event.aspx?EventID="+eventID;
}
protected void DrawBulletins(DataView dvEvents, int cutOff)
{
string eventID = Request.QueryString["AdID"];
HttpCookie cookie = Request.Cookies["BrowserDate"];
if (cookie == null)
{
cookie = new HttpCookie("BrowserDate");
cookie.Value = DateTime.Now.ToString();
cookie.Expires = DateTime.Now.AddDays(22);
Response.Cookies.Add(cookie);
}
DateTime isNow = DateTime.Parse(cookie.Value.ToString().Replace("%20", " ").Replace("%3A", ":"));
Data dat = new Data(DateTime.Parse(cookie.Value.ToString().Replace("%20", " ").Replace("%3A", ":")));
Literal lit = new Literal();
int count = 0;
DataView dvEvent;
string contentSub = "";
foreach (DataRowView row in dvEvents)
{
if (count > cutOff - 1)
{
break;
}
else
{
contentSub = dat.stripHTML(row["Content"].ToString().Replace("<br>",
"").Replace("</br>", "").Replace("<br/>", "").Replace("<BR>", "").Replace("<BR/>",
"").Replace("<br />", "").Replace("<BR />", ""));
if (dat.stripHTML(row["Content"].ToString().Replace("<br>",
"").Replace("</br>", "").Replace("<br/>", "").Replace("<BR>", "").Replace("<BR/>",
"").Replace("<br />", "").Replace("<BR />", "")).Length > 100)
contentSub = dat.stripHTML(row["Content"].ToString().Replace("<br>",
"").Replace("</br>", "").Replace("<br/>", "").Replace("<BR>", "").Replace("<BR/>",
"").Replace("<br />", "").Replace("<BR />", "")).Substring(0, 100);
lit.Text += "<div class=\"SimilarSide\">";
lit.Text += "<a class=\"Green12LinkNF\" href=\"" + dat.MakeNiceName(row["Header"].ToString()) +
"_" + row["AdID"].ToString() + "_Ad\">" + row["Header"].ToString() +
"</a>. " + dat.BreakUpString(contentSub, 30) +
"... <a class=\"Blue12Link\" href=\"" + dat.MakeNiceName(row["Header"].ToString()) +
"_" + row["AdID"].ToString() + "_Ad\">Read More</a>";
lit.Text += "</div>";
count++;
}
}
OtherAdsPanel.Controls.Add(lit);
}
protected void Page_Load(object sender, EventArgs e)
{
HtmlMeta hm = new HtmlMeta();
HtmlHead head = (HtmlHead)Page.Header;
hm.Name = "ROBOTS";
hm.Content = "NOINDEX, FOLLOW";
head.Controls.AddAt(0, hm);
HttpCookie cookie = Request.Cookies["BrowserDate"];
if (cookie == null)
{
cookie = new HttpCookie("BrowserDate");
cookie.Value = DateTime.Now.ToString();
cookie.Expires = DateTime.Now.AddDays(22);
Response.Cookies.Add(cookie);
}
//Ajax.Utility.RegisterTypeForAjax(typeof(Delete));
if (!IsPostBack)
{
string cookieName = FormsAuthentication.FormsCookieName;
HttpCookie authCookie = Context.Request.Cookies[cookieName];
Data dat = new Data(DateTime.Parse(cookie.Value.ToString().Replace("%20", " ").Replace("%3A", ":")));
DataView dvEvent = dat.GetDataDV("SELECT * FROM GroupEvents WHERE ID=" +
Request.QueryString["ID"].ToString());
string groupID = dvEvent[0]["GroupID"].ToString();
DataView dvGroup = dat.GetDataDV("SELECT * FROM Groups WHERE ID=" + groupID);
ImageButton9.OnClientClick = "Search('" + dat.MakeNiceName(dvGroup[0]["Header"].ToString()) + "_" + groupID + "_Group');";
TextLabel.Text = "Are you sure you want to delete the event '" + dvEvent[0]["Name"].ToString() +
"' from the group '" + dvGroup[0]["Header"].ToString() + "'";
}
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
HtmlMeta hm = new HtmlMeta();
HtmlHead head = (HtmlHead)Page.Header;
hm.Name = "ROBOTS";
hm.Content = "NOINDEX, FOLLOW";
head.Controls.AddAt(0, hm);
HttpCookie cookie = Request.Cookies["BrowserDate"];
Data dat = new Data(DateTime.Parse(cookie.Value.ToString().Replace("%20", " ").Replace("%3A", ":")));
DataView dvGroupEvent = dat.GetDataDV("SELECT * FROM GroupEvents WHERE ID=" + Request.QueryString["ID"].ToString());
ImageButton9.OnClientClick = "javascript:Search('" +
dat.MakeNiceName(dvGroupEvent[0]["Name"].ToString()) + "_" + Request.QueryString["O"].ToString() + "_" +
Request.QueryString["ID"].ToString() + "_GroupEvent');";
string groupID = Request.QueryString["ID"].ToString();
string command = "SELECT * FROM Group_Members WHERE GroupID=" +
dvGroupEvent[0]["GroupID"].ToString() + " AND MemberID=" + Session["User"].ToString();
DataView dvMembers = dat.GetDataDV(command);
if (bool.Parse(dvMembers[0]["SharedHosting"].ToString()))
{
HostPanel.Visible = true;
}
else
HostPanel.Visible = false;
}
catch (Exception ex)
{
ErrorLabel.Text = ex.ToString();
}
}
protected void Page_Load(object sender, EventArgs e)
{
HttpCookie cookie = Request.Cookies["BrowserDate"];
if (cookie == null)
{
cookie = new HttpCookie("BrowserDate");
cookie.Value = DateTime.Now.ToString();
cookie.Expires = DateTime.Now.AddDays(22);
Response.Cookies.Add(cookie);
}
Data dat = new Data(DateTime.Parse(cookie.Value.ToString().Replace("%20", " ").Replace("%3A", ":")));
if (Session["User"] == null)
{
Response.Redirect("~/Home.aspx");
}
if (Request.QueryString["ID"] == null)
Response.Redirect("Home.aspx");
if (dat.HasEventPassed(Request.QueryString["ID"].ToString()))
{
DataView dvName = dat.GetDataDV("SELECT * FROM Events WHERE ID="+
Request.QueryString["ID"].ToString());
Response.Redirect(dat.MakeNiceName(dvName[0]["Header"].ToString()) + "_" +
Request.QueryString["ID"].ToString() + "_Event");
}
}
protected void Page_Load(object sender, EventArgs e)
{
HttpCookie cookie = Request.Cookies["BrowserDate"];
Data dat = new Data(DateTime.Parse(cookie.Value.ToString().Replace("%20", " ").Replace("%3A", ":")));
TitleLabel.Text = title;
TitleLabel.NavigateUrl = "../" + dat.MakeNiceName(title) + "_" + eventID + "_Event";
summary = summary.Replace("<br/>", " ");
if (summary.Length > 70)
summary = dat.BreakUpString(summary.Substring(0, 70), 35) + "...";
OtherEventSummaryLabel.Text = summary;
PresentedByLabel.Text = "presented on " + presentedBy;
}
protected void SubmitIt(object sender, EventArgs e)
{
HttpCookie cookie = Request.Cookies["BrowserDate"];
Data dat = new Data(DateTime.Parse(cookie.Value.ToString().Replace("%20", " ").Replace("%3A", ":")));
if (UpdateText.Text.Trim() != "")
{
SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["Connection"].ToString());
conn.Open();
SqlCommand cmd = new SqlCommand("INSERT INTO EventUpdates (modifierID, EventID, eventChange) "+
"VALUES("+Session["User"].ToString()+", "+Request.QueryString["ID"].ToString()+", @p3)", conn);
cmd.Parameters.Add("@p3", SqlDbType.NVarChar).Value = UpdateText.Text;
cmd.ExecuteNonQuery();
conn.Close();
string ID = Request.QueryString["ID"].ToString();
Encryption encrypt = new Encryption();
DataSet dsEvent = dat.GetData("SELECT * FROM Events WHERE ID=" + ID);
//send email to users who have this event in their calendar and selected their preferences
string emailBody = "<br/><br/>Updates have been made to an event in your calendar: Event '\"" + dsEvent.Tables[0].Rows[0]["Header"].ToString() +
"\"'. <br/><br/> To view these updates, please go to this event's <a href=\"http://hippohappenings.com/" + dat.MakeNiceName(dsEvent.Tables[0].Rows[0]["Header"].ToString())+
"_" + ID + "_Event\">page</a> and click on the updates drop down. " +
"<br/><br/><br/>Have a Hippo Happening Day!<br/><br/> <a href=\"http://HippoHappenings.com\">Happening Hippo</a>";
DataSet dsAllUsers = dat.GetData("SELECT * FROM User_Calendar UC, Users U, UserPreferences UP WHERE U.User_ID=UP.UserID AND UP.EmailPrefs LIKE '%C%' AND U.User_ID=UC.UserID AND UC.EventID=" + ID);
DataView dv = new DataView(dsAllUsers.Tables[0], "", "", DataViewRowState.CurrentRows);
if (dv.Count > 0)
{
for (int i = 0; i < dv.Count; i++)
{
dat.SendEmail(System.Configuration.ConfigurationManager.AppSettings["emailemail"].ToString(),
System.Configuration.ConfigurationManager.AppSettings["emailName"].ToString(),
dv[i]["Email"].ToString(), emailBody,
"Event '" + dsEvent.Tables[0].Rows[0]["Header"].ToString() + "' has been modified");
}
}
Session["Message"] = "Your update has been posted successfully<br/><br/> Here are your next steps. <br/><br/>";
Session["Message"] += "<br/><br/>" + "-Go to <a class=\"AddLink\" onclick=\"Search('" +
dat.MakeNiceName(dsEvent.Tables[0].Rows[0]["Header"].ToString()) + "_" + ID + "_Event');\">this event's</a> home page.<br/><br/> -<a class=\"AddLink\" onclick=\"Search('RateExperience.aspx?Type=E&ID=" + ID + "');\" >Rate </a>your user experience posting this event.";
MessageRadWindow.NavigateUrl = "Message.aspx?message=" + encrypt.encrypt(Session["Message"].ToString() +
"<br/><br/><img onclick=\"Search('Home.aspx');\" onmouseover=\"this.src='image/DoneSonButtonSelected.png'\" onmouseout=\"this.src='image/DoneSonButton.png'\" src=\"image/DoneSonButton.png\"/><br/>");
MessageRadWindow.Visible = true;
MessageRadWindowManager.VisibleOnPageLoad = true;
}
else
{
ErrorLabel.Text = "Please enter an Update.";
}
}
protected void Page_Load(object sender, EventArgs e)
{
HtmlMeta hm = new HtmlMeta();
HtmlHead head = (HtmlHead)Page.Header;
hm.Name = "ROBOTS";
hm.Content = "NOINDEX, FOLLOW";
head.Controls.AddAt(0, hm);
HttpCookie cookie = Request.Cookies["BrowserDate"];
Data dat = new Data(DateTime.Parse(cookie.Value.ToString().Replace("%20", " ").Replace("%3A", ":")));
DataView dvGroupEvent = dat.GetDataDV("SELECT * FROM GroupEvents WHERE ID=" +
Request.QueryString["ID"].ToString());
ImageButton9.OnClientClick = "javascript:Search('" +
dat.MakeNiceName(dvGroupEvent[0]["Name"].ToString()) + "_" + Request.QueryString["O"].ToString() + "_" +
Request.QueryString["ID"].ToString() + "_GroupEvent');";
}
protected void Page_Load(object sender, EventArgs e)
{
Data dat = new Data(DateTime.Now);
if(Request.QueryString["ID"] == null)
Response.Redirect("../home");
string theID = Request.QueryString["ID"].ToString();
DataView dv = dat.GetDataDV("SELECT * FROM HippoBlogContent WHERE ID=" + theID);
TitleLiteral.Text = dv[0]["Title"].ToString();
TagLineLiteral.Text = dv[0]["TagLine"].ToString();
MainContentLiteral.Text = dv[0]["MainContent"].ToString();
MainImage.Visible = false;
if (dv[0]["MainImage"].ToString() != "")
{
MainImage.ImageUrl = dv[0]["MainImage"].ToString();
MainImage.Visible = true;
}
Page.Title = dat.MakeNiceName(dv[0]["Title"].ToString());
}
protected string GetEmailString(string header, string picture, string ID, string description,
string userName, ref int normalAdCount, string templateID)
{
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 adtitle = "style=\"color: #7c7a7a;font-size: 14px;font-weight: bold;text-decoration: none;\"";
string adbody = "style=\"color: #7c7a7a;font-size: 12px;font-weight: normal;\"";
string readmorelink = "style=\"color: #09718F;text-decoration: none;cursor: pointer;\"";
string email = "";
string w = "";
string h = "";
if (normalAdCount % 2 == 0)
{
email += "<tr><td>";
}
else
{
email += "<td>";
}
email += "<div align=\"center\" style=\"position: relative;float: left;width: 198px; height: 262px;border: solid 1px #d9d6d6; " +
"margin-right: 2px; " +
"\">";
if (picture == null)
{
email += "<div style=\"padding-top: 10px; clear: both; padding-left: 1px;\">";
}
else
{
GetAdSize(out w, out h, picture, templateID);
if (templateID == "1")
{
email += "<div style=\"padding-top: 10px; clear: both; padding-left: 1px;\"><div style=\"float: left;padding-right: 2px;\"><table width=\"100px\" height=\"100px\" " +
"cellpadding=\"0\" cellspacing=\"0\"><tbody align=\"center\"><tr><td valign=\"middle\">";
}
else if (templateID == "2")
{
email += "<div style=\"padding-top: 10px; clear: both;\"><div style=\"float: left;padding-right: 2px;\"><table width=\"198px\" height=\"140px\" " +
"cellpadding=\"0\" cellspacing=\"0\"><tbody align=\"center\"><tr><td valign=\"middle\"> ";
}
else
{
email += "<div style=\"clear: both;\"><div center=\"float\" style=\"float: left;\"><table width=\"198px\" height=\"262px\" " +
"cellpadding=\"0\" cellspacing=\"0\"><tbody align=\"center\"><tr><td valign=\"middle\"> ";
}
if (ID == null)
{
email += "<img alt=\"" + header + "\" " +
"name=\"" + header + "\" width='" + w + "px' height='" + h + "px' src=\"./UserFiles/" +
userName + "/" + picture + "\" /></td></tr></tbody></table></div>";
}
else
{
email += "<a href=\"http://HippoHappenings.com/" + dat.MakeNiceName(header) + "_" + ID + "_Ad" +
"\" ><img style='border: 0;' alt=\"" + header + "\" " +
"name=\"" + header + "\" width='" + w + "px' height='" + h + "px' src=\"http://hippohappenings.com/UserFiles/" +
userName + "/" + picture + "\" /></a></td></tr></tbody></table></div>";
}
}
if (ID == null)
{
if (templateID == "1")
{
email += "<div><a class=\"Text14\">" + dat.BreakUpString(header, 10) +
"</a></div></div>" +
"<div align=\"center\" style=\"clear: both; padding-left: 2px; padding-right: 2px;" +
"padding-top: 1px;\"> " +
"<span class=\"Text12\">" +
dat.BreakUpString(description, 21) + "</span>" +
"</div>" +
"<div style=\"clear: none;\"><a class=\"ReadMoreHome2\">Read More</a>" +
"</div></div>";
}
else if (templateID == "2")
{
email += "</div><div style=\"padding-top: 5px; clear: both; padding-right: 4px;padding-left: 4px;\"><a class=\"Text14\">" +
dat.BreakUpString(header, 21) +
"</a></div>" +
"<div align=\"center\" style=\"clear: both; padding-left: 4px; padding-right: 4px;\"> " +
"<span class=\"Text12\">" +
dat.BreakUpString(description, 21) + "</span>" +
"</div>" +
"<div style=\"clear: none;\"><a class=\"ReadMoreHome2\">Read More</a>" +
"</div></div>";
}
}
else
{
if (templateID == "1")
{
email += "<div><a href=\"../" + dat.MakeNiceName(header) +
"_" + ID + "_Ad\" class=\"Text14\">" + dat.BreakUpString(header, 10) +
"</a></div></div>" +
"<div align=\"center\" style=\"clear: both; padding-left: 2px; padding-right: 2px;" +
"padding-top: 1px;\"> " +
"<span class=\"Text12\">" +
dat.BreakUpString(description, 21) + "</span>" +
"</div>" +
"<div style=\"clear: none;\"><a class=\"ReadMoreHome2\" href=\"../" +
dat.MakeNiceName(header) +
"_" + ID + "_Ad\">Read More</a>" +
"</div></div>";
}
else if (templateID == "2")
{
email += "</div><div style=\"padding-top: 5px; clear: both; padding-right: 4px;padding-left: 4px;\"><a href=\"../" +
dat.MakeNiceName(header) +
"_" + ID + "_Ad\" class=\"Text14\">" + dat.BreakUpString(header, 21) +
"</a></div>" +
"<div align=\"center\" style=\"clear: both; padding-left: 4px; padding-right: 4px;\"> " +
"<span class=\"Text12\">" +
dat.BreakUpString(description, 21) + "</span>" +
"</div>" +
"<div style=\"clear: none;\"><a class=\"ReadMoreHome2\" href=\"../" +
dat.MakeNiceName(header) +
"_" + ID + "_Ad\">Read More</a>" +
"</div></div>";
}
}
if (normalAdCount % 2 == 0)
{
email += "</td>";
}
else
{
email += "</td></tr>";
}
normalAdCount++;
return email;
}
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 CreateMembers(string theID, bool isUpdate, string IDofFirstOccurance)
{
if (ParticipantsList.SelectedValue != "1")
{
string command = "";
try
{
char[] delim = { '-' };
HttpCookie cookie = Request.Cookies["BrowserDate"];
Data dat = new Data(DateTime.Parse(cookie.Value.ToString().Replace("%20", " ").Replace("%3A", ":")));
string emailBody = Session["UserName"].ToString() + " has created a new group event <a href=\"http://hippohappenings.com/" +
dat.MakeNiceName(VenueNameTextBox.THE_TEXT.Trim()) +
"_" + IDofFirstOccurance + "_" + theID + "_GroupEvent\">" + VenueNameTextBox.THE_TEXT.Trim() +
"</a> and is inviting you to it." +
" To accept this invitation <a href=\"http://hippohappenings.com/my-account\">log in to HippoHappenings</a>, view your messages in 'My Account' and " +
"click 'Accept' in the message corresponding to this email. Have good fun at the event! <br/><br/>HippoHappenings";
string emailSubject = "You have a group event invite for '" + VenueNameTextBox.THE_TEXT + "'";
string messageBody = theID + " " + Session["UserName"].ToString() + " has created a new group event <a class=\"AddLink\" href=\"" +
dat.MakeNiceName(VenueNameTextBox.THE_TEXT.Trim()) +
"_" + IDofFirstOccurance + "_" + theID + "_GroupEvent\">" + VenueNameTextBox.THE_TEXT.Trim() +
"</a> and is inviting you to it. Click " +
"the 'Accept' button to the right if you accept this invitation. ";
if (isUpdate)
{
emailBody = Session["UserName"].ToString() + " has updated the group event <a href=\"http://hippohappenings.com/" +
dat.MakeNiceName(VenueNameTextBox.THE_TEXT.Trim()) +
"_" + IDofFirstOccurance + "_" + theID + "_GroupEvent\">" + VenueNameTextBox.THE_TEXT.Trim() +
"</a> and is inviting you to it." +
" To accept this invitation <a href=\"http://hippohappenings.com/my-account\">log in to HippoHappenings</a>, view your messages in 'My Account' and " +
"click 'Accept' in the message corresponding to this email. Have good fun at the event! <br/><br/>HippoHappenings";
emailSubject = "You have a group event invite for '" + VenueNameTextBox.THE_TEXT + "'";
messageBody = theID + " " + Session["UserName"].ToString() + " has updated the group event <a class=\"AddLink\" href=\"" +
dat.MakeNiceName(VenueNameTextBox.THE_TEXT.Trim()) +
"_" + IDofFirstOccurance + "_" + theID + "_GroupEvent\">" + VenueNameTextBox.THE_TEXT.Trim() +
"</a> and is inviting you to it. Click " +
"the 'Accept' button to the right if you accept this invitation. ";
}
DataView dvMems;
dvMems = dat.GetDataDV("SELECT * FROM Group_Members WHERE GroupID=" +
Request.QueryString["GroupID"].ToString());
DataView dvUserGroupCalendar = dat.GetDataDV("SELECT * FROM User_GroupEvent_Calendar WHERE GroupEventID=" + theID);
bool doIt = false;
if (dvUserGroupCalendar.Count > 0)
{
if (ParticipantsList.SelectedValue == "2" || ParticipantsList.SelectedValue == "3")
{
foreach (DataRowView row in dvUserGroupCalendar)
{
doIt = false;
if (ParticipantsList.SelectedValue == "2")
{
dvMems.RowFilter = "MemberID=" + row["UserID"].ToString();
if (dvMems.Count > 0)
doIt = true;
}
else
{
if (GroupMembersSelectedListBox.Items.Contains(new ListItem(dat.GetDataDV("SELECT * FROM "+
"Users WHERE User_ID="+row["UserID"].ToString())[0]["UserName"].ToString(),
row["UserID"].ToString())))
doIt = true;
}
if (doIt)
{
if (dat.GetDataDV("SELECT * FROM GroupEvent_Members WHERE UserID=" +
row["UserID"].ToString() + " AND GroupEventID=" + theID + " AND ReoccurrID=" +
row["ReoccurrID"].ToString()).Count == 0)
{
dat.Execute("INSERT INTO GroupEvent_Members (UserID, GroupEventID, Accepted, ReoccurrID, DateAdded) " +
"VALUES(" + row["UserID"].ToString() + ", " + theID + ", 'True', " + row["ReoccurrID"].ToString() +
", CONVERT(DATETIME, '" + row["DateAdded"].ToString() + "'))");
}
}
}
}
}
DataView dvPrevMembers = dat.GetDataDV("SELECT * FROM GroupEvent_Members WHERE GroupEventID=" + theID);
if (dvPrevMembers.Count > 0 && ParticipantsList.SelectedValue == "1")
{
foreach (DataRowView row in dvUserGroupCalendar)
{
if (dat.GetDataDV("SELECT * FROM User_GroupEvent_Calendar WHERE UserID=" +
row["UserID"].ToString() + " AND GroupEventID=" + theID + " AND ReoccurrID=" +
row["ReoccurrID"].ToString()).Count == 0)
{
dat.Execute("INSERT INTO User_GroupEvent_Calendar (UserID, GroupEventID, ReoccurrID, DateAdded) " +
"VALUES(" + row["UserID"].ToString() + ", " + theID + ", " + row["ReoccurrID"].ToString() +
", CONVERT(DATETIME, '" + row["DateAdded"].ToString() + "'))");
}
}
}
DataView dvAllOccurances = dat.GetDataDV("SELECT * FROM GroupEvent_Occurance WHERE GroupEventID=" + theID);
string keepthese = "";
if (ParticipantsList.SelectedValue == "3")
{
foreach (ListItem item in GroupMembersSelectedListBox.Items)
{
//execute update/insert member
foreach (DataRowView row in dvAllOccurances)
{
if (isUpdate)
{
dvPrevMembers.RowFilter = "UserID=" + item.Value + " AND ReoccurrID=" + row["ID"].ToString();
if (dvPrevMembers.Count == 0)
{
command = "INSERT INTO GroupEvent_Members (GroupEventID, UserID, ReoccurrID) VALUES(" + theID +
", " + item.Value + ", " + row["ID"].ToString() + ")";
dat.Execute(command);
keepthese += " AND NOT(UserID = " + item.Value + " AND ReoccurrID=" + row["ID"].ToString() + ") ";
DataView dvUser = dat.GetDataDV("SELECT * FROM Users WHERE User_ID=" + item.Value);
if (item.Value != Session["User"].ToString())
{
dat.Execute("INSERT INTO UserMessages (MessageContent, MessageSubject, From_UserID, To_UserID, " +
"[Date], [Read], [Mode], [Live]) VALUES('" + messageBody.Replace("'", "''") + "', '" + emailSubject.Replace("'", "''") + "', " +
dat.HIPPOHAPP_USERID.ToString() + ", " + item.Value + ", '" +
DateTime.Parse(cookie.Value.ToString().Replace("%20", " ").Replace("%3A", ":")).ToString() + "', 'False', 9, 'True')");
dat.SendEmail(System.Configuration.ConfigurationManager.AppSettings["emailemail"].ToString(),
System.Configuration.ConfigurationManager.AppSettings["emailName"].ToString(),
dvUser[0]["Email"].ToString(), emailBody, emailSubject);
}
}
else
{
keepthese += " AND NOT(UserID = " + item.Value + " AND ReoccurrID=" + row["ID"].ToString() + ")";
}
}
else
{
command = "INSERT INTO GroupEvent_Members (GroupEventID, UserID, ReoccurrID) VALUES(" + theID +
", " + item.Value + ", " + row["ID"].ToString() + ")";
dat.Execute(command);
DataView dvUser = dat.GetDataDV("SELECT * FROM Users WHERE User_ID=" + item.Value);
if (item.Value != Session["User"].ToString())
{
dat.Execute("INSERT INTO UserMessages (MessageContent, MessageSubject, From_UserID, To_UserID, " +
"[Date], [Read], [Mode], [Live]) VALUES('" + messageBody.Replace("'", "''") + "', '" + emailSubject.Replace("'", "''") + "', " +
dat.HIPPOHAPP_USERID.ToString() + ", " + item.Value + ", '" +
DateTime.Parse(cookie.Value.ToString().Replace("%20", " ").Replace("%3A", ":")).ToString() + "', 'False', 9, 'True')");
dat.SendEmail(System.Configuration.ConfigurationManager.AppSettings["emailemail"].ToString(),
System.Configuration.ConfigurationManager.AppSettings["emailName"].ToString(),
dvUser[0]["Email"].ToString(), emailBody, emailSubject);
}
}
}
}
if (isUpdate)
{
dat.Execute("DELETE FROM GroupEvent_Members WHERE GroupEventID=" + theID + keepthese);
}
}
else if (ParticipantsList.SelectedValue == "2")
{
foreach (DataRowView item in dvMems)
{
//execute update/insert member
foreach (DataRowView row in dvAllOccurances)
{
if (isUpdate)
{
dvPrevMembers.RowFilter = "UserID=" + item["MemberID"] + " AND ReoccurrID=" +
row["ID"].ToString();
if (dvPrevMembers.Count == 0)
{
command = "INSERT INTO GroupEvent_Members (GroupEventID, UserID, ReoccurrID) VALUES(" + theID +
", " + item["MemberID"] + ", " + row["ID"].ToString() + ")";
dat.Execute(command);
keepthese += " AND NOT(UserID = " + item["MemberID"] + " AND ReoccurrID=" +
row["ID"].ToString() + ") ";
DataView dvUser = dat.GetDataDV("SELECT * FROM Users WHERE User_ID=" + item["MemberID"]);
if (item["MemberID"] != Session["User"].ToString())
{
dat.Execute("INSERT INTO UserMessages (MessageContent, MessageSubject, From_UserID, To_UserID, " +
"[Date], [Read], [Mode], [Live]) VALUES('" + messageBody.Replace("'", "''") + "', '" + emailSubject.Replace("'", "''") + "', " +
dat.HIPPOHAPP_USERID.ToString() + ", " + item["MemberID"] + ", '" +
DateTime.Parse(cookie.Value.ToString().Replace("%20", " ").Replace("%3A", ":")).ToString() + "', 'False', 9, 'True')");
dat.SendEmail(System.Configuration.ConfigurationManager.AppSettings["emailemail"].ToString(),
System.Configuration.ConfigurationManager.AppSettings["emailName"].ToString(),
dvUser[0]["Email"].ToString(), emailBody, emailSubject);
}
}
else
{
keepthese += " AND NOT(UserID = " + item["MemberID"] +
" AND ReoccurrID=" + row["ID"].ToString() + ")";
}
}
else
{
command = "INSERT INTO GroupEvent_Members (GroupEventID, UserID, ReoccurrID) VALUES(" +
theID + ", " + item["MemberID"] + ", " + row["ID"].ToString() + ")";
dat.Execute(command);
DataView dvUser = dat.GetDataDV("SELECT * FROM Users WHERE User_ID=" + item["MemberID"]);
if (item["MemberID"] != Session["User"].ToString())
{
dat.Execute("INSERT INTO UserMessages (MessageContent, MessageSubject, From_UserID, To_UserID, " +
"[Date], [Read], [Mode], [Live]) VALUES('" + messageBody.Replace("'", "''") + "', '" + emailSubject.Replace("'", "''") + "', " +
dat.HIPPOHAPP_USERID.ToString() + ", " + item["MemberID"] + ", '" +
DateTime.Parse(cookie.Value.ToString().Replace("%20", " ").Replace("%3A", ":")).ToString() + "', 'False', 9, 'True')");
dat.SendEmail(System.Configuration.ConfigurationManager.AppSettings["emailemail"].ToString(),
System.Configuration.ConfigurationManager.AppSettings["emailName"].ToString(),
dvUser[0]["Email"].ToString(), emailBody, emailSubject);
}
}
}
}
if (isUpdate)
{
dat.Execute("DELETE FROM GroupEvent_Members WHERE GroupEventID=" + theID + keepthese);
}
}
}
catch (Exception ex)
{
MessagePanel.Visible = true;
YourMessagesLabel.Text = ex.ToString() + "<br/>command: " + command;
}
}
}
protected void SendGroupEventNotifications(string eventID, string IDofFirstOccurance)
{
string theID = Request.QueryString["GroupID"].ToString();
HttpCookie cookie = Request.Cookies["BrowserDate"];
Data dat = new Data(DateTime.Parse(cookie.Value.ToString().Replace("%20", " ").Replace("%3A", ":")));
DataView dvUsers = dat.GetDataDV("SELECT * FROM Group_Members GM, Users U WHERE GM.MemberID=" +
"U.User_ID AND GM.GroupID=" + theID + " AND Prefs LIKE '%2%'");
DataView dvGroup = dat.GetDataDV("SELECT * FROM Groups WHERE ID=" + theID);
DataView dvThread = dat.GetDataDV("SELECT * FROM GroupEvents WHERE ID=" + eventID);
string email = "A new event '" + dvThread[0]["Name"].ToString() +
"' has been posted for the group '" +
dvGroup[0]["Header"].ToString() + "'. <a href=\"http://hippohappenings.com/" +
dat.MakeNiceName(dvThread[0]["Name"].ToString()) + "_" + IDofFirstOccurance + "_" + eventID +
"_GroupEvent\">Check it out.</a>";
foreach (DataRowView row in dvUsers)
{
dat.SendEmail(System.Configuration.ConfigurationManager.AppSettings["emailemail"].ToString(),
System.Configuration.ConfigurationManager.AppSettings["emailName"].ToString(), row["Email"].ToString(),
email, "A new group event has been posted");
}
}
protected void PostIt(object sender, EventArgs e)
{
HttpCookie cookie = Request.Cookies["BrowserDate"];
if (AgreeCheckBox.Checked)
{
Data dat = new Data(DateTime.Parse(cookie.Value.ToString().Replace("%20", " ").Replace("%3A", ":")));
SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["Connection"].ToString());
conn.Open();
string command = "";
try
{
bool isUpdate = false;
bool isCopy = false;
DataSet dsVenue = new DataSet();
if (Request.QueryString["ID"] != null)
{
if (Request.QueryString["copy"] != null)
{
if (!bool.Parse(Request.QueryString["copy"].ToString()))
{
dsVenue = dat.GetData("SELECT * FROM GroupEvents WHERE ID=" + Request.QueryString["ID"].ToString());
isUpdate = true;
}
else
{
isCopy = true;
}
}
else
{
dsVenue = dat.GetData("SELECT * FROM GroupEvents WHERE ID=" + Request.QueryString["ID"].ToString());
isUpdate = true;
}
}
bool cont = true;
if (cont)
{
if (isUpdate)
{
command = "UPDATE GroupEvents SET StuffNeededCheckable=@checkable, ColorA=@cA, ColorB=@cB, TextA=@tA, TextB=@tB, LastEdit=GETDATE(), LastEditBy=" + Session["User"].ToString() +
", Name=@name, [Content]=@content, Agenda=@agenda, " +
" EventType=@eType, RegType=@rType, RegNum=@rNum, RegDeadline=@rDeadline WHERE ID=" + Request.QueryString["ID"].ToString();
}
else
command = "INSERT INTO GroupEvents (StuffNeededCheckable, ColorA, ColorB, TextA, TextB, PostedOn, LastEdit, LastEditBy, UserID, GroupID, Name, [Content], " +
" Agenda, EventType, RegType, RegNum, RegDeadline) VALUES(@checkable, @cA, @cB, @tA, @tB, GETDATE(), GETDATE()," +
Session["User"].ToString() + ", " + Session["User"].ToString() + ", " +
Request.QueryString["GroupID"].ToString() +
", @name, @content, @agenda, @eType, " +
" @rType, @rNum, @rDeadline)";
SqlCommand cmd = new SqlCommand(command, conn);
cmd.CommandType = CommandType.Text;
cmd.Parameters.Add("@checkable", SqlDbType.Bit).Value = StuffCheckableCheckBox.Checked;
if (ColorSchemeRadioList.SelectedValue == "0")
{
cmd.Parameters.Add("@cA", SqlDbType.NVarChar).Value = "568301";
cmd.Parameters.Add("@cB", SqlDbType.NVarChar).Value = "1fb6e7";
}
else
{
cmd.Parameters.Add("@cA", SqlDbType.NVarChar).Value = ColorTd1.BgColor.Replace("#", "");
cmd.Parameters.Add("@cB", SqlDbType.NVarChar).Value = ColorTd2.BgColor.Replace("#", "");
}
if (ColorTextRadioList.SelectedValue == "0")
{
cmd.Parameters.Add("@tA", SqlDbType.NVarChar).Value = "ffffff";
cmd.Parameters.Add("@tB", SqlDbType.NVarChar).Value = "ffffff";
}
else
{
cmd.Parameters.Add("@tA", SqlDbType.NVarChar).Value =
System.Drawing.ColorTranslator.ToHtml(Text1Label.ForeColor).Replace("#", "");
cmd.Parameters.Add("@tB", SqlDbType.NVarChar).Value =
System.Drawing.ColorTranslator.ToHtml(Text2Label.ForeColor).Replace("#", "");
}
cmd.Parameters.Add("@name", SqlDbType.NVarChar).Value = VenueNameTextBox.THE_TEXT.Trim();
cmd.Parameters.Add("@content", SqlDbType.NVarChar).Value = DescriptionTextBox.Content.Trim();
if (AgendaCheckBox.Checked)
cmd.Parameters.Add("@agenda", SqlDbType.NVarChar).Value = AgendaLiteral.Text;
else
cmd.Parameters.Add("@agenda", SqlDbType.NVarChar).Value = DBNull.Value;
cmd.Parameters.Add("@eType", SqlDbType.Int).Value = ParticipantsList.SelectedValue;
cmd.Parameters.Add("@rType", SqlDbType.Int).Value = RagistrationRadioList.SelectedValue;
if (RagistrationRadioList.SelectedValue == "1")
{
cmd.Parameters.Add("@rNum", SqlDbType.Int).Value = DBNull.Value;
cmd.Parameters.Add("@rDeadline", SqlDbType.DateTime).Value = DBNull.Value;
}
else
{
if (NumRegTextBox.Text.Trim() != "")
cmd.Parameters.Add("@rNum", SqlDbType.Int).Value = NumRegTextBox.Text.Trim();
else
cmd.Parameters.Add("@rNum", SqlDbType.Int).Value = DBNull.Value;
if (DeadlineDatePicker.SelectedDate == null)
cmd.Parameters.Add("@rDeadline", SqlDbType.DateTime).Value = DBNull.Value;
else
cmd.Parameters.Add("@rDeadline", SqlDbType.DateTime).Value = DeadlineDatePicker.SelectedDate.Value;
}
cmd.ExecuteNonQuery();
string IDofFirstOccurance = "";
string eventID = "";
if (isUpdate)
{
eventID = Request.QueryString["ID"].ToString();
IDofFirstOccurance = Request.QueryString["O"].ToString();
}
else
{
cmd = new SqlCommand("SELECT @@IDENTITY AS IDS", conn);
SqlDataAdapter da2 = new SqlDataAdapter(cmd);
DataSet ds3 = new DataSet();
da2.Fill(ds3);
eventID = ds3.Tables[0].Rows[0]["IDS"].ToString();
}
#region Take care of Venue and Occurance
string state = "";
string zip = "";
string city = "";
string country = "";
string address = "";
string apt = "";
string aptNo = "";
string aptName = "";
string location = "";
string streetNo = "";
string streetName = "";
string streetDrop = "";
DataView dvRealVenue;
char[] delim = { ';' };
string[] delimStr = { "--" };
string[] tokens3;
string[] tokens2;
int venueID = 0;
bool isVenue = false;
string startDate = "";
string endDate = "";
foreach (ListItem item in DateSelectionsListBox.Items)
{
isVenue = false;
tokens3 = item.Text.Split(delimStr, StringSplitOptions.RemoveEmptyEntries);
startDate = tokens3[0].Trim();
endDate = tokens3[1].Trim();
tokens2 = item.Value.Split(delim);
if (tokens3[2].Trim() != "Private Location")
{
isVenue = true;
venueID = int.Parse(item.Value);
}
if (!isVenue)
{
state = tokens2[1];
city = tokens2[0];
zip = tokens2[2];
location = tokens2[3];
apt = tokens2[4];
country = tokens2[5];
if(apt.Trim() != ""){
char [] tempdelimer = {' '};
string [] apttoks = apt.Split(tempdelimer);
aptName = apttoks[0];
aptNo = apttoks[1];
}
if (country == "223")
{
char[] tempDelim = { '%' };
string[] streettoks = location.Split(tempDelim);
streetNo = streettoks[0];
streetName = streettoks[1];
streetDrop = streettoks[2];
}
}
else
{
dvRealVenue = dat.GetDataDV("SELECT * FROM Venues WHERE ID=" + item.Value);
state = dvRealVenue[0]["State"].ToString();
zip = dvRealVenue[0]["Zip"].ToString();
city = dvRealVenue[0]["City"].ToString();
country = dvRealVenue[0]["Country"].ToString();
}
if (isUpdate)
{
DataView dvSelect = dat.GetDataDV("SELECT * FROM GroupEvent_Occurance WHERE GroupEventID=" +
eventID + " AND DateTimeStart = CONVERT(DATETIME,'" + startDate + "')");
if (dvSelect.Count == 0)
{
command = "INSERT INTO GroupEvent_Occurance (GroupEventID, DateTimeStart, DateTimeEnd, " +
"State, City, Country, Zip, StreetNumber, StreetName, StreetDrop, AptName, AptNo, Location, VenueID) VALUES(" + eventID + ", @start, @end, @state, " +
"@city, @country, @zip, @sNo, @sName, @sDrop, @aName, @aNo, @location, @venue)";
}
else
{
command = "UPDATE GroupEvent_Occurance SET DateTimeEnd=@end, State=@state, " +
"City=@city, Country=@country, Zip=@zip, StreetNumber=@sNo, StreetName=@sName, " +
"StreetDrop=@sDrop, AptName=@aName, AptNo=@aNo, Location=@location, VenueID=@venue " +
" WHERE ID=" + dvSelect[0]["ID"].ToString();
}
}
else
{
command = "INSERT INTO GroupEvent_Occurance (GroupEventID, DateTimeStart, DateTimeEnd, " +
"State, City, Country, Zip, StreetNumber, StreetName, StreetDrop, AptName, AptNo, Location, VenueID) VALUES(" + eventID + ", @start, @end, @state, " +
"@city, @country, @zip, @sNo, @sName, @sDrop, @aName, @aNo, @location, @venue)";
}
cmd = new SqlCommand(command, conn);
command += "venueID: '" + venueID.ToString() + "', country: " + country + ", address: " + address;
if (!isVenue)
cmd.Parameters.Add("@venue", SqlDbType.Int).Value = DBNull.Value;
else
cmd.Parameters.Add("@venue", SqlDbType.Int).Value = venueID;
cmd.Parameters.Add("@start", SqlDbType.DateTime).Value = startDate;
cmd.Parameters.Add("@end", SqlDbType.DateTime).Value = endDate;
cmd.Parameters.Add("@zip", SqlDbType.NVarChar).Value = zip;
cmd.Parameters.Add("@city", SqlDbType.NVarChar).Value = city;
cmd.Parameters.Add("@state", SqlDbType.NVarChar).Value = state;
if (isVenue)
{
cmd.Parameters.Add("@sNo", SqlDbType.NVarChar).Value = DBNull.Value;
cmd.Parameters.Add("@sName", SqlDbType.NVarChar).Value = DBNull.Value;
cmd.Parameters.Add("@sDrop", SqlDbType.NVarChar).Value = DBNull.Value;
cmd.Parameters.Add("@aName", SqlDbType.NVarChar).Value = DBNull.Value;
cmd.Parameters.Add("@aNo", SqlDbType.NVarChar).Value = DBNull.Value;
cmd.Parameters.Add("@location", SqlDbType.NVarChar).Value = DBNull.Value;
}
else
{
if (country == "223")
{
cmd.Parameters.Add("@sNo", SqlDbType.NVarChar).Value = streetNo;
cmd.Parameters.Add("@sName", SqlDbType.NVarChar).Value = streetName;
cmd.Parameters.Add("@sDrop", SqlDbType.NVarChar).Value = streetDrop;
cmd.Parameters.Add("@aName", SqlDbType.NVarChar).Value = aptName;
cmd.Parameters.Add("@aNo", SqlDbType.NVarChar).Value = aptNo;
cmd.Parameters.Add("@location", SqlDbType.NVarChar).Value = DBNull.Value;
}
else
{
cmd.Parameters.Add("@sNo", SqlDbType.NVarChar).Value = DBNull.Value;
cmd.Parameters.Add("@sName", SqlDbType.NVarChar).Value = DBNull.Value;
cmd.Parameters.Add("@sDrop", SqlDbType.NVarChar).Value = DBNull.Value;
cmd.Parameters.Add("@location", SqlDbType.NVarChar).Value = location;
cmd.Parameters.Add("@aName", SqlDbType.NVarChar).Value = aptName;
cmd.Parameters.Add("@aNo", SqlDbType.NVarChar).Value = aptNo;
}
}
cmd.Parameters.Add("@country", SqlDbType.Int).Value = country;
cmd.ExecuteNonQuery();
if (IDofFirstOccurance == "")
{
cmd = new SqlCommand("SELECT @@IDENTITY AS AAS", conn);
DataSet dsTemp = new DataSet();
SqlDataAdapter da = new SqlDataAdapter(cmd);
da.Fill(dsTemp);
IDofFirstOccurance = dsTemp.Tables[0].Rows[0]["AAS"].ToString();
}
}
#endregion
#region Take care of slider
bool isSlider = false;
if (PictureCheckList.Items.Count > 0)
isSlider = true;
if (isSlider)
{
char[] delim2 = { '\\' };
string[] fileArray = System.IO.Directory.GetFiles(MapPath(".") + "\\UserFiles\\" + Session["UserName"].ToString() + "\\Slider\\");
if (!System.IO.Directory.Exists(MapPath(".") + "\\GroupEventFiles"))
{
System.IO.Directory.CreateDirectory(MapPath(".") + "\\GroupEventFiles\\");
System.IO.Directory.CreateDirectory(MapPath(".") + "\\GroupEventFiles\\" + eventID + "\\");
System.IO.Directory.CreateDirectory(MapPath(".") + "\\GroupEventFiles\\" + eventID + "\\Slider\\");
}
else
{
if (!System.IO.Directory.Exists(MapPath(".") + "\\GroupEventFiles\\" + eventID))
{
System.IO.Directory.CreateDirectory(MapPath(".") + "\\GroupEventFiles\\" + eventID + "\\");
System.IO.Directory.CreateDirectory(MapPath(".") + "\\GroupEventFiles\\" + eventID + "\\Slider\\");
}
else
{
if (!!System.IO.Directory.Exists(MapPath(".") + "\\GroupEventFiles\\" + eventID + "\\Slider\\"))
System.IO.Directory.CreateDirectory(MapPath(".") + "\\GroupEventFiles\\" + eventID + "\\Slider\\");
}
}
char[] delim3 = { '.' };
char[] delim4 = { '-' };
string realName = "";
string origName = "";
string caption = "";
dat.Execute("DELETE FROM GroupEvent_Slider_Mapping WHERE GroupEventID=" + eventID.ToString());
for (int i = 0; i < PictureCheckList.Items.Count; i++)
{
caption = "";
string[] tokensN = PictureCheckList.Items[i].Value.Split(delim4);
if (tokensN.Length > 1)
{
realName = tokensN[0].Trim();
caption = PictureCheckList.Items[i].Value.Replace(tokensN[0].Trim() + " - ", "");
}
else
{
realName = tokensN[0].Trim();
}
tokensN = PictureCheckList.Items[i].Text.Split(delim4);
origName = tokensN[0].Trim();
string[] tokens = realName.Split(delim3);
if (tokens.Length >= 2)
{
if (tokens[1].ToUpper() == "JPG" || tokens[1].ToUpper() == "JPEG" || tokens[1].ToUpper() == "GIF" || tokens[1].ToUpper() == "PNG")
{
if (!System.IO.File.Exists(MapPath(".") + "\\GroupEventFiles\\" + eventID.ToString() + "\\Slider\\" + realName))
{
System.IO.File.Copy(MapPath(".") + "\\UserFiles\\" + Session["UserName"].ToString() + "\\Slider\\" +
realName, MapPath(".") + "\\GroupEventFiles\\" + eventID.ToString() + "\\Slider\\" + realName);
}
cmd = new SqlCommand("INSERT INTO GroupEvent_Slider_Mapping (GroupEventID, PictureName, RealPictureName, Caption) " +
"VALUES (@eventID, @picName, @realName, @cap)", conn);
cmd.Parameters.Add("@eventID", SqlDbType.Int).Value = eventID;
cmd.Parameters.Add("@picName", SqlDbType.NVarChar).Value = realName;
cmd.Parameters.Add("@realName", SqlDbType.NVarChar).Value = origName;
cmd.Parameters.Add("@cap", SqlDbType.NVarChar).Value = caption;
cmd.ExecuteNonQuery();
}
}
else
{
cmd = new SqlCommand("INSERT INTO GroupEvent_Slider_Mapping (isYouTube,GroupEventID, PictureName, RealPictureName, Caption) " +
"VALUES ('True',@eventID, @picName, @realName, @cap)", conn);
cmd.Parameters.Add("@eventID", SqlDbType.Int).Value = eventID;
cmd.Parameters.Add("@picName", SqlDbType.NVarChar).Value = realName.Replace("YouTube ID: ", "");
cmd.Parameters.Add("@realName", SqlDbType.NVarChar).Value = realName.Replace("YouTube ID: ", "");
cmd.Parameters.Add("@cap", SqlDbType.NVarChar).Value = caption;
cmd.ExecuteNonQuery();
}
}
}
#endregion
#region Take care of 'Stuff we Need'
int order = 0;
DataView dvStuff;
bool doInsert = false;
string keepthese = "";
if (StuffCheckBox.Checked)
{
foreach (ListItem item in StuffNeededListBox.Items)
{
if (isUpdate)
{
dvStuff = dat.GetDataDV("SELECT * FROM GroupEvent_StuffNeeded WHERE GroupEventID=" +
eventID + " AND StuffNeeded='" + item.Text.Replace("'", "''") + "'");
if (dvStuff.Count == 0)
{
doInsert = true;
}
else
{
cmd = new SqlCommand("UPDATE GroupEvent_StuffNeeded SET OrderID=@order WHERE GroupEventID=" +
eventID + " AND StuffNeeded='" + item.Text.Replace("'", "''") + "'", conn);
cmd.Parameters.Add("@order", SqlDbType.Int).Value = order++;
cmd.ExecuteNonQuery();
keepthese += " AND ID <> " + dvStuff[0]["ID"].ToString();
}
}
else
{
doInsert = true;
}
if (doInsert)
{
cmd = new SqlCommand("INSERT INTO GroupEvent_StuffNeeded (GroupEventID, StuffNeeded, " +
"UserID, OrderID) VALUES(" + eventID + ", @stuff, @UserID, @order)", conn);
cmd.Parameters.Add("@stuff", SqlDbType.NVarChar).Value = item.Text;
cmd.Parameters.Add("@UserID", SqlDbType.Int).Value = DBNull.Value;
cmd.Parameters.Add("@order", SqlDbType.Int).Value = order++;
cmd.ExecuteNonQuery();
cmd = new SqlCommand("SELECT @@IDENTITY AS AID", conn);
DataSet dsN = new DataSet();
SqlDataAdapter d1 = new SqlDataAdapter(cmd);
d1.Fill(dsN);
keepthese += " AND ID <> " + dsN.Tables[0].Rows[0]["AID"].ToString();
}
}
}
dat.Execute("DELETE FROM GroupEvent_StuffNeeded WHERE GroupEventID=" + eventID + keepthese);
#endregion
CreateMembers(eventID, isUpdate, IDofFirstOccurance);
CreateGroupings(eventID, isUpdate);
CreateCategories(eventID, isUpdate);
//Send the informational email to the user
DataSet dsUser = dat.GetData("SELECT Email, UserName FROM USERS WHERE User_ID=" +
Session["User"].ToString());
string emailBody = "<br/><br/>Dear " + dsUser.Tables[0].Rows[0]["UserName"].ToString() + ", <br/><br/> you have successfully posted the group event \"" + VenueNameTextBox.THE_TEXT +
"\". <br/><br/> You can find this group event <a href=\"http://hippohappenings.com/" +
dat.MakeNiceName(VenueNameTextBox.THE_TEXT) + "_" + IDofFirstOccurance + "_" +
eventID + "_GroupEvent\">here</a>. " +
"<br/><br/> To rate your experience posting this group event <a href=\"http://hippohappenings.com/RateExperience.aspx?Edit=" + isUpdate.ToString() + "&Type=GE&ID=" + eventID +
"\">please include your feedback here.</a>" +
"<br/><br/><br/>Have a Hippo Happening Day!<br/><br/>";
try
{
if (isUpdate)
{
if (!Request.Url.AbsoluteUri.Contains("localhost"))
{
dat.SendEmail(System.Configuration.ConfigurationManager.AppSettings["emailemail"].ToString(),
System.Configuration.ConfigurationManager.AppSettings["emailName"].ToString(),
dsUser.Tables[0].Rows[0]["Email"].ToString(), emailBody, "You have updated group event: " +
VenueNameTextBox.THE_TEXT);
}
}
else
{
if (!Request.Url.AbsoluteUri.Contains("localhost"))
{
dat.SendEmail(System.Configuration.ConfigurationManager.AppSettings["emailemail"].ToString(),
System.Configuration.ConfigurationManager.AppSettings["emailName"].ToString(),
dsUser.Tables[0].Rows[0]["Email"].ToString(), emailBody, "You have posted the event: " +
VenueNameTextBox.THE_TEXT);
SendGroupEventNotifications(eventID, IDofFirstOccurance);
}
}
}
catch (Exception ex)
{
}
conn.Close();
//pop up the message to the user
Encryption encrypt = new Encryption();
if (!isUpdate)
{
Session["Message"] = "Your group event has been posted successfully! An email with this info will also be sent to your account.<br/>"
+ "<br/>Check out <a class=\"AddLink\" onclick=\"Search('" +
dat.MakeNiceName(VenueNameTextBox.THE_TEXT) + "_" +
IDofFirstOccurance + "_" + eventID + "_GroupEvent');\">this group event's</a> home page.<br/><br/><br/> " +
"-<a class=\"AddLink\" onclick=\"Search('RateExperience.aspx?Edit=" + isUpdate.ToString() + "&Type=GE&ID=" +
eventID + "');\" >Rate </a>your user experience posting this group event.<br/>";
}
else
{
Session["Message"] = "You have successfully updated group event: \"" + VenueNameTextBox.THE_TEXT.Trim() +
"\".<br/><br/>Check out <a class=\"AddLink\" onclick=\"Search('" +
dat.MakeNiceName(VenueNameTextBox.THE_TEXT) + "_" + Request.QueryString["O"].ToString() + "_" + eventID +
"_GroupEvent');\">this group event's</a> home page.<br/><br/> <a class=\"AddLink\" onclick=\"Search('RateExperience.aspx?Edit=" +
isUpdate.ToString() + "&Type=GE&ID=" + eventID + "');\" >Rate </a>your user experience editing this group event.<br/>";
}
MessageRadWindow.NavigateUrl = "Message.aspx?message=" + encrypt.encrypt(Session["Message"].ToString() + "<br/><img onclick=\"Search('home');\" onmouseover=\"this.src='image/DoneSonButtonSelected.png'\" onmouseout=\"this.src='image/DoneSonButton.png'\" src=\"image/DoneSonButton.png\"/>");
MessageRadWindow.Visible = true;
MessageRadWindow.VisibleOnPageLoad = true;
}
}
catch (Exception ex)
{
MessagePanel.Visible = true;
YourMessagesLabel.Text += ex.ToString() + command;
}
}
else
{
MessagePanel.Visible = true;
YourMessagesLabel.Text += "<br/><br/>You must agree to the terms and conditions.";
}
}
protected void Page_Load(object sender, EventArgs e)
{
HttpCookie cookie = Request.Cookies["BrowserDate"];
bool isCl = false;
if (Request.QueryString["cl"] != null)
if (bool.Parse(Request.QueryString["cl"]))
{
isCl = true;
}
string command = "";
try
{
if (cookie != null)
{
HtmlMeta hm = new HtmlMeta();
HtmlHead head = (HtmlHead)Page.Header;
hm.Name = "ROBOTS";
hm.Content = "NOINDEX, FOLLOW";
head.Controls.AddAt(0, hm);
HtmlLink lk = new HtmlLink();
lk.Attributes.Add("rel", "canonical");
lk.Href = "http://hippohappenings.com/MessageAlert.aspx";
head.Controls.AddAt(0, lk);
MessageLabel2.Text = "";
SendItButton.SERVER_CLICK += ServerSendMessage;
if (!IsPostBack)
{
Session["ButtonClicked"] = null;
Session["CheckUsers"] = null;
Session["AllFriends"] = null;
Session.Remove("ButtonClicked");
Session.Remove("CheckUsers");
Session.Remove("AllFriends");
}
Data dat = new Data(DateTime.Parse(cookie.Value.ToString().Replace("%20", " ").Replace("%3A", ":")));
if (Session["User"] != null)
{
TechLiteral.Text = "";
DataSet dsFriends = dat.GetData("SELECT * FROM User_Friends UF, Users U WHERE UF.FriendID=U.User_ID AND UF.UserID=" + Session["User"].ToString());
bool getFriendsMessage = false;
if (dsFriends.Tables.Count > 0)
if (dsFriends.Tables[0].Rows.Count > 0)
{
Session["AllFriends"] = "";
ImageButton theImage;
string eventID = "";
string type = "";
if (isCl)
{
type = "cl";
eventID = Request.QueryString["EID"];
}
else
{
if (Request.QueryString["ID"] == null)
{
if (Request.QueryString["EID"] == null)
{
type = "a";
eventID = Request.QueryString["AID"];
}
else
{
type = "e";
eventID = Request.QueryString["EID"];
}
}
else
{
type = Request.QueryString["A"].ToString();
eventID = Request.QueryString["ID"].ToString();
}
}
for (int i = 0; i < dsFriends.Tables[0].Rows.Count; i++)
{
theImage = new ImageButton();
theImage.Width = 50;
theImage.Height = 50;
theImage.Style.Add("padding", "5px");
theImage.AlternateText = dsFriends.Tables[0].Rows[i]["UserName"].ToString();
theImage.ToolTip = dsFriends.Tables[0].Rows[i]["UserName"].ToString();
theImage.Click += new ImageClickEventHandler(AddFriendPanel);
theImage.CommandArgument = dsFriends.Tables[0].Rows[i]["UserName"].ToString();
Session["AllFriends"] += dsFriends.Tables[0].Rows[i]["UserName"].ToString() + ";";
if (System.IO.File.Exists(Server.MapPath(".") + "\\UserFiles\\" + dsFriends.Tables[0].Rows[i]["UserName"].ToString() + "\\Profile\\" + dsFriends.Tables[0].Rows[i]["ProfilePicture"].ToString()))
{
theImage.ImageUrl += "UserFiles/" + dsFriends.Tables[0].Rows[i]["UserName"].ToString() + "/Profile/" + dsFriends.Tables[0].Rows[i]["ProfilePicture"].ToString();
}
else
{
theImage.ImageUrl = "~/NewImages/noAvatar_50x50_small.png";
theImage.Attributes.Add("onmouseover", "this.src='NewImages/noAvatar_50x50_smallhover.png'");
theImage.Attributes.Add("onmouseout", "this.src='NewImages/noAvatar_50x50_small.png'");
}
FriendsPanel.Controls.Add(theImage);
}
DataSet dsUser = dat.GetData("SELECT * FROM Users WHERE User_ID=" + Session["User"].ToString());
DataSet dsEvent = new DataSet();
if (type == "a")
{
dsEvent = dat.GetData("SELECT * FROM Ads WHERE Ad_ID=" + eventID);
Session["MessageBody"] = "<label>Ad: <a class=\"AddLink\" href=\"http://hippohappenings.com/" + dat.MakeNiceName(dsEvent.Tables[0].Rows[0]["Header"].ToString())
+ "_" + eventID + "_Ad\">" + dsEvent.Tables[0].Rows[0]["Header"].ToString() + "</a>" +
" \nDescription: " + dsEvent.Tables[0].Rows[0]["Description"].ToString() + "</label>";
Session["EventName"] = dsEvent.Tables[0].Rows[0]["Header"].ToString();
}
else if (type == "cl")
{
string desc = Session["ClDescription"].ToString();
if (desc.Length > 100)
desc = desc.Substring(0, 100) + "...";
Session["MessageBody"] = "<label>Event: <a class=\"AddLink\" href=\"http://hippohappenings.com/" +
dat.MakeNiceName(Session["ClHeader"].ToString()) + "_CLHH" + eventID.Replace("/", "_") + "_ClEvent\">" +
Session["ClHeader"].ToString() + "</a>" +
" \nDescription: " + desc + "</label>";
Session["EventName"] = Session["ClHeader"].ToString();
}
else if (type == "e")
{
dsEvent = dat.GetData("SELECT * FROM Events E, Event_Occurance EO, " +
"Venues V WHERE E.ID=EO.EventID AND E.Venue=V.ID AND E.ID=" +
eventID);
Session["MessageBody"] = "<label>Event: <a class=\"AddLink\" href=\"http://hippohappenings.com/" +
dat.MakeNiceName(dsEvent.Tables[0].Rows[0]["Header"].ToString()) + "_" + eventID + "_Event\">" +
dsEvent.Tables[0].Rows[0]["Header"].ToString() + "</a>" +
" \nVenue: " + dsEvent.Tables[0].Rows[0]["Name"].ToString() +
" \nDate: " + dsEvent.Tables[0].Rows[0]["DateTimeStart"].ToString() +
" \nDescription: " + dsEvent.Tables[0].Rows[0]["Content"].ToString() + "</label>";
Session["EventName"] = dsEvent.Tables[0].Rows[0]["Header"].ToString();
}
else if (type == "ge")
{
string reocurr = Request.QueryString["O"].ToString();
command = "SELECT * FROM GroupEvents GE, GroupEvent_Occurance GO WHERE GE.ID=" +
eventID + " AND GE.ID=GO.GroupEventID";
dsEvent = dat.GetData(command);
Session["MessageBody"] = "<label>Group Event: <a class=\"AddLink\" " +
"href=\"http://hippohappenings.com/" +
dat.MakeNiceName(dsEvent.Tables[0].Rows[0]["Name"].ToString()) + "_" + reocurr +
"_" +
eventID + "_GroupEvent\">" +
dsEvent.Tables[0].Rows[0]["Name"].ToString() + "</a>" +
" \nDate: " + dsEvent.Tables[0].Rows[0]["DateTimeStart"].ToString() +
" \nDescription: " + dsEvent.Tables[0].Rows[0]["Content"].ToString() + "</label>";
Session["EventName"] = dsEvent.Tables[0].Rows[0]["Name"].ToString();
}
else if (type == "g")
{
command = "SELECT * FROM Groups WHERE ID=" + eventID;
dsEvent = dat.GetData(command);
Session["MessageBody"] = "<label>Group: <a class=\"AddLink\" href=\"http://hippohappenings.com/" +
dat.MakeNiceName(dsEvent.Tables[0].Rows[0]["Header"].ToString()) + "_" +
eventID + "_Group\">" +
dsEvent.Tables[0].Rows[0]["Header"].ToString() + "</a>" +
" \nDescription: " + dsEvent.Tables[0].Rows[0]["Content"].ToString() + "</label>";
Session["EventName"] = dsEvent.Tables[0].Rows[0]["Header"].ToString();
}
else if (type == "t")
{
command = "SELECT * FROM Trips WHERE ID=" + eventID;
dsEvent = dat.GetData(command);
Session["MessageBody"] = "<label>Trip: <a class=\"AddLink\" href=\"http://hippohappenings.com/" +
dat.MakeNiceName(dsEvent.Tables[0].Rows[0]["Header"].ToString()) + "_" +
eventID + "_Trip\">" +
dsEvent.Tables[0].Rows[0]["Header"].ToString() + "</a>" +
" \nDescription: " + dsEvent.Tables[0].Rows[0]["Content"].ToString() + "</label>";
Session["EventName"] = dsEvent.Tables[0].Rows[0]["Header"].ToString();
}
else
{
dsEvent = dat.GetData("SELECT * FROM Venues WHERE ID=" + eventID);
Session["MessageBody"] = "<label>Venue: <a class=\"AddLink\" href=\"http://hippohappenings.com/" +
dat.MakeNiceName(dsEvent.Tables[0].Rows[0]["Name"].ToString()) + "_" +
eventID + "_Venue\">" + dsEvent.Tables[0].Rows[0]["Name"].ToString() + "</a>" +
" \nDescription: " + dsEvent.Tables[0].Rows[0]["Content"].ToString() + "</label>";
Session["EventName"] = dsEvent.Tables[0].Rows[0]["Name"].ToString();
}
}
else
getFriendsMessage = true;
else
getFriendsMessage = true;
if (getFriendsMessage)
{
Literal FriendLiteral = new Literal();
FriendLiteral.Text = "You do not have any friends listed. To add friends visit 'My Account'. To send information of this event to an email account please visit this event's page.";
FriendsPanel.Controls.Add(FriendLiteral);
}
CreateCheckUser();
}
else
{
TechLiteral.Text = "<script type=\"text/javascript\">Search('login');</script>";
}
}
else
{
TechLiteral.Text = "<script type=\"text/javascript\">Search('login');</script>";
}
}
catch (Exception ex)
{
MessageLabel.Text += ex.ToString() + "<br/>" + command;
}
}
protected void Page_Load(object sender, EventArgs e)
{
DayOfWeek theWeekDay = DayOfWeek.Friday;
switch (theDay)
{
case days.Sun:
theWeekDay = DayOfWeek.Sunday;
break;
case days.Mon:
theWeekDay = DayOfWeek.Monday;
break;
case days.Tues:
theWeekDay = DayOfWeek.Tuesday;
break;
case days.Wed:
theWeekDay = DayOfWeek.Wednesday;
break;
case days.Thurs:
theWeekDay = DayOfWeek.Thursday;
break;
case days.Fri:
theWeekDay = DayOfWeek.Friday;
break;
case days.Sat:
theWeekDay = DayOfWeek.Saturday;
break;
}
if (!IsPostBack)
{
string imageSrc = "";
string eventStr = "";
string thisDay = theDay.ToString();
HttpCookie cookie = Request.Cookies["BrowserDate"];
DateTime datNow = DateTime.Parse(cookie.Value.ToString().Replace("%20", " ").Replace("%3A", ":"));
Data dat = new Data(datNow);
int thisDayCount = 0;
DataView dvAll = dat.GetDataDV("SELECT DISTINCT EO.DateTimeStart AS TheDate, EO.EventID AS ID, E.Header FROM Events E, User_Calendar UC, Event_Occurance EO WHERE " +
"UC.EventID=EO.EventID AND EO.EventID=E.ID AND UC.UserID=" + Session["User"].ToString());
int subtraction = 0;
switch (datNow.DayOfWeek)
{
case DayOfWeek.Friday:
subtraction = 5;
break;
case DayOfWeek.Monday:
subtraction = 1;
break;
case DayOfWeek.Saturday:
subtraction = 6;
break;
case DayOfWeek.Sunday:
subtraction = 0;
break;
case DayOfWeek.Thursday:
subtraction = 4;
break;
case DayOfWeek.Tuesday:
subtraction = 2;
break;
case DayOfWeek.Wednesday:
subtraction = 3;
break;
default: break;
}
string toolTipText = "";
if (dvAll.Count > 0)
{
for (int i = 0; i < dvAll.Count; i++)
{
DateTime date2 = DateTime.Parse(dvAll[i]["TheDate"].ToString());
if (date2.DayOfWeek == theWeekDay)
{
if (dat.IsThisWeek(date2))
{
thisDayCount++;
toolTipText += "<div class=\"TextNormal\" style=\"clear: both;\"><a class=\"NavyLink12\" href=\"" + dat.MakeNiceName(dvAll[i]["Header"].ToString()) +
"_" + dvAll[i]["ID"].ToString() + "_Event\">" + dvAll[i]["Header"].ToString() + "</a> at " +
DateTime.Parse(dvAll[i]["TheDate"].ToString()).ToShortTimeString() + "</div>";
}
}
}
}
numberOfEvents = thisDayCount;
switch (numberOfEvents)
{
case 0:
imageSrc = "NewImages/GlanceCalendarOpen.png";
eventStr = "open";
break;
default:
imageSrc = "NewImages/GlanceCalendarOpen.png";
if (numberOfEvents == 1)
eventStr = numberOfEvents + " event";
else
eventStr = numberOfEvents + " events";
break;
}
if (datNow.DayOfWeek.ToString().Substring(0, 3) == theDay.ToString() ||
datNow.DayOfWeek.ToString().Substring(0, 4) == theDay.ToString() ||
datNow.DayOfWeek.ToString().Substring(0, 5) == theDay.ToString())
{
thisDay = "Today";
imageSrc = "NewImages/GlanceCalendarOrange.png";
}
string addStr = "";
if (toolTipText != "")
addStr = " style=\"text-decoration: underline;cursor: pointer;\"";
ImageLiteral.Text = "<div class=\"TextNormal\" id=\"theDay" + theDay.ToString() +
"\" style=\"font-size: 10px;float:left;margin-right:5px;" +
"width: 53px; height: 58px; background-image:url('" +
imageSrc + "'); font-weight: bold;\"><div style=\"padding-left:2px;\"> " +
thisDay + "</div><br/><div align=\"center\" " + addStr + ">" + eventStr + "</div></div>";
ImageLiteral.ID = "lit" + theDay.ToString();
if (toolTipText != "")
{
Telerik.Web.UI.RadToolTip tip = new Telerik.Web.UI.RadToolTip();
tip.Text = "<div style=\"padding: 10px;\">" + toolTipText + "</div>";
tip.Width = 200;
tip.TargetControlID = "theDay" + theDay.ToString();
tip.IsClientID = true;
tip.HideEvent = Telerik.Web.UI.ToolTipHideEvent.ManualClose;
tip.Animation = Telerik.Web.UI.ToolTipAnimation.None;
tip.Position = Telerik.Web.UI.ToolTipPosition.TopCenter;
tip.ShowEvent = Telerik.Web.UI.ToolTipShowEvent.OnClick;
tip.Skin = "Sunset";
ToolTipPanel.Controls.Add(tip);
tip.RelativeTo = Telerik.Web.UI.ToolTipRelativeDisplay.Element;
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
HttpCookie cookie = Request.Cookies["BrowserDate"];
Data dat = new Data(DateTime.Parse(cookie.Value.ToString().Replace("%20", " ").Replace("%3A", ":")));
if (searchNumber != "")
{
string markerNumber = dat.GetImageNum(searchNumber); //(int.Parse(dat.GetImageNum(searchNumber)) + numofallresults).ToString();
ImageLiteral.Text = imageLiteral + "<div style=\"float: left;\"><img style=\"cursor: pointer;\" onclick=\"myclick(" + markerNumber + ");\" src=" +
"\"http://www.google.com/mapfiles/marker" + searchNumber + ".png\" /></div>";
//SearchLiteral.Text += "<script type=\"text/javascript\">var letter = String.fromCharCode(\"A\".charCodeAt(0) + " +
// searchNumber + "); var letteredIcon = new GIcon(baseIcon); document.getElementById('image" + searchNumber +
// "').src = \"http://www.google.com/mapfiles/marker\" + letter + \".png\";</script>";
BeginingLiteral.Text = "<div style=\";background-color:" + color + "; min-height: 33px; width: " + width.ToString() +
"px; padding: 3px; margin-bottom: 3px;\">";
}
else
{
BeginingLiteral.Text = "<div style=\"background-color:" + color + "; width: " + width.ToString() +
"px; padding: 3px; margin-bottom: 3px;\">";
}
SearchLabel.Text = searchLabel;
//search = true is disabled here
if (windowT)
{
SearchLabel.Attributes.Add("onclick", "CloseWindow('" + "../" + dat.MakeNiceName(searchLabel) + "_" + venueID + "_Venue" + "');");
}
else
{
SearchLabel.NavigateUrl = "../" + dat.MakeNiceName(searchLabel) + "_" + venueID + "_Venue";
}
string begining = "<div style=\"color: #b1a812; font-family: Arial; font-size: 11px;\">";
string end = "</div>";
TagsLiteral.Text = begining + city + ", " + state + end;
dat.TAG_TYPE = Data.tagType.VENUE;
string tags = dat.getTags(dat.GetData("SELECT DISTINCT C.ID, C.Name AS CategoryName, VC.tagSize FROM Venue_Category VC, VenueCategories C WHERE VC.CATEGORY_ID=C.ID AND VC.VENUE_ID=" + venueID), false, windowT);
TagsLiteral.Text += "<span style=\"color: #b1a812; line-height: 10px; font-size: 11px;\" >" + tags + "</span>";
}
protected void PostIt(object sender, EventArgs e)
{
HttpCookie cookie = Request.Cookies["BrowserDate"];
if (AgreeCheckBox.Checked)
{
Data dat = new Data(DateTime.Parse(cookie.Value.ToString().Replace("%20", " ").Replace("%3A", ":")));
SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["Connection"].ToString());
conn.Open();
bool mediaChanged = false;
bool contentChanged = false;
string mediaCat = "0";
if (PictureCheckList.Items.Count > 0)
mediaCat = "1";
bool isUpdate = false;
bool isOwner = false;
string ownerID = "";
DataSet dsVenue = new DataSet();
bool ownerUpForGrabs = false;
if (Request.QueryString["ID"] != null)
{
dsVenue = dat.GetData("SELECT * FROM Venues WHERE ID=" + Request.QueryString["ID"].ToString());
isUpdate = true;
ownerUpForGrabs = dat.IsOwnerUpForGrabs(Request.QueryString["ID"].ToString(), ref ownerID, ref isOwner, true);
}
string state = "";
if (StateDropDownPanel.Visible)
state = StateDropDown.SelectedItem.Text;
else
state = StateTextBox.THE_TEXT;
//We already do this in 'Onwards' method
//SqlCommand cmd = new SqlCommand("SELECT * FROM Venues WHERE Name=@name AND City=@city AND State=@state ", conn);
//cmd.Parameters.Add("@name", SqlDbType.NVarChar).Value = VenueNameTextBox.THE_TEXT;
//cmd.Parameters.Add("@city", SqlDbType.NVarChar).Value = CityTextBox.Text;
//cmd.Parameters.Add("@state", SqlDbType.NVarChar).Value = state;
//DataSet ds = new DataSet();
//SqlDataAdapter da = new SqlDataAdapter(cmd);
//da.Fill(ds);
//bool cont = false;
//if (ds.Tables.Count > 0)
// if (ds.Tables[0].Rows.Count > 0 && !isUpdate)
// {
// MessagePanel.Visible = true;
// YourMessagesLabel.Text += "<br/><br/>A venue under this name already exists in this City and State. To edit the details of this particular venue please contact Hippo Happenings " + "<a class=\"AddGreenLink\" href=\"ContactUs.aspx\">here</a>. Otherwise, please modify the name slightly.";
// }
// else
// cont = true;
//else
// cont = true;
bool cont = true;
if (cont)
{
string command = "";
if (isUpdate)
{
if (isOwner || ownerUpForGrabs)
command = "UPDATE Venues SET Name=@name, Owner=@owner, City=@city, Edit='False', Email=@email, Phone=@phone, State=@state, Country=@country, Zip=@zip, Address=@address, "
+ " EditedByUser=@user, Content=@content, Web=@web, mediaCategory=" + mediaCat + ", LastEditOn=@dateE WHERE ID=" + Request.QueryString["ID"].ToString();
else
{
command = "INSERT INTO VenueRevisions (Web, modifierID, VenueID, [Content], " +
"City, State, Country, Zip, Name, Email, Phone, Address, DATE)"
+ " VALUES(@web, "+Session["User"].ToString()+"," + Request.QueryString["ID"].ToString() +
", @content, @city, @state, @country, @zip, "+
"@name, @email, @phone, @address, '"+DateTime.Parse(cookie.Value.ToString().Replace("%20", " ").Replace("%3A", ":"))+"')";
}
}
else
command = "INSERT INTO Venues (Web, Owner, City, State, Country, Zip, Edit, Name, Email, Phone, Address, CreatedByUser,Content, mediaCategory, Rating, PostedOn) "
+ "VALUES(@web, @owner, @city, @state, @country, @zip, 'False', @name, @email, @phone, @address, @user, @content, " + mediaCat + ", 0, @dateE)";
string locationStr = "";
string apt = "";
if (AptNumberTextBox.Text.Trim() != "")
apt = AptDropDown.SelectedItem.Text + " " + AptNumberTextBox.Text.Trim().ToLower();
if (CountryDropDown.SelectedValue == "223")
{
locationStr = StreetNumberTextBox.Text.Trim().ToLower() + ";" + StreetNameTextBox.Text.Trim().ToLower()
+ ";" + StreetDropDown.SelectedItem.Text + ";" + apt;
}
else
{
locationStr = LocationTextBox.Text.Trim().ToLower() + ";" + apt;
}
SqlCommand cmd = new SqlCommand(command, conn);
cmd.CommandType = CommandType.Text;
cmd.Parameters.Add("@dateE", SqlDbType.DateTime).Value = DateTime.Parse(cookie.Value.ToString().Replace("%20", " ").Replace("%3A", ":"));
if (isUpdate && !isOwner)
{
if (ownerUpForGrabs)
{
if (OwnerCheckBox.Checked)
cmd.Parameters.Add("@owner", SqlDbType.Int).Value = Session["User"].ToString();
else
{
if (ownerUpForGrabs)
{
cmd.Parameters.Add("@owner", SqlDbType.Int).Value = DBNull.Value;
}
}
}
else
{
}
cmd.Parameters.Add("@user", SqlDbType.Int).Value = Session["User"].ToString();
if (dsVenue.Tables[0].Rows[0]["Name"].ToString() != VenueNameTextBox.THE_TEXT.Trim())
{
cmd.Parameters.Add("@name", SqlDbType.NVarChar).Value = VenueNameTextBox.THE_TEXT.Trim();
contentChanged = true;
}
else
{
if (ownerUpForGrabs)
{
cmd.Parameters.Add("@name", SqlDbType.NVarChar).Value = dsVenue.Tables[0].Rows[0]["Name"].ToString();
}
else
{
cmd.Parameters.Add("@name", SqlDbType.NVarChar).Value = DBNull.Value;
}
}
if (dsVenue.Tables[0].Rows[0]["Email"].ToString() != EmailTextBox.Text.Trim())
{
if(EmailTextBox.Text.Trim() != "")
cmd.Parameters.Add("@email", SqlDbType.NVarChar).Value = EmailTextBox.Text.Trim();
else
cmd.Parameters.Add("@email", SqlDbType.NVarChar).Value = DBNull.Value;
contentChanged = true;
}
else
{
if (ownerUpForGrabs)
{
cmd.Parameters.Add("@email", SqlDbType.NVarChar).Value = dsVenue.Tables[0].Rows[0]["Email"].ToString();
}
else
{
cmd.Parameters.Add("@email", SqlDbType.NVarChar).Value = DBNull.Value;
}
}
if (dsVenue.Tables[0].Rows[0]["Phone"].ToString() != PhoneTextBox.Text.Trim())
{
if (PhoneTextBox.Text.Trim() != "")
cmd.Parameters.Add("@phone", SqlDbType.NVarChar).Value = PhoneTextBox.Text.Trim();
else
cmd.Parameters.Add("@phone", SqlDbType.NVarChar).Value = DBNull.Value;
contentChanged = true;
}
else
{
if (ownerUpForGrabs)
{
cmd.Parameters.Add("@phone", SqlDbType.NVarChar).Value = dsVenue.Tables[0].Rows[0]["Phone"].ToString();
}
else
{
cmd.Parameters.Add("@phone", SqlDbType.NVarChar).Value = DBNull.Value;
}
}
if (dsVenue.Tables[0].Rows[0]["Web"].ToString() != WebSiteTextBox.Text.Trim())
{
if (WebSiteTextBox.Text.Trim() != "")
cmd.Parameters.Add("@web", SqlDbType.NVarChar).Value = WebSiteTextBox.Text.Trim();
else
cmd.Parameters.Add("@web", SqlDbType.NVarChar).Value = DBNull.Value;
contentChanged = true;
}
else
{
if (ownerUpForGrabs)
{
cmd.Parameters.Add("@web", SqlDbType.NVarChar).Value =
dsVenue.Tables[0].Rows[0]["Web"].ToString();
}
else
{
cmd.Parameters.Add("@web", SqlDbType.NVarChar).Value = DBNull.Value;
}
}
if (dsVenue.Tables[0].Rows[0]["Address"].ToString() != locationStr)
{
cmd.Parameters.Add("@address", SqlDbType.NVarChar).Value = locationStr;
contentChanged = true;
}
else
{
if (ownerUpForGrabs)
{
cmd.Parameters.Add("@address", SqlDbType.NVarChar).Value = dsVenue.Tables[0].Rows[0]["Address"].ToString();
}
else
{
cmd.Parameters.Add("@address", SqlDbType.NVarChar).Value = DBNull.Value;
}
}
if (dsVenue.Tables[0].Rows[0]["Content"].ToString() != DescriptionTextBox.Content.Trim())
{
cmd.Parameters.Add("@content", SqlDbType.NVarChar).Value = DescriptionTextBox.Content;
contentChanged = true;
}
else
{
if (ownerUpForGrabs)
{
cmd.Parameters.Add("@content", SqlDbType.NVarChar).Value = dsVenue.Tables[0].Rows[0]["Content"].ToString();
}
else
{
cmd.Parameters.Add("@content", SqlDbType.NVarChar).Value = DBNull.Value;
}
}
if (dsVenue.Tables[0].Rows[0]["Country"].ToString() != CountryDropDown.SelectedValue)
{
cmd.Parameters.Add("@country", SqlDbType.Int).Value = int.Parse(CountryDropDown.SelectedValue);
contentChanged = true;
}
else
{
if (ownerUpForGrabs)
{
cmd.Parameters.Add("@country", SqlDbType.Int).Value = dsVenue.Tables[0].Rows[0]["Country"].ToString();
}
else
{
cmd.Parameters.Add("@country", SqlDbType.Int).Value = DBNull.Value;
}
}
if (dsVenue.Tables[0].Rows[0]["Zip"].ToString() != ZipTextBox.Text.Trim())
{
cmd.Parameters.Add("@zip", SqlDbType.NVarChar).Value = ZipTextBox.Text.Trim();
contentChanged = true;
}
else
{
if (ownerUpForGrabs)
{
cmd.Parameters.Add("@zip", SqlDbType.NVarChar).Value = dsVenue.Tables[0].Rows[0]["Zip"].ToString();
}
else
{
cmd.Parameters.Add("@zip", SqlDbType.NVarChar).Value = DBNull.Value;
}
}
if (dsVenue.Tables[0].Rows[0]["City"].ToString() != CityTextBox.Text.Trim())
{
cmd.Parameters.Add("@city", SqlDbType.NVarChar).Value = CityTextBox.Text.Trim();
contentChanged = true;
}
else
{
if (ownerUpForGrabs)
{
cmd.Parameters.Add("@city", SqlDbType.NVarChar).Value = dsVenue.Tables[0].Rows[0]["City"].ToString();
}
else
{
cmd.Parameters.Add("@city", SqlDbType.NVarChar).Value = DBNull.Value;
}
}
if (dsVenue.Tables[0].Rows[0]["State"].ToString() != state)
{
cmd.Parameters.Add("@state", SqlDbType.NVarChar).Value = state;
contentChanged = true;
}
else
{
if (ownerUpForGrabs)
{
cmd.Parameters.Add("@state", SqlDbType.NVarChar).Value = dsVenue.Tables[0].Rows[0]["State"].ToString();
}
else
{
cmd.Parameters.Add("@state", SqlDbType.NVarChar).Value = DBNull.Value;
}
}
}
else
{
if (OwnerPanel.Visible)
{
if(OwnerCheckBox.Checked)
cmd.Parameters.Add("@owner", SqlDbType.Int).Value = Session["User"].ToString();
else
cmd.Parameters.Add("@owner", SqlDbType.Int).Value = DBNull.Value;
}
else
{
}
cmd.Parameters.Add("@name", SqlDbType.NVarChar).Value = VenueNameTextBox.THE_TEXT.Trim();
if (EmailTextBox.Text != "")
cmd.Parameters.Add("@email", SqlDbType.NVarChar).Value = EmailTextBox.Text.Trim();
else
cmd.Parameters.Add("@email", SqlDbType.NVarChar).Value = DBNull.Value;
if (PhoneTextBox.Text != "")
cmd.Parameters.Add("@phone", SqlDbType.NVarChar).Value = PhoneTextBox.Text.Trim();
else
cmd.Parameters.Add("@phone", SqlDbType.NVarChar).Value = DBNull.Value;
if (WebSiteTextBox.Text != "")
cmd.Parameters.Add("@web", SqlDbType.NVarChar).Value = WebSiteTextBox.Text.Trim();
else
cmd.Parameters.Add("@web", SqlDbType.NVarChar).Value = DBNull.Value;
cmd.Parameters.Add("@address", SqlDbType.NVarChar).Value = locationStr;
cmd.Parameters.Add("@user", SqlDbType.Int).Value = int.Parse(Session["User"].ToString());
cmd.Parameters.Add("@content", SqlDbType.NVarChar).Value = DescriptionTextBox.Content.Trim();
cmd.Parameters.Add("@country", SqlDbType.Int).Value = int.Parse(CountryDropDown.SelectedValue);
cmd.Parameters.Add("@zip", SqlDbType.NVarChar).Value = ZipTextBox.Text.Trim();
cmd.Parameters.Add("@city", SqlDbType.NVarChar).Value = CityTextBox.Text.Trim();
cmd.Parameters.Add("@state", SqlDbType.NVarChar).Value = state;
}
cmd.ExecuteNonQuery();
string ID = "";
string revisionID = "1";
if (isUpdate)
{
if (!isOwner)
{
ID = Request.QueryString["ID"].ToString();
cmd = new SqlCommand("SELECT @@IDENTITY AS IDS", conn);
SqlDataAdapter da2 = new SqlDataAdapter(cmd);
DataSet ds3 = new DataSet();
da2.Fill(ds3);
revisionID = ds3.Tables[0].Rows[0]["IDS"].ToString();
}
else
{
ID = Request.QueryString["ID"].ToString();
}
}
else
{
cmd = new SqlCommand("SELECT @@IDENTITY AS IDS", conn);
SqlDataAdapter da2 = new SqlDataAdapter(cmd);
DataSet ds3 = new DataSet();
da2.Fill(ds3);
ID = ds3.Tables[0].Rows[0]["IDS"].ToString();
}
bool isSlider = false;
if (PictureCheckList.Items.Count > 0)
isSlider = true;
if (isSlider)
{
char[] delim2 = { '\\' };
//string[] fileArray = System.IO.Directory.GetFiles(MapPath(".") + "\\UserFiles\\" + Session["UserName"].ToString() + "\\Slider\\");
if (!System.IO.Directory.Exists(MapPath(".") + "\\VenueFiles"))
{
System.IO.Directory.CreateDirectory(MapPath(".") + "\\VenueFiles\\");
System.IO.Directory.CreateDirectory(MapPath(".") + "\\VenueFiles\\" + ID+"\\");
System.IO.Directory.CreateDirectory(MapPath(".") + "\\VenueFiles\\" + ID + "\\Slider\\");
}
else
{
if (!System.IO.Directory.Exists(MapPath(".") + "\\VenueFiles\\" + ID))
{
System.IO.Directory.CreateDirectory(MapPath(".") + "\\VenueFiles\\" + ID+"\\");
System.IO.Directory.CreateDirectory(MapPath(".") + "\\VenueFiles\\" + ID+"\\Slider\\");
}
else
{
if (!!System.IO.Directory.Exists(MapPath(".")+"\\VenueFiles\\" + ID+"\\Slider\\"))
System.IO.Directory.CreateDirectory(MapPath(".")+"\\VenueFiles\\" + ID+"\\Slider\\");
}
}
string YouTubeStr = "";
char[] delim3 = { '.'};
dat.Execute("DELETE FROM Venue_Slider_Mapping WHERE VenueID=" + ID.ToString());
for (int i = 0; i < PictureCheckList.Items.Count; i++)
{
//int length = fileArray[i].Split(delim2).Length;
string[] tokens = PictureCheckList.Items[i].Value.ToString().Split(delim3);
if (tokens.Length >= 2)
{
//if (PictureCheckList.Items[i].Enabled)
//{
if (tokens[1].ToUpper() == "JPG" || tokens[1].ToUpper() == "JPEG" || tokens[1].ToUpper() == "GIF" || tokens[1].ToUpper() == "PNG")
{
if (!System.IO.File.Exists(MapPath(".") + "\\VenueFiles\\" + ID.ToString() + "\\Slider\\" + PictureCheckList.Items[i].Value))
{
System.IO.File.Copy(MapPath(".") + "\\UserFiles\\" + Session["UserName"].ToString() + "\\Slider\\" +
PictureCheckList.Items[i].Value,
MapPath(".") + "\\VenueFiles\\" + ID.ToString() + "\\Slider\\" + PictureCheckList.Items[i].Value);
}
cmd = new SqlCommand("INSERT INTO Venue_Slider_Mapping (VenueID, PictureName, RealPictureName) "+
"VALUES (@eventID, @picName, @realName)", conn);
cmd.Parameters.Add("@eventID", SqlDbType.Int).Value = ID;
cmd.Parameters.Add("@picName", SqlDbType.NVarChar).Value = PictureCheckList.Items[i].Value;
cmd.Parameters.Add("@realName", SqlDbType.NVarChar).Value = PictureCheckList.Items[i].Text;
cmd.ExecuteNonQuery();
}
else if (tokens[1].ToUpper() == "WMV")
{
if (!System.IO.File.Exists(MapPath(".") + "\\VenueFiles\\" + ID.ToString() + "\\Slider\\" + PictureCheckList.Items[i].Value))
{
System.IO.File.Copy(MapPath(".") + "\\UserFiles\\" + Session["UserName"].ToString() + "\\Slider\\" +
PictureCheckList.Items[i].Value,
MapPath(".") + "\\VenueFiles\\" + ID.ToString() + "\\Slider\\" + PictureCheckList.Items[i].Value);
}
cmd = new SqlCommand("INSERT INTO Venue_Slider_Mapping (VenueID, PictureName) VALUES (@eventID, @picName)", conn);
cmd.Parameters.Add("@eventID", SqlDbType.Int).Value = ID;
cmd.Parameters.Add("@picName", SqlDbType.NVarChar).Value = PictureCheckList.Items[i].Value;
cmd.ExecuteNonQuery();
}
//}
}
else
{
YouTubeStr += PictureCheckList.Items[i].Value + ";";
}
}
dat.Execute("UPDATE Venues SET YouTubeVideo='" + YouTubeStr + "' WHERE ID=" + ID);
}
CreateCategories(ID, isOwner, isUpdate, revisionID, ownerUpForGrabs);
//if (CategoriesCheckBoxes.Items.Count > 0)
//{
// int catCount = CategoriesCheckBoxes.Items.Count;
// for (int i = 0; i < catCount; i++)
// {
// cmd = new SqlCommand("INSERT INTO Event_Category_Mapping (EventID, CategoryID) VALUES (@eventID, @catID)", conn);
// cmd.Parameters.Add("@catID", SqlDbType.Int).Value = int.Parse(CategoriesCheckBoxes.Items[i].Value);
// cmd.Parameters.Add("@eventID", SqlDbType.Int).Value = ID;
// cmd.ExecuteNonQuery();
// }
//}
//Send the informational email to the user
DataSet dsUser = dat.GetData("SELECT Email, UserName FROM USERS WHERE User_ID=" +
Session["User"].ToString());
string emailBody = "<br/><br/>Dear " + dsUser.Tables[0].Rows[0]["UserName"].ToString() + ", <br/><br/> you have successfully posted the venue \"" + VenueNameTextBox.THE_TEXT +
"\". <br/><br/> You can find this venue <a href=\"http://hippohappenings.com/" + dat.MakeNiceName(VenueNameTextBox.THE_TEXT) + "_" + ID + "_Venue\">here</a>. " +
"<br/><br/> To rate your experience posting this venue <a href=\"http://hippohappenings.com/RateExperience.aspx?Edit=" + isUpdate.ToString() + "&Type=V&ID=" + ID + "\">please include your feedback here.</a>" +
"<br/><br/><br/>Have a Hippo Happening Day!<br/><br/>";
//MessageLiteral.Text = "<script type=\"text/javascript\">alert('" + message + "');</script>";
if (isUpdate && !isOwner)
{
if (!ownerUpForGrabs)
{
DataSet dsEventUser = dat.GetData("SELECT * FROM Users U WHERE User_ID=" + ownerID);
emailBody = "<br/><br/>A change request has been submitted for a venue you are the owner of on HippoHappenings: \"" + VenueNameTextBox.THE_TEXT.Trim() +
"\". <br/><br/> You can find this venue <a href=\"http://hippohappenings.com/" + dat.MakeNiceName(VenueNameTextBox.THE_TEXT) + "_" + ID + "_Venue\">here</a>. " +
"<br/><br/> Please log into Hippo Happenings and check your messages to view and approve these changes.</a>" +
"<br/><br/><br/>Have a Hippo Happening Day!<br/><br/>";
//conn.Open();
SqlCommand cmd34 = new SqlCommand("INSERT INTO UserMessages (MessageContent, MessageSubject, From_UserID, To_UserID, Date, [Read], Mode, Live, SentLive) VALUES('" +
"VenueID:" + Request.QueryString["ID"].ToString() + ",UserID:" + Session["User"].ToString() + ",RevisionID:" + revisionID + "',@content, "+dat.HIPPOHAPP_USERID.ToString()+", " + ownerID + ", '" + DateTime.Parse(cookie.Value.ToString().Replace("%20", " ").Replace("%3A", ":")).ToString() + "', 0, 5, 1, 1)", conn);
cmd34.Parameters.Add("@content", SqlDbType.NVarChar).Value = "A change request has been submitted for a venue you've created: " +
VenueNameTextBox.THE_TEXT;
cmd34.ExecuteNonQuery();
conn.Close();
if (!Request.Url.AbsoluteUri.Contains("localhost"))
{
dat.SendEmail(System.Configuration.ConfigurationManager.AppSettings["emailemail"].ToString(),
System.Configuration.ConfigurationManager.AppSettings["emailName"].ToString(),
dsEventUser.Tables[0].Rows[0]["Email"].ToString(), emailBody, "A change request has been submitted for a venue you own on HippoHappenings: " +
VenueNameTextBox.THE_TEXT);
}
}
}
if (isUpdate)
{
if (isOwner)
{
//dat.SendEmail(System.Configuration.ConfigurationManager.AppSettings["emailemail"].ToString(),
// System.Configuration.ConfigurationManager.AppSettings["emailName"].ToString(),
// dsUser.Tables[0].Rows[0]["Email"].ToString(), emailBody, "You have updated venue: " +
// VenueNameTextBox.THE_TEXT);
}
else
{
if (ownerUpForGrabs)
{
emailBody = "<br/><br/>You have successfully submitted updates for venue: \"" + VenueNameTextBox.THE_TEXT.Trim() +
"\". <br/><br/> You can find this venue <a href=\"http://hippohappenings.com/" + dat.MakeNiceName(VenueNameTextBox.THE_TEXT) + "_" + ID + "_Venue\">here</a>. " +
"<br/><br/> To rate your experience posting this venue <a href=\"http://hippohappenings.com/RateExperience.aspx?Edit=" +
isUpdate.ToString() + "&Type=V&ID=" + ID + "\">please include your feedback here.</a><br/><br/>"+
"Have a Hippo Happening Day!<br/><br/>";
}
else
{
emailBody = "<br/><br/>You have successfully submitted updates for venue: \"" + VenueNameTextBox.THE_TEXT.Trim() +
"\". <br/><br/> You can find this venue <a href=\"http://hippohappenings.com/" + dat.MakeNiceName(VenueNameTextBox.THE_TEXT) + "_" + ID + "_Venue\">here</a>. " +
"<br/><br/> The owner of the venue will need to approve/reject your change suggestions. If you do not hear back " +
"from the venue's owner within 7 days, you will be allowed to take over ownership of this venue and automatically submit changes. That is, if no one else beats you to it! " +
"If you have chosen to take over ownership, a button will be available for you on the venue's page. If you have not, you will need to edit the venue's details again." +
"<br/><br/><br/>Have a Hippo Happening Day!<br/><br/>";
}
if (!Request.Url.AbsoluteUri.Contains("localhost"))
{
dat.SendEmail(System.Configuration.ConfigurationManager.AppSettings["emailemail"].ToString(),
System.Configuration.ConfigurationManager.AppSettings["emailName"].ToString(),
dsUser.Tables[0].Rows[0]["Email"].ToString(), emailBody, "You have submitted updates for venue: " +
VenueNameTextBox.THE_TEXT);
}
}
}
else
{
if (!Request.Url.AbsoluteUri.Contains("localhost"))
{
dat.SendEmail(System.Configuration.ConfigurationManager.AppSettings["emailemail"].ToString(),
System.Configuration.ConfigurationManager.AppSettings["emailName"].ToString(),
dsUser.Tables[0].Rows[0]["Email"].ToString(), emailBody, "You have posted the venue: " +
VenueNameTextBox.THE_TEXT);
}
}
conn.Close();
//Update ownership history if neccessary
if (isUpdate)
{
if (OwnerPanel.Visible)
{
if (isOwner)
{
if (!OwnerCheckBox.Checked)
{
string OwnerHistoryID = dat.GetData("SELECT * FROM VenueOwnerHistory WHERE VenueID="+
Request.QueryString["ID"].ToString()+" AND OwnerID="+Session["User"].ToString()+
" ORDER BY DateCreatedOwnership DESC").Tables[0].Rows[0]["ID"].ToString();
dat.Execute("UPDATE VenueOwnerHistory SET DateLostOwnership='"+DateTime.Parse(cookie.Value.ToString().Replace("%20", " ").Replace("%3A", ":")).ToString()+
"', GaveUpOwnership='True' WHERE ID="+OwnerHistoryID);
}
}
else
{
if (OwnerCheckBox.Checked)
{
dat.Execute("INSERT INTO VenueOwnerHistory (VenueID, OwnerID, DateCreatedOwnership) "+
"VALUES("+Request.QueryString["ID"].ToString()+", "+Session["User"].ToString()+
", '"+DateTime.Parse(cookie.Value.ToString().Replace("%20", " ").Replace("%3A", ":")).ToString()+"')");
}
}
}
}
else
{
dat.Execute("INSERT INTO VenueOwnerHistory (VenueID, OwnerID, DateCreatedOwnership) VALUES("+ID+", "+Session["User"].ToString()+", '"+DateTime.Parse(cookie.Value.ToString().Replace("%20", " ").Replace("%3A", ":")).ToString()+"')");
}
//pop up the message to the user
Encryption encrypt = new Encryption();
if (isOwner || !isUpdate)
{
Session["Message"] = "Your venue has been posted successfully! An email with this info will also be sent to your account.<br/>"
+ "Check out <a class=\"AddLink\" onclick=\"Search('" + dat.MakeNiceName(VenueNameTextBox.THE_TEXT) + "_" + ID + "_Venue');\">this venues's</a> home page.<br/><br/><br/> -<a class=\"AddLink\" onclick=\"Search('RateExperience.aspx?Edit=" + isUpdate.ToString() + "&Type=V&ID=" + ID + "');\" >Rate </a>your user experience posting this venue.<br/>";
//MessageLiteral.Text = "<script type=\"text/javascript\">alert('" + message + "');</script>";
}
else
{
if (ownerUpForGrabs)
{
Session["Message"] = "You have successfully submitted updates for venue: \"" + VenueNameTextBox.THE_TEXT.Trim() +
"\".<br/><br/>Check out <a class=\"AddLink\" onclick=\"Search('" + dat.MakeNiceName(VenueNameTextBox.THE_TEXT) + "_" + ID +
"_Venue');\">this venues's</a> home page.<br/><br/> <a class=\"AddLink\" onclick=\"Search('RateExperience.aspx?Edit=" +
isUpdate.ToString() + "&Type=V&ID=" + ID + "');\" >Rate </a>your user experience editing this venue.<br/>";
}
else
{
Session["Message"] = "You have successfully submitted updates for this venue." +
"<br/><br/> The owner of the venue will need to <b>approve/reject</b> your change suggestions. If you do not hear back " +
"from the venue's owner within <b>7 days</b>, you will be allowed to <b>take over ownership</b> of this venue and automatically submit changes. That is, if no one else beats you to it! " +
"If you have chosen to take over ownership, a button will be available for you on the venue's page to do so. If you have not, you will need to edit the venue's details again.<br/><br/>"
+ "Check out <a class=\"AddLink\" onclick=\"Search('" + dat.MakeNiceName(VenueNameTextBox.THE_TEXT) + "_" + ID + "_Venue');\">this venues's</a> home page.<br/><br/> <a class=\"AddLink\" onclick=\"Search('RateExperience.aspx?Edit=" + isUpdate.ToString() + "&Type=V&ID=" + ID + "');\" >Rate </a>your user experience editing this venue.<br/>";
MessageRadWindow.Width = 530;
MessageRadWindow.Height = int.Parse(MessageRadWindow.Height.Value.ToString()) + 20;
}
}
MessageRadWindow.NavigateUrl = "Message.aspx?message=" + encrypt.encrypt(Session["Message"].ToString() + "<br/><img onclick=\"Search('Home.aspx');\" onmouseover=\"this.src='image/DoneSonButtonSelected.png'\" onmouseout=\"this.src='image/DoneSonButton.png'\" src=\"image/DoneSonButton.png\"/>");
MessageRadWindow.Visible = true;
MessageRadWindowManager.VisibleOnPageLoad = true;
}
}
else
{
MessagePanel.Visible = true;
YourMessagesLabel.Text += "<br/><br/>You must agree to the terms and conditions.";
}
}
protected string GetEmailString(string header, string picture, string ID, string description,
string userName, bool isBig, ref int normalAdCount)
{
HttpCookie cookie = Request.Cookies["BrowserDate"];
Data dat = new Data(DateTime.Parse(cookie.Value.ToString().Replace("%20", " ").Replace("%3A", ":")));
string adtitle = "style=\"color: White;font-weight: bold;font-family: Arial;font-size: 14px;margin-top: 10px;text-decoration: none;\"";
string adbody = "style=\"color: #cccccc;font-family: Arial;font-size: 12px;line-height: 20px;\"";
string readmorelink = "style=\"font-family: Arial; font-weight: bold;color: #1fb6e7; font-size: 12px;text-decoration: none;\"";
string email = "";
if (isBig)
{
email += "<tr><td colspan=\"2\"><div style=\"float: left;width: 419px;margin: 10px; height: 206px; background-color: #686868;\">" +
"<div class=\"topDiv\" style=\"padding-top: 5px; clear: both; padding-left: 5px; background-color: #686868;\">";
if (picture == null)
{
email += "</div>" +
"<div style=\"float: left;padding-top: 5px; padding-left: 3px;\">";
}
else
{
email += "<div style=\"float: left;\"><table width='212px' height='190px' " +
"bgcolor=\"black\" cellpadding=\"0\" cellspacing=\"0\"><tbody align=\"center\"><tr>" +
"<td valign=\"middle\"><img alt=\"" +
header + "\" " + "name=\"" + header + "\" src=\"./UserFiles/" + userName + "/" +
picture + "\" /></td></tr></tbody></table></div>" + "" +
"<div style=\"text-align: center; padding-top: 5px; padding-left: 3px;\">";
}
if (ID == null)
{
email += "<a " + adtitle + ">" + dat.BreakUpString(header, 21) + "</a><br/>";
}
else
{
email += "<a href=\"http://HippoHappenings.com/" + dat.MakeNiceName(header) + "_" + ID + "_Ad" +
"\" " + adtitle + ">" + dat.BreakUpString(header, 10) + "</a><br/>";
}
email += "<label " + adbody + ">" + description + "</label>";
if (ID == null)
{
email += "<div style=\"float: right; padding-right: 8px; height: 50px; width: 80px; padding-top: 10px;\">" +
"<div style=\"float: left;padding-top: 5px; clear: none;\"><img src=\"http://HippoHappenings.com/image/ReadMoreArrow.png\" /></div>" +
"<div style=\"float: right;clear: none;\"><a " + readmorelink + ">Read More</a>";
}
else
{
email += "<div style=\"float: right; padding-right: 8px; height: 50px; width: 80px; padding-top: 10px;\">" +
"<div style=\"float: left;padding-top: 5px; clear: none;\"><img src=\"http://HippoHappenings.com/image/ReadMoreArrow.png\" /></div>" +
"<div style=\"float: right;clear: none;\"><a " + readmorelink + " href=\"http://HippoHappenings.com/" + dat.MakeNiceName(header) + "_" + ID + "_Ad\">Read More</a>";
}
email += "</div></div>" +
"</div>" +
"</div>" +
"</div></td></tr>";
}
else
{
if (normalAdCount % 2 == 0)
{
email += "<tr><td>";
}
else
{
email += "<td>";
}
email += "<div style=\"float: left;margin: 10px; width: 214px; height: 268px; "+
"background-color: #686868;\">" +
"<div style=\"float: left;width: 214px; height: 268px; background-color: #686868;\">" +
"<div class=\"topDiv\" style=\";padding-top: 10px; clear: both; padding-left: 10px;\">";
if (picture == null)
{
email += "";
}
else
{
string w = "";
string h = "";
GetAdSize(out w, out h, picture);
email += "<div style=\"float: left;\"><table width=\"100px\" height=\"100px\" " +
"bgcolor=\"black\" cellpadding=\"0\" cellspacing=\"0\"><tbody align=\"center\"><tr><td valign=\"middle\">" +
"<img alt=\"" + header + "\" " +
"name=\"" + header + "\" width='" + w + "px' height='" + h + "px' src=\"./UserFiles/" +
userName + "/" + picture + "\" /></td></tr></tbody></table></div>";
}
if (ID == null)
{
email += "<div style=\"text-align: center; padding-left: 3px;\"><a " + adtitle + ">" +
dat.BreakUpString(header, 10) + "</a><br/>" +
"</div>" +
"</div>" +
"<div align=\"left\" style=\"clear: both; padding-left: 12px; padding-right: 8px;\">" +
"<label " + adbody + ">" + description + "</label>" +
"</div>" +
"<div style=\"float: right; padding-right: 8px; height: 50px; width: 80px; padding-top: 10px;\">" +
"<div style=\"float: left;padding-top: 5px; clear: none;\"><img src=\"http://HippoHappenings.com/image/ReadMoreArrow.png\" /></div>" +
"<div style=\"float: right;clear: none;\"><a " + readmorelink + " >Read More</a>" +
"</div></div></div></div>";
}
else
{
email += "<div><a href=\"http://HippoHappenings.com/" + dat.MakeNiceName(header) +
"_" + ID + "_Ad\" " + adtitle + ">" + dat.BreakUpString(header, 10) + "</a><br/>" +
"</div>" +
"</div>" +
"<div align=\"left\" style=\"clear: both; padding-left: 12px; padding-right: 8px;\">" +
"<label " + adbody + ">" + description + "</label>" +
"</div>" +
"<div style=\"float: right; padding-right: 8px; height: 50px; width: 80px; padding-top: 10px;\">" +
"<div style=\"float: left;padding-top: 5px; clear: none;\"><img src=\"http://HippoHappenings.com/image/ReadMoreArrow.png\" /></div>" +
"<div style=\"float: right;clear: none;\"><a " + readmorelink + " href=\"http://HippoHappenings.com/" + dat.MakeNiceName(header) + "_" + ID + "_Ad\">Read More</a>" +
"</div></div></div></div>";
}
if (normalAdCount % 2 == 0)
{
email += "</td>";
}
else
{
email += "</td></tr>";
}
normalAdCount++;
}
return email;
}
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 Page_Load(object sender, EventArgs e)
{
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 background = "";
if (isFeatured)
{
background = "background-color: #e9f1f4;";
}
else
{
background = "border-bottom: solid 1px #dedbdb;";
}
if (searchNumber != "")
{
string markerNumber = dat.GetImageNum(searchNumber);
ImageLiteral.Text = imageLiteral + "<div style=\"float: left;padding-right: 5px;height: 50px;\"><img style=\"cursor: pointer;\" onclick=\"myclick(" + markerNumber + ");\" src=" +
"\"http://www.google.com/mapfiles/marker" + searchNumber + ".png\" /></div>";
BeginingLiteral.Text = "<div style=\"clear: both;margin-top: 3px;height: 56px;margin-bottom: 3px; width: " + width.ToString() +
"px; padding: 3px;" + background + "\">";
}
else
{
BeginingLiteral.Text = "<div class=\"topDiv\" style=\"clear: both;background-color:" + color + "; width: " + width.ToString() +
"px; padding: 3px; margin-bottom: 3px;" + background + "\">";
}
SearchLabel.NavigateUrl = "../" + dat.MakeNiceName(searchLabel) + "_" + venueID + "_Venue";
if (searchLabel.Length > 36)
{
searchLabel = searchLabel.Substring(0, 33) + "...";
}
SearchLabel.Text = dat.stripHTML(searchLabel);
DataView dvEvent = dat.GetDataDV("SELECT * FROM Venues WHERE ID=" + venueID);
string shortDesc = "";
if (dvEvent[0]["Content"].ToString().Trim() != "")
{
shortDesc = dat.stripHTML(dvEvent[0]["Content"].ToString()).Trim();
if (shortDesc.Length > 113)
{
shortDesc = shortDesc.Substring(0, 110) + "...";
}
}
ShortDescriptionLabel.Text = dat.stripHTML(shortDesc);
DataView dvEventsSlider = dat.GetDataDV("SELECT * FROM Venues E, Venue_Slider_Mapping ESM "+
"WHERE E.ID=ESM.VenueID AND E.ID=" + venueID);
if (dvEventsSlider.Count > 0)
{
if (System.IO.File.Exists(MapPath("../") + "\\VenueFiles\\" +
venueID + "\\Slider\\" + dvEventsSlider[0]["PictureName"].ToString()))
{
System.Drawing.Image img = System.Drawing.Image.FromFile(MapPath("../") + "\\VenueFiles\\" +
venueID + "\\Slider\\" + dvEventsSlider[0]["PictureName"].ToString());
SaveThumbnail(img, MapPath("../") + "\\Temp\\Temp_" + dvEventsSlider[0]["PictureName"].ToString());
EventImageLiteral.Text = "<img style='float: left; padding-right: 5px;' src='http://hippohappenings.com/Temp/Temp_" +
dvEventsSlider[0]["PictureName"].ToString() + "' />";
}
}
else
{
EventImageLiteral.Text = "";
}
string begining = "<div class=\"TextNormal\">";
string end = "</div>";
TagsLiteral.Text = begining + end;
dat.TAG_TYPE = Data.tagType.VENUE;
int tagLength = 0;
if (ShortDescriptionLabel.Text.Length > 64)
{
tagLength = 57;
}
else if (ShortDescriptionLabel.Text.Length == 0)
{
tagLength = 183;
}
else
{
tagLength = 122;
}
string tags = dat.getTagsRestricted(dat.GetData("SELECT DISTINCT C.ID, C.Name AS "+
"CategoryName, VC.tagSize FROM Venue_Category VC, VenueCategories "+
"C WHERE VC.CATEGORY_ID=C.ID AND VC.VENUE_ID=" + venueID), false, windowT, tagLength);
TagsLiteral.Text += tags;
}
protected void PostIt(object sender, EventArgs e)
{
object appSeshCountry;
object appSeshState;
object appSeshCity;
object appSeshZip;
object appSeshRadius;
HttpCookie cookie = Request.Cookies["BrowserDate"];
if (AgreeCheckBox.Checked)
{
Data dat = new Data(DateTime.Parse(cookie.Value.ToString().Replace("%20", " ").Replace("%3A", ":")));
SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["Connection"].ToString());
conn.Open();
bool isEdit = false;
if (Request.QueryString["edit"] != null)
{
isEdit = bool.Parse(Request.QueryString["edit"].ToString());
}
string mediaCat = "0";
if (PictureCheckList.Items.Count > 0)
mediaCat = "1";
string command = "";
DataSet dsEvent;
int numViews = 0;
if (isEdit)
{
dsEvent = dat.GetData("SELECT * FROM Ads WHERE Ad_ID="+adID.Text);
numViews = int.Parse(dsEvent.Tables[0].Rows[0]["NumViews"].ToString());
string rad = "";
if (RadiusPanel.Visible)
rad = ", Radius=@radius ";
command = "UPDATE Ads SET hasSongs=@songs, User_ID=@userID, FeaturedSummary=@featuredSummary , " +
"Description=@description, Header=@header, CountShown=@countShown, mediaCategory=" + mediaCat + ", " +
"FeaturedPicture=@featuredPicture, FeaturedPictureName=@featuredPictureName, CatCountry=@catCountry, CatState=@catState, CatCity=@catCity, " +
"CatZip=@catZip" + rad + ", DisplayToAll=@displayAll, NumViews=@num WHERE Ad_ID=" + adID.Text;
}
else
{
string rad = "";
string radEnd = "";
if (RadiusPanel.Visible)
{
rad = ", Radius ";
radEnd = ", @radius ";
}
command = "INSERT INTO Ads (hasSongs, User_ID, FeaturedSummary ,Description, Header, "+
"CountShown, Featured, mediaCategory, FeaturedPicture, FeaturedPictureName, CatCountry, CatState, CatCity, "+
"CatZip" + rad + ", DisplayToAll, NumViews, NumCurrentViews, BigAd, DateAdded) "
+ " VALUES(@songs, @userID, @featuredSummary, @description, @header, @countShown, "+
"@featured, " + mediaCat + ", @featuredPicture, @featuredPictureName, @catCountry, @catState, @catCity, @catZip" + radEnd + ", @displayAll, @num, 0, @big, '" +
DateTime.Parse(cookie.Value.ToString().Replace("%20", " ").Replace("%3A", ":")).ToString() + "')";
}
SqlCommand cmd = new SqlCommand(command, conn);
cmd.CommandType = CommandType.Text;
cmd.Parameters.Add("@num", SqlDbType.Int).Value = int.Parse(UsersTextBox.Text) + numViews;
cmd.Parameters.Add("@description", SqlDbType.NVarChar).Value = DescriptionTextBox.Content;
cmd.Parameters.Add("@userID", SqlDbType.Int).Value = int.Parse(Session["User"].ToString());
cmd.Parameters.Add("@featured", SqlDbType.Bit).Value = bool.Parse(isFeatured.Text);
cmd.Parameters.Add("@songs", SqlDbType.Bit).Value = MusicCheckBox.Checked;
if (bool.Parse(isFeatured.Text))
cmd.Parameters.Add("@featuredSummary", SqlDbType.NVarChar).Value = SummaryTextBox.InnerHtml;
else
cmd.Parameters.Add("@featuredSummary", SqlDbType.NVarChar).Value = DBNull.Value;
cmd.Parameters.Add("@header", SqlDbType.NVarChar).Value = AdNameTextBox.THE_TEXT;
cmd.Parameters.Add("@countShown", SqlDbType.Int).Value = 0;
if (AdPlacementList.SelectedValue == "0.01")
cmd.Parameters.Add("@big", SqlDbType.Bit).Value = false;
else
cmd.Parameters.Add("@big", SqlDbType.Bit).Value = true;
if (bool.Parse(isFeatured.Text))
if (AdPictureCheckList.Items.Count > 0 && AdMediaPanel.Visible)
{
cmd.Parameters.Add("@featuredPicture", SqlDbType.NVarChar).Value = AdPictureCheckList.Items[0].Value;
cmd.Parameters.Add("@featuredPictureName", SqlDbType.NVarChar).Value = AdPictureCheckList.Items[0].Text;
}
else
{
cmd.Parameters.Add("@featuredPicture", SqlDbType.NVarChar).Value = DBNull.Value;
cmd.Parameters.Add("@featuredPictureName", SqlDbType.NVarChar).Value = DBNull.Value;
}
else
{
cmd.Parameters.Add("@featuredPicture", SqlDbType.NVarChar).Value = DBNull.Value;
cmd.Parameters.Add("@featuredPictureName", SqlDbType.NVarChar).Value = DBNull.Value;
}
if (CountryDropDown.SelectedIndex != -1)
{
appSeshCountry = CountryDropDown.SelectedValue;
cmd.Parameters.Add("@catCountry", SqlDbType.Int).Value = CountryDropDown.SelectedValue;
string state = "";
if (StateDropDownPanel.Visible)
{
if (StateDropDown.SelectedIndex != -1)
state = StateDropDown.SelectedItem.Text;
}
else
state = StateTextBox.THE_TEXT;
appSeshState = state;
if (state != "")
cmd.Parameters.Add("@catState", SqlDbType.NVarChar).Value = state;
else
cmd.Parameters.Add("@catState", SqlDbType.NVarChar).Value = DBNull.Value;
if (CityTextBox.Text.Trim() != "")
{
appSeshCity = CityTextBox.Text.Trim();
cmd.Parameters.Add("@catCity", SqlDbType.NVarChar).Value = CityTextBox.Text.Trim();
}
else
cmd.Parameters.Add("@catCity", SqlDbType.NVarChar).Value = DBNull.Value;
if (ZipTextBox.Text.Trim() != "")
{
appSeshZip = ZipTextBox.Text.Trim();
appSeshRadius = RadiusDropDown.SelectedValue;
cmd.Parameters.Add("@catZip", SqlDbType.NVarChar).Value =
dat.GetAllZipsInRadius(RadiusDropDown.SelectedValue, ZipTextBox.Text.Trim(), true);
}
else
cmd.Parameters.Add("@catZip", SqlDbType.NVarChar).Value = DBNull.Value;
if(CountryDropDown.SelectedValue == "223")
cmd.Parameters.Add("@radius", SqlDbType.Int).Value = RadiusDropDown.SelectedValue;
}
else
{
cmd.Parameters.Add("@catCountry", SqlDbType.Int).Value = DBNull.Value;
cmd.Parameters.Add("@catState", SqlDbType.NVarChar).Value = DBNull.Value;
cmd.Parameters.Add("@catCity", SqlDbType.NVarChar).Value = DBNull.Value;
cmd.Parameters.Add("@catZip", SqlDbType.NVarChar).Value = DBNull.Value;
cmd.Parameters.Add("@radius", SqlDbType.Int).Value = DBNull.Value;
}
cmd.Parameters.Add("@displayAll", SqlDbType.Bit).Value = DisplayCheckList.Items[0].Selected;
//Media Categories: NONE: 0, Slider: 1.
bool isSlider = false;
if (PictureCheckList.Items.Count > 0)
isSlider = true;
cmd.ExecuteNonQuery();
cmd = new SqlCommand("SELECT @@IDENTITY AS ID", conn);
SqlDataAdapter da2 = new SqlDataAdapter(cmd);
DataSet ds3 = new DataSet();
da2.Fill(ds3);
string ID = ds3.Tables[0].Rows[0]["ID"].ToString();
if (isEdit)
{
dat.Execute("DELETE FROM Ad_Calendar WHERE AdID="+adID.Text);
if (bool.Parse(isFeatured.Text))
{
cmd = new SqlCommand("INSERT INTO Ad_Calendar (AdID, DateTimeStart, DateTimeEnd) VALUES(@id, @start, @end)", conn);
cmd.Parameters.Add("@id", SqlDbType.Int).Value = adID.Text;
cmd.Parameters.Add("@start", SqlDbType.DateTime).Value = Session["SelectedStartDate"].ToString();
cmd.Parameters.Add("@end", SqlDbType.DateTime).Value = DateTime.Parse(Session["SelectedStartDate"].ToString()).AddDays(double.Parse(DaysDropDown.SelectedValue));
cmd.ExecuteNonQuery();
}
else
{
cmd = new SqlCommand("INSERT INTO Ad_Calendar (AdID, DateTimeStart, DateTimeEnd) VALUES(@id, @start, @end)", conn);
cmd.Parameters.Add("@id", SqlDbType.Int).Value = adID.Text;
cmd.Parameters.Add("@start", SqlDbType.DateTime).Value = StartDateTimePicker.DbSelectedDate;
cmd.Parameters.Add("@end", SqlDbType.DateTime).Value = DateTime.Parse(StartDateTimePicker.DbSelectedDate.ToString()).AddDays(double.Parse(DaysDropDown.SelectedValue));
cmd.ExecuteNonQuery();
}
}
else
{
cmd = new SqlCommand("INSERT INTO Ad_Calendar (AdID, DateTimeStart, DateTimeEnd) VALUES(@id, @start, @end)", conn);
cmd.Parameters.Add("@id", SqlDbType.Int).Value = ID;
if (bool.Parse(isFeatured.Text))
{
cmd.Parameters.Add("@start", SqlDbType.DateTime).Value = Session["SelectedStartDate"].ToString();
cmd.Parameters.Add("@end", SqlDbType.DateTime).Value = DateTime.Parse(Session["SelectedStartDate"].ToString()).AddDays(double.Parse(DaysDropDown.SelectedValue));
}
else
{
cmd.Parameters.Add("@start", SqlDbType.DateTime).Value = DateTime.Parse(StartDateTimePicker.DbSelectedDate.ToString());
cmd.Parameters.Add("@end", SqlDbType.DateTime).Value = DateTime.Parse(StartDateTimePicker.DbSelectedDate.ToString()).AddDays(double.Parse(DaysDropDown.SelectedValue));
}
cmd.ExecuteNonQuery();
}
string theID = ID;
if (isEdit)
{
theID = adID.Text;
}
if (MusicCheckBox.Checked)
{
if (isEdit)
{
dat.Execute("DELETE FROM Ad_Song_Mapping WHERE AdID="+theID);
}
for (int i = 0; i < SongCheckList.Items.Count; i++)
{
cmd = new SqlCommand("INSERT INTO Ad_Song_Mapping (AdID, SongName, SongTitle) "+
"VALUES(@eventID, @songName, @songTitle)", conn);
cmd.Parameters.Add("@eventID", SqlDbType.Int).Value = int.Parse(theID);
cmd.Parameters.Add("@songName", SqlDbType.NVarChar).Value = SongCheckList.Items[i].Value.ToString();
cmd.Parameters.Add("@songTitle", SqlDbType.NVarChar).Value = SongCheckList.Items[i].Text;
cmd.ExecuteNonQuery();
dat.Execute("UPDATE Ads SET hasSongs=1 WHERE Ad_ID="+theID);
}
}
if (isEdit)
{
dat.Execute("DELETE FROM Ad_Slider_Mapping WHERE AdID=" + theID);
}
if (MainAttractionCheck.Checked)
{
if (isSlider)
{
char[] delim2 = { '\\' };
string[] fileArray = System.IO.Directory.GetFiles(MapPath(".") + "\\UserFiles\\" +
Session["UserName"].ToString() + "\\AdSlider\\");
if (!System.IO.Directory.Exists(MapPath(".") + "\\UserFiles"))
{
System.IO.Directory.CreateDirectory(MapPath(".") + "\\UserFiles");
System.IO.Directory.CreateDirectory(MapPath(".") + "\\UserFiles\\" + Session["UserName"].ToString() + "\\");
System.IO.Directory.CreateDirectory(MapPath(".") + "\\UserFiles\\" + Session["UserName"].ToString() + "\\AdSlider");
System.IO.Directory.CreateDirectory(MapPath(".") + "\\UserFiles\\" + Session["UserName"].ToString() + "\\AdSlider\\" + theID);
}
else
{
if (!System.IO.Directory.Exists(MapPath(".") + "\\UserFiles\\" + Session["UserName"].ToString() + "\\"))
{
System.IO.Directory.CreateDirectory(MapPath(".") + "\\UserFiles\\" + Session["UserName"].ToString() + "\\");
System.IO.Directory.CreateDirectory(MapPath(".") + "\\UserFiles\\" + Session["UserName"].ToString() + "\\AdSlider");
System.IO.Directory.CreateDirectory(MapPath(".") + "\\UserFiles\\" + Session["UserName"].ToString() + "\\" + theID);
}
else
{
if (!System.IO.Directory.Exists(MapPath(".") + "\\UserFiles\\" + Session["UserName"].ToString() + "\\AdSlider"))
{
System.IO.Directory.CreateDirectory(MapPath(".") + "\\UserFiles\\" + Session["UserName"].ToString() + "\\AdSlider");
System.IO.Directory.CreateDirectory(MapPath(".") + "\\UserFiles\\" + Session["UserName"].ToString() + "\\AdSlider\\" + theID);
}
else
{
if (!System.IO.Directory.Exists(MapPath(".") + "\\UserFiles\\" + Session["UserName"].ToString() + "\\AdSlider\\" + theID))
{
System.IO.Directory.CreateDirectory(MapPath(".") + "\\UserFiles\\" + Session["UserName"].ToString() + "\\AdSlider\\" + theID);
}
}
}
}
string YouTubeStr = "";
char[] delim3 = { '.' };
for (int i = 0; i < PictureCheckList.Items.Count; i++)
{
int length = fileArray[i].Split(delim2).Length;
string[] tokens = PictureCheckList.Items[i].Value.ToString().Split(delim3);
if (tokens.Length >= 2)
{
if (tokens[1].ToUpper() == "JPG" || tokens[1].ToUpper() == "JPEG" || tokens[1].ToUpper() == "GIF")
{
if (!System.IO.File.Exists(MapPath(".") + "\\UserFiles\\" + Session["UserName"].ToString() +
"\\AdSlider\\" + theID + "\\" + PictureCheckList.Items[i].Value))
{
System.IO.File.Copy(MapPath(".") + "\\UserFiles\\" + Session["UserName"].ToString() +
"\\AdSlider\\" + PictureCheckList.Items[i].Value,
MapPath(".") + "\\UserFiles\\" + Session["UserName"].ToString() +
"\\AdSlider\\" + theID + "\\" +
PictureCheckList.Items[i].Value);
}
cmd = new SqlCommand("INSERT INTO Ad_Slider_Mapping (AdID, PictureName, RealPictureName) " +
"VALUES (@eventID, @picName, @realName)", conn);
cmd.Parameters.Add("@eventID", SqlDbType.Int).Value = theID;
cmd.Parameters.Add("@picName", SqlDbType.NVarChar).Value = PictureCheckList.Items[i].Value;
cmd.Parameters.Add("@realName", SqlDbType.NVarChar).Value = PictureCheckList.Items[i].Text;
cmd.ExecuteNonQuery();
}
}
else
{
YouTubeStr += PictureCheckList.Items[i].Value + ";";
}
}
//if (YouTubeStr != "")
//{
dat.Execute("UPDATE Ads SET YouTubeVideo='" + YouTubeStr + "' WHERE Ad_ID=" + theID);
//}
}
}
else
{
}
if (isEdit)
{
dat.Execute("DELETE FROM Ad_Category_Mapping WHERE AdID="+theID);
}
CreateCategories(theID);
string views = dat.GetDataDV("SELECT NumViews - NumCurrentViews AS Views FROM Ads WHERE Ad_ID=" +
theID)[0]["Views"].ToString();
if (bool.Parse(isFeatured.Text) && int.Parse(views) != 0)
EmailSavedSearches(theID, views);
//if (CategoriesCheckBoxes.Items.Count > 0)
//{
// int catCount = CategoriesCheckBoxes.Items.Count;
// for (int i = 0; i < catCount; i++)
// {
// cmd = new SqlCommand("INSERT INTO Ad_Category_Mapping (AdID, CategoryID) VALUES (@adID, @catID)", conn);
// cmd.Parameters.Add("@adID", SqlDbType.Int).Value = ID;
// cmd.Parameters.Add("@catID", SqlDbType.Int).Value = int.Parse(CategoriesCheckBoxes.Items[i].Value);
// cmd.ExecuteNonQuery();
// }
//}
string adFeatured = "";
string adFeaturedEmail = "";
if (bool.Parse(isFeatured.Text))
{
adFeatured += "<br/><br/>Since you selected to have your ad Featured, you can view the progress of your ad on the <a class=\"AddLink\" onclick=\"Search('AdStatistics.aspx?Ad="+theID+"');\">Ad Statistics</a> page, which is also linkable from your user page.";
adFeaturedEmail += "<br/><br/>Since you selected to have your ad Featured, you can view the progress of your ad on the <a href=\"http://hippohappenings.com/AdStatistics.aspx?Ad="+theID+"\">Ad Statistics</a> page, which is also linkable from your user page.";
}
DataSet dsUser = dat.GetData("SELECT Email, UserName FROM USERS WHERE User_ID=" +
Session["User"].ToString());
string emailBody = "<br/><br/>Dear " + dsUser.Tables[0].Rows[0]["UserName"].ToString() + ", <br/><br/> you have successfully posted the ad \"" + AdNameTextBox.THE_TEXT +
"\". <br/><br/> You can find this ad <a href=\"http://hippohappenings.com/" + dat.MakeNiceName(AdNameTextBox.THE_TEXT)+"_" + theID + "_Ad\">here</a>. " + adFeaturedEmail +
"<br/><br/> To rate your experience posting this ad <a href=\"http://hippohappenings.com/RateExperience.aspx?Type=A&ID=" + theID + "\">please include your feedback here.</a>" +
"<br/><br/><br/>Have a Hippo Happening Day!<br/><br/>";
if (isEdit)
{
emailBody = "<br/><br/>Dear " + dsUser.Tables[0].Rows[0]["UserName"].ToString() + ", <br/><br/> you have successfully edited the ad \"" + AdNameTextBox.THE_TEXT +
"\". <br/><br/> You can find this ad <a href=\"http://hippohappenings.com/" + dat.MakeNiceName(AdNameTextBox.THE_TEXT) + "_" + theID + "_Ad\">here</a>. " + adFeaturedEmail +
"<br/><br/> To rate your experience editing this ad <a href=\"http://hippohappenings.com/RateExperience.aspx?Type=A&ID=" + theID + "\">please include your feedback here.</a>" +
"<br/><br/><br/>Have a Hippo Happening Day!<br/><br/>";
}
if (!Request.IsLocal)
{
dat.SendEmail(System.Configuration.ConfigurationManager.AppSettings["emailemail"].ToString(),
System.Configuration.ConfigurationManager.AppSettings["emailName"].ToString(),
dsUser.Tables[0].Rows[0]["Email"].ToString(), emailBody, "You have successfully posted the ad: " +
AdNameTextBox.THE_TEXT);
}
conn.Close();
dat.SendFriendPostedAdNotification(Session["User"].ToString(), theID);
Session["Message"] = "Your ad has been posted successfully!<br/> Here are your next steps: <br/>";
if (isEdit)
{
Session["Message"] = "Your ad has been edited successfully!<br/> Here are your next steps: <br/>";
}
CheckAllUsers(AdPlacementList.SelectedValue != "0.01", theID);
//Clear cache so that the PlayerList.xml can be grabbed by the browser again.
ClearCache();
Session["Message"] += "<br/>" + "Go to <a class=\"AddLink\" onclick=\"Search('" + dat.MakeNiceName(AdNameTextBox.THE_TEXT) + "_" + theID + "_Ad');\">your ad's</a> home page." + adFeatured + "<br/><br/> -<a class=\"AddLink\" onclick=\"Search('RateExperience.aspx?Type=A&ID=" + theID + "');\" >Rate </a>your user experience posting this venue.<br/>";
//MessageLiteral.Text = "<script type=\"text/javascript\">alert('" + message + "');</script>";
Encryption encrypt = new Encryption();
MessageRadWindow.NavigateUrl = "Message.aspx?message=" + encrypt.encrypt(Session["Message"].ToString() +
"<br/><img onclick=\"Search('Home.aspx');\" onmouseover=\"this.src='image/DoneSonButtonSelected.png'\" onmouseout=\"this.src='image/DoneSonButton.png'\" src=\"image/DoneSonButton.png\"/>");
MessageRadWindow.Visible = true;
MessageRadWindowManager.VisibleOnPageLoad = true;
Session["categorySession"] = null;
}
else
{
MessagePanel.Visible = true;
YourMessagesLabel.Text += "<br/><br/>You must agree to the terms and conditions.";
}
}
protected void PostIt(object sender, EventArgs e)
{
object appSeshCountry;
object appSeshState;
object appSeshCity;
object appSeshZip;
object appSeshRadius;
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 state = "";
AuthorizePayPal d = new AuthorizePayPal();
if (AgreeCheckBox.Checked)
{
bool chargeCard = false;
SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["Connection"].ToString());
conn.Open();
//Add case for if Paypal is filled in...
//Authorize Credit Card
decimal price = 0.00M;
bool goOn = false;
string message = "";
string transactionID = "";
if (FeaturePanel.Visible && TotalLabel.Text.Trim() != "")
{
if (decimal.TryParse(TotalLabel.Text.Trim(), out price))
{
if (price != 0.00M)
{
if (PaymentPanel.Visible)
{
if (FirstNameTextBox.Text.Trim() == "" || LastNameTextBoxtBox.Text.Trim() == "" ||
BillingStreetAddressTextBox.Text.Trim() == "" || BillingCityTextBox.Text.Trim() == "" ||
BillingZipCodeTextBox.Text.Trim() == "" || BillingStateTextBox.Text.Trim() == "" ||
CardNumberTextBox.Text.Trim() == "" || CSVTextBox.Text.Trim() == "")
{
goOn = false;
Session["Featured"] = false;
message = "Please fill in all of the billing information.";
}
else
{
goOn = false;
Session["Featured"] = false;
string country = dat.GetDataDV("SELECT country_2_code FROM Countries WHERE country_id=" + BillingCountry.SelectedValue)[0]["country_2_code"].ToString();
com.paypal.sdk.util.NVPCodec status = d.DoPayment("Authorization", TotalLabel.Text, CardTypeDropDown.SelectedValue, CardNumberTextBox.Text.Trim(),
ExpirationMonth.SelectedItem.Text, ExpirationYear.SelectedItem.Text, CSVTextBox.Text.Trim(), FirstNameTextBox.Text.Trim(), LastNameTextBoxtBox.Text.Trim(),
BillingStreetAddressTextBox.Text.Trim(), BillingCityTextBox.Text, BillingStateTextBox.Text, country, BillingZipCodeTextBox.Text.Trim(), dat.GetIP());
message = status.ToString();
string successORFailure = status["ACK"];
switch (successORFailure.ToLower())
{
case "failure":
goOn = false;
Session["Featured"] = false;
message = status["L_LONGMESSAGE0"];
break;
case "successwithwarning":
goOn = false;
Session["Featured"] = false;
message = status["L_SHORTMESSAGE0"];
if (message == "Transaction approved but with invalid CSC format.")
message = "Your CVC/CSV format for this card is not valid.";
break;
case "success":
transactionID = status["TRANSACTIONID"];
Session["TransID"] = transactionID;
goOn = true;
chargeCard = true;
Session["Featured"] = true;
break;
default:
goOn = false;
Session["Featured"] = false;
message = "There was an internal problem. Please contact support at: [email protected]. Please include as much detail as possible about what you are trying to do.";
foreach (string key in status.Keys)
{
message += "key: " + key.ToString() + ", value: " + status[key].ToString() + "<br/>";
}
break;
}
}
}
else
{
goOn = true;
Session["Featured"] = true;
}
}
else
{
if (SearchTermsListBox.Items.Count > 0 && price == 0.00M)
{
goOn = false;
Session["Featured"] = false;
message = "You have entered search terms, but, have not included any dates.";
}
else
{
goOn = true;
Session["Featured"] = false;
}
}
}
else
{
goOn = true;
Session["Featured"] = false;
}
}
else
{
goOn = true;
Session["Featured"] = false;
}
if (goOn)
{
bool isEdit = false;
DateTime LastFetUpdate = DateTime.Now;
if (Request.QueryString["edit"] != null)
{
isEdit = bool.Parse(Request.QueryString["edit"].ToString());
}
string mediaCat = "0";
if (PictureCheckList.Items.Count > 0)
mediaCat = "1";
string command = "";
DataSet dsEvent;
bool wasFeatured = false;
DataView dvRenu = new DataView();
if (isEdit)
{
dsEvent = dat.GetData("SELECT * FROM Ads WHERE Ad_ID=" + adID.Text);
wasFeatured = bool.Parse(dsEvent.Tables[0].Rows[0]["Featured"].ToString());
LastFetUpdate = DateTime.Parse(dsEvent.Tables[0].Rows[0]["LastFetUpdate"].ToString());
//numViews = int.Parse(dsEvent.Tables[0].Rows[0]["NumViews"].ToString());
string rad = "";
//if (RadiusPanel.Visible)
// rad = ", Radius=@radius ";
dvRenu = dat.GetDataDV("SELECT * FROM Ads WHERE Ad_ID=" + adID.Text);
command = "UPDATE Ads SET LastFetUpdate=@fetUpdate, DatesOfAd=@dates, Template=@template, hasSongs=@songs, User_ID=@userID, FeaturedSummary=@featuredSummary , " +
"Description=@description, Featured=@featured, Header=@header, CountShown=@countShown, mediaCategory=" + mediaCat + ", " +
"FeaturedPicture=@featuredPicture, FeaturedPictureName=@featuredPictureName, CatCountry=@catCountry, " +
"CatState=@catState, CatCity=@catCity WHERE Ad_ID=" + adID.Text;
}
else
{
string rad = "";
string radEnd = "";
//if (RadiusPanel.Visible)
//{
// rad = ", Radius ";
// radEnd = ", @radius ";
//}
command = "INSERT INTO Ads (LastFetUpdate, DatesOfAd, Template, hasSongs, User_ID, FeaturedSummary ,Description, Header, " +
"CountShown, Featured, mediaCategory, FeaturedPicture, FeaturedPictureName, CatCountry, CatState, CatCity, " +
" DateAdded) "
+ " VALUES('" + DateTime.Now.ToString() + "', @dates, @template, @songs, @userID, @featuredSummary, @description, @header, @countShown, " +
"@featured, " + mediaCat + ", @featuredPicture, @featuredPictureName, @catCountry, @catState, @catCity, '" +
DateTime.Now.ToString() + "')";
}
SqlCommand cmd = new SqlCommand(command, conn);
cmd.CommandType = CommandType.Text;
cmd.Parameters.Add("@description", SqlDbType.NVarChar).Value = DescriptionTextBox.Content;
cmd.Parameters.Add("@userID", SqlDbType.Int).Value = int.Parse(Session["User"].ToString());
string fetDays = "";
bool newDates = false;
foreach (ListItem item in FeatureDatesListBox.Items)
{
fetDays += ";" + item.Text + ";";
if (item.Value != "Disabled")
newDates = true;
}
if (wasFeatured)
{
if (newDates)
cmd.Parameters.Add("@fetUpdate", SqlDbType.DateTime).Value = DateTime.Now;
else
cmd.Parameters.Add("@fetUpdate", SqlDbType.DateTime).Value = LastFetUpdate;
cmd.Parameters.Add("@featured", SqlDbType.Bit).Value = true;
if (FeaturePanel.Visible)
{
cmd.Parameters.Add("@dates", SqlDbType.NVarChar).Value = fetDays;
}
else
cmd.Parameters.Add("@dates", SqlDbType.NVarChar).Value = dvRenu[0]["DatesOfAd"].ToString();
}
else
{
cmd.Parameters.Add("@fetUpdate", SqlDbType.DateTime).Value = DateTime.Now;
cmd.Parameters.Add("@featured", SqlDbType.Bit).Value = FeaturePanel.Visible;
if (FeaturePanel.Visible)
{
cmd.Parameters.Add("@dates", SqlDbType.NVarChar).Value = fetDays;
}
else
{
cmd.Parameters.Add("@dates", SqlDbType.NVarChar).Value = DBNull.Value;
}
}
if (FeaturePanel.Visible)
{
if (BannerAdCheckBox.Checked)
{
cmd.Parameters.Add("@template", SqlDbType.Int).Value = TemplateRadioList.SelectedValue;
}
else
{
cmd.Parameters.Add("@template", SqlDbType.Int).Value = 1;
}
}
else
{
if (wasFeatured)
cmd.Parameters.Add("@template", SqlDbType.Int).Value = dvRenu[0]["Template"].ToString();
else
cmd.Parameters.Add("@template", SqlDbType.Int).Value = DBNull.Value;
}
cmd.Parameters.Add("@songs", SqlDbType.Bit).Value = false;
if (FeaturePanel.Visible)
cmd.Parameters.Add("@featuredSummary", SqlDbType.NVarChar).Value = SummaryTextBox.InnerHtml;
else
{
if (wasFeatured)
cmd.Parameters.Add("@featuredSummary", SqlDbType.NVarChar).Value = dvRenu[0]["FeaturedSummary"].ToString();
else
cmd.Parameters.Add("@featuredSummary", SqlDbType.NVarChar).Value = DBNull.Value;
}
cmd.Parameters.Add("@header", SqlDbType.NVarChar).Value = AdNameTextBox.Text;
cmd.Parameters.Add("@countShown", SqlDbType.Int).Value = 0;
if (FeaturePanel.Visible)
if (AdPictureCheckList.Items.Count > 0 && AdMediaPanel.Visible)
{
cmd.Parameters.Add("@featuredPicture", SqlDbType.NVarChar).Value = AdPictureCheckList.Items[0].Value;
cmd.Parameters.Add("@featuredPictureName", SqlDbType.NVarChar).Value = AdPictureCheckList.Items[0].Text;
}
else
{
cmd.Parameters.Add("@featuredPicture", SqlDbType.NVarChar).Value = DBNull.Value;
cmd.Parameters.Add("@featuredPictureName", SqlDbType.NVarChar).Value = DBNull.Value;
}
else
{
if (wasFeatured)
{
cmd.Parameters.Add("@featuredPicture", SqlDbType.NVarChar).Value = dvRenu[0]["FeaturedPicture"].ToString();
cmd.Parameters.Add("@featuredPictureName", SqlDbType.NVarChar).Value = dvRenu[0]["FeaturedPictureName"].ToString();
}
else
{
cmd.Parameters.Add("@featuredPicture", SqlDbType.NVarChar).Value = DBNull.Value;
cmd.Parameters.Add("@featuredPictureName", SqlDbType.NVarChar).Value = DBNull.Value;
}
}
if (CountryDropDown.SelectedIndex != -1)
{
appSeshCountry = CountryDropDown.SelectedValue;
cmd.Parameters.Add("@catCountry", SqlDbType.Int).Value = CountryDropDown.SelectedValue;
if (StateDropDownPanel.Visible)
{
if (StateDropDown.SelectedIndex != -1)
state = StateDropDown.SelectedItem.Text;
}
else
state = StateTextBox.Text;
appSeshState = state;
if (state != "")
cmd.Parameters.Add("@catState", SqlDbType.NVarChar).Value = state;
else
cmd.Parameters.Add("@catState", SqlDbType.NVarChar).Value = DBNull.Value;
string city = "";
if (CityDropDownPanel.Visible)
city = MajorCityDrop.SelectedItem.Text;
else
city = CityTextBox.Text;
appSeshCity = city;
cmd.Parameters.Add("@catCity", SqlDbType.NVarChar).Value = city;
}
else
{
cmd.Parameters.Add("@catCountry", SqlDbType.Int).Value = DBNull.Value;
cmd.Parameters.Add("@catState", SqlDbType.NVarChar).Value = DBNull.Value;
cmd.Parameters.Add("@catCity", SqlDbType.NVarChar).Value = DBNull.Value;
}
//Media Categories: NONE: 0, Slider: 1.
bool isSlider = false;
if (PictureCheckList.Items.Count > 0)
isSlider = true;
cmd.ExecuteNonQuery();
cmd = new SqlCommand("SELECT @@IDENTITY AS ID", conn);
SqlDataAdapter da2 = new SqlDataAdapter(cmd);
DataSet ds3 = new DataSet();
da2.Fill(ds3);
string ID = ds3.Tables[0].Rows[0]["ID"].ToString();
if (isEdit)
ID = Request.QueryString["ID"].ToString();
#region Take care of search terms
if (FeaturePanel.Visible)
{
string terms = "";
foreach (ListItem item in SearchTermsListBox.Items)
{
terms += ";" + item.Text + ";";
}
foreach (ListItem item in FeatureDatesListBox.Items)
{
if (item.Value != "Disabled")
dat.Execute("INSERT INTO AdSearchTerms (AdID, SearchTerms, SearchDate) VALUES(" + ID +
", '" + terms.Replace("'", "''") + "', '" + item.Text + "')");
}
}
#endregion
string theID = ID;
if (isEdit)
{
theID = adID.Text;
}
//if (MusicCheckBox.Checked)
//{
// if (isEdit)
// {
// dat.Execute("DELETE FROM Ad_Song_Mapping WHERE AdID="+theID);
// }
// for (int i = 0; i < SongCheckList.Items.Count; i++)
// {
// cmd = new SqlCommand("INSERT INTO Ad_Song_Mapping (AdID, SongName, SongTitle) "+
// "VALUES(@eventID, @songName, @songTitle)", conn);
// cmd.Parameters.Add("@eventID", SqlDbType.Int).Value = int.Parse(theID);
// cmd.Parameters.Add("@songName", SqlDbType.NVarChar).Value = SongCheckList.Items[i].Value.ToString();
// cmd.Parameters.Add("@songTitle", SqlDbType.NVarChar).Value = SongCheckList.Items[i].Text;
// cmd.ExecuteNonQuery();
// dat.Execute("UPDATE Ads SET hasSongs=1 WHERE Ad_ID="+theID);
// }
//}
if (isEdit)
{
dat.Execute("DELETE FROM Ad_Slider_Mapping WHERE AdID=" + theID);
}
if (MainAttractionCheck.Checked)
{
if (isSlider)
{
char[] delim2 = { '\\' };
string[] fileArray = System.IO.Directory.GetFiles(MapPath(".") + "\\UserFiles\\" +
Session["UserName"].ToString() + "\\AdSlider\\");
if (!System.IO.Directory.Exists(MapPath(".") + "\\UserFiles"))
{
System.IO.Directory.CreateDirectory(MapPath(".") + "\\UserFiles");
System.IO.Directory.CreateDirectory(MapPath(".") + "\\UserFiles\\" + Session["UserName"].ToString() + "\\");
System.IO.Directory.CreateDirectory(MapPath(".") + "\\UserFiles\\" + Session["UserName"].ToString() + "\\AdSlider");
System.IO.Directory.CreateDirectory(MapPath(".") + "\\UserFiles\\" + Session["UserName"].ToString() + "\\AdSlider\\" + theID);
}
else
{
if (!System.IO.Directory.Exists(MapPath(".") + "\\UserFiles\\" + Session["UserName"].ToString() + "\\"))
{
System.IO.Directory.CreateDirectory(MapPath(".") + "\\UserFiles\\" + Session["UserName"].ToString() + "\\");
System.IO.Directory.CreateDirectory(MapPath(".") + "\\UserFiles\\" + Session["UserName"].ToString() + "\\AdSlider");
System.IO.Directory.CreateDirectory(MapPath(".") + "\\UserFiles\\" + Session["UserName"].ToString() + "\\" + theID);
}
else
{
if (!System.IO.Directory.Exists(MapPath(".") + "\\UserFiles\\" + Session["UserName"].ToString() + "\\AdSlider"))
{
System.IO.Directory.CreateDirectory(MapPath(".") + "\\UserFiles\\" + Session["UserName"].ToString() + "\\AdSlider");
System.IO.Directory.CreateDirectory(MapPath(".") + "\\UserFiles\\" + Session["UserName"].ToString() + "\\AdSlider\\" + theID);
}
else
{
if (!System.IO.Directory.Exists(MapPath(".") + "\\UserFiles\\" + Session["UserName"].ToString() + "\\AdSlider\\" + theID))
{
System.IO.Directory.CreateDirectory(MapPath(".") + "\\UserFiles\\" + Session["UserName"].ToString() + "\\AdSlider\\" + theID);
}
}
}
}
string YouTubeStr = "";
char[] delim3 = { '.' };
for (int i = 0; i < PictureCheckList.Items.Count; i++)
{
int length = fileArray[i].Split(delim2).Length;
string[] tokens = PictureCheckList.Items[i].Value.ToString().Split(delim3);
if (tokens.Length >= 2)
{
if (tokens[1].ToUpper() == "JPG" || tokens[1].ToUpper() == "JPEG" || tokens[1].ToUpper() == "GIF" || tokens[1].ToUpper() == "PNG")
{
if (!System.IO.File.Exists(MapPath(".") + "\\UserFiles\\" + Session["UserName"].ToString() +
"\\AdSlider\\" + theID + "\\" + PictureCheckList.Items[i].Value))
{
System.IO.File.Copy(MapPath(".") + "\\UserFiles\\" + Session["UserName"].ToString() +
"\\AdSlider\\" + PictureCheckList.Items[i].Value,
MapPath(".") + "\\UserFiles\\" + Session["UserName"].ToString() +
"\\AdSlider\\" + theID + "\\" +
PictureCheckList.Items[i].Value);
}
cmd = new SqlCommand("INSERT INTO Ad_Slider_Mapping (AdID, PictureName, RealPictureName) " +
"VALUES (@eventID, @picName, @realName)", conn);
cmd.Parameters.Add("@eventID", SqlDbType.Int).Value = theID;
cmd.Parameters.Add("@picName", SqlDbType.NVarChar).Value = PictureCheckList.Items[i].Value;
cmd.Parameters.Add("@realName", SqlDbType.NVarChar).Value = PictureCheckList.Items[i].Text;
cmd.ExecuteNonQuery();
}
}
else
{
YouTubeStr += PictureCheckList.Items[i].Value + ";";
}
}
//if (YouTubeStr != "")
//{
dat.Execute("UPDATE Ads SET YouTubeVideo='" + YouTubeStr + "' WHERE Ad_ID=" + theID);
//}
}
}
else
{
}
if (isEdit)
{
dat.Execute("DELETE FROM Ad_Category_Mapping WHERE AdID=" + theID);
}
CreateCategories(theID);
string adFeatured = "";
string adFeaturedEmail = "";
DataSet dsUser = dat.GetData("SELECT Email, UserName FROM USERS WHERE User_ID=" +
Session["User"].ToString());
try
{
bool showMessage = false;
if (chargeCard)
{
Encryption encrypt = new Encryption();
//Charge Card
string country = dat.GetDataDV("SELECT country_2_code FROM Countries WHERE country_id=" + BillingCountry.SelectedValue)[0]["country_2_code"].ToString();
com.paypal.sdk.util.NVPCodec status = d.DoCaptureCode(transactionID, price.ToString(),
"B" + theID + isn.ToString(), "Capture Transaction for Featuring Bulletin '" +
dat.MakeNiceNameFull(AdNameTextBox.Text) + "'");
//message = status.ToString();
string successORFailure = status["ACK"];
switch (successORFailure.ToLower())
{
case "failure":
MessagePanel.Visible = true;
YourMessagesLabel.Text += status["L_LONGMESSAGE0"];
//MessagePanel.Visible = true;
//foreach (string key in status.Keys)
//{
// YourMessagesLabel.Text += "key: '" + key + "', value: '" + status[key] + "' <br/>";
//}
break;
case "success":
showMessage = true;
break;
default:
MessagePanel.Visible = true;
foreach (string key in status.Keys)
{
YourMessagesLabel.Text += "key: '" + key + "', value: '" + status[key] + "' <br/>";
}
break;
}
}
else
{
showMessage = true;
}
if (showMessage)
{
string emailBody = "Dear " + dsUser.Tables[0].Rows[0]["UserName"].ToString() + ", <br/><br/> you have successfully posted the bulletin \"" + AdNameTextBox.Text +
"\". <br/><br/> You can find this bulletin <a href=\"http://hippohappenings.com/" + dat.MakeNiceName(AdNameTextBox.Text) + "_" + theID + "_Ad\">here</a>. " + adFeaturedEmail +
"<br/><br/> To rate your experience posting this bulletin <a href=\"http://hippohappenings.com/RateExperience.aspx?Type=A&ID=" + theID + "\">please include your feedback here.</a>" +
"<br/><br/><br/>Have a HippoHappening Day!<br/><br/>";
if (isEdit)
{
emailBody = "Dear " + dsUser.Tables[0].Rows[0]["UserName"].ToString() + ", <br/><br/> you have successfully edited the bulletin \"" + AdNameTextBox.Text +
"\". <br/><br/> You can find this bulletin <a href=\"http://hippohappenings.com/" + dat.MakeNiceName(AdNameTextBox.Text) + "_" + theID + "_Ad\">here</a>. " + adFeaturedEmail +
"<br/><br/> To rate your experience editing this bulletin <a href=\"http://hippohappenings.com/RateExperience.aspx?Type=A&ID=" + theID + "\">please include your feedback here.</a>" +
"<br/><br/><br/>Have a HippoHappening Day!<br/><br/>";
}
if (!Request.IsLocal)
{
dat.SendEmail(System.Configuration.ConfigurationManager.AppSettings["emailemail"].ToString(),
System.Configuration.ConfigurationManager.AppSettings["emailName"].ToString(),
dsUser.Tables[0].Rows[0]["Email"].ToString(), emailBody, "You have successfully posted the bulletin: " +
AdNameTextBox.Text);
}
conn.Close();
Session["Message"] = "Your bulletin has been posted successfully!<br/> Here are your next steps: <br/>";
if (isEdit)
{
Session["Message"] = "Your bulletin has been edited successfully!<br/> Here are your next steps: <br/>";
}
//Clear cache so that the PlayerList.xml can be grabbed by the browser again.
ClearCache();
Session["Message"] += "<br/>" + "Go to <a class=\"AddLink\" onclick=\"Search('" + dat.MakeNiceName(AdNameTextBox.Text) + "_" + theID + "_Ad');\">your bulletin's</a> home page." + adFeatured + "<br/><br/> -<a class=\"AddLink\" onclick=\"Search('RateExperience.aspx?Type=A&ID=" + theID + "');\" >Rate </a>your user experience posting this bulletin.<br/>";
//MessageLiteral.Text = "<script type=\"text/javascript\">alert('" + message + "');</script>";
Encryption encrypt = new Encryption();
MessageRadWindow.NavigateUrl = "Message.aspx?message=" + encrypt.encrypt(Session["Message"].ToString() +
"<br/><br/><div align=\"center\">" +
"<div style=\"width: 50px;\" onclick=\"Search('home')\">" +
"<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;\">" +
" OK " +
"</div>" +
" <img style=\"float: left;\" src=\"NewImages/ButtonRight.png\" height=\"27px\" /> " +
"</div>" +
"</div>" +
"</div><br/>");
MessageRadWindow.Visible = true;
MessageRadWindowManager.VisibleOnPageLoad = true;
Session["categorySession"] = null;
}
}
catch (Exception ex)
{
MessagePanel.Visible = true;
YourMessagesLabel.Text += ex.ToString();
}
}
else
{
MessagePanel.Visible = true;
YourMessagesLabel.Text = message;
}
}
else
{
MessagePanel.Visible = true;
YourMessagesLabel.Text += "You must agree to the terms and conditions.";
}
}
protected bool OnwardsIT(bool changeTab, int selectedIndex)
{
HttpCookie cookie = Request.Cookies["BrowserDate"];
Data dat = new Data(DateTime.Parse(cookie.Value.ToString().Replace("%20", " ").Replace("%3A", ":")));
SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["Connection"].ToString());
conn.Open();
switch (selectedIndex)
{
case 0:
#region Case 0
bool goOn = false;
bool isInternational = false;
string locationStr = "";
VenueNameTextBox.THE_TEXT = dat.stripHTML(VenueNameTextBox.THE_TEXT);
CityTextBox.Text = dat.stripHTML(CityTextBox.Text);
ZipTextBox.Text = dat.stripHTML(ZipTextBox.Text);
if (CountryDropDown.SelectedValue == "223")
{
isInternational = true;
string apt = "";
if(AptNumberTextBox.Text.Trim() != "")
apt = AptDropDown.SelectedItem.Text + " " + AptNumberTextBox.Text.Trim().ToLower();
locationStr = StreetNumberTextBox.Text.Trim().ToLower() + ";" + StreetNameTextBox.Text.Trim().ToLower()
+ ";" + StreetDropDown.SelectedItem.Text + ";" + apt;
goOn = VenueNameTextBox.THE_TEXT.Trim() != "" && StreetNumberTextBox.Text.Trim() != ""
&& StreetNameTextBox.Text.Trim() != "" && StreetDropDown.SelectedItem.Text != "Select One..."
&& CityTextBox.Text.Trim() != ""
&& ZipTextBox.Text.Trim() != "";
}
else
{
string apt = "";
if (AptNumberTextBox.Text.Trim() != "")
apt = AptDropDown.SelectedItem.Text + " " + AptNumberTextBox.Text.Trim().ToLower();
locationStr = LocationTextBox.Text.Trim().ToLower() + ";" + apt;
goOn = VenueNameTextBox.THE_TEXT.Trim() != "" && LocationTextBox.Text.Trim() != "" &&
CityTextBox.Text.Trim() != "" && ZipTextBox.Text.Trim() != "";
}
if (goOn)
{
bool isUpdate = false;
if (Request.QueryString["ID"] != null)
{
isUpdate = true;
}
if (EmailTextBox.Text.Trim() != "")
{
if (!dat.ValidateEmail(EmailTextBox.Text))
{
MessagePanel.Visible = true;
YourMessagesLabel.Text += "<br/><br/>*Email address is not in the appropriate format.";
goOn = false;
}
}
if (CountryDropDown.SelectedValue == "223")
{
int zip = 0;
if (int.TryParse(ZipTextBox.Text.Trim(), out zip))
{
if (ZipTextBox.Text.Trim().Length == 5)
{
}
else
{
MessagePanel.Visible = true;
YourMessagesLabel.Text += "<br/><br/>*Zip must be a 5 digit code.";
goOn = false;
}
}
else
{
MessagePanel.Visible = true;
YourMessagesLabel.Text += "<br/><br/>*Zip must be a 5 digit code.";
goOn = false;
}
}
if (StateDropDown.Visible)
{
if (StateDropDown.SelectedIndex == -1)
{
MessagePanel.Visible = true;
YourMessagesLabel.Text += "<br/><br/>*Must include state.";
goOn = false;
}
}
else
{
if (StateTextBox.THE_TEXT.Trim() == "")
{
MessagePanel.Visible = true;
YourMessagesLabel.Text += "<br/><br/>*Must include state.";
goOn = false;
}
}
if (!isUpdate && goOn)
{
string state = "";
if (StateDropDownPanel.Visible)
state = StateDropDown.SelectedItem.Text;
else
state = StateTextBox.THE_TEXT;
SqlCommand cmd = new SqlCommand("SELECT * FROM Venues WHERE Address=@address AND City=@city AND State=@state", conn);
cmd.Parameters.Add("@address", SqlDbType.NVarChar).Value = locationStr;
cmd.Parameters.Add("@city", SqlDbType.NVarChar).Value = CityTextBox.Text.Trim().ToLower();
cmd.Parameters.Add("@state", SqlDbType.NVarChar).Value = state;
DataSet ds = new DataSet();
SqlDataAdapter da = new SqlDataAdapter(cmd);
da.Fill(ds);
if (ds.Tables.Count > 0)
if (ds.Tables[0].Rows.Count > 0)
{
MessagePanel.Visible = true;
YourMessagesLabel.Text += "<br/><br/>A venue already exists under this address. " +
"Please take a look at it " +
"<a target=\"_blank\" class=\"AddGreenLink\" href=\"" + dat.MakeNiceName(VenueNameTextBox.THE_TEXT) + "_" +
ds.Tables[0].Rows[0]["ID"].ToString() + "_Venue\">here.</a> You can submit edits to the existing venue by licking on the 'Edit Venue' link at the top of the venue page.";
goOn = false;
}
}
if (goOn)
{
if(changeTab)
ChangeSelectedTab(0, 1);
FillLiteral();
return true;
}
else
{
return false;
}
}
else
{
MessagePanel.Visible = true;
YourMessagesLabel.Text += "<br/><br/>*Please fill in all fields.";
}
return false;
#endregion
break;
case 1:
DescriptionTextBox.Content = dat.StripHTML_LeaveLinks(DescriptionTextBox.Content.Replace("<div>", "<br/>").Replace("</div>", ""));
if (DescriptionTextBox.Text.Length >= 50)
{
if(changeTab)
ChangeSelectedTab(1, 2);
FillLiteral();
return true;
}
else
{
MessagePanel.Visible = true;
YourMessagesLabel.Text += "<br/><br/>*Make sure you say what you want your viewers to hear about this venue! The description must be at least 50 characters.";
return false;
}
break;
case 2:
if(Session["CategoriesSet"] == null && Request.QueryString["ID"] != null)
SetCategories();
if (changeTab)
{
ChangeSelectedTab(2, 3);
}
FillLiteral();
return true;
break;
case 3:
if (CategorySelected())
{
FillLiteral();
bool isownerupforgrabs = false;
EnableOwnerPanel(ref isownerupforgrabs);
if(changeTab)
ChangeSelectedTab(3, 4);
return true;
}
else
{
MessagePanel.Visible = true;
YourMessagesLabel.Text = "Must include at least one category.";
return false;
}
break;
default: break;
}
return false;
}
protected void Page_Load(object sender, EventArgs e)
{
HttpCookie cookie = Request.Cookies["BrowserDate"];
Data dat = new Data(DateTime.Parse(cookie.Value.ToString().Replace("%20", " ").Replace("%3A", ":")));
if (IsPostBack)
{
MessageRadWindowManager.VisibleOnPageLoad = false;
}
//take care of mapping to the search map
if (searchNumber != "")
{
string markerNumber = dat.GetImageNum(searchNumber); // (int.Parse(dat.GetImageNum(searchNumber)) + numofallresults).ToString();
ImageLiteral.Text = imageLiteral + "<div style=\"float: left;\"><img style=\"cursor: pointer;\" onclick=\"selectFirstTab();myclick(" + markerNumber + ");\" id='image" + searchNumber + "' src=" +
"\"http://www.google.com/mapfiles/marker" + searchNumber + ".png\" /></div>";
//SearchLiteral.Text += "<script type=\"text/javascript\">var letter = String.fromCharCode(\"A\".charCodeAt(0) + " +
// searchNumber + "); var letteredIcon = new GIcon(baseIcon); document.getElementById('image" + searchNumber +
// "').src = \"http://www.google.com/mapfiles/marker\" + letter + \".png\";</script>";
BeginingLiteral.Text = "<div style=\"margin-bottom: 3px;background-color:" +
color + "; width: " + width.ToString() + "px; min-height: 33px; padding: 3px;\">";
}
else
{
BeginingLiteral.Text = "<div style=\"margin-bottom: 3px;background-color:" + color + "; width: " + width.ToString() + "px;padding: 3px;\">";
}
if (calendarLetter != "")
{
ImageLiteral.Text += "<div onclick=\"selectCalendarDate('"+firstDate+"', '"+toolTipID+"');\" align=\"center\" style=\"cursor: pointer;margin-right: 3px;margin-left: 5px; margin-top: 6px;font-weight: bold;width: 20px; height: 14px;color: #1b1b1b;font-size: " +
"10px; padding-top: 6px;float: left; background-image: url(images/CalendarIcon.png);" +
"\">" + calendarLetter + "</div>";
}
if (isGroup)
{
ImageLiteral.Text += "<div style=\"float: left; height: 30px; margin-top: -4px\"><img height=\"40px\" title=\"Group Event\" " +
"name=\"Group Event\" src=\"images/GroupsIcon2.png\" /></div>";
}
//search = true is disabled here
SearchLabel.Text = searchLabel;
if (venueLabel.Trim() != "")
VenueLabel.Text = venueLabel;
else
{
VenueRealLabel.Text = address;
VenueRealLabel.Style.Add("color", "#cccccc");
VenueRealLabel.Style.Add("font-weight", "normal");
VenueRealLabel.Style.Add("pointer", "default");
VenueRealLabel.Style.Add("font-family", "Arial");
VenueRealLabel.Style.Add("font-size", "12px");
}
if (windowT)
{
if (isGroup)
SearchLabel.Attributes.Add("onclick", "CloseWindow('" + "../" +
dat.MakeNiceName(searchLabel) + "_" + reoccurrID + "_" + eventID + "_GroupEvent" + "');");
else
SearchLabel.Attributes.Add("onclick", "CloseWindow('" + "../" +
dat.MakeNiceName(searchLabel) + "_" + eventID + "_Event" + "');");
if (venueLabel.Trim() != "")
VenueLabel.Attributes.Add("onclick", "CloseWindow('" + "../" +
dat.MakeNiceName(venueLabel) + "_" + venueID + "_Venue" + "');");
}
else
{
if (isGroup)
SearchLabel.NavigateUrl = "../" + dat.MakeNiceName(searchLabel) + "_" +
reoccurrID + "_" + eventID + "_GroupEvent";
else
SearchLabel.NavigateUrl = "../" + dat.MakeNiceName(searchLabel) + "_" + eventID + "_Event";
if (venueLabel.Trim() != "")
VenueLabel.NavigateUrl = "../" + dat.MakeNiceName(venueLabel) +
"_" + venueID + "_Venue";
}
//if(numLabel != "")
// NumLabel.Text = numLabel;
DateLabel.Text = datelabel;
string begining = "<a style=\"color: #b1a812; font-family: Arial; font-size: 11px;\">";
string end = "</a>";
string tags = "";
if (isGroup)
{
dat.TAG_TYPE = Data.tagType.GROUP_EVENT;
DataSet ds1 = dat.GetData("SELECT DISTINCT C.ID, C.GroupName AS CategoryName, '22px' AS tagSize FROM GroupEvent_Category VC, GroupCategories C WHERE C.ID=VC.CATEGORY_ID AND VC.GROUPEVENT_ID=" + eventID);
tags = dat.getTags(ds1, false, windowT);
}
else
{
dat.TAG_TYPE = Data.tagType.EVENT;
tags = dat.getTags(dat.GetData("SELECT C.ID, C.Name AS CategoryName, ECM.tagSize FROM Event_Category_Mapping ECM, EventCategories C WHERE ECM.CategoryID=C.ID AND ECM.EventID=" + eventID), false, windowT);
DataSet ds = dat.GetData("SELECT ShortDescription FROM Events WHERE ID=" + eventID);
//ShortDescriptionLabel.Text = dat.BreakUpString(ds.Tables[0].Rows[0]["ShortDescription"].ToString(), 300);
}
//if (Session["User"] != null && !isGroup)
//{
// dat.GetRecommendationIcons(eventID.ToString(), ref RecomPanel);
//}
TagsLiteral.Text = "<span style=\"color: #b1a812; line-height: 10px; font-size: 11px;\" >" + tags + "</span>";
if (isConnectTo)
{
ConnectImageButton.Visible = true;
}
}
