public ActionResult Create([Bind(Include = "bus_type_id,bus_type_name")] bus_type bus_type)
{
if (ModelState.IsValid)
{
db.bus_type.Add(bus_type);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(bus_type));
}
public ActionResult Create([Bind(Include = "company_id,company_name,company_address,company_phone_number")] company company)
{
if (ModelState.IsValid)
{
db.companies.Add(company);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(company));
}
public ActionResult Create([Bind(Include = "location_id,location_name,latitude,longitude")] location location)
{
if (ModelState.IsValid)
{
db.locations.Add(location);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(location));
}
public ActionResult Create([Bind(Include = "drives_id,driver_id,bus_id")] drive drive)
{
if (ModelState.IsValid)
{
db.drives.Add(drive);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.bus_id = new SelectList(db.buses, "bus_id", "bus_id", drive.bus_id);
ViewBag.driver_id = new SelectList(db.drivers, "driver_id", "driver_name", drive.driver_id);
return(View(drive));
}
public ActionResult Create([Bind(Include = "bus_id,bus_type_id,company_id")] bus bus)
{
if (ModelState.IsValid)
{
db.buses.Add(bus);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.bus_type_id = new SelectList(db.bus_type, "bus_type_id", "bus_type_name", bus.bus_type_id);
ViewBag.company_id = new SelectList(db.companies, "company_id", "company_name", bus.company_id);
return(View(bus));
}
public ActionResult Create([Bind(Include = "route_id,source,destination")] route route)
{
ViewBag.source = new SelectList(db.locations, "location_name", "location_name");
ViewBag.destination = new SelectList(db.locations, "location_name", "location_name");
if (ModelState.IsValid)
{
db.routes.Add(route);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(route));
}
public ActionResult DeleteConfirmed(int id)
{
complaint complaint = db.complaints.Find(id);
db.complaints.Remove(complaint);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Create([Bind(Include = "complaint_id,complaint1,route_id")] complaint complaint)
{
if (ModelState.IsValid)
{
db.complaints.Add(complaint);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.route_id = from r in db.routes.ToList()
select new
{
id = r.route_id,
about_route = r.source + " - " + r.destination
};
return(View(complaint));
}
public ActionResult Create([Bind(Include = "passes_through_id,route_id,location_id,order_no,time_to_reach")] passes_through passes_through)
{
if (ModelState.IsValid)
{
db.passes_through.Add(passes_through);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.location_id = new SelectList(db.locations, "location_id", "location_name", passes_through.location_id);
// ViewBag.route_id = new SelectList(db.routes, "route_id", "source", passes_through.route_id);
ViewBag.route_id = from r in db.routes.ToList()
select new
{
id = r.route_id,
about_route = r.source + " - " + r.destination
};
return(View(passes_through));
}
public ActionResult Create([Bind(Include = "driver_id,driver_name,phone_number,driver_address,gender,date_of_birth")] driver driver)
{
if (ModelState.IsValid)
{
db.drivers.Add(driver);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.gender = new SelectList(new List <SelectListItem> {
new SelectListItem {
Text = "Male", Value = "Male"
}, new SelectListItem {
Text = "Female", Value = "Female"
}
},
"Value", "Text");
return(View(driver));
}
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);
}
