Esempio n. 1
0
        public ActionResult Create(Artist artist)
        {
            if (ModelState.IsValid)
            {
                db.Artists.Add(artist);
                db.SaveChanges();
                return RedirectToAction("Index");
            }

            ViewBag.Artist_AgentId = new SelectList(db.Agents.OrderBy(a => a.Agent_Name), "Agent_Id", "Agent_Name", artist.Artist_AgentId);
            ViewBag.Artist_CountryId = new SelectList(db.CountryRegions.OrderBy(c => c.CountryRegion_Name), "CountryRegion_Id", "CountryRegion_Name", artist.Artist_CountryId);
            ViewBag.Artist_StateProvinceId = new SelectList(db.StateProvinces.OrderBy(s => s.StateProvince_Name), "StateProvince_Id", "StateProvince_Name", artist.Artist_StateProvinceId);
            ViewBag.Artist_TypeId = new SelectList(db.Types.OrderBy(t => t.Type_Name), "Type_Id", "Type_Name", artist.Artist_TypeId);
            return View(artist);
        }
Esempio n. 2
0
        public ActionResult EditPerformanceArtist(PerformanceArtist performanceArtist, string OtherRole, string PerformanceArtist_ArtistFullName)
        {
            if (ModelState.IsValid)
            {

                // Role
                if (OtherRole != null && OtherRole.Length > 0)
                {

                    //Check the Role
                    Role role = db.Roles.FirstOrDefault(r => r.Role_Id == performanceArtist.PerformanceArtist_RoleId);
                    if (role.Role_Name == "Other")
                    {
                        // Create a new Role

                        // remove any unnecessary spaces
                        OtherRole = OtherRole.Replace("  ", " ").Trim();

                        Role newRole = new Role();
                        newRole.Role_Name = OtherRole;

                        Performance performance = db.Performances.FirstOrDefault(p => p.Performance_Id == performanceArtist.PerformanceArtist_PerformanceId);
                        newRole.Role_PieceId = performance.Performance_PieceId;

                        newRole.Role_Rank = db.Roles.Where(r => r.Role_PieceId == performance.Performance_PieceId).Select(r => r.Role_Rank).Max() + 1;

                        db.Roles.Add(newRole);

                        performanceArtist.PerformanceArtist_RoleId = newRole.Role_Id;
                    }
                }

                // Artist
                Artist artist = db.Artists.FirstOrDefault(a => string.Concat(a.Artist_FirstName, " ", a.Artist_LastName).Equals(PerformanceArtist_ArtistFullName));
                if (artist != null)
                {
                    //attach the artist
                    performanceArtist.PerformanceArtist_ArtistId = artist.Artist_Id;
                }
                else
                {
                    //create a new artist

                    // remove any unnecessary spaces
                    PerformanceArtist_ArtistFullName = PerformanceArtist_ArtistFullName.Replace("  ", " ").Trim();

                    string firstName = "";
                    string lastName;

                    // find the position of the last space
                    int i = PerformanceArtist_ArtistFullName.LastIndexOf(" ");

                    if (i > 0)
                    {
                        //there are two words or more
                        firstName = PerformanceArtist_ArtistFullName.Substring(0, i).Trim();
                        lastName = PerformanceArtist_ArtistFullName.Substring(i, PerformanceArtist_ArtistFullName.Length - i).Trim();

                    }
                    else
                    { //there's only one word
                        lastName = PerformanceArtist_ArtistFullName;
                    }

                    Artist newArtist = new Artist();
                    newArtist.Artist_FirstName = firstName;
                    newArtist.Artist_LastName = lastName;
                    db.Artists.Add(newArtist);

                    performanceArtist.PerformanceArtist_ArtistId = newArtist.Artist_Id;

                }

                db.Entry(performanceArtist).State = EntityState.Modified;
                db.SaveChanges();

                ViewBag.artist = db.Artists.Find(performanceArtist.PerformanceArtist_ArtistId);
                ViewBag.role = db.Roles.Find(performanceArtist.PerformanceArtist_RoleId);

                // Can the current user edit this event?
                ViewBag.UserCanEditEvent = true;

                return PartialView("DetailsPerformanceArtist", performanceArtist);
            }
            else
            {
                return Content("Please review your form");
            }
        }
Esempio n. 3
0
        public ActionResult NewPieceArtist(PieceArtist PieceArtist, string PieceArtist_ArtistFullName)
        {
            if (ModelState.IsValid)
            {
                Artist artist = db.Artists.FirstOrDefault(a => string.Concat(a.Artist_FirstName, " ", a.Artist_LastName).Equals(PieceArtist_ArtistFullName));
                if (artist != null)
                {
                    //attach the artist
                    PieceArtist.PieceArtist_ArtistId = artist.Artist_Id;
                }
                else
                {
                    //create a new artist

                    // remove any unnecessary spaces
                    PieceArtist_ArtistFullName.Replace("  ", " ").Trim();

                    string firstName = "";
                    string lastName;

                    // find the position of the last space
                    int i = PieceArtist_ArtistFullName.LastIndexOf(" ");

                    if (i > 0)
                    {
                        //there are two words or more
                        firstName = PieceArtist_ArtistFullName.Substring(0, i);
                        lastName = PieceArtist_ArtistFullName.Substring(i, PieceArtist_ArtistFullName.Length - i);
                    }
                    else
                    { //there's only one word
                        lastName = PieceArtist_ArtistFullName;
                    }

                    Artist newArtist = new Artist();
                    newArtist.Artist_FirstName = firstName;
                    newArtist.Artist_LastName = lastName;
                    db.Artists.Add(newArtist);

                    PieceArtist.PieceArtist_ArtistId = newArtist.Artist_Id;

                }
                db.PieceArtists.Add(PieceArtist);
                db.SaveChanges();

                ViewBag.artist = db.Artists.Find(PieceArtist.PieceArtist_ArtistId);
                ViewBag.pieceArtistType = db.PieceArtistTypes.Find(PieceArtist.PieceArtist_PieceArtistTypeId);

                return PartialView("DetailsPieceArtist", PieceArtist);
            }
            else
            {
                return Content("Please review your form");
            }
        }
Esempio n. 4
0
        public ActionResult ThisIsMe(Artist artist)
        {
            if (ModelState.IsValid)
            {
                db.Entry(artist).State = EntityState.Modified;
                db.SaveChanges();

                ViewBag.Type = db.Types.FirstOrDefault(t => t.Type_Id == artist.Artist_TypeId);
                ViewBag.Agent = db.Agents.FirstOrDefault(a => a.Agent_Id == artist.Artist_AgentId);
                ViewBag.CountryRegion = db.CountryRegions.FirstOrDefault(c => c.CountryRegion_Id == artist.Artist_CountryId);
                ViewBag.StateProvince = db.StateProvinces.FirstOrDefault(c => c.StateProvince_Id == artist.Artist_StateProvinceId);

                ViewBag.AmITheArtist = true;

                return PartialView("DetailsArtist", artist);
            }
            else
            {
                return Content("Please review your form");
            }
        }
Esempio n. 5
0
        public ActionResult EditArtist(Artist artist)
        {
            if (ModelState.IsValid)
            {
                db.Entry(artist).State = EntityState.Modified;
                db.SaveChanges();

                ViewBag.Type = db.Types.FirstOrDefault(t => t.Type_Id == artist.Artist_TypeId);
                ViewBag.Agent = db.Agents.FirstOrDefault(a => a.Agent_Id == artist.Artist_AgentId);
                ViewBag.CountryRegion = db.CountryRegions.FirstOrDefault(c => c.CountryRegion_Id == artist.Artist_CountryId);
                ViewBag.StateProvince = db.StateProvinces.FirstOrDefault(c => c.StateProvince_Id == artist.Artist_StateProvinceId);

                // Am I the artist?
                ViewBag.AmITheArtist = false;
                if (Request.IsAuthenticated && artist.Artist_UserId == (int)Session["UserID"])
                {
                    ViewBag.AmITheArtist = true;
                }

                // Could I be the artist?
                ViewBag.CouldIBeTheArtist = false;
                if (Request.IsAuthenticated && artist.Artist_UserId == null)
                {
                    ViewBag.CouldIBeTheArtist = true;
                }

                return PartialView("DetailsArtist", artist);
            }
            else
            {
                return Content("Please review your form");
            }
        }