public static List <EmployeeViewModel> GetListEmployee(string code, string fullName, int?mCompanyId, DateTime?createDate2, string createBy) { List <EmployeeViewModel> result = new List <EmployeeViewModel>(); using (var context = new MarkomApplicationDBEntities()) { var res = context.spEmployeeSearch(code, fullName, mCompanyId, createDate2, createBy); List <EmployeeViewModel> comList = res.Select(c => new EmployeeViewModel { id = c.id, code = c.employee_number, firstName = c.first_name, lastName = c.last_name, mCompanyId = c.m_company_id, companyName = c.name, createDate = c.create_date, createBy = c.create_by }).ToList(); result = comList; } return(result); }