/// <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>
/// 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 {
}
}
/// <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);
}
/// <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 {
}
}
/// <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 {
}
}