public static List <EmployeeViewModel> SearchStringEmployeeName(string prefix)
        {
            List <EmployeeViewModel> result = new List <EmployeeViewModel>();

            try
            {
                using (MarkomApplicationDBEntities db = new MarkomApplicationDBEntities())
                {
                    var res = db.spEmployeeName(prefix);

                    List <EmployeeViewModel> comList = res.Select(c => new EmployeeViewModel
                    {
                        id       = c.id,
                        fullName = c.first_name + ' ' + c.last_name
                    }).ToList();

                    result = comList;
                }
            }
            catch (Exception ex)
            {
                Message = ex.Message;
            }
            return(result);
        }