public ActionResult Create([Bind(Include = "Id,TypeName")] VehicleType vehicleType)
{
if (ModelState.IsValid)
{
db.VehicleTypes.Add(vehicleType);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(vehicleType));
}
public ActionResult Create([Bind(Include = "ID,VinNumber,ImageURL,Year,Make,Model,Mileage")] Automobile automobile)
{
if (ModelState.IsValid)
{
db.Automobiles.Add(automobile);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(automobile));
}
public ActionResult Create([Bind(Include = "Id,FirstName,LastName,PhoneNo,Mail")] Member member)
{
if (ModelState.IsValid)
{
db.Members.Add(member);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(member));
}
public ActionResult Create([Bind(Include = "Id,RegistrationNumber,Brand,Model,Color,Wheels,WhenParked,MemberId,VehicleTypeId")] Vehicle vehicle)
{
if (ModelState.IsValid)
{
db.Vehicles.Add(vehicle);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.MemberId = new SelectList(db.Members, "Id", "FirstName", vehicle.MemberId);
ViewBag.VehicleTypeId = new SelectList(db.VehicleTypes, "Id", "TypeName", vehicle.VehicleTypeId);
return(View(vehicle));
}
public static bool AddUser(User user)
{
try
{
db.Users.Add(user);
db.SaveChanges();
return(true);
}
catch
{
return(false);
}
}
public void InsertIntoVehicleRecordProperties(VehiclesModel vehicles, decimal id)
{
if (!string.IsNullOrEmpty(vehicles.Engine))
{
var recordProperty = new VehicleRecordsProperties()
{
VrId = id,
VpmId = 2,
Value = vehicles.Engine
};
_modelContext.VehicleRecordsProperties.Add(recordProperty);
_modelContext.SaveChanges();
}
if (!string.IsNullOrEmpty(vehicles.Doors))
{
var recordProperty = new VehicleRecordsProperties()
{
VrId = id,
VpmId = 3,
Value = vehicles.Doors
};
_modelContext.VehicleRecordsProperties.Add(recordProperty);
_modelContext.SaveChanges();
}
if (!string.IsNullOrEmpty(vehicles.Wheels))
{
var recordProperty = new VehicleRecordsProperties()
{
VrId = id,
VpmId = 4,
Value = vehicles.Wheels
};
_modelContext.VehicleRecordsProperties.Add(recordProperty);
_modelContext.SaveChanges();
}
if (!string.IsNullOrEmpty(vehicles.BodyType))
{
var recordProperty = new VehicleRecordsProperties()
{
VrId = id,
VpmId = 5,
Value = vehicles.BodyType
};
_modelContext.VehicleRecordsProperties.Add(recordProperty);
_modelContext.SaveChanges();
}
if (!string.IsNullOrEmpty(vehicles.Colour))
{
var recordProperty = new VehicleRecordsProperties()
{
VrId = id,
VpmId = 6,
Value = vehicles.Colour
};
_modelContext.VehicleRecordsProperties.Add(recordProperty);
_modelContext.SaveChanges();
}
}
static void Main(string[] args)
{
VehiclesContext context = new VehiclesContext();
context.Database.Initialize(true);
context.SaveChanges();
}
public ModelsFixture()
{
options = new DbContextOptionsBuilder <VehiclesContext>()
.UseInMemoryDatabase(databaseName: "ModelsDataBase")
.Options;
using var vehicleContext = new VehiclesContext(options);
vehicleContext.Models.Add(new Model
{
ModelId = 1,
MakeId = 1,
Name = "X-Trail"
});
vehicleContext.Models.Add(new Model
{
ModelId = 2,
MakeId = 1,
Name = "Pathfinder"
});
vehicleContext.Models.Add(new Model
{
ModelId = 3,
MakeId = 2,
Name = "Cherokee"
});
vehicleContext.SaveChanges();
}
public IActionResult Delete(int id)
{
var vehicle = context.Vehicles.Find(id);
context.Vehicles.Remove(vehicle);
context.SaveChanges();
return(RedirectToAction("Vehicles"));
}
public ActionResult Create([Bind(Include = "Id,RegistrationNumber,Brand,Model,Color,Wheels,WhenParked,MemberId,VehicleTypeId")] Vehicle vehicle)
//public ActionResult Create([Bind(Include = "Id,RegistrationNumber,VehicleType,Brand,Model,Color,Wheels,WhenParked")] Vehicle vehicle)
{
ViewBag.VehicleAdded = "";
int numberOfVehicles = db.Vehicles.Count();
numberVehicleMessage();
if (ModelState.IsValid && (MaxNumberVehicles > numberOfVehicles && UniqRegistrationNumber(vehicle.RegistrationNumber)))
{
ViewBag.VehicleAdded = " The Vehicle is Parked";
vehicle.WhenParked = DateTime.Now;
db.Vehicles.Add(vehicle);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.MemberId = new SelectList(db.Members, "Id", "FirstName", vehicle.MemberId);
ViewBag.VehicleTypeId = new SelectList(db.VehicleTypes, "Id", "TypeName", vehicle.VehicleTypeId);
return(View(vehicle));
}
public IActionResult Create(VehiclesModel vehicles, IFormCollection formCollection)
{
IActionResult returnpath = View(vehicles);
VehicleMakemodelMapping mapping = new VehicleMakemodelMapping();
//var _modelContext = new VehiclesContext();
try
{
Validation(vehicles);
decimal VmakeId = Convert.ToDecimal(HttpContext.Request.Form["VmakeId"]);
decimal VmodelId = Convert.ToDecimal(HttpContext.Request.Form["VmodelId"]);
mapping = _vehicleService.GetMakeModelIDList(mapping, VmakeId, VmodelId);
if (ModelState.IsValid)
{
if (mapping != null)
{
var record = new VehicleRecords()
{
VmmpId = mapping.VmmpId
};
_modelContext.VehicleRecords.Add(record);
_modelContext.SaveChanges();
decimal id = record.VrId;
if (id != 0)
{
_vehicleService.InsertIntoVehicleRecordProperties(vehicles, id);
}
}
returnpath = RedirectToAction("Index");
}
else
{
ViewBag.ListOfVehicles = _vehicleService.LoadVehicleTypeList();
returnpath = View(vehicles);
}
}
catch (Exception ex)
{
_logger.LogError(" Exception on creating new record: " + ex);
}
return(returnpath);
}
public static void InitializeDbForTests(VehiclesContext db)
{
var car1Id = Guid.Parse("e7341f86-28bd-49bc-9509-e23752cfa450");
var car2Id = Guid.Parse("b27f84a0-6ddb-44e6-8f31-123eca58ecbe");
var car3Id = Guid.Parse("fdaac995-ea18-41ff-8f16-a200d6ec7a40");
var cars = new List <Car>()
{
new Car
{
Id = car1Id,
Type = VehicleType.Car,
Make = "Toyota",
Model = "Yaris",
NumberOfWheels = 4,
NumberOfDoors = 5,
Engine = "V4",
BodyType = CarBodyType.Sedan
},
new Car
{
Id = car2Id,
Type = VehicleType.Car,
Make = "Toyota",
Model = "RAV4",
NumberOfWheels = 4,
NumberOfDoors = 5,
Engine = "V6",
BodyType = CarBodyType.Hatchback
},
new Car
{
Id = car3Id,
Type = VehicleType.Truck,
Make = "Ford",
Model = "Ranger",
NumberOfWheels = 4,
NumberOfDoors = 4,
Engine = "V8",
BodyType = CarBodyType.Sedan
}
};
db.Cars.AddRange(cars);
db.SaveChanges();
}
public CarsFixture()
{
options = new DbContextOptionsBuilder <VehiclesContext>()
.UseInMemoryDatabase(databaseName: "CarsDataBase")
.Options;
using var vehicleContext = new VehiclesContext(options);
for (int i = 0; i < 12; i += 2)
{
vehicleContext.Cars.Add(new Car
{
CarId = i + 1,
MakeId = 1,
Engine = "v6",
Doors = 4,
Wheels = 4,
BodyTypeId = 1,
ModelId = 1,
AddDate = DateTime.Today,
IsSold = false,
VehicleTypeId = 1
});
vehicleContext.Cars.Add(new Car
{
CarId = i + 2,
MakeId = 1,
Engine = "v4",
Doors = 4,
Wheels = 4,
BodyTypeId = 2,
ModelId = 3,
AddDate = DateTime.Today,
IsSold = false,
VehicleTypeId = 1
});
}
vehicleContext.SaveChanges();
}
public BodyTypesFixture()
{
options = new DbContextOptionsBuilder <VehiclesContext>()
.UseInMemoryDatabase(databaseName: "BodyTypesDataBase")
.Options;
using var vehicleContext = new VehiclesContext(options);
vehicleContext.BodyTypes.Add(new BodyType
{
BodyTypeId = 1,
Name = "Wagon"
});
vehicleContext.BodyTypes.Add(new BodyType
{
BodyTypeId = 2,
Name = "SUV"
});
vehicleContext.SaveChanges();
}
public MakesFixture()
{
options = new DbContextOptionsBuilder <VehiclesContext>()
.UseInMemoryDatabase(databaseName: "MakesDataBase")
.Options;
using var vehicleContext = new VehiclesContext(options);
vehicleContext.Makes.Add(new Make
{
MakeId = 1,
Name = "Nissan"
});
vehicleContext.Makes.Add(new Make
{
MakeId = 2,
Name = "Jeep"
});
vehicleContext.SaveChanges();
}
public VehicleTypesFixture()
{
options = new DbContextOptionsBuilder <VehiclesContext>()
.UseInMemoryDatabase(databaseName: "VehicleTypesDataBase")
.Options;
using var vehicleContext = new VehiclesContext(options);
vehicleContext.VehicleTypes.Add(new VehicleType
{
VehicleTypeId = 1,
Name = "Car"
});
vehicleContext.VehicleTypes.Add(new VehicleType
{
VehicleTypeId = 2,
Name = "Boat"
});
vehicleContext.SaveChanges();
}
public async Task <IActionResult> Dashboard(CarGarage cg)
{
_context.CarGarage.Add(cg);
_context.SaveChanges();
return(RedirectToAction());
}
