private void GetAvailableRides()
{
String registeredCondition = (Session["UserId"] != null) ? "AND o.User_Id != '" + Session["UserId"].ToString() + "'" : "";
SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["RidersConnectionConnectionString"].ConnectionString);
string selectstatement = "SELECT o.*, u.Firstname AS Firstname FROM Offers AS o, Users as u WHERE o.status = 0 AND o.User_Id = u.Id " + registeredCondition;
con.Open();
//will pull all rides, filter handled by client
SqlCommand selectcommand = new SqlCommand(selectstatement, con);
SqlDataReader reader = selectcommand.ExecuteReader();
Data data = new Data();
while (reader.Read())
{
Ride ride = new Ride
{
Id = int.Parse(reader["Id"].ToString()),
address = reader["Address"].ToString(),
latitude = reader["Latitude"].ToString(),
longitude = reader["Longitude"].ToString(),
rate = reader["Rate"].ToString(),
max_distance = reader["MaxDistance"].ToString(),
max_capacity = reader["Capacity"].ToString(),
user_id = reader["User_Id"].ToString(),
username = reader["Firstname"].ToString()
};
data.rides.Add(ride);
}
con.Close();
Out(data, 200);
}
public async Task PutAsync(Ride ride)
{
string url = String.Format(CultureInfo.InvariantCulture
, "{0}rides/Put", _urlPrefix);
await base.PutAsync<Ride>(url, ride);
}
public void UnMountRide()
{
if(null != ride)
{
ride.UnMount();
}
ride = null;
}
public static void AtendeCarona(User usr, Ride rd)
{
using (elmatEntities entities = new elmatEntities())
{
var ride = (from R in entities.RIDE.Where(x => x.RideID == rd.RideID) select R).FirstOrDefault();
ride.DriverID = usr.UserID;
entities.SaveChanges();
}
}
public void MountRide(int modelId)
{
ride = null;
rideModelId = modelId;
if(IsMainBodyReady)
{
ride = new Ride(modelId, MainBody);
//ride.PlayAnim(EAnimType.Walk_Fore);
rideModelId = 0;
}
}
public ActionResult <String> CreateRide([FromBody] Ride ride)
{
bool alreadyInDb = (from p in motherload.Rides where p.Driver == ride.Driver &&
p.Date == ride.Date && p.Time == ride.Time select p).Count() > 0;
if (alreadyInDb)
{
return("alreadyExists");
}
else
{
motherload.Rides.Add(ride);
motherload.SaveChanges();
return("created");
}
}
public ActionResult Index(RegisterViewModel model)
{
var viewModel = new MemberViewModel()
{
Rolename = model.RoleName,
Email = model.Email,
Cars = unitOfWork.Car.GetCars(),
AvailableSeats = Ride.CreateAvailableSeatsForDrivers()
};
if (model.RoleName == RoleName.Driver)
{
return(View("DriverForm", viewModel));
}
return(View("PassengerForm", viewModel));
}
public List <Ride> AddBooking(Ride ride, Booking booking, Employee employee, Client client)
{
((BookingDBRepository)_bookingRepository).Save(booking);
var allRides = ((RideDBRepository)_rideRepository).FindAll().ToList();
foreach (var x in _observers.Keys)
{
if (x != employee.UserName)
{
Task.Run(() => _observers[x].AddBooking(allRides));
}
}
return(allRides);
}
private void listView_Click(object sender, RoutedEventArgs e)
{
Marketplace marketplace = Marketplace.Instance;
List <Ride> buyableRides = marketplace.GetBuyableRides(park.ParkInventory);
var item = (sender as ListView).SelectedItem;
if (item != null)
{
Ride ride = item as Ride;
NameLabel.Content = "Name: " + ride.Name;
DurationLabel.Content = "Duration: " + ride.Duration;
EntryFee.Content = "Entry Fee: " + ride.EntryFee.ToString();
}
}
public void ApplyRide(Ride r)
{
var d = r.DistToStart(CurRow, CurRow);
CurT += d;
if (r.StartT < CurT)
{
CurT = r.StartT;
}
CurT += r.Length();
CurRow = r.FinishRow;
CurCol = r.FinishCol;
Rides.Add(r);
}
public RideDTO(Ride r)
{
if (r != null)
{
AvailableSeats = r.AvailableSeats;
DropOffLocation = r.DropOffLocation;
IsSoldOut = r.IsSoldOut;
PassengerContribution = r.PassengerContribution;
PickUpLocation = r.PickUpLocation;
RideId = r.RideId;
Stopovers = r.Stopovers;
TotalAvailableSeats = r.TotalAvailableSeats;
TravelDate = r.TravelDate;
Owner = new UserDTO(r.Owner);
}
}
// PUT: api/Rides/5
public async Task PutAsync(int id, [FromBody] RideDTO ride)
{
Ride rideEntity = new Ride()
{
Id = id,
Rider = ride.Rider,
RideTime = ride.Time,
Porpoise = new Porpoise()
{
Name = ride.Porpoise.Name,
Species = ride.Porpoise.Species
}
};
await _rideManagementService.UpdateRideAsync(rideEntity);
}
// RIDE LEGS ******************
public async Task <Ride> AddRideLegsAsync(Ride ride, params RideLeg[] rideLegs)
{
foreach (RideLeg rideLeg in rideLegs)
{
ValidateRideLeg(rideLeg);
// Todo: Set time and distance for each leg
// Can reuse calculated distance for return trip if origin and distination are the same
_uow.RideLegs.Add(rideLeg);
ride.RideLegs.Add(rideLeg);
}
await _uow.SaveChangesAsync();
return(ride);
}
public async Task <decimal> GetRideCostAsync(Ride rideOffer, Ride rideRequest)
{
var rideCost = rideOffer.RideCost;
decimal cost = rideCost.BaseCost;
var newRide = await AddRideRequestToOfferAsync(rideOffer, rideRequest);
var extraDistance = newRide.Distance - rideOffer.Distance;
var extraTime = newRide.TravelTime - rideOffer.TravelTime;
cost += rideCost.CostPerMile * (decimal)newRide.Distance;
cost += rideCost.PickupCostPerMile * (decimal)extraDistance;
cost += rideCost.PickupCostPerHour * (decimal)extraTime.TotalHours;
return(cost);
}
public List <Report> GetReportsForRide(int id)
{
query = $"SELECT * FROM Reports WHERE RideId = '{id}'";
var data = cDB.ExecuteQuery(query);
Ride theRide = GetRide(id);
return(data.Tables[0].AsEnumerable().Select(dataRow => new Report
{
Id = dataRow.Field <int>("Id"),
RideReportedOn = theRide,
Status = (StatusOptions)System.Enum.Parse(typeof(StatusOptions), dataRow.Field <string>("Status")),
ReportTime = dataRow.Field <DateTime>("ReportTime"),
Notes = dataRow.Field <string>("Notes")
}).ToList());
}
public IActionResult GetById(string id)
{
if (string.IsNullOrEmpty(id))
{
return(BadRequest());
}
Ride ride = this._rideServices.GetById(id);
if (ride == null)
{
return(NotFound());
}
return(Ok(ride));
}
private void dgRides_SelectionChanged(object sender, SelectionChangedEventArgs e)
{
tblkBreakdownNumber.Text = "";
tblkCategory.Text = "";
tblkDaysSinceBreakdown.Text = "";
tblkName.Text = "";
tblkStatus.Text = "";
Ride r = (dgRides.SelectedItem as Ride);
tblkName.Text = r.Name;
tblkStatus.Text = r.Status.ToString();
tblkCategory.Text = r.Category.ToString();
tblkBreakdownNumber.Text = r.NumberOfShutdowns().ToString();
tblkDaysSinceBreakdown.Text = r.DaysSinceLastShutdown().ToString();
}
public List <Ride> GetRides()
{
Ride ride1 = new Ride {
Hour = "17:54", Room = 3, Destination = "ראשון לציון"
};
Ride ride2 = new Ride {
Hour = "18:10", Room = 2, Destination = "רעננה"
};
Ride ride3 = new Ride {
Hour = "18:15", Room = 4, Destination = "נתניה"
};
return(new List <Ride> {
ride1, ride2, ride3
});
}
public async Task <RideDTO> CancelRide(Ride ride)
{
if (ride != null && ride.RideStatus != null && ride.RideStatus.Code == Core.Constant.RideStatus.Waiting)
{
ride.IsActive = false;
await this.UnitOfWork.RideRepository.Update(ride);
await this.UnitOfWork.SaveAsync();
return(new RideDTO(ride));
}
else
{
return(null);
}
}
// GET: Ride/Details/5
public ActionResult Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Ride ride = db.Rides.Find(id);
string userName = User.Identity.Name;
ViewBag.UserName = userName;
if (ride == null)
{
return(HttpNotFound());
}
return(View(ride));
}
//Create
public string CreateRide(Ride ride)
{
ride.RideType = "Truck";
string message = "";
string connection = ConfigurationManager.ConnectionStrings["temp_transport"].ConnectionString;
SqlConnection con = new SqlConnection(connection);
con.Open();
int RideExpenses = int.Parse(ride.RideCommisionCharge.ToString())
+ int.Parse(ride.RideDieselExpense.ToString()) + int.Parse(ride.RideDriverCharge.ToString())
+ int.Parse(ride.RideFoodExpense.ToString()) + int.Parse(ride.RideMaintainanceExpense.ToString()) +
int.Parse(ride.RideMobileExpense.ToString()) + int.Parse(ride.RideTaxExpense.ToString());
int RideFare = int.Parse(ride.RideFare.ToString());
int RideProfit = RideFare - RideExpenses;
SqlCommand cmd = new SqlCommand("sp_Ride_create", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Ride_Source", ride.RideSource.ToString());
cmd.Parameters.AddWithValue("@Ride_Destination", ride.RideDestination.ToString());
cmd.Parameters.AddWithValue("@Ride_DieselExpenses", int.Parse(ride.RideDieselExpense.ToString()));
cmd.Parameters.AddWithValue("@Ride_MaintainanceExpenses", int.Parse(ride.RideMaintainanceExpense.ToString()));
cmd.Parameters.AddWithValue("@Ride_FoodExpenses", int.Parse(ride.RideFoodExpense.ToString()));
cmd.Parameters.AddWithValue("@Ride_MobileExpenses", int.Parse(ride.RideMobileExpense.ToString()));
cmd.Parameters.AddWithValue("@Ride_TaxExpenses", int.Parse(ride.RideTaxExpense.ToString()));
cmd.Parameters.AddWithValue("@Ride_DriverCharges", int.Parse(ride.RideDriverCharge.ToString()));
cmd.Parameters.AddWithValue("@Ride_CommisionCharges", int.Parse(ride.RideCommisionCharge.ToString()));
cmd.Parameters.AddWithValue("@Ride_DieselQuantity", ride.RideDieselQuantity.ToString());
cmd.Parameters.AddWithValue("@Ride_DriverId", int.Parse(ride.RideDriverId.ToString()));
cmd.Parameters.AddWithValue("@Ride_VehicleNumber", ride.RideVehicleNumber.ToString());
cmd.Parameters.AddWithValue("@Ride_ProfitLoss", RideProfit);
cmd.Parameters.AddWithValue("@RideSeller", ride.RideSeller.ToString());
cmd.Parameters.AddWithValue("@RideBuyer", ride.RideBuyer);
cmd.Parameters.AddWithValue("@RideFare", RideFare);
cmd.Parameters.AddWithValue("@RideDate", ride.RideDate.Date);
cmd.Parameters.AddWithValue("@RideDetail", ride.RideDetail.ToString());
cmd.Parameters.AddWithValue("@RideType", ride.RideType.ToString());
cmd.Parameters.AddWithValue("@companyId", ride.CompanyId);
int result = cmd.ExecuteNonQuery();
if (result > 0)
{
message = "Ride Added Successfully";
ride = new Ride();
}
con.Close();
return(message);
}
public async Task UpdateAsync_WithInvalidModel_ReturnsFalse()
{
// Arrange
var context = new PoolItDbContext(new DbContextOptionsBuilder <PoolItDbContext>()
.UseInMemoryDatabase(Guid.NewGuid().ToString())
.Options);
var ride = new Ride
{
Title = "Initial Title",
PhoneNumber = "0000000000",
Notes = "Initial Notes",
Car = new Car(),
Date = DateTime.UtcNow,
AvailableSeats = 1,
From = "Test From",
To = "Test To"
};
await context.Rides.AddAsync(ride);
await context.SaveChangesAsync();
var ridesService = new RidesService(new EfRepository <Ride>(context), null, null, null);
var serviceModel = new RideServiceModel()
{
Id = ride.Id,
Notes = "Updated Notes",
CarId = ride.CarId,
AvailableSeats = ride.AvailableSeats,
From = ride.From,
To = ride.To
};
var initialTitle = ride.Title;
// Act
var result = await ridesService.UpdateAsync(serviceModel);
// Assert
Assert.False(result);
var dbModel = await context.Rides.SingleAsync();
Assert.Equal(initialTitle, dbModel.Title);
}
public IActionResult AdminPut(int id, [FromBody] Ride ride)
{
var existingRide = _Context.Rides.Find(id);
if (existingRide == null)
{
return(NotFound());
}
existingRide.Name = ride.Name;
existingRide.Destination = ride.Destination;
existingRide.Source = ride.Source;
_Context.SaveChanges();
return(Ok(existingRide));
}
public List <Ride> AddBooking(Ride ride, Booking booking, Employee employee, Client client)
{
var clientDto = DTOUtils.GetClientDto(client);
var bookingDto = DTOUtils.GetBookingDto(booking);
var rideDto = DTOUtils.GetRideDto(ride);
var employeeDto = DTOUtils.GetEmployeeDto(employee);
SendRequest(new BookingRequest(bookingDto, rideDto, employeeDto, clientDto));
var response = ReadResponse();
if (response is ErrorResponse)
{
throw new Exception("Error add reservation");
}
return(((GetRidesResponse)response).Rides.Select(DTOUtils.GetFromDto).ToList());
}
public int PriceEstimattion(Ride ride)
{
while (true)
{
display.Print("Distance from starting point :");
try
{
ride.Destination.DistancefromStartPoint = int.Parse(display.Scan());
break;
}
catch (FormatException)
{
display.Print("Check format of distance");
}
}
return((ride.Priceperkm * ride.Destination.DistancefromStartPoint));
}
public void AddRide_ReturnsFalseRideWasntAdded()
{
//Arrange
Member member = new Member();
BikeRoute bikeRoute = new BikeRoute();
bikeRoute.Difficulty = Difficulty.Hard;
Ride ride = new Ride();
ride.Route = bikeRoute;
//Act
//Assert
Assert.False(member.Add(ride));
}
public void AddRide_ReturnsTrueRideWasAdded()
{
//Arrange
Member member = new Member();
BikeRoute bikeRoute = new BikeRoute();
bikeRoute.Difficulty = Difficulty.Easy;
Ride ride = new Ride();
ride.Route = bikeRoute;
//Act
//Assert
Assert.True(member.Add(ride));
}
public ActionResult UpDate(Ride ride) // Ananewsh Request
{
var requestDB = unitOfWork.Requests.SpecificRequest(ride.RideID, User.Identity.GetUserId());
// Epistrofh stoixeiwn diadromhs
var rideDB = unitOfWork.Rides.GetRideInfo(ride.RideID);
requestDB.UpDateRequest(rideDB, requestDB, ride.SelectNumberOfSeats);
var viewModel = new RequestViewModel()
{
Ride = rideDB,
Heading = "Η Διαδρομή Ανανεώθηκε Επιτυχώς"
};
unitOfWork.Complete();
return(View("SaveRequest", viewModel));
}
public List <Ride> FindOfferedRides(string providerId)
{
List <Ride> rides = new List <Ride>();
string connectionString = Configuration.ConnectionString;
using (SqlConnection connection = new SqlConnection(connectionString))
{
connection.Open();
string sql = $"Select * From Ride where ProviderId='{providerId}' ";
SqlCommand command = new SqlCommand(sql, connection);
using (SqlDataReader dataReader = command.ExecuteReader())
{
while (dataReader.Read())
{
List <string> locations;
Ride Ride = new Ride
{
Id = Convert.ToInt32(dataReader["Id"]),
NoOfOfferedSeats = Convert.ToInt32(dataReader["NoOfOfferedSeats"]),
StartDate = Convert.ToDateTime(dataReader["StartDate"]),
UnitDistanceCost = float.Parse(Convert.ToString(dataReader["UnitDistanceCost"])),
VehicleId = Convert.ToString(dataReader["VehicleId"]),
Time = Convert.ToString(dataReader["Time"])
};
locations = Convert.ToString(dataReader["locations"]).Split(",").ToList();
Ride.VehicleType = VehicleDal.GetVehicleType(Ride.VehicleId);
Ride.ProviderName = UserDal.GetUserName(Ride.ProviderId);
Ride.Route = new Route()
{
Source = locations.First(),
Destination = locations.Last(),
ViaPoints = new List <ViaPoint>()
};
locations.RemoveAt(0);
locations.RemoveAt(locations.Count - 1);
locations.ForEach(_ => Ride.Route.ViaPoints.Add(new ViaPoint()
{
Location = _
}));
rides.Add(Ride);
}
}
connection.Close();
}
return(rides);
}
private Ride BuildRide(Ride ride, string driverName, Vehicle vehicle, Employee employee)
{
var created = new Ride
{
CarrierId = ride.CarrierId,
Id = ride.Id,
Comments = ride.Comments,
Cost = ride.Cost,
Distance = ride.Distance,
Duration = ride.Duration,
EndAddress = ride.EndAddress,
StartAddress = ride.StartAddress,
EndDateTime = ride.EndDateTime,
StartDateTime = ride.StartDateTime,
StartLatitude = 10,
EndLatitude = 10,
StartLongitude = 10,
EndLongitude = 10,
Rating = ride.Rating,
RideId = ride.RideId,
VehicleId = ride.VehicleId,
Vehicle = vehicle == null ? null : new Vehicle()
{
LicensePlate = vehicle.LicensePlate,
Model = vehicle.Model,
Picture = vehicle.Picture,
Make = vehicle.Make,
Rate = vehicle.Rate
},
DriverId = ride.DriverId,
Driver = new Driver()
{
DriverId = ride.DriverId,
Name = driverName
},
EmployeeId = ride.EmployeeId,
Employee = employee == null ? null : new Employee()
{
EmployeeId = employee.EmployeeId,
Picture = employee.Picture,
Name = employee.Name
}
};
return(created);
}
public void GetStatus_ReturnsCorrectWithOneReport()
{
//Assign
Ride ride = new Ride();
Report report = new Report();
report.Status = Status.BeingRepaired;
Status expectedStatus = Status.BeingRepaired;
ride.AddReport(report);
//Action
Status actualStatus = ride.Status;
//Assert
Assert.Equal <Status>(expectedStatus, actualStatus);
}
public void IsValidRide_ReturnsTrueWithValidRide()
{
Member member = new Member();
BikeRoute route = new BikeRoute();
route.Difficulty = Difficulty.Easy;
Ride ride = new Ride();
DateTime date = DateTime.Today.AddDays(-10);
ride.Member = member;
ride.Route = route;
ride.RideDate = date;
(bool isValid, string errMsg)result = ride.IsValidRide;
Assert.True(result.isValid, result.errMsg);
}
public void EditExistingDetails(int rideId, DateTime rideDate, decimal?rideDistance, decimal?rideTime, int rideAscent, int bikeId)
{
Ride existingRide = Entities.Rides.Where(r => r.RideID == rideId).SingleOrDefault();
if (existingRide == null)
{
return;
}
existingRide.RideDate = rideDate;
existingRide.DistanceInMiles = rideDistance;
existingRide.TimeInMinutes = rideTime;
existingRide.Ascent = rideAscent;
existingRide.BikeID = bikeId;
Entities.SaveChanges();
}
public async Task <IActionResult> OnPostAsync(int?id)
{
if (id == null)
{
return(NotFound());
}
Ride = await _context.Ride.FindAsync(id);
if (Ride != null)
{
_context.Ride.Remove(Ride);
await _context.SaveChangesAsync();
}
return(RedirectToPage("./Index"));
}
public int CreateNewEntry(DateTime rideDate, decimal?rideDistance, decimal?rideTime, int rideAscent, int bikeId)
{
Ride newRide = new Ride
{
RideDate = rideDate,
DistanceInMiles = rideDistance,
TimeInMinutes = rideTime,
Ascent = rideAscent,
Bike = BikeList.Where(b => b.BikeID == bikeId).FirstOrDefault(),
BikeID = bikeId
};
Entities.Rides.Add(newRide);
Entities.SaveChanges();
return(newRide.RideID);
}
public static Ride CadastraRide(Ride r)
{
using (elmatEntities entities = new elmatEntities())
{
RIDE R = RideToRIDE(r);
try
{
entities.RIDE.Add(R);
entities.SaveChanges();
r.RideID = R.RideID;
return r;
}
catch (Exception e)
{
throw e;
}
}
}
public bool SaveVehicleRoute(Ride.Business.Objects.Employee employee, Ride.Business.Objects.Vehicles.Vehicle vehicle, Ride.Business.Objects.Routes.Route route)
{
try
{
using (RideWCFServiceImplementation client = GetSyncClient())
{
VehicleRoute request = new VehicleRoute();
SaveResponse response = null;
string gpsGateUser = string.Empty;
request.UniqueID = Guid.NewGuid().ToString();
request.VehicleID = vehicle.VehicleID;
request.VehicleIDSpecified = true;
if (employee == null)
request.PersonID = 0;
else
request.PersonID = employee.PersonID;
request.PersonIDSpecified = true;
if (route == null)
request.RouteID = 0;
else
request.RouteID = route.RouteID;
request.RouteIDSpecified = true;
//Only get the GPS Gate User if it is required. Otherwise, just move the vehicle/route...
if (Config.AppSettings.Ref.ProgramSettings.RequireGPSGateForVehicleRoute)
{
gpsGateUser = Config.AppSettings.Ref.GetGPSGateUser();
//If we don't have a GPS Gate User, then exit out because we dont have a user to update with
if (string.IsNullOrEmpty(gpsGateUser))
return false;
request.GpsGateUserName = gpsGateUser;
response = client.SaveVehicleRoute(_rideCredential, request);
}
else
{
response = client.MoveVehicleToRouteWithoutGPSGateUser(_rideCredential, request);
}
if (response == null)
return false;
return response.Success;
}
}
catch (System.Net.WebException ex)
{
Console.Write(ex.Message);
return false;
}
catch (Exception ex)
{
throw ex;
}
}
private Ride BuildRide(Ride ride, string driverName, Vehicle vehicle, Employee employee)
{
var created = new Ride
{
CarrierId = ride.CarrierId,
Id = ride.Id,
Comments = ride.Comments,
Cost = ride.Cost,
Distance = ride.Distance,
Duration = ride.Duration,
EndAddress = ride.EndAddress,
StartAddress = ride.StartAddress,
EndDateTime = ride.EndDateTime,
StartDateTime = ride.StartDateTime,
StartLatitude = 10,
EndLatitude = 10,
StartLongitude = 10,
EndLongitude = 10,
Rating = ride.Rating,
RideId = ride.RideId,
VehicleId = ride.VehicleId,
Vehicle = vehicle == null ? null : new Vehicle()
{
LicensePlate = vehicle.LicensePlate,
Model = vehicle.Model,
Picture = vehicle.Picture,
Make = vehicle.Make,
Rate = vehicle.Rate
},
DriverId = ride.DriverId,
Driver = new Driver()
{
DriverId = ride.DriverId,
Name = driverName
},
EmployeeId = ride.EmployeeId,
Employee = employee == null ? null : new Employee()
{
EmployeeId = employee.EmployeeId,
Picture = employee.Picture,
Name = employee.Name
}
};
return created;
}
private static Ride RIDEToRide(RIDE R)
{
Ride r = new Ride();
r.DriverID = R.DriverID != null ? R.DriverID.Value : 0;
r.RideID = R.RideID;
r.usr.UserID = R.UserID;
r.Hour = R.Hour;
r.LatOrigem = R.LatOrg;
r.LatDestino = R.LatDest;
r.LonDestino = R.LonDest;
r.LonOrigem = R.LonOrg;
return r;
}
private static RIDE RideToRIDE(Ride r)
{
RIDE R = new RIDE();
R.UserID = r.usr.UserID;
R.Hour = r.Hour;
R.LatOrg = r.LatOrigem;
R.LatDest = r.LatDestino;
R.LonDest = r.LonDestino;
R.LonOrg = r.LonOrigem;
return R;
}
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
{
RideId = rideId + 1,
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 = "199 E 23rd St",
EndAddress = "S Michigan Ave, Chicago",
StartLatitude = 41.851117,
StartLongitude = -87.623197,
EndLatitude = 41.848999,
EndLongitude = -87.623703,
};
rides.Add(ride);
distance = Randomize.Next(20, 40);
endTime = startDateTime02.AddMinutes(3 * distance);
duration = distance * 3;
cost = distance * vehicle.Rate;
ride = new Ride
{
RideId = rideId + 2,
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 = "199 E 23rd St",
EndAddress = "S Michigan Ave, Chicago",
StartLatitude = 41.851117,
StartLongitude = -87.623197,
EndLatitude = 41.848999,
EndLongitude = -87.623703,
};
rides.Add(ride);
distance = Randomize.Next(20, 40);
endTime = startDateTime03.AddMinutes(3 * distance);
duration = distance * 3;
cost = distance * vehicle.Rate;
ride = new Ride
{
RideId = rideId + 3,
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 = "199 E 23rd St",
EndAddress = "S Michigan Ave, Chicago",
StartLatitude = 41.851117,
StartLongitude = -87.623197,
EndLatitude = 41.848999,
EndLongitude = -87.623703,
};
rides.Add(ride);
distance = Randomize.Next(20, 40);
endTime = startDateTime04.AddMinutes(3 * distance);
duration = distance * 3;
cost = distance * vehicle.Rate;
ride = new Ride
{
RideId = rideId + 4,
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 Cermak Rd, Chicago",
EndAddress = "1589 E Marquette Rd",
StartLatitude = 41.852798,
StartLongitude = -87.624329,
EndLatitude = 41.775157,
EndLongitude = 87.586632,
};
rides.Add(ride);
distance = Randomize.Next(20, 40);
endTime = startDateTime05.AddMinutes(3 * distance);
duration = distance * 3;
cost = distance * vehicle.Rate;
ride = new Ride
{
RideId = rideId + 5,
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 = "2050 S Calumet Ave, Chicago",
EndAddress = "1589 E Marquette Rd",
StartLatitude = 41.854950,
StartLongitude = -87.619094,
EndLatitude = 41.775157,
EndLongitude = 87.586632,
};
rides.Add(ride);
distance = Randomize.Next(20, 40);
endTime = startDateTime06.AddMinutes(3 * distance);
duration = distance * 3;
cost = distance * vehicle.Rate;
ride = new Ride
{
RideId = rideId + 6,
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 = "2050 S Calumet Ave, Chicago",
EndAddress = "1589 E Marquette Rd",
StartLatitude = 41.854950,
StartLongitude = -87.619094,
EndLatitude = 41.775157,
EndLongitude = 87.586632,
};
rides.Add(ride);
rideId = rideId + 6;
}
context.Rides.AddRange(rides.ToArray<Ride>());
context.SaveChanges();
}
public async Task UpdateAsync(Ride ride)
{
_context.Rides.Update(ride);
await _context.SaveChangesAsync();
}
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();
}