public ActionResult EventVenue(EventVenueViewModel eventVenueVm)
{
try
{
if (User.IsInRole(AppEnum.RoleEnum.User.ToString()))
{
return(new HttpNotFoundResult());
}
if (ModelState.IsValid)
{
EventVenue eventVenue = new EventVenue();
eventVenue.EventVenueName = eventVenueVm.EventVenueName;
db.EventVenues.Add(eventVenue);
var count = db.SaveChanges();
if (count > 0)
{
ModelState.Clear();
TempData["msg"] = "Event Venue information has been successfully saved.";
return(View("EventVenue"));
}
}
return(RedirectToAction("Index", "Home", "Home"));
}
catch (Exception)
{
return(View());
}
}
public static MvcHtmlString VenueLink(this HtmlHelper html, EventVenue v)
{
return(html.ActionLink(
v.Name,
MVC.Site.Ticket.Venue(v.Id.Substring("ticketjonesvenue-".Length))
));
}
public ActionResult DeleteConfirmed(int id)
{
EventVenue eventvenue = db.Venues.Find(id);
db.Venues.Remove(eventvenue);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Edit([Bind(Include = "Id,AreaId,Name,Address,Capacity,Image")] EventVenue eventvenue)
{
if (ModelState.IsValid)
{
db.Entry(eventvenue).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.AreaId = new SelectList(db.Areas, "AreaId", "Name", eventvenue.AreaId);
return(View(eventvenue));
}
private EventVenue GetOrCreateVenue(EventVenue eventVenue)
{
var existing = _db.Venues.FirstOrDefault(e => e.ExternalId == eventVenue.ExternalId);
if (existing != null)
{
return(existing);
}
_db.Add(eventVenue);
return(eventVenue);
}
// GET: /Venue/Details/5
public ActionResult Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
EventVenue eventvenue = db.Venues.Find(id);
if (eventvenue == null)
{
return(HttpNotFound());
}
return(View(eventvenue));
}
// GET: /Venue/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
EventVenue eventvenue = db.Venues.Find(id);
if (eventvenue == null)
{
return(HttpNotFound());
}
ViewBag.AreaId = new SelectList(db.Areas, "AreaId", "Name", eventvenue.AreaId);
return(View(eventvenue));
}
private async Task InsertAllEventsAsync()
{
foreach (dynamic @event in _events)
{
CityEvent info = GetEventData(@event);
if (info.Genre == null || info.SubGenre == null || info.Segment == null)
{
Console.WriteLine($"+++ Skipped {@event.name} (no segment or genre or subgenre)");
}
else
{
EventVenue venue = GetVenue(@event);
if (venue != null)
{
if (IsNewCityEvent(info))
{
info.Venue = venue;
_db.Events.Add(info);
Console.WriteLine($"+++ Added {@event.name} in db AND docdb");
}
else
{
Console.WriteLine($"+++ Skipped {@event.name} (already exists)");
}
}
else
{
Console.WriteLine($"+++ Skipped {@event.name} because has not venue");
}
}
try
{
await _db.SaveChangesAsync();
}
catch (Exception ex)
{
Console.WriteLine($"+++ Error saving {@event.name}: {ex.Message}");
}
}
}
public void GeoSpatialTest()
{
using (var store = GetDocumentStore())
{
new EventsBySimpleLocation().Execute(store);
using (var session = store.OpenSession())
{
var venue = new EventVenue()
{
Name = "TechHub",
AddressLine1 = "Sofia House",
City = "London",
PostalCode = "EC1Y 2BJ",
GeoLocation = new GeoLocation(38.9690000, -77.3862000)
};
session.Store(venue);
var eventListing = new EventListing("Some event")
{
Cost = "free",
EventType = EventType.Conference,
VenueId = venue.Id,
};
session.Store(eventListing);
session.SaveChanges();
}
WaitForIndexing(store);
using (var session = store.OpenSession())
{
var matchingEvents = session.Advanced.DocumentQuery <EventWithLocation, EventsBySimpleLocation>()
.WaitForNonStaleResults(TimeSpan.FromMinutes(5))
.ToList();
Assert.Equal(1, matchingEvents.Count);
Assert.Equal("Some event", matchingEvents.First().EventName);
Assert.Equal("TechHub", matchingEvents.First().VenueName);
}
}
}
