public List <JobPostViewModel> GetBulkJobSearchList(int CompanyId, string FY, string statecode, string citycode) { DataTable dt = _userProcessor.GetBulkJobSearchList(CompanyId, FY, statecode, citycode); List <JobPostViewModel> JobPostDetails = new List <JobPostViewModel>(); for (int i = 0; i < dt.Rows.Count; i++) { JobPostViewModel jobPost = new JobPostViewModel { JobPostId = Convert.ToInt32(dt.Rows[i]["JobPostId"]), Country = Convert.ToString(dt.Rows[i]["Country"]), City = Convert.ToString(dt.Rows[i]["City"]), State = Convert.ToString(dt.Rows[i]["State"]), JobTypeSummary = Convert.ToString(dt.Rows[i]["JobTypeSummary"]), JobDetails = Convert.ToString(dt.Rows[i]["JobDetails"]), CTC = Convert.ToString(dt.Rows[i]["CTC"]), CompanyName = Convert.ToString(dt.Rows[i]["CompanyName"]), PostedOn = Convert.ToDateTime(dt.Rows[i]["PostedOn"]), JobTitleByEmployer = Convert.ToString(dt.Rows[i]["JobTitleByEmployer"]) }; JobPostDetails.Add(jobPost); } return(JobPostDetails); }