private static void AddPayments(ManagerReportsContext dbContext) { if (dbContext.Payments.Any()) { return; } dbContext.Payments.AddRange( new PaymentRecordEntity { Date = new DateTime(2015, 12, 29).Date, Amount = 338000.0m, Project = dbContext.Projects.FirstOrDefault(i => i.ExternalId == 352), ProjectVersion = dbContext.ProjectVersions.FirstOrDefault(i => i.ExternalId == 243) }); }
private static void AddSoldResources(ManagerReportsContext dbContext) { if (dbContext.SoldResources.Any()) { return; } dbContext.SoldResources.AddRange( new SoldResourceEntity { Name = "Дизайн", Rate = 1400.0m, Hours = 120.0m, Employees = new[] { new EmployeeSoldResourceEntity { Employee = dbContext.Employees.FirstOrDefault(i => i.LastName == "Анкудинов") } }, Project = dbContext.Projects.FirstOrDefault(i => i.ExternalId == 352), ProjectVersion = dbContext.ProjectVersions.FirstOrDefault(i => i.ExternalId == 243) }, new SoldResourceEntity { Name = "Управление проектом", Rate = 1300.0m, Hours = 60.0m, Employees = new[] { new EmployeeSoldResourceEntity { Employee = dbContext.Employees.FirstOrDefault(i => i.LastName == "Шемякин") } }, Project = dbContext.Projects.FirstOrDefault(i => i.ExternalId == 352), ProjectVersion = dbContext.ProjectVersions.FirstOrDefault(i => i.ExternalId == 243) }, new SoldResourceEntity { Name = "Разработка", Rate = 1500.0m, Hours = 240.0m, Employees = new[] { new EmployeeSoldResourceEntity { Employee = dbContext.Employees.FirstOrDefault(i => i.LastName == "Макшаков") }, new EmployeeSoldResourceEntity { Employee = dbContext.Employees.FirstOrDefault(i => i.LastName == "Красноперов") } }, Project = dbContext.Projects.FirstOrDefault(i => i.ExternalId == 352), ProjectVersion = dbContext.ProjectVersions.FirstOrDefault(i => i.ExternalId == 243) }, new SoldResourceEntity { Name = "Тестирование", Rate = 1000.0m, Hours = 70.0m, Employees = new[] { new EmployeeSoldResourceEntity { Employee = dbContext.Employees.FirstOrDefault(i => i.LastName == "Калинин") } }, Project = dbContext.Projects.FirstOrDefault(i => i.ExternalId == 352), ProjectVersion = dbContext.ProjectVersions.FirstOrDefault(i => i.ExternalId == 243) }, new SoldResourceEntity { Name = "Дизайн", Rate = 1200.0m, Hours = 256.0m, Employees = new[] { new EmployeeSoldResourceEntity { Employee = dbContext.Employees.FirstOrDefault(i => i.LastName == "Анкудинов") }, new EmployeeSoldResourceEntity { Employee = dbContext.Employees.FirstOrDefault(i => i.LastName == "Учанов") } }, Project = dbContext.Projects.FirstOrDefault(i => i.ExternalId == 331), ProjectVersion = dbContext.ProjectVersions.FirstOrDefault(i => i.ExternalId == 226) }, new SoldResourceEntity { Name = "Аналитика", Rate = 1200.0m, Hours = 172.0m, Employees = new[] { new EmployeeSoldResourceEntity { Employee = dbContext.Employees.FirstOrDefault(i => i.LastName == "Рахимова") } }, Project = dbContext.Projects.FirstOrDefault(i => i.ExternalId == 331), ProjectVersion = dbContext.ProjectVersions.FirstOrDefault(i => i.ExternalId == 225) }, new SoldResourceEntity { Name = "Прототипирование", Rate = 1200.0m, Hours = 80.0m, Project = dbContext.Projects.FirstOrDefault(i => i.ExternalId == 331), ProjectVersion = dbContext.ProjectVersions.FirstOrDefault(i => i.ExternalId == 225), Employees = new[] { new EmployeeSoldResourceEntity { Employee = dbContext.Employees.FirstOrDefault(i => i.LastName == "Учанов") }, new EmployeeSoldResourceEntity { Employee = dbContext.Employees.FirstOrDefault(i => i.LastName == "Анкудинов") } } }, new SoldResourceEntity { Name = "Создание контента", Rate = 800.0m, Hours = 120.0m, Project = dbContext.Projects.FirstOrDefault(i => i.ExternalId == 331) }, new SoldResourceEntity { Name = "Разработка", Rate = 800.0m, Hours = 120.0m, Project = dbContext.Projects.FirstOrDefault(i => i.ExternalId == 331), ProjectVersion = dbContext.ProjectVersions.FirstOrDefault(i => i.ExternalId == 225), Employees = new[] { new EmployeeSoldResourceEntity { Employee = dbContext.Employees.FirstOrDefault(i => i.LastName == "Моглиев") }, new EmployeeSoldResourceEntity { Employee = dbContext.Employees.FirstOrDefault(i => i.LastName == "Богатырев") } } }, new SoldResourceEntity { Name = "Управление проектом", Rate = 1200.0m, Hours = 130.0m, Project = dbContext.Projects.FirstOrDefault(i => i.ExternalId == 331), ProjectVersion = dbContext.ProjectVersions.FirstOrDefault(i => i.ExternalId == 225), Employees = new[] { new EmployeeSoldResourceEntity { Employee = dbContext.Employees.FirstOrDefault(i => i.LastName == "Рахимова") }, new EmployeeSoldResourceEntity { Employee = dbContext.Employees.FirstOrDefault(i => i.LastName == "Шемякин") } } }); }