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);
        }