public ActionResult AddStops(string VehicleId)
{
ManageStops stopDetail = new ManageStops();
using (DSRCManagementSystemEntities1 db = new DSRCManagementSystemEntities1())
{
int vehichleId = string.IsNullOrEmpty(VehicleId) ? 0 : Convert.ToInt32(VehicleId);
ViewData["Stops"] = db.Stops.ToList().Select(x => new SelectListItem {
Text = x.Stop_Name, Value = x.StopId.ToString()
});
var driverList = (from vehicle in db.Vehicles
join vehicleMap in db.DriverVehicle_Mapping on vehicle.VehicleId equals vehicleMap.VehicleId
join drivers in db.Drivers on vehicleMap.DriverId equals drivers.DriverId
where vehicle.VehicleId == vehichleId
select new { DriverName = drivers.First_Name + " " + drivers.Last_Name, driverId = drivers.DriverId, VehicleId = vehicle.VehicleId }).ToList().Select(x => new SelectListItem {
Text = x.DriverName, Value = x.driverId.ToString()
});
ViewData["DriverName"] = driverList;
var vehicleList = db.Vehicles.ToList().Select(x => new SelectListItem {
Value = x.VehicleId.ToString(), Text = x.Vehicle_No
});
stopDetail.vehicleId = vehichleId;
ViewData["VehicleList"] = vehicleList;
}
return(View(stopDetail));
}
public ActionResult AddRoute(int stopId = 0, ManageStops obj = null)
{
ManageRoute route = new ManageRoute();
using (DSRCManagementSystemEntities1 db = new DSRCManagementSystemEntities1())
{
if (Request.IsAjaxRequest())
{
//stopId = Convert.ToInt32(Request.QueryString["stopId"].ToString());
List <SelectListItem> item = new List <SelectListItem>();
var stopsDetails = db.Stops.ToList();
string stopval = "";
foreach (var stops in stopsDetails)
{
if (stops.StopId == stopId)
{
stopval = stops.StopId.ToString();
item.Add(new SelectListItem {
Text = stops.Stop_Name, Value = stops.StopId.ToString()
});
}
}
route.StopItemList = item.ToList();
return(Json(item, JsonRequestBehavior.AllowGet));
}
ViewData["VehicleList"] = db.Vehicles.ToList().Select(x => new SelectListItem {
Value = x.VehicleId.ToString(), Text = x.Vehicle_No
});
//route.StopItemList = db.Stops.ToList().Where(x => !string.IsNullOrEmpty(x.Stop_Name)).Select(X => new SelectListItem { Value = X.StopId.ToString(), Text = X.Stop_Name });
}
return(View(route));
}
