public async Task <IActionResult> Create([Bind("Name,CharacterID,WorldID,LocationID,Summary")] Character character)
{
ViewBag.data = null;
if (ModelState.IsValid)
{
var location = await _context.Locations.Include(l => l.World).FirstOrDefaultAsync(m => m.LocationID == character.LocationID);
//if (character.LocationID != null)
// {
if (character.LocationID != null && character.WorldID != location.WorldID)
{
ViewData["LocationID"] = new SelectList(_context.Locations, "LocationID", "Name", character.LocationID);
ViewData["WorldID"] = new SelectList(_context.Worlds, "WorldID", "Name", character.WorldID);
ViewBag.location = location;
return(View(character));
}
// }
_context.Add(character);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
ViewData["LocationID"] = new SelectList(_context.Locations, "LocationID", "Name", character.LocationID);
ViewData["WorldID"] = new SelectList(_context.Worlds, "WorldID", "Name", character.WorldID);
return(View(character));
}
public async Task <IActionResult> PutStop([FromRoute] long id, [FromBody] Stop stop)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != stop.Id)
{
return(BadRequest());
}
_context.Entry(stop).State = EntityState.Modified;
try
{
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!StopExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(NoContent());
}
public async Task <IActionResult> Create([Bind("Name,Summary,WorldID")] World world)
{
if (ModelState.IsValid && world.Name != null)
{
_context.Add(world);
await _context.SaveChangesAsync();
return(RedirectToAction("World", "Worlds", new { id = world.WorldID }));
}
return(View(world));
}
public async Task <IActionResult> Create([Bind("LoreID,WorldID,Title,Details")] Lore lore)
{
if (ModelState.IsValid && lore.Title != null)
{
_context.Add(lore);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
ViewData["WorldID"] = new SelectList(_context.Worlds, "WorldID", "Name", lore.WorldID);
return(View(lore));
}
public async Task <IActionResult> Create([Bind("LocationID,WorldID,Name,Summary")] Location location)
{
if (ModelState.IsValid && location.Name != null)
{
_context.Add(location);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
ViewData["WorldID"] = new SelectList(_context.Worlds, "WorldID", "Name", location.WorldID);
return(View(location));
}
public async Task AsyncData()
{
using (var context = new WorldContext())
{
await context.Database.EnsureDeletedAsync();
await context.Database.EnsureCreatedAsync();
var america = new Continent {
Code = "AM", Name = "America"
};
var europe = new Continent {
Code = "EU", Name = "Europe"
};
var asia = new Continent {
Code = "AS", Name = "Asia"
};
var africa = new Continent {
Code = "AF", Name = "Africa"
};
await context.AddAsync(america);
await context.AddRangeAsync(europe, asia, africa);
var result = context.SaveChangesAsync();
result.Wait(30_000);
Assert.Null(result.Exception);
Assert.Equal(4, result.Result);
}
using (var context = new WorldContext())
{
var continent = await context.FindAsync <Continent>("AS");
Assert.Equal("Asia", continent.Name);
var continents = await context.Continents.ToListAsync();
Assert.Equal(4, continents.Count);
}
}
public async Task EnsureSeedDataAsync()
{
if (await _userManager.FindByEmailAsync("*****@*****.**") == null)
{
var user = new WorldUser()
{
UserName = "******",
Email = "*****@*****.**"
};
var result = await _userManager.CreateAsync(user, "X");
Debug.WriteLine(result);
_logger.LogDebug(String.Format("Default user creation result:{0} {1}", result.Succeeded, result.Errors));
}
if (!_context.Trips.Any())
{
Trip t = new Trip()
{
Created = DateTime.UtcNow,
Name = "Cappadocia",
UserName = "******",
Destinations = new List <Stop>
{
new Stop()
{
Arrival = DateTime.UtcNow,
Order = 1,
Name = "Uchisar",
Latitude = 0.123,
Longitude = 0.321
},
new Stop()
{
Arrival = DateTime.UtcNow,
Order = 2,
Name = "Ortahisar",
Latitude = 2.123,
Longitude = 2.321
},
new Stop()
{
Arrival = DateTime.UtcNow,
Order = 3,
Name = "Göreme",
Latitude = 3.123,
Longitude = 3.321
},
new Stop()
{
Arrival = DateTime.UtcNow,
Order = 4,
Name = "Ürgüp",
Latitude = 4.123,
Longitude = 4.321
}
}
};
_context.Trips.Add(t);
await _context.SaveChangesAsync();
}
}
public async Task EnsureSeedData()
{
if (!_context.Trips.Any())
{
var usTrip = new Trip()
{
DateCreated = DateTime.UtcNow,
Name = "US Trip",
UserName = "", //TODO Populate this later
Stops = new List <Stop>
{
new Stop()
{
Name = "Atlanta, GA", Arrival = new DateTime(2014, 6, 4), Latitude = 33.748995, Longitude = -84.387982, Order = 0
},
new Stop()
{
Name = "New York, NY", Arrival = new DateTime(2014, 6, 9), Latitude = 40.712784, Longitude = -74.005941, Order = 1
},
new Stop()
{
Name = "Boston, MA", Arrival = new DateTime(2014, 7, 1), Latitude = 42.360082, Longitude = -71.058880, Order = 2
},
new Stop()
{
Name = "Chicago, IL", Arrival = new DateTime(2014, 7, 10), Latitude = 41.878114, Longitude = -87.629798, Order = 3
},
new Stop()
{
Name = "Seattle, WA", Arrival = new DateTime(2014, 8, 13), Latitude = 47.606209, Longitude = -122.332071, Order = 4
},
new Stop()
{
Name = "Atlanta, GA", Arrival = new DateTime(2014, 8, 23), Latitude = 33.748995, Longitude = -84.387982, Order = 5
},
}
};
_context.Trips.Add(usTrip);
_context.Stops.AddRange(usTrip.Stops);
var worldTrip = new Trip()
{
DateCreated = DateTime.UtcNow,
Name = "World Tour",
UserName = "", // Add this later
Stops = new List <Stop>
{
new Stop()
{
Order = 0, Latitude = 33.748995, Longitude = -84.387982, Name = "Atlanta, Georgia", Arrival = DateTime.Parse("Jun 3, 2014")
},
new Stop()
{
Order = 1, Latitude = 48.856614, Longitude = 2.352222, Name = "Paris, France", Arrival = DateTime.Parse("Jun 4, 2014")
},
new Stop()
{
Order = 2, Latitude = 50.850000, Longitude = 4.350000, Name = "Brussels, Belgium", Arrival = DateTime.Parse("Jun 25, 2014")
},
new Stop()
{
Order = 3, Latitude = 51.209348, Longitude = 3.224700, Name = "Bruges, Belgium", Arrival = DateTime.Parse("Jun 28, 2014")
},
new Stop()
{
Order = 4, Latitude = 48.856614, Longitude = 2.352222, Name = "Paris, France", Arrival = DateTime.Parse("Jun 30, 2014")
},
new Stop()
{
Order = 5, Latitude = 51.508515, Longitude = -0.125487, Name = "London, UK", Arrival = DateTime.Parse("Jul 8, 2014")
},
new Stop()
{
Order = 6, Latitude = 51.454513, Longitude = -2.587910, Name = "Bristol, UK", Arrival = DateTime.Parse("Jul 24, 2014")
},
new Stop()
{
Order = 7, Latitude = 52.078000, Longitude = -2.783000, Name = "Stretton Sugwas, UK", Arrival = DateTime.Parse("Jul 29, 2014")
},
new Stop()
{
Order = 8, Latitude = 51.864211, Longitude = -2.238034, Name = "Gloucestershire, UK", Arrival = DateTime.Parse("Jul 30, 2014")
},
new Stop()
{
Order = 9, Latitude = 52.954783, Longitude = -1.158109, Name = "Nottingham, UK", Arrival = DateTime.Parse("Jul 31, 2014")
},
new Stop()
{
Order = 10, Latitude = 51.508515, Longitude = -0.125487, Name = "London, UK", Arrival = DateTime.Parse("Aug 1, 2014")
},
new Stop()
{
Order = 11, Latitude = 55.953252, Longitude = -3.188267, Name = "Edinburgh, UK", Arrival = DateTime.Parse("Aug 5, 2014")
},
new Stop()
{
Order = 12, Latitude = 55.864237, Longitude = -4.251806, Name = "Glasgow, UK", Arrival = DateTime.Parse("Aug 6, 2014")
},
new Stop()
{
Order = 13, Latitude = 57.149717, Longitude = -2.094278, Name = "Aberdeen, UK", Arrival = DateTime.Parse("Aug 7, 2014")
},
new Stop()
{
Order = 14, Latitude = 55.953252, Longitude = -3.188267, Name = "Edinburgh, UK", Arrival = DateTime.Parse("Aug 8, 2014")
},
new Stop()
{
Order = 15, Latitude = 51.508515, Longitude = -0.125487, Name = "London, UK", Arrival = DateTime.Parse("Aug 10, 2014")
},
new Stop()
{
Order = 16, Latitude = 52.370216, Longitude = 4.895168, Name = "Amsterdam, Netherlands", Arrival = DateTime.Parse("Aug 14, 2014")
},
new Stop()
{
Order = 17, Latitude = 48.583148, Longitude = 7.747882, Name = "Strasbourg, France", Arrival = DateTime.Parse("Aug 17, 2014")
},
new Stop()
{
Order = 18, Latitude = 46.519962, Longitude = 6.633597, Name = "Lausanne, Switzerland", Arrival = DateTime.Parse("Aug 19, 2014")
},
new Stop()
{
Order = 19, Latitude = 46.021073, Longitude = 7.747937, Name = "Zermatt, Switzerland", Arrival = DateTime.Parse("Aug 27, 2014")
},
new Stop()
{
Order = 20, Latitude = 46.519962, Longitude = 6.633597, Name = "Lausanne, Switzerland", Arrival = DateTime.Parse("Aug 29, 2014")
},
new Stop()
{
Order = 21, Latitude = 53.349805, Longitude = -6.260310, Name = "Dublin, Ireland", Arrival = DateTime.Parse("Sep 2, 2014")
},
new Stop()
{
Order = 22, Latitude = 54.597285, Longitude = -5.930120, Name = "Belfast, Northern Ireland", Arrival = DateTime.Parse("Sep 7, 2014")
},
new Stop()
{
Order = 23, Latitude = 53.349805, Longitude = -6.260310, Name = "Dublin, Ireland", Arrival = DateTime.Parse("Sep 9, 2014")
},
new Stop()
{
Order = 24, Latitude = 47.368650, Longitude = 8.539183, Name = "Zurich, Switzerland", Arrival = DateTime.Parse("Sep 16, 2014")
},
new Stop()
{
Order = 25, Latitude = 48.135125, Longitude = 11.581981, Name = "Munich, Germany", Arrival = DateTime.Parse("Sep 19, 2014")
},
new Stop()
{
Order = 26, Latitude = 50.075538, Longitude = 14.437800, Name = "Prague, Czech Republic", Arrival = DateTime.Parse("Sep 21, 2014")
},
new Stop()
{
Order = 27, Latitude = 51.050409, Longitude = 13.737262, Name = "Dresden, Germany", Arrival = DateTime.Parse("Oct 1, 2014")
},
new Stop()
{
Order = 28, Latitude = 50.075538, Longitude = 14.437800, Name = "Prague, Czech Republic", Arrival = DateTime.Parse("Oct 4, 2014")
},
new Stop()
{
Order = 29, Latitude = 42.650661, Longitude = 18.094424, Name = "Dubrovnik, Croatia", Arrival = DateTime.Parse("Oct 10, 2014")
},
new Stop()
{
Order = 30, Latitude = 42.697708, Longitude = 23.321868, Name = "Sofia, Bulgaria", Arrival = DateTime.Parse("Oct 16, 2014")
},
new Stop()
{
Order = 31, Latitude = 45.658928, Longitude = 25.539608, Name = "Brosov, Romania", Arrival = DateTime.Parse("Oct 20, 2014")
},
new Stop()
{
Order = 32, Latitude = 41.005270, Longitude = 28.976960, Name = "Istanbul, Turkey", Arrival = DateTime.Parse("Nov 1, 2014")
},
new Stop()
{
Order = 33, Latitude = 45.815011, Longitude = 15.981919, Name = "Zagreb, Croatia", Arrival = DateTime.Parse("Nov 11, 2014")
},
new Stop()
{
Order = 34, Latitude = 41.005270, Longitude = 28.976960, Name = "Istanbul, Turkey", Arrival = DateTime.Parse("Nov 15, 2014")
},
new Stop()
{
Order = 35, Latitude = 50.850000, Longitude = 4.350000, Name = "Brussels, Belgium", Arrival = DateTime.Parse("Nov 25, 2014")
},
new Stop()
{
Order = 36, Latitude = 50.937531, Longitude = 6.960279, Name = "Cologne, Germany", Arrival = DateTime.Parse("Nov 30, 2014")
},
new Stop()
{
Order = 37, Latitude = 48.208174, Longitude = 16.373819, Name = "Vienna, Austria", Arrival = DateTime.Parse("Dec 4, 2014")
},
new Stop()
{
Order = 38, Latitude = 47.497912, Longitude = 19.040235, Name = "Budapest, Hungary", Arrival = DateTime.Parse("Dec 28,2014")
},
new Stop()
{
Order = 39, Latitude = 37.983716, Longitude = 23.729310, Name = "Athens, Greece", Arrival = DateTime.Parse("Jan 2, 2015")
},
new Stop()
{
Order = 40, Latitude = -25.746111, Longitude = 28.188056, Name = "Pretoria, South Africa", Arrival = DateTime.Parse("Jan 19, 2015")
},
new Stop()
{
Order = 41, Latitude = 43.771033, Longitude = 11.248001, Name = "Florence, Italy", Arrival = DateTime.Parse("Feb 1, 2015")
},
new Stop()
{
Order = 42, Latitude = 45.440847, Longitude = 12.315515, Name = "Venice, Italy", Arrival = DateTime.Parse("Feb 9, 2015")
},
new Stop()
{
Order = 43, Latitude = 43.771033, Longitude = 11.248001, Name = "Florence, Italy", Arrival = DateTime.Parse("Feb 13, 2015")
},
new Stop()
{
Order = 44, Latitude = 41.872389, Longitude = 12.480180, Name = "Rome, Italy", Arrival = DateTime.Parse("Feb 17, 2015")
},
new Stop()
{
Order = 45, Latitude = 28.632244, Longitude = 77.220724, Name = "New Delhi, India", Arrival = DateTime.Parse("Mar 4, 2015")
},
new Stop()
{
Order = 46, Latitude = 27.700000, Longitude = 85.333333, Name = "Kathmandu, Nepal", Arrival = DateTime.Parse("Mar 10, 2015")
},
new Stop()
{
Order = 47, Latitude = 28.632244, Longitude = 77.220724, Name = "New Delhi, India", Arrival = DateTime.Parse("Mar 11, 2015")
},
new Stop()
{
Order = 48, Latitude = 22.1667, Longitude = 113.5500, Name = "Macau", Arrival = DateTime.Parse("Mar 21, 2015")
},
new Stop()
{
Order = 49, Latitude = 22.396428, Longitude = 114.109497, Name = "Hong Kong", Arrival = DateTime.Parse("Mar 24, 2015")
},
new Stop()
{
Order = 50, Latitude = 39.904030, Longitude = 116.407526, Name = "Beijing, China", Arrival = DateTime.Parse("Apr 19, 2015")
},
new Stop()
{
Order = 51, Latitude = 22.396428, Longitude = 114.109497, Name = "Hong Kong", Arrival = DateTime.Parse("Apr 24, 2015")
},
new Stop()
{
Order = 52, Latitude = 1.352083, Longitude = 103.819836, Name = "Singapore", Arrival = DateTime.Parse("Apr 30, 2015")
},
new Stop()
{
Order = 53, Latitude = 3.139003, Longitude = 101.686855, Name = "Kuala Lumpor, Malaysia", Arrival = DateTime.Parse("May 7, 2015")
},
new Stop()
{
Order = 54, Latitude = 13.727896, Longitude = 100.524123, Name = "Bangkok, Thailand", Arrival = DateTime.Parse("May 24, 2015")
},
new Stop()
{
Order = 55, Latitude = 33.748995, Longitude = -84.387982, Name = "Atlanta, Georgia", Arrival = DateTime.Parse("Jun 17, 2015")
},
}
};
_context.Trips.Add(worldTrip);
_context.Stops.AddRange(worldTrip.Stops);
await _context.SaveChangesAsync();
}
}
public async Task <IActionResult> Create([Bind("RelationshipID,Character1ID,Character2ID,RelationshipTypeID,Details")] Relationship Relationship)
{
bool related = false;
var context = _context.Relationships.Where(c => c.Character1ID == Relationship.Character1ID).ToList();
foreach (var c in context)
{
if (c.Character2ID == Relationship.Character2ID)
{
related = true;
break;
}
}
if (ModelState.IsValid && !related)
{
await UpdateRelationsAsync(Relationship);
_context.Add(Relationship);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
ViewBag.related = true;
ViewData["RelationshipTypeID"] = new SelectList(_context.RelationshipTypes, "RelationshipTypeID", "Description", Relationship.RelationshipTypeID);
ViewBag.char1 = new SelectList(_context.Characters.Where(c => c.CharacterID == Relationship.Character1ID), "CharacterID", "Name");
ViewBag.chars = new SelectList(_context.Characters.Where(c => c.CharacterID != Relationship.Character1ID), "CharacterID", "Name");
return(View());
}
// Returns whether or not the changes were saved
public async Task <bool> SaveChangesAsync()
{
int result = await _context.SaveChangesAsync();
return(result > 0);
}
public async Task <int> SaveContext()
{
_logger.LogInformation("Save context to BBDD");
return(await _context.SaveChangesAsync());
}