public List <tbl_DeptLeaveRequest> GetAutoCompleteList(string search) { try { DALBase obj = new DALBase(_config); List <tbl_DeptLeaveRequest> listObj = new List <tbl_DeptLeaveRequest>(); DataSet ds = obj.GetAutoCompleteList(ConstantStoredProcedure.SP_BCL_GETEMPLOYEENAMEDEPT, search); DataTable dt = ds.Tables[0]; if (dt.Rows.Count > 0) { foreach (DataRow dtRow in dt.Rows) { string[] vals = dtRow["EmpNameId"].ToString().Split('_'); var EmpID = Convert.ToString(vals[0]); var EmpName = Convert.ToString(vals[1]); var objAutoId = new tbl_DeptLeaveRequest(); objAutoId.EmployeeID = EmpID; objAutoId.EmployeeName = EmpName; listObj.Add(objAutoId); } } return(listObj); } catch (Exception ex) { throw ex; } }
public List <string> GetAutoCompleteList(string search) { try { DALBase obj = new DALBase(_config); List <string> listObj = new List <string>(); DataSet ds = obj.GetAutoCompleteList(ConstantStoredProcedure.SP_BCL_GETEMPLOYEENAME, search); DataTable dt = ds.Tables[0]; if (dt.Rows.Count > 0) { foreach (DataRow dtRow in dt.Rows) { var EmpName = dtRow["EmpNameId"].ToString(); listObj.Add(EmpName); } } return(listObj); } catch (Exception ex) { throw ex; } }