public IList <SearchApplicant_Result> SearchApplicant(string searchText, string status, string company, string experience, string createdBy, string salary, string location, string industry, string days, int?startRecord, int?pageLimit, out int totalRecord) { List <SearchApplicant_Result> searchResultList; //ObjectResult<SearchApplicant_Result> candidateResults = null; dynamic candidateResults; try { ObjectParameter Output = new ObjectParameter("TotalRecord", typeof(Int32)); using (var context = new apptrackEntities()) { candidateResults = context.SearchApplicant(searchText, status, company, experience, createdBy, salary, location, industry, days, startRecord, pageLimit, Output).ToList(); searchResultList = ConvertToSearchResultList(candidateResults); totalRecord = Output.Value == DBNull.Value ? 0 : Convert.ToInt32(Output.Value); } return(searchResultList); } catch (Exception ex) { throw; } }
public virtual async Task <IEnumerable <SearchApplicant_Result> > SearchApplicantAsync(string searchText, string status, string company, string experience, string createdBy, string salary, string location, string industry, string days, int?startRecord, int?pageLimit, int totalRecord) { dynamic result = null; try { ObjectParameter Output = new ObjectParameter("TotalRecord", typeof(Int32)); using (var context = new apptrackEntities()) { await Task.Run(() => { result = context.SearchApplicant(searchText, status, company, experience, createdBy, salary, location, industry, days, startRecord, pageLimit, Output).ToList(); }); totalRecord = Convert.ToInt32(Output.Value); } return(result); } catch (Exception) { throw; } }