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");
}
}
