public ActionResult EditVehicle(string Id) { int vehicleid = Convert.ToInt32(Id); DSRCManagementSystemEntities1 db = new DSRCManagementSystemEntities1(); DSRCManagementSystem.Models.AddVehicle objmodel = new DSRCManagementSystem.Models.AddVehicle(); var value = db.Vehicles.Where(x => x.VehicleId == vehicleid).Select(o => o).FirstOrDefault(); var model = (from p in db.Master_VehicleModel select new { ModelId = p.VehicleModel_Id, Model = p.VehicleModel }).ToList(); var brand = (from p in db.Master_VehicleBrand select new { BrandId = p.VehicleBrand_Id, Brand = p.VehicleBrand }).ToList(); var type = (from P in db.Master_VehicleType select new { Typeid = P.VehicleType_Id, Type = P.VehicleType }).ToList(); ViewBag.VehicleModel = new SelectList(model, "ModelId", "Model", value.VehicleModel_Id); ViewBag.VehicleBrand = new SelectList(brand, "BrandId", "Brand", value.VehicleBrand_Id); ViewBag.VehicleType = new SelectList(type, "Typeid", "Type", value.VehicleType_Id); ViewBag.Years = new SelectList(GetYears(), "", "", value.Model_Year); objmodel.Vehicle_No = value.Vehicle_No; objmodel.VehicleMake = value.VehicleMake; objmodel.Remarks = value.Vehicle_Remarks; objmodel.VehicleBrand = Convert.ToString(value.VehicleBrand_Id); objmodel.VehicleType = Convert.ToString(value.VehicleType_Id); objmodel.VehicleModel = Convert.ToString(value.VehicleModel_Id); objmodel.Model_Year = value.Model_Year; objmodel.No_of_Seat = value.No_of_Seat; objmodel.Trip = value.No_of_Trip; objmodel.Contact_No = value.Contact_No; objmodel.vehicleid = Convert.ToInt32(vehicleid); //objmodel.Vehicle_Photo = value.Vehicle_Photo; //List<int> Years = new List<int>(); //ViewBag.Years = new SelectList(Years, "", "", value.Model_Year); return(View(objmodel)); }
public ActionResult AddVehicle() { DSRCManagementSystemEntities1 db = new DSRCManagementSystemEntities1(); DSRCManagementSystem.Models.AddVehicle objmodel = new DSRCManagementSystem.Models.AddVehicle(); //var vehi = (from a in db.Vehicles // join b in db.Master_VehicleModel on a.VehicleModel_Id equals b.VehicleModel_Id // join c in db.Master_VehicleBrand on a.VehicleBrand_Id equals c.VehicleBrand_Id // join d in db.Master_VehicleType on a.VehicleType_Id equals d.VehicleType_Id // select new DSRCManagementSystem.Models.AddVehicle() // { // VehicleModel_Id = a.VehicleModel_Id, // VehicleBrand_Id = a.VehicleBrand_Id, // VehicleType_Id = a.VehicleType_Id, // }).ToList(); var model = (from p in db.Master_VehicleModel select new { ModelId = p.VehicleModel_Id, Model = p.VehicleModel }).ToList(); var brand = (from p in db.Master_VehicleBrand select new { BrandId = p.VehicleBrand_Id, Brand = p.VehicleBrand }).ToList(); var type = (from P in db.Master_VehicleType select new { Typeid = P.VehicleType_Id, Type = P.VehicleType }).ToList(); ViewBag.VehicleModel = new SelectList(model, "ModelId", "Model"); ViewBag.VehicleBrand = new SelectList(brand, "BrandId", "Brand"); ViewBag.VehicleType = new SelectList(type, "Typeid", "Type"); ViewBag.Years = new SelectList(GetYears(), "", ""); //GetYears(); return(View()); }
public ActionResult AssignDriver(int Id) { DSRCManagementSystemEntities1 db = new DSRCManagementSystemEntities1(); DSRCManagementSystem.Models.AddVehicle objmodel = new DSRCManagementSystem.Models.AddVehicle(); try { //var vehicles = (from p in db.Vehicles.Where(x => x.IsActive == true || x.IsActive == null) // select new // { // VehicleId = p.VehicleId, // VehicleNo = p.Vehicle_No, // }).ToList(); var num = db.Vehicles.Where(x => x.VehicleId == Id).Select(x => x).FirstOrDefault(); //var Vehicle = (from x in db.Vehicles // select new // { // VehileId = x.VehicleId, // VehicleName = x.Vehicle_No // }).ToList(); objmodel.Vehicle_No = num.Vehicle_No; var Driver = (from x in db.Drivers where x.IsActive == true select new { DriverId = x.DriverId, DriverName = x.First_Name } ).ToList(); //ViewBag.Vehicle = new SelectList(vehicles, "VehicleId", "VehicleNo", num); ViewBag.Driver = new SelectList(Driver, "DriverId", "DriverName"); ViewBag.Co_Driver = new SelectList("", "", ""); } catch (Exception Ex) { string actionName = this.ControllerContext.RouteData.Values["action"].ToString(); string controllerName = this.ControllerContext.RouteData.Values["controller"].ToString(); ExceptionHandlingController.ExceptionDetails(Ex, actionName, controllerName); } return(View(objmodel)); }