public void PopulateGenreList()
{
using (MusicLibraryContext db = new MusicLibraryContext())
{
genreDataGridView.DataSource = db.Genres.ToList <Genre>();
}
}
public int Add(object o)
{
using (MusicLibraryContext musicLibraryContext = new MusicLibraryContext())
{
musicLibraryContext.Genres.Add((Genre)o);
return(musicLibraryContext.SaveChanges());
}
}
public int Update(object o)
{
using (MusicLibraryContext musicLibraryContext = new MusicLibraryContext())
{
musicLibraryContext.Entry((Genre)o).State = EntityState.Modified;
return(musicLibraryContext.SaveChanges());
}
}
void PopulateDataGridView()
{
dvgAlbum.AutoGenerateColumns = false;
using (MusicLibraryContext ac = new MusicLibraryContext())
{
dvgAlbum.DataSource = ac.Albums.ToList <Album>();
}
}
public int Add(object o)
{
using (MusicLibraryContext musicLibraryContext = new MusicLibraryContext())
{
musicLibraryContext.Artists.Add((Artist)o);
return(musicLibraryContext.SaveChanges());
}
}
private void PopulateDataGridView()
{
dataGridViewArtist.AutoGenerateColumns = false;
using (MusicLibraryContext musicLibraryContext = new MusicLibraryContext())
{
dataGridViewArtist.DataSource = musicLibraryContext.Artists.ToList <Artist>();
}
}
public object Get(int id)
{
Genre genre = null;
using (MusicLibraryContext musicLibraryContext = new MusicLibraryContext())
{
genre = musicLibraryContext.Genres.Where(x => x.GenreId == id).FirstOrDefault();
}
return(genre);
}
public object Get(int id)
{
Song song = null;
using (MusicLibraryContext musicLibraryContext = new MusicLibraryContext())
{
song = musicLibraryContext.Songs.Where(x => x.SongId == id).FirstOrDefault();
}
return(song);
}
public object Get(int id)
{
Album album = null;
using (MusicLibraryContext musicLibraryContext = new MusicLibraryContext())
{
album = musicLibraryContext.Albums.Where(x => x.AlbumId == id).FirstOrDefault();
}
return(album);
}
public object Get(int id)
{
Artist artist = null;
using (MusicLibraryContext musicLibraryContext = new MusicLibraryContext())
{
artist = musicLibraryContext.Artists.Where(x => x.ArtistId == id).FirstOrDefault();
}
return(artist);
}
protected override void OnLoad(EventArgs e)
{
base.OnLoad(e);
_context = new MusicLibraryContext();
//load categories from db
_context.Genres.Load();
//bind the data to the source
this.genreBindingSource.DataSource = _context.Genres.Local.ToBindingList();
btnDeleteGenre.Enabled = false;
}
public int Delete(object o)
{
using (MusicLibraryContext musicLibraryContext = new MusicLibraryContext())
{
var entry = musicLibraryContext.Entry((Genre)o);
if (entry.State == EntityState.Detached)
{
musicLibraryContext.Genres.Attach((Genre)o);
}
musicLibraryContext.Genres.Remove((Genre)o);
return(musicLibraryContext.SaveChanges());
}
}
