private static void PositionGenerate(NotarialOfficeContext db) { if (db.Positions.Any()) { return; } db.Positions.AddRange(new Position[] { new Position() { Name = "Notary", Salary = 1000, Duties = "Communication with clients", Requirement = "Communication, diploma" }, new Position() { Name = "Assistant notary", Salary = 600, Duties = "Paperwork", Requirement = "Communication, incomplete higher education" }, new Position() { Name = "Secretary ", Salary = 400, Duties = "Paperwork", Requirement = "Communication, secondary education" }, }); db.SaveChanges(); }
private static void ContractGenerate(NotarialOfficeContext db, int count) { if (db.Contracts.Any()) { return; } int serviceCount = db.Services.Count(); int employeeCount = db.Employees.Count(); int clientCount = db.Clients.Count(); for (int i = 0; i < count; i++) { var subDate = DateTime.Now.AddDays(-randObj.Next(1000)); var endDate = subDate.AddDays(randObj.Next(500)); var serviceId = randObj.Next(1, serviceCount + 1); var employeeId = randObj.Next(1, employeeCount + 1); var clientId = randObj.Next(1, clientCount + 1); db.Contracts.Add(new Contract() { SubscriptDate = subDate, EndDate = endDate, ServiceId = serviceId, EmployeeId = employeeId, ClientId = clientId }); } db.SaveChanges(); }
public static void Initialize(NotarialOfficeContext db) { db.Database.EnsureCreated(); int clientCount = 100; int employeeCount = 50; int serviceCount = 20; int contractCount = 100; PositionGenerate(db); ClientGenerate(db, clientCount); EmployeeGenerate(db, employeeCount); ServiceGenerate(db, serviceCount); ContractGenerate(db, contractCount); }
private static void EmployeeGenerate(NotarialOfficeContext db, int count) { if (db.Employees.Any()) { return; } int positionCount = db.Positions.Count(); string[] fullNamesVoc = { "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[] addressVoc = { "per.Zaslonova, ", "st.Gastelo, ", "st.Poleskay, ", "pr.Rechetski, ", "st, International, ", "pr.October, ", "st.Basseinaya, ", "boulevard Youth, " }; for (int i = 0; i < count; i++) { var fullName = fullNamesVoc[randObj.Next(fullNamesVoc.GetLength(0))] + randObj.Next(count); var birthdayDate = DateTime.Now.AddDays(-randObj.Next(5000, 10000)); 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 positionId = randObj.Next(1, positionCount + 1); db.Employees.Add(new Employee() { FullName = fullName, BirthdayDate = birthdayDate, Address = address, PhoneNumber = phoneNumber, PositionId = positionId }); } db.SaveChanges(); }
private static void ServiceGenerate(NotarialOfficeContext db, int count) { if (db.Services.Any()) { return; } string chars = "ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz "; for (int i = 0; i < count; i++) { var name = new string(Enumerable.Repeat(chars, 20) .Select(s => s[randObj.Next(s.Length)]).ToArray()); var price = randObj.NextDouble() * 100; db.Services.Add(new Service() { Name = name, Price = price }); } db.SaveChanges(); }
private static void ClientGenerate(NotarialOfficeContext db, int count) { if (db.Clients.Any()) { return; } string chars = "ABCDEFGHIJKLMNOPQRSTUVWXYZ"; 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." }; 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 passportSeries = chars[randObj.Next(chars.Length)].ToString() + chars[randObj.Next(chars.Length)].ToString(); var passportNum = randObj.Next(100000, 999999); var birthdayDate = DateTime.Now.AddDays(-randObj.Next(5000, 10000)); 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); db.Clients.Add(new Client() { FullName = fullName, PassportSeries = passportSeries, PassportNumber = passportNum, BirthdayDate = birthdayDate, Address = address, PhoneNumber = phoneNumber }); } db.SaveChanges(); }