public override void Generate()
{
var employeesIds = this.Database.Employees.Select(a => a.Id).ToList();
Console.WriteLine("Adding Reports:");
for (int i = 0; i < this.Count; i++)
{
var newReport = new Report
{
Text = "Blank",
CreatedOn = DateTime.Now,
EmployeeId = employeesIds[this.Random.GetRandomNumber(0, employeesIds.Count - 1)]
};
if (i % 100 == 0)
{
Console.Write(".");
this.Database.SaveChanges();
}
this.Database.Reports.Add(newReport);
}
Console.WriteLine();
Console.WriteLine("Projects added!");
}
public override void Generate()
{
var employeeIDs = this.Database.Employees.Select(c => c.ID).ToList();
this.Logger.LogMessage("Adding reports");
for (int i = 0; i < this.Count; i++)
{
var report = new Report
{
Content = this.Random.GetRandomStringWithRandomLength(10, 100),
Date = ProjectDataGenerator.RandomDay(),
EmployeeID = employeeIDs[this.Random.GetRandomNumber(0, employeeIDs.Count - 1)]
};
this.Database.Reports.Add(report);
if (i % 100 == 0)
{
this.Logger.Dot();
this.Database.SaveChanges();
}
}
this.Logger.LogMessage(" Reports added!\n");
}
public void GenerateData(CompanyEntities data, IRandomGenerator random, int count)
{
var employeeIds = data.Employees.Select(e => e.Id).ToList();
foreach (var employeeId in employeeIds)
{
var reportsCount = random.GetRandomNumber((int)(0.5 * count), (int)(1.5 * count));
for (int i = 0; i < reportsCount; i++)
{
var timeSpanForReport = random.GetRandomNumber(0, 60 * 60 * 24 * 1000);
var report = new Report
{
EmployeeId = employeeId,
Time = DateTime.Now.AddSeconds(-timeSpanForReport)
};
data.Reports.Add(report);
}
}
}
public override void Generate()
{
Console.WriteLine("Generating Reports");
var employeesIds = this.Db.Employees.Select(d => d.ID).ToList();
for (int i = 0; i < this.Count; i++)
{
var newReport = new Report
{
Time = DateTime.Now.AddDays(this.Random.GetInt(-50, 0)),
EmployeeID = employeesIds[this.Random.GetInt(0, employeesIds.Count - 1)],
};
this.Db.Reports.Add(newReport);
if (i % 100 == 0)
{
Console.Write(".");
Db.SaveChanges();
}
}
Console.WriteLine("\nGenerating Reports Done!");
}
static void Main(string[] args)
{
var random = RandomDataGenerator.Instance;
var db = new CompanyEntities();
db.Configuration.AutoDetectChangesEnabled = false;
Console.WriteLine("\nAdding departments");
for (int i = 0; i < 100; i++)
{
var department = new Department
{
Name = random.GetRandomStringWithRandomLength(10,50)
};
db.Departments.Add(department);
if (i%100 == 0)
{
Console.Write(".");
db.SaveChanges();
}
}
db.SaveChanges();
Console.WriteLine("\nDepartents added");
Console.WriteLine("\nAdding employees");
var departmentIds = db.Departments.Select(d => d.Id).ToList();
for (int i = 0; i < 5000; i++)
{
var employee = new Employee
{
FirstName = random.GetRandomStringWithRandomLength(5,20),
LastName = random.GetRandomStringWithRandomLength(5,20),
DepartmentId = departmentIds[random.GetRandomNumber(0, departmentIds.Count - 1)],
YearSalary = random.GetRandomNumber(50000,200000),
ManagerId = (i > 250) ? i - 1 :(int?)null // 4750 employees will have a manager (95%) :)
// it is very stupid i know but I left it for last and forgot it
};
db.Employees.Add(employee);
if (i % 100 == 0)
{
Console.Write(".");
db.SaveChanges();
}
}
db.SaveChanges();
Console.WriteLine("\nEmployees added");
Console.WriteLine("\nAdding Projects"); //For some reason it does not want to work
var employeeIds = db.Employees.Select(e => e.Id).ToList();
for (int i = 0; i < 1000; i++)
{
var project = new Project
{
Name = "Project" + i.ToString(),
};
var count = random.GetRandomNumber(5, 20);
for (int j = 0; j < count; j++)
{
var projectEmployee = new ProjectsEmployee
{
EmployeeId = employeeIds[i+j],
ProjectId = i+1,
StartDate = new DateTime(random.GetRandomNumber(1980, 2005), random.GetRandomNumber(1, 12), random.GetRandomNumber(1, 28)),
EndDate = new DateTime(random.GetRandomNumber(2005, 2020), random.GetRandomNumber(1, 12), random.GetRandomNumber(1, 28))
};
project.ProjectsEmployees.Add(projectEmployee);
}
db.Projects.Add(project);
if (i % 100 == 0)
{
Console.Write(".");
db.SaveChanges();
}
}
db.SaveChanges();
Console.WriteLine("\nProjects added");
Console.WriteLine("\nAdding Reports");
var employeeIds2 = db.Employees.Select(d => d.Id).ToList();
for (int i = 0; i < 5000; i++)
{
var empId = employeeIds2[i];
for (int j = 0; j < 50; j++) // every empolyee gets 50 reports
{
var report = new Report
{
EmployeeId = empId,
TimeOfReport = new DateTime(random.GetRandomNumber(1980, 2014), random.GetRandomNumber(1, 12), random.GetRandomNumber(1, 28))
};
db.Reports.Add(report);
}
Console.Write(".");
db.SaveChanges();
}
db.SaveChanges();
Console.WriteLine("\nReports added");
db.Configuration.AutoDetectChangesEnabled = true;
}
