public static AdsDataComponent.PhotosDataTable GetPhotosByAdId(int adId) { using (PhotosDataAdapter db = new PhotosDataAdapter()) { return db.GetPhotosByAdId(adId); } }
public static byte[] GetPhotoBytesById(int photoId, PhotoSize size) { using (PhotosDataAdapter db = new PhotosDataAdapter()) { return db.GetPhotoBytesById(photoId, (int)size) as byte[]; } }
public static int InsertPhoto(int adId, byte[] bytesFull, byte[] bytesMedium, byte[] bytesSmall, bool useAsPreview) { int photoId = -1; if (bytesFull != null && bytesMedium != null && bytesSmall != null) { SiteSettings s = SiteSettings.GetSharedSettings(); using (PhotosDataAdapter db = new PhotosDataAdapter()) { if (s.StorePhotosInDatabase) photoId = Convert.ToInt32(db.InsertPhoto(adId, bytesFull, bytesMedium, bytesSmall, useAsPreview, DateTime.Now)); else { photoId = Convert.ToInt32(db.InsertPhoto(adId, null, null, null, useAsPreview, DateTime.Now)); string fullSizePath = GetFilePath(photoId, false, PhotoSize.Full); string mediumSizePath = GetFilePath(photoId, false, PhotoSize.Medium); string smallSizePath = GetFilePath(photoId, false, PhotoSize.Small); WriteToFile(fullSizePath, bytesFull); WriteToFile(mediumSizePath, bytesMedium); WriteToFile(smallSizePath, bytesSmall); } } } return photoId; }
public static void SetAdPreviewPhoto(int adId, int photoId) { using (PhotosDataAdapter db = new PhotosDataAdapter()) { db.SetAdPreviewPhoto(photoId, adId); } }
public static void RemovePhotosOfDeletedAds() { SiteSettings s = SiteSettings.GetSharedSettings(); // must remove photos from file system before removing from DB using (PhotosDataAdapter db = new PhotosDataAdapter()) { if (s.StorePhotosInDatabase) { AdsDataComponent.PhotosDataTable deletedAdPhotos = db.GetPhotosByAdStatus((int)AdStatus.Deleted); RemovePhotoFilesInTable(deletedAdPhotos); } db.RemovePhotosByAdStatus((int)AdStatus.Deleted); } }
public static void RemovePhotosByAdId(int adId) { SiteSettings s = SiteSettings.GetSharedSettings(); using (PhotosDataAdapter db = new PhotosDataAdapter()) { if (s.StorePhotosInDatabase) { AdsDataComponent.PhotosDataTable photos = db.GetPhotosByAdStatus((int)AdStatus.Deleted); RemovePhotoFilesInTable(photos); } } }
public static bool RemovePhotoById(int id) { bool result = false; using (PhotosDataAdapter db = new PhotosDataAdapter()) { db.RemovePhoto(id); } SiteSettings s = SiteSettings.GetSharedSettings(); if (s.StorePhotosInDatabase) { result = true; } { result = DeleteLocalPhotoFiles(id); } return result; }