//public List<SeatSection> GetSeatMapForVenue(int venueId) //{ // return GetSeatMapForVenueInternal(venueId); //} public VenueModel AddNewVenue(string venueName, int cityId) { // Add Venue, continue if added var venue = new VenueModel(); var venueScript = string.Format(@"INSERT INTO [Venues] (VenueName, Capacity, CityId, Description) VALUES ('{0}', 1000, {1}, '') Select @@Identity", venueName, cityId); var venueId = DataHelper.ExecuteInsert(venueScript); if (venueId > 0) { venue.VenueId = venueId; } else { return venue; } // Add Seat Section var seatSectionScript = string.Format(@"INSERT INTO [SeatSection] (SeatCount, VenueId, Description) VALUES (100, {0}, '') Select @@Identity", venue.VenueId); var seatSectionId = DataHelper.ExecuteInsert(seatSectionScript); LogAction("Added new venue - " + venueName); return venue; }
private bool UpsertVenue(EventAdministrationViewModel viewModel, CityModel cityModelFromDb, out VenueModel venueModelFromDb) { // Add venue if it doesn't exist if (!string.IsNullOrWhiteSpace(viewModel.NewVenue)) { venueModelFromDb = _venueRepository.GetVenues().FirstOrDefault(ven => String.CompareOrdinal(ven.VenueName, viewModel.NewVenue.Trim()) == 0); if (venueModelFromDb == null) { venueModelFromDb = _venueRepository.AddNewVenue(viewModel.NewVenue, cityModelFromDb.CityId); if (venueModelFromDb == null) { DisplayMessage(String.Format(" Failed to add new Venue '{0}'. Cannot Continue.", viewModel.NewVenue)); return false; } } } else { venueModelFromDb = _venueRepository.GetVenues().FirstOrDefault(ven => ven.VenueId == viewModel.VenueId); } return true; }
private static VenueModel MapRowToVenue(SqlDataReader reader) { // Map data row into the venue var venue = new VenueModel { VenueName = reader.GetString("venueName"), Capacity = reader.GetInt32(reader.GetOrdinal("venueCapacity")), Description = reader.GetString("venueDescription"), VenueId = reader.GetInt32(reader.GetOrdinal("venueId")), VenueCityModel = new CityModel { CityName = reader.GetString("cityName"), CityId = reader.GetInt32(reader.GetOrdinal("cityId")), Description = reader.GetString("cityDescription"), StateModel = new StateModel { StateName = reader.GetString("stateName"), Description = reader.GetString("stateDescription"), Country = new Country { CountryName = reader.GetString("countryName") } } }, }; return venue; }
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; }