コード例 #1
0
 public IActionResult Create()
 {
     using (var db = new BandDbContext())
     {
         return(View());
     }
 }
コード例 #2
0
 public IActionResult Edit(int id)
 {
     using (var db = new BandDbContext())
     {
         var bandToEdit = db.Bands.Find(id);
         return(View(bandToEdit));
     }
 }
コード例 #3
0
 public IActionResult Index()
 {
     using (BandDbContext db = new BandDbContext())
     {
         List <Band> bands = db.Bands.ToList();
         return(View(bands));
     }
 }
コード例 #4
0
 public IActionResult Delete(int id)
 {
     using (var db = new BandDbContext())
     {
         var bandToDelete = db.Bands.Find(id);
         return(View(bandToDelete));
     }
 }
コード例 #5
0
 public IActionResult Index()
 {
     using (var db = new BandDbContext())
     {
         var allBands = db.Bands.ToList();
         return(View(allBands));
     }
 }
コード例 #6
0
 public IActionResult Delete(Band band)
 {
     using (var db = new BandDbContext())
     {
         db.Bands.Remove(band);
         db.SaveChanges();
     }
     return(RedirectToAction("Index"));
 }
コード例 #7
0
        public IActionResult Edit(Band band)
        {
            using (var db = new BandDbContext())
            {
                var bandToEdit = db.Bands.Update(band);
                db.SaveChanges();
            }

            return(RedirectToAction("Index"));
        }
コード例 #8
0
 public IActionResult Edit(int id)
 {
     using (var db = new BandDbContext())
     {
         var BandToEdit = db.Bands.FirstOrDefault(x => x.Id == id);
         if (BandToEdit == null)
         {
             return(RedirectToAction("Index"));
         }
         return(this.View(BandToEdit));
     }
 }
コード例 #9
0
        public IActionResult Delete(int id)
        {
            using (var db = new BandDbContext())
            {
                Band BandDetails = db.Bands.FirstOrDefault(t => t.Id == id);
                if (BandDetails == null)
                {
                    return(RedirectToAction("Index"));
                }

                return(View(BandDetails));
            }
        }
コード例 #10
0
        public IActionResult Delete(int id)
        {
            using (BandDbContext db = new BandDbContext())
            {
                Band oldBand = db.Bands.FirstOrDefault(x => x.Id == id);
                if (oldBand == null)
                {
                    return(RedirectToAction("Index"));
                }

                return(View(oldBand));
            }
        }
コード例 #11
0
 public IActionResult Edit(Band band)
 {
     using (var db = new BandDbContext())
     {
         var bandToEdit = db.Bands.FirstOrDefault(x => x.Id == band.Id);
         bandToEdit.Name       = band.Name;
         bandToEdit.Members    = band.Members;
         bandToEdit.Honorarium = band.Honorarium;
         bandToEdit.Genre      = band.Genre;
         db.SaveChanges();
     }
     return(RedirectToAction("Index"));
 }
コード例 #12
0
        public IActionResult Delete(int id)
        {
            using (var db = new BandDbContext())
            {
                var band = db.Bands.FirstOrDefault(b => b.Id == id);

                if (band != null)
                {
                    return(View(band));
                }

                return(RedirectToAction("Index"));
            }
        }
コード例 #13
0
        public IActionResult Delete(Band band)
        {
            using (BandDbContext db = new BandDbContext())
            {
                if (band == null)
                {
                    return(RedirectToAction("Index"));
                }

                db.Bands.Remove(band);
                db.SaveChanges();

                return(RedirectToAction("Index"));
            }
        }
コード例 #14
0
        public IActionResult Create(Band band)
        {
            if (!ModelState.IsValid)
            {
                return(RedirectToAction("Index"));
            }

            using (BandDbContext db = new BandDbContext())
            {
                db.Bands.Add(band);
                db.SaveChanges();
            }

            return(RedirectToAction("Index"));
        }
コード例 #15
0
        public IActionResult Delete(Band band)
        {
            using (var db = new BandDbContext())
            {
                var currentBand = db.Bands.FirstOrDefault(b => b.Id == band.Id);

                if (currentBand != null)
                {
                    db.Bands.Remove(currentBand);
                    db.SaveChanges();
                }
            }

            return(RedirectToAction("Index"));
        }
コード例 #16
0
        public IActionResult Create(Band band)
        {
            if (string.IsNullOrEmpty(band.Name) || string.IsNullOrEmpty(band.Members) ||
                string.IsNullOrEmpty(band.Genre) || band.Honorarium <= 0)
            {
                return(RedirectToAction("Index"));
            }

            using (var db = new BandDbContext())
            {
                db.Bands.Add(band);
                db.SaveChanges();
                return(RedirectToAction("Index"));
            }
        }
コード例 #17
0
        public IActionResult Delete(Band band)
        {
            using (var db = new BandDbContext())
            {
                var bandToDel = db.Bands.FirstOrDefault(t => t.Id == band.Id);
                if (bandToDel == null)
                {
                    return(RedirectToAction("Index"));
                }

                db.Bands.Remove(bandToDel);
                db.SaveChanges();
            }

            return(RedirectToAction("Index"));
        }
コード例 #18
0
        public IActionResult Edit(Band band)
        {
            if (!ModelState.IsValid)
            {
                return(RedirectToAction("Index"));
            }

            using (var db = new BandDbContext())
            {
                var BandToEdit = db.Bands.FirstOrDefault(t => t.Id == band.Id);
                BandToEdit.Name       = band.Name;
                BandToEdit.Members    = band.Members;
                BandToEdit.Honorarium = band.Honorarium;
                BandToEdit.Genre      = band.Genre;

                db.SaveChanges();
            }

            return(RedirectToAction("Index"));
        }
コード例 #19
0
        public IActionResult Edit(Band band)
        {
            if (ModelState.IsValid)
            {
                using (var db = new BandDbContext())
                {
                    var currentBand = db.Bands.FirstOrDefault(b => b.Id == band.Id);

                    if (currentBand != null)
                    {
                        currentBand.Name       = band.Name;
                        currentBand.Members    = band.Members;
                        currentBand.Honorarium = band.Honorarium;
                        currentBand.Genre      = band.Genre;
                    }
                }
            }

            return(RedirectToAction("Index"));
        }
コード例 #20
0
        public IActionResult Create(string name, string members, double honorarium, string genre)
        {
            if (string.IsNullOrEmpty(name) || string.IsNullOrEmpty(members) || string.IsNullOrEmpty(genre))
            {
                return(RedirectToAction("Index"));
            }

            Band band = new Band
            {
                Name       = name,
                Members    = members,
                Honorarium = honorarium,
                Genre      = genre
            };

            using (var db = new BandDbContext())
            {
                db.Bands.Add(band);
                db.SaveChanges();
            }
            return(RedirectToAction("Index"));
        }
コード例 #21
0
        public IActionResult Edit(Band newBand)
        {
            if (!ModelState.IsValid)
            {
                return(RedirectToAction("Index"));
            }
            using (BandDbContext db = new BandDbContext())
            {
                Band oldBand = db.Bands.FirstOrDefault(x => x.Id == newBand.Id);
                if (oldBand == null)
                {
                    return(RedirectToAction("Index"));
                }

                oldBand.Name       = newBand.Name;
                oldBand.Members    = newBand.Members;
                oldBand.Honorarium = newBand.Honorarium;
                oldBand.Genre      = newBand.Genre;

                db.SaveChanges();

                return(RedirectToAction("Index"));
            }
        }
コード例 #22
0
 public BandAlbumRepostitory(BandDbContext context)
 {
     _context = context ?? throw new ArgumentNullException(nameof(context));
 }
コード例 #23
0
 public BandController(BandDbContext context)
 {
     _context = context;
 }
 public HomeController(ILogger <HomeController> logger, BandDbContext context)
 {
     _logger = logger;
     // set database on start up
     _context = context;
 }