static void Main() { var sw = new Stopwatch(); sw.Start(); Console.WriteLine("Start Warehouse.Database project."); using (var dataContext = new WarehouseContext()) { System.Data.Entity.Database.SetInitializer(new WarehouseInitializer()); dataContext.Database.Initialize(false); } sw.Stop(); Console.WriteLine("End at {0} s", sw.ElapsedMilliseconds / 1000); }
private static void InitProducts(WarehouseContext context) { if (!context.Products.Any()) { context.Products.AddRange( new Product { Name = "Хрустим Багет Томат и Зелень 60г 24X", Code = "6743", Party = "S100000001", Term = partyTerm.FirstOrDefault(x => x.Key == "S100000001").Value, Comment = "", BoxesInPallete = codesNumBoxes.FirstOrDefault(x => x.Key == "6743").Value, NumOfPalletes = 10, Cost = 8000, PlaceId = 1 }, new Product { Name = "Лейз Из Печи Королевский Краб 85г 12X", Code = "7826", Party = "S200000001", Term = partyTerm.FirstOrDefault(x => x.Key == "S200000001").Value, Comment = "", BoxesInPallete = codesNumBoxes.FirstOrDefault(x => x.Key == "7826").Value, NumOfPalletes = 6, Cost = 12000, PlaceId = 2 }, new Product { Name = "Лейз Стакс Зеленый Лук 140г 9X", Code = "15976", Party = "S300000001", Term = partyTerm.FirstOrDefault(x => x.Key == "S300000001").Value, Comment = "", BoxesInPallete = codesNumBoxes.FirstOrDefault(x => x.Key == "15976").Value, NumOfPalletes = 2, Cost = 32000, PlaceId = 1 } ); context.SaveChanges(); } }
private static void InitPositions(WarehouseContext context) { if (!context.Positions.Any()) { context.Positions.AddRange( new Position { Name = "Грузчик" }, new Position { Name = "Погрузчик" }, new Position { Name = "Кладовщик" }, new Position { Name = "Старший кладовщик" }); } }
private static void InitCustomers(WarehouseContext context) { if (!context.Customers.Any()) { context.Customers.AddRange( new Customer { FIO = "Корнилов Ефим Михаилович", CompanyName = "Фрито Лей", City = "Москва", PhoneNumber = "89225120091" }, new Customer { FIO = "Пономарёв Эльдар Митрофанович", CompanyName = "Бамба", City = "Рязань", PhoneNumber = "89164427689" } ); context.SaveChanges(); } }
private static void InitPlaces(WarehouseContext context) { if (!context.Places.Any()) { context.Places.AddRange( new Place { Sector = "1", Number = "1", MaxPalletes = 22, StorageId = 1 }, new Place { Sector = "1", Number = "2", MaxPalletes = 22, StorageId = 1 } ); context.SaveChanges(); } }
private static void InitStorage(WarehouseContext context) { byte[] fB = File.ReadAllBytes(Environment.CurrentDirectory + "/wwwroot/images/maps5MihnevoStorage.jpg"); string encodedFile = Convert.ToBase64String(fB); byte[] fB2 = File.ReadAllBytes(Environment.CurrentDirectory + "/wwwroot/images/maps5StupinoStorageZyab.jpg"); string encodedFile2 = Convert.ToBase64String(fB2); if (!context.Storages.Any()) { context.Storages.AddRange( new Storage { Name = "Модуль-5", Territory = "ЗЯБ", Address = "РФ, МО, г.Ступино, ул.Транспортная, вл.22/2", GeoLat = 54.899057, GeoLong = 38.050520, StorageImage = fB, StorageImageBase64 = encodedFile }, new Storage { Name = "Модуль-3", Territory = "ЗЯБ", Address = "РФ, МО, г.Ступино, ул.Транспортная, вл.22/2", GeoLat = 54.898866, GeoLong = 38.047805, StorageImage = fB2, StorageImageBase64 = encodedFile2 } ); context.SaveChanges(); } }
private static void InitPassports(WarehouseContext context) { if (!context.Passports.Any()) { context.Passports.AddRange( new Passport { Series = "4415", Number = "900320", IssuedAt = "МСК МУНИЦ МО РФ", IssuedWas = Convert.ToDateTime("01.02.2010") }, new Passport { Series = "4542", Number = "900321", IssuedAt = "МСК МУНИЦ МО РФ", IssuedWas = Convert.ToDateTime("04.03.2011") }, new Passport { Series = "4418", Number = "900324", IssuedAt = "МСК МУНИЦ МО РФ", IssuedWas = Convert.ToDateTime("20.01.2012") }, new Passport { Series = "4417", Number = "900329", IssuedAt = "МСК МУНИЦ МО РФ", IssuedWas = Convert.ToDateTime("17.08.2016") }, new Passport { Series = "4420", Number = "900327", IssuedAt = "МСК МУНИЦ МО РФ", IssuedWas = Convert.ToDateTime("12.04.2009") }, new Passport { Series = "4440", Number = "900330", IssuedAt = "МСК МУНИЦ МО РФ", IssuedWas = Convert.ToDateTime("11.06.2018") }, new Passport { Series = "4441", Number = "901001", IssuedAt = "МСК МУНИЦ МО РФ", IssuedWas = Convert.ToDateTime("19.01.2012") }, new Passport { Series = "4499", Number = "901310", IssuedAt = "МСК МУНИЦ МО РФ", IssuedWas = Convert.ToDateTime("13.08.2016") }, new Passport { Series = "4456", Number = "901326", IssuedAt = "МСК МУНИЦ МО РФ", IssuedWas = Convert.ToDateTime("18.04.2009") }, new Passport { Series = "4378", Number = "901456", IssuedAt = "МСК МУНИЦ МО РФ", IssuedWas = Convert.ToDateTime("17.06.2018") } ); context.SaveChanges(); } }
private static void InitVehicle(WarehouseContext context) { if (!context.Vehicles.Any()) { context.Drivers.AddRange( new Driver { FIO = "Самсонов Владимир Геннадьевич", Birthday = Convert.ToDateTime("02.06.1982"), PhoneNumber = "89155326672", Experience = 5, PassportId = 7 }, new Driver { FIO = "Вишняков Рудольф Мартынович", Birthday = Convert.ToDateTime("11.10.1975"), PhoneNumber = "89155326102", Experience = 10, PassportId = 8 }, new Driver { FIO = "Симонов Корнелий Якунович", Birthday = Convert.ToDateTime("22.11.1979"), PhoneNumber = "89155326188", Experience = 9, PassportId = 9 }, new Driver { FIO = "Шарапов Иннокентий Федосеевич", Birthday = Convert.ToDateTime("23.04.1999"), PhoneNumber = "89155326001", Experience = 3, PassportId = 10 } ); context.SaveChanges(); context.Vehicles.AddRange( new Vehicle { Name = "МАЗ-5440М9", Number = "A999AA", Capacity = 32, DriverId = 1 }, new Vehicle { Name = "Foton Auman H5", Number = "Y645TO", Capacity = 36, DriverId = 2 }, new Vehicle { Name = "MAN TGS", Number = "X112BX", Capacity = 22, DriverId = 3 }, new Vehicle { Name = "Hyundai Mighty", Number = "X235YM", Capacity = 33, DriverId = 4 } ); context.SaveChanges(); } }
private static void InitWorkers(WarehouseContext context) { if (!context.Workers.Any()) { context.Workers.AddRange( new Worker { FIO = "Молодов Геннадий Викторович", Birthday = Convert.ToDateTime("22.07.1998"), PhoneNumber = "89953468162", Number = "00001", Salary = 30000, PositionId = 1, Experience = 1, PassportId = 1 }, new Worker { FIO = "Чекарев Михаил Александрович", Birthday = Convert.ToDateTime("11.05.1989"), PhoneNumber = "89953468500", Number = "00002", Salary = 30000, PositionId = 1, Experience = 2, PassportId = 2 }, new Worker { FIO = "Музов Кирилл Викторович", Birthday = Convert.ToDateTime("25.02.1986"), PhoneNumber = "89953468345", Number = "10001", Salary = 40000, PositionId = 2, Experience = 3, PassportId = 3 }, new Worker { FIO = "Лесов Павел Кириллович", Birthday = Convert.ToDateTime("10.09.1987"), PhoneNumber = "89953468999", Number = "10002", Salary = 40000, PositionId = 2, Experience = 2, PassportId = 4 }, new Worker { FIO = "Трубнов Владимир Петрович", Birthday = Convert.ToDateTime("21.10.1995"), PhoneNumber = "89953468533", Number = "20001", PositionId = 3, Experience = 1, PassportId = 5 }, new Worker { FIO = "Рощена Мария Павловна", Birthday = Convert.ToDateTime("20.01.1972"), PhoneNumber = "89953468532", Number = "20002", Salary = 50000, PositionId = 4, Experience = 5, PassportId = 6 } ); context.SaveChanges(); } }