コード例 #1
0
        public ActionResult DeleteConfirmed(int id)
        {
            BusTrace busTrace = db.BusTraces.Find(id);

            db.BusTraces.Remove(busTrace);
            db.SaveChanges();
            return(RedirectToAction("Index"));
        }
コード例 #2
0
 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));
 }
コード例 #3
0
        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));
        }
コード例 #4
0
        // 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));
        }
コード例 #5
0
        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));
        }