public IQueryable <Band> GetBands()
{
var _db = new BandContext();
IQueryable <Band> query = _db.Bands;
return(query);
}
public ActionResult Create(Band band)
{
using (var db = new BandContext())
{
db.Bands.Add(band);
db.SaveChanges();
}
return(RedirectToAction("Index"));
}
public BandController(BandContext context)
{
_context = context;
if (_context.Band.Count() == 0)
{
_context.Band.Add(new Band {
BandName = "ROTNS", FormationYear = 2008, Members = 5, Style = "HxC"
});
_context.SaveChanges();
}
}
public void AddMultipleBandsReturnsCorrectNumberOfRowa()
{
var builder = new DbContextOptionsBuilder();
builder.UseInMemoryDatabase("AddMultipleBands");
using (var context = new BandContext(builder.Options))
{
var queryData = new QueryData(context);
var nameList = new string[] { "Kix", "Van Halen", "LynardSkynard", "The Cult" };
var result = queryData.AddMultipleBands(nameList);
Assert.AreEqual(nameList.Length, result);
}
}
public void CanInsertBandIntoDatabase()
{
var builder = new DbContextOptionsBuilder();
builder.UseInMemoryDatabase("CanInsertBand");
using (var context = new BandContext(builder.Options))
{
var band = new Band();
context.Bands.Add(band);
Assert.AreEqual(EntityState.Added, context.Entry(band).State);
}
}
public ActionResult Index(string searchBox1)
{
BandContext db = new BandContext();
{
if (!String.IsNullOrEmpty(searchBox1))
{
ViewBag.FindBand = db.Albums.Where(b => b.AlbumTitle.Contains(searchBox1) || b.Band.BandName.Contains(searchBox1));
}
else
{
ViewBag.FindBand = db.Albums.OrderBy(album => album.Band.BandName).ToList();
}
return(View());
}
}
public IQueryable <Band> GetBand([RouteData] int?Id)
{
var _db = new BandContext();
IQueryable <Band> query = _db.Bands;
if (Id.HasValue && Id > 0)
{
query = query.Where(p => p.Id == Id);
}
else
{
query = null;
}
return(query);
}
public void TestMethod1()
{
using (var context = new BandContext())
{
//context.Database.EnsureDeleted();
//context.Database.EnsureCreated();
var band = new Band();
context.Bands.Add(band);
Debug.WriteLine($"Before save: {band.Id}");
context.SaveChanges();
Debug.WriteLine($"After save: {band.Id}");
Assert.AreNotEqual(0, band.Id);
}
}
public void CanInsertSingleBand()
{
var builder = new DbContextOptionsBuilder();
builder.UseInMemoryDatabase("InsertSingleBand");
using (var context = new BandContext(builder.Options))
{
var queryData = new QueryData(context);
queryData.InsertNewBand(new Band());
}
using (var context2 = new BandContext(builder.Options))
{
Assert.AreEqual(1, context2.Bands.Count());
}
}
private async void PairButtonClicked(object sender, RoutedEventArgs e)
{
StartAction();
do
{ // Pair band
ContinueButton.IsEnabled = false;
var isSupported = await BandContext.GetBluetoothIsEnabledAsync();
if (!isSupported)
{ // Bluetooth error
EndAction();
await new MessageDialog("Please enable BlueTooth and pair phone with Band", "Error!").ShowAsync();
break;
}
GlobalContext.Band = new BandContext();
try
{ // Connect to band
isPaired = await GlobalContext.Band.PairBand().TimeoutAfter(new TimeSpan(0, 0, 15));
EndAction();
if (isPaired)
{ // Connection successfull
PairBandButton.Content = "Paired Successfully!";
PairBandButton.Width = double.NaN;
PairBandButton.Foreground = new SolidColorBrush(Colors.Black);
PairBandButton.IsEnabled = false;
}
else
{
await new MessageDialog("Did not find band\nPlease try again", "Pairing Failed!").ShowAsync();
}
}
catch (TimeoutException)
{
EndAction();
await new MessageDialog("Pairing timed out after 15 seconds", "Pairing Failed!").ShowAsync();
}
} while (false);
}
public BandManager(BandContext context)
{
_context = context;
}
public QueryData()
{
_context = new BandContext();
}
public QueryData(BandContext context)
{
_context = context;
}
public BandsController(BandContext context)
{
_context = context;
}
