|
public GetByManager ( int managerKey ) : IList |
||
| managerKey | int | |
| return | IList |
|
public IList<Employee> GetByManager(int managerKey)
{
using (var con = new SqlConnection(m_ConnectionString))
{
con.Open();
return con.Query<Employee>("SELECT e.EmployeeKey, e.FirstName, e.MiddleName, e.LastName, e.Title, e.ManagerKey, e.OfficePhone, e.CellPhone, e.CreatedDate FROM HR.Employee e WHERE e.ManagerKey = @ManagerKey", new { @ManagerKey = managerKey }).AsList();
}
}