/// <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);
}
