public void NewBand()
{
using (var db = new BandsContext())
{
Console.WriteLine();
Console.WriteLine("Add a band to the database:");
string newBand = Console.ReadLine();
if (newBand != "")
{
db.Bands.Add(new Band {
Name = newBand
});
var count = db.SaveChanges();
Console.WriteLine("{0} records saved to database", count);
}
// pause
Console.ReadLine();
}
}
public void DeleteBand()
{
using (var db = new BandsContext())
{
Console.WriteLine();
Console.WriteLine("Enter the band's name to delete");
string userInput = Console.ReadLine();
var bandToDelete = db.Bands.Where(b => b.Name.ToUpper() == userInput.ToUpper()).FirstOrDefault();
if (bandToDelete != null)
{
Console.WriteLine("Deleting {0} from the database", bandToDelete.Name);
db.Remove(bandToDelete);
db.SaveChanges();
Console.ReadLine();
}
else
{
Console.WriteLine("Could not find band: {0}", userInput);
Console.ReadLine();
}
}
}
