Beispiel #1
0
 /// <summary>
 /// Remove slideshow
 /// </summary>
 /// <param name="id"></param>
 public static void RemoveSlideShow(int id)
 {
     try {
         using (var db = new MediaPlayerContext()) {
             SlideShowMapper slideShowMapper = db.SlideShowMapper.Single(x => x.Id == id);
             db.SlideShowMapper.Remove(slideShowMapper);
             db.SaveChanges();
         }
     } catch {
     }
 }
Beispiel #2
0
 /// <summary>
 /// Remove entry
 /// </summary>
 /// <param name="id"></param>
 public static void RemoveMediaData(int id)
 {
     try {
         using (var db = new MediaPlayerContext()) {
             MediaDataMapper mediaDataMapper = db.MediaDataMapper.Single(x => x.Id == id);
             db.MediaDataMapper.Remove(mediaDataMapper);
             db.SaveChanges();
         }
     } catch {
     }
 }
 /// <summary>
 /// Update last used time
 /// </summary>
 /// <param name="id"></param>
 public static void UpdateLastUsed(int id)
 {
     try {
         using (var db = new MediaPlayerContext()) {
             AlbumMapper albumMapper = db.AlbumMapper.Single(x => x.Id == id);
             albumMapper.LastUsed = DateTime.Now;
             db.SaveChanges();
         }
     } catch {
     }
 }
 /// <summary>
 /// Remove album from table
 /// </summary>
 /// <param name="id"></param>
 public static void RemoveAlbum(int id)
 {
     try {
         using (var db = new MediaPlayerContext()) {
             AlbumMapper albumMapper = db.AlbumMapper.Single(x => x.Id == id);
             db.AlbumMapper.Remove(albumMapper);
             db.SaveChanges();
         }
     } catch {
     }
 }
Beispiel #5
0
        /// <summary>
        /// Retrive slideshow data
        /// </summary>
        /// <param name="id"></param>
        /// <returns></returns>
        public static SlideShowMapper GetSlideShow(int id)
        {
            SlideShowMapper slideShowMapper;

            try {
                using (var db = new MediaPlayerContext()) {
                    slideShowMapper = db.SlideShowMapper.Single(x => x.Id == id);
                }
                return(slideShowMapper);
            } catch {
                return(null);
            }
        }
 /// <summary>
 /// Update name of album
 /// </summary>
 /// <param name="id"></param>
 /// <param name="name"></param>
 public static void UpdateName(int id, string name)
 {
     try {
         using (var db = new MediaPlayerContext()) {
             // Get data and update field
             AlbumMapper albumMapper = db.AlbumMapper.Single(x => x.Id == id);
             albumMapper.Name     = name;
             albumMapper.LastUsed = DateTime.Now;
             db.SaveChanges();
         }
     } catch {
     }
 }
        /// <summary>
        /// Return last used time of album
        /// Allow sorting albums by last used
        /// </summary>
        /// <param name="id"></param>
        /// <returns></returns>
        public static DateTime GetLastUsedTime(int id)
        {
            DateTime lastUsed;

            try {
                using (var db = new MediaPlayerContext()) {
                    AlbumMapper albumMapper = db.AlbumMapper.Single(x => x.Id == id);
                    lastUsed = albumMapper.LastUsed;
                }
            } catch {
            }
            return(DateTime.MinValue);
        }
        /// <summary>
        /// Retrive album data
        /// </summary>
        /// <param name="id"></param>
        /// <returns></returns>
        public static AlbumMapper GetAlbum(int id)
        {
            AlbumMapper albumMapper;

            try {
                using (var db = new MediaPlayerContext()) {
                    albumMapper = db.AlbumMapper.Single(x => x.Id == id);
                }
                return(albumMapper);
            } catch {
                return(null);
            }
        }
Beispiel #9
0
        /// <summary>
        /// Retrive data
        /// </summary>
        /// <param name="id"></param>
        /// <returns></returns>
        public static MediaDataMapper GetMediaData(int id)
        {
            MediaDataMapper mediaDataMapper;

            try {
                using (var db = new MediaPlayerContext()) {
                    mediaDataMapper = db.MediaDataMapper.Single(x => x.Id == id);
                }
                return(mediaDataMapper);
            } catch {
                return(null);
            }
        }
 /// <summary>
 /// Remove slideshow from album
 /// </summary>
 /// <param name="id"></param>
 /// <param name="slideShowId"></param>
 public static void RemoveSlideShow(int id, int slideShowId)
 {
     try {
         using (var db = new MediaPlayerContext()) {
             // Get data and update field
             SlideShowMapper slideShowMapper = db.SlideShowMapper.Single(x => x.Id == slideShowId);
             AlbumMapper     albumMapper     = db.AlbumMapper.Single(x => x.Id == id);
             albumMapper.SlideShowMappers.Remove(slideShowMapper);
             albumMapper.LastUsed = DateTime.Now;
             db.SaveChanges();
         }
     } catch {
     }
 }
Beispiel #11
0
 /// <summary>
 /// Update name of slideshow
 /// </summary>
 /// <param name="id"></param>
 /// <param name="name"></param>
 public static void UpdateName(int id, string name)
 {
     try {
         SlideShowMapper slideShowMapper;
         using (var db = new MediaPlayerContext()) {
             // Get data and update field
             slideShowMapper      = db.SlideShowMapper.Single(x => x.Id == id);
             slideShowMapper.Name = name;
             db.SaveChanges();
         }
         AlbumQuery.UpdateLastUsed(slideShowMapper.AlbumMapper.Id);
     } catch {
     }
 }
Beispiel #12
0
        /// <summary>
        /// Add new entry
        /// </summary>
        /// <param name="mediaDataMapper"></param>
        /// <returns></returns>
        public static int NewMediaData(MediaDataMapper mediaDataMapper)
        {
            int id = -1;

            try {
                using (var db = new MediaPlayerContext()) {
                    // Get id (max+1) and add to table
                    id = db.MediaDataMapper.Select(x => x.Id).DefaultIfEmpty(0).Max() + 1;
                    mediaDataMapper.Id = id;
                    db.MediaDataMapper.Add(mediaDataMapper);
                    db.SaveChanges();
                }
            } catch {
            }
            return(id);
        }
Beispiel #13
0
 /// <summary>
 /// Remove mediadata
 /// </summary>
 /// <param name="id"></param>
 /// <param name="mediaDataId"></param>
 public static void RemoveMediaData(int id, int mediaDataId)
 {
     try {
         int albumId = 0;
         using (var db = new MediaPlayerContext()) {
             // Get data and update field
             MediaDataMapper mediaDataMapper = db.MediaDataMapper.Single(x => x.Id == mediaDataId);
             SlideShowMapper slideShowMapper = db.SlideShowMapper.Single(x => x.Id == id);
             slideShowMapper.MediaDataMappers.Remove(mediaDataMapper);
             albumId = slideShowMapper.AlbumMapper.Id;
             db.SaveChanges();
         }
         AlbumQuery.UpdateLastUsed(albumId);
     } catch {
     }
 }
Beispiel #14
0
        /// <summary>
        /// Retrive all ids and media data type
        /// </summary>
        /// <param name="slideShowId"></param>
        /// <returns></returns>
        public static Dictionary <int, MediaDataType> GetMediaDatas(int slideShowId)
        {
            // Create dictonary with id and corresponding mediadata type
            Dictionary <int, MediaDataType> mediaData = new Dictionary <int, MediaDataType>();

            try {
                using (var db = new MediaPlayerContext()) {
                    List <MediaDataMapper> mediaDataMappers = db.MediaDataMapper.Where(x => x.SlideShowMapper.Id == slideShowId).ToList();
                    foreach (MediaDataMapper mediaDataMapper in mediaDataMappers)
                    {
                        mediaData.Add(mediaDataMapper.Id, mediaDataMapper.MediaDataType);
                    }
                }
            } catch {
            }
            return(mediaData);
        }
Beispiel #15
0
        /// <summary>
        /// Add slideshow to table
        /// </summary>
        /// <param name="name"></param>
        /// <returns></returns>
        public static int NewSlideShow(string name)
        {
            SlideShowMapper slideShowMapper = new SlideShowMapper(name);
            int             id = -1;

            try {
                using (var db = new MediaPlayerContext()) {
                    // Get id (max+1) and add to table
                    id = db.SlideShowMapper.Select(x => x.Id).DefaultIfEmpty(0).Max() + 1;
                    slideShowMapper.Id = id;
                    db.SlideShowMapper.Add(slideShowMapper);
                    db.SaveChanges();
                }
            } catch {
            }
            return(id);
        }
        /// <summary>
        /// Get all albums ids
        /// </summary>
        /// <returns></returns>
        public static List <int> GetAlbums()
        {
            List <int> ints = new List <int>();

            try {
                using (var db = new MediaPlayerContext()) {
                    List <AlbumMapper> albumMappers = db.AlbumMapper.ToList();
                    if (albumMappers.Count > 0)
                    {
                        for (int i = 0; i < albumMappers.Count; i++)
                        {
                            ints.Add(albumMappers[i].Id);
                        }
                    }
                }
            } catch {
            }
            return(ints);
        }
        /// <summary>
        /// Add album to table
        /// </summary>
        /// <param name="name"></param>
        /// <returns></returns>
        public static int NewAlbum(string name, out DateTime lastUsed)
        {
            // create new entity
            AlbumMapper albumMapper = new AlbumMapper(name);
            int         id          = 0;

            try {
                using (var db = new MediaPlayerContext()) {
                    // Get new id (max)+1 and set parameteres
                    id                   = db.AlbumMapper.Select(x => x.Id).DefaultIfEmpty(0).Max() + 1;
                    albumMapper.Id       = id;
                    lastUsed             = DateTime.Now;
                    albumMapper.LastUsed = lastUsed;
                    db.AlbumMapper.Add(albumMapper);
                    db.SaveChanges();
                }
            } catch {
                lastUsed = DateTime.MinValue;
            }
            return(id);
        }
        /// <summary>
        /// Returns the key information of the last used album
        /// </summary>
        /// <param name="id"></param>
        /// <param name="name"></param>
        public static void GetLastUsed(ref int id, ref string name)
        {
            AlbumMapper albumMapper;

            try {
                using (var db = new MediaPlayerContext()) {
                    // Order by last used, and set to current time (as it is being used now)
                    albumMapper          = db.AlbumMapper.OrderBy(x => x.LastUsed).FirstOrDefault();
                    albumMapper.LastUsed = DateTime.Now;
                    db.SaveChanges();
                }
                if (albumMapper != null)
                {
                    id   = albumMapper.Id;
                    name = albumMapper.Name;
                    return;
                }
            } catch {
            }
            id   = -1;
            name = string.Empty;
        }
Beispiel #19
0
        /// <summary>
        /// Retrive all slideshow ids for a album
        /// </summary>
        /// <param name="albumId"></param>
        /// <returns></returns>
        public static List <int> GetSlideShows(int albumId)
        {
            List <int> ints = new List <int>();

            try {
                using (var db = new MediaPlayerContext()) {
                    // Get list from album
                    AlbumMapper            albumMapper      = db.AlbumMapper.Single(x => x.Id == albumId);
                    List <SlideShowMapper> slideShowMappers = db.SlideShowMapper.Where(x => x.AlbumMapper.Id == albumId).ToList();
                    // Return as ids
                    if (slideShowMappers.Count > 0)
                    {
                        foreach (SlideShowMapper slideShowMapper in slideShowMappers)
                        {
                            ints.Add(slideShowMapper.Id);
                        }
                    }
                }
            } catch {
            }
            return(ints);
        }
Beispiel #20
0
        /// <summary>
        /// Update thumbnail image
        /// </summary>
        /// <param name="id"></param>
        /// <param name="thumbNailImage"></param>
        public static void UpdateThumbNail(int id, byte[] thumbNailImage)
        {
            int albumId = -1;

            try {
                using (var db = new MediaPlayerContext()) {
                    // Get data and update field
                    MediaDataMapper mediaDataMapper = db.MediaDataMapper.Single(x => x.Id == id);
                    mediaDataMapper.ThumbNailImage = thumbNailImage;
                    SlideShowMapper slideShowMapper = mediaDataMapper.SlideShowMapper;
                    if (slideShowMapper != null)
                    {
                        albumId = slideShowMapper.AlbumMapper.Id;
                    }
                    db.SaveChanges();
                }
                if (albumId >= 0)
                {
                    AlbumQuery.UpdateLastUsed(albumId);
                }
            } catch {
            }
        }
Beispiel #21
0
        /// <summary>
        /// Change order field
        /// </summary>
        /// <param name="id"></param>
        /// <param name="order"></param>
        public static void UpdateOrder(int id, int order)
        {
            int albumId = 0;

            try {
                using (var db = new MediaPlayerContext()) {
                    // Get data and update field
                    MediaDataMapper mediaDataMapper = db.MediaDataMapper.Single(x => x.Id == id);
                    mediaDataMapper.Order = order;
                    SlideShowMapper slideShowMapper = mediaDataMapper.SlideShowMapper;
                    if (slideShowMapper != null)
                    {
                        albumId = slideShowMapper.AlbumMapper.Id;
                    }
                    db.SaveChanges();
                }
                if (albumId >= 0)
                {
                    AlbumQuery.UpdateLastUsed(albumId);
                }
            } catch {
            }
        }