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));
}
