public ActionResult Create(ArtistSubTypeModel artistsubtypemodel)
 {
     if (ModelState.IsValid)
     {
         Db.ArtistSubTypes.Add(artistsubtypemodel);
         Db.SaveChanges();
         return RedirectToAction("Index");
     }
     ViewData["ArtistTypes"] = new SelectList(Db.ArtistTypes.ToList(), "Id", "ArtistType");
     return View(artistsubtypemodel);
 }
        public ActionResult Edit(ArtistSubTypeModel artistsubtypemodel)
        {
            if (ModelState.IsValid)
            {
                Db.Entry(artistsubtypemodel).State = EntityState.Modified;

                foreach (ArtistModel artist in Db.Artists.ToList())
                {
                    if (artist.ArtistSubTypeId == artistsubtypemodel.Id && artist.ArtistTypeId != artistsubtypemodel.ArtistTypeId)
                    {
                        artist.ArtistTypeId = artistsubtypemodel.ArtistTypeId;
                        Db.Entry(artist).State = EntityState.Modified;
                    }
                }

                Db.SaveChanges();
                return RedirectToAction("Index");
            }

            ViewData["ArtistTypes"] = new SelectList(Db.ArtistTypes.ToList(), "Id", "ArtistType", artistsubtypemodel.ArtistTypeId);
            return View(artistsubtypemodel);
        }