protected virtual void Create(T item, PlaylistContext context)
{
item.CreatedBy = System.Security.Principal.WindowsIdentity.GetCurrent().User.Value;
item.CreatedOn = DateTime.UtcNow;
context.Set <T>().Add(item);
}
public Task <MediaItemModel> GetMediaItemByPlaylistIdAsync(int id)
{
return(Task.Run(() =>
{
using (var context = new PlaylistContext())
return GetMediaItemByPlaylistIdInternalAsync(id, context);
}));
}
public Task <T> GetByIdAsync(int Id)
{
return(Task.Run(() =>
{
using (var context = new PlaylistContext())
return GetByIdInternalAsync(Id, context);
}));
}
public Task <MediaPlayer> GetMainMediaPlayerAsync()
{
return(Task.Run(() =>
{
using (var context = new PlaylistContext())
return GetMainMediaPlayerInternal(context);
}));
}
public Task <IReadOnlyCollection <MediaPlayer> > GetOptionalMediaPlayersAsync()
{
return(Task.Run(() =>
{
using (var context = new PlaylistContext())
return GetOptionalMediaPlayersInternal(context);
}));
}
public Task <IReadOnlyCollection <T> > GetAsync()
{
return(Task.Run(() =>
{
using (var context = new PlaylistContext())
return GetInternalAsync(context);
}));
}
protected virtual void Update(T item, PlaylistContext context)
{
var entity = GetEntities(context).Find(item.Id);
if (entity == null)
{
return;
}
item.UpdatedOn = DateTime.UtcNow;
item.UpdatedBy = System.Security.Principal.WindowsIdentity.GetCurrent().User.Value;
context.Entry(entity).CurrentValues.SetValues(item);
}
protected virtual void SaveInternal(T item, PlaylistContext context)
{
if (item.IsNew)
{
Create(item, context);
}
else
{
if (item.IsDeleted)
{
context.Database.Log = (message) => Debug.WriteLine(message);
Delete(item, context);
}
else
{
Update(item, context);
}
}
context.SaveChanges();
}
protected override DbSet <MediaItemModel> GetEntities(PlaylistContext context)
{
return(context.MediaItems);
}
protected override DbSet <MediaPlayer> GetEntities(PlaylistContext context)
{
return(context.Mediaplayers);
}
protected override IReadOnlyCollection <MediaPlayer> GetInternalAsync(PlaylistContext context)
{
return(GetEntities(context).Include(p => p.Playlist).ToList());
}
private IReadOnlyCollection <MediaPlayer> GetOptionalMediaPlayersInternal(PlaylistContext context)
{
return(GetEntities(context).Include(p => p.Playlist)
.Where(p => !p.IsPrimary)
.ToList());
}
private MediaPlayer GetMainMediaPlayerInternal(PlaylistContext context)
{
return(GetEntities(context).Include(p => p.Playlist)
.FirstOrDefault(p => p.IsPrimary));
}
protected virtual IReadOnlyCollection <T> GetInternalAsync(PlaylistContext context)
{
return(GetEntities(context).ToList());
}
protected virtual T GetByIdInternalAsync(int id, PlaylistContext context)
{
return(GetEntities(context).FirstOrDefault(p => p.Id == id));
}
private MediaItemModel GetMediaItemByPlaylistIdInternalAsync(int id, PlaylistContext context)
{
return(context.MediaItems.FirstOrDefault(p => p.Playlist.Id == id));
}
protected override DbSet <PlaylistModel> GetEntities(PlaylistContext context)
{
return(context.Playlists);
}
protected virtual void Delete(T item, PlaylistContext context)
{
context.Set <T>().Remove(item);
}
protected abstract DbSet <T> GetEntities(PlaylistContext context);
public void Save(T item)
{
using (var context = new PlaylistContext())
SaveInternal(item, context);
}
