public void CreateVehicle(DomainVehicle newVehicle)
{
var createdAt = DateTime.UtcNow;
var vehicle = new Vehicle()
{
VehicleId = newVehicle.VehicleId,
Name = newVehicle.Name,
Speed = newVehicle.Speed,
EngineTemperature = newVehicle.EngineTemperature,
RadiatorPressure = newVehicle.RadiatorPressure,
FuelRemaining = newVehicle.FuelRemaining,
CreatedTimestamp = createdAt,
UpdatedTimestamp = createdAt,
VehicleLocation = new VehicleLocation()
{
VehicleLocationId = Guid.NewGuid(),
Latitude = newVehicle.Latitude,
Longitude = newVehicle.Longitude
}
};
_dbContext.Vehicle.Add(vehicle);
_dbContext.SaveChanges();
}
public ActionResult Create([Bind(Include = "VehicleId,Model,Registraion,EngineCapacity," +
"Price,SteerTypeId,MileAges,GearTypeId,FuelTypeId,ColorOfVehicleId,VehicleTypeId")]
Vehicle vehicle, IEnumerable <HttpPostedFileBase> httpPostedFileBases)
{
IEnumerable <HttpPostedFileBase> httpPostedFile = httpPostedFileBases;
if (ModelState.IsValid)
{
db.Vehicles.Add(vehicle);
db.SaveChanges();
if (httpPostedFile != null)
{
foreach (var afile in httpPostedFile)
{
VehicleImage aVehicleImage = new VehicleImage();
Stream stream = afile.InputStream;
BinaryReader brd = new BinaryReader(stream);
byte[] bytes = brd.ReadBytes((int)stream.Length);
aVehicleImage.VehicleId = vehicle.VehicleId;
aVehicleImage.VehicleImages = bytes;
db.VehicleImages.Add(aVehicleImage);
db.SaveChanges();
}
}
return(RedirectToAction("Index"));
}
ViewBag.ColorOfVehicleId = new SelectList(db.ColorOfVehilces, "ColorOfVehicleId", "ColorOfVehicleName", vehicle.ColorOfVehicleId);
ViewBag.FuelTypeId = new SelectList(db.FuelTypes, "FuelTypeId", "FuelTypeName", vehicle.FuelTypeId);
ViewBag.GearTypeId = new SelectList(db.GearTypes, "GearTypeId", "GearTypeName", vehicle.GearTypeId);
ViewBag.SteerTypeId = new SelectList(db.SteerTypes, "SteerTypeId", "SteerTypeName", vehicle.SteerTypeId);
ViewBag.VehicleTypeId = new SelectList(db.TypesOfVehicles, "VehicleTypeId", "VehicleTypeName", vehicle.VehicleTypeId);
return(View(vehicle));
}
// Vehicle Management
public Vehicle AddVehicle(Vehicle v)
{
//Verify that the vehicle does not already exist and if it does return null
var exists = db.Vehicles.FirstOrDefault(r => r.RegNumber == v.RegNumber);
if (exists != null)
{
return(null);
}
var vehicle = new Vehicle
{
Make = v.Make,
Model = v.Model,
RegNumber = v.RegNumber,
DateOfRegistration = v.DateOfRegistration,
Transmission = v.Transmission,
Co2Rating = v.Co2Rating,
FuelType = v.FuelType,
BodyType = v.BodyType,
NoOfDoors = v.NoOfDoors,
EngineCC = v.EngineCC,
PhotoURL = v.PhotoURL,
};
//add vehicle to Database and save changes
db.Vehicles.Add(vehicle);
db.SaveChanges();
return(vehicle);
}
public ActionResult Create([Bind(Include = "Id,TypeName,Description")] VehicleType vehicleType)
{
if (ModelState.IsValid)
{
db.VehicleTypes.Add(vehicleType);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(vehicleType));
}
public ActionResult Create([Bind(Include = "GearTypeId,GearTypeName")] GearType geartype)
{
if (ModelState.IsValid)
{
db.GearTypes.Add(geartype);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(geartype));
}
public ActionResult Create([Bind(Include = "VehicleTypeId,VehicleTypeName")] TypeOfVehicle typeofvehicle)
{
if (ModelState.IsValid)
{
db.TypesOfVehicles.Add(typeofvehicle);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(typeofvehicle));
}
public ActionResult Create([Bind(Include = "ColorOfVehicleId,ColorOfVehicleName")] ColorOfVehilce colorofvehilce)
{
if (ModelState.IsValid)
{
db.ColorOfVehilces.Add(colorofvehilce);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(colorofvehilce));
}
public ActionResult Create([Bind(Include = "FuelTypeId,FuelTypeName")] FuelType fueltype)
{
if (ModelState.IsValid)
{
db.FuelTypes.Add(fueltype);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(fueltype));
}
public ActionResult Create([Bind(Include = "Id,Name")] Department department)
{
if (ModelState.IsValid)
{
db.Departments.Add(department);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(department));
}
public ActionResult Create([Bind(Include = "Id,Name,MobileNo,LicenceNo,NID,Address,IsDelete")] Driver driver)
{
if (ModelState.IsValid)
{
db.Drivers.Add(driver);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(driver));
}
public ActionResult Create([Bind(Include = "Id,VehicleTypeId,RegistrationNo,Description,IsDelete")] Vehicle vehicle)
{
if (ModelState.IsValid)
{
db.Vehicles.Add(vehicle);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.VehicleTypeId = new SelectList(db.VehicleTypes, "Id", "TypeName", vehicle.VehicleTypeId);
return(View(vehicle));
}
public ActionResult Create([Bind(Include = "VehicleImageId,VehicleImages,VehicleId")] VehicleImage vehicleimage)
{
if (ModelState.IsValid)
{
db.VehicleImages.Add(vehicleimage);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.VehicleId = new SelectList(db.Vehicles, "VehicleId", "Model", vehicleimage.VehicleId);
return(View(vehicleimage));
}
public bool AddCar(Car car)
{
try
{
_context.Cars.Add(car);
return(_context.SaveChanges() == 1);
}
catch (Exception exception)
{
return(false);
}
}
public ActionResult Create([Bind(Include = "Id,Designation,DepartmentId")] EmployeeDesignation employeeDesignation)
{
if (ModelState.IsValid)
{
db.EmployeeDesignations.Add(employeeDesignation);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.DepartmentId = new SelectList(db.Departments, "Id", "Name", employeeDesignation.DepartmentId);
return(View(employeeDesignation));
}
public ActionResult Create([Bind(Include = "Id,Name,EmployeeDesignationId,DepartmentId,ContactNo,Email,Address,IsDelete")] Employee employee)
{
if (ModelState.IsValid)
{
db.Employees.Add(employee);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.DepartmentId = new SelectList(db.Departments, "Id", "Name", employee.DepartmentId);
ViewBag.EmployeeDesignationId = new SelectList(db.EmployeeDesignations, "Id", "Designation", employee.EmployeeDesignationId);
return(View(employee));
}
public ActionResult Create([Bind(Include = "Id,DriverId,VehicleId")] DriverVehicle driverVehicle)
{
if (ModelState.IsValid)
{
db.DriverVehicles.Add(driverVehicle);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.DriverId = new SelectList(db.Drivers, "Id", "Name", driverVehicle.DriverId);
ViewBag.VehicleId = new SelectList(db.Vehicles, "Id", "RegistrationNo", driverVehicle.VehicleId);
return(View(driverVehicle));
}
public static void Seed(VehicleDbContext context)
{
if (!context.Vehicles.Any())
{
context.AddRange
(
new Vehicle {
VehicleId = "YS2R4X20005399401", RegistrationNo = "ABC123", CustomerID = 1, CustomerName = "Kalles Grustransporter AB", LastPingTime = DateTime.Now
},
new Vehicle {
VehicleId = "VLUR4X20009093588", RegistrationNo = "DEF456", CustomerID = 1, CustomerName = "Kalles Grustransporter AB", LastPingTime = DateTime.Now
},
new Vehicle {
VehicleId = "VLUR4X20009048066", RegistrationNo = "GHI789", CustomerID = 1, CustomerName = "Kalles Grustransporter AB", LastPingTime = DateTime.Now
},
new Vehicle {
VehicleId = "YS2R4X20005388011", RegistrationNo = "JKL012", CustomerID = 2, CustomerName = "johans-bulk-ab", LastPingTime = DateTime.Now
},
new Vehicle {
VehicleId = "YS2R4X20005387949", RegistrationNo = "MNO345", CustomerID = 2, CustomerName = "johans-bulk-ab", LastPingTime = DateTime.Now
},
new Vehicle {
VehicleId = "VLUR4X20009048066", RegistrationNo = "PQR678", CustomerID = 3, CustomerName = "haralds-värdetransporter-ab", LastPingTime = DateTime.Now
},
new Vehicle {
VehicleId = "YS2R4X20005387055", RegistrationNo = "STU901", CustomerID = 3, CustomerName = "haralds-värdetransporter-ab", LastPingTime = DateTime.Now
}
);
var output = context.SaveChanges();
var output1 = output;
}
}
private void SeedData()
{
_vehicleDbContext.RemoveRange(_vehicleDbContext.Cars);
_vehicleDbContext.AddRange(
new Car
{
Make = "nissan",
Model = "x-trail",
Engine = "2-cylinder",
Doors = 4,
Wheels = 4,
VehicleType = VehicleType.Car,
BodyType = BodyType.SUV
},
new Car
{
Make = "nissan",
Model = "x-trail Ti",
Engine = "4-cylinder",
Doors = 4,
Wheels = 4,
VehicleType = VehicleType.Car,
BodyType = BodyType.SUV
}
);
_vehicleDbContext.SaveChanges();
}
/* Vehicle Management */
public Vehicle AddVehicle(Vehicle v)
{
/* Verify Same Vehicle does not exist (using RegNum as a unique
* Attribute) */
var Previous = db.Vehicles.FirstOrDefault
(p => p.RegNumber == v.RegNumber);
if (Previous != null)
{
return(null);
}
// If not add Vehicle
db.Vehicles.Add(v);
db.SaveChanges();
// Return added vehicle
return(v);
} // AddVehicle
public ActionResult AddVal([Bind(Include = "lat,lon")] Locationinfo location)
{
if (ModelState.IsValid)
{
var _username = Session["UserName"];
var get_user = db.Login.FirstOrDefault(p => p.Username == _username.ToString());
location.ID = get_user.ID;
db.location.Add(location);
db.SaveChanges();
return(View(location));
}
return(View());
}
public void DeleteMake(int id)
{
VehicleMake make = context.VehicleMakers.Find(id);
if (make != null)
{
context.Remove(make);
context.SaveChanges();
}
}
public CarRepository(VehicleDbContext context) : base(context)
{
_context = context;
if (EnumerableExtensions.Any(_context.Cars))
{
return;
}
_context.Cars.AddRangeAsync(new List <Car>
{
new Car
{
BodyType = "5-door SUV",
EngineType = "2.0 L B20Z",
Make = "Honda",
Model = "CRV",
NumberOfDoors = 4,
NumberOfWheels = 4,
Year = 2018
}
});
_context.SaveChanges();
}
public Service AddService(Service s)
{ // create service record linked to a vehicle and
//add it to database
var newService = new Service
{
VehicleId = s.VehicleId,
MechanicName = s.MechanicName,
VehicleMileage = s.VehicleMileage,
ServiceCost = s.ServiceCost,
ServiceDate = s.ServiceDate,
RepairSummary = s.RepairSummary
};
vtx.ServiceRecords.Add(newService);
vtx.SaveChanges();
return(newService);
}
public bool Add(Requisition requisition)
{
db.Requisitions.Add(requisition);
return(db.SaveChanges() > 0);
}
public virtual void Commit()
{
_vehicleDbContext.SaveChanges();
}
private void InitializeMockDbSet(IEnumerable <Car> mockCars)
{
VehicleDbContext.Cars.RemoveRange(VehicleDbContext.Cars);
VehicleDbContext.Cars.AddRange(mockCars);
VehicleDbContext.SaveChanges();
}
public int SaveChanges()
{
return(_db.SaveChanges());
}
public void Commit()
{
_context.SaveChanges();
}
public void AddContact(Contact contact)
{
if (_ctx.Contacts.Count() == 0)
{
contact.ContactId = 1;
}
else
{
var maxID = _ctx.Contacts.Max(c => c.ContactId);
contact.ContactId = maxID + 1;
}
_ctx.Contacts.Add(contact);
_ctx.SaveChanges();
}
public void IdentityTest()
{
using (VehicleDbContext context = new VehicleDbContext())
{
if (context.Database.Exists()) context.Database.Delete();
context.Database.CreateIfNotExists();
// Identity as Guid
Manufacturer nissan = new Manufacturer
{
Name = "Nissan"
};
Manufacturer ford = new Manufacturer
{
Name = "Ford"
};
context.Manufacturers.Add(nissan);
context.Manufacturers.Add(ford);
// Identity as Integer
Distributor dis1 = new Distributor
{
Name = "Distributor1"
};
Distributor dis2 = new Distributor
{
Name = "Distributor2"
};
context.Distributors.Add(dis1);
context.Distributors.Add(dis2);
context.SaveChanges();
using (MySqlConnection conn = new MySqlConnection(context.Database.Connection.ConnectionString))
{
conn.Open();
// Validates Guid
MySqlCommand cmd = new MySqlCommand("SELECT * FROM Manufacturers", conn);
MySqlDataReader dr = cmd.ExecuteReader();
if (!dr.HasRows)
Assert.Fail("No records found");
while (dr.Read())
{
string name = dr.GetString(1);
switch (name)
{
case "Nissan":
Assert.AreEqual(dr.GetGuid(0), nissan.ManufacturerId);
Assert.AreEqual(dr.GetGuid(2), nissan.GroupIdentifier);
break;
case "Ford":
Assert.AreEqual(dr.GetGuid(0), ford.ManufacturerId);
Assert.AreEqual(dr.GetGuid(2), ford.GroupIdentifier);
break;
default:
Assert.Fail();
break;
}
}
dr.Close();
// Validates Integer
cmd = new MySqlCommand("SELECT * FROM Distributors", conn);
dr = cmd.ExecuteReader();
if (!dr.HasRows)
Assert.Fail("No records found");
while (dr.Read())
{
string name = dr.GetString(1);
switch (name)
{
case "Distributor1":
Assert.AreEqual(dr.GetInt32(0), dis1.DistributorId);
break;
case "Distributor2":
Assert.AreEqual(dr.GetInt32(0), dis2.DistributorId);
break;
default:
Assert.Fail();
break;
}
}
dr.Close();
}
}
}
public void Bug63920_Test1()
{
ReInitDb();
using (VehicleDbContext context = new VehicleDbContext())
{
context.Database.Delete();
context.Database.Initialize(true);
context.Vehicles.Add(new Car { Id = 1, Name = "Mustang", Year = 2012, CarProperty = "Car" });
context.Vehicles.Add(new Bike { Id = 101, Name = "Mountain", Year = 2011, BikeProperty = "Bike" });
context.SaveChanges();
var list = context.Vehicles.ToList();
int records = -1;
using (MySqlConnection conn = new MySqlConnection(context.Database.Connection.ConnectionString))
{
conn.Open();
MySqlCommand cmd = new MySqlCommand("SELECT COUNT(*) FROM Vehicles", conn);
records = Convert.ToInt32(cmd.ExecuteScalar());
}
Assert.AreEqual(context.Vehicles.Count(), records);
}
}
public Vehicle Create(Vehicle vehicle)
{
_context.Vehicle.Add(vehicle);
_context.SaveChanges();
return(vehicle);
}