//=============================================================== // 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) { 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(); } int eventPictureID = int.Parse(Request.QueryString["EPID"].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); SedogoEventPicture eventPic = new SedogoEventPicture((string)Application["connectionString"], eventPictureID); eventImage.ImageUrl = "~/assets/eventPics/" + eventPic.eventImagePreview; GlobalData gd = new GlobalData(""); string imageFile = gd.GetStringValue("FileStoreFolder") + @"\eventPics\" + eventPic.eventImagePreview; //FileInfo imageFileInfo = new FileInfo(imageFile); System.Drawing.Image sourceImage = System.Drawing.Image.FromFile(imageFile); if (sourceImage.Height > 370) { eventImage.Height = 370; } captionLabel.Text = eventPic.caption; /* if (userID > 0) { SedogoEvent sedogoEvent = new SedogoEvent("", eventID); if (sedogoEvent.userID != userID) { // Viewing someone elses event captionTextBox.Visible = false; saveButton.Visible = false; deleteButton.Visible = false; } else { // Viewing own event captionLabel.Text = "Caption: "; captionTextBox.Visible = true; captionTextBox.Text = eventPic.caption; saveButton.Visible = true; deleteButton.Visible = true; deleteButton.Attributes.Add("onclick", "if(confirm('Are you sure you want to delete this picture?')){document.forms[0].target = '_top';return true;}else{return false}"); } } else { // Not logged in captionLabel.Text = eventPic.caption; captionTextBox.Visible = false; saveButton.Visible = false; deleteButton.Visible = false; } */ } }
//=============================================================== // Function: CreateGoalPicPreviews // Description: //=============================================================== public static int CreateGoalPicPreviews(string filename, int eventID, string loggedInContactName, int postedByUserID, string caption) { int returnStatus = -1; GlobalData gd = new GlobalData(""); int thumbnailSize = gd.GetIntegerValue("ThumbnailSize");//100; int previewSize = gd.GetIntegerValue("PreviewSize");//500; string fileStoreFolder = gd.GetStringValue("FileStoreFolder"); string fileStoreFolderTemp = fileStoreFolder + "\\temp"; string fileStoreFolderProfilePics = fileStoreFolder + "\\eventPics"; string thumbnailFileName = ""; string previewFileName = ""; int thumbnailStatus = GenerateThumbnail(fileStoreFolderTemp, filename, thumbnailSize, thumbnailSize, previewSize, previewSize, out thumbnailFileName, out previewFileName); if (thumbnailStatus > 0) { // Move the thumbnails to the /profilePics folder and update the user string destFilename = MiscUtils.GetUniqueFileName(Path.Combine(fileStoreFolderProfilePics, filename)); string destThumbnailFilename = MiscUtils.GetUniqueFileName(Path.Combine(fileStoreFolderProfilePics, thumbnailFileName)); string destPreviewFilename = MiscUtils.GetUniqueFileName(Path.Combine(fileStoreFolderProfilePics, previewFileName)); File.Move(Path.Combine(fileStoreFolderTemp, filename), destFilename); File.Move(Path.Combine(fileStoreFolderTemp, thumbnailFileName), destThumbnailFilename); File.Move(Path.Combine(fileStoreFolderTemp, previewFileName), destPreviewFilename); SedogoEventPicture pic = new SedogoEventPicture(loggedInContactName); pic.eventID = eventID; pic.postedByUserID = postedByUserID; pic.eventImageFilename = Path.GetFileName(destFilename); pic.eventImagePreview = Path.GetFileName(destPreviewFilename); pic.eventImageThumbnail = Path.GetFileName(destThumbnailFilename); pic.caption = caption; pic.Add(); returnStatus = pic.eventPictureID; } return returnStatus; }
//=============================================================== // 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; columnNumber = 1; } loopDate = createdDate; var @event = new SedogoEvent(string.Empty, eventID); var eventPicture = new SedogoEventPicture(string.Empty, eventPictureID); // PD 3/12/10 - Removed this because goal image was being repeated on all comments // instead of showing correct image imageThumbnail = ResolveUrl(ImageHelper.GetRelativeImagePath(eventPicture.eventPictureID, @event.eventGUID, ImageType.EventPictureThumbnailSmall)); //imageThumbnail = "assets/eventPics/" + imageThumbnail; 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 + "&EPID=" + eventPictureID + "\"><img src=\"" + 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>")); // PD 3/12/10 - Removed this because goal image was being repeated on all comments // instead of showing correct image //albumnsPlaceHolder.Controls.Add(new LiteralControl("<a href=\"morePictures.aspx?EID=" + loopEventID.ToString() // + "\"><img width=\"100\" src=\"/assets/eventPics/" + loopEvent.eventPicThumbnail + "\"/></a>")); albumnsPlaceHolder.Controls.Add(new LiteralControl("<a href=\"morePictures.aspx?EID=" + loopEventID + "\"><img width=\"100\" src=\"" + ResolveUrl(ImageHelper.GetRelativeImagePath(loopEvent.eventID, loopEvent.eventGUID, ImageType.EventPreview)) + "\"/></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(); } }