public static List <EmployeeCommanModal> GetSalesDirector(SearchModal Obj) { using (var context = new SalesReturndbEntities()) { var list = context.SP_GetEmployeeForBU_Division_Country(Obj.BUName, Obj.DivisionName, Obj.CountryName).ToList(); List <EmployeeCommanModal> empList = null; if (list != null) { empList = list.Select(x => new EmployeeCommanModal() { EmployeeCode = x.EMP_CODE, EmployeeName = x.Emp_First_name, }).ToList(); return(empList); } return(empList); } }