public LocationViewModel(IManager manager)
{
this.manager = manager;
this.location = new Location();
SaveCommand = new RelayCommand(o => UpdateLocation());
ConfigureValidation();
}
public Venue(int id, string label, int maxSpectators, Location location, double latitude, double longitude)
{
Id = id;
Label = label;
Location = location;
MaxSpectators = maxSpectators;
Latitude = latitude;
Longitude = longitude;
}
public LocationViewModel(Location location, IManager manager)
{
this.manager = manager;
if (location == null)
this.location = new Location();
else
this.location = location;
SaveCommand = new RelayCommand(o => UpdateLocation());
ConfigureValidation();
}
private void CreateTestData()
{
var loc = new Location(LOCATION_ID, LOCATION);
var locationDao = new LocationDao(database);
locationDao.Insert(loc);
items = new List<Venue>();
items.Add(new Venue(VENUE1_ID, VENUE1_LABEL, VENUE1_SPECTATORS, loc, 0, 0));
items.Add(new Venue(VENUE2_ID, VENUE2_LABEL, VENUE2_SPECTATORS, loc, 0, 0));
items.Add(new Venue(VENUE3_ID, VENUE3_LABEL, VENUE3_SPECTATORS, loc, 0, 0));
}
public bool Insert(Location o)
{
if (o == null ||
o.Id == null ||
o.Label == null)
return false;
var command = _database.CreateCommand(SQL_INSERT);
_database.DefineParameter(command, "@id", DbType.String, o.Id);
_database.DefineParameter(command, "@label", DbType.String, o.Label);
return _database.ExecuteNonQuery(command) == 1;
}
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));
}
public void UpdateLocation(Location location)
{
if (location == null)
throw new ArgumentNullException("Invalid location!");
if (locationDao.FindById(location.Id) != null)
{
if (!locationDao.Update(location))
throw new LocationException("Cannot update location");
}
else
{
CreateLocation(location);
}
}
public void RemoveLocation(Location location)
{
if (location == null)
throw new ArgumentNullException("Invalid location!");
if (!locationDao.Delete(location.Id))
throw new LocationException("Cannot remove location");
}
public void CreateLocation(Location location)
{
if (!locationDao.Insert(location))
throw new LocationException("Cannot create location");
}
public bool LocationExists(Location location)
{
if (location == null)
throw new ArgumentNullException("Invalid location!");
return locationDao.FindById(location.Id) != null;
}
