public void TestInsert()
{
// arrange
bool expectedValue = true;
Artist newArtist = new Artist("Anne & Mitja", "test.jpg", "test2.jpg", "Akrobatik&Tanz", "DE");
bool beforeInsert = aDao.GetAll().Count == 91;
// act
aDao.Insert(newArtist);
bool afterInsert = aDao.GetAll().Count == 92;
// assert
bool actualValue = (beforeInsert && afterInsert);
Assert.AreEqual(expectedValue, actualValue, "Artist has not been inserted successfully.");
}
public bool Update(Artist a)
{
return database.ExecuteNonQuery(CreateUpdateCommand(a.Name, a.PictureURL, a.PromoVideoURL, a.CategoryName, a.CountryCode)) == 1;
}
public ArtistVM(Artist artist)
{
this.artist = artist;
}
public ICollection<Performance> FilterPerformances(Artist artist, Venue venue, Category category, int from, int to)
{
ICollection<Performance> performances = performanceDao.GetAll();
ICollection<Artist> artists = artistDao.GetAll();
HashSet<Performance> pList1 = null;
HashSet<Performance> pList2 = null;
HashSet<Performance> pList3 = null;
HashSet<Performance> pList4 = null;
// get performances containing artist
if (artist != null)
{
foreach (Performance p in performances)
{
if (p.Artist == artist.Name)
pList1.Add(p);
}
}
// get performances at venue
if (venue != null)
{
foreach (Performance p in performances)
{
if (p.Venue == venue.ShortName)
pList2.Add(p);
}
}
// get performances containing artists of category
if (category != null)
{
foreach (Artist a in artists)
{
if (a.CategoryName == category.CategoryName)
{
foreach (Performance p in performances)
{
if (p.Artist == a.Name)
pList3.Add(p);
}
}
}
}
// get performances from starting with 1400, to approx. 2400
if ((from >= 14 && from <= 23) && (to <= 24 && to >= 15))
{
foreach (Performance p in performances)
{
if (p.Time >= from && p.Time <= to)
pList4.Add(p);
}
}
else if (from >= 14 && from <= 23) // only from
{
{
foreach (Performance p in performances)
{
if (p.Time >= from)
pList4.Add(p);
}
}
}
else if (to <= 24 && to >= 15) // only to
{
foreach (Performance p in performances)
{
if (p.Time <= to)
pList4.Add(p);
}
}
// create result out of partial results
HashSet<Performance> result = new HashSet<Performance>();
if (pList1 != null)
foreach (Performance p in pList1)
result.Add(p);
if (pList2 != null)
foreach (Performance p in pList2)
result.Add(p);
if (pList3 != null)
foreach (Performance p in pList3)
result.Add(p);
if (pList4 != null)
foreach (Performance p in pList4)
result.Add(p);
return new List<Performance>(result);
}
public bool DeleteArtist(Artist artist)
{
return artistDao.Delete(artist.Name);
}
public bool UpdateArtist(Artist artist)
{
return artistDao.Update(artist);
}
public bool InsertArtist(Artist artist)
{
return artistDao.Insert(artist);
}