private static void SeedTravelLog(Metro2036DbContext context, TravelLogDtoImp[] travelLogsDtos)
{
var validTravelLog = new List <TravelLog>();
foreach (var travelLogDto in travelLogsDtos)
{
var userId = context.Users
.Where(u => u.UserName == travelLogDto.UserName)
.Select(u => u.Id)
.Single();
var stationId = travelLogDto.StationId;
//var travelLog = Mapper.Map<TravelLog>(travelLogDto);
var travelLog = new TravelLog
{
UserId = userId,
StationId = stationId
};
validTravelLog.Add(travelLog);
//TODO: Implement Import Logging
}
context.TravelLogs.AddRange(validTravelLog);
context.SaveChanges();
}
private static void SeedRoutes(Metro2036DbContext context, RouteDtoImp[] deserializedRoutes)
{
var validRoutes = new List <Route>();
var validPoints = new List <Point>();
foreach (var routeDto in deserializedRoutes)
{
var routeAlreadyExists = validRoutes.Any(s => s.RouteName == routeDto.RouteName);
//var route = Mapper.Map<Route>(routeDto);
//validRoutes.Add(route);
var impPoints = routeDto.Points;
foreach (var pointDtoImp in impPoints)
{
var PointToAdd = new Point
{
stop = pointDtoImp.stop,
StopCode = pointDtoImp.StopCode,
StopName = pointDtoImp.StopName,
Latitude = pointDtoImp.Latitude,
Longitude = pointDtoImp.Longitude,
VehicleType = pointDtoImp.VehicleType,
};
validPoints.Add(PointToAdd);
}
var route = new Route
{
Id = routeDto.Id,
RouteId = routeDto.RouteId,
Type = routeDto.Type,
RouteName = routeDto.RouteName,
LineId = routeDto.LineId,
ExtId = routeDto.ExtId,
LineName = routeDto.LineName,
Points = validPoints
};
validRoutes.Add(route);
//TODO: Implement Import Logging
}
context.Routes.AddRange(validRoutes);
context.Points.AddRange(validPoints);
context.SaveChanges();
}
private static void SeedStations(Metro2036DbContext context, StationDtoImp[] deserializedStations)
{
var validStations = new List <Station>();
foreach (var stationDto in deserializedStations)
{
var stationAlreadyExists = validStations.Any(s => s.Name == stationDto.Name);
var station = Mapper.Map <Station>(stationDto);
validStations.Add(station);
//TODO: Implement Import Logging
}
context.Stations.AddRange(validStations);
context.SaveChanges();
}
private static void SeedTrains(Metro2036DbContext context, TrainDtoImp[] deserializedTrains)
{
var validTrains = new List <Train>();
foreach (var trainDto in deserializedTrains)
{
var trainAlreadyExists = deserializedTrains.Any(s => s.SerialNumber == trainDto.SerialNumber);
var train = Mapper.Map <Train>(trainDto);
validTrains.Add(train);
//TODO: Implement Import Logging
}
context.Trains.AddRange(validTrains);
context.SaveChanges();
}
private static void SeedUsers(Metro2036DbContext context, UserManager <User> userManager)
{
if (context.Users.Count() <= 1)
{
var usersList = File
.ReadAllText(WebConstants.UsersListPath);
var deserializedUsers = JsonConvert.DeserializeObject <User[]>(usersList);
Task.Run(async() =>
{
foreach (var user in deserializedUsers)
{
var result = await userManager.CreateAsync(user, WebConstants.UserPassword);
}
foreach (var user in deserializedUsers)
{
var result = await userManager.AddToRoleAsync(user, WebConstants.UserRole);
}
})
.GetAwaiter()
.GetResult();
}
}
public PointController(Metro2036DbContext context)
{
_context = context;
}
public TrainService(Metro2036DbContext context)
{
_context = context;
}
public UserService(Metro2036DbContext context)
{
_context = context;
}
public StationService(Metro2036DbContext context)
{
_context = context;
}
public RouteService(Metro2036DbContext context)
{
_context = context;
}
public PointService(Metro2036DbContext context)
{
_context = context;
}
public TimingService(Metro2036DbContext context)
{
_context = context;
}
