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();
}
}
