<%@ Page Title="Photos" Language="C#" MasterPageFile="~/MasterPages/FrontEnd.master" AutoEventWireup="true" CodeFile="Default.aspx.cs" Inherits="_Default" %>

<asp:Content ID="Content1" ContentPlaceHolderID="head" Runat="Server">
</asp:Content>
<asp:Content ID="Content2" ContentPlaceHolderID="cpMainContent" Runat="Server">
    <asp:UpdatePanel runat="server">
        <ContentTemplate>
            <header>Photos</header>
            <section id ="PageContent">
        
                <asp:DropDownList ID="DropDownList1" runat="server" AutoPostBack="True" 
                    DataSourceID="EntityDataSource1" DataTextField="Name" DataValueField="Id" Width="200px">
                </asp:DropDownList>
                

                <asp:ListView ID="ListView1" runat="server" 
                    DataKeyNames="Id" 
                    DataSourceID="EntityDataSource2" 
                    ItemType="SmileCycleModel.Picture" 
                    OnDataBound="ListView1_DataBound">
                    
                    <EmptyDataTemplate>
                        No data was returned.
                    </EmptyDataTemplate>

                    <ItemTemplate>
                        <li>
                            ImageUrl:
                            <asp:Image ID="Image1" runat="server" ImageUrl='<%# Item.ImageUrl %>' ToolTip='<%# Item.ToolTip %>'/>

                            Description:
                            <asp:Label ID="DescriptionLabel" runat="server" Text='<%# Item.Description %>' />
                            <br />
                    
                        </li>
                    </ItemTemplate>

                    <LayoutTemplate>
                        <ul class="ItemContainer">
                            <li runat="server" id="itemPlaceholder" />
                        </ul>
                        <div style="clear:both">
                            <asp:DataPager ID="DataPager1" runat="server" PageSize ="3">
                                <Fields>
                                    <asp:NextPreviousPagerField ButtonType="Button" ShowFirstPageButton="True" ShowLastPageButton="True" />
                                </Fields>
                            </asp:DataPager>
                        </div>
                    </LayoutTemplate>
           
                </asp:ListView>

                <br />
                <br />
                <asp:HyperLink ID="EditLink" Text="Edit Photo Album" runat="server" />

                <asp:EntityDataSource ID="EntityDataSource2" runat="server" 
                    AutoGenerateWhereClause="True" ConnectionString="name=SmileCycleEntities" 
                    DefaultContainerName="SmileCycleEntities" EnableFlattening="False" 
                    EntitySetName="Pictures" Where="">
                    <WhereParameters>
                        <asp:ControlParameter ControlID="DropDownList1" Name="PhotoAlbumID" PropertyName="SelectedValue" Type="Int32" />
                    </WhereParameters>
                </asp:EntityDataSource>
                <asp:EntityDataSource ID="EntityDataSource1" runat="server" 
                    ConnectionString="name=SmileCycleEntities" 
                    DefaultContainerName="SmileCycleEntities" EnableFlattening="False" 
                    EntitySetName="PhotoAlbums" Select="it.[Id], it.[Name]">
                </asp:EntityDataSource>
            </section>
        </ContentTemplate>
    </asp:UpdatePanel>
</asp:Content>

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using SmileCycleModel;

public partial class _Default : BasePage
{
    protected void Page_Load(object sender, EventArgs e)
    {
        
    }

    protected void ListView1_DataBound(object sender, EventArgs e)
    {
        if (!string.IsNullOrEmpty(DropDownList1.SelectedValue))
        {
            int photoAlbumId = Convert.ToInt32(DropDownList1.SelectedValue);
            using (SmileCycleEntities myEntities = new SmileCycleEntities())
            {
                string photoAlbumOwner = (from p in myEntities.PhotoAlbums
                                          where p.Id == photoAlbumId
                                          select p.UserName).Single();

                if (User.Identity.IsAuthenticated && (User.Identity.Name == photoAlbumOwner || User.IsInRole("Managers")))
                {
                    EditLink.NavigateUrl = string.Format(
                        "~/ManagePhotoAlbum.aspx?PhotoAlbumId={0}", DropDownList1.SelectedValue);
                    EditLink.Visible = true;
                }
                else
                {
                    EditLink.Visible = false;
                }
            }
        }
        else
        {
            EditLink.Visible = false; 
        }
    }
}