public ActionResult Genre(string genre)
        {
            AlbumsContext albCtx = new AlbumsContext();
            var           album  = albCtx.albums.Where(alb => alb.Genre.Contains(genre) || genre == null);

            return(View(album));
        }
        public ActionResult Artist(string artist)
        {
            AlbumsContext albCtx = new AlbumsContext();
            var           album  = albCtx.albums.Where(alb => alb.Author.Contains(artist) || artist == null);

            return(View(album));
        }
        public ActionResult Name(string name)
        {
            AlbumsContext albCtx = new AlbumsContext();
            var           album  = albCtx.albums.Where(alb => alb.Name.Contains(name) || name == null);

            return(View(album));
        }
Example #4
0
        static void Main(string[] args)
        {
            using (var db = new AlbumsContext())
            {
                var albums = new Album {
                    AlbumName = "Album nou"
                };
                db.Albums.Add(albums);
                db.SaveChanges();

                var query = from b in db.Albums
                            orderby b.AlbumName
                            select b;
                Console.WriteLine("All albums in database");
                foreach (var item in query)
                {
                    Console.WriteLine(item.AlbumName);
                }
                Console.WriteLine("Press any key to exit");
                Console.ReadKey();
            }
        }
 public AlmubsBasesController(AlbumsContext context)
 {
     _context = context;
 }
Example #6
0
 public AlbumsController(AlbumsContext context)
 {
     _context = context;
 }