public ActionResult UpdateRoute(int routeId, List<int> stopIds, string routeName, int busId, string driverLicense) { DatabaseInterface db = new DatabaseInterface(); String sRouteId = routeId.ToString(); if (!db.IsRouteNameUnique(routeName, sRouteId)) return Json("false"); List<Stop> stops = new List<Stop>(); foreach (int id in stopIds) { stops.Add(db.GetStopByStopId(id)); } db.AssignBusToRoute(busId, routeId); db.AssignDriverToRoute(driverLicense, routeId); Route route = new Route() { Stops = stops, Driver = db.GetDriverByDriverLicense(driverLicense), Name = routeName, RouteId = routeId, Bus = db.GetBusByBusId(busId) }; db.UpdateRoute(route); return Json("true"); }
public ActionResult ModifyBus(int busId) { DatabaseInterface db = new DatabaseInterface(); Bus bus = db.GetBusByBusId(busId); AddBusModel model = new AddBusModel { StateNames = stateNames, StateAbbreviations = stateAbbreviations, Capacity = bus.Capacity.ToString(), License = bus.LicensePlate, UpdatingBus = true, Status = bus.Status.ToString(), State = bus.State, BusId = busId.ToString() }; return PartialView("AddBus", model); }
public ActionResult UpdateBus(string busId, int capacity, string license, string state, string status) { DatabaseInterface db = new DatabaseInterface(); if (!db.IsLicenseUnique(license, busId)) return Json("false"); Bus bus = db.GetBusByBusId(int.Parse(busId)); bus.LicensePlate = license; bus.BusId = int.Parse(busId); BusStatus busStatus; if (status.Equals("0")) { busStatus = BusStatus.Active; } else { busStatus = BusStatus.Inactive; } bus.Status = busStatus; bus.Capacity = capacity; bus.State = state; db.UpdateBus(bus); return Json("true"); }
public ActionResult AddNewRoute(List<int> stopIds, string routeName, int busId, bool startsAtWork, string driverLicense) { DatabaseInterface db = new DatabaseInterface(); if (!db.IsRouteNameUnique(routeName)) return Json("false"); int routeId; if (startsAtWork) routeId = db.GetNextLowRouteId(); else routeId = db.GetNextHighRouteId(); List<Stop> stops = new List<Stop>(); foreach (int id in stopIds) { stops.Add(db.GetStopByStopId(id)); } List<Route> routes = new List<Route>(); routes = db.GetAvailableRoutes(); db.AssignBusToRoute(busId, routeId); db.AssignDriverToRoute(driverLicense, routeId); Route route = new Route() { Stops = stops, Driver = db.GetDriverByDriverLicense(driverLicense), Name = routeName, RouteId = routeId, Id = ObjectId.GenerateNewId(), Bus = db.GetBusByBusId(busId) }; db.AddRoute(route); return Json(new { success = "true", id = route.Id.ToString() }); }