public List<Employee> GetAllEmployees()
{
EmployeeSortByEmpCode employeeSortByEmpCode = new EmployeeSortByEmpCode();
var employeeList = context.Query<Employee>().Where(employee =>employee.IsActive==true).ToList();
employeeList.Sort(employeeSortByEmpCode);
return employeeList;
}
public List <Employee> GetAllEmployees()
{
var context = _commonMapper.GetCommonDataBAseContext();
EmployeeSortByEmpCode employeeSortByEmpCode = new EmployeeSortByEmpCode();
var userList = context.Query <User>();
var employeeList = new List <Employee>();
foreach (var user in userList)
{
employeeList.Add(_commonMapper.MapBasicPropertiesOfUserToEmployee(user));
}
// employeeList = AttachTitleToEmployee(employeeList);
employeeList.Sort(employeeSortByEmpCode);
return(employeeList);
}
public List<Employee> GetEmployeeByName(string name)
{
EmployeeSortByEmpCode employeeSortByEmpCode = new EmployeeSortByEmpCode();
List<Employee> employeeList = new List<Employee>();
if (name != null)
{
string _name = name.Trim().ToLower();
employeeList = context.Query<Employee>().Where(employee=> employee.IsActive== true).ToList()
.Where((e => e.FullName.ToLower().Contains(_name))).ToList();
if (employeeList.Count == 0)
{
var empList = context.Query<Employee>().ToList()
.Where((e => e.EmployeeCode.ToString().ToLower().Contains(_name))).Where(employee => employee.IsActive == true).ToList();
empList.Sort(employeeSortByEmpCode);
return empList;
}
}
employeeList.Sort(employeeSortByEmpCode);
return employeeList;
}
//public List<Employee> GetEmployeeByName(string name)
//{
// EmployeeSortByEmpCode employeeSortByEmpCode = new EmployeeSortByEmpCode();
// List<Employee> employeeList = new List<Employee>();
// if (name != null)
// {
// string _name = name.Trim().ToLower();
// var usersByName = _commonMapper.GetCommonDataBAseContext().Query<User>().ToList().Where(u => u.DisplayName.Trim().ToLower().Contains(_name)).ToList();
// foreach (var user in usersByName)
// {
// employeeList.Add(_commonMapper.MapBasicPropertiesOfUserToEmployee(user));
// }
public List <Employee> GetEmployeeByName(string name)
{
EmployeeSortByEmpCode employeeSortByEmpCode = new EmployeeSortByEmpCode();
List <Employee> employeeList = new List <Employee>();
var context = _commonMapper.GetCommonDataBAseContext();
if (name != null)
{
string _name = name.Trim().ToLower();
var userList = context.Query <User>().Where((e => e.DisplayName.Trim().ToLower().Contains(_name))).ToList();
foreach (User user in userList)
{
employeeList.Add(_commonMapper.MapBasicPropertiesOfUserToEmployee(user));
}
employeeList = employeeList.Where(emp => emp.IsActive == true).ToList();
if (employeeList.Count == 0)
{
var empList = context.Query <User>().ToList()
.Where((e => e.UserName.ToString().ToLower().Contains(_name)));
foreach (User user in empList)
{
employeeList.Add(_commonMapper.MapBasicPropertiesOfUserToEmployee(user));
}
employeeList = employeeList.Where(emp => emp.IsActive == true).ToList();
employeeList.Sort(employeeSortByEmpCode);
return(employeeList);
}
}
employeeList.Sort(employeeSortByEmpCode);
return(employeeList);
}
