/// <summary> /// Gets data from Data Base. /// </summary> /// <param name="mode">True to get all data related to cars.</param> public void GetData(bool getAll) { if (getAll) { using (CarContext ccx = new CarContext()) { Cars = new ObservableCollection <Car>(ccx.Cars .Include("Brand") .Include("Propellant") .ToList() as List <Car>); Brands = new ObservableCollection <Brand>(ccx.Brands.ToList() as List <Brand>); Propellants = new ObservableCollection <Propellant>(ccx.Propellants.ToList() as List <Propellant>); } } else { using (CarContext ccx = new CarContext()) { Cars = new ObservableCollection <Car>(ccx.Cars .Include("Brand") .Include("Propellant") .ToList() as List <Car>); } } }
private static async Task FillOwnershipsAsync(CarContext context) { var persons = await context.Persons.ToArrayAsync(); var carModels = await context.CarModels.ToArrayAsync(); var ownershipsdata = await File.ReadAllTextAsync("TestData/Ownerships.json"); var ownerships = JsonSerializer.Deserialize <IEnumerable <Ownership> >(ownershipsdata).ToArray(); var rand = new Random(); for (var i = 0; i < ownerships.Count(); i++) { Ownership dbOwnership = new Ownership { PersonID = persons.Skip(i).First().PersonID, CarModelID = carModels[rand.Next(carModels.Length)].CarModelID, VehicleIdentificationNumber = ownerships.Skip(i).First().VehicleIdentificationNumber }; context.Ownerships.Add(dbOwnership); } await context.SaveChangesAsync(); }
public async Task <List <VehicleMakeD> > GetAllAsync(CancellationToken cancellationToken = default(CancellationToken)) { using (var context = new CarContext()) { return(await context.Cars.ToListAsync(cancellationToken)); } }
private static void ImportEntities(CarContext context, string baseDir = @"Data\") { var suppliersPath = $"{baseDir}suppliers.json"; var supplierString = File.ReadAllText(suppliersPath); Console.WriteLine(DataProcessor.Deserializer.ImportSuppliers(context, supplierString)); var partsPath = $"{baseDir}parts.json"; var partString = File.ReadAllText(partsPath); Console.WriteLine(DataProcessor.Deserializer.ImportParts(context, partString)); var carsPath = $"{baseDir}cars.json"; var carString = File.ReadAllText(carsPath); Console.WriteLine(DataProcessor.Deserializer.ImportCars(context, carString)); var customersPath = $"{baseDir}customers.json"; var customerString = File.ReadAllText(customersPath); Console.WriteLine(DataProcessor.Deserializer.ImportCustomers(context, customerString)); DataProcessor.Deserializer.ImportCarParts(context); DataProcessor.Deserializer.ImportSales(context); }
// This method gets called by the runtime. Use this method to configure the HTTP request pipeline. public void Configure(IApplicationBuilder app, IHostingEnvironment env, CarContext shoppingCartContext) { if (env.IsDevelopment()) { app.UseDeveloperExceptionPage(); } else { app.UseExceptionHandler(appBuilder => { appBuilder.Run(async context => { context.Response.StatusCode = 500; await context.Response.WriteAsync("An unexpected fault happened. Try again later."); }); }); } shoppingCartContext.EnsureSeedDataForContext(); #pragma warning disable CS0618 // Type or member is obsolete AutoMapper.Mapper.Initialize(cfg => { cfg.CreateMap <Car, CarDto>(); cfg.CreateMap <CarForCreationDto, Car>(); cfg.CreateMap <CarForUpdateDto, Car>(); cfg.CreateMap <Car, CarForUpdateDto>(); }); app.UseCors("MyPolicy"); #pragma warning restore CS0618 // Type or member is obsolete app.UseMvc(); }
public IHttpActionResult Get() { using (var context = new CarContext()) { return(this.Ok(context.Cars.Select(car => car.Model).ToList())); } }
private static async Task PrintStatistics(CarContext context) { var carModels = await context.CarModels.Include(cm => cm.CarMake).ToArrayAsync(); foreach (var model in carModels) { var ownershipsPerModel = context.Ownerships.Where(o => o.CarModel.Model == model.Model).Count(); Console.WriteLine("For " + model.CarMake.Make + " " + model.Model + " " + ownershipsPerModel + " ownerships where created"); } var modelsWithoutOwn = context.CarModels.Include(cm => cm.Ownerships).Where(cm => cm.Ownerships.Count == 0); if (modelsWithoutOwn.Count() == 0) { Console.WriteLine("\nFor every model a ownership was created"); } else { Console.WriteLine("\nFor the following models no ownerships were created: "); foreach (var model in modelsWithoutOwn) { Console.WriteLine(model.Model); } } }
private static async Task <IEnumerable <Ownership> > QueryOwnershipsModels(CarContext context) { return(await context.Ownerships .Include(i => i.CarModel) .Include(i => i.Person) .ToArrayAsync()); }
public CarManagerTests() { DbContextOptionsBuilder <CarContext> options = new DbContextOptionsBuilder <CarContext>(); options.UseSqlServer(Secrets.ConnectionString); _context = new CarContext(options.Options); }
private void OnTimedEvent(object sender, ElapsedEventArgs e) { if (ApplicationState.GetValue <bool>("IsImpolite")) { return; } var context = new CarContext(); var userInfo = ApplicationState.GetValue <UserMetadata>("Metadata"); long badgeNum = userInfo.BadgeNumber; var user = context.Users.Where(u => u.USER_PIV_BADGE_NUM == badgeNum); if (user.Any()) { var curUser = user.First(); var apo = context.Pcos.Where(u => u.APO_PCO_PIV_BADGE_NUM == curUser.APO_PCO_PIV_BADGE_NUM); if (curUser.OUTSTANDING_ASSET.HasValue && curUser.OUTSTANDING_ASSET.Value) { if ((apo?.First().CAN_SEND_REMINDER ?? true) && curUser.LAST_REMINDER != null && curUser.LAST_REMINDER < DateTime.Now) { Current.Dispatcher.BeginInvoke((Action)OnMainThread); ApplicationState.SetValue("IsImpolite", true); } else { Current.Dispatcher.BeginInvoke((Action)OpenPoliteReminder); } } } }
public async void CanGetCars() { using (var context = new CarContext(ContextOptions)) { var controller = new CarsController(context); // get all cars var enumerableCars = await controller.GetCars(); List <Car> cars = enumerableCars.Value.ToList(); // test total number of cars Assert.Equal(2, cars.Count()); // test first car Assert.Equal("Nissan", cars[0].Make); Assert.Equal(VehicleType.CAR, cars[0].VehicleType); Assert.Equal("Juke 2020", cars[0].Model); Assert.Equal("1.0-litre, three-cylinder turbo-petrol engine", cars[0].Engine); Assert.Equal("SUV", cars[0].BodyType); Assert.Equal(5, cars[0].Doors); Assert.Equal(4, cars[0].Wheels); // test second car Assert.Equal("Suzuki", cars[1].Make); Assert.Equal(VehicleType.CAR, (VehicleType)cars[1].VehicleType); Assert.Equal("Vitara Turbo 2020", cars[1].Model); Assert.Equal("86kW/156Nm naturally-aspirated 1.6-litre petrol engine", cars[1].Engine); Assert.Equal("SUV", cars[1].BodyType); Assert.Equal(5, cars[1].Doors); Assert.Equal(4, cars[1].Wheels); } }
public static string ImportCustomers(CarContext context, string jsonString) { var sb = new StringBuilder(); var deserialisedCustomers = JsonConvert.DeserializeObject <CustomerDto[]>(jsonString); var validCustomers = new List <Customer>(); foreach (var obj in deserialisedCustomers) { if (!IsValid(obj)) { sb.AppendLine(FailureMessage); continue; } DateTime birthDate = DateTime.Parse(obj.BirthDate); var customer = new Customer { Name = obj.Name, BirthDate = birthDate, IsYoungDriver = obj.IsYoungDriver }; validCustomers.Add(customer); sb.AppendLine(String.Format(SuccessMessage, "customer", obj.Name)); } context.AddRange(validCustomers); context.SaveChanges(); return(sb.ToString()); }
public static string ExportFerrari(CarContext context) { var cars = context.Cars.Where(p => p.Make == "Ferrari") .Select(p => new FerrariDto { Id = p.Id, Model = p.Model, TravelledDistance = p.TravelledDistance }) .OrderBy(p => p.Model) .ThenByDescending(p => p.TravelledDistance) .ToArray(); var serializer = new XmlSerializer(typeof(FerrariDto[]), new XmlRootAttribute("Cars")); var sb = new StringBuilder(); serializer.Serialize(new StringWriter(sb), cars, new XmlSerializerNamespaces(new[] { XmlQualifiedName.Empty })); var result = sb.ToString(); return(result); }
public static string ExportCarParts(CarContext context) { var carsParts = context.Cars.Select(p => new CarPartDto { Make = p.Make, Model = p.Model, TravelledDistance = p.TravelledDistance, Parts = p.Parts.Select(k => new PartDto { Name = k.Part.Name, Price = k.Part.Price }).ToArray() }) .ToArray(); var serializer = new XmlSerializer(typeof(CarPartDto[]), new XmlRootAttribute("cars")); var sb = new StringBuilder(); serializer.Serialize(new StringWriter(sb), carsParts, new XmlSerializerNamespaces(new[] { XmlQualifiedName.Empty })); var result = sb.ToString(); return(result); }
public static string ExportCustomersWithSales(CarContext context) { var customers = context.Customers.Where(p => p.Sales.Count >= 1) .Select(p => new CustomerDto { FullName = p.Name, BoughtCars = p.Sales.Count(), SpentMoney = p.Sales.Select(l => l.Car.Parts.Sum(k => k.Part.Price)).Sum() }) .OrderByDescending(p => p.SpentMoney) .ThenByDescending(p => p.BoughtCars) .ToArray(); var serializer = new XmlSerializer(typeof(CustomerDto[]), new XmlRootAttribute("Customers")); var sb = new StringBuilder(); serializer.Serialize(new StringWriter(sb), customers, new XmlSerializerNamespaces(new[] { XmlQualifiedName.Empty })); var result = sb.ToString(); return(result); }
public static string ExportSales(CarContext context) { var sales = context.Sales.Where(p => p.Discount != null && p.Discount > 0) .Select(p => new SaleDto { Car = new CarPartDto { Make = p.Car.Make, Model = p.Car.Model, TravelledDistance = p.Car.TravelledDistance }, Name = p.Customer.Name, Discount = p.Discount, Price = p.Car.Parts.Select(k => k.Part.Price).Sum(), PriceWithDiscount = p.Car.Parts.Select(k => k.Part.Price).Sum() * (1 - p.Discount) }) .ToArray(); var serializer = new XmlSerializer(typeof(SaleDto[]), new XmlRootAttribute("Sales")); var sb = new StringBuilder(); serializer.Serialize(new StringWriter(sb), sales, new XmlSerializerNamespaces(new[] { XmlQualifiedName.Empty })); var result = sb.ToString(); return(result); }
public async void CanPostCar() { using (var context = new CarContext(ContextOptions)) { var controller = new CarsController(context); // new car var newCar = new Car(); newCar.Make = "Toyota"; newCar.Model = "Sonata Active"; newCar.Engine = "138kW/241Nm 2.4-litre four-cylinder engine"; newCar.BodyType = "Sedan"; newCar.Doors = 4; newCar.Wheels = 4; // update car await controller.PostCar(newCar); // get the newly added car var car = (await controller.GetCar(newCar.Id)).Value; // test updated car values Assert.Equal("Toyota", car.Make); Assert.Equal(VehicleType.CAR, car.VehicleType); Assert.Equal("Sonata Active", car.Model); Assert.Equal("138kW/241Nm 2.4-litre four-cylinder engine", car.Engine); Assert.Equal("Sedan", car.BodyType); Assert.Equal(4, car.Doors); Assert.Equal(4, car.Wheels); } }
public PurchaseRequestsController(CarContext context, IWebHostEnvironment appEnvironment, UserManager <User> userManager, RoleManager <IdentityRole> roleManager) { _context = context; _appEnvironment = appEnvironment; _userManager = userManager; _roleManager = roleManager; }
private static async Task <IEnumerable <CarModel> > QueryCarModels(CarContext context) { return(await context.CarModels .Include(cm => cm.CarMake) .Include(cm => cm.Ownerships) .ToArrayAsync()); }
public static string ImportSuppliers(CarContext context, string xmlString) { var sb = new StringBuilder(); var serializer = new XmlSerializer(typeof(SupplierDto[]), new XmlRootAttribute("suppliers")); var deserializedSuppliers = (SupplierDto[])serializer.Deserialize(new MemoryStream(Encoding.UTF8.GetBytes(xmlString))); var validSuppliers = new List <Supplier>(); foreach (var obj in deserializedSuppliers) { if (!IsValid(obj)) { sb.AppendLine(FailureMessage); continue; } var supplier = new Supplier { Name = obj.Name, IsImporter = obj.IsImporter }; validSuppliers.Add(supplier); sb.AppendLine(String.Format(SuccessCustomerMessage, obj.Name)); } context.AddRange(validSuppliers); context.SaveChanges(); return(sb.ToString().Trim()); }
private static async Task FillCarModelsAsync(CarContext context) { var carModeldata = await File.ReadAllTextAsync("TestData/CarModels.json"); var carModels = JsonSerializer.Deserialize <IEnumerable <CarModel> >(carModeldata); var carMakes = JsonSerializer.Deserialize <IEnumerable <CarMake> >(carModeldata).ToArray(); for (var i = 0; i < carModels.Count(); i++) { var make = context.CarMakes.FirstOrDefault(m => m.Make == carMakes.Skip(i).First().Make); if (make == null) { context.CarMakes.Add(carMakes.Skip(i).First()); await context.SaveChangesAsync(); make = await context.CarMakes.FirstOrDefaultAsync(m => m.Make == carMakes.Skip(i).First().Make); } carModels.Skip(i).First().CarMake = make; context.CarModels.Add(carModels.Skip(i).First()); } await context.SaveChangesAsync(); }
public async void CanPutCar() { using (var context = new CarContext(ContextOptions)) { var controller = new CarsController(context); // get car values var cars = (await controller.GetCars()).Value.ToList(); var car = (await controller.GetCar(cars[0].Id)).Value; // update car values car.Make = "Hyundai"; car.Model = "Sonata Active"; car.Engine = "138kW/241Nm 2.4-litre four-cylinder engine"; car.BodyType = "Sedan"; car.Doors = 4; car.Wheels = 4; // update car await controller.PutCar(car.Id, car); // get car values again cars = (await controller.GetCars()).Value.ToList(); car = (await controller.GetCar(cars[0].Id)).Value; // test updated car values Assert.Equal("Hyundai", car.Make); Assert.Equal(VehicleType.CAR, car.VehicleType); Assert.Equal("Sonata Active", car.Model); Assert.Equal("138kW/241Nm 2.4-litre four-cylinder engine", car.Engine); Assert.Equal("Sedan", car.BodyType); Assert.Equal(4, car.Doors); Assert.Equal(4, car.Wheels); } }
public ChangeCarInformation(employess e, string Number) { InitializeComponent(); List <string> CarLevelList = new List <string>(); CarLevelList.Add("Премиум"); CarLevelList.Add("Средний"); CarLevelList.Add("Эконом"); CarLevel.ItemsSource = CarLevelList; numberCar = Number; using (CarContext db = new CarContext()) { Car car = db.Cars.Where(c => c.CarNumber == numberCar).FirstOrDefault(); if (car != null) { CarModel.Text = car.CarName; CarNumber.Text = car.CarNumber; YearOfIssue.Text = car.YearOfIssue; CarLevel.SelectedValue = car.CarLevel; } } em = e; }
public static void Initialize(CarContext context) { context.Database.EnsureCreated(); if (!context.Cars.Any()) { context.Cars.Add(new Car() { Make = "Ford", Model = "Edge", Year = 2020, Color = "Red" }); context.Cars.Add(new Car() { Make = "Ford", Model = "Fusion", Year = 2020, Color = "White" }); context.Cars.Add(new Car() { Make = "Tesla", Model = "Model 3", Year = 2020, Color = "Black" }); context.Cars.Add(new Car() { Make = "Ram", Model = "2500", Year = 2020, Color = "Black" }); context.Cars.Add(new Car() { Make = "Tesla", Model = "Model X", Year = 2020, Color = "Grey" }); } context.SaveChanges(); }
public Car Get(Expression <Func <Car, bool> > filter) { using (CarContext context = new CarContext()) { return(context.Set <Car>().SingleOrDefault(filter)); } }
public static string ImportSuppliers(CarContext context, string jsonString) { var sb = new StringBuilder(); var deserialisedSuppliers = JsonConvert.DeserializeObject <SupplierDto[]>(jsonString); var validSuppliers = new List <Supplier>(); foreach (var obj in deserialisedSuppliers) { if (!IsValid(obj)) { sb.AppendLine(FailureMessage); continue; } var supplier = new Supplier { Name = obj.Name, IsImporter = obj.IsImporter }; validSuppliers.Add(supplier); sb.AppendLine(String.Format(SuccessMessage, "category", obj.Name)); } context.AddRange(validSuppliers); context.SaveChanges(); return(sb.ToString()); }
// GET: Car public ActionResult GetCars() { CarContext carContext = new CarContext(); List <Car> cars = carContext.Cars.ToList(); return(View(cars)); }
public static string ImportCars(CarContext context, string jsonString) { var sb = new StringBuilder(); var deserialisedCars = JsonConvert.DeserializeObject <CarDto[]>(jsonString); var validCars = new List <Car>(); foreach (var obj in deserialisedCars) { if (!IsValid(obj)) { sb.AppendLine(FailureMessage); continue; } var car = new Car { Make = obj.Make, Model = obj.Model, TravelledDistance = obj.TravelledDistance }; validCars.Add(car); sb.AppendLine(String.Format(SuccessMessage, obj.Make, obj.Model)); } context.Cars.AddRange(validCars); context.SaveChanges(); return(sb.ToString()); }
private void Seed() { using (var context = new CarContext(ContextOptions)) { context.Database.EnsureDeleted(); context.Database.EnsureCreated(); var firstCar = new Car(); firstCar.Make = "Nissan"; firstCar.Model = "Juke 2020"; firstCar.Engine = "1.0-litre, three-cylinder turbo-petrol engine"; firstCar.BodyType = "SUV"; firstCar.Doors = 5; firstCar.Wheels = 4; var secondCar = new Car(); secondCar.Make = "Suzuki"; secondCar.Model = "Vitara Turbo 2020"; secondCar.Engine = "86kW/156Nm naturally-aspirated 1.6-litre petrol engine"; secondCar.BodyType = "SUV"; secondCar.Doors = 5; secondCar.Wheels = 4; context.AddRange(firstCar, secondCar); context.SaveChanges(); } }
private async Task AddModificationAsync(ModificationsEdge edge) { await CarContext.FindOrCreateModificationCatalogAsync( edge.node.model.make.name, edge.node.model.name, edge.node.startProductionYear); }
public static void List() { Services.Providers.Message("Cars:"); using (var c = new CarContext()) { foreach (var car in c.Cars) Services.Providers.Message(null, "Key: {0}; Model: {1}", car.Key, car.Model); } Services.Providers.Message("Persons:"); using (var c = new PersonContext()) { foreach (var p in c.Persons) Services.Providers.Message(null, "Key: {0}; Name: {1}; City: {2}", p.Key, p.Name, p.City); } }
public Finder(CarContext Cars) { var _carsCount = Cars.Cars.Count(); if (!isInit) { CarBodys = Cars.Bodys.Select(c=>new BodyDTO {BodyID= c.BodyID, Name= c.Name }).ToList(); CarBodys.Add(new BodyDTO { BodyID = -1, Name = C_STR_ALL_RUS }); CarRudders = Cars.Rudders.Select(c => new RudderDTO { RudderID = c.RudderID, Name = c.Name }).ToList(); CarRudders.Add(new RudderDTO { RudderID = -1, Name = C_STR_ALL_RUS }); CarDrives = Cars.Drives.Select(c => new DriveDTO { DriveID = c.DriveID, Name = c.Name }).ToList(); CarDrives.Add(new DriveDTO { DriveID = -1, Name = C_STR_ALL_RUS }); CarTranssmisisons = Cars.Transmissions.Select(c => new TransmissionDTO { TransmissionID = c.TransmissionID, Name = c.Name }).ToList(); CarTranssmisisons.Add(new TransmissionDTO { TransmissionID = -1, Name = C_STR_ALL_RUS_F }); //static public List<TransmissionDTO> CarTranssmisisons { get; set; } isInit = true; } if ((CarsCount != _carsCount) && (_carsCount > 0)) { CarsCount = _carsCount; CarBrands = Cars.Brands.Join(Cars.Cars, c => c.BrandId, p => p.CarModel.BrandId, (c, p) => new BrandDTO { BrandId = c.BrandId, BrandName = c.BrandName, LogoName = c.LogoName }).Distinct().ToList(); CarBrands.Add(new BrandDTO { BrandId = -1, BrandName = "Все марки", LogoName = "all" }); CarModels = Cars.CarModels.Join(Cars.Cars, c => c.ModelId, p => p.ModelId, (c, p) => new ModelDTO { ModelId = c.ModelId, ModelName = c.ModelName }).Distinct().ToList(); CarModels.Add(new ModelDTO { ModelId = -1, ModelName = "Все модели" }); minYear = Cars.Cars.OrderBy(c => c.IssueYar).First().IssueYar; minPrice = Cars.Cars.OrderBy(c => c.Price).First().Price; maxYear = Cars.Cars.OrderByDescending(c => c.IssueYar).First().IssueYar; maxPrice = Cars.Cars.OrderByDescending(c => c.Price).First().Price; } if ((CarsCount != _carsCount) && (_carsCount == 0)) { CarsCount = _carsCount; CarBrands = new List<BrandDTO> { new BrandDTO { BrandId=-1, BrandName="Все марки", LogoName="all"} }; CarModels = new List<ModelDTO> { new ModelDTO { ModelId = -1, ModelName = "Все модели"} }; minYear = 1950; minPrice = 0; maxYear = DateTime.Now.Year; maxPrice = int.MaxValue; } f_minPrice = (int)minPrice; f_maxPrice = (int)maxPrice; f_minYear = minYear; f_maxYear = maxYear; f_brandId = -1; f_modelId = -1; //CarModels }
public static void Fill() { using (var p = new PersonContext()) { p.Persons.Add(new Person { City="Basel", Name="David" }); p.Persons.Add(new Person { City="Basel", Name="Bettina" }); p.Persons.Add(new Person { City="Basel", Name="Sergio" }); p.Persons.Add(new Person { City="Thun", Name="Kim" }); p.SaveChanges(); } Services.Providers.Message("Persons Filled."); using (var c = new CarContext()) { c.Cars.Add(new Car { Model = "Audi" }); c.Cars.Add(new Car { Model = "BMW" }); c.Cars.Add(new Car { Model = "Mercedes" }); c.Cars.Add(new Car { Model = "Fiat" }); c.SaveChanges(); } Services.Providers.Message("Cars filled."); }
public static async void Initialize(IServiceProvider serviceProvider) { var context = new CarContext(); if (context == null) { return; } if (context.Database.Exists()) { if (!context.Brands.Any()) { context.Bodys.Add(new Body { BodyID = 1, Name = "седан" }); context.Bodys.Add(new Body { BodyID = 2, Name = "хэчбэк" }); context.Bodys.Add(new Body { BodyID = 3, Name = "универсал" }); context.Bodys.Add(new Body { BodyID = 4, Name = "SUV" }); context.Bodys.Add(new Body { BodyID = 5, Name = "пикап" }); context.Bodys.Add(new Body { BodyID = 6, Name = "внедорожник" }); context.Bodys.Add(new Body { BodyID = 7, Name = "кроссовер" }); context.Bodys.Add(new Body { BodyID = 8, Name = "родстер" }); context.Bodys.Add(new Body { BodyID = 9, Name = "кабриолет" }); context.Bodys.Add(new Body { BodyID = 10, Name = "купе" }); context.Bodys.Add(new Body { BodyID = 11, Name = "минвэн" }); context.Bodys.Add(new Body { BodyID = 12, Name = "лимузин" }); await context.SaveChangesAsync(); } if (!context.Brands.Any()) { context.Drives.Add(new Drive { DriveID = 1, Name = "передний" }); context.Drives.Add(new Drive { DriveID = 2, Name = "задний" }); context.Drives.Add(new Drive { DriveID = 3, Name = "полный" }); await context.SaveChangesAsync(); } if (!context.Brands.Any()) { context.Rudders.Add(new Rudder { RudderID = 1, Name = "левый" }); context.Rudders.Add(new Rudder { RudderID = 2, Name = "правый" }); await context.SaveChangesAsync(); } if (!context.Brands.Any()) { context.Transmissions.Add(new Transmission { TransmissionID = 1, Name = "АКПП" }); context.Transmissions.Add(new Transmission { TransmissionID = 2, Name = "МКПП" }); context.Transmissions.Add(new Transmission { TransmissionID = 3, Name = "CVT" }); await context.SaveChangesAsync(); } if (!context.Brands.Any()) { //var nissan = context.Brands.Add(new Brand { BrandId = 1, BrandName = "Nissan", Cars = null }); //var mitsu = context.Brands.Add(new Brand { BrandId = 2, BrandName = "Mitsubishi", Cars = null }); context.Brands.Add(new Brand { BrandName = "Alfa-Romeo"}); context.Brands.Add(new Brand { BrandName = "Audi"}); context.Brands.Add(new Brand { BrandName = "Bmw"}); context.Brands.Add(new Brand { BrandName = "Chaevrolet"}); context.Brands.Add(new Brand { BrandName = "Citroen"}); context.Brands.Add(new Brand { BrandName = "Ferrari"}); context.Brands.Add(new Brand { BrandName = "Fiat"}); context.Brands.Add(new Brand { BrandName = "Ford"}); context.Brands.Add(new Brand { BrandName = "Geely"}); context.Brands.Add(new Brand { BrandName = "Greatwall"}); context.Brands.Add(new Brand { BrandName = "Honda"}); context.Brands.Add(new Brand { BrandName = "Hyundai"}); context.Brands.Add(new Brand { BrandName = "Infiniti"}); context.Brands.Add(new Brand { BrandName = "Jaguar"}); context.Brands.Add(new Brand { BrandName = "Jeep"}); context.Brands.Add(new Brand { BrandName = "Kia"}); context.Brands.Add(new Brand { BrandName = "Lancia"}); context.Brands.Add(new Brand { BrandName = "Land - rover"}); context.Brands.Add(new Brand { BrandName = "Lexus"}); context.Brands.Add(new Brand { BrandName = "Lifan"}); context.Brands.Add(new Brand { BrandName = "Mazda"}); context.Brands.Add(new Brand { BrandName = "Mercedes"}); context.Brands.Add(new Brand { BrandName = "Mgcars"}); context.Brands.Add(new Brand { BrandName = "Mini"}); //context.Brands.Add(new Brand { BrandName = "Mitsubishi"}); // context.Brands.Add(new Brand { BrandName = "Nissan"}); context.Brands.Add(new Brand { BrandName = "Opel"}); context.Brands.Add(new Brand { BrandName = "Peugeot"}); context.Brands.Add(new Brand { BrandName = "Porsche"}); context.Brands.Add(new Brand { BrandName = "Renault"}); context.Brands.Add(new Brand { BrandName = "Seat"}); context.Brands.Add(new Brand { BrandName = "Skoda"}); context.Brands.Add(new Brand { BrandName = "Ssangyong"}); context.Brands.Add(new Brand { BrandName = "Subaru"}); context.Brands.Add(new Brand { BrandName = "Toyota"}); context.Brands.Add(new Brand { BrandName = "Volvo"}); context.Brands.Add(new Brand { BrandName = "Volkswagen", LogoName = "vw"}); context.Brands.Add(new Brand { BrandName = "ВАЗ", LogoName = "autovaz" }); await context.SaveChangesAsync(); } if (!context.Cars.Any()) { } } }