public static void Local() { // информация для логирования var preLog = Guid.Empty + " | " + ClassName + "." + ExtensionProvider.GetCallerMethodName(); try { using var context = new LocalDatabaseContext(); // мигрируем базу данных context.Database.Migrate(); } catch (Exception ex) { // логируем исключение Logging.Exception(preLog + "(" + ex.Message + ")" + ex.StackTrace.ToTabString()); } }
public static void LocalData() { // информация для логирования var preLog = Guid.Empty + " | " + ClassName + "." + ExtensionProvider.GetCallerMethodName(); try { using var context = new LocalDatabaseContext(); var department1 = new Department { Name = "Shop" }; context.Departments.Add(department1); var department2 = new Department { Name = "Logistics" }; context.Departments.Add(department2); var department3 = new Department { Name = "Orders" }; context.Departments.Add(department3); var department4 = new Department { Name = "Marketing" }; context.Departments.Add(department4); var department5 = new Department { Name = "Warehouse" }; context.Departments.Add(department5); context.SaveChanges(); var employee1 = new Employee { Name = "Harry", Salary = 5000, DepartmentId = department1.Id }; context.Employees.Add(employee1); var employee2 = new Employee { Name = "Oliver", Salary = 4500, DepartmentId = department2.Id }; context.Employees.Add(employee2); var employee3 = new Employee { Name = "Jack", Salary = 7000, DepartmentId = department3.Id }; context.Employees.Add(employee3); var employee4 = new Employee { Name = "Charlie", Salary = 2000, DepartmentId = department4.Id }; context.Employees.Add(employee4); var employee5 = new Employee { Name = "Thomas", Salary = 3500, DepartmentId = department5.Id }; context.Employees.Add(employee5); var employee6 = new Employee { Name = "Jacob", Salary = 1000, DepartmentId = department1.Id }; context.Employees.Add(employee6); var employee7 = new Employee { Name = "Alfie", Salary = 6000, DepartmentId = department2.Id }; context.Employees.Add(employee7); var employee8 = new Employee { Name = "Riley", Salary = 5000, DepartmentId = department3.Id }; context.Employees.Add(employee8); var employee9 = new Employee { Name = "William", Salary = 4500, DepartmentId = department4.Id }; context.Employees.Add(employee9); var employee10 = new Employee { Name = "James", Salary = 7000, DepartmentId = department5.Id }; context.Employees.Add(employee10); var employee11 = new Employee { Name = "Amelia", Salary = 2500, DepartmentId = department1.Id }; context.Employees.Add(employee11); var employee12 = new Employee { Name = "Olivia", Salary = 3000, DepartmentId = department2.Id }; context.Employees.Add(employee12); var employee13 = new Employee { Name = "Jessica", Salary = 5000, DepartmentId = department3.Id }; context.Employees.Add(employee13); var employee14 = new Employee { Name = "Emily", Salary = 4500, DepartmentId = department4.Id }; context.Employees.Add(employee14); var employee15 = new Employee { Name = "Lily", Salary = 7000, DepartmentId = department5.Id }; context.Employees.Add(employee15); var employee16 = new Employee { Name = "Ava", Salary = 5000, DepartmentId = department1.Id }; context.Employees.Add(employee16); var employee17 = new Employee { Name = "Heather", Salary = 5000, DepartmentId = department2.Id }; context.Employees.Add(employee17); var employee18 = new Employee { Name = "Sophie", Salary = 3500, DepartmentId = department3.Id }; context.Employees.Add(employee18); var employee19 = new Employee { Name = "Mia", Salary = 3000, DepartmentId = department4.Id }; context.Employees.Add(employee19); var employee20 = new Employee { Name = "Isabella", Salary = 3500, DepartmentId = department5.Id }; context.Employees.Add(employee20); var employee21 = new Employee { Name = "Jack", Salary = 1000, DepartmentId = department1.Id }; context.Employees.Add(employee21); var employee22 = new Employee { Name = "James", Salary = 1500, DepartmentId = department2.Id }; context.Employees.Add(employee22); var employee23 = new Employee { Name = "Daniel", Salary = 5000, DepartmentId = department3.Id }; context.Employees.Add(employee23); var employee24 = new Employee { Name = "Harry", Salary = 5000, DepartmentId = department4.Id }; context.Employees.Add(employee24); var employee25 = new Employee { Name = "Charlie", Salary = 4500, DepartmentId = department5.Id }; context.Employees.Add(employee25); var employee26 = new Employee { Name = "Ethan", Salary = 7000, DepartmentId = department1.Id }; context.Employees.Add(employee26); var employee27 = new Employee { Name = "Matthew", Salary = 7000, DepartmentId = department2.Id }; context.Employees.Add(employee27); var employee28 = new Employee { Name = "Ryen", Salary = 5000, DepartmentId = department3.Id }; context.Employees.Add(employee28); var employee29 = new Employee { Name = "Riley", Salary = 6500, DepartmentId = department4.Id }; context.Employees.Add(employee29); var employee30 = new Employee { Name = "Noah", Salary = 3500, DepartmentId = department5.Id }; context.Employees.Add(employee30); context.SaveChanges(); } catch (Exception ex) { // логируем исключение Logging.Exception(preLog + "(" + ex.Message + ")" + ex.StackTrace.ToTabString()); } }