public Performance()
{
Id = 0;
Start = new DateTime();
Artist = null;
Venue = null;
}
public Performance(int id, DateTime start, Artist artist, Venue venue)
{
Id = id;
Start = start;
Artist = artist;
Venue = venue;
}
public Restriction(int id, DateTime start, DateTime end, Venue venue, Category category)
{
Id = id;
Start = start;
End = end;
Venue = venue;
Category = category;
}
public List<Performance> GetPerformanceByVenueAndDate(Venue venue, string date)
{
DateTime day;
if (DateTime.TryParse(date, out day))
{
return new List<Performance>(viewBL.GetPerformanceByVenueAndDate(venue, day));
}
return new List<Performance>();
}
private void CreateTestData()
{
var loc = new Location(LOCATION_ID, LOCATION);
var locationDao = new LocationDao(database);
locationDao.Insert(loc);
var venue = new Venue(VENUE_ID, VENUE_LABEL, VENUE_SPECTATORS, loc, 0, 0);
var venueDao = new VenueDao(database);
venueDao.Insert(venue);
var category = new Category(CATEGORY_ID, CATEGORY_LABEL);
var categoryDao = new CategoryDao(database);
categoryDao.Insert(category);
items = new List<Restriction>();
items.Add(new Restriction(1, RESTRICTION1_START, RESTRICTION1_STOP, venue, category));
items.Add(new Restriction(2, RESTRICTION2_START, RESTRICTION2_STOP, venue, category));
items.Add(new Restriction(3, RESTRICTION3_START, RESTRICTION3_STOP, venue, category));
items.Add(new Restriction(4, RESTRICTION4_START, RESTRICTION4_STOP, venue, category));
}
private void CreateTestData()
{
var loc = new Location(LOCATION_ID, LOCATION);
var locationDao = new LocationDao(database);
locationDao.Insert(loc);
var venue = new Venue(VENUE_ID, VENUE_LABEL, VENUE_SPECTATORS, loc, 0, 0);
var venueDao = new VenueDao(database);
venueDao.Insert(venue);
var category = new Category(CATEGORY_ID, CATEGORY_LABEL);
var categoryDao = new CategoryDao(database);
categoryDao.Insert(category);
var artist = new Artist(ARTIST_ID, ARTIST_NAME, ARTIST_COUNTRY, ARTIST_MAIL, "", "", "", "", category, false);
var artistDao = new ArtistDao(database);
artistDao.Insert(artist);
items = new List<Performance>();
items.Add(new Performance(1, PERFORMANCE1_START, artist, venue));
items.Add(new Performance(2, PERFORMANCE2_START, artist, venue));
items.Add(new Performance(3, PERFORMANCE3_START, artist, venue));
items.Add(new Performance(4, PERFORMANCE4_START, artist, venue));
}
/// <summary>
/// Gets the performance by venue and date.
/// </summary>
/// <param name="venue">The venue.</param>
/// <param name="date">The date.</param>
/// <returns></returns>
public IList<Performance> GetPerformanceByVenueAndDate(Venue venue, DateTime date)
{
DateTime start = new DateTime(date.Year, date.Month, date.Day, 0, 0, 0);
DateTime end = new DateTime(date.Year, date.Month, date.Day, 23, 59, 59);
return performanceDao.FindByVenueAndDate(venue.Label, start, end);
}
/// <summary>
/// Gets the performance by venue.
/// </summary>
/// <param name="venue">The venue.</param>
/// <returns></returns>
public IList<Performance> GetPerformanceByVenue(Venue venue)
{
return performanceDao.FindByVenue(venue.Label);
}
public List<Performance> GetPerformanceByVenue(Venue venue)
{
return new List<Performance>(viewBL.GetPerformanceByVenue(venue));
}
public void UpdateVenue(Venue venue)
{
if (venue == null)
throw new ArgumentNullException("Invalid venue!");
if (venueDao.FindById(venue.Id, venue.Location.Id) != null)
{
if (!venueDao.Update(venue))
throw new VenueException("Cannot update venue!");
}
else
{
CreateVenue(venue);
}
}
public void RemoveVenue(Venue venue)
{
if (venue == null)
throw new ArgumentNullException("Invalid venue!");
if (!venueDao.Delete(venue.Id, venue.Location.Id))
throw new VenueException("Cannot delete venue!");
}
public void CreateVenue(Venue venue)
{
if (venue == null)
throw new ArgumentNullException("Invalid Venue!");
if (!venueDao.Insert(venue))
throw new VenueException("Cannot insert venue!");
}
public bool Update(Venue o)
{
if (o == null ||
o.Label == null ||
o.Location == null)
return false;
var command = _database.CreateCommand(SQL_UPDATE);
_database.DefineParameter(command, "@idVenue", DbType.Int32, o.Id);
_database.DefineParameter(command, "@idLocation", DbType.Int32, o.Location.Id);
_database.DefineParameter(command, "@label", DbType.String, o.Label);
_database.DefineParameter(command, "@location", DbType.String, o.Location.Id);
_database.DefineParameter(command, "@maxSpectators", DbType.Int32, o.MaxSpectators);
_database.DefineParameter(command, "@latitude", DbType.Double, o.Latitude);
_database.DefineParameter(command, "@longitude", DbType.Double, o.Longitude);
return _database.ExecuteNonQuery(command) == 1;
}
