private static void TypeOfCargo(CargoTransportationContext db) { if (db.TypeOfCargos.Any()) { return; } db.TypeOfCargos.AddRange(new TypeOfCargo[] { new TypeOfCargo() { Name = "Bulk", Description = "Some description" }, new TypeOfCargo() { Name = "Powdery", Description = "Some description" }, new TypeOfCargo() { Name = "Oversized", Description = "Some description" }, new TypeOfCargo() { Name = "Piece", Description = "Some description" } }); db.SaveChanges(); }
private static void CargoGenerate(CargoTransportationContext db, int count) { if (db.Cargos.Any()) { return; } string chars = "ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz "; var typeOfCargoCount = db.TypeOfCargos.Count(); for (int i = 0; i < count; i++) { var name = GetRandStr(chars, 20); var typeOfCargoId = randObj.Next(1, typeOfCargoCount + 1); var shelfLife = DateTime.Now.AddDays(randObj.Next(500)); var features = GetRandStr(chars, 40); db.Cargos.Add(new Cargo() { Name = name, TypeOfCargoId = typeOfCargoId, ShelfLife = shelfLife, Features = features }); } db.SaveChanges(); }
private static void CarBrandGenerate(CargoTransportationContext db, int count) { if (db.CarBrands.Any()) { return; } string chars = "ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz "; string[] nameVoc = { "Mercedes-Benz W", "VW Passat B", "VW Golf ", "VW Polo ", "ВАЗ201", "Tesla Model ", "Volvo F", "Seat ", "Toyota Camry 3.", "Hyundai " }; string[] typeVoc = { "Passenger car", "Truck ", "Сargo-passenger car" }; for (int i = 0; i < count; i++) { var name = nameVoc[randObj.Next(nameVoc.GetLength(0))] + randObj.Next(count); int maxSpeed = randObj.Next(160, 320); var description = new string(Enumerable.Repeat(chars, 20) .Select(s => s[randObj.Next(s.Length)]).ToArray()); var type = typeVoc[randObj.Next(typeVoc.GetLength(0))] + randObj.Next(count); db.CarBrands.Add(new CarBrand() { Name = name, MaxSpeed = maxSpeed, Description = description, Type = type }); } db.SaveChanges(); }
private static void FlightGenerat(CargoTransportationContext db, int count) { if (db.Flights.Any()) { return; } string[] customerVoc = { "Lipsky D.Y.", "Stolny S.D.", "Semenov D.S.", "Deker M.A.", "Ropot I.V.", "Butkovski Y.V.", "Stepanenko Y.V.", "Moiseikov R.A.", "Rogolevich N.V.", "Gerosimenko M.A.", "Galetskiy A.A.", "Zankevich K.A." }; string[] pointVoc = { "Gomel", "Mozyr", "Minsk", "Grodno", "Brest", "Moscow", "Mogilev" }; int carCount = db.Cargos.Count(); int cargoCount = db.Cargos.Count(); for (int i = 0; i < count; i++) { var customer = customerVoc[randObj.Next(customerVoc.GetLength(0))] + randObj.Next(count); var startPoint = pointVoc[randObj.Next(pointVoc.GetLength(0))] + randObj.Next(count); var endPoint = pointVoc[randObj.Next(pointVoc.GetLength(0))] + randObj.Next(count); var startDate = DateTime.Now.AddDays(-randObj.Next(500)); var endDate = startDate.AddDays(randObj.Next(500)); var carId = randObj.Next(1, carCount + 1); var cargoId = randObj.Next(1, cargoCount + 1); var price = randObj.NextDouble() * 100; var isPayment = randObj.Next(0, 1000) > 500 ? true : false; var isReturn = randObj.Next(0, 1000) > 500 ? true : false; db.Flights.Add(new Flight() { Customer = customer, StartPoint = startPoint, EndPoint = endPoint, StartDate = startDate, EndDate = endDate, CarId = carId, CargoId = cargoId, Price = price, IsPayment = isPayment, IsReturn = isReturn }); } db.SaveChanges(); }
public static void Initialize(CargoTransportationContext db) { db.Database.EnsureCreated(); int employeeCount = 50; int carBrandCount = 40; int carCount = 100; int cargoCount = 100; int flightCount = 200; TypeOfCargo(db); EmployeeGenerate(db, employeeCount); CarBrandGenerate(db, carBrandCount); CarGenerate(db, carCount); CargoGenerate(db, cargoCount); FlightGenerat(db, flightCount); }
private static void EmployeeGenerate(CargoTransportationContext db, int count) { if (db.Employees.Any()) { return; } string chars = "ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz "; string[] fullNamesVoc = { "Zhmailik A.V.", "Setko A.I.", "Semenov D.S.", "Davidchik A.E.", "Piskun E.A.", "Drakula V.A.", "Yastrebov A.A.", "Steponenko Y.A.", "Basharimov Y.I.", "Karkozov V.V.", "Lipsky D.Y." }; string[] addressVoc = { "Mozyr, per.Zaslonova, ", "Gomel, st.Gastelo, ", "Minsk, st.Poleskay, ", "Grodno, pr.Rechetski, ", "Vitebsk, st, International, ", "Brest, pr.October, ", "Minsk, st.Basseinaya, ", "Mozyr, boulevard Youth, " }; for (int i = 0; i < count; i++) { var fullName = fullNamesVoc[randObj.Next(fullNamesVoc.GetLength(0))] + randObj.Next(count); var age = randObj.Next(18, 65); var address = addressVoc[randObj.Next(addressVoc.GetLength(0))] + randObj.Next(count); var phoneNumber = "+375 (29) " + randObj.Next(100, 999) + "-" + randObj.Next(10, 99) + "-" + randObj.Next(10, 99); var passportData = new string(Enumerable.Repeat(chars, 2) .Select(s => s[randObj.Next(s.Length)]).ToArray()).ToUpper() + randObj.Next(100000, 999999); var position = new string(Enumerable.Repeat(chars, 20) .Select(s => s[randObj.Next(s.Length)]).ToArray()); db.Employees.Add(new Employee() { FullName = fullName, Age = age, Address = address, PhoneNumber = phoneNumber, PassportData = passportData, Position = position }); } db.SaveChanges(); }
private static void CarGenerate(CargoTransportationContext db, int count) { if (db.Cars.Any()) { return; } string chars = "ABCDEFGHIJKLMNOPQRSTUVWXYZ"; int carBrandCount = db.CarBrands.Count(); int employeeCount = db.Employees.Count(); for (int i = 0; i < count; i++) { var regNumber = chars[randObj.Next(chars.Length)].ToString() + chars[randObj.Next(chars.Length)].ToString() + " " + randObj.Next(1000, 9999); var vinNumber = GetRandStr(chars, 8) + randObj.Next(0, 9) + GetRandStr(chars, 2) + randObj.Next(100000, 999999); var engineNumber = GetRandStr(chars, 2) + randObj.Next(1000, 9999) + GetRandStr(chars, 1) + randObj.Next(10, 99); var yearOfIssue = randObj.Next(1980, 2020); var techInspection = DateTime.Now.AddDays(-randObj.Next(1000)); var employeeId = randObj.Next(1, employeeCount + 1); var carBrandId = randObj.Next(1, carBrandCount + 1); db.Cars.Add(new Car() { RegNumber = regNumber, VinNumber = vinNumber, EngineNumber = engineNumber, YearOfIssue = yearOfIssue, TechInspection = techInspection, EmployeeId = employeeId, CarBrandId = carBrandId }); } db.SaveChanges(); }