public IActionResult Index()
        {
            using (var db = new BandRegisterDbContex())
            {
                List <Band> bands = db.Bands.ToList();

                return(View(bands));
            }
        }
        public IActionResult Edit(int id)
        {
            using (var db = new BandRegisterDbContex())
            {
                Band bandToEdit = db.Bands.SingleOrDefault(b => b.Id == id);
                if (bandToEdit == null)
                {
                    return(RedirectToAction("index"));
                }

                return(View(bandToEdit));
            }
        }
        public IActionResult Create(Band band)
        {
            if (ModelState.IsValid)
            {
                using (var db = new BandRegisterDbContex())
                {
                    db.Bands.Add(band);
                    db.SaveChanges();
                }

                return(RedirectToAction("Index"));
            }

            return(RedirectToAction("Index"));
        }
        public IActionResult Delete(Band band)
        {
            using (var db = new BandRegisterDbContex())
            {
                var bandToDelete = db.Bands
                                   .SingleOrDefault(b => b.Id == band.Id);

                if (bandToDelete == null)
                {
                    return(RedirectToAction("Index"));
                }

                db.Remove(bandToDelete);
                db.SaveChanges();
            }

            return(RedirectToAction("Index"));
        }
        public IActionResult Edit(Band edittedBand)
        {
            if (ModelState.IsValid)
            {
                using (var db = new BandRegisterDbContex())
                {
                    var bandToEdit = db.Bands
                                     .SingleOrDefault(b => b.Id == edittedBand.Id);

                    bandToEdit.Name       = edittedBand.Name;
                    bandToEdit.Members    = edittedBand.Members;
                    bandToEdit.Honorarium = edittedBand.Honorarium;
                    bandToEdit.Genre      = edittedBand.Genre;
                    db.SaveChanges();
                }

                return(RedirectToAction("Index"));
            }

            return(View(edittedBand));
        }