public void CanUpdateVehicle()
        {
            Vehicle vehicleToAdd = new Vehicle();
            var     repo         = new VehicleRepositoryADO();

            vehicleToAdd.VIN                = "9870987fhej320nf";
            vehicleToAdd.ModelID            = 1;
            vehicleToAdd.ConditionID        = 1;
            vehicleToAdd.VehicleTypeID      = 1;
            vehicleToAdd.Year               = "2018";
            vehicleToAdd.TransmissionTypeID = 1;
            vehicleToAdd.CarColor           = 1;
            vehicleToAdd.Interior           = 1;
            vehicleToAdd.Mileage            = "567";
            vehicleToAdd.MSRP               = 28000M;
            vehicleToAdd.SalesPrice         = 26500M;
            vehicleToAdd.Description        = "Its a green car!";
            vehicleToAdd.Picture            = "placeholder.png";
            vehicleToAdd.Featured           = true;

            repo.Insert(vehicleToAdd);

            vehicleToAdd.VIN                = "9870987fhej320nf";
            vehicleToAdd.ModelID            = 1;
            vehicleToAdd.ConditionID        = 1;
            vehicleToAdd.VehicleTypeID      = 1;
            vehicleToAdd.Year               = "2018";
            vehicleToAdd.TransmissionTypeID = 1;
            vehicleToAdd.CarColor           = 3;
            vehicleToAdd.Interior           = 4;
            vehicleToAdd.Mileage            = "567";
            vehicleToAdd.MSRP               = 31000M;
            vehicleToAdd.SalesPrice         = 26500M;
            vehicleToAdd.Description        = "Beautiful vehicle!";
            vehicleToAdd.Picture            = "placeholder.png";
            vehicleToAdd.Featured           = true;

            repo.Update(vehicleToAdd);

            var updatedVehicle = repo.GetById(9);

            Assert.AreEqual(3, updatedVehicle.CarColor);
            Assert.AreEqual(4, updatedVehicle.Interior);
            Assert.AreEqual(31000M, updatedVehicle.MSRP);
            Assert.AreEqual("Beautiful vehicle!", updatedVehicle.Description);
        }
Beispiel #2
0
        public static void CanUpdateVehicle()
        {
            VehicleRepositoryADO repo = new VehicleRepositoryADO();

            Vehicle vehicle = new Vehicle()
            {
                VehicleId    = 1,
                Vin          = "0000000000",
                Color        = "Blue",
                Style        = "Car",
                Description  = "Notes and stuff",
                Interior     = "Black",
                MakeId       = 1,
                ModelId      = 1,
                Mileage      = 500,
                MSRP         = 15000M,
                SalePrice    = 12000M,
                Sold         = false,
                Transmission = "Auto",
                Type         = "New",
                Year         = 2015
            };

            var editedvehicle = repo.Update(vehicle);
            var resultInt     = editedvehicle.VehicleId;
            var resultVehicle = repo.GetById(resultInt);

            Assert.AreEqual(resultVehicle.VehicleId, 1);
            Assert.AreEqual(vehicle.Vin, resultVehicle.Vin);
            Assert.AreEqual(vehicle.Color, resultVehicle.Color);
            Assert.AreEqual(vehicle.Style, resultVehicle.Style);
            Assert.AreEqual(vehicle.Description, resultVehicle.Description);
            Assert.AreEqual(vehicle.Interior, resultVehicle.Interior);
            Assert.AreEqual("Subaru", resultVehicle.Make);
            Assert.AreEqual("Impreza", resultVehicle.Model);
            Assert.AreEqual(vehicle.MSRP, resultVehicle.MSRP);
            Assert.AreEqual(vehicle.Mileage, resultVehicle.Mileage);
            Assert.AreEqual(vehicle.SalePrice, resultVehicle.SalePrice);
            Assert.AreEqual(vehicle.Sold, resultVehicle.Sold);
            Assert.AreEqual(vehicle.Transmission, resultVehicle.Transmission);
            Assert.AreEqual(vehicle.Type, resultVehicle.Type);
            Assert.AreEqual(vehicle.Year, resultVehicle.Year);
        }
Beispiel #3
0
        public void CanUpdateVehicle()
        {
            Vehicle vehicleToAdd = new Vehicle();
            var     repo         = new VehicleRepositoryADO();

            vehicleToAdd.VehicleYear        = 2016;
            vehicleToAdd.MakeID             = 3;
            vehicleToAdd.ModelID            = 1;
            vehicleToAdd.Price              = 24000;
            vehicleToAdd.Mileage            = 1000;
            vehicleToAdd.Vin                = "1GNDU23W27D181467";
            vehicleToAdd.MSRP               = 26000;
            vehicleToAdd.VehicleDescription = "Beauty";
            vehicleToAdd.VehicleType        = "New";
            vehicleToAdd.ImageFileName      = "placeholder.png";
            vehicleToAdd.BodyStyleID        = 1;
            vehicleToAdd.TransmissionID     = 2;
            vehicleToAdd.BodyColorID        = 3;
            vehicleToAdd.InteriorColorID    = 2;
            vehicleToAdd.SaleStatus         = true;
            vehicleToAdd.IsFeatured         = true;

            repo.Insert(vehicleToAdd);

            vehicleToAdd.VehicleDescription = "What a beauty!";
            vehicleToAdd.MSRP          = 28000;
            vehicleToAdd.ImageFileName = "placeholder2.png";
            vehicleToAdd.IsFeatured    = false;

            repo.Update(vehicleToAdd);

            var updatedVehicle = repo.GetbyId(9);

            Assert.AreEqual("What a beauty!", updatedVehicle.VehicleDescription);
            Assert.AreEqual("placeholder2.png", updatedVehicle.ImageFileName);
            Assert.AreEqual("New", updatedVehicle.VehicleType);
            Assert.AreEqual(9, updatedVehicle.VehicleID);
        }
Beispiel #4
0
        public void CanEditVehicle()
        {
            Vehicle vehicleToAdd = new Vehicle();
            var     repo         = new VehicleRepositoryADO();

            vehicleToAdd.Year        = 2018;
            vehicleToAdd.Mileage     = 0;
            vehicleToAdd.MSRP        = 50011;
            vehicleToAdd.SalesPrice  = 49875;
            vehicleToAdd.Description = "The meanest on the streets!";
            vehicleToAdd.Picture     = "placeholder.png";
            vehicleToAdd.Featured    = true;
            vehicleToAdd.VIN         = "KMHHT6KD1CU079023";
            //vehicleToAdd.MakeID = 2;
            vehicleToAdd.BodyID         = 5;
            vehicleToAdd.ModelID        = 3;
            vehicleToAdd.ColorID        = 2;
            vehicleToAdd.TypeID         = 1;
            vehicleToAdd.TransmissionID = 1;
            vehicleToAdd.InteriorID     = 3;
            vehicleToAdd.UserID         = "00000000-1111-1111-0000-000000000000";

            repo.Insert(vehicleToAdd);

            vehicleToAdd.Year        = 2010;
            vehicleToAdd.Mileage     = 30000;
            vehicleToAdd.MSRP        = 12654;
            vehicleToAdd.SalesPrice  = 11632;
            vehicleToAdd.Description = "Baddest on the streets!";
            vehicleToAdd.Picture     = "placeholder.png";
            vehicleToAdd.Featured    = false;
            vehicleToAdd.VIN         = "KMHHR6K21CU0A9023";
            //vehicleToAdd.MakeID = 2;
            vehicleToAdd.BodyID         = 3;
            vehicleToAdd.ModelID        = 2;
            vehicleToAdd.ColorID        = 1;
            vehicleToAdd.TypeID         = 2;
            vehicleToAdd.TransmissionID = 2;
            vehicleToAdd.InteriorID     = 1;
            vehicleToAdd.UserID         = "00000000-1111-1111-0000-000000000000";

            repo.Update(vehicleToAdd);

            var updatedVehicle = repo.GetByID(9);

            Assert.AreEqual(2010, vehicleToAdd.Year);
            Assert.AreEqual(30000, vehicleToAdd.Mileage);
            Assert.AreEqual(12654, vehicleToAdd.MSRP);
            Assert.AreEqual(11632, vehicleToAdd.SalesPrice);
            Assert.AreEqual("Baddest on the streets!", vehicleToAdd.Description);
            Assert.AreEqual("placeholder.png", vehicleToAdd.Picture);
            Assert.AreEqual(false, vehicleToAdd.Featured);
            Assert.AreEqual("KMHHR6K21CU0A9023", vehicleToAdd.VIN);
            Assert.AreEqual(3, vehicleToAdd.BodyID);
            Assert.AreEqual(2, vehicleToAdd.ModelID);
            Assert.AreEqual(1, vehicleToAdd.ColorID);
            Assert.AreEqual(2, vehicleToAdd.TypeID);
            Assert.AreEqual(2, vehicleToAdd.TransmissionID);
            Assert.AreEqual(1, vehicleToAdd.InteriorID);
            Assert.AreEqual("00000000-1111-1111-0000-000000000000", vehicleToAdd.UserID);
        }
Beispiel #5
0
        public ActionResult EditVehicle(EditVehicleViewModel model)
        {
            if (ModelState.IsValid)
            {
                var repo = new VehicleRepositoryADO();

                try
                {
                    var oldVehicleInfo = repo.GetByID(model.Vehicle.VehicleID);
                    if (model.PictureUpload != null && model.PictureUpload.ContentLength > 0)
                    {
                        var savePath = Server.MapPath("~/Images");

                        string fileName  = Path.GetFileNameWithoutExtension(model.PictureUpload.FileName);
                        string extension = Path.GetExtension(model.PictureUpload.FileName);

                        var filePath = Path.Combine(savePath, fileName + extension);

                        int counter = 1;
                        while (System.IO.File.Exists(filePath))
                        {
                            filePath = Path.Combine(savePath, fileName + counter.ToString() + extension);
                            counter++;
                        }

                        model.PictureUpload.SaveAs(filePath);
                        model.Vehicle.Picture = Path.GetFileName(filePath);

                        var oldPath = Path.Combine(savePath, fileName + counter.ToString() + extension);
                        if (System.IO.File.Exists(oldPath))
                        {
                            System.IO.File.Delete(oldPath);
                        }
                    }
                    else
                    {
                        model.Vehicle.Picture = oldVehicleInfo.Picture;
                    }

                    repo.Update(model.Vehicle);

                    return(RedirectToAction("EditVehicle", "Admin", new { id = model.Vehicle.VehicleID }));
                }
                catch (Exception ex)
                {
                    throw ex;
                }
            }
            else
            {
                var vehicleModel     = new AddVehicleViewModel();
                var makeRepo         = new MakeRepositoryADO();
                var modelRepo        = new ModelRepositoryADO();
                var typeRepo         = new TypeRepositoryADO();
                var bodystyleRepo    = new BodyStyleRepositoryADO();
                var transmissionRepo = new TransmissionRepositoryADO();
                var colorRepo        = new ColorRepositoryADO();
                var interiorRepo     = new InteriorRepositoryADO();

                vehicleModel.Makes         = new SelectList(makeRepo.GetAll(), "MakeID", "MakeName");
                vehicleModel.Models        = new SelectList(modelRepo.GetAll(), "ModelID", "ModelName");
                vehicleModel.Types         = new SelectList(modelRepo.GetAll(), "TypeID", "TypeName");
                vehicleModel.BodyStyles    = new SelectList(modelRepo.GetAll(), "BodyID", "BodyStyleName");
                vehicleModel.Transmissions = new SelectList(modelRepo.GetAll(), "TransmissionID", "TransmissionType");
                vehicleModel.Colors        = new SelectList(modelRepo.GetAll(), "ColorID", "ColorName");
                vehicleModel.Interiors     = new SelectList(modelRepo.GetAll(), "InteriorID", "InteriorColor");

                return(View(vehicleModel));
            }
        }
Beispiel #6
0
        public void ADOCanUpdateVehicle()
        {
            var vehicle = new Vehicle();
            var repo    = new VehicleRepositoryADO();

            vehicle.ModelId         = 9;
            vehicle.BodyStyleId     = 4;
            vehicle.InteriorColorId = 2;
            vehicle.ExteriorColorId = 5;
            vehicle.SaleId          = null;
            vehicle.IsUsed          = true;
            vehicle.IsAutomatic     = false;
            vehicle.IsFeatured      = false;
            vehicle.UserId          = "00000000-0000-0000-0000-000000000000";
            vehicle.VIN             = "9012345678ABCDEFG";
            vehicle.Description     = "Added vehicle";
            vehicle.Image           = "added.jpg";
            vehicle.SalePrice       = 15000m;
            vehicle.MSRP            = 16000m;
            vehicle.Mileage         = 90000m;

            repo.Insert(vehicle);

            vehicle.ModelId         = 28;
            vehicle.BodyStyleId     = 1;
            vehicle.InteriorColorId = 1;
            vehicle.ExteriorColorId = 4;
            vehicle.SaleId          = null;
            vehicle.IsUsed          = false;
            vehicle.IsAutomatic     = true;
            vehicle.IsFeatured      = true;
            vehicle.UserId          = "11111111-1111-1111-1111-111111111111";
            vehicle.VIN             = "0123456789ABCDEFG";
            vehicle.Description     = "Updated vehicle";
            vehicle.Image           = "updated.jpg";
            vehicle.SalePrice       = 38000m;
            vehicle.MSRP            = 40000m;
            vehicle.Mileage         = 800m;

            repo.Update(vehicle);

            var updatedVehicle = repo.GetDetailById(3);

            Assert.AreEqual("Tesla", updatedVehicle.Make);
            Assert.AreEqual("3", updatedVehicle.Model);
            Assert.AreEqual("Car", updatedVehicle.BodyStyle);
            Assert.AreEqual("Black", updatedVehicle.InteriorColor);
            Assert.AreEqual("Gray", updatedVehicle.ExteriorColor);
            Assert.AreEqual("11111111-1111-1111-1111-111111111111", updatedVehicle.UserId);
            Assert.AreEqual("0123456789ABCDEFG", updatedVehicle.VIN);
            Assert.AreEqual("Updated vehicle", updatedVehicle.Description);
            Assert.AreEqual("updated.jpg", updatedVehicle.Image);
            Assert.AreEqual(null, updatedVehicle.SaleId);
            Assert.AreEqual(false, updatedVehicle.IsUsed);
            Assert.AreEqual(true, updatedVehicle.IsAutomatic);
            Assert.AreEqual(true, updatedVehicle.IsFeatured);
            Assert.AreEqual(2018, updatedVehicle.Year);
            Assert.AreEqual(38000m, updatedVehicle.SalePrice);
            Assert.AreEqual(40000m, updatedVehicle.MSRP);
            Assert.AreEqual(800m, updatedVehicle.Mileage);
        }