public List <Employee> GetEmployees([FromQuery] string date) { string query = "SELECT * FROM EmployeeTable;"; using (SqlConnection conn = new SqlConnection(Connection.ConnString)) { try { conn.Open(); List <Employee> employees = conn.Query <Employee>(query).ToList(); if (employees.Count < 1) { employees.Add(new Employee { Id = 1001, Name = "Manager 1", Role = "Manager", ContractHours = 37.5, WorkPattern = "Mon,Tue,Wed,Thu,Fri" }); employees.Add(new Employee { Id = 1002, Name = "Manager 2", Role = "Manager", ContractHours = 30.0, WorkPattern = "Fri,Sat,Sun,Mon" }); employees.Add(new Employee { Id = 1003, Name = "Supervisor 1", Role = "Supervisor", ContractHours = 37.5, WorkPattern = "Mon,Tue,Wed,Thu,Fri" }); employees.Add(new Employee { Id = 1004, Name = "Supervisor 2", Role = "Supervisor", ContractHours = 37.5, WorkPattern = "Mon,Tue,Wed,Thu,Fri" }); employees.Add(new Employee { Id = 1005, Name = "Supervisor 3", Role = "Supervisor", ContractHours = 30.0, WorkPattern = "Fri,Sat,Sun,Mon" }); employees.Add(new Employee { Id = 1006, Name = "Supervisor 4", Role = "Supervisor", ContractHours = 30.0, WorkPattern = "Fri,Sat,Sun,Mon" }); employees.Add(new Employee { Id = 1007, Name = "Agent 1", Role = "Agent", ContractHours = 37.5, WorkPattern = "Mon,Tue,Wed,Thu,Fri" }); employees.Add(new Employee { Id = 1008, Name = "Agent 2", Role = "Agent", ContractHours = 37.5, WorkPattern = "Mon,Tue,Wed,Thu,Fri" }); employees.Add(new Employee { Id = 1009, Name = "Agent 3", Role = "Agent", ContractHours = 37.5, WorkPattern = "Mon,Tue,Wed,Thu,Fri" }); employees.Add(new Employee { Id = 1010, Name = "Agent 4", Role = "Agent", ContractHours = 37.5, WorkPattern = "Mon,Tue,Wed,Thu,Fri" }); employees.Add(new Employee { Id = 1011, Name = "Agent 5", Role = "Agent", ContractHours = 30.0, WorkPattern = "Fri,Sat,Sun,Mon" }); employees.Add(new Employee { Id = 1012, Name = "Agent 6", Role = "Agent", ContractHours = 30.0, WorkPattern = "Fri,Sat,Sun,Mon" }); employees.Add(new Employee { Id = 1013, Name = "Agent 7", Role = "Agent", ContractHours = 30.0, WorkPattern = "Fri,Sat,Sun,Mon" }); employees.Add(new Employee { Id = 1014, Name = "Agent 8", Role = "Agent", ContractHours = 30.0, WorkPattern = "Fri,Sat,Sun,Mon" }); string queryInitialise = "INSERT INTO EmployeeTable (Id, Name, Role, ContractHours, WorkPattern) " + "VALUES (@Id, @Name, @Role, @ContractHours, @WorkPattern);"; conn.Execute(queryInitialise, employees); } GetStatuses(employees, AbsenceController.GetAbsencesStatic(date)); return(employees); } catch (Exception ex) { System.Diagnostics.Debug.WriteLine(ex); return(new List <Employee>()); } } }