public ManageRoute SetModelObject(string routeId, string vehicleId, string stopId)
{
ManageRoute route = new ManageRoute();
using (DSRCManagementSystemEntities1 db = new DSRCManagementSystemEntities1())
{
route.RouteId = Convert.ToInt32(routeId);
route.VehicleId = Convert.ToInt32(vehicleId);
route.StopId = Convert.ToInt32(stopId);
route.RouteName = db.Routes.Where(x => x.RouteId == route.RouteId).FirstOrDefault().Route_Name;
var stopItemList = (from routes in db.Routes join routeMap in db.RoutesStops_Mapping on routes.RouteId equals routeMap.RouteId join vehicle in db.Vehicles on routeMap.VehicleId equals vehicle.VehicleId select new { stopId = routeMap.StopId, StopName = routeMap.Stop }).ToList()
.Select(x => new SelectListItem {
Value = x.stopId.ToString(), Text = x.StopName.Stop_Name
}); //db.Stops.ToList().Where(x => !string.IsNullOrEmpty(x.Stop_Name)).Select(X => new SelectListItem { Value = X.StopId.ToString(), Text = X.Stop_Name });
//SelectListItem StopItem = stopItemList.Where(x => x.Value == stopId).FirstOrDefault();
//if (StopItem != null)
// stopItemList = new SelectList(stopItemList, "value", "text", StopItem.Value);
//route.StopItemList = stopItemList;
var vehicleList = db.Vehicles.ToList().Select(x => new SelectListItem {
Value = x.VehicleId.ToString(), Text = x.Vehicle_No
});
SelectListItem vehicleItem = vehicleList.Where(x => x.Value == vehicleId).FirstOrDefault();
if (vehicleItem != null)
{
vehicleList = new SelectList(vehicleList, "value", "text", vehicleItem.Value);
}
ViewData["VehicleList"] = vehicleList;
}
return(route);
}
public ActionResult EditRoute(ManageRoute obj)
{
Route route = new Route();
RoutesStops_Mapping routeMap = new RoutesStops_Mapping();
using (var db = new DSRCManagementSystemEntities1())
{
route = db.Routes.ToList().Where(x => x.RouteId == obj.RouteId).FirstOrDefault();
route.Route_Name = obj.RouteName;
routeMap = db.RoutesStops_Mapping.ToList().Where(x => x.RouteId == obj.RouteId).FirstOrDefault();
routeMap.VehicleId = obj.VehicleId;
routeMap.StopId = obj.StopId;
db.SaveChanges();
}
return(RedirectToAction("RouteDetails", "Transportation"));
}
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));
}
public ActionResult RouteDetails()
{
DSRCManagementSystemEntities1 db = new DSRCManagementSystemEntities1();
var routeDetails = (from route in db.Routes
join routeMap in db.RoutesStops_Mapping
on route.RouteId equals routeMap.RouteId
join vehicle in db.Vehicles
on routeMap.VehicleId equals vehicle.VehicleId
join stops in db.Stops
on routeMap.StopId equals stops.StopId
select new
{
RouteName = route.Route_Name,
Stopping = stops.Stop_Name,
vehicleNo = vehicle.Vehicle_No,
RouteId = route.RouteId,
vehicleId = vehicle.VehicleId,
stopId = stops.StopId
}).ToList();
List <ManageRoute> manageRouteList = new List <ManageRoute>();
ManageRoute manageRoute;
foreach (var routeDetail in routeDetails)
{
manageRoute = new ManageRoute();
manageRoute.Stops = routeDetail.Stopping;
manageRoute.RouteName = routeDetail.RouteName;
manageRoute.VehicleNumber = routeDetail.vehicleNo;
manageRoute.RouteId = routeDetail.RouteId;
manageRoute.StopId = routeDetail.stopId;
manageRoute.VehicleId = routeDetail.vehicleId;
manageRouteList.Add(manageRoute);
}
return(View(manageRouteList));
}
public ActionResult AddRoute(ManageRoute obj, string[] StopArray)
{
using (var db = new DSRCManagementSystemEntities1())
{
//Adding Route Name to Routes Table
Route route = new Route();
route.Route_Name = obj.RouteName;
db.Routes.AddObject(route);
foreach (var stopId in StopArray)
{
//Adding Details to RouteMapping Table
RoutesStops_Mapping route_StopMapping = new RoutesStops_Mapping();
route_StopMapping.RouteId = route.RouteId;
route_StopMapping.VehicleId = obj.VehicleId;
route_StopMapping.StopId = Convert.ToInt32(stopId);
db.RoutesStops_Mapping.AddObject(route_StopMapping);
}
db.SaveChanges();
}
return(RedirectToAction("RouteDetails", "Transportation"));
}
public ActionResult EditRoute(string routeId, string vehicleId, string stopId)
{
ManageRoute route = SetModelObject(routeId, vehicleId, stopId);
return(View(route));
}
