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); }