public static List <Z.Photo> ZGetPhotos(int AlbumID) { bool filter = !(HttpContext.Current.User.IsInRole("Friends") || HttpContext.Current.User.IsInRole("Administrators")); var photoDB = new Z.PhotoDataContext(); var qPhotos = photoDB .Photos .Where(p => p.AlbumID == AlbumID) .Where(p => p.Album.IsPublic == filter || p.Album.IsPublic == true) .Select(p => new { p.PhotoID, p.AlbumID, p.Caption }); var photos = new List <Z.Photo>(); foreach (var p in qPhotos) { photos.Add(new Z.Photo() { PhotoID = p.PhotoID, AlbumID = p.AlbumID, Caption = p.Caption }); } return(photos); }
public static void ZAddAlbum(string _Caption, bool _IsPublic) { var photosDB = new Z.PhotoDataContext(); var a = new Z.Album() { Caption = _Caption, IsPublic = _IsPublic }; photosDB.Albums.InsertOnSubmit(a); photosDB.SubmitChanges(); }
public static void ZAddPhoto(int _AlbumID, string _Caption, byte[] _BytesOriginal) { var photosDB = new Z.PhotoDataContext(); var p = new Z.Photo() { AlbumID = _AlbumID, Caption = _Caption, BytesOriginal = _BytesOriginal, BytesFull = ResizeImageFile(_BytesOriginal, 600), BytesPoster = ResizeImageFile(_BytesOriginal, 198), BytesThumb = ResizeImageFile(_BytesOriginal, 100) }; photosDB.Photos.InsertOnSubmit(p); photosDB.SubmitChanges(); }
public static Stream ZGetPhoto(int photoid, PhotoSize size) { bool filter = !(HttpContext.Current.User.IsInRole("Friends") || HttpContext.Current.User.IsInRole("Administrators")); Z.PhotoDataContext photoDB = new Z.PhotoDataContext(); Binary result = null; switch (size) { case PhotoSize.Small: result = photoDB.Photos .Where(p => p.PhotoID == photoid) .Where(p => p.Album.IsPublic == filter || p.Album.IsPublic == true) .Select(p => p.BytesThumb).SingleOrDefault(); break; case PhotoSize.Medium: result = photoDB.Photos .Where(p => p.PhotoID == photoid) .Where(p => p.Album.IsPublic == filter || p.Album.IsPublic == true) .Select(p => p.BytesPoster).SingleOrDefault(); break; case PhotoSize.Large: result = photoDB.Photos .Where(p => p.PhotoID == photoid) .Where(p => p.Album.IsPublic == filter || p.Album.IsPublic == true) .Select(p => p.BytesFull).SingleOrDefault(); break; case PhotoSize.Original: result = photoDB.Photos .Where(p => p.PhotoID == photoid) .Where(p => p.Album.IsPublic == filter || p.Album.IsPublic == true) .Select(p => p.BytesOriginal).SingleOrDefault(); break; } try { return(new MemoryStream(result.ToArray())); } catch { return(null); } }
public static List <Z.Album> ZGetAlbums() { Z.PhotoDataContext photoDB = new Z.PhotoDataContext(); bool filter = !((HttpContext.Current.User.IsInRole("Friends") || HttpContext.Current.User.IsInRole("Administrators"))); var qAlbums = photoDB .Albums .Where(a => a.IsPublic == filter || a.IsPublic == true) .Select(a => new { AlbumID = a.AlbumID, Caption = a.Caption, IsPublic = a.IsPublic, Count = a.Photos.Count() }); List <Z.Album> albums = new List <Z.Album>(); foreach (var x in qAlbums) { var a = new Z.Album() { AlbumID = x.AlbumID, Caption = x.Caption, IsPublic = x.IsPublic, Count = x.Count }; albums.Add(a); } return(albums); }
public static void ZRemoveAlbum(int _AlbumID) { var photosDB = new Z.PhotoDataContext(); var status = photosDB.RemoveAlbum(_AlbumID); }
public static void ZRemovePhoto(int _PhotoID) { var photoDB = new Z.PhotoDataContext(); photoDB.ExecuteCommand("DELETE FROM [Photos] WHERE [PhotoID] = {0}", _PhotoID); }