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;
            }
        }
Example #2
0
        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;
            }
        }