//===============================================================
// Function: imagesRepeater_ItemCommand
//===============================================================
protected void imagesRepeater_ItemCommand(object sender, RepeaterCommandEventArgs e)
{
int eventID = int.Parse(Request.QueryString["EID"]);
int eventPictureID = int.Parse(e.CommandArgument.ToString());
if (e.CommandName == "deleteButton")
{
SedogoEvent sedogoEvent = new SedogoEvent((string)Session["loggedInUserFullName"], eventID);
sedogoEvent.Update();
SedogoEventPicture eventPic = new SedogoEventPicture((string)Application["connectionString"], eventPictureID);
eventPic.Delete();
Response.Redirect("editEventPics.aspx?EID=" + eventID.ToString());
}
if (e.CommandName == "saveButton")
{
SedogoEvent sedogoEvent = new SedogoEvent((string)Session["loggedInUserFullName"], eventID);
sedogoEvent.Update();
SedogoEventPicture eventPic = new SedogoEventPicture((string)Application["connectionString"], eventPictureID);
TextBox imageCaptionTextBox = e.Item.FindControl("imageCaptionTextBox") as TextBox;
eventPic.caption = imageCaptionTextBox.Text;
eventPic.Update();
Response.Redirect("editEventPics.aspx?EID=" + eventID.ToString());
}
}
//===============================================================
// Function: Page_Load
//===============================================================
protected void Page_Load(object sender, EventArgs e)
{
int eventID = int.Parse(Request.QueryString["EID"]);
int messageUserID = -1;
if (Request.QueryString["UID"] != null)
{
messageUserID = int.Parse(Request.QueryString["UID"]);
}
if (!IsPostBack)
{
SedogoEvent sedogoEvent = new SedogoEvent(Session["loggedInUserFullName"].ToString(), eventID);
eventNameLabel.Text = sedogoEvent.eventName;
SetFocus(messageTextBox);
if (Session["SendMessageCaptcha"] == null || (string)Session["SendMessageCaptcha"] == "N")
{
registerCaptcha.Visible = true;
}
else
{
registerCaptcha.Visible = false;
}
}
PopulateTrackingList(eventID, messageUserID);
}
//===============================================================
// Function: Page_Load
//===============================================================
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
int eventID = int.Parse(Request.QueryString["EID"]);
int userID = int.Parse(Session["loggedInUserID"].ToString());
SedogoEvent sedogoEvent = new SedogoEvent(Session["loggedInUserFullName"].ToString(), eventID);
eventNameLabel.Text = sedogoEvent.eventName;
SedogoUser eventOwner = new SedogoUser(Session["loggedInUserFullName"].ToString(), sedogoEvent.userID);
string dateString = "";
DateTime startDate = sedogoEvent.startDate;
MiscUtils.GetDateStringStartDate(eventOwner, sedogoEvent.dateType, sedogoEvent.rangeStartDate,
sedogoEvent.rangeEndDate, sedogoEvent.beforeBirthday, ref dateString, ref startDate);
messageToLabel.Text = eventOwner.firstName + " " + eventOwner.lastName;
eventDateLabel.Text = dateString;
eventVenueLabel.Text = sedogoEvent.eventVenue.Replace("\n", "<br/>");
SetFocus(messageTextBox);
if (Session["SendMessageCaptcha"] == null || (string)Session["SendMessageCaptcha"] == "N")
{
registerCaptcha.Visible = true;
}
else
{
registerCaptcha.Visible = false;
}
}
}
//===============================================================
// Function: Page_Load
//===============================================================
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
int eventID = int.Parse(Request.QueryString["EID"]);
SedogoEvent sedogoEvent = new SedogoEvent(Session["loggedInUserFullName"].ToString(), eventID);
eventNameLabel.Text = sedogoEvent.eventName;
SedogoUser eventOwner = new SedogoUser(Session["loggedInUserFullName"].ToString(), sedogoEvent.userID);
string dateString = "";
DateTime startDate = sedogoEvent.startDate;
MiscUtils.GetDateStringStartDate(eventOwner, sedogoEvent.dateType, sedogoEvent.rangeStartDate,
sedogoEvent.rangeEndDate, sedogoEvent.beforeBirthday, ref dateString, ref startDate);
eventDateLabel.Text = dateString;
eventVenueLabel.Text = sedogoEvent.eventVenue.Replace("\n", "<br/>");
deleteImageButton.Attributes.Add("onclick", "if(confirm('Are you sure you want to delete this picture?')){}else{return false}");
if (sedogoEvent.eventPicFilename == "")
{
deleteImageButton.Visible = false;
}
SetFocus(eventPicFileUpload);
}
}
//===============================================================
// Function: Page_Load
//===============================================================
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
int eventID = -1;
if (Request.QueryString["EID"] != null)
{
eventID = int.Parse(Request.QueryString["EID"]);
}
int messageToUserID = int.Parse(Request.QueryString["UID"]);
int parentMessageID = -1;
if (Request.QueryString["PMID"] != null)
{
parentMessageID = int.Parse(Request.QueryString["PMID"]);
}
int messageID = -1;
if (Request.QueryString["MID"] != null)
{
messageID = int.Parse(Request.QueryString["MID"]);
}
if (int.Parse(Session["loggedInUserID"].ToString()) == messageToUserID)
{
messageToUserID = Message.GetAltEmailUserID(parentMessageID, messageToUserID);
}
if( eventID > 0 )
{
goalNameDiv.Visible = true;
try
{
SedogoEvent sedogoEvent = new SedogoEvent(Session["loggedInUserFullName"].ToString(), eventID);
eventNameLabel.Text = sedogoEvent.eventName;
}
catch
{
eventNameLabel.Text = "";
}
}
else
{
goalNameDiv.Visible = false;
}
SedogoUser messageToUser = new SedogoUser(Session["loggedInUserFullName"].ToString(), messageToUserID);
messageToLabel.Text = messageToUser.firstName + " " + messageToUser.lastName;
SetFocus(messageTextBox);
if (Session["SendMessageCaptcha"] == null || (string)Session["SendMessageCaptcha"] == "N")
{
registerCaptcha.Visible = true;
}
else
{
registerCaptcha.Visible = false;
}
}
}
//===============================================================
// Function: Page_Load
//===============================================================
protected void Page_Load(object sender, EventArgs e)
{
int eventID = int.Parse(Request.QueryString["EID"]);
SedogoEvent sedogoEvent = new SedogoEvent(Session["loggedInUserFullName"].ToString(), eventID);
eventNameLabel.Text = sedogoEvent.eventName;
}
//===============================================================
// Function: saveButton_Click
//===============================================================
protected void saveButton_Click(object sender, EventArgs e)
{
int eventID = int.Parse(Request.QueryString["EID"]);
SedogoEvent sedogoEvent = new SedogoEvent(Session["loggedInAdministratorName"].ToString(),
eventID);
sedogoEvent.showOnDefaultPage = showOnDefaultPageCheckbox.Checked;
sedogoEvent.Update();
}
//===============================================================
// Function: Page_Load
//===============================================================
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
int eventID = int.Parse(Request.QueryString["EID"]);
SedogoEvent sedogoEvent = new SedogoEvent("", eventID);
SedogoUser eventOwner = new SedogoUser("", sedogoEvent.userID);
int userID = -1;
if (Session["loggedInUserID"] != null)
{
userID = int.Parse(Session["loggedInUserID"].ToString());
}
sidebarControl.userID = userID;
string currentUserFullName = "";
if (userID > 0)
{
SedogoUser user = new SedogoUser("", userID);
sidebarControl.user = user;
bannerAddFindControl.userID = userID;
currentUserFullName = user.firstName + " " + user.lastName;
addressBookLink1.Visible = true;
addressBookLink2.Visible = true;
addressBookLink3.Visible = true;
addressBookLink4.Visible = true;
addressBookLink5.Visible = true;
}
else
{
addressBookLink1.Visible = false;
addressBookLink2.Visible = false;
addressBookLink3.Visible = false;
addressBookLink4.Visible = false;
addressBookLink5.Visible = false;
}
string dateString = "";
DateTime startDate = sedogoEvent.startDate;
MiscUtils.GetDateStringStartDate(eventOwner, sedogoEvent.dateType, sedogoEvent.rangeStartDate,
sedogoEvent.rangeEndDate, sedogoEvent.beforeBirthday, ref dateString, ref startDate);
additionalInviteTextTextBox.Text = currentUserFullName + " thought you might be interested in this.";
eventTitleLabel.Text = sedogoEvent.eventName;
eventOwnersNameLabel.Text = eventOwner.firstName + " " + eventOwner.lastName;
eventDateLabel.Text = dateString;
eventDescriptionLabel.Text = sedogoEvent.eventDescription.Replace("\n", "<br/>");
eventNameLabel.Text = sedogoEvent.eventName;
goalNameLabel.Text = sedogoEvent.eventName;
goalVenueLabel.Text = sedogoEvent.eventVenue;
editedDateLabel.Text = sedogoEvent.lastUpdatedDate.ToString("dd MMMM yyyy");
}
}
//===============================================================
// Function: deleteImageButton_click
//===============================================================
protected void deleteImageButton_click(object sender, EventArgs e)
{
int eventID = int.Parse(Request.QueryString["EID"]);
SedogoEvent sedogoEvent = new SedogoEvent(Session["loggedInUserFullName"].ToString(), eventID);
sedogoEvent.eventPicFilename = "";
sedogoEvent.eventPicPreview = "";
sedogoEvent.eventPicThumbnail = "";
sedogoEvent.UpdateEventPic();
Response.Redirect("viewEvent.aspx?EID=" + eventID.ToString());
}
//===============================================================
// Function: Page_Load
//===============================================================
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
int eventID = int.Parse(Request.QueryString["EID"]);
SedogoEvent sedogoEvent = new SedogoEvent(Session["loggedInAdministratorName"].ToString(),
eventID);
eventNameLabel.Text = sedogoEvent.eventName;
showOnDefaultPageCheckbox.Checked = sedogoEvent.showOnDefaultPage;
}
}
//===============================================================
// Function: achievedEventsRepeater_ItemDataBound
//===============================================================
protected void achievedEventsRepeater_ItemDataBound(object sender, RepeaterItemEventArgs e)
{
if (e.Item.DataItem != null &&
(e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem))
{
DataRowView row = e.Item.DataItem as DataRowView;
int eventID = int.Parse(row["EventID"].ToString());
SedogoEvent sedogoEvent = new SedogoEvent(Session["loggedInUserFullName"].ToString(), eventID);
SedogoUser eventOwner = new SedogoUser("", sedogoEvent.userID);
string dateString = "";
DateTime startDate = sedogoEvent.startDate;
MiscUtils.GetDateStringStartDate(eventOwner, sedogoEvent.dateType, sedogoEvent.rangeStartDate,
sedogoEvent.rangeEndDate, sedogoEvent.beforeBirthday, ref dateString, ref startDate);
HyperLink eventNameLabel = e.Item.FindControl("eventNameLabel") as HyperLink;
eventNameLabel.NavigateUrl = "viewEvent.aspx?EID=" + row["EventID"].ToString();
eventNameLabel.Text = row["EventName"].ToString();
Label eventDateLabel = e.Item.FindControl("eventDateLabel") as Label;
eventDateLabel.Text = dateString;
Label dateAchievedLabel = e.Item.FindControl("dateAchievedLabel") as Label;
if (sedogoEvent.eventAchievedDate > DateTime.MinValue)
{
dateAchievedLabel.Text = sedogoEvent.eventAchievedDate.ToString("dd MMM yyyy");
}
else
{
dateAchievedLabel.Text = "";
}
//HyperLink userNameLabel = e.Item.FindControl("userNameLabel") as HyperLink;
//userNameLabel.Text = row["FirstName"].ToString() + " " + row["LastName"].ToString();
//userNameLabel.NavigateUrl = "userTimeline.aspx?UID=" + sedogoEvent.userID.ToString();
Image eventImage = e.Item.FindControl("eventImage") as Image;
string eventPicThumbnail = row["EventPicThumbnail"].ToString();
if (eventPicThumbnail == "")
{
eventImage.ImageUrl = "~/images/eventThumbnailBlank.png";
}
else
{
var _event = new SedogoEvent(string.Empty, eventID);
eventImage.ImageUrl = ResolveUrl(ImageHelper.GetRelativeImagePath(_event.eventID, _event.eventGUID, ImageType.EventThumbnail));
}
}
}
//===============================================================
// Function: click_achievedEventLink
//===============================================================
protected void click_achievedEventLink(object sender, EventArgs e)
{
int eventID = int.Parse(Request.QueryString["EID"]);
SedogoEvent sedogoEvent = new SedogoEvent(Session["loggedInUserFullName"].ToString(), eventID);
sedogoEvent.eventAchieved = !sedogoEvent.eventAchieved;
if (sedogoEvent.eventAchieved == true)
{
sedogoEvent.eventAchievedDate = DateTime.Now;
}
else
{
sedogoEvent.eventAchievedDate = DateTime.MinValue;
}
sedogoEvent.Update();
//sedogoEvent.SendEventUpdateEmail();
if (sedogoEvent.eventAchieved == true)
{
Session["AcheievedEventID"] = eventID;
}
Response.Redirect("profileRedirect.aspx");
}
//===============================================================
// Function: uploadProfilePicButton_click
//===============================================================
protected void uploadProfilePicButton_click(object sender, EventArgs e)
{
int eventID = int.Parse(Request.QueryString["EID"]);
int userID = int.Parse(Session["loggedInUserID"].ToString());
if (goalPicFileUpload.PostedFile.ContentLength != 0)
{
SedogoEvent sedogoEvent = new SedogoEvent((string)Session["loggedInUserFullName"], eventID);
sedogoEvent.Update();
int fileSizeBytes = goalPicFileUpload.PostedFile.ContentLength;
GlobalData gd = new GlobalData((string)Session["loggedInUserFullName"]);
string fileStoreFolder = gd.GetStringValue("FileStoreFolder") + @"\temp";
string originalFileName = Path.GetFileName(goalPicFileUpload.PostedFile.FileName);
string destPath = Path.Combine(fileStoreFolder, originalFileName);
destPath = destPath.Replace(" ", "_");
destPath = MiscUtils.GetUniqueFileName(destPath);
string savedFilename = Path.GetFileName(destPath);
goalPicFileUpload.PostedFile.SaveAs(destPath);
int status = MiscUtils.CreateGoalPicPreviews(Path.GetFileName(destPath),
eventID, (string)Session["loggedInUserFullName"], userID, captionTextBox.Text);
if (status >= 0)
{
Response.Redirect("morePictures.aspx?EID=" + eventID.ToString());
}
else
{
Page.ClientScript.RegisterStartupScript(this.GetType(), "Alert", "alert(\"This type of image is not supported, please choose another.\");", true);
}
}
}
//===============================================================
// Function: Page_Load
//===============================================================
protected void Page_Load(object sender, EventArgs e)
{
int eventID = int.Parse(Request.QueryString["EID"]);
SedogoEvent sedogoEvent = new SedogoEvent(Session["loggedInUserFullName"].ToString(), eventID);
eventNameLabel.Text = sedogoEvent.eventName;
CalendarAlertDate.SelectedDate = DateTime.Now;
PickerAlertDate.SelectedDate = DateTime.Now;
}
//===============================================================
// Function: SendInviteEmail
//===============================================================
private Boolean SendInviteEmail(int eventID, string emailAddress, string additionalInviteText,
string dateString, SedogoEvent currentEvent, SedogoUser currentUser,
out string errorMessageDescription)
{
Boolean sentOK = false;
GlobalData gd = new GlobalData("");
errorMessageDescription = "";
if (MiscUtils.IsValidEmailAddress(emailAddress) == true)
{
try
{
// Check if they have already been invited
int inviteCount = EventInvite.GetInviteCountForEmailAddress(eventID, emailAddress);
if (inviteCount == 0)
{
StringBuilder emailBodyCopy = new StringBuilder();
// Check if they are a Sedogo account holder
int sedogoUserID = SedogoUser.GetUserIDFromEmailAddress(emailAddress);
Boolean enableSendEmails = true;
if( sedogoUserID != currentUser.userID )
{
EventInvite newInvite = new EventInvite(Session["loggedInUserFullName"].ToString());
newInvite.eventID = eventID;
newInvite.emailAddress = emailAddress;
newInvite.inviteAdditionalText = additionalInviteText;
newInvite.userID = sedogoUserID;
newInvite.Add();
string inviteURL = gd.GetStringValue("SiteBaseURL");
inviteURL = inviteURL + "?EIG=" + newInvite.eventInviteGUID;
string eventURL = gd.GetStringValue("SiteBaseURL");
eventURL = eventURL + "?EID=" + currentEvent.eventID.ToString();
emailBodyCopy.AppendLine("<html>");
emailBodyCopy.AppendLine("<head><title></title><meta http-equiv=\"Content-Type\" content=\"text/html; charset=iso-8859-1\">");
emailBodyCopy.AppendLine("<style type=\"text/css\">");
emailBodyCopy.AppendLine(" body, td, p { font-size: 15px; color: #9B9885; font-family: Arial, Helvetica, Sans-Serif }");
emailBodyCopy.AppendLine(" p { margin: 0 }");
emailBodyCopy.AppendLine(" h1 { color: #00ccff; font-size: 18px; font-weight: bold; }");
emailBodyCopy.AppendLine(" a, .blue { color: #00ccff; text-decoration: none; }");
emailBodyCopy.AppendLine(" img { border: 0; }");
emailBodyCopy.AppendLine("</style></head>");
emailBodyCopy.AppendLine("<body bgcolor=\"#f0f1ec\">");
emailBodyCopy.AppendLine(" <table width=\"692\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\">");
//emailBodyCopy.AppendLine(" <tr><td colspan=\"3\"><img src=\"http://www.sedogo.com/email-template/images/email-template_01.png\" width=\"692\" height=\"32\" alt=\"\"></td></tr>");
emailBodyCopy.AppendLine(" <tr><td style=\"background: #fff\" width=\"30\"></td>");
emailBodyCopy.AppendLine(" <td style=\"background: #fff\" width=\"632\">");
if (sedogoUserID > 0)
{
SedogoUser inviteUser = new SedogoUser(Session["loggedInUserFullName"].ToString(), sedogoUserID);
if (inviteUser.enableSendEmails == false)
{
enableSendEmails = false;
}
inviteURL = inviteURL + "&UID=" + sedogoUserID.ToString();
emailBodyCopy.AppendLine(" <h1>You are invited to join the following goal:</h1>");
emailBodyCopy.AppendLine(" <table border=\"0\" cellpadding=\"0\" cellspacing=\"0\" width=\"600\">");
emailBodyCopy.AppendLine(" <tr>");
emailBodyCopy.AppendLine(" <td width=\"60\">What:</td>");
emailBodyCopy.AppendLine(" <td width=\"10\"> </td>");
emailBodyCopy.AppendLine(" <td width=\"530\">" + currentEvent.eventName + "</td>");
emailBodyCopy.AppendLine(" </tr>");
emailBodyCopy.AppendLine(" <tr>");
emailBodyCopy.AppendLine(" <td valign=\"top\">Where:</td>");
emailBodyCopy.AppendLine(" <td width=\"10\"> </td>");
emailBodyCopy.AppendLine(" <td>" + currentEvent.eventVenue + "</td>");
emailBodyCopy.AppendLine(" </tr>");
emailBodyCopy.AppendLine(" <tr>");
emailBodyCopy.AppendLine(" <td valign=\"top\">When:</td>");
emailBodyCopy.AppendLine(" <td width=\"10\"> </td>");
emailBodyCopy.AppendLine(" <td>" + dateString + "</td>");
emailBodyCopy.AppendLine(" </tr>");
emailBodyCopy.AppendLine(" </table>");
emailBodyCopy.AppendLine(" <p><span class=\"blue\">" + currentUser.firstName + "</span> has created this future goal on <a href=\"http://www.sedogo.com\">sedogo.com</a> and wants you to join in.</p>");
emailBodyCopy.AppendLine(" <p>To be part of this event, <a href=\"" + inviteURL + "\"><u>click here</u></a>.</p>");
emailBodyCopy.AppendLine(" <p>To see who else is part of making this goal happen, <a href=\"" + eventURL + "\"><u>click here</u></a>.</p>");
emailBodyCopy.AppendLine(" <p>To view this goal, <a href=\"" + eventURL + "\"><u>click here</u></a>.</p>");
}
else
{
emailBodyCopy.AppendLine(" <h1>You are invited to join the following goal:</h1>");
emailBodyCopy.AppendLine(" <table border=\"0\" cellpadding=\"0\" cellspacing=\"0\" width=\"600\">");
emailBodyCopy.AppendLine(" <tr>");
emailBodyCopy.AppendLine(" <td width=\"60\">What:</td>");
emailBodyCopy.AppendLine(" <td width=\"10\"> </td>");
emailBodyCopy.AppendLine(" <td width=\"530\">" + currentEvent.eventName + "</td>");
emailBodyCopy.AppendLine(" </tr>");
emailBodyCopy.AppendLine(" <tr>");
emailBodyCopy.AppendLine(" <td valign=\"top\">Where:</td>");
emailBodyCopy.AppendLine(" <td width=\"10\"> </td>");
emailBodyCopy.AppendLine(" <td>" + currentEvent.eventVenue + "</td>");
emailBodyCopy.AppendLine(" </tr>");
emailBodyCopy.AppendLine(" <tr>");
emailBodyCopy.AppendLine(" <td valign=\"top\">When:</td>");
emailBodyCopy.AppendLine(" <td width=\"10\"> </td>");
emailBodyCopy.AppendLine(" <td>" + dateString + "</td>");
emailBodyCopy.AppendLine(" </tr>");
emailBodyCopy.AppendLine(" </table>");
emailBodyCopy.AppendLine(" <p><span class=\"blue\">" + currentUser.firstName + "</span> has created this future goal on <a href=\"http://www.sedogo.com\">sedogo.com</a> and wants you to join in.</p>");
emailBodyCopy.AppendLine(" <p>To be part of this event, <a href=\"" + inviteURL + "\">sign up</a> for a free sedogo account now.");
emailBodyCopy.AppendLine(" <p>When you have completed the registration process, <a href=\"" + eventURL + "\">click here</a> to view this event.");
}
emailBodyCopy.AppendLine(" <br /><br />");
emailBodyCopy.AppendLine(" <p>Regards</p><a href=\"http://www.sedogo.com\" class=\"blue\"><strong>The Sedogo Team.</strong></a><br />");
emailBodyCopy.AppendLine(" <br /><br /><br /><a href=\"http://www.sedogo.com\">");
//emailBodyCopy.AppendLine(" <img src=\"http://www.sedogo.com/email-template/images/logo.gif\" />");
emailBodyCopy.AppendLine(" </a></td>");
emailBodyCopy.AppendLine(" <td style=\"background: #fff\" width=\"30\"></td></tr><tr><td colspan=\"3\">");
//emailBodyCopy.AppendLine(" <img src=\"http://www.sedogo.com/email-template/images/email-template_05.png\" width=\"692\" height=\"32\" alt=\"\">");
emailBodyCopy.AppendLine(" </td></tr><tr><td colspan=\"3\"><small>This message was intended for " + emailAddress + ". To stop receiving these emails, go to your profile and uncheck the 'Enable email notifications' option.<br/>Sedogo offices are located at Sedogo Ltd, The Studio, 17 Blossom St, London E1 6PL.</small></td></tr>");
emailBodyCopy.AppendLine(" </td></tr></table></body></html>");
string emailSubject = currentUser.firstName + " wants you to be a part of " + currentEvent.eventName + " " + dateString + "!";
string SMTPServer = gd.GetStringValue("SMTPServer");
string mailFromAddress = gd.GetStringValue("MailFromAddress");
string mailFromUsername = gd.GetStringValue("MailFromUsername");
string mailFromPassword = gd.GetStringValue("MailFromPassword");
if (enableSendEmails == true)
{
try
{
MailMessage message = new MailMessage(mailFromAddress, emailAddress);
message.ReplyTo = new MailAddress("*****@*****.**");
message.Subject = emailSubject;
message.Body = emailBodyCopy.ToString();
message.IsBodyHtml = true;
SmtpClient smtp = new SmtpClient();
smtp.Host = SMTPServer;
if (mailFromPassword != "")
{
// If the password is blank, assume mail relay is permitted
smtp.Credentials = new System.Net.NetworkCredential(mailFromAddress, mailFromPassword);
}
smtp.Send(message);
newInvite.inviteEmailSent = true;
newInvite.inviteEmailSentDate = DateTime.Now;
newInvite.inviteEmailSentEmailAddress = emailAddress;
newInvite.Update();
SentEmailHistory emailHistory = new SentEmailHistory(Session["loggedInUserFullName"].ToString());
emailHistory.subject = emailSubject;
emailHistory.body = emailBodyCopy.ToString();
emailHistory.sentFrom = mailFromAddress;
emailHistory.sentTo = emailAddress;
emailHistory.Add();
}
catch (Exception ex)
{
SentEmailHistory emailHistory = new SentEmailHistory(Session["loggedInUserFullName"].ToString());
emailHistory.subject = emailSubject;
emailHistory.body = ex.Message + " -------- " + emailBodyCopy.ToString();
emailHistory.sentFrom = mailFromAddress;
emailHistory.sentTo = emailAddress;
emailHistory.Add();
}
}
sentOK = true;
}
else
{
errorMessageDescription = emailAddress + " - you cannot invite yourself";
}
}
else
{
errorMessageDescription = emailAddress + " - already invited";
}
}
catch (Exception ex)
{
errorMessageDescription = emailAddress + " - " + ex.Message;
}
}
else
{
errorMessageDescription = emailAddress + " - invalid email address";
}
return sentOK;
}
//===============================================================
// Function: Page_Load
//===============================================================
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
int eventID = int.Parse(Request.QueryString["EID"]);
int eventPID = int.Parse(Request.QueryString["EPID"]);
int userID = -1;
string loggedInUserName = "";
if (Session["loggedInUserID"] != null)
{
userID = int.Parse(Session["loggedInUserID"].ToString());
loggedInUserName = Session["loggedInUserFullName"].ToString();
}
sidebarControl.userID = userID;
if (userID > 0)
{
SedogoUser user = new SedogoUser(Session["loggedInUserFullName"].ToString(), userID);
sidebarControl.user = user;
bannerAddFindControl.userID = userID;
}
SedogoEvent sedogoEvent = new SedogoEvent(loggedInUserName, eventID);
eventTitleLabel.Text = sedogoEvent.eventName;
if (sedogoEvent.privateEvent == true)
{
privateIcon.Visible = true;
}
if (sedogoEvent.deleted == true)
{
Response.Redirect("~/profile.aspx");
}
pageTitleUserName.Text = sedogoEvent.eventName + " pictures : Sedogo : Create your future and connect with others to make it happen";
string timelineColour = "#cd3301";
switch (sedogoEvent.categoryID)
{
case 1:
timelineColour = "#cd3301";
break;
case 2:
timelineColour = "#ff0b0b";
break;
case 3:
timelineColour = "#ff6801";
break;
case 4:
timelineColour = "#ff8500";
break;
case 5:
timelineColour = "#d5b21a";
break;
case 6:
timelineColour = "#8dc406";
break;
case 7:
timelineColour = "#5b980c";
break;
case 8:
timelineColour = "#079abc";
break;
case 9:
timelineColour = "#5ab6cd";
break;
case 10:
timelineColour = "#8a67c1";
break;
case 11:
timelineColour = "#e54ecf";
break;
case 12:
timelineColour = "#a5369c";
break;
case 13:
timelineColour = "#a32672";
break;
}
pageBannerBarDiv.Style.Add("background-color", timelineColour);
int imageCount = 0;
SqlConnection conn = new SqlConnection((string)Application["connectionString"]);
try
{
conn.Open();
SqlCommand cmd = new SqlCommand("", conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "spSelectEventPictureList";
cmd.Parameters.Add("@EventID", SqlDbType.Int).Value = eventID;
DbDataReader rdr = cmd.ExecuteReader();
while (rdr.Read())
{
int eventPictureID = int.Parse(rdr["EventPictureID"].ToString());
int postedByUserID = int.Parse(rdr["PostedByUserID"].ToString());
string imageFilename = "";
if (!rdr.IsDBNull(rdr.GetOrdinal("ImageFilename")))
{
imageFilename = (string)rdr["ImageFilename"];
}
string imagePreview = "";
if (!rdr.IsDBNull(rdr.GetOrdinal("ImagePreview")))
{
imagePreview = (string)rdr["ImagePreview"];
}
string imageThumbnail = "";
if (!rdr.IsDBNull(rdr.GetOrdinal("ImageThumbnail")))
{
imageThumbnail = (string)rdr["ImageThumbnail"];
}
string caption = "";
if (!rdr.IsDBNull(rdr.GetOrdinal("Caption")))
{
caption = (string)rdr["Caption"];
}
var @event = new SedogoEvent(string.Empty, eventID);
imagePreview = ResolveUrl(ImageHelper.GetRelativeImagePath(eventPictureID, @event.eventGUID,ImageType.EventPictureThumbnailSlideShow));// ImageType.EventPicturePreview));
sliderImagesLiteral.Text += "slidesX[" + imageCount.ToString() + "] = [\"" + imagePreview + "\", \"" + caption.Replace('"',' ') + "\"];\n";
imageCount++;
// if(eventPictureID==eventPID) sliderImagesLiteral.Text += "slidesX.jumpto="+imageCount+";\n";
}
rdr.Close();
}
catch (Exception ex)
{
throw ex;
}
finally
{
conn.Close();
}
}
}
//===============================================================
// Function: saveChangesButton_click
//===============================================================
protected void saveChangesButton_click(object sender, EventArgs e)
{
Boolean continueSending = false;
if (Session["SendMessageCaptcha"] == null || (string)Session["SendMessageCaptcha"] == "N")
{
if (registerCaptcha.IsValid == true)
{
Session["SendMessageCaptcha"] = "Y";
continueSending = true;
}
}
else
{
// Captcha has already been done in this session
continueSending = true;
}
if (continueSending == true)
{
int eventID = int.Parse(Request.QueryString["EID"]);
SedogoEvent sedogoEvent = new SedogoEvent(Session["loggedInUserFullName"].ToString(), eventID);
SedogoUser currentUser = new SedogoUser(Session["loggedInUserFullName"].ToString(),
int.Parse(Session["loggedInUserID"].ToString()));
SedogoUser eventOwner = new SedogoUser(Session["loggedInUserFullName"].ToString(),
sedogoEvent.userID);
string messageText = messageTextBox.Text;
Message message = new Message(Session["loggedInUserFullName"].ToString());
message.userID = sedogoEvent.userID;
message.eventID = eventID;
message.postedByUserID = int.Parse(Session["loggedInUserID"].ToString());
message.messageText = messageText;
message.Add();
StringBuilder emailBodyCopy = new StringBuilder();
GlobalData gd = new GlobalData("");
string eventURL = gd.GetStringValue("SiteBaseURL");
eventURL = eventURL + "/viewEvent.aspx?EID=" + eventID.ToString();
string replyURL = gd.GetStringValue("SiteBaseURL");
replyURL = replyURL + "?Redir=Messages&MessageID=" + message.messageID.ToString();
emailBodyCopy.AppendLine("<html>");
emailBodyCopy.AppendLine("<head><title></title><meta http-equiv=\"Content-Type\" content=\"text/html; charset=iso-8859-1\">");
emailBodyCopy.AppendLine("<style type=\"text/css\">");
emailBodyCopy.AppendLine(" body, td, p { font-size: 15px; color: #9B9885; font-family: Arial, Helvetica, Sans-Serif }");
emailBodyCopy.AppendLine(" p { margin: 0 }");
emailBodyCopy.AppendLine(" h1 { color: #00ccff; font-size: 18px; font-weight: bold; }");
emailBodyCopy.AppendLine(" a, .blue { color: #00ccff; text-decoration: none; }");
emailBodyCopy.AppendLine("</style></head>");
emailBodyCopy.AppendLine("<body bgcolor=\"#f0f1ec\">");
emailBodyCopy.AppendLine(" <table width=\"692\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\">");
//emailBodyCopy.AppendLine(" <tr><td colspan=\"3\"><img src=\"http://www.sedogo.com/email-template/images/email-template_01.png\" width=\"692\" height=\"32\" alt=\"\"></td></tr>");
emailBodyCopy.AppendLine(" <tr><td style=\"background: #fff\" width=\"30\"></td>");
emailBodyCopy.AppendLine(" <td style=\"background: #fff\" width=\"632\">");
//emailBodyCopy.AppendLine(" <h1>sedogo.com message</h1>");
emailBodyCopy.AppendLine(" <table border=\"0\" cellpadding=\"0\" cellspacing=\"0\" width=\"600\">");
emailBodyCopy.AppendLine(" <tr>");
emailBodyCopy.AppendLine(" <td width=\"60\">From:</td>");
emailBodyCopy.AppendLine(" <td width=\"10\" rowspan=\"5\"> </td>");
emailBodyCopy.AppendLine(" <td width=\"530\">" + currentUser.firstName + " " + currentUser.lastName + "</td>");
emailBodyCopy.AppendLine(" </tr>");
emailBodyCopy.AppendLine(" <tr>");
emailBodyCopy.AppendLine(" <td valign=\"top\">Goal:</td>");
emailBodyCopy.AppendLine(" <td><a href=\"" + eventURL + "\">" + sedogoEvent.eventName + "</a></td>");
emailBodyCopy.AppendLine(" </tr>");
emailBodyCopy.AppendLine(" <tr>");
emailBodyCopy.AppendLine(" <td valign=\"top\">Where:</td>");
emailBodyCopy.AppendLine(" <td>" + sedogoEvent.eventVenue + "</td>");
emailBodyCopy.AppendLine(" </tr>");
emailBodyCopy.AppendLine(" <tr>");
emailBodyCopy.AppendLine(" <td valign=\"top\">Message:</td>");
emailBodyCopy.AppendLine(" <td><p style=\"color:black\">" + messageText.Replace("\n", "<br/>") + "</p></td>");
emailBodyCopy.AppendLine(" </tr>");
emailBodyCopy.AppendLine(" <tr>");
emailBodyCopy.AppendLine(" <td valign=\"top\"></td>");
emailBodyCopy.AppendLine(" <td><a class=\"blue\" href=\"" + replyURL + "\">Click here to reply to this message</a></td>");
emailBodyCopy.AppendLine(" </tr>");
emailBodyCopy.AppendLine(" </table>");
emailBodyCopy.AppendLine(" <br /><br />");
emailBodyCopy.AppendLine(" <p>Regards</p><a href=\"http://www.sedogo.com\" class=\"blue\"><strong>The Sedogo Team.</strong></a><br />");
emailBodyCopy.AppendLine(" <br /><br /><br /><a href=\"http://www.sedogo.com\">");
//emailBodyCopy.AppendLine(" <img src=\"http://www.sedogo.com/email-template/images/logo.gif\" />");
emailBodyCopy.AppendLine(" </a></td>");
emailBodyCopy.AppendLine(" <td style=\"background: #fff\" width=\"30\"></td></tr><tr><td colspan=\"3\">");
//emailBodyCopy.AppendLine(" <img src=\"http://www.sedogo.com/email-template/images/email-template_05.png\" width=\"692\" height=\"32\" alt=\"\">");
emailBodyCopy.AppendLine(" </td></tr><tr><td colspan=\"3\"><small>This message was intended for " + eventOwner.emailAddress + ". To stop receiving these emails, go to your profile and uncheck the 'Enable email notifications' option.<br/>Sedogo offices are located at Sedogo Ltd, The Studio, 17 Blossom St, London E1 6PL.</small></td></tr>");
emailBodyCopy.AppendLine(" </td></tr></table></body></html>");
string emailSubject = "Sedogo message from " + currentUser.firstName + " regarding " + sedogoEvent.eventName;
string SMTPServer = gd.GetStringValue("SMTPServer");
string mailFromAddress = gd.GetStringValue("MailFromAddress");
string mailFromUsername = gd.GetStringValue("MailFromUsername");
string mailFromPassword = gd.GetStringValue("MailFromPassword");
if (eventOwner.enableSendEmails == true)
{
try
{
MailMessage mailMessage = new MailMessage(mailFromAddress, eventOwner.emailAddress);
mailMessage.ReplyTo = new MailAddress("*****@*****.**");
mailMessage.Subject = emailSubject;
mailMessage.Body = emailBodyCopy.ToString();
mailMessage.IsBodyHtml = true;
SmtpClient smtp = new SmtpClient();
smtp.Host = SMTPServer;
if (mailFromPassword != "")
{
// If the password is blank, assume mail relay is permitted
smtp.Credentials = new System.Net.NetworkCredential(mailFromAddress, mailFromPassword);
}
smtp.Send(mailMessage);
SentEmailHistory emailHistory = new SentEmailHistory(Session["loggedInUserFullName"].ToString());
emailHistory.subject = emailSubject;
emailHistory.body = emailBodyCopy.ToString();
emailHistory.sentFrom = mailFromAddress;
emailHistory.sentTo = eventOwner.emailAddress;
emailHistory.Add();
}
catch (Exception ex)
{
SentEmailHistory emailHistory = new SentEmailHistory(Session["loggedInUserFullName"].ToString());
emailHistory.subject = emailSubject;
emailHistory.body = ex.Message + " -------- " + emailBodyCopy.ToString();
emailHistory.sentFrom = mailFromAddress;
emailHistory.sentTo = eventOwner.emailAddress;
emailHistory.Add();
}
}
Response.Redirect("viewEvent.aspx?EID=" + eventID.ToString());
}
}
//===============================================================
// Function: Page_Load
//===============================================================
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
int eventID = int.Parse(Request.QueryString["EID"]);
string action = "";
int eventAlertID = -1;
if (Request.QueryString["A"] != null && Request.QueryString["EAID"] != null)
{
action = Request.QueryString["A"].ToString();
eventAlertID = int.Parse(Request.QueryString["EAID"]);
if (action == "Delete")
{
try
{
EventAlert alertToDelete = new EventAlert(Session["loggedInUserFullName"].ToString(), eventAlertID);
alertToDelete.Delete();
}
catch (Exception ex)
{
Page.ClientScript.RegisterStartupScript(this.GetType(), "Alert",
"alert(\"Error: " + ex.Message + "\");", true);
}
}
}
SedogoEvent sedogoEvent = new SedogoEvent(Session["loggedInUserFullName"].ToString(), eventID);
SedogoUser eventOwner = new SedogoUser("", sedogoEvent.userID);
string dateString = "";
DateTime startDate = sedogoEvent.startDate;
MiscUtils.GetDateStringStartDate(eventOwner, sedogoEvent.dateType, sedogoEvent.rangeStartDate,
sedogoEvent.rangeEndDate, sedogoEvent.beforeBirthday, ref dateString, ref startDate);
eventTitleLabel.Text = sedogoEvent.eventName;
eventOwnersNameLabel.Text = eventOwner.firstName + " " + eventOwner.lastName;
eventDateLabel.Text = dateString;
eventDescriptionLabel.Text = sedogoEvent.eventDescription.Replace("\n", "<br/>");
CalendarAlertDate.SelectedDate = DateTime.Now;
PickerAlertDate.SelectedDate = DateTime.Now;
PopulateAlerts(eventID);
}
}
//===============================================================
// Function: GetInviteCount
//===============================================================
public void SendInviteAcceptedEmail()
{
GlobalData gd = new GlobalData("");
string SMTPServer = gd.GetStringValue("SMTPServer");
string mailFromAddress = gd.GetStringValue("MailFromAddress");
string mailFromUsername = gd.GetStringValue("MailFromUsername");
string mailFromPassword = gd.GetStringValue("MailFromPassword");
string invitedUserFullName = m_emailAddress;
if( m_userID > 0 )
{
SedogoUser invitedUser = new SedogoUser(m_loggedInUser, m_userID);
invitedUserFullName = invitedUser.fullName;
}
SedogoEvent sedogoEvent = new SedogoEvent(m_loggedInUser, m_eventID);
SedogoUser eventOwner = new SedogoUser(m_loggedInUser, sedogoEvent.userID);
string emailSubject = "Sedogo invitation to " + sedogoEvent.eventName + " has been accepted by "
+ invitedUserFullName;
string dateString = "";
DateTime startDate = sedogoEvent.startDate;
MiscUtils.GetDateStringStartDate(eventOwner, sedogoEvent.dateType, sedogoEvent.rangeStartDate,
sedogoEvent.rangeEndDate, sedogoEvent.beforeBirthday, ref dateString, ref startDate);
string inviteURL = gd.GetStringValue("SiteBaseURL");
inviteURL = inviteURL + "/viewEvent.aspx?EID=" + m_eventID.ToString();
StringBuilder emailBodyCopy = new StringBuilder();
emailBodyCopy.AppendLine("<html>");
emailBodyCopy.AppendLine("<head><title></title><meta http-equiv=\"Content-Type\" content=\"text/html; charset=iso-8859-1\">");
emailBodyCopy.AppendLine("<style type=\"text/css\">");
emailBodyCopy.AppendLine(" body, td, p { font-size: 15px; color: #9B9885; font-family: Arial, Helvetica, Sans-Serif }");
emailBodyCopy.AppendLine(" p { margin: 0 }");
emailBodyCopy.AppendLine(" h1 { color: #00ccff; font-size: 18px; font-weight: bold; }");
emailBodyCopy.AppendLine(" a, .blue { color: #00ccff; text-decoration: none; }");
emailBodyCopy.AppendLine(" img { border: 0; }");
emailBodyCopy.AppendLine("</style></head>");
emailBodyCopy.AppendLine("<body bgcolor=\"#f0f1ec\">");
emailBodyCopy.AppendLine(" <table width=\"692\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\">");
//emailBodyCopy.AppendLine(" <tr><td colspan=\"3\"><img src=\"http://www.sedogo.com/email-template/images/email-template_01.png\" width=\"692\" height=\"32\" alt=\"\"></td></tr>");
emailBodyCopy.AppendLine(" <tr><td style=\"background: #fff\" width=\"30\"></td>");
emailBodyCopy.AppendLine(" <td style=\"background: #fff\" width=\"632\">");
emailBodyCopy.AppendLine(" <h1>" + invitedUserFullName + " has accepted your invitation:</h1>");
emailBodyCopy.AppendLine(" <table border=\"0\" cellpadding=\"0\" cellspacing=\"0\" width=\"600\">");
emailBodyCopy.AppendLine(" <tr>");
emailBodyCopy.AppendLine(" <td width=\"60\">What:</td>");
emailBodyCopy.AppendLine(" <td width=\"10\" rowspan=\"4\"> </td>");
emailBodyCopy.AppendLine(" <td width=\"530\"><a href=\"" + inviteURL + "\">" + sedogoEvent.eventName + "</a></td>");
emailBodyCopy.AppendLine(" </tr>");
emailBodyCopy.AppendLine(" <tr>");
emailBodyCopy.AppendLine(" <td valign=\"top\">Where:</td>");
emailBodyCopy.AppendLine(" <td>" + sedogoEvent.eventVenue + "</td>");
emailBodyCopy.AppendLine(" </tr>");
emailBodyCopy.AppendLine(" <tr>");
emailBodyCopy.AppendLine(" <td valign=\"top\">Who:</td>");
emailBodyCopy.AppendLine(" <td>" + eventOwner.firstName + " " + eventOwner.lastName + "</td>");
emailBodyCopy.AppendLine(" </tr>");
emailBodyCopy.AppendLine(" <tr>");
emailBodyCopy.AppendLine(" <td valign=\"top\">When:</td>");
emailBodyCopy.AppendLine(" <td>" + dateString + "</td>");
emailBodyCopy.AppendLine(" </tr>");
emailBodyCopy.AppendLine(" </table>");
emailBodyCopy.AppendLine(" <p>To view this event, <a href=\"" + inviteURL + "\"><u>click here</u></a>.</p>");
emailBodyCopy.AppendLine(" <br /><br />");
emailBodyCopy.AppendLine(" <p>Regards</p><a href=\"http://www.sedogo.com\" class=\"blue\"><strong>The Sedogo Team.</strong></a><br />");
emailBodyCopy.AppendLine(" <br /><br /><br /><a href=\"http://www.sedogo.com\">");
//emailBodyCopy.AppendLine(" <img src=\"http://www.sedogo.com/email-template/images/logo.gif\" />");
emailBodyCopy.AppendLine(" </a></td>");
emailBodyCopy.AppendLine(" <td style=\"background: #fff\" width=\"30\"></td></tr><tr><td colspan=\"3\">");
//emailBodyCopy.AppendLine(" <img src=\"http://www.sedogo.com/email-template/images/email-template_05.png\" width=\"692\" height=\"32\" alt=\"\">");
emailBodyCopy.AppendLine(" </td></tr><tr><td colspan=\"3\"><small>This message was intended for " + eventOwner.emailAddress + ". To stop receiving these emails, go to your profile and uncheck the 'Enable email notifications' option.<br/>Sedogo offices are located at Sedogo Ltd, The Studio, 17 Blossom St, London E1 6PL.</small></td></tr>");
emailBodyCopy.AppendLine(" </td></tr></table></body></html>");
if (eventOwner.enableSendEmails == true)
{
try
{
MailMessage message = new MailMessage(mailFromAddress, eventOwner.emailAddress);
message.ReplyTo = new MailAddress("*****@*****.**");
message.Subject = emailSubject;
message.Body = emailBodyCopy.ToString();
message.IsBodyHtml = true;
SmtpClient smtp = new SmtpClient();
smtp.Host = SMTPServer;
if (mailFromPassword != "")
{
// If the password is blank, assume mail relay is permitted
smtp.Credentials = new System.Net.NetworkCredential(mailFromAddress, mailFromPassword);
}
smtp.Send(message);
SentEmailHistory emailHistory = new SentEmailHistory("");
emailHistory.subject = emailSubject;
emailHistory.body = emailBodyCopy.ToString();
emailHistory.sentFrom = mailFromAddress;
emailHistory.sentTo = eventOwner.emailAddress;
emailHistory.Add();
}
catch (Exception ex)
{
SentEmailHistory emailHistory = new SentEmailHistory("");
emailHistory.subject = emailSubject;
emailHistory.body = ex.Message + " -------- " + emailBodyCopy.ToString();
emailHistory.sentFrom = mailFromAddress;
emailHistory.sentTo = eventOwner.emailAddress;
emailHistory.Add();
}
}
}
//===============================================================
// Function: Page_Load
//===============================================================
protected void Page_Load(object sender, EventArgs e)
{
int eventID = int.Parse(Request.QueryString["EID"]);
SedogoEvent sedogoEvent = new SedogoEvent(Session["loggedInUserFullName"].ToString(), eventID);
SedogoUser eventOwner = new SedogoUser(Session["loggedInUserFullName"].ToString(), sedogoEvent.userID);
string dateString = "";
if (sedogoEvent.dateType == "D")
{
// Event occurs on a specific date
dateString = sedogoEvent.startDate.ToString("ddd d MMMM yyyy");
}
if (sedogoEvent.dateType == "R")
{
// Event occurs in a date range - use the start date
dateString = sedogoEvent.rangeStartDate.ToString("ddd d MMMM yyyy") + " to " + sedogoEvent.rangeEndDate.ToString("ddd d MMMM yyyy");
}
if (sedogoEvent.dateType == "A")
{
// Event occurs before birthday
string dateSuffix = "";
switch (sedogoEvent.beforeBirthday)
{
case 1: case 21: case 31: case 41: case 51: case 61: case 71: case 81: case 91: case 101:
dateSuffix = "st";
break;
case 2: case 22: case 32: case 42: case 52: case 62: case 72: case 82: case 92: case 102:
dateSuffix = "nd";
break;
case 3: case 23: case 33: case 43: case 53: case 63: case 73: case 83: case 93: case 103:
dateSuffix = "rd";
break;
case 4: case 5: case 6: case 7: case 8: case 9: case 10:
case 11: case 12: case 13: case 14: case 15: case 16: case 17: case 18: case 19: case 20:
case 24: case 25: case 26: case 27: case 28: case 29: case 30:
case 34: case 35: case 36: case 37: case 38: case 39: case 40:
case 44: case 45: case 46: case 47: case 48: case 49: case 50:
case 54: case 55: case 56: case 57: case 58: case 59: case 60:
case 64: case 65: case 66: case 67: case 68: case 69: case 70:
case 74: case 75: case 76: case 77: case 78: case 79: case 80:
case 84: case 85: case 86: case 87: case 88: case 89: case 90:
case 94: case 95: case 96: case 97: case 98: case 99: case 100:
case 104: case 105: case 106: case 107: case 108: case 109: case 110:
dateSuffix = "th";
break;
default:
break;
}
dateString = "Before " + sedogoEvent.beforeBirthday.ToString() + dateSuffix + " birthday";
}
int inviteCount = EventInvite.GetInviteCount(eventID);
eventNameLabel.Text = sedogoEvent.eventName;
whoLabel.Text = eventOwner.firstName + " " + eventOwner.lastName;
goalNameLabel.Text = sedogoEvent.eventName;
if (sedogoEvent.eventDescription == "")
{
descriptionLabel.Text = " ";
}
else
{
descriptionLabel.Text = sedogoEvent.eventDescription.Replace("\n", "<br/>");
}
venueLabel.Text = sedogoEvent.eventVenue;
dateLabel.Text = dateString;
reminderLabel.Text = GetAlertsText(eventID);
invitesLabel.Text = inviteCount.ToString() + " pending";
if (sedogoEvent.eventPicPreview == "")
{
eventImage.ImageUrl = "~/images/eventImageBlank.png";
}
else
{
eventImage.ImageUrl = "~/assets/eventPics/" + sedogoEvent.eventPicPreview;
}
}
//===============================================================
// Function: PopulateEvents
//===============================================================
protected void PopulateEvents()
{
int userID = int.Parse(Session["loggedInUserID"].ToString());
if (Session["ViewArchivedEvents"] != null)
{
viewArchivedEvents = (Boolean)Session["ViewArchivedEvents"];
}
DateTime todayStart = new DateTime(DateTime.Now.Year, DateTime.Now.Month, DateTime.Now.Day,
0, 0, 0);
DateTime todayPlus1Day = todayStart.AddDays(1);
DateTime todayPlus7Days = todayStart.AddDays(7);
DateTime todayPlus1Month = todayStart.AddMonths(1);
DateTime todayPlus1Year = todayStart.AddYears(1);
DateTime todayPlus2Years = todayStart.AddYears(2);
DateTime todayPlus3Years = todayStart.AddYears(3);
DateTime todayPlus4Years = todayStart.AddYears(4);
DateTime todayPlus5Years = todayStart.AddYears(5);
DateTime todayPlus10Years = todayStart.AddYears(10);
DateTime todayPlus20Years = todayStart.AddYears(20);
DateTime todayPlus100Years = todayStart.AddYears(100);
todaysDateLabel.Text = "Today: " + todayStart.ToString("ddd d MMMM yyyy");
int numOverdueEvents = 0;
int numTodayEvents = 0;
int numThisWeekEvents = 0;
int numThisMonthEvents = 0;
int numThisYearEvents = 0;
int numNext2YearsEvents = 0;
int numNext3YearsEvents = 0;
int numNext4YearsEvents = 0;
int numNext5YearsEvents = 0;
int numNext10YearsEvents = 0;
int numNext20YearsEvents = 0;
int numNext100YearsEvents = 0;
int numNotScheduledEvents = 0;
SearchHistory searchHistory = new SearchHistory("");
searchHistory.searchDate = DateTime.Now;
searchHistory.searchText = "";
searchHistory.userID = userID;
int rowCount = 0;
StringBuilder stateString = new StringBuilder();
SqlConnection conn = new SqlConnection((string)Application["connectionString"]);
try
{
conn.Open();
SqlCommand cmd = new SqlCommand("", conn);
cmd.CommandType = CommandType.StoredProcedure;
if (viewArchivedEvents == true)
{
cmd.CommandText = "spSelectFullEventListIncludingAchievedByCategory";
}
else
{
cmd.CommandText = "spSelectFullEventListByCategory";
}
cmd.Parameters.Add("@UserID", SqlDbType.Int).Value = userID;
cmd.Parameters.Add("@ShowPrivate", SqlDbType.Bit).Value = true;
//cmd.CommandText = "spSearchEvents";
//cmd.Parameters.Add("@UserID", SqlDbType.Int).Value = userID;
//cmd.Parameters.Add("@SearchText", SqlDbType.NVarChar, 1000).Value = searchText;
DbDataReader rdr = cmd.ExecuteReader();
if (rdr.HasRows == true)
{
while (rdr.Read())
{
int categoryID = 1;
string dateType = "D";
DateTime startDate = DateTime.MinValue;
DateTime rangeStartDate = DateTime.MinValue;
DateTime rangeEndDate = DateTime.MinValue;
int beforeBirthday = -1;
Boolean privateEvent = false;
Boolean eventAchieved = false;
string eventPicThumbnail = "";
int eventID = int.Parse(rdr["EventID"].ToString());
int eventUserID = int.Parse(rdr["UserID"].ToString());
string eventName = (string)rdr["EventName"];
if (!rdr.IsDBNull(rdr.GetOrdinal("DateType")))
{
dateType = (string)rdr["DateType"];
}
if (!rdr.IsDBNull(rdr.GetOrdinal("StartDate")))
{
startDate = (DateTime)rdr["StartDate"];
}
if (!rdr.IsDBNull(rdr.GetOrdinal("RangeStartDate")))
{
rangeStartDate = (DateTime)rdr["RangeStartDate"];
}
if (!rdr.IsDBNull(rdr.GetOrdinal("RangeEndDate")))
{
rangeEndDate = (DateTime)rdr["RangeEndDate"];
}
eventAchieved = (Boolean)rdr["EventAchieved"];
if (!rdr.IsDBNull(rdr.GetOrdinal("CategoryID")))
{
categoryID = int.Parse(rdr["CategoryID"].ToString());
}
if (!rdr.IsDBNull(rdr.GetOrdinal("BeforeBirthday")))
{
beforeBirthday = int.Parse(rdr["BeforeBirthday"].ToString());
}
privateEvent = (Boolean)rdr["PrivateEvent"];
if (!rdr.IsDBNull(rdr.GetOrdinal("EventPicThumbnail")))
{
eventPicThumbnail = (string)rdr["EventPicThumbnail"];
}
string dateString = "";
if (dateType == "D")
{
// Event occurs on a specific date
dateString = startDate.ToString("ddd d MMMM yyyy");
}
if (dateType == "R")
{
// Event occurs in a date range - use the start date
dateString = rangeStartDate.ToString("ddd d MMMM yyyy") + " to " + rangeEndDate.ToString("ddd d MMMM yyyy");
startDate = rangeEndDate;
//startDate = rangeStartDate;
}
if (dateType == "A")
{
// Event occurs before birthday
string dateSuffix = "";
switch (beforeBirthday)
{
case 1: case 21: case 31: case 41: case 51: case 61: case 71: case 81: case 91: case 101:
dateSuffix = "st";
break;
case 2: case 22: case 32: case 42: case 52: case 62: case 72: case 82: case 92: case 102:
dateSuffix = "nd";
break;
case 3: case 23: case 33: case 43: case 53: case 63: case 73: case 83: case 93: case 103:
dateSuffix = "rd";
break;
case 4: case 5: case 6: case 7: case 8: case 9: case 10:
case 11: case 12: case 13: case 14: case 15: case 16: case 17: case 18: case 19: case 20:
case 24: case 25: case 26: case 27: case 28: case 29: case 30:
case 34: case 35: case 36: case 37: case 38: case 39: case 40:
case 44: case 45: case 46: case 47: case 48: case 49: case 50:
case 54: case 55: case 56: case 57: case 58: case 59: case 60:
case 64: case 65: case 66: case 67: case 68: case 69: case 70:
case 74: case 75: case 76: case 77: case 78: case 79: case 80:
case 84: case 85: case 86: case 87: case 88: case 89: case 90:
case 94: case 95: case 96: case 97: case 98: case 99: case 100:
case 104: case 105: case 106: case 107: case 108: case 109: case 110:
dateSuffix = "th";
break;
default:
break;
}
dateString = "Before " + beforeBirthday.ToString() + dateSuffix + " birthday";
startDate = DateTime.Now;
if (userID != eventUserID)
{
// Use the event users birthday
SedogoUser eventUser = new SedogoUser("", eventUserID);
if (eventUser.birthday > DateTime.MinValue)
{
startDate = eventUser.birthday.AddYears(beforeBirthday);
}
}
else
{
// My event/my birthday
if (user.birthday > DateTime.MinValue)
{
startDate = user.birthday.AddYears(beforeBirthday);
}
}
}
string timelineColour = "#cd3301";
switch (categoryID)
{
case 1:
timelineColour = "#cd3301";
break;
case 2:
timelineColour = "#ff0b0b";
break;
case 3:
timelineColour = "#ff6801";
break;
case 4:
timelineColour = "#ff8500";
break;
case 5:
timelineColour = "#d5b21a";
break;
case 6:
timelineColour = "#8dc406";
break;
case 7:
timelineColour = "#5b980c";
break;
case 8:
timelineColour = "#079abc";
break;
case 9:
timelineColour = "#5ab6cd";
break;
case 10:
timelineColour = "#8a67c1";
break;
case 11:
timelineColour = "#e54ecf";
break;
case 12:
timelineColour = "#a5369c";
break;
case 13:
timelineColour = "#a32672";
break;
}
int eventAlertCount = EventAlert.GetEventAlertCountPending(eventID);
int trackingUserCount = SedogoEvent.GetTrackingUserCount(eventID);
int joinedUserCount = SedogoEvent.GetMemberUserCount(eventID);
StringBuilder eventString = new StringBuilder();
eventString.Append("<div class=\"event");
//if( categoryID > 0 ) // Show border colour on event
//{
// eventString.Append(" highlight-group-" + categoryID.ToString());
//}
eventString.AppendLine("\">");
eventString.AppendLine("<table width=\"100%\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\" ");
eventString.AppendLine("onMouseOver=\"setColor('colourBar_" + eventID.ToString() + "','" + timelineColour + "');\" ");
eventString.AppendLine("onMouseOut=\"setColor('colourBar_" + eventID.ToString() + "','#FFFFFF');\" ");
eventString.AppendLine("onclick=\"showhideGoal('goalDiv_" + eventID.ToString() + "');\" ");
eventString.AppendLine(">");
eventString.AppendLine("<tr style=\"background-color:#EEEEEE\" >");
eventString.AppendLine("<td>");
eventString.AppendLine("<p class=\"eventListText\"><b>");
//if (eventAchieved == true)
//{
// eventString.AppendLine(" <img src=\"./images/acceptachieve.gif\" alt=\"Achieved\" />");
//}
eventString.Append(eventName);
eventString.Append("</b></p>");
eventString.AppendLine("</td>");
eventString.AppendLine("<td align=\"right\">");
if (eventAchieved == true)
{
eventString.AppendLine(" <img src=\"./images/acceptachieve.gif\" alt=\"Achieved\" />");
}
if (privateEvent == true)
{
eventString.AppendLine("<img src=\"./images/private.gif\" alt=\"Private event\" />");
}
if (eventAlertCount > 0)
{
eventString.AppendLine("<img src=\"./images/reminder.gif\" alt=\"Alert\" />");
}
eventString.AppendLine("</td>");
eventString.AppendLine("</tr>");
eventString.AppendLine("<tr height=\"6px\"><td colspan=\"2\" bgcolor=\"#FFFFFF\" id=\"colourBar_" + eventID.ToString() + "\" >");
eventString.AppendLine("<img src=\"/images/1x1trans.gif\" height=\"6px\" >");
eventString.AppendLine("</td></tr>");
eventString.AppendLine("</table>");
eventString.AppendLine("<div id=\"goalDiv_" + eventID.ToString() + "\" style=\"display:none\">");
eventString.AppendLine("<table width=\"100%\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\" >");
eventString.AppendLine("<tr>");
eventString.AppendLine("<td>");
eventString.AppendLine("<p>" + dateString + "</p>");
eventString.AppendLine("<p>");
if (joinedUserCount > 0)
{
eventString.AppendLine(joinedUserCount.ToString());
if (joinedUserCount == 1)
{
eventString.AppendLine(" member");
}
else
{
eventString.AppendLine(" members");
}
}
if (trackingUserCount > 0)
{
if (joinedUserCount > 0)
{
eventString.AppendLine("<br/>");
}
eventString.AppendLine(trackingUserCount.ToString());
eventString.AppendLine(" following");
}
eventString.AppendLine("</p>");
eventString.AppendLine("<a href=\"viewEvent.aspx?EID=" + eventID.ToString()
+ "\" title=\"\">View</a>");
eventString.AppendLine("</td>");
eventString.AppendLine("<td align=\"right\" style=\"padding-top:5px\">");
if (eventPicThumbnail == "")
{
eventString.AppendLine("<img src=\"./images/eventThumbnailBlank.png\" />");
}
else
{
var _event = new SedogoEvent(string.Empty, eventID);
eventString.AppendLine("<img src=\"" + ImageHelper.GetRelativeImagePath(_event.eventID, _event.eventGUID, ImageType.EventThumbnail).Replace("~", ".") + "\" />");
}
eventString.AppendLine("</td>");
eventString.AppendLine("</tr></table>");
eventString.AppendLine("</div>");
eventString.AppendLine("</div>");
// Use the timeline start date as this has been adjusted above
if (startDate < todayStart && startDate != DateTime.MinValue)
{
overdueEventsPlaceHolder.Controls.Add(new LiteralControl(eventString.ToString()));
numOverdueEvents++;
}
if (startDate >= todayStart && startDate < todayPlus1Day)
{
todayEventsPlaceHolder.Controls.Add(new LiteralControl(eventString.ToString()));
numTodayEvents++;
}
if (startDate >= todayPlus1Day && startDate < todayPlus7Days)
{
thisWeekEventsPlaceHolder.Controls.Add(new LiteralControl(eventString.ToString()));
numThisWeekEvents++;
}
if (startDate >= todayPlus7Days && startDate < todayPlus1Month)
{
thisMonthEventsPlaceHolder.Controls.Add(new LiteralControl(eventString.ToString()));
numThisMonthEvents++;
}
if (startDate >= todayPlus1Month && startDate < todayPlus1Year)
{
nextYearEventsPlaceHolder.Controls.Add(new LiteralControl(eventString.ToString()));
numThisYearEvents++;
}
if (startDate >= todayPlus1Year && startDate < todayPlus2Years)
{
next2YearsEventsPlaceHolder.Controls.Add(new LiteralControl(eventString.ToString()));
numNext2YearsEvents++;
}
if (startDate >= todayPlus2Years && startDate < todayPlus3Years)
{
next3YearsEventsPlaceHolder.Controls.Add(new LiteralControl(eventString.ToString()));
numNext3YearsEvents++;
}
if (startDate >= todayPlus3Years && startDate < todayPlus4Years)
{
next4YearsEventsPlaceHolder.Controls.Add(new LiteralControl(eventString.ToString()));
numNext4YearsEvents++;
}
if (startDate >= todayPlus4Years && startDate < todayPlus5Years)
{
next5YearsEventsPlaceHolder.Controls.Add(new LiteralControl(eventString.ToString()));
numNext5YearsEvents++;
}
if (startDate >= todayPlus5Years && startDate < todayPlus10Years)
{
next10YearsEventsPlaceHolder.Controls.Add(new LiteralControl(eventString.ToString()));
numNext10YearsEvents++;
}
if (startDate >= todayPlus10Years && startDate < todayPlus20Years)
{
next20YearsEventsPlaceHolder.Controls.Add(new LiteralControl(eventString.ToString()));
numNext20YearsEvents++;
}
if (startDate >= todayPlus20Years && startDate < todayPlus100Years)
{
next100YearsEventsPlaceHolder.Controls.Add(new LiteralControl(eventString.ToString()));
numNext100YearsEvents++;
}
if (startDate == DateTime.MinValue)
{
notScheduledEventsPlaceHolder.Controls.Add(new LiteralControl(eventString.ToString()));
numNotScheduledEvents++;
}
}
rdr.Close();
}
searchHistory.searchHits = rowCount;
searchHistory.Add();
overdueTitleLabel.Visible = true;
todaysDateLabel.Visible = true;
thisWeekTitleLabel.Visible = true;
thisMonthTitleLabel.Visible = true;
thisYearTitleLabel.Visible = true;
next2YearsTitleLabel.Visible = true;
next3YearsTitleLabel.Visible = true;
next4YearsTitleLabel.Visible = true;
next5YearsTitleLabel.Visible = true;
fiveToTenYearsTitleLabel.Visible = true;
tenToTwentyYearsTitleLabel.Visible = true;
twentyPlusYearsTitleLabel.Visible = true;
unknownDateTitleLabel.Visible = true;
if (numOverdueEvents == 0)
{
overdueTitleLabel.Visible = false;
}
if (numTodayEvents == 0)
{
todaysDateLabel.Visible = false;
}
if (numThisWeekEvents == 0)
{
thisWeekTitleLabel.Visible = false;
}
if (numThisMonthEvents == 0)
{
thisMonthTitleLabel.Visible = false;
}
if (numThisYearEvents == 0)
{
thisYearTitleLabel.Visible = false;
}
if (numNext2YearsEvents == 0)
{
next2YearsTitleLabel.Visible = false;
}
if (numNext3YearsEvents == 0)
{
next3YearsTitleLabel.Visible = false;
}
if (numNext4YearsEvents == 0)
{
next4YearsTitleLabel.Visible = false;
}
if (numNext5YearsEvents == 0)
{
next5YearsTitleLabel.Visible = false;
}
if (numNext10YearsEvents == 0)
{
fiveToTenYearsTitleLabel.Visible = false;
}
if (numNext20YearsEvents == 0)
{
tenToTwentyYearsTitleLabel.Visible = false;
}
if (numNext100YearsEvents == 0)
{
twentyPlusYearsTitleLabel.Visible = false;
}
if (numNotScheduledEvents == 0)
{
unknownDateTitleLabel.Visible = false;
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
conn.Close();
}
}
//===============================================================
// Function: saveChangesButton_click
//===============================================================
protected void saveChangesButton_click(object sender, EventArgs e)
{
int eventID = int.Parse(Request.QueryString["EID"]);
if (eventPicFileUpload.PostedFile.ContentLength != 0)
{
int fileSizeBytes = eventPicFileUpload.PostedFile.ContentLength;
GlobalData gd = new GlobalData((string)Session["loggedInUserFullName"]);
string fileStoreFolder = gd.GetStringValue("FileStoreFolder") + @"\temp";
string originalFileName = Path.GetFileName(eventPicFileUpload.PostedFile.FileName);
string destPath = Path.Combine(fileStoreFolder, originalFileName);
if ((eventPicFileUpload.PostedFile.ContentType == "image/jpeg"
|| eventPicFileUpload.PostedFile.ContentType == "image/gif"
|| eventPicFileUpload.PostedFile.ContentType == "image/png")
&& Path.GetExtension(destPath) != ""
)
{
destPath = destPath.Replace(" ", "_");
destPath = MiscUtils.GetUniqueFileName(destPath);
string savedFilename = Path.GetFileName(destPath);
eventPicFileUpload.PostedFile.SaveAs(destPath);
MiscUtils.CreateEventPicPreviews(Path.GetFileName(destPath), eventID);
}
}
DateTime alertDate = CalendarAlertDate.SelectedDate;
string alertText = newAlertTextBox.Text.Trim();
if (alertText != "")
{
EventAlert eventAlert = new EventAlert((string)Application["connectionString"]);
eventAlert.alertDate = alertDate;
eventAlert.eventID = eventID;
eventAlert.alertText = alertText;
eventAlert.Add();
newAlertTextBox.Text = "";
CalendarAlertDate.SelectedDate = DateTime.Now;
PickerAlertDate.SelectedDate = DateTime.Now;
}
SedogoEvent sedogoEvent = new SedogoEvent((string)Session["loggedInUserFullName"], eventID);
sedogoEvent.Update();
Response.Redirect("addEventInvites.aspx?EID=" + eventID.ToString());
}
//===============================================================
// Function: sendInvitesLink_click
//===============================================================
protected void sendInvitesLink_click(object sender, EventArgs e)
{
int eventID = int.Parse(Request.QueryString["EID"]);
StringBuilder invalidEmailAddresses = new StringBuilder();
string errorMessage = "";
StringBuilder successfullyInvitedEmailAddresses = new StringBuilder();
Boolean allInvitesSentOK = true;
string invite1EmailAddress = inviteTextBox1.Text;
string invite2EmailAddress = inviteTextBox2.Text;
string invite3EmailAddress = inviteTextBox3.Text;
string invite4EmailAddress = inviteTextBox4.Text;
string invite5EmailAddress = inviteTextBox5.Text;
string invite6EmailAddress = inviteTextBox6.Text;
string invite7EmailAddress = inviteTextBox7.Text;
string invite8EmailAddress = inviteTextBox8.Text;
string invite9EmailAddress = inviteTextBox9.Text;
string invite10EmailAddress = inviteTextBox10.Text;
string invite11EmailAddress = inviteTextBox11.Text;
string invite12EmailAddress = inviteTextBox12.Text;
string invite13EmailAddress = inviteTextBox13.Text;
string invite14EmailAddress = inviteTextBox14.Text;
string invite15EmailAddress = inviteTextBox15.Text;
string invite16EmailAddress = inviteTextBox16.Text;
string invite17EmailAddress = inviteTextBox17.Text;
string invite18EmailAddress = inviteTextBox18.Text;
string invite19EmailAddress = inviteTextBox19.Text;
string invite20EmailAddress = inviteTextBox20.Text;
string additionalInviteText = additionalInviteTextTextBox.Text;
int currentUserID = int.Parse(Session["loggedInUserID"].ToString());
SedogoUser currentUser = new SedogoUser(Session["loggedInUserFullName"].ToString(), currentUserID);
SedogoEvent currentEvent = new SedogoEvent(Session["loggedInUserFullName"].ToString(), eventID);
string dateString = "";
if (currentEvent.dateType == "D")
{
// Date
dateString = "on " + currentEvent.startDate.ToString("ddd d MMMM yyyy");
}
if (currentEvent.dateType == "R")
{
// Range
dateString = "between " + currentEvent.rangeStartDate.ToString("ddd d MMMM yyyy");
dateString += "and " + currentEvent.rangeEndDate.ToString("ddd d MMMM yyyy");
}
if (currentEvent.dateType == "A")
{
// Birthday
dateString = "before ";
if (currentUser.gender == "M")
{
dateString += "his ";
}
else
{
dateString += "her ";
}
string dateSuffix = "";
switch (currentEvent.beforeBirthday)
{
case 1: case 21: case 31: case 41: case 51: case 61: case 71: case 81: case 91: case 101:
dateSuffix = "st";
break;
case 2: case 22: case 32: case 42: case 52: case 62: case 72: case 82: case 92: case 102:
dateSuffix = "nd";
break;
case 3: case 23: case 33: case 43: case 53: case 63: case 73: case 83: case 93: case 103:
dateSuffix = "rd";
break;
case 4: case 5: case 6: case 7: case 8: case 9: case 10:
case 11: case 12: case 13: case 14: case 15: case 16: case 17: case 18: case 19: case 20:
case 24: case 25: case 26: case 27: case 28: case 29: case 30:
case 34: case 35: case 36: case 37: case 38: case 39: case 40:
case 44: case 45: case 46: case 47: case 48: case 49: case 50:
case 54: case 55: case 56: case 57: case 58: case 59: case 60:
case 64: case 65: case 66: case 67: case 68: case 69: case 70:
case 74: case 75: case 76: case 77: case 78: case 79: case 80:
case 84: case 85: case 86: case 87: case 88: case 89: case 90:
case 94: case 95: case 96: case 97: case 98: case 99: case 100:
case 104: case 105: case 106: case 107: case 108: case 109: case 110:
dateSuffix = "th";
break;
default:
break;
}
dateString += currentEvent.beforeBirthday + dateSuffix + " birthday";
}
if (invite1EmailAddress.Trim() != "")
{
if (SendInviteEmail(eventID, invite1EmailAddress, additionalInviteText, dateString,
currentEvent, currentUser, out errorMessage) == false)
{
allInvitesSentOK = false;
invalidEmailAddresses.AppendLine(invite1EmailAddress + ": " + errorMessage);
}
else
{
successfullyInvitedEmailAddresses.AppendLine(invite1EmailAddress);
}
}
if (invite2EmailAddress.Trim() != "")
{
if (SendInviteEmail(eventID, invite2EmailAddress, additionalInviteText, dateString,
currentEvent, currentUser, out errorMessage) == false)
{
allInvitesSentOK = false;
invalidEmailAddresses.AppendLine(invite2EmailAddress + ": " + errorMessage);
}
else
{
successfullyInvitedEmailAddresses.AppendLine(invite2EmailAddress);
}
}
if (invite3EmailAddress.Trim() != "")
{
if (SendInviteEmail(eventID, invite3EmailAddress, additionalInviteText, dateString,
currentEvent, currentUser, out errorMessage) == false)
{
allInvitesSentOK = false;
invalidEmailAddresses.AppendLine(invite3EmailAddress + ": " + errorMessage);
}
else
{
successfullyInvitedEmailAddresses.AppendLine(invite3EmailAddress);
}
}
if (invite4EmailAddress.Trim() != "")
{
if (SendInviteEmail(eventID, invite4EmailAddress, additionalInviteText, dateString,
currentEvent, currentUser, out errorMessage) == false)
{
allInvitesSentOK = false;
invalidEmailAddresses.AppendLine(invite4EmailAddress + ": " + errorMessage);
}
else
{
successfullyInvitedEmailAddresses.AppendLine(invite4EmailAddress);
}
}
if (invite5EmailAddress.Trim() != "")
{
if (SendInviteEmail(eventID, invite5EmailAddress, additionalInviteText, dateString,
currentEvent, currentUser, out errorMessage) == false)
{
allInvitesSentOK = false;
invalidEmailAddresses.AppendLine(invite5EmailAddress + ": " + errorMessage);
}
else
{
successfullyInvitedEmailAddresses.AppendLine(invite5EmailAddress);
}
}
if (invite6EmailAddress.Trim() != "")
{
if (SendInviteEmail(eventID, invite6EmailAddress, additionalInviteText, dateString,
currentEvent, currentUser, out errorMessage) == false)
{
allInvitesSentOK = false;
invalidEmailAddresses.AppendLine(invite6EmailAddress + ": " + errorMessage);
}
else
{
successfullyInvitedEmailAddresses.AppendLine(invite6EmailAddress);
}
}
if (invite7EmailAddress.Trim() != "")
{
if (SendInviteEmail(eventID, invite7EmailAddress, additionalInviteText, dateString,
currentEvent, currentUser, out errorMessage) == false)
{
allInvitesSentOK = false;
invalidEmailAddresses.AppendLine(invite7EmailAddress + ": " + errorMessage);
}
else
{
successfullyInvitedEmailAddresses.AppendLine(invite7EmailAddress);
}
}
if (invite8EmailAddress.Trim() != "")
{
if (SendInviteEmail(eventID, invite8EmailAddress, additionalInviteText, dateString,
currentEvent, currentUser, out errorMessage) == false)
{
allInvitesSentOK = false;
invalidEmailAddresses.AppendLine(invite8EmailAddress + ": " + errorMessage);
}
else
{
successfullyInvitedEmailAddresses.AppendLine(invite8EmailAddress);
}
}
if (invite9EmailAddress.Trim() != "")
{
if (SendInviteEmail(eventID, invite9EmailAddress, additionalInviteText, dateString,
currentEvent, currentUser, out errorMessage) == false)
{
allInvitesSentOK = false;
invalidEmailAddresses.AppendLine(invite9EmailAddress + ": " + errorMessage);
}
else
{
successfullyInvitedEmailAddresses.AppendLine(invite9EmailAddress);
}
}
if (invite10EmailAddress.Trim() != "")
{
if (SendInviteEmail(eventID, invite10EmailAddress, additionalInviteText, dateString,
currentEvent, currentUser, out errorMessage) == false)
{
allInvitesSentOK = false;
invalidEmailAddresses.AppendLine(invite10EmailAddress + ": " + errorMessage);
}
else
{
successfullyInvitedEmailAddresses.AppendLine(invite10EmailAddress);
}
}
if (invite11EmailAddress.Trim() != "")
{
if (SendInviteEmail(eventID, invite11EmailAddress, additionalInviteText, dateString,
currentEvent, currentUser, out errorMessage) == false)
{
allInvitesSentOK = false;
invalidEmailAddresses.AppendLine(invite11EmailAddress + ": " + errorMessage);
}
else
{
successfullyInvitedEmailAddresses.AppendLine(invite11EmailAddress);
}
}
if (invite12EmailAddress.Trim() != "")
{
if (SendInviteEmail(eventID, invite12EmailAddress, additionalInviteText, dateString,
currentEvent, currentUser, out errorMessage) == false)
{
allInvitesSentOK = false;
invalidEmailAddresses.AppendLine(invite12EmailAddress + ": " + errorMessage);
}
else
{
successfullyInvitedEmailAddresses.AppendLine(invite12EmailAddress);
}
}
if (invite13EmailAddress.Trim() != "")
{
if (SendInviteEmail(eventID, invite13EmailAddress, additionalInviteText, dateString,
currentEvent, currentUser, out errorMessage) == false)
{
allInvitesSentOK = false;
invalidEmailAddresses.AppendLine(invite13EmailAddress + ": " + errorMessage);
}
else
{
successfullyInvitedEmailAddresses.AppendLine(invite13EmailAddress);
}
}
if (invite14EmailAddress.Trim() != "")
{
if (SendInviteEmail(eventID, invite14EmailAddress, additionalInviteText, dateString,
currentEvent, currentUser, out errorMessage) == false)
{
allInvitesSentOK = false;
invalidEmailAddresses.AppendLine(invite14EmailAddress + ": " + errorMessage);
}
else
{
successfullyInvitedEmailAddresses.AppendLine(invite14EmailAddress);
}
}
if (invite15EmailAddress.Trim() != "")
{
if (SendInviteEmail(eventID, invite15EmailAddress, additionalInviteText, dateString,
currentEvent, currentUser, out errorMessage) == false)
{
allInvitesSentOK = false;
invalidEmailAddresses.AppendLine(invite15EmailAddress + ": " + errorMessage);
}
else
{
successfullyInvitedEmailAddresses.AppendLine(invite15EmailAddress);
}
}
if (invite16EmailAddress.Trim() != "")
{
if (SendInviteEmail(eventID, invite16EmailAddress, additionalInviteText, dateString,
currentEvent, currentUser, out errorMessage) == false)
{
allInvitesSentOK = false;
invalidEmailAddresses.AppendLine(invite16EmailAddress + ": " + errorMessage);
}
else
{
successfullyInvitedEmailAddresses.AppendLine(invite16EmailAddress);
}
}
if (invite17EmailAddress.Trim() != "")
{
if (SendInviteEmail(eventID, invite17EmailAddress, additionalInviteText, dateString,
currentEvent, currentUser, out errorMessage) == false)
{
allInvitesSentOK = false;
invalidEmailAddresses.AppendLine(invite17EmailAddress + ": " + errorMessage);
}
else
{
successfullyInvitedEmailAddresses.AppendLine(invite17EmailAddress);
}
}
if (invite18EmailAddress.Trim() != "")
{
if (SendInviteEmail(eventID, invite18EmailAddress, additionalInviteText, dateString,
currentEvent, currentUser, out errorMessage) == false)
{
allInvitesSentOK = false;
invalidEmailAddresses.AppendLine(invite18EmailAddress + ": " + errorMessage);
}
else
{
successfullyInvitedEmailAddresses.AppendLine(invite18EmailAddress);
}
}
if (invite19EmailAddress.Trim() != "")
{
if (SendInviteEmail(eventID, invite19EmailAddress, additionalInviteText, dateString,
currentEvent, currentUser, out errorMessage) == false)
{
allInvitesSentOK = false;
invalidEmailAddresses.AppendLine(invite19EmailAddress + ": " + errorMessage);
}
else
{
successfullyInvitedEmailAddresses.AppendLine(invite19EmailAddress);
}
}
if (invite20EmailAddress.Trim() != "")
{
if (SendInviteEmail(eventID, invite20EmailAddress, additionalInviteText, dateString,
currentEvent, currentUser, out errorMessage) == false)
{
allInvitesSentOK = false;
invalidEmailAddresses.AppendLine(invite20EmailAddress + ": " + errorMessage);
}
else
{
successfullyInvitedEmailAddresses.AppendLine(invite20EmailAddress);
}
}
if (allInvitesSentOK == true)
{
Response.Redirect("addEventSummary.aspx?EID=" + eventID.ToString());
}
else
{
Page.ClientScript.RegisterStartupScript(this.GetType(), "Alert",
"alert(\"Invitations to the following addresses could not be sent: "
+ invalidEmailAddresses.ToString().Replace("\n", ", ").Replace("\r", "") + "\");", true);
inviteTextBox1.Text = "";
inviteTextBox2.Text = "";
inviteTextBox3.Text = "";
inviteTextBox4.Text = "";
inviteTextBox5.Text = "";
inviteTextBox6.Text = "";
inviteTextBox7.Text = "";
inviteTextBox8.Text = "";
inviteTextBox9.Text = "";
inviteTextBox10.Text = "";
inviteTextBox11.Text = "";
inviteTextBox12.Text = "";
inviteTextBox13.Text = "";
inviteTextBox14.Text = "";
inviteTextBox15.Text = "";
inviteTextBox16.Text = "";
inviteTextBox17.Text = "";
inviteTextBox18.Text = "";
inviteTextBox19.Text = "";
inviteTextBox20.Text = "";
}
}
//===============================================================
// Function: CreateXMLContent
//===============================================================
private void CreateXMLContent(XmlTextWriter writer, string searchText)
{
SqlConnection conn = new SqlConnection((string)Application["connectionString"]);
try
{
conn.Open();
SqlCommand cmd = new SqlCommand("", conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "spSelectHomePageEvents";
DbDataReader rdr = cmd.ExecuteReader();
while (rdr.Read())
{
int categoryID = 1;
string dateType = "D";
DateTime startDate = DateTime.MinValue;
DateTime rangeStartDate = DateTime.MinValue;
DateTime rangeEndDate = DateTime.MinValue;
int beforeBirthday = -1;
Boolean privateEvent = false;
Boolean eventAchieved = false;
int userID = -1;
DateTime timelineStartDate = DateTime.MinValue;
DateTime timelineEndDate = DateTime.MinValue;
//*New
string eventPicThumbnail = "";
//
int eventID = int.Parse(rdr["EventID"].ToString());
string eventName = (string)rdr["EventName"];
if (!rdr.IsDBNull(rdr.GetOrdinal("DateType")))
{
dateType = (string)rdr["DateType"];
}
if (!rdr.IsDBNull(rdr.GetOrdinal("StartDate")))
{
startDate = (DateTime)rdr["StartDate"];
}
if (!rdr.IsDBNull(rdr.GetOrdinal("RangeStartDate")))
{
rangeStartDate = (DateTime)rdr["RangeStartDate"];
}
if (!rdr.IsDBNull(rdr.GetOrdinal("RangeEndDate")))
{
rangeEndDate = (DateTime)rdr["RangeEndDate"];
}
eventAchieved = (Boolean)rdr["EventAchieved"];
if (!rdr.IsDBNull(rdr.GetOrdinal("CategoryID")))
{
categoryID = int.Parse(rdr["CategoryID"].ToString());
}
if (!rdr.IsDBNull(rdr.GetOrdinal("BeforeBirthday")))
{
beforeBirthday = int.Parse(rdr["BeforeBirthday"].ToString());
}
privateEvent = (Boolean)rdr["PrivateEvent"];
if (!rdr.IsDBNull(rdr.GetOrdinal("UserID")))
{
userID = int.Parse(rdr["UserID"].ToString());
}
//*New
if (!rdr.IsDBNull(rdr.GetOrdinal("EventPicThumbnail")))
{
eventPicThumbnail = (string)rdr["EventPicThumbnail"];
}
string EUserName = string.Empty;
if (!rdr.IsDBNull(rdr.GetOrdinal("FirstName")))
{
EUserName = (string)rdr["FirstName"];
if (!rdr.IsDBNull(rdr.GetOrdinal("LastName")))
{
EUserName = EUserName + " " + (string)rdr["LastName"];
}
}
//
if (dateType == "D")
{
// Event occurs on a specific date
timelineStartDate = startDate;
timelineEndDate = startDate.AddDays(28); // Add 28 days so it shows up
}
if (dateType == "R")
{
// Event occurs in a date range - use the start date
timelineStartDate = rangeStartDate;
timelineEndDate = rangeEndDate;
TimeSpan ts = timelineEndDate - timelineStartDate;
if (ts.Days < 28)
{
timelineEndDate = timelineStartDate.AddDays(28); // Add 28 days so it shows up
}
startDate = rangeStartDate;
}
if (dateType == "A")
{
// Event occurs before birthday
timelineStartDate = DateTime.Now;
if (userID > 0)
{
SedogoUser user = new SedogoUser("", userID);
if (user.birthday > DateTime.MinValue)
{
timelineEndDate = user.birthday.AddYears(beforeBirthday);
TimeSpan ts = timelineEndDate - DateTime.Now; // timelineStartDate.AddYears(beforeBirthday);
if (ts.Days < 0)
{
// Birthday was in the past
timelineStartDate = DateTime.Now;
timelineEndDate = timelineStartDate.AddDays(28); // Add 28 days so it shows up
// Set start date so event is correctly placed below
startDate = DateTime.Now.AddDays(ts.Days);
}
else if (ts.Days >= 0 && ts.Days < 28)
{
// Birthday is within 28 days - extend the timeline a bit
timelineEndDate = timelineStartDate.AddDays(28); // Add 28 days so it shows up
startDate = timelineStartDate;
}
else
{
startDate = timelineStartDate;
}
}
else
{
timelineEndDate = DateTime.Now.AddDays(28);
}
}
else
{
// If the userID is not set for any reason
timelineEndDate = timelineStartDate.AddMonths(1);
}
}
string timelineColour = "#cd3301";
string category = "";
switch (categoryID)
{
case 1:
timelineColour = "#cd3301";
category = "Personal";
break;
case 2:
timelineColour = "#ff0b0b";
category = "Travel";
break;
case 3:
timelineColour = "#ff6801";
category = "Friends";
break;
case 4:
timelineColour = "#ff8500";
category = "Family";
break;
case 5:
timelineColour = "#d5b21a";
category = "General";
break;
case 6:
timelineColour = "#8dc406";
category = "Health";
break;
case 7:
timelineColour = "#5b980c";
category = "Money";
break;
case 8:
timelineColour = "#079abc";
category = "Education";
break;
case 9:
timelineColour = "#5ab6cd";
category = "Hobbies";
break;
case 10:
timelineColour = "#8A67C1";
category = "Work";
break;
case 11:
timelineColour = "#E54ECF";
category = "Culture";
break;
case 12:
timelineColour = "#A5369C";
category = "Charity";
break;
case 13:
timelineColour = "#A32672";
category = "Green";
break;
case 14:
timelineColour = "#669";
category = "Misc";
break;
}
int messageCount = SedogoEvent.GetCommentCount(eventID);
int trackingUserCount = SedogoEvent.GetTrackingUserCount(eventID);
int memberUserCount = SedogoEvent.GetMemberUserCount(eventID);
//string linkURL = "<a href=\"viewEvent.aspx?EID=" + eventID.ToString() + "\" class=\"modal\" title=\"\">Full details</a>";
//string linkURL = trackingUserCount.ToString() + " following this goal<br/>";
//linkURL = linkURL + memberUserCount.ToString() + " members<br/>";
//linkURL = linkURL + messageCount.ToString() + " comments<br/>";
//linkURL = linkURL + "<a href=\"javascript:openEvent(" + eventID.ToString() + ")\" title=\"\">Full details</a>";
//* New
string linkURL = timelineStartDate.ToString("ddd dd MMM yyyy") + "<br/><br/>";
linkURL = linkURL + memberUserCount.ToString() + " Members<br/>";
linkURL = linkURL + trackingUserCount.ToString() + " Followers<br/>";
linkURL = linkURL + messageCount.ToString() + " Comments<br/>";
linkURL = linkURL + "<a style=\"text-decoration:underline;\" href=\"javascript:openEvent(" + eventID.ToString() + ")\" title=\"\">Goal details</a>";
linkURL = linkURL + " <a style=\"text-decoration:underline;\" href=\"javascript:viewUserTimeline(" + userID.ToString() + ")\" title=\"\">Timeline</a>";
linkURL = linkURL + " <a style=\"text-decoration:underline;\" href=\"javascript:viewProfile(" + userID.ToString() + ")\" title=\"\">Profile</a>";
string ImgLink = "|" + EUserName + " <a href=\"javascript:doSendMessage(" + userID.ToString() + ")\"><img src=\"images/ico_messages.gif\" title=\"Send Message\" alt=\"Send Message\" /></a>";
//string ImgLink = "|" + EUserName;
//*
writer.WriteStartElement("event"); // Time format: Feb 27 2009 09:00:00 GMT
writer.WriteAttributeString("start", timelineStartDate.ToString("MMM dd yyyy HH:mm:ss 'GMT'"));
writer.WriteAttributeString("end", timelineEndDate.ToString("MMM dd yyyy HH:mm:ss 'GMT'"));
writer.WriteAttributeString("isDuration", "true");
writer.WriteAttributeString("title", eventName);
var _event = new SedogoEvent(string.Empty, eventID);
//* New
if (eventPicThumbnail == "")
{
writer.WriteAttributeString("image", "./images/eventThumbnailBlank.png");
}
else
{
writer.WriteAttributeString("image", ResolveUrl(ImageHelper.GetRelativeImagePath(_event.eventID, _event.eventGUID, ImageType.EventThumbnail)));
}
//writer.WriteAttributeString("image", "http://simile.mit.edu/images/csail-logo.gif");
//*
writer.WriteAttributeString("color", timelineColour);
writer.WriteAttributeString("category", category);
writer.WriteString(linkURL + " <br />" + ImgLink);
writer.WriteEndElement();
}
rdr.Close();
}
catch (Exception ex)
{
ErrorLog errorLog = new ErrorLog();
errorLog.WriteLog("timelineHomePageXML", "Page_Load", ex.Message, logMessageLevel.errorMessage);
//throw ex;
}
finally
{
conn.Close();
}
}
//===============================================================
// Function: Page_Load
//===============================================================
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
int eventID = int.Parse(Request.QueryString["EID"]);
int userID = -1;
string loggedInUserName = "";
if (Session["loggedInUserID"] != null)
{
userID = int.Parse(Session["loggedInUserID"].ToString());
loggedInUserName = Session["loggedInUserFullName"].ToString();
}
sidebarControl.userID = userID;
if (userID > 0)
{
SedogoUser user = new SedogoUser(Session["loggedInUserFullName"].ToString(), userID);
sidebarControl.user = user;
bannerAddFindControl.userID = userID;
}
else
{
}
SedogoEvent sedogoEvent = new SedogoEvent(loggedInUserName, eventID);
eventTitleLabel.Text = sedogoEvent.eventName;
if (sedogoEvent.privateEvent == true)
{
privateIcon.Visible = true;
}
if (sedogoEvent.deleted == true)
{
Response.Redirect("~/profile.aspx");
}
pageTitleUserName.Text = sedogoEvent.eventName + " pictures : Sedogo : Create your future and connect with others to make it happen";
string timelineColour = "#cd3301";
switch (sedogoEvent.categoryID)
{
case 1:
timelineColour = "#cd3301";
break;
case 2:
timelineColour = "#ff0b0b";
break;
case 3:
timelineColour = "#ff6801";
break;
case 4:
timelineColour = "#ff8500";
break;
case 5:
timelineColour = "#d5b21a";
break;
case 6:
timelineColour = "#8dc406";
break;
case 7:
timelineColour = "#5b980c";
break;
case 8:
timelineColour = "#079abc";
break;
case 9:
timelineColour = "#5ab6cd";
break;
case 10:
timelineColour = "#8a67c1";
break;
case 11:
timelineColour = "#e54ecf";
break;
case 12:
timelineColour = "#a5369c";
break;
case 13:
timelineColour = "#a32672";
break;
}
pageBannerBarDiv.Style.Add("background-color", timelineColour);
uploadEventImage.Visible = false;
if (userID > 0)
{
if (sedogoEvent.userID != userID)
{
// Viewing someone elses event
SedogoUser eventUser = new SedogoUser(Session["loggedInUserFullName"].ToString(), sedogoEvent.userID);
goalOwnerNameLabel.Text = eventUser.firstName + " " + eventUser.lastName + "'s goal albums";
}
else
{
// Viewing own event
addPictureLiteral.Text = "var url = 'addGoalPicture.aspx?EID=" + eventID.ToString() + "';";
uploadEventImage.Visible = true;
editPicsButton.Visible = true;
goalOwnerNameLabel.Text = "My goal albums";
}
}
else
{
// Setup the window for a user who is not registered/logged in
if (sedogoEvent.privateEvent == true)
{
// Viewing private events is not permitted
Response.Redirect("profile.aspx");
}
goalOwnerNameLabel.Text = "My goal albums";
}
PopulateImages(eventID, sedogoEvent.userID);
}
}
//===============================================================
// Function: PopulateImages
//===============================================================
private void PopulateImages(int eventID, int userID)
{
DateTime loopDate = DateTime.MinValue;
Boolean firstRow = true;
int columnNumber = 1;
SqlConnection conn = new SqlConnection((string)Application["connectionString"]);
try
{
conn.Open();
SqlCommand cmd = new SqlCommand("", conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "spSelectEventPictureList";
cmd.Parameters.Add("@EventID", SqlDbType.Int).Value = eventID;
DbDataReader rdr = cmd.ExecuteReader();
while (rdr.Read())
{
int eventPictureID = int.Parse(rdr["EventPictureID"].ToString());
int postedByUserID = int.Parse(rdr["PostedByUserID"].ToString());
string imageFilename = "";
if (!rdr.IsDBNull(rdr.GetOrdinal("ImageFilename")))
{
imageFilename = (string)rdr["ImageFilename"];
}
string imagePreview = "";
if (!rdr.IsDBNull(rdr.GetOrdinal("ImagePreview")))
{
imagePreview = (string)rdr["ImagePreview"];
}
string imageThumbnail = "";
if (!rdr.IsDBNull(rdr.GetOrdinal("ImageThumbnail")))
{
imageThumbnail = (string)rdr["ImageThumbnail"];
}
string caption = "";
if (!rdr.IsDBNull(rdr.GetOrdinal("Caption")))
{
caption = (string)rdr["Caption"];
}
DateTime createdDate = (DateTime)rdr["CreatedDate"];
if (createdDate.DayOfYear != loopDate.DayOfYear)
{
if (firstRow == false)
{
imagesPlaceHolder.Controls.Add(new LiteralControl("<div style=\"clear: both;\" />"));
}
imagesPlaceHolder.Controls.Add(new LiteralControl("<i><span style=\"font-size:80%\">" + createdDate.ToString("ddd d MMMM yyyy") + "</span></i><br/>"));
firstRow = false;
}
loopDate = createdDate;
imagesPlaceHolder.Controls.Add(new LiteralControl("<div style=\"width:110px; float:left; margin:0 10px 20px 0\">"));
imagesPlaceHolder.Controls.Add(new LiteralControl("<a href=\"eventPicDetails.aspx?EID=" + eventID.ToString()
+ "&EPID=" + eventPictureID.ToString() + "\"><img src=\"/assets/eventPics/" + imageThumbnail + "\"/></a>"));
if( caption != "" )
{
if (caption.Length > 30)
{
caption = caption.Substring(0, 30) + "...";
}
imagesPlaceHolder.Controls.Add(new LiteralControl("<br/>" + caption));
}
imagesPlaceHolder.Controls.Add(new LiteralControl("</div>"));
if ((columnNumber % 6) == 0)
{
imagesPlaceHolder.Controls.Add(new LiteralControl("<div style=\"clear: both;\" />"));
}
columnNumber++;
}
rdr.Close();
if( userID > 0 )
{
columnNumber = 1;
SqlCommand cmdEventsWithPics = new SqlCommand("", conn);
cmdEventsWithPics.CommandType = CommandType.StoredProcedure;
cmdEventsWithPics.CommandText = "spSelectEventsWithPicturesList";
cmdEventsWithPics.Parameters.Add("@UserID", SqlDbType.Int).Value = userID;
DbDataReader rdrEventsWithPics = cmdEventsWithPics.ExecuteReader();
while (rdrEventsWithPics.Read())
{
int loopEventID = int.Parse(rdrEventsWithPics["EventID"].ToString());
SedogoEvent loopEvent = new SedogoEvent("", loopEventID);
string timelineColour = "#cd3301";
switch (loopEvent.categoryID)
{
case 1:
timelineColour = "#cd3301";
break;
case 2:
timelineColour = "#ff0b0b";
break;
case 3:
timelineColour = "#ff6801";
break;
case 4:
timelineColour = "#ff8500";
break;
case 5:
timelineColour = "#d5b21a";
break;
case 6:
timelineColour = "#8dc406";
break;
case 7:
timelineColour = "#5b980c";
break;
case 8:
timelineColour = "#079abc";
break;
case 9:
timelineColour = "#5ab6cd";
break;
case 10:
timelineColour = "#8a67c1";
break;
case 11:
timelineColour = "#e54ecf";
break;
case 12:
timelineColour = "#a5369c";
break;
case 13:
timelineColour = "#a32672";
break;
}
albumnsPlaceHolder.Controls.Add(new LiteralControl("<div style=\"width:150px; float:left; margin:0 10px 10px 0\" "));
albumnsPlaceHolder.Controls.Add(new LiteralControl("onMouseOver=\"setColor('colourBar_" + loopEventID.ToString() + "','" + timelineColour + "'); "
+ "setColor('colourBar2_" + loopEventID.ToString() + "','#EEEEEE');\" "));
albumnsPlaceHolder.Controls.Add(new LiteralControl("onMouseOut=\"setColor('colourBar_" + loopEventID.ToString() + "','#FFFFFF');"
+ "setColor('colourBar2_" + loopEventID.ToString() + "','#FFFFFF');\" "));
albumnsPlaceHolder.Controls.Add(new LiteralControl("> "));
string displayName = loopEvent.eventName;
if (displayName != "")
{
if (displayName.Length > 30)
{
displayName = displayName.Substring(0, 30) + "...";
}
}
albumnsPlaceHolder.Controls.Add(new LiteralControl("<div id=\"colourBar2_" + loopEventID.ToString() + "\" width=\"150px\">"));
albumnsPlaceHolder.Controls.Add(new LiteralControl("<a href=\"morePictures.aspx?EID=" + loopEventID.ToString() + "\">" + displayName + "</a>"));
albumnsPlaceHolder.Controls.Add(new LiteralControl("</div>"));
albumnsPlaceHolder.Controls.Add(new LiteralControl("<a href=\"morePictures.aspx?EID=" + loopEventID.ToString()
+ "\"><img width=\"100\" src=\"/assets/eventPics/" + loopEvent.eventPicPreview + "\"/></a>"));
albumnsPlaceHolder.Controls.Add(new LiteralControl("<span id=\"colourBar_" + loopEventID.ToString() + "\"><img src=\"/images/1x1trans.gif\" height=\"6px\" width=\"100px\" ></span> "));
if (loopEvent.eventAchieved == true)
{
albumnsPlaceHolder.Controls.Add(new LiteralControl("<a href=\"morePictures.aspx?EID=" + loopEventID.ToString()
+ "\">Achieved <img src=\"images/acceptachieve.gif\" /></a>"));
}
albumnsPlaceHolder.Controls.Add(new LiteralControl("</div>"));
if ((columnNumber % 4) == 0)
{
albumnsPlaceHolder.Controls.Add(new LiteralControl("<div style=\"clear: both;\" />"));
}
columnNumber++;
}
rdrEventsWithPics.Close();
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
conn.Close();
}
}
//===============================================================
// Function: PopulateGoalNames
//===============================================================
private void PopulateGoalNames(string letterFilter)
{
SqlConnection conn = new SqlConnection((string)Application["connectionString"]);
try
{
conn.Open();
SqlCommand cmd = new SqlCommand("", conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "spSelectEventListByFirstLetter";
cmd.Parameters.Add("@LetterFilter", SqlDbType.Char, 1).Value = letterFilter;
DbDataReader rdr = cmd.ExecuteReader();
if (rdr.HasRows == true)
{
while (rdr.Read())
{
string eventName = "";
int eventID = int.Parse(rdr["EventID"].ToString());
if (!rdr.IsDBNull(rdr.GetOrdinal("EventName")))
{
eventName = (string)rdr["EventName"];
}
string eventPicThumbnail = "";
if (!rdr.IsDBNull(rdr.GetOrdinal("EventPicThumbnail")))
{
eventPicThumbnail = (string)rdr["EventPicThumbnail"];
}
//SELECT , , DateType, StartDate, RangeStartDate, RangeEndDate,
//BeforeBirthday, CategoryID, TimezoneID, EventAchieved, PrivateEvent, CreatedFromEventID,
//EventDescription, EventVenue, MustDo,
//EventPicFilename, , EventPicPreview,
//CreatedDate, CreatedByFullName, LastUpdatedDate, LastUpdatedByFullName
Literal userLink = new Literal();
userLink.Text = "<table><tr><td width=\"50\">"; // <div class=\"directory\">
if (eventPicThumbnail == "")
{
userLink.Text += "<img src=\"../images/1x1trans.gif\" width=\"50\" />";
//userLink.Text += "<img src=\"../images/goalimage_small.jpg\" />";
}
else
{
var _event = new SedogoEvent(string.Empty, eventID);
eventPicThumbnail = ResolveUrl(ImageHelper.GetRelativeImagePath(_event.eventID, _event.eventGUID, ImageType.EventThumbnail));
userLink.Text += "<div ><img src=\"" + eventPicThumbnail + "\" width=\"50\" /></div>";
}
userLink.Text += "</td><td> <a class=\"event\" href=\"/viewEvent.aspx?EID=" + eventID + "\">" + eventName + "</a></td>";
userLink.Text += "</tr></table>";
goalPlaceHolder.Controls.Add(userLink);
}
noGoalsWithThisLetterDiv.Visible = false;
}
else
{
noGoalsWithThisLetterDiv.Visible = true;
}
rdr.Close();
}
catch (Exception ex)
{
throw ex;
}
finally
{
conn.Close();
}
}
//===============================================================
// Function: trackedEventsRepeater_ItemDataBound
//===============================================================
protected void trackedEventsRepeater_ItemDataBound(object sender, RepeaterItemEventArgs e)
{
if (e.Item.DataItem != null &&
(e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem))
{
DataRowView row = e.Item.DataItem as DataRowView;
int eventID = int.Parse(row["EventID"].ToString());
SedogoEvent sedogoEvent = new SedogoEvent(Session["loggedInUserFullName"].ToString(), eventID);
HyperLink eventNameLabel = e.Item.FindControl("eventNameLabel") as HyperLink;
eventNameLabel.NavigateUrl = "viewEvent.aspx?EID=" + row["EventID"].ToString();
eventNameLabel.Text = row["EventName"].ToString();
HyperLink userNameLabel = e.Item.FindControl("userNameLabel") as HyperLink;
userNameLabel.Text = row["FirstName"].ToString() + " " + row["LastName"].ToString();
userNameLabel.NavigateUrl = "userTimeline.aspx?UID=" + sedogoEvent.userID.ToString();
Image eventImage = e.Item.FindControl("eventImage") as Image;
string eventPicThumbnail = row["EventPicThumbnail"].ToString();
if (eventPicThumbnail == "")
{
eventImage.ImageUrl = "~/images/eventThumbnailBlank.png";
}
else
{
var _event = new SedogoEvent(string.Empty, eventID);
eventImage.ImageUrl = ImageHelper.GetRelativeImagePath(_event.eventID, _event.eventGUID, ImageType.EventThumbnail);
}
}
}
//===============================================================
// Function: Page_Load
//===============================================================
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
int eventID = int.Parse(Request.QueryString["EID"]);
SedogoEvent sedogoEvent = new SedogoEvent(Session["loggedInUserFullName"].ToString(), eventID);
eventNameLabel.Text = sedogoEvent.eventName;
eventNameLabel2.Text = sedogoEvent.eventName;
SedogoUser eventOwner = new SedogoUser(Session["loggedInUserFullName"].ToString(), sedogoEvent.userID);
string dateString = "";
DateTime startDate = sedogoEvent.startDate;
MiscUtils.GetDateStringStartDate(eventOwner, sedogoEvent.dateType, sedogoEvent.rangeStartDate,
sedogoEvent.rangeEndDate, sedogoEvent.beforeBirthday, ref dateString, ref startDate);
CalendarAlertDate.SelectedDate = DateTime.Now;
PickerAlertDate.SelectedDate = DateTime.Now;
alertDatePickList.Attributes.Add("onchange", "setReminderDate()");
DateTime d = DateTime.Now.AddDays(1);
Date1DValue1.Text = d.Year.ToString() + "," + (d.Month-1).ToString() + "," + d.Day.ToString();
Date1DValue2.Text = d.Year.ToString() + "," + (d.Month - 1).ToString() + "," + d.Day.ToString();
d = DateTime.Now.AddDays(7);
Date1WValue1.Text = d.Year.ToString() + "," + (d.Month - 1).ToString() + "," + d.Day.ToString();
Date1WValue2.Text = d.Year.ToString() + "," + (d.Month - 1).ToString() + "," + d.Day.ToString();
d = DateTime.Now.AddMonths(1);
Date1MValue1.Text = d.Year.ToString() + "," + (d.Month - 1).ToString() + "," + d.Day.ToString();
Date1MValue2.Text = d.Year.ToString() + "," + (d.Month - 1).ToString() + "," + d.Day.ToString();
d = DateTime.Now.AddMonths(3);
Date3MValue1.Text = d.Year.ToString() + "," + (d.Month - 1).ToString() + "," + d.Day.ToString();
Date3MValue2.Text = d.Year.ToString() + "," + (d.Month - 1).ToString() + "," + d.Day.ToString();
d = DateTime.Now.AddMonths(6);
Date6MValue1.Text = d.Year.ToString() + "," + (d.Month - 1).ToString() + "," + d.Day.ToString();
Date6MValue2.Text = d.Year.ToString() + "," + (d.Month - 1).ToString() + "," + d.Day.ToString();
d = DateTime.Now.AddYears(1);
Date1YValue1.Text = d.Year.ToString() + "," + (d.Month - 1).ToString() + "," + d.Day.ToString();
Date1YValue2.Text = d.Year.ToString() + "," + (d.Month - 1).ToString() + "," + d.Day.ToString();
SetFocus(eventPicFileUpload);
}
}
//===============================================================
// Function: Page_Load
//===============================================================
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
int eventID = int.Parse(Request.QueryString["EID"]);
int userID = -1;
string loggedInUserName = "";
if (Session["loggedInUserID"] != null)
{
userID = int.Parse(Session["loggedInUserID"].ToString());
loggedInUserName = Session["loggedInUserFullName"].ToString();
}
sidebarControl.userID = userID;
if (userID > 0)
{
SedogoUser user = new SedogoUser(Session["loggedInUserFullName"].ToString(), userID);
sidebarControl.user = user;
bannerAddFindControl.userID = userID;
}
else
{
}
SedogoEvent sedogoEvent = new SedogoEvent(loggedInUserName, eventID);
eventTitleLabel.Text = sedogoEvent.eventName;
if (sedogoEvent.privateEvent == true)
{
privateIcon.Visible = true;
}
if (sedogoEvent.deleted == true)
{
Response.Redirect("~/profile.aspx");
}
pageTitleUserName.Text = sedogoEvent.eventName + " pictures : Sedogo : Create your future and connect with others to make it happen";
string timelineColour = "#cd3301";
switch (sedogoEvent.categoryID)
{
case 1:
timelineColour = "#cd3301";
break;
case 2:
timelineColour = "#ff0b0b";
break;
case 3:
timelineColour = "#ff6801";
break;
case 4:
timelineColour = "#ff8500";
break;
case 5:
timelineColour = "#d5b21a";
break;
case 6:
timelineColour = "#8dc406";
break;
case 7:
timelineColour = "#5b980c";
break;
case 8:
timelineColour = "#079abc";
break;
case 9:
timelineColour = "#5ab6cd";
break;
case 10:
timelineColour = "#8a67c1";
break;
case 11:
timelineColour = "#e54ecf";
break;
case 12:
timelineColour = "#a5369c";
break;
case 13:
timelineColour = "#a32672";
break;
}
pageBannerBarDiv.Style.Add("background-color", timelineColour);
PopulateImages(eventID, userID);
}
}
