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