public ActionResult DeleteConfirmed(int id) { BusTrace busTrace = db.BusTraces.Find(id); db.BusTraces.Remove(busTrace); db.SaveChanges(); return(RedirectToAction("Index")); }
public ActionResult Edit([Bind(Include = "Id,BusId,Longitude,Latitude,Timestamp")] BusTrace busTrace) { if (ModelState.IsValid) { db.Entry(busTrace).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(busTrace)); }
public ActionResult Create([Bind(Include = "Id,BusId,Longitude,Latitude,Timestamp")] BusTrace busTrace) { if (ModelState.IsValid) { db.BusTraces.Add(busTrace); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(busTrace)); }
// GET: BusTraces/Delete/5 public ActionResult Delete(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } BusTrace busTrace = db.BusTraces.Find(id); if (busTrace == null) { return(HttpNotFound()); } return(View(busTrace)); }
public ActionResult Index() { List <Bus> busList = _dbcontext.Buses.ToList(); ViewBag.BusInfo = busList; var temp = (from p in _dbcontext.BusPositions select new { Id = p.Id, BusId = p.BusId, Latitude = p.Latitude, Longitude = p.Longitude, BusName = p.Bus.BusName, Timestamp = p.Timestamp }).ToList(); var model = new EditBusLineViewModel(); model.Traces = _dbcontext.BusTraces.OrderBy(C => C.OrderNum).ToList(); model.Stations = _dbcontext.Stations.ToList(); model.Lines = _dbcontext.Lines.ToList(); int maxId; if (model.Traces.Count != 0) { maxId = model.Traces.Max(a => a.Id); } else { maxId = 1; } foreach (Bus b in busList) { int traceNum = model.Traces.Where(a => a.BusId == b.BusId).Count(); if (traceNum == 0) { var stations = model.Lines.Where(l => l.LineID == b.BusId).OrderBy(l => l.StationNr).ToList(); if (stations.Count != 0) { //int order = 0; foreach (Line st in stations) { maxId += 1; Station station = model.Stations.Find(s => s.StationID == st.StationID); BusTrace trace = new BusTrace(); trace.BusId = b.BusId; trace.Id = maxId; trace.Latitude = station.Latitude; trace.Longitude = station.Longitude; trace.EndPoint = true; // trace.OrderNum = order; // order += 1; model.Traces.Add(trace); } } } } int order = 0; foreach (BusTrace trace in model.Traces) { trace.OrderNum = order; order += 1; } return(View(model)); }