private void ShowErrorMessage(String message)
{
Label LBError = LVAlbum.FindControl("LBError") as Label;
if (LBError == null)
{
return;
}
LBError.Visible = true;
LBError.Text = message;
Control container = LVAlbum.FindControl("photo_container");
container.Visible = false;
}
private void ShowContainer()
{
Control container = LVAlbum.FindControl("photo_container");
container.Visible = true;
}
protected void Page_Load(object sender, EventArgs e)
{
if (!Utils.userIsAuthenticated())
{
return;
}
Label LBAlbumName = LVAlbum.FindControl("LBAlbumName") as Label;
Label LBNrPhotos = LVAlbum.FindControl("LBNrPhotos") as Label;
Control photo_container = LVAlbum.FindControl("photo_container");
if (Request.Params["id"] == null || Request.Params["id"].Length == 0)
{
this.ShowErrorMessage("Invalid album id");
return;
}
else
{
String albumId = Request.Params["id"];
String currentUserId = Utils.GetCurrentUserUid();
Boolean isAuthorizedUser = false;
Boolean authorizationChecked = false;
String albumName = null;
if (!AlbumModel.Exists(albumId))
{
this.ShowErrorMessage("This album doesn't exist");
return;
}
String query = " Select Albums.Name, Photos.Id, Photos.URL, Posts.Id'PostId' FROM " +
" Photos join Photos_Albums on Photos.Id = Photos_Albums.PhotoID " +
" join Albums on Photos_Albums.AlbumID = Albums.ID " +
" join Posts on Photos.Id = Posts.PhotoID " +
"where Photos_Albums.AlbumID = @albumId";
SqlConnection con = new SqlConnection(@"Data Source=GHGRLH2\SQLEXPRESS;Initial Catalog=aspnetdb;Integrated Security=True");
try
{
con.Open();
SqlCommand cmd = new SqlCommand(query, con);
cmd.Parameters.AddWithValue("albumId", albumId);
SqlDataReader reader = cmd.ExecuteReader();
int nrPhotos = 0;
while (reader.Read())
{
String url = reader["URL"].ToString();
String postId = reader["PostId"].ToString();
String photoId = reader["Id"].ToString();
if (albumName == null)
{
albumName = reader["Name"].ToString();
LBAlbumName.Text = albumName;
}
if (albumName != null && authorizationChecked == false)
{
isAuthorizedUser = User.IsInRole("Admin") || AlbumModel.Exists(currentUserId, albumName);
authorizationChecked = true;
}
HtmlGenericControl albumItem = new HtmlGenericControl("DIV");
albumItem.Attributes["class"] = "album-item";
HtmlImage img = new HtmlImage();
img.Src = "/Images/" + url;
img.Attributes["class"] = "album-img";
albumItem.Controls.Add(img);
if (authorizationChecked == true && isAuthorizedUser)
{
HtmlGenericControl buttonsContainer = new HtmlGenericControl("DIV");
buttonsContainer.Attributes["class"] = "album-btn-container";
LinkButton showPostBtn = new LinkButton();
showPostBtn.Command += new CommandEventHandler(ShowPostBtn_Click);
showPostBtn.CommandArgument = postId;
showPostBtn.Text = "Show post";
buttonsContainer.Controls.Add(showPostBtn);
LinkButton deletePhotoBtn = new LinkButton();
deletePhotoBtn.Command += new CommandEventHandler(DeletePhotoBtn_Click);
deletePhotoBtn.CommandArgument = photoId;
deletePhotoBtn.Text = "Delete photo";
buttonsContainer.Controls.Add(deletePhotoBtn);
LinkButton deletePostBtn = new LinkButton();
deletePostBtn.Command += new CommandEventHandler(DeleteBtn_Click);
deletePostBtn.CommandArgument = postId;
deletePostBtn.Text = "Delete entire post";
buttonsContainer.Controls.Add(deletePostBtn);
albumItem.Controls.Add(buttonsContainer);
}
photo_container.Controls.Add(albumItem);
nrPhotos += 1;
}
LBNrPhotos.Text = "Photos: " + nrPhotos.ToString();
}
catch (Exception ex)
{
this.ShowErrorMessage("An error occured while trying to retrieve the photos from this album:" + ex.Message);
return;
}
}
this.ShowContainer();
}