// GET: SPRouteStop
/// <summary>
/// Index ActionResult
/// Takes busRouteCode as cookie or session variables
/// Assigns cookie or session variables to busRouteCode when there's no parameter
/// </summary>
/// <param name="busRouteCode">Query string that narrows the result</param>
/// <returns></returns>
public ActionResult Index(string busRouteCode)
{
if (busRouteCode != null)
{
Session["busRouteCode"] = busRouteCode;
Response.Cookies.Add(new HttpCookie("busRouteCode", busRouteCode));
}
else if (Request.Cookies["busRoutecode"] != null)
{
busRouteCode = Request.Cookies["busRouteCode"].Value;
}
else if (Session["busRouteCode"] != null)
{
busRouteCode = Session["busRouteCode"].ToString();
}
else
{
TempData["message"] = "Please select Bus Route..";
return(RedirectToAction("index", "SPBusRoute"));
}
var routeStops = db.routeStops.Where(r => r.busRouteCode == busRouteCode).OrderBy(r => r.offsetMinutes).Include(r => r.busRoute).Include(r => r.busStop);
// To display title of this view with busRouteCode and RouteName
ViewBag.busRouteCode = busRouteCode;
busRoute busRoute = db.busRoutes.Find(busRouteCode);
ViewBag.busRouteName = busRoute.routeName;
return(View(routeStops.ToList()));
}
// GET: SPRouteStop/Create
/// <summary>
/// Create ActionResult
/// Examines if there are any cookie or session variables to make title of this view
/// </summary>
/// <returns></returns>
public ActionResult Create()
{
string busRouteCode = "";
//Examines cookie or session variables to assign to make title of this view
if (Request.Cookies["busRoutecode"] != null)
{
busRouteCode = Request.Cookies["busRouteCode"].Value;
}
else if (Session["busRouteCode"] != null)
{
busRouteCode = Session["busRouteCode"].ToString();
}
else
{
TempData["message"] = "Please select Bus Route..";
return(RedirectToAction("index", "SPBusRoute"));
}
// To display title of this view with busRouteCode and RouteName
ViewBag.busRouteCode_ = busRouteCode;
busRoute busRoute = db.busRoutes.Find(busRouteCode);
ViewBag.busRouteName = busRoute.routeName;
//Commented because this auto generated code doesn't need any more.
//ViewBag.busRouteCode = new SelectList(db.busRoutes, "busRouteCode", "routeName", busRoute.busRouteCode);
ViewBag.busStopNumber = new SelectList(db.busStops, "busStopNumber", "location", busRoute.busRouteCode);
return(View());
}
public ActionResult DeleteConfirmed(string id)
{
busRoute busRoute = db.busRoutes.Find(id);
db.busRoutes.Remove(busRoute);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Edit([Bind(Include = "busRouteCode,routeName")] busRoute busRoute)
{
if (ModelState.IsValid)
{
db.Entry(busRoute).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(busRoute));
}
/// <summary>
/// Combine routeCode and busStop to return schedule
/// </summary>
/// <param name="form"></param>
/// <returns>selected busStop and selected busRoute schedule</returns>
public ActionResult RouteStopSchedule(FormCollection form)
{
string busRouteCode = "";
//RouteSelector ActionResult of SPBusStopController may set this Session variable
if (Session["routeCodeFromBusStop"] == null)
{
//RouteSelector View of SPBusStopController may select one of dropDownList
if (form["routeNames"] == null)
{
TempData["message"] = "No Bus Route selected!";
return(RedirectToAction("index", "SPBusStop"));
}
else
{
busRouteCode = form["routeNames"];
}
}
else
{
busRouteCode = Session["routeCodeFromBusStop"].ToString();
Session["routeCodeFromBusStop"] = null;
}
int busStopNumber = (int)Session["busStopNumber"];
int offsetMinutes = 0;
busRoute busRoute = db.busRoutes.Find(busRouteCode);
ViewBag.selectedRouteName = busRouteCode + " - " + busRoute.routeName;
busStop busStop = db.busStops.Find(busStopNumber);
ViewBag.selectedLocation = busStopNumber + " - " + busStop.location;
//Finds out offsetMunutes of selected busRoute and selected busStop
//If there are more than one record found accidently, it abends!!
var routeStop = db.routeStops.Where(a => a.busRouteCode == busRouteCode && a.busStopNumber == busStopNumber).Single();
offsetMinutes = (int)routeStop.offsetMinutes;
//Composes all startTimes within the schedule
var selectedSchedule = from r in db.routeSchedules
where (r.busRouteCode == busRouteCode)
orderby r.startTime
select r;
//Callculates busStop arrival times and returns model
foreach (var item in selectedSchedule)
{
item.startTime = item.startTime.Add(TimeSpan.FromMinutes(offsetMinutes));
}
return(View(selectedSchedule));
}
public ActionResult Create([Bind(Include = "busRouteCode,routeName")] busRoute busRoute)
{
if (ModelState.IsValid)
{
db.busRoutes.Add(busRoute);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(busRoute));
}
/// <summary>
/// Handles post actions depends on number of routeCodes
/// </summary>
/// <param name="id"></param>
/// <returns>
/// case 1 : no routeCode returns Index View
/// case 2 : 1 routeCode returns RouteStopSchedule View of SPRouteSchedule controller
/// case 3 : more than 1 routeCodes ruturn RouteSelector View
/// </returns>
public ActionResult RouteSelector(int?id)
{
if (id == null)
{
TempData["message"] = "Select bus stop..";
return(RedirectToAction("Index"));
}
else
{
Session["busStopNumber"] = id;
int selectedCount = 0;
var query = (from r in db.routeStops where r.busStopNumber == id select r.busRouteCode).Distinct().ToList();
string routeCodeToRouteStopSchedule = "";
List <SelectListItem> selectRouteNames = new List <SelectListItem>();
foreach (var routeCode in query)
{
if (routeCode == null)
{
continue;
}
busRoute busRoute = db.busRoutes.Find(routeCode);
selectRouteNames.Insert(selectedCount, new SelectListItem {
Value = routeCode, Text = busRoute.routeName
});
routeCodeToRouteStopSchedule = routeCode;
selectedCount++;
}
ViewBag.routeNames = selectRouteNames.OrderBy(a => a.Text);
//selectedCount = selectedCount - 1;
if (selectedCount == 1)
{
Session["routeCodeFromBusStop"] = routeCodeToRouteStopSchedule;
return(RedirectToAction("RouteStopSchedule", "SPRouteSchedule"));
}
else if (selectedCount > 1)
{
return(View());
}
else
{
var busStop = db.busStops.Find(id);
string busLocation = busStop.location;
TempData["message"] = "No route found for " + busLocation + "(" + id + ")";
return(RedirectToAction("Index"));
}
}
}
public static async Task <List <busRoute> > readBusRoutes()
{
List <busRoute> routes = new List <busRoute>();
await databaseManager.selectQuery("SELECT * FROM busroutes", (DbDataReader reader) =>
{
busRoute route = new busRoute();
route.name = (string)reader["name"];
route.stations = NAPI.Util.FromJson <List <point> >((string)reader["points"]);
route.id = (int)reader["id"];
routes.Add(route);
}).Execute();
return(routes);
}
// GET: SPBusRoutes/Edit/5
public ActionResult Edit(string id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
busRoute busRoute = db.busRoutes.Find(id);
if (busRoute == null)
{
return(HttpNotFound());
}
return(View(busRoute));
}
public void createRoute(Player client, string name)
{
if (playerManager.doesPlayerHasAdmin(client) <= 0)
{
client.SendChatMessage("!{#CEF0AC}You need to be an admin.");
return;
}
if (client.HasData("createdBusRoute"))
{
client.SendChatMessage("Esti deja intr-un route creation."); return;
}
;
var rotue = new busRoute();
rotue.name = name;
rotue.stations = new List <point>();
client.SetData("createdBusRoute", rotue);
}
// GET: SPRouteStop/Edit/5
/// <summary>
/// Edit ActionResult
/// Examines if there's any cookie or session variables to make title of this view
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
routeStop routeStop = db.routeStops.Find(id);
if (routeStop == null)
{
return(HttpNotFound());
}
string busRouteCode = "";
//Examines cookie or session variables to assign to make title of this view
if (Request.Cookies["busRoutecode"] != null)
{
busRouteCode = Request.Cookies["busRouteCode"].Value;
}
else if (Session["busRouteCode"] != null)
{
busRouteCode = Session["busRouteCode"].ToString();
}
else
{
TempData["message"] = "Please select Bus Route..";
return(RedirectToAction("index", "SPBusRoute"));
}
// To display title of this view with busRouteCode and RouteName
ViewBag.busRouteCode_ = busRouteCode;
busRoute busRoute = db.busRoutes.Find(busRouteCode);
ViewBag.busRouteName = busRoute.routeName;
//This was commented to hide busRotueCode
//ViewBag.busRouteCode = new SelectList(db.busRoutes, "busRouteCode", "routeName", routeStop.busRouteCode);
ViewBag.busStopNumber = new SelectList(db.busStops, "busStopNumber", "location", routeStop.busStopNumber);
return(View(routeStop));
}
// GET: SPRouteStop/Details/5
/// <summary>
/// Details ActionResult
/// Examines if there are any cookie or session variables to make title of this view
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public ActionResult Details(int?id)
{
string busRouteCode = "";
//Examines cookie or session variables to assign to make title of this view
if (Request.Cookies["busRoutecode"] != null)
{
busRouteCode = Request.Cookies["busRouteCode"].Value;
}
else if (Session["busRouteCode"] != null)
{
busRouteCode = Session["busRouteCode"].ToString();
}
else
{
TempData["message"] = "Please select Bus Route..";
return(RedirectToAction("index", "SPBusRoute"));
}
// To display title of this view with busRouteCode and RouteName
ViewBag.busRouteCode = busRouteCode;
busRoute busRoute = db.busRoutes.Find(busRouteCode);
ViewBag.busRouteName = busRoute.routeName;
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
routeStop routeStop = db.routeStops.Find(id);
if (routeStop == null)
{
return(HttpNotFound());
}
return(View(routeStop));
}
public static async Task <int> createBusRoute(busRoute gs)
{
return(await databaseManager.updateQuery($"INSERT INTO busroutes (name, points) VALUES ('{gs.name}', '{NAPI.Util.ToJson(gs.stations)}')").Execute());
}
