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()
});
}
