//===============================================================
// 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();
}
}
