public IList <EmployeeComplex> FindByLastName(string lastName)
{
const string sql = @"SELECT ed.EmployeeKey, ed.FirstName, ed.MiddleName, ed.LastName, ed.Title, ed.OfficePhone, ed.CellPhone, ed.EmployeeClassificationKey, ed.EmployeeClassificationName, ed.IsExempt, ed.IsEmployee FROM HR.EmployeeDetail ed WHERE ed.LastName = @LastName";
var settings = new ColumnMapSetting().WithSplitOnFor <EmployeeClassification>(e => e.EmployeeClassificationKey);
return(DbConnector.ReadToList <EmployeeComplex>(settings, sql, new { LastName = lastName }).Execute());
}
public EmployeeComplex?GetByKey(int employeeKey)
{
const string sql = @"SELECT ed.EmployeeKey, ed.FirstName, ed.MiddleName, ed.LastName, ed.Title, ed.OfficePhone, ed.CellPhone, ed.EmployeeClassificationKey, ed.EmployeeClassificationName, ed.IsExempt, ed.IsEmployee FROM HR.EmployeeDetail ed WHERE ed.EmployeeKey = @EmployeeKey";
//Configure Split map settings
var settings = new ColumnMapSetting().WithSplitOnFor <EmployeeClassification>(e => e.EmployeeClassificationKey);
return(DbConnector.ReadSingleOrDefault <EmployeeComplex>(settings, sql, new { EmployeeKey = employeeKey }).Execute());
}
public IList <EmployeeComplex> GetAll()
{
const string sql = @"SELECT ed.EmployeeKey, ed.FirstName, ed.MiddleName, ed.LastName, ed.Title, ed.OfficePhone, ed.CellPhone, ed.EmployeeClassificationKey, ed.EmployeeClassificationName, ed.IsExempt, ed.IsEmployee FROM HR.EmployeeDetail ed";
//Configure Split map settings
var settings = new ColumnMapSetting().WithSplitOnFor <EmployeeClassification>(e => e.EmployeeClassificationKey);
return(DbConnector.ReadToList <EmployeeComplex>(settings, sql).Execute());
}
