/// <summary> /// This is the method that provide Paging mechanism using stored procedure but current not imilimented /// </summary> /// <param name="searchValue"></param> /// <param name="CurrentPage"></param> /// <param name="PageSize"></param> /// <param name="TotalRows"></param> /// <returns></returns> public List <CompanyVM> GetList(string searchValue, int CurrentPage, int PageSize, out int TotalRows) { List <CompanyVM> list = new List <CompanyVM>(); try { using (CMS_DbEntities db = new CMS_DbEntities()) { List <SpCompany> companies = new List <SpCompany>(); companies = db.UserSP_GetCompany(searchValue, 1, 10, "Name", "ASC").ToList(); TotalRows = (companies.Count() > 0) ? (companies.FirstOrDefault().MaxRows ?? 0) : 0; foreach (SpCompany company in companies) { list.Add(converter.ConvertToModel(company)); } } } catch (Exception ex) { // We can add a error logger to record all exception throw; } return(list); }