private void addNewVenueButton_Click(object sender, EventArgs e) { string newVenueName = Interaction.InputBox("Please enter new venue name. This will update the venue name for any event using this venue", "Enter New Venue Name", venueSelectorComboBox.SelectedText); if (newVenueName.Length == 0) { MessageBox.Show("Error"); return; } VenueModel venue = new VenueModel(); venue.VenueName = newVenueName; //Create new venue in SQL GlobalConfig.Connection.UpSertVenue_ByVenueId(venue); eventLocation = new LocationModel(); eventLocation.Venue = venue; venueSelectorComboBox.DataSource = null; venueSelectorComboBox.Items.Add(venue); venueSelectorComboBox.DisplayMember = "VenueName"; venueSelectorComboBox.Text = venue.VenueName; DisableControls(); ClearAddressLines(); venueAddressGroupBox.Enabled = true; }
public void Addevents_Valid() { var events = new EventsModel() { Date = "2014-07-18", Artist = "Uhhhhh", Description = "I don't think they host events here anymore?", EndTime = "22:30:00", StartTime = "15:30:00" }; var venue = new VenueModel() { Name = "Lancaster events Center", Address = "4100 N 84th St, Lincoln, NE 68507", PhoneNumber = "4024416545", EmailAddress = "*****@*****.**" }; var connectionFactory = new ConnectionFactory(); var eventsDataProvider = new EventsDataProvider(connectionFactory); var eventsBuilder = new EventsBuilder(eventsDataProvider); eventsBuilder.Addevents(events, venue); }
public async Task <IActionResult> CreateVenue([FromBody] VenueModel model) { var venue = (Venue)model; venue.DateJoined = DateTime.Now; var setedAdmins = _userService.SetUsers(model.Admins); if (setedAdmins == null) { return(NotFound(new { message = "Error with admins privilage" })); } venue.Admins = setedAdmins; var createdEntity = _venueService.Insert(venue); if (createdEntity == null) { return(BadRequest(new { message = "problem with creating venue" })); } return(Ok(createdEntity)); }
public bool Addevents(EventsModel events, VenueModel venue) { var locationId = GetLocationId(venue); var eventsId = Newevents(locationId, events); return(true); }
public VenueModel GetVenueDetails(string connectionString, int tenantId) { using (var context = CreateContext(connectionString, tenantId)) { //get database name string databaseName; using (SqlConnection sqlConn = Sharding.ShardMap.OpenConnectionForKey(tenantId, connectionString)) { databaseName = sqlConn.Database; } var venueModel = context.Venue.FirstOrDefault(); var venue = new VenueModel { VenueName = venueModel.VenueName.Trim(), AdminEmail = venueModel.AdminEmail.Trim(), AdminPassword = venueModel.AdminPassword, CountryCode = venueModel.CountryCode.Trim(), PostalCode = venueModel.PostalCode, VenueType = venueModel.VenueType.Trim(), DatabaseName = databaseName }; return(venue); } }
public async Task <IActionResult> UpdateVenue(int id, [FromBody] VenueModel model) { var venue = (Venue)model; var setedAdmins = _userService.SetUsers(model.Admins); if (setedAdmins == null) { return(NotFound(new { message = "Error with admins privilage" })); } venue.Admins = setedAdmins; var updatedVenue = _venueService.Update(id, venue); if (updatedVenue == null) { return(BadRequest(new { message = "Venue not updated!" })); } return(Ok(updatedVenue)); }
public Guid Post(VenueModel venueModel) { var newId = this.venueRepository.CreateVenue(venueModel); log.LogDebug($"new venue is create with id {newId}."); return(newId); }
/// <summary> /// This method is hit when not passing any tenant name /// Will display the Events Hub page /// </summary> /// <returns></returns> public async Task <IActionResult> Index() { try { var tenantsModel = await _catalogRepository.GetAllTenants(); if (tenantsModel != null) { //get the venue name for each tenant foreach (var tenant in tenantsModel) { VenueModel venue = await _tenantRepository.GetVenueDetails(tenant.TenantId); if (venue != null) { tenant.VenueName = venue.VenueName; tenant.TenantName = venue.DatabaseName; } } return(View(tenantsModel)); } } catch (Exception ex) { _logger.LogError(0, ex, "Error in getting all tenants in Events Hub"); } return(View("Error")); }
private void VenueLayoutTreeInit() { VenueLayoutTreeSource = new ObservableCollection <TreeViewItemModel>(); var allVenues = _venueService.GetAll(); if (allVenues.Any()) { var allLayouts = _layoutService.GetAll(); foreach (var v in allVenues) { var r = from x in allLayouts where v.Id == x.VenueId select x; if (r.Any()) { VenueLayoutTreeSource.Add(new TreeViewItemModel(VenueModel.FromEntity(v), LayoutModel.FromEntityList(r.ToList()))); } else { VenueLayoutTreeSource.Add(new TreeViewItemModel(VenueModel.FromEntity(v))); } } } }
public void VenueComplete(VenueModel model) { venues.Add(model); WireupVenueDropDown(); DisplayTeamVenue.Text = model.VenueName; venueDropDown.SelectedItem = model; }
public async Task <ExecutionResponse <VenueModel> > UpdateVenue(VenueModel model) { var venue = _venueQueryRepo.GetAll().FirstOrDefault(x => x.Id == model.Id && x.CompanyId == CurrentCompanyId); if (venue == null) { return new ExecutionResponse <VenueModel> { ResponseCode = ResponseCode.NotFound, Message = "No record found" } } ; //update venue record in db venue.Name = model.Name; venue.Description = model.Description; await _venueCommandRepo.UpdateAsync(venue); await _venueCommandRepo.SaveChangesAsync(); return(new ExecutionResponse <VenueModel> { ResponseCode = ResponseCode.Ok, ResponseData = _mapper.Map <VenueModel>(venue) }); }
public async Task <ExecutionResponse <VenueModel> > CreateVenue(VenueModel model) { var oldVenue = _venueQueryRepo.GetAll().FirstOrDefault(x => x.Name.Trim().ToLower() == model.Name.Trim().ToLower()); if (oldVenue != null) { throw new Exception("Venue already exists"); } //save venue info var venue = new Venue { Name = model.Name, CompanyId = CurrentCompanyId, Description = model.Description, CreateById = _httpContext.GetCurrentSSOUserId() }; await _venueCommandRepo.InsertAsync(venue); await _venueCommandRepo.SaveChangesAsync(); return(new ExecutionResponse <VenueModel> { ResponseCode = ResponseCode.Ok, ResponseData = _mapper.Map <VenueModel>(venue) }); }
public SearchResult(VenueModel model) { Id = model.Id; Name = model.Name; Bio = string.Format("{0}, {1}, {2} {3} - {4}", model.Address, model.City, model.State, model.Zip, model.PhoneNumber); Type = SearchResultType.Venue.ToString(); }
private void wireupLists(VenueModel vm) { selectedVenueName = vm.VenueName; venueNames = new List <string>(); selectedVenueAddress = vm.VenueAddress; addresses = new List <string>(); selectedVenuePhone = vm.VenuePhone; venuePhones = new List <string>(); foreach (VenueModel model in venues) { if (model.VenueName != " Select Venue ") { if (model.VenueName != selectedVenueName) { venueNames.Add(model.VenueName); } if (model.VenueAddress != selectedVenueAddress) { addresses.Add(model.VenueAddress); } if (model.VenuePhone != selectedVenuePhone) { venuePhones.Add(model.VenuePhone); } } } }
public ActionResult Edit(int?id) { if (id.HasValue) { var Venue_ZH = _db.VenueZH.Find(id); var Venue_EN = _db.VenueEN.Find(id); var Venue = new VenueModel(); Venue.SportEN = Venue_EN.Sport; Venue.SportZH = Venue_ZH.Sport; Venue.TypeEN = Venue_EN.Type; Venue.TypeZH = Venue_ZH.Type; Venue.VenueEN = Venue_EN.Venue; Venue.VenueZH = Venue_ZH.Venue; Venue.IDZH = Venue_ZH.ID; Venue.IDEN = Venue_EN.ID; Venue.Deleted = Venue_ZH.Deleted.Value; ViewData.Model = Venue; return(View()); } // ViewData.Model = new VenueModel(); return(View()); }
public ConcertModel Getevents() { var concertModel = new ConcertModel(); var reader = _eventsDataProvider.Getevents(); int i = 0; while (reader.Read()) { var events = new EventsModel { EventsId = reader.GetInt32(0), VenueId = reader.GetInt32(1), Artist = reader.GetString(2), Description = reader.GetString(3), Date = reader.GetString(4), StartTime = reader.GetString(5), EndTime = reader.GetString(6), }; var venue = new VenueModel { LocationId = reader.GetInt32(1), Name = reader.GetString(7), Address = reader.GetString(8), PhoneNumber = reader.GetString(9), EmailAddress = reader.GetString(10) }; concertModel.Events.Add(i, events); concertModel.Venue.Add(i, venue); i += 1; } return(concertModel); }
// private List<SeatSection> GetSeatMapForVenueInternal(int venueId) // { // // Build script // var seatMapQuery = String.Format( // @"SELECT section.SeatSectionId as seatSectionId, // section.Description as seatDescription, // section.VenueId as venueId, // section.SeatCount as seatCount // FROM SeatSection as section // WHERE section.VenueId={0}", venueId); // // Get the Seat Maps for Venue // var seatMapList = DataHelper.ExecuteReader(seatMapQuery, MapRowToSeatSection); // return seatMapList; // } #endregion #region - Mapping Methods - 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 void PopulateAddressComboBox() { addressesComboBox.DataSource = null; VenueModel venue = (VenueModel)venueSelectorComboBox.SelectedItem; addressesComboBox.DataSource = GlobalConfig.Connection.GetEventAddresses_ByVenueId(venue.Id); addressesComboBox.DisplayMember = "FullMultiLineAddress"; }
/// <summary> /// This method is hit when not passing any tenant name /// Will display the Events Hub page /// </summary> /// <returns></returns> public async Task <IActionResult> Index() { try { var tenantsModel = await _catalogRepository.GetAllTenants(); if (tenantsModel != null) { //get the venue name for each tenant foreach (var tenant in tenantsModel) { VenueModel venue = null; String tenantStatus = _utilities.GetTenantStatus(tenant.TenantId); if (tenantStatus == "Online") { try { venue = await _tenantRepository.GetVenueDetails(tenant.TenantId); } catch (Microsoft.Azure.SqlDatabase.ElasticScale.ShardManagement.ShardManagementException ex) { if (ex.ErrorCode == Microsoft.Azure.SqlDatabase.ElasticScale.ShardManagement.ShardManagementErrorCode.MappingDoesNotExist) { //Fix mapping irregularities - trust local shard map _utilities.ResolveMappingDifferences(tenant.TenantId); //Get venue details if tenant is online String updatedTenantStatus = _utilities.GetTenantStatus(tenant.TenantId); if (updatedTenantStatus == "Online") { venue = await _tenantRepository.GetVenueDetails(tenant.TenantId); } } } catch (Exception ex) { _logger.LogError(0, ex, "Error in getting all tenants in Events Hub"); return(View("Error", ex.Message)); } } if (venue != null) { tenant.VenueName = venue.VenueName; tenant.TenantName = venue.DatabaseName; } } return(View(tenantsModel)); } } catch (Exception ex) { _logger.LogError(0, ex, "Error in getting all tenants in Events Hub"); return(View("Error", ex.Message)); } return(View("Error")); }
public List <LeagueModel> GetLeagues(VenueModel venue) { Task <IDocument> task = BrowsingContext.New(AppState.config).OpenAsync($"{AppState.baseURL}{venue.Href}"); task.Wait(); var leagues = processLeagues(task.Result); return(leagues); }
private void VenueNameComboBox_SelectedValueChanged(object sender, EventArgs e) { vm = (VenueModel)VenueNameComboBox.SelectedItem; if (formReady() == true) { wireupLabels(); wireupLists(vm); } }
public async Task <IActionResult> Create([FromBody] VenueModel model) { var result = await _venueService.Create(model); return(CreatedAtAction(nameof(GetById), new { id = result.Result }, result.Result)); }
public async Task <VenueModel> AddVenue(VenueModel venue) { using (var context = ContextFactory.CreateDbContext(ConnectionString)) { context.Venues.Add(venue); await context.SaveChangesAsync(); return(venue); } }
public List <VenueModel> GetVenue(string latitude, string longitude, double dist = 800) { String jsonData; List <VenueModel> venueList = new List <VenueModel>(); List <VenueModel> venueJsonList = new List <VenueModel>(); string clientID = ConfigurationSettings.AppSettings["client_id"]; string clientSecret = ConfigurationSettings.AppSettings["client_secret"]; string currentDate = DateTime.Now.ToString("yyyyMMdd").ToString(); double distance = dist; using (var client = new WebClient()) { //jsonData = client.DownloadString("https://api.foursquare.com/v2/venues/search?v=20170807&ll=38.42,27.13&intent=browse&radius=800&categoryId=4d4b7105d754a06374d81259&client_id=TOMWFBM0IH5Y3XQLE1L41JY22H5OIQO0DKUURDQ5JOKKK4Q3&client_secret=HCGTEWHVFD35NS5ABIKGI3FAXOUCGPUMC5Z0MSVCOYBBBKNX"); client.Encoding = System.Text.Encoding.UTF8; jsonData = client.DownloadString("https://api.foursquare.com/v2/venues/search?v=" + currentDate + "&ll=" + latitude + "," + longitude + "&intent=browse&radius=" + distance + "&categoryId=4d4b7105d754a06374d81259&client_id=" + clientID + "&client_secret=" + clientSecret); } JObject responseData = JObject.Parse(jsonData); var secondElement = responseData["response"]; var venuesElement = secondElement["venues"]; int VenuesCount = venuesElement.Count(); for (int i = 0; i < VenuesCount; i++) { VenueModel vm = new VenueModel(); var element = venuesElement[i]; vm.venueId = element["id"].ToString(); vm.venueName = element["name"].ToString(); var locationElement = element["location"]; vm.address = (locationElement["address"] != null) ? locationElement["address"].ToString() : String.Empty; vm.lat = double.Parse(locationElement["lat"].ToString()); vm.lng = double.Parse(locationElement["lng"].ToString()); vm.distance = (locationElement["distance"] != null) ? int.Parse(locationElement["distance"].ToString()) : -1; var categories = (element["categories"] != null) ? element["categories"] : String.Empty; var categoryElement = (categories[0] != null) ? categories[0] : String.Empty; vm.categoryId = (categoryElement != null) ? categoryElement["id"].ToString() : String.Empty; vm.categoryName = (categoryElement != null) ? categoryElement["name"].ToString() : String.Empty; //vm.url = element["url"].ToString() == null ? "No Website" : element["url"].ToString(); if (element["url"] != null) { vm.url = element["url"].ToString(); } else { vm.url = "No Website"; } venueList.Add(vm); } int cnt = venueList.Count; return(venueList); }
public static void Main() { // StudentModel example Console.WriteLine("\nTESTING STUDENT MANAGER:"); Console.WriteLine(StudentModel.create("U096988R", "asdqwe", "Felix").MatricId); var allStudents = StudentModel.getAll(); foreach (var s in allStudents) { Console.WriteLine("{0}--{1}--{2}", s.Key, s.Value.Name, s.Value.Password); } Student student = StudentModel.getByMatricId("U096988R"); Console.WriteLine("Student's name is {0}", student.Name); foreach (var ev in student.OwnedEvents) { Console.WriteLine("{0} organizes {1} in {2}", student.Name, ev.Name); } Console.WriteLine("First auth attempt, {0}", StudentModel.authenticate("U096988R", "asdqwe")); Console.WriteLine("Second auth attempt, {0}", StudentModel.authenticate("U096988R", "aqwe")); // Venue Console.WriteLine("\nTESTING VENUE MANAGER:"); //var newVenue = VenueModel.create("LT19 school of computing"); //Console.WriteLine("Created venue: {0} with ID: {1}\n", newVenue.Name, newVenue.Id); var venues = VenueModel.getAll(); Console.WriteLine("A list of venues:"); foreach (var v in venues) { Console.WriteLine("{0}.) {1}", v.Id, v.Name); } // EventModel example Console.WriteLine("\nTESTING EVENT MANAGER:"); var newEvent = EventModel.create("U096988R", "My new event 2", 2, new DateTime(2012, 2, 5, 6, 0, 0), new DateTime(2012, 2, 5, 9, 0, 0), 100, 30, "Just another event"); Console.WriteLine("{0}, {1}", newEvent.Name, newEvent.Description); var allEvents = EventModel.getAllForLoginPage(); Console.WriteLine("Loading all events:"); foreach (var s in allEvents) { Console.WriteLine("EventName:{0},\nVenue:{1}\nOwner:{2}\n", s.Name, s.Owner.Name); } // student registering event Console.WriteLine("Student register event"); Console.WriteLine(EventModel.registerGuest("U096988R", 2)); Console.WriteLine(""); Console.WriteLine("End tester"); Console.WriteLine("Press any key to exit..."); Console.ReadKey(); }
// GET: Backend/Venue public ActionResult Index(int Page = 1) { var currentPage = Page < 1 ? 1 : Page; var PageSize = 15; var model = new VenueModel().List(); var PageModel = model.ToPagedList(currentPage, PageSize); //ViewBag.GameList = new GameSiteListModel().List(); ViewData.Model = PageModel; return(View()); }
public async Task <IActionResult> Update([FromRoute] int id, [FromBody] VenueModel model) { var resultStatus = await _venueService.Update(id, model); if (resultStatus == VenueOperationStatus.DoesNotExists) { return(NotFound()); } return(NoContent()); }
public ActionResult Post([FromBody] VenueModel body) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } VenueModel item = _service.Create(body); return(CreatedAtAction("Get", new { id = item.Id }, item)); }
public async Task <VenueViewModel> UpdateVenue(VenueModel venue) { var model = await _repository.UpdateVenueAsync(venue); return(new VenueViewModel { CityId = model.CityId, Description = model.Description, Id = model.Id, Name = model.Name, }); }
public async Task <VenueViewModel> AddVenue(VenueModel venue) { var result = await _repository.AddVenue(venue); return(new VenueViewModel { CityId = result.CityId, Description = result.Description, Name = result.Name, Id = result.Id }); }
public void UpSertVenue_ByVenueId(VenueModel model) { using (IDbConnection connection = new System.Data.SqlClient.SqlConnection(GlobalConfig.CnnString(db))) { var p = new DynamicParameters(); p.Add("@VenueName", model.VenueName); p.Add("@Id", model.Id, dbType: DbType.Int32, direction: ParameterDirection.InputOutput); connection.Query <StaffModel>("dbo.spUpSertVenue_ByVenueId", p, commandType: CommandType.StoredProcedure); model.Id = p.Get <int>("@Id"); } }