public List <ManageTrips> GetTrips()
{
List <ManageTrips> ManageTrip = new List <ManageTrips>();
List <Trip> trips = db.Trips.ToList();
foreach (var trip in trips)
{
ManageTrips manage = new ManageTrips();
manage.trip = trip;
manage.tripStops = db.TripStops.Where(ts => ts.TripId == trip.Id).OrderBy(ts => ts.ArrivalTime).ToList();
ManageTrip.Add(manage);
}
return(ManageTrip);
}
public string AddNewTrip(ManageTrips addTrip)
{
try
{
Trip trip = addTrip.trip;
trip.Status = "Scheduled";
db.Trips.Add(trip);
db.SaveChanges();
foreach (TripStop tripStop in addTrip.tripStops)
{
tripStop.TripId = trip.Id;
db.TripStops.Add(tripStop);
}
db.SaveChanges();
return("Added");
}
catch
{
return("Error");
}
}
