private bool UpsertEvent(EventAdministrationViewModel viewModel, VenueModel venueModelForConcert, PerformerModel artistFromDb) { // Add event if it doesn't exist const ServerTargetEnum saveToShardDb = ServerTargetEnum.Primary; var eventDateTime = new DateTime(viewModel.Year, viewModel.Month, viewModel.Day, 20, 0, 0); if (_concertRepository.SaveNewConcert(viewModel.NewEvent, viewModel.Description, eventDateTime, saveToShardDb, venueModelForConcert.VenueId, artistFromDb.PerformerId) == null) { DisplayMessage(String.Format(" Failed to add new concert event. \'{0}\'", viewModel.NewEvent)); return false; } DisplayMessage(string.Format("Successfully added new event {0}.", viewModel.NewEvent)); return true; }
private ConcertModel PopulateSingleConcertFromDbReader(SqlDataReader dbReader) { var concertPerformer = new PerformerModel { PerformerId = dbReader.GetInt32(dbReader.GetOrdinal(@"performerId")), FirstName = dbReader.GetString(dbReader.GetOrdinal(@"performerFirstName")), LastName = dbReader.GetString(dbReader.GetOrdinal(@"performerLastName")), ShortName = dbReader.GetString(dbReader.GetOrdinal(@"performerShortName")) }; var concertToReturn = new ConcertModel { ConcertId = dbReader.GetInt32(dbReader.GetOrdinal(@"concertId")), ConcertDate = dbReader.GetDateTime(dbReader.GetOrdinal(@"concertDate")), ConcertName = dbReader.GetString(dbReader.GetOrdinal(@"concertName")), VenueId = dbReader.GetInt32(dbReader.GetOrdinal(@"venueId")), Description = dbReader.GetString(dbReader.GetOrdinal(@"concertDescription")), PerformerId = dbReader.GetInt32(dbReader.GetOrdinal(@"concertPerformerId")), PerformerModel = concertPerformer, SaveToDbServer = (dbReader.IsDBNull(dbReader.GetOrdinal(@"saveToDatabase"))) ? ((int)ServerTargetEnum.Primary) : ((ServerTargetEnum)dbReader.GetInt32(dbReader.GetOrdinal(@"saveToDatabase"))) }; return concertToReturn; }
private bool UpsertArtist(EventAdministrationViewModel viewModel, out PerformerModel artistFromDb) { // Add artist if it doesn't exist if (!string.IsNullOrWhiteSpace(viewModel.NewArtist)) { artistFromDb = _artistRepository.GetArtistByName(viewModel.NewArtist.Trim()); if (artistFromDb == null) { artistFromDb = _artistRepository.AddNewArtist(viewModel.NewArtist); if (artistFromDb == null) { DisplayMessage(String.Format("Failed to add new Artist '{0}'. Cannot Continue.", viewModel.NewArtist)); return false; } } } else { artistFromDb = _artistRepository.GetArtistById(viewModel.ArtistId); } return true; }