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