/// <summary>
/// Edits a musician; this is not the most efficient way to edit a record; just demonstrating the repository in action.
/// </summary>
static void EditMusician()
{
using (var db = new DB_Bands())
{
var musicianRepo = new MusicianRepository(db);
var bandRepo = new BandRepository(db);
var random = new Random();
var bands = bandRepo.GetAll();
var musicians = musicianRepo.GetAll();
var mi = random.Next(0, musicians.Count);
var bi = random.Next(0, bands.Count);
var musicianId = musicians[mi].MusicianId;
var bandId = bands[bi].BandId;
var randomMusician = musicianRepo.GetById(musicianId);
var randomBand = bandRepo.GetById(bandId);
if (randomMusician.Band != null && randomMusician.Band.Name.Equals(randomBand.Name))
{
Console.WriteLine("Selected " + randomMusician.Name + " and " + randomBand.Name + ". No Edit was made. Please try again.");
Console.WriteLine("");
return;
}
randomMusician.Band = randomBand;
musicianRepo.Save();
Console.WriteLine("Edited: " + randomMusician.Name + " - New band: " + randomMusician.Band.Name);
}
Console.WriteLine("");
}
/// <summary>
/// Deleted a musician; this is not the most efficient way to edit a record; just demonstrating the repository in action.
/// </summary>
static void DeleteMusician()
{
using (var db = new DB_Bands())
{
var repo = new MusicianRepository(db);
var random = new Random();
var musicians = repo.GetAll();
var index = random.Next(0, musicians.Count);
var musicianId = musicians[index].MusicianId;
var randomMusician = repo.GetById(musicianId);
repo.Delete(randomMusician);
repo.Save();
Console.WriteLine("Deleted: " + randomMusician.Name);
}
Console.WriteLine("");
}