/// <summary> /// Adds a musician to a band /// </summary> /// <param name="Band"></param> /// <param name="Musician"></param> /// <returns></returns> public static Band AddMusicianToBand(Band Band, Musician Musician) { using (var context = new BandBookerContext()) { var dbBand = (from x in context.Band where x.BandId == Band.BandId select x).FirstOrDefault(); var currentBM = (from x in context.BandMusician where x.BandId == Band.BandId && x.MusicianId == Musician.MusicianId select x).FirstOrDefault(); if (currentBM == null) { var dbMusician = (from x in context.Musician where x.MusicianId == Musician.MusicianId select x).FirstOrDefault(); var bm = new BandMusician() { Band = dbBand, Musician = dbMusician }; dbBand.BandMusician.Add(bm); context.SaveChanges(); } var thisband = (from x in Bands where x.BandId == Band.BandId select x).FirstOrDefault(); return(thisband); } }
static void AddMusiciansToBand() { ViewAllBands(); Console.WriteLine("What band would you like to add musicians to? Please enter the Band ID."); var bandID = Int32.Parse(Console.ReadLine()); ViewMusicians(false); var addMusician = true; var suncoastDs = new DatabaseService(); var listOfBandMusicians = new List <BandMusician>(); while (addMusician) { Console.WriteLine("What musician would you like to add to the band? Please enter the Musician ID."); var musicianID = Int32.Parse(Console.ReadLine()); var bandMusician = new BandMusician() { BandID = bandID, MusicianID = musicianID }; listOfBandMusicians.Add(bandMusician); Console.WriteLine("Would you like to add another musician to the band? (YES) or (NO)."); var userInput = Console.ReadLine().ToLower(); if (userInput == "no") { addMusician = false; } } suncoastDs.AddMusiciansToBand(listOfBandMusicians); Console.WriteLine("New musician added successfully!"); Console.WriteLine(); Thread.Sleep(3000); }