private static PhotoAlbum[] Fetch(int? id, string username, string name, eAccess? access)
{
using (SqlConnection conn = Config.DB.Open())
{
SqlDataReader reader = SqlHelper.ExecuteReader(conn,
"FetchPhotoAlbums",
id, username, name, access);
List<PhotoAlbum> photoAlbums = new List<PhotoAlbum>();
while (reader.Read())
{
PhotoAlbum photoAlbum = new PhotoAlbum();
photoAlbum.id = (int)reader["ID"];
photoAlbum.username = (string) reader["Username"];
photoAlbum.name = (string) reader["Name"];
photoAlbum.access = (eAccess) reader["Access"];
photoAlbum.coverPhotoID = reader["CoverPhotoID"] != DBNull.Value ? (int?) reader["CoverPhotoID"] : null;
photoAlbums.Add(photoAlbum);
}
return photoAlbums.ToArray();
}
}
protected void btnCreateEditPhotoAlbum_Click(object sender, EventArgs e)
{
string photoAlbumName = txtPhotoAlbumName.Text.Trim();
if (photoAlbumName.Length == 0)
{
lblError.Text = "Please specify album name!".Translate();
return;
}
PhotoAlbum photoAlbum = null;
if (!EditedPhotoAlbumID.HasValue)
photoAlbum = new PhotoAlbum(CurrentUserSession.Username)
{
Name = photoAlbumName,
Access = (PhotoAlbum.eAccess)Convert.ToInt32(ddPhotoAlbumAccess.SelectedValue)
};
else
{
photoAlbum = PhotoAlbum.Fetch(EditedPhotoAlbumID.Value);
photoAlbum.Name = photoAlbumName;
photoAlbum.Access = (PhotoAlbum.eAccess)Convert.ToInt32(ddPhotoAlbumAccess.SelectedValue);
}
photoAlbum.Save();
populateDDPhotoAlbums();
ddPhotoAlbums.SelectedValue = photoAlbum.ID.ToString();
pnlManagePhotos.Visible = true;
loadPhotos = true;
EditedPhotoAlbumID = null;
}