public ActionResult DeleteConfirmed(int id)
        {
            RouteInformations routeinformations = db.RouteInformations.Find(id);

            db.RouteInformations.Remove(routeinformations);
            db.SaveChanges();
            return(RedirectToAction("Index"));
        }
 public ActionResult Edit([Bind(Include = "Id,VehicleNo,RouteId,UserId,StartTime,DepartureTime,DriverName,Phone")] RouteInformations routeinformations)
 {
     if (ModelState.IsValid)
     {
         db.Entry(routeinformations).State = EntityState.Modified;
         db.SaveChanges();
         return(RedirectToAction("Index"));
     }
     return(View(routeinformations));
 }
        // GET: /TransportAdmin/Delete/5
        public ActionResult Delete(int?id)
        {
            if (id == null)
            {
                return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
            }
            RouteInformations routeinformations = db.RouteInformations.Find(id);

            if (routeinformations == null)
            {
                return(HttpNotFound());
            }
            return(View(routeinformations));
        }
        // GET: /TransportAdmin/Edit/5
        public ActionResult Edit(int?id)
        {
            ViewBag.Route = db.Routes.ToList();
            ViewBag.Users = db.TransportUsers.ToList();
            if (id == null)
            {
                return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
            }
            RouteInformations routeinformations = db.RouteInformations.Find(id);

            if (routeinformations == null)
            {
                return(HttpNotFound());
            }
            return(View(routeinformations));
        }
 public ActionResult Create([Bind(Include = "Id,VehicleNo,RouteId,UserId,StartTime,DepartureTime,DriverName,Phone")] RouteInformations routeinformations)
 {
     if (ModelState.IsValid)
     {
         routeinformations.VehicleNo     = routeinformations.VehicleNo;
         routeinformations.RouteId       = routeinformations.RouteId;
         routeinformations.UserId        = routeinformations.UserId;
         routeinformations.StartTime     = routeinformations.StartTime;
         routeinformations.DepartureTime = routeinformations.DepartureTime;
         routeinformations.DriverName    = routeinformations.DriverName;
         routeinformations.Phone         = routeinformations.Phone;
         db.RouteInformations.Add(routeinformations);
         db.SaveChanges();
     }
     return(RedirectToAction("Create", new { message = "Route information Successfully inserted" }));
 }
        public JsonResult GetAllRouteInfoById(int id, int routeid)
        {
            List <RouteInformations> routs = new List <RouteInformations>();

            using (var db = new UniversityContext())
            {
                var a = db.RouteInformations.Where(s => s.UserId == id && s.RouteId == routeid);
                foreach (var k in a)
                {
                    RouteInformations routeInformations = new RouteInformations();
                    routeInformations.VehicleNo     = k.VehicleNo;
                    routeInformations.RouteId       = k.RouteId;
                    routeInformations.UserId        = k.UserId;
                    routeInformations.StartTime     = k.StartTime;
                    routeInformations.DepartureTime = k.DepartureTime;
                    routeInformations.DriverName    = k.DriverName;
                    routeInformations.Phone         = k.Phone;
                    routs.Add(routeInformations);
                }
            }
            return(Json(routs));
        }