public object search(JourneyRoute journeyinfo) { //var busInfoPost = db.proc_Bus(journeyinfo.FromLocation, journeyinfo.ToLocation, journeyinfo.FromDate); var busInfoPost = db.proc_Buses(journeyinfo.TripID, journeyinfo.FromDate); return(busInfoPost); }
public IHttpActionResult PutJourneyRoute(int id, JourneyRoute journeyRoute) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } if (id != journeyRoute.RouteID) { return(BadRequest()); } db.Entry(journeyRoute).State = EntityState.Modified; try { db.SaveChanges(); } catch (DbUpdateConcurrencyException) { if (!JourneyRouteExists(id)) { return(NotFound()); } else { throw; } } return(StatusCode(HttpStatusCode.NoContent)); }
private void GetRoutes(Journey journey) { journey.Routes.Clear(); var availableRoutesInJourney = _context.JourneyRoutes.Where(route => route.JourneyId == journey.Id).ToList(); foreach (var journeyRoute in availableRoutesInJourney) { var newJourneyRoute = new JourneyRoute(journey.Id, journeyRoute.Order, journeyRoute.RouteId) { Route = _context.Routes.FirstOrDefault(rt => rt.Id == journeyRoute.RouteId) }; journey.Routes.Add(newJourneyRoute); } }
public object AddRoute(JourneyRoute journeyRoute) { int count = db.JourneyRoutes.ToList().Where(route => route.RouteID == journeyRoute.RouteID).Count(); if (count == 1) { return("This Route Already Exists"); } else { db.proc_AddRoute(journeyRoute.TripID, journeyRoute.FromLocation, journeyRoute.ToLocation, journeyRoute.FromDate, journeyRoute.ToDate, journeyRoute.FromTime, journeyRoute.ToTime, journeyRoute.FromDescription, journeyRoute.ToDescription, journeyRoute.Fare, journeyRoute.NumberOfSeats); db.SaveChanges(); return("Route Added Successfully"); } }
public Journey AddJourney(Journey journey, List <JourneyAsset> journeyAssets, List <JourneyAssetDriver> journeyAssetDrivers, List <JourneyAssetExternalPassenger> journeyAssetExternalPassengers, JourneyRoute journeyRoute) { IHttpRestRequest request = GetRequest(APIControllerRoutes.JourneysController.ADDJOURNEY, HttpMethod.Put); request.AddJsonBody(journey); request.AddJsonBody(journeyAssets); request.AddJsonBody(journeyAssetDrivers); request.AddJsonBody(journeyAssetExternalPassengers); request.AddJsonBody(journeyRoute); IHttpRestResponse <Journey> response = Execute <Journey>(request, 1); return(response.Data); }
public async Task <Journey> AddJourneyAsync(Journey journey, List <JourneyAsset> journeyAssets, List <JourneyAssetDriver> journeyAssetDrivers, List <JourneyAssetExternalPassenger> journeyAssetExternalPassengers, JourneyRoute journeyRoute) { IHttpRestRequest request = GetRequest(APIControllerRoutes.JourneysController.ADDJOURNEY, HttpMethod.Put); request.AddJsonBody(journey); request.AddJsonBody(journeyAssets); request.AddJsonBody(journeyAssetDrivers); request.AddJsonBody(journeyAssetExternalPassengers); request.AddJsonBody(journeyRoute); IHttpRestResponse <Journey> response = await ExecuteAsync <Journey>(request, 1).ConfigureAwait(false); return(response.Data); }