public void CreateSportEventTest()
{
using (var db = new EventsProjectContext())
{
var sportEventsBefore = db.SportEvents.Count();
_crudManager.AddSportEvent("WMBLY", "FTBAL", "Aston Villa vs Chelsea", new DateTime(2020, 11, 07, 20, 00, 00), 40000);
var sportEventsAfter = db.SportEvents.Count();
Assert.AreEqual(sportEventsBefore + 1, sportEventsAfter);
currentSportEventId = db.SportEvents.Where(me => me.Fixture == "Aston Villa vs Chelsea").Select(me => me.SportEventId).FirstOrDefault();
}
}
private void AddEvent_Click(object sender, RoutedEventArgs e)
{
try
{
// date time entries to valid DateTime parameters
int year = DateTime.Parse(DateInfo.Text).Year;
var month = DateTime.Parse(DateInfo.Text).Month;
var day = DateTime.Parse(DateInfo.Text).Day;
var hour = DateTime.Parse(TimeInfo.Text).Hour;
var min = DateTime.Parse(TimeInfo.Text).Minute;
var dateTime = new DateTime(year, month, day, hour, min, 0);
_crudManager.AddSportEvent(NewVenue.SelectedItem.ToString(), _crudManager.SelectedSport.SportId, FixtureInfo.Text, dateTime, Int32.Parse(TicketsSoldInfo.Text));
this.Close();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
// metgod to add the event
private void AddEvent_Click(object sender, RoutedEventArgs e)
{
try
{
var artist = FixtureGenreInfo.Text;
var ticketsSold = Int32.Parse(TicketsSoldInfo.Text);
// converting the entered date and time into correct format for DateTime object
int year = DateTime.Parse(DateInfo.Text).Year;
var month = DateTime.Parse(DateInfo.Text).Month;
var day = DateTime.Parse(DateInfo.Text).Day;
var hour = DateTime.Parse(TimeInfo.Text).Hour;
var min = DateTime.Parse(TimeInfo.Text).Minute;
var dateTime = new DateTime(year, month, day, hour, min, 0);
// catch blocks to ensure everything submitted is valid
if (SportMusicBox.SelectedItem != null)
{
if (TypeBox.SelectedItem == null)
{
var id = NewGenreIdInfo.Text;
var info = NewGenreInfo.Text;
if (SportMusicBox.SelectedItem.ToString() == "Music")
{
_crudManager.AddMusicType(id, info);
var venue = _crudManager.SelectedVenue;
try
{
_crudManager.AddMusicEvent(venue.VenueId, id, artist, dateTime, ticketsSold);
this.Close();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
else if (SportMusicBox.SelectedItem.ToString() == "Sport")
{
_crudManager.AddSportType(id, info);
var venue = _crudManager.SelectedVenue;
try
{
_crudManager.AddSportEvent(venue.VenueId, id, artist, dateTime, ticketsSold);
this.Close();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
}
else if (SportMusicBox.SelectedItem.ToString() == "Music")
{
var venue = _crudManager.SelectedVenue;
var music = _crudManager.SelectedMusic;
_crudManager.AddMusicEvent(venue.VenueId, music.MusicId, artist, dateTime, ticketsSold);
this.Close();
}
else if (SportMusicBox.SelectedItem.ToString() == "Sport")
{
var venue = _crudManager.SelectedVenue;
var sport = _crudManager.SelectedSport;
_crudManager.AddSportEvent(venue.VenueId, sport.SportId, artist, dateTime, ticketsSold);
this.Close();
}
}
}
catch (Exception ex)
{
MessageBox.Show("Input was invalid");
}
}
