public static List <String> GenerateEmployees()
{
List <String> employeesGenerated = new List <String>();
RandomDateTime rdt = new RandomDateTime(new DateTime(1955, 1, 1), new DateTime(2001, 1, 1));
Random r = new Random();
for (int i = 0; i < 20; i++)
{
//"INSERT INTO Employee VALUES('EM00','Darwin','Bonner','24 Cherokee Way',TO_DATE('6/7/1974', 'mm/dd/yyyy'),'M','Department Manager','DP30');""
string code = "EM" + (i + 10);
string firstName = firstNames[r.Next(0, firstNames.Count())];
string lastname = lastNames[r.Next(0, lastNames.Count())];
string address = addresses[r.Next(0, addresses.Count())];
string date = rdt.Next().ToString().Split(' ')[0].Replace('.', '/');
char[] genders = { 'M', 'F' };
char gender = genders[r.Next(0, 2)];
string job = i < 5 ? position[0] : position[r.Next(1, position.Count())];
string department = i < 5 ? departmentCodeNumbers[i] : departmentCodeNumbers[r.Next(1, departmentCodeNumbers.Count())];
departmentEmployees[department].Add(code);
string insert = $"INSERT INTO Employee VALUES ('{code}', '{firstName}', '{lastname}', '{address}', TO_DATE('{date}', 'mm/dd/yyyy'), '{gender}', '{job}', '{department}');";
employeesGenerated.Add(insert);
}
return(employeesGenerated);
}
public static List <String> GenerateWorksOn()
{
List <String> generatedWorksOn = new List <String>();
RandomDateTime rdt = new RandomDateTime(new DateTime(2019, 1, 1), new DateTime(2021, 1, 1));
Random r = new Random();
for (int i = 0; i < 20; i++)
{
string date = rdt.Next().ToString().Split(' ')[0].Replace('.', '/');
double hours = r.NextDouble() * (10 - 4) + 4;
string department = departmentCodeNumbers[r.Next(0, departmentCodeNumbers.Count())];
string project = departmentProyects[department][r.Next(0, departmentProyects[department].Count())];
string employee = departmentEmployees[department][r.Next(0, departmentEmployees[department].Count())];
string insert = $"INSERT INTO WorksOn VALUES('{employee}','{project}', TO_DATE('{date}', 'mm/dd/yyyy'), {hours.ToString("#.#").Replace(',','.')});";
generatedWorksOn.Add(insert);
}
return(generatedWorksOn);
}