/// <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())
{
}
}
}
