public IEnumerable <Employee> SearchItem(string searchItem, SearchStyleEnum searchStyle)
{
const string query = @"SELECT e.Id, e.EmpNum
, p.Id PersonId, [Lastname], [Firstname], [Middlename], [MiddleInitial], [NameExtension], [MaidenMiddlename], [Gender]
from person p inner join Employee e on p.Id = e.PersonId
where Replace(DBO.FULLNAME(LASTNAME, FIRSTNAME, MIDDLENAME, MiddleInitial, 0, NAMEEXTENSION),' ','') like @Criteria";
var results = Search.SearchData <dynamic>(searchItem, query, searchStyle);
var itemCollection = new List <Employee>();
foreach (var result in results)
{
var item = new Employee();
item.DataMapper.Map(result);
item.PersonClass.DataMapper.Map(result);
item.PersonClass.Id = result.PersonId;
item.StartTrackingChanges();
itemCollection.Add(item);
}
return(itemCollection);
}
public Employee GetBasicProfileOf(int employeeId)
{
const string query = "select p.Id PersonId, [Lastname], [Firstname], [Middlename], [MiddleInitial], [NameExtension], [MaidenMiddlename], [Gender], CameraCounter, " +
" e.Id, EmpNum from Employee e inner join Person p on p.Id = e.PersonId " +
" where e.Id = @Id";
using (var db = Connection.CreateConnection())
{
db.Open();
var result = db.Query(query, new { Id = employeeId }).FirstOrDefault();
if (result == null)
{
return(null);
}
var employee = new Employee();
employee.DataMapper.Map(result);
employee.PersonClass.DataMapper.Map(result);
employee.StartTrackingChanges();
return(employee);
}
}
public Employee GetItemOf(int id, SqlConnection db)
{
const string query = @"select e.*
, p.Id PersonId, [Lastname], [Firstname], [Middlename], [MiddleInitial], [NameExtension], [MaidenMiddlename], BirthDate, [Gender], [CameraCounter]
from employee e
inner join person p on e.PersonId = p.Id
where e.Id = @EmployeeId";
dynamic record = db.Query(query, new { EmployeeId = id }).FirstOrDefault();
var item = new Employee();
item.DataMapper.Map(record);
item.PersonClass.DataMapper.Map(record);
item.PersonClass.DataMapper.Map(_ => _.Id, (int)record.PersonId);
item.RowStatus = RecordStatus.NoChanges;
item.StartTrackingChanges();
return(item);
}
