static async Task CreateSampleData(IServiceProvider serviceProvider, MyShuttleContext context)
{
_serviceProvider = serviceProvider;
int carrierId = CreateCarrier_01(context);
await CreateDefaultUser(serviceProvider);
CreateCarriers(context);
}
public void Should_Create_DB()
{
// Arrange
var connectionString = $"Data Source=(LocalDb)\\MSSQLLocalDB;Initial Catalog=MyShuttle-Test-{Guid.NewGuid().ToString()}";
var context = new MyShuttleContext(connectionString);
// Act
var created = InitializeDatabaseForTests(context);
var deleted = context.Database.Delete();
// Assert
Assert.IsTrue(created);
Assert.IsTrue(deleted);
}
public async Task Db_CreatedSuccessfully()
{
var optionsBuilder = new DbContextOptionsBuilder();
optionsBuilder.UseInMemoryDatabase("MyShuttleTestDb");
var context = new MyShuttleContext(optionsBuilder.Options);
var databaseCreated = await context.Database.EnsureCreatedAsync();
Assert.True(databaseCreated);
var databaseDeleted = await context.Database.EnsureDeletedAsync();
Assert.True(databaseDeleted);
}
private static void CreateCarriers(MyShuttleContext context)
{
CreateCustomer_01(context);
CreateVehicleAndDriver_01(_DefaultCarrierId, context);
CreateVehicleAndDriver_02(_DefaultCarrierId, context);
CreateVehicleAndDriver_03(_DefaultCarrierId, context);
CreateVehicleAndDriver_04(_DefaultCarrierId, context);
CreateVehicleAndDriver_05(_DefaultCarrierId, context);
CreateVehicleAndDriver_06(_DefaultCarrierId, context);
CreateVehicleAndDriver_07(_DefaultCarrierId, context);
CreateVehicleAndDriver_08(_DefaultCarrierId, context);
CreateVehicleAndDriver_09(_DefaultCarrierId, context);
CreateVehicleAndDriver_10(_DefaultCarrierId, context);
CreateVehicleAndDriver_11(_DefaultCarrierId, context);
CreateVehicleAndDriver_12(_DefaultCarrierId, context);
CreateVehicleAndDriver_13(_DefaultCarrierId, context);
CreateVehicleAndDriver_14(_DefaultCarrierId, context);
CreateVehicleAndDriver_15(_DefaultCarrierId, context);
CreateVehicleAndDriver_16(_DefaultCarrierId, context);
CreateVehicleAndDriver_17(_DefaultCarrierId, context);
CreateVehicleAndDriver_18(_DefaultCarrierId, context);
CreateVehicleAndDriver_19(_DefaultCarrierId, context);
var carrierId_02 = CreateCarrier_02(context);
CreateVehicleAndDriver_20(carrierId_02, context);
CreateVehicleAndDriver_21(carrierId_02, context);
CreateCarrier_03(context);
CreateCarrier_04(context);
CreateCarrier_05(context);
CreateCarrier_06(context);
CreateCarrier_07(context);
CreateCarrier_08(context);
CreateDrivers(_DefaultCarrierId, context);
CreateRides(_DefaultCarrierId, context);
}
public DriverRepository(MyShuttleContext dbcontext)
{
_context = dbcontext;
}
public RidesRepository(MyShuttleContext dbcontext)
{
_context = dbcontext;
}
private static void CreateVehicleAndDriver_18(int carrierId, MyShuttleContext context)
{
var driver = new Driver
{
Name = "Ibon Campa",
Phone = "555-48970",
Picture = GetNoMsDriver(10),
CarrierId = carrierId,
RatingAvg = 2,
TotalRides = Randomize.Next(50, 100),
};
context.Drivers.Add(driver);
context.SaveChanges();
var vehicle = new Vehicle
{
LicensePlate = "RTY-2345",
Model = "Riviera",
Make = "Buick",
Type = VehicleType.Luxury,
Seats = 7,
VehicleStatus = VehicleStatus.Occupied,
DriverId = driver.DriverId,
Picture = GetVehicle(18),
Latitude = 47.641944,
Longitude = -122.187212,
CarrierId = carrierId,
Rate = Randomize.Next(1, 5),
RatingAvg = Randomize.Next(0, 5),
TotalRides = Randomize.Next(50, 100),
DeviceId = "deviceVehicleLED"
};
context.Vehicles.Add(vehicle);
context.SaveChanges();
}
private static void CreateVehicleAndDriver_10(int carrierId, MyShuttleContext context)
{
var driver = new Driver
{
Name = "Scott Guthrie",
Phone = "555-48970",
Picture = GetDriver(10),
CarrierId = carrierId,
RatingAvg = 5,
TotalRides = Randomize.Next(50, 100),
};
context.Drivers.Add(driver);
context.SaveChanges();
var vehicle = new Vehicle
{
LicensePlate = "ERT-1256",
Model = "Caliber",
Make = "Dodge",
Type = VehicleType.Van,
Seats = 7,
VehicleStatus = VehicleStatus.Occupied,
DriverId = driver.DriverId,
Picture = GetVehicle(10),
Latitude = 48.641924,
Longitude = -122.127212,
CarrierId = carrierId,
Rate = Randomize.Next(1, 5),
RatingAvg = Randomize.Next(0, 5),
TotalRides = Randomize.Next(50, 100),
DeviceId = "ERT-1256",
};
context.Vehicles.Add(vehicle);
context.SaveChanges();
}
private static void CreateVehicleAndDriver_09(int carrierId, MyShuttleContext context)
{
var driver = new Driver
{
Name = "S. Somasegar",
Phone = "555-48970",
Picture = GetDriver(9),
CarrierId = carrierId,
RatingAvg = Randomize.Next(0, 3),
TotalRides = Randomize.Next(50, 100),
};
context.Drivers.Add(driver);
context.SaveChanges();
var vehicle = new Vehicle
{
LicensePlate = "VVV-4444",
Model = "AveoLT",
Make = "Chevrolet",
Type = VehicleType.Van,
Seats = 7,
VehicleStatus = VehicleStatus.Free,
DriverId = driver.DriverId,
Picture = GetVehicle(9),
Latitude = 47.641964,
Longitude = -122.127212,
CarrierId = carrierId,
Rate = Randomize.Next(1, 5),
RatingAvg = Randomize.Next(0, 5),
TotalRides = Randomize.Next(50, 100),
DeviceId = "VVV-4444",
};
context.Vehicles.Add(vehicle);
context.SaveChanges();
}
private static void CreateVehicleAndDriver_07(int carrierId, MyShuttleContext context)
{
var driver = new Driver
{
Name = "Mitra Azizirad",
Phone = "555-48970",
Picture = GetDriver(7),
CarrierId = carrierId,
RatingAvg = 4.6,
TotalRides = Randomize.Next(50, 100),
};
context.Drivers.Add(driver);
context.SaveChanges();
var vehicle = new Vehicle
{
LicensePlate = "JOP-9876",
Model = "BLS",
Make = "Cadillac",
Type = VehicleType.Van,
Seats = 7,
VehicleStatus = VehicleStatus.Occupied,
DriverId = driver.DriverId,
Picture = GetVehicle(7),
Latitude = 47.631915,
Longitude = -122.127221,
CarrierId = carrierId,
Rate = Randomize.Next(1, 5),
RatingAvg = Randomize.Next(0, 5),
TotalRides = Randomize.Next(50, 100),
DeviceId = "JOP-9876",
};
context.Vehicles.Add(vehicle);
context.SaveChanges();
}
static int CreateCarrier_01(MyShuttleContext context)
{
var carrier = new Carrier
{
Name = "James&McCarthy",
Description = "James&McCarthy is your best option of available carriers, and you know it!",
CompanyID = "03-00-00427-CV",
Address = "3956 Broadway, New York, NY 10032 (212)",
ZipCode = "568-3700",
City = "New York City",
State = "New York",
Country = "USA",
Phone = "555-567",
Email = "*****@*****.**",
Picture = GetCarrier(3),
RatingAvg = Randomize.Next(0, 5),
};
context.Carriers.Add(carrier);
context.SaveChanges();
return carrier.CarrierId;
}
static void CreateEmployees(int customerId, MyShuttleContext context)
{
int employeeId = 0;
if (context.Employees.Any())
employeeId = context.Employees.Max(e => e.EmployeeId);
var employees = new List<Employee>()
{
new Employee
{
Id = "90a0d28b-4342-40d5-92b6-af2d0ea7630b",
CustomerId = customerId,
Email = "*****@*****.**",
Name = "Scott Hanselman",
Picture = GetEmplyoyee(1),
},
new Employee
{
Id = "bbe41151-abfa-42da-80c1-91a56cad538f",
CustomerId = customerId,
Email = "*****@*****.**",
Name = "Mitra Azizirad",
Picture = GetEmplyoyee(2),
},
new Employee
{
Id = "c7a9c8a2-a5e3-48d4-99e4-4117599af048",
CustomerId = customerId,
Email = "*****@*****.**",
Name = "Amanda Silver",
Picture = GetEmplyoyee(3),
},
new Employee
{
Id = "4e6767fb-a723-4ce0-9547-f0d349658f9d",
CustomerId = customerId,
Email = "*****@*****.**",
Name = "Nicole Herskowitz",
Picture = GetEmplyoyee(4),
},
new Employee
{
Id = "b9b62397-7c1b-4fb8-898f-a9bbc0234fdf",
CustomerId = customerId,
Email = "*****@*****.**",
Name = "Scott Guthrie",
Picture = GetDriver(10),
}
};
context.Employees.AddRange(employees.ToArray<Employee>());
context.SaveChanges();
}
private static void CreateRides(int carrierId, MyShuttleContext context)
{
var employeeList = context.Employees.Select(e => e.EmployeeId).ToList();
var rides = new List<Ride>();
int rideId = 0;
if (context.Rides.Any())
rideId = context.Rides.Max(e => e.RideId);
foreach (Vehicle vehicle in context.Vehicles)
{
var startDateTime01 = DateTime.UtcNow.AddDays(-Randomize.Next(15, 30));
var startDateTime02 = DateTime.UtcNow.AddDays(-Randomize.Next(15, 30));
var startDateTime03 = DateTime.UtcNow.AddDays(-Randomize.Next(0, 15));
var startDateTime04 = DateTime.UtcNow.AddDays(-Randomize.Next(0, 15));
var startDateTime05 = DateTime.UtcNow.AddDays(-Randomize.Next(10, 20));
var startDateTime06 = DateTime.UtcNow.AddDays(-Randomize.Next(0, 10));
var distance = Randomize.Next(20, 40);
var endTime = startDateTime01.AddMinutes(3 * distance);
var duration = distance * 3;
var cost = distance * vehicle.Rate;
var ride = new Ride
{
Id = Guid.NewGuid().ToString(),
StartDateTime = startDateTime01,
EndDateTime = endTime,
VehicleId = vehicle.VehicleId,
DriverId = vehicle.DriverId,
Cost = cost,
EmployeeId = employeeList[Randomize.Next(0, employeeList.Count() - 1)],
Comments = string.Empty,
CarrierId = carrierId,
Distance = distance,
Duration = duration,
Rating = Randomize.Next(3, 5),
Signature = null,
StartAddress = "Madison Ave 10037",
EndAddress = "217 Broadway",
StartLatitude = 40.721847,
StartLongitude = -74.007326,
EndLatitude = 40.721847,
EndLongitude = -74.007326,
};
rides.Add(ride);
distance = Randomize.Next(20, 40);
endTime = startDateTime02.AddMinutes(3 * distance);
duration = distance * 3;
cost = distance * vehicle.Rate;
ride = new Ride
{
Id = Guid.NewGuid().ToString(),
StartDateTime = startDateTime02,
EndDateTime = endTime,
VehicleId = vehicle.VehicleId,
DriverId = vehicle.DriverId,
Cost = cost,
EmployeeId = employeeList[Randomize.Next(0, employeeList.Count() - 1)],
Comments = string.Empty,
CarrierId = carrierId,
Distance = distance,
Duration = 20,
Rating = Randomize.Next(3, 5),
Signature = null,
StartAddress = "217 Broadway",
EndAddress = "E 156th St, Bronx",
StartLatitude = 40.721847,
StartLongitude = -74.007326,
EndLatitude = 40.721847,
EndLongitude = -74.007326,
};
rides.Add(ride);
distance = Randomize.Next(20, 40);
endTime = startDateTime03.AddMinutes(3 * distance);
duration = distance * 3;
cost = distance * vehicle.Rate;
ride = new Ride
{
Id = Guid.NewGuid().ToString(),
StartDateTime = startDateTime03,
EndDateTime = endTime,
VehicleId = vehicle.VehicleId,
DriverId = vehicle.DriverId,
Cost = cost,
EmployeeId = employeeList[Randomize.Next(0, employeeList.Count() - 1)],
Comments = string.Empty,
CarrierId = carrierId,
Distance = distance,
Duration = duration,
Rating = Randomize.Next(2, 5),
Signature = null,
StartAddress = "54 Fulton St",
EndAddress = "E 156th St, Bronx",
StartLatitude = 40.721847,
StartLongitude = -74.007326,
EndLatitude = 40.721847,
EndLongitude = -74.007326,
};
rides.Add(ride);
distance = Randomize.Next(20, 40);
endTime = startDateTime04.AddMinutes(3 * distance);
duration = distance * 3;
cost = distance * vehicle.Rate;
ride = new Ride
{
Id = Guid.NewGuid().ToString(),
StartDateTime = startDateTime04,
EndDateTime = endTime,
VehicleId = vehicle.VehicleId,
DriverId = vehicle.DriverId,
Cost = cost,
EmployeeId = employeeList[Randomize.Next(0, employeeList.Count() - 1)],
Comments = string.Empty,
CarrierId = carrierId,
Distance = distance,
Duration = duration,
Rating = Randomize.Next(2, 5),
Signature = null,
StartAddress = "E 156th St, Bronx",
EndAddress = "33 Wooster St",
StartLatitude = 40.721847,
StartLongitude = -74.007326,
EndLatitude = 40.721847,
EndLongitude = -74.007326,
};
rides.Add(ride);
distance = Randomize.Next(20, 40);
endTime = startDateTime05.AddMinutes(3 * distance);
duration = distance * 3;
cost = distance * vehicle.Rate;
ride = new Ride
{
Id = Guid.NewGuid().ToString(),
StartDateTime = startDateTime05,
EndDateTime = endTime,
VehicleId = vehicle.VehicleId,
DriverId = vehicle.DriverId,
Cost = cost,
EmployeeId = employeeList[Randomize.Next(0, employeeList.Count() - 1)],
Comments = string.Empty,
CarrierId = carrierId,
Distance = distance,
Duration = duration,
Rating = Randomize.Next(2, 5),
Signature = null,
StartAddress = "48 Wall St",
EndAddress = "Madison Ave 10037",
StartLatitude = 40.721847,
StartLongitude = -74.007326,
EndLatitude = 40.721847,
EndLongitude = -74.007326,
};
rides.Add(ride);
distance = Randomize.Next(20, 40);
endTime = startDateTime06.AddMinutes(3 * distance);
duration = distance * 3;
cost = distance * vehicle.Rate;
ride = new Ride
{
Id = Guid.NewGuid().ToString(),
StartDateTime = startDateTime06,
EndDateTime = endTime,
VehicleId = vehicle.VehicleId,
DriverId = vehicle.DriverId,
Cost = cost,
EmployeeId = employeeList[Randomize.Next(0, employeeList.Count() - 1)],
Comments = "Great service!",
CarrierId = carrierId,
Distance = distance,
Duration = duration,
Rating = Randomize.Next(2, 5),
Signature = null,
StartAddress = "33 Wooster St",
EndAddress = "48 Wall St",
StartLatitude = 40.721847,
StartLongitude = -74.007326,
EndLatitude = 40.721847,
EndLongitude = -74.007326,
};
rides.Add(ride);
}
context.Rides.AddRange(rides.ToArray<Ride>());
context.SaveChanges();
}
private static void CreateVehicleAndDriver_21(int carrierId, MyShuttleContext context)
{
var driver = new Driver
{
Name = "Andry Jackson",
Phone = "555-48970",
Picture = GetNoMsDriver(11),
CarrierId = carrierId,
RatingAvg = 2,
TotalRides = Randomize.Next(50, 100),
};
context.Drivers.Add(driver);
context.SaveChanges();
var vehicle = new Vehicle
{
LicensePlate = "WIE-4545",
Model = "Grand Prix",
Make = "Pontiac",
Type = VehicleType.Luxury,
Seats = 7,
VehicleStatus = VehicleStatus.Occupied,
DriverId = driver.DriverId,
Picture = GetVehicle(21),
Latitude = 47.641944,
Longitude = -122.327252,
CarrierId = carrierId,
Rate = Randomize.Next(1, 5),
RatingAvg = Randomize.Next(0, 5),
TotalRides = Randomize.Next(50, 100),
DeviceId = string.Empty
};
context.Vehicles.Add(vehicle);
context.SaveChanges();
}
static void CreateCustomer_01(MyShuttleContext context)
{
var customer = new Customer
{
Address = "15010 NE 36th Street",
City = "Redmond",
Country = "United States",
CompanyID = "1234-344",
Email = "*****@*****.**",
Name = "Microsoft",
Phone = "555-555-555",
State = "Washington",
ZipCode = "98052"
};
context.Customers.Add(customer);
context.SaveChanges();
CreateEmployees(customer.CustomerId, context);
}
private static void CreateVehicleAndDriver_19(int carrierId, MyShuttleContext context)
{
var driver = new Driver
{
Name = "Carlos Rodriguez",
Phone = "555-48970",
Picture = GetNoMsDriver(9),
CarrierId = carrierId,
RatingAvg = 2,
TotalRides = Randomize.Next(50, 100),
};
context.Drivers.Add(driver);
context.SaveChanges();
var vehicle = new Vehicle
{
LicensePlate = "ERT-2345",
Model = "Impala LTZ",
Make = "Chevrolet",
Type = VehicleType.Luxury,
Seats = 7,
VehicleStatus = VehicleStatus.Occupied,
DriverId = driver.DriverId,
Picture = GetVehicle(19),
Latitude = 47.641944,
Longitude = -122.197232,
CarrierId = carrierId,
Rate = Randomize.Next(1, 5),
RatingAvg = Randomize.Next(0, 5),
TotalRides = Randomize.Next(50, 100),
DeviceId = string.Empty
};
context.Vehicles.Add(vehicle);
context.SaveChanges();
}
private static void CreateVehicleAndDriver_05(int carrierId, MyShuttleContext context)
{
var driver = new Driver
{
Name = "Scott Hanselman",
Phone = "555-48970",
Picture = GetDriver(5),
CarrierId = carrierId,
RatingAvg = 4.8,
TotalRides = Randomize.Next(50, 100),
};
context.Drivers.Add(driver);
context.SaveChanges();
var vehicle = new Vehicle
{
LicensePlate = "FGH-9876",
Model = "Volt2",
Make = "Chevrolet",
Type = VehicleType.Van,
Seats = 7,
VehicleStatus = VehicleStatus.Free,
DriverId = driver.DriverId,
Picture = GetVehicle(5),
Latitude = 47.631925,
Longitude = -122.127220,
CarrierId = carrierId,
Rate = Randomize.Next(1, 5),
RatingAvg = Randomize.Next(0, 5),
TotalRides = Randomize.Next(50, 100),
DeviceId = "FGH-9876"
};
context.Vehicles.Add(vehicle);
context.SaveChanges();
}
private static void CreateVehicleAndDriver_06(int carrierId, MyShuttleContext context)
{
var driver = new Driver
{
Name = "Erich Gamma",
Phone = "555-48970",
Picture = GetDriver(6),
CarrierId = carrierId,
RatingAvg = Randomize.Next(0, 3),
TotalRides = Randomize.Next(50, 100),
};
context.Drivers.Add(driver);
context.SaveChanges();
var vehicle = new Vehicle
{
LicensePlate = "ZUA-1456",
Model = "Caprice PPV",
Make = "Chevrolet",
Type = VehicleType.Van,
Seats = 7,
VehicleStatus = VehicleStatus.Free,
DriverId = driver.DriverId,
Picture = GetVehicle(6),
Latitude = 47.631935,
Longitude = -122.127222,
CarrierId = carrierId,
Rate = Randomize.Next(1, 5),
RatingAvg = Randomize.Next(0, 5),
TotalRides = Randomize.Next(50, 100),
DeviceId = "CUA-1456",
};
context.Vehicles.Add(vehicle);
context.SaveChanges();
}
static int CreateCarrier_08(MyShuttleContext context)
{
var carrier = new Carrier
{
Name = "Threeangle",
Description = "Threeangle is your best option of available carriers-.",
CompanyID = "03-00-00427-CV",
Address = "3956 Broadway, New York, NY 10032 (212)",
ZipCode = "568-3700",
City = "New York City",
State = "New York",
Country = "USA",
Phone = "555-FAST&CALM",
Email = "*****@*****.**",
Picture = GetCarrier(8),
RatingAvg = Randomize.Next(0, 5),
};
context.Carriers.Add(carrier);
context.SaveChanges();
return carrier.CarrierId;
}
private static void CreateVehicleAndDriver_08(int carrierId, MyShuttleContext context)
{
var driver = new Driver
{
Name = "Rob Caron",
Phone = "555-48970",
Picture = GetDriver(8),
CarrierId = carrierId,
RatingAvg = Randomize.Next(0, 3),
TotalRides = Randomize.Next(50, 100),
};
context.Drivers.Add(driver);
context.SaveChanges();
var vehicle = new Vehicle
{
LicensePlate = "HTY-1243",
Model = "ELR",
Make = "Cadilac",
Type = VehicleType.Van,
Seats = 7,
VehicleStatus = VehicleStatus.Occupied,
DriverId = driver.DriverId,
Picture = GetVehicle(8),
Latitude = 47.621954,
Longitude = -122.127212,
CarrierId = carrierId,
Rate = Randomize.Next(1, 5),
RatingAvg = Randomize.Next(0, 5),
TotalRides = Randomize.Next(50, 100),
DeviceId = "HTY-1243",
};
context.Vehicles.Add(vehicle);
context.SaveChanges();
}
private static void CreateDrivers(int carrierId, MyShuttleContext context)
{
var drivers = new List<Driver>()
{
new Driver
{
Name = "Carlos Zimmermann",
Phone = "555-178895",
Picture = GetDriver(11),
CarrierId = carrierId,
RatingAvg = Randomize.Next(0, 5),
TotalRides = Randomize.Next(50, 100),
},
new Driver
{
Name = "Andrew Davis",
Phone = "555-178895",
Picture = GetDriver(12),
CarrierId = carrierId,
RatingAvg = Randomize.Next(0, 5),
TotalRides = Randomize.Next(50, 100),
},
new Driver
{
Name = "Carolina Anderson",
Phone = "555-178895",
Picture = GetDriver(13),
CarrierId = carrierId,
RatingAvg = Randomize.Next(0, 5),
TotalRides = Randomize.Next(50, 100),
},
new Driver
{
Name = "Julian Thomas",
Phone = "555-178895",
Picture = GetDriver(14),
CarrierId = carrierId,
RatingAvg = Randomize.Next(0, 5),
TotalRides = Randomize.Next(50, 100),
}
};
context.Drivers.AddRange(drivers.ToArray<Driver>());
context.SaveChanges();
}
private static void CreateVehicleAndDriver_13(int carrierId, MyShuttleContext context)
{
var driver = new Driver
{
Name = "Aaron McDonall",
Phone = "555-48970",
Picture = GetNoMsDriver(3),
CarrierId = carrierId,
RatingAvg = 2,
TotalRides = Randomize.Next(50, 100),
};
context.Drivers.Add(driver);
context.SaveChanges();
var vehicle = new Vehicle
{
LicensePlate = "HUL-5678",
Model = "Aura XR",
Make = "Saturn",
Type = VehicleType.Luxury,
Seats = 7,
VehicleStatus = VehicleStatus.Occupied,
DriverId = driver.DriverId,
Picture = GetVehicle(13),
Latitude = 47.644944,
Longitude = -122.125222,
CarrierId = carrierId,
Rate = Randomize.Next(1, 5),
RatingAvg = Randomize.Next(0, 5),
TotalRides = Randomize.Next(50, 100),
DeviceId = "deviceVehicleRC"
};
context.Vehicles.Add(vehicle);
context.SaveChanges();
}
private static void CreateVehicleAndDriver_16(int carrierId, MyShuttleContext context)
{
var driver = new Driver
{
Name = "Wendy Torre",
Phone = "555-48970",
Picture = GetNoMsDriver(14),
CarrierId = carrierId,
RatingAvg = 2,
TotalRides = Randomize.Next(50, 100),
};
context.Drivers.Add(driver);
context.SaveChanges();
var vehicle = new Vehicle
{
LicensePlate = "ERT-1289",
Model = "Regal",
Make = "Buick",
Type = VehicleType.Luxury,
Seats = 7,
VehicleStatus = VehicleStatus.Occupied,
DriverId = driver.DriverId,
Picture = GetVehicle(16),
Latitude = 47.641951,
Longitude = -122.177222,
CarrierId = carrierId,
Rate = Randomize.Next(1, 5),
RatingAvg = Randomize.Next(0, 5),
TotalRides = Randomize.Next(50, 100),
DeviceId = string.Empty
};
context.Vehicles.Add(vehicle);
context.SaveChanges();
}
private static void CreateVehicleAndDriver_11(int carrierId, MyShuttleContext context)
{
var driver = new Driver
{
Name = "James Rodriguez",
Phone = "555-48970",
Picture = GetNoMsDriver(1),
CarrierId = carrierId,
RatingAvg = 2,
TotalRides = Randomize.Next(50, 100),
};
context.Drivers.Add(driver);
context.SaveChanges();
var vehicle = new Vehicle
{
LicensePlate = "WWW-1256",
Model = "Dart",
Make = "Dodge",
Type = VehicleType.Luxury,
Seats = 7,
VehicleStatus = VehicleStatus.Occupied,
DriverId = driver.DriverId,
Picture = GetVehicle(11),
Latitude = 47.642944,
Longitude = -122.128222,
CarrierId = carrierId,
Rate = Randomize.Next(1, 5),
RatingAvg = Randomize.Next(0, 5),
TotalRides = Randomize.Next(50, 100),
DeviceId = "deviceVehicleSIM"
};
context.Vehicles.Add(vehicle);
context.SaveChanges();
}
private static void CreateVehicleAndDriver_14(int carrierId, MyShuttleContext context)
{
var driver = new Driver
{
Name = "Alan Anderson",
Phone = "555-48970",
Picture = GetNoMsDriver(4),
CarrierId = carrierId,
RatingAvg = 2,
TotalRides = Randomize.Next(50, 100),
};
context.Drivers.Add(driver);
context.SaveChanges();
var vehicle = new Vehicle
{
LicensePlate = "WTW-6182",
Model = "G6",
Make = "Pontiac",
Type = VehicleType.Luxury,
Seats = 7,
VehicleStatus = VehicleStatus.Occupied,
DriverId = driver.DriverId,
Picture = GetVehicle(14),
Latitude = 41.151172,
Longitude = -87.914014,
CarrierId = carrierId,
Rate = Randomize.Next(1, 5),
RatingAvg = Randomize.Next(0, 5),
TotalRides = Randomize.Next(50, 100),
DeviceId = string.Empty
};
context.Vehicles.Add(vehicle);
context.SaveChanges();
}
private static void CreateVehicleAndDriver_15(int carrierId, MyShuttleContext context)
{
var driver = new Driver
{
Name = "Austin Lumbert",
Phone = "555-48970",
Picture = GetNoMsDriver(5),
CarrierId = carrierId,
RatingAvg = 2,
TotalRides = Randomize.Next(50, 100),
};
context.Drivers.Add(driver);
context.SaveChanges();
var vehicle = new Vehicle
{
LicensePlate = "OUJ-6182",
Model = "G5",
Make = "Pontiac",
Type = VehicleType.Luxury,
Seats = 7,
VehicleStatus = VehicleStatus.Occupied,
DriverId = driver.DriverId,
Picture = GetVehicle(15),
Latitude = 47.641950,
Longitude = -122.167222,
CarrierId = carrierId,
Rate = Randomize.Next(1, 5),
RatingAvg = Randomize.Next(0, 5),
TotalRides = Randomize.Next(50, 100),
DeviceId = string.Empty
};
context.Vehicles.Add(vehicle);
context.SaveChanges();
}
private static void CreateVehicleAndDriver_01(int carrierId, MyShuttleContext context)
{
var driver = new Driver
{
Name = "Cesar de la Torre",
Phone = "555-178895",
Picture = GetDriver(1),
CarrierId = carrierId,
RatingAvg = 4.5,
TotalRides = Randomize.Next(50, 100),
};
context.Drivers.Add(driver);
context.SaveChanges();
var vehicle = new Vehicle
{
LicensePlate = "SLV-4335",
Model = "Pacifica",
Make = "Chrysler",
Type = VehicleType.Compact,
Seats = 4,
VehicleStatus = VehicleStatus.Occupied,
DriverId = driver.DriverId,
CarrierId = carrierId,
Picture = GetVehicle(1),
Latitude = 47.621931,
Longitude = -122.127232,
Rate = Randomize.Next(1, 5),
RatingAvg = Randomize.Next(0, 5),
TotalRides = Randomize.Next(50, 100),
DeviceId = "SLV-4335",
};
context.Vehicles.Add(vehicle);
context.SaveChanges();
}
private static void CreateVehicleAndDriver_02(int carrierId, MyShuttleContext context)
{
var driver = new Driver
{
Name = "David Carmona",
Phone = "555-48970",
Picture = GetDriver(2),
CarrierId = carrierId,
RatingAvg = 4.6,
TotalRides = Randomize.Next(50, 100),
};
context.Drivers.Add(driver);
context.SaveChanges();
var vehicle = new Vehicle
{
LicensePlate = "MAX-9876",
Model = "Town Car",
Make = "Lincoln",
Type = VehicleType.Van,
Seats = 7,
VehicleStatus = VehicleStatus.Free,
DriverId = driver.DriverId,
Picture = GetVehicle(2),
Latitude = 47.621934,
Longitude = 122.127222,
CarrierId = carrierId,
Rate = Randomize.Next(1, 5),
RatingAvg = Randomize.Next(0, 5),
TotalRides = Randomize.Next(50, 100),
DeviceId = "MAX-9876"
};
context.Vehicles.Add(vehicle);
context.SaveChanges();
}
private static void CreateVehicleAndDriver_03(int carrierId, MyShuttleContext context)
{
var driver = new Driver
{
Name = "David Salgado",
Phone = "555-48970",
Picture = GetDriver(3),
CarrierId = carrierId,
RatingAvg = 3,
TotalRides = Randomize.Next(50, 100),
};
context.Drivers.Add(driver);
context.SaveChanges();
var vehicle = new Vehicle
{
LicensePlate = "ZCC-1432",
Model = "Taurus",
Make = "Ford",
Type = VehicleType.Van,
Seats = 7,
VehicleStatus = VehicleStatus.Occupied,
DriverId = driver.DriverId,
Picture = GetVehicle(3),
Latitude = 47.741924,
Longitude = 122.127222,
CarrierId = carrierId,
Rate = Randomize.Next(1, 5),
RatingAvg = Randomize.Next(0, 5),
TotalRides = Randomize.Next(50, 100),
DeviceId = "CCC-1432"
};
context.Vehicles.Add(vehicle);
context.SaveChanges();
}
public CarrierRepository(MyShuttleContext dbcontext)
{
_context = dbcontext;
}
private static void CreateVehicleAndDriver_04(int carrierId, MyShuttleContext context)
{
var driver = new Driver
{
Name = "Dmitry Lyalin",
Phone = "555-48970",
Picture = GetDriver(4),
CarrierId = carrierId,
RatingAvg = Randomize.Next(0, 4),
TotalRides = Randomize.Next(50, 100),
};
context.Drivers.Add(driver);
context.SaveChanges();
var vehicle = new Vehicle
{
LicensePlate = "JNV-9876",
Model = "300C",
Make = "Chrysler",
Type = VehicleType.Van,
Seats = 7,
VehicleStatus = VehicleStatus.Occupied,
DriverId = driver.DriverId,
Picture = GetVehicle(4),
Latitude = 47.841914,
Longitude = -122.127222,
CarrierId = carrierId,
Rate = Randomize.Next(1, 5),
RatingAvg = Randomize.Next(0, 5),
TotalRides = Randomize.Next(50, 100),
DeviceId = "JNV-9876"
};
context.Vehicles.Add(vehicle);
context.SaveChanges();
}
public VehicleRepository(MyShuttleContext dbcontext)
{
_context = dbcontext;
}
public CustomerRepository(MyShuttleContext dbcontext)
{
context = dbcontext;
}
