public ActionResult DeleteConfirmed(int id)
{
route_trip route_trip = db.route_trip.Find(id);
db.route_trip.Remove(route_trip);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Edit([Bind(Include = "route_trip_id,route_id,number_of_trips,arrival_time,departure_time")] route_trip route_trip)
{
if (ModelState.IsValid)
{
db.Entry(route_trip).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.route_id = new SelectList(db.routes, "route_id", "source", route_trip.route_id);
return(View(route_trip));
}
// GET: /RouteTrip/Details/5
public ActionResult Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
route_trip route_trip = db.route_trip.Find(id);
if (route_trip == null)
{
return(HttpNotFound());
}
return(View(route_trip));
}
// GET: /RouteTrip/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
route_trip route_trip = db.route_trip.Find(id);
if (route_trip == null)
{
return(HttpNotFound());
}
ViewBag.route_id = new SelectList(db.routes, "route_id", "source", route_trip.route_id);
return(View(route_trip));
}
public ActionResult Create([Bind(Include = "route_trip_id,route_id,number_of_trips,arrival_time,departure_time")] route_trip route_trip, [Bind(Include = "bus_id")] bus busid, [Bind(Include = "driver_id")] driver driverid)
{
// if (ModelState.IsValid)
// {
db.route_trip.Add(route_trip);
db.SaveChanges();
bus_trip trip = new bus_trip();
// ViewBag.driver_id = new SelectList(db.drivers, "driver_id", "driver_name", trip.driver_id);
// ViewBag.bus_id = new SelectList(db.buses, "bus_id", "bus_id", trip.driver_id);
trip.bus_id = busid.bus_id;
trip.bus_trip_date = DateTime.Now;
trip.start_time = route_trip.arrival_time;
trip.end_time = route_trip.departure_time;
trip.driver_id = driverid.driver_id;
trip.route_trip_id = route_trip.route_trip_id;
db.bus_trip.Add(trip);
db.SaveChanges();
// }
// ViewBag.route_id = new SelectList(db.routes, "route_id", "source", route_trip.route_id);
ViewBag.route_id = from r in db.routes.ToList()
select new
{
id = r.route_id,
about_route = r.source + " - " + r.destination
};
ViewBag.bus_id = new SelectList(db.buses, "bus_id", "bus_id");
ViewBag.driver_id = new SelectList(db.drivers, "driver_id", "driver_name");
return(RedirectToAction("Index"));
// return View(route_trip);
}
