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()); } }