public MenuViewList GetAllMenuListData(MenuFilterModel model, int Userid = 0, int OrganizationId = 0) { MenuViewList list = new MenuViewList(); ObjectParameter totalRecords = new ObjectParameter("TotalRecords", typeof(int)); var data = base.RepositoryContext.SP_GetAllMenuListData(model.PageNo, model.PageSize, model.SortColumn, model.SortOrder, model.TitleFilter, model.HrefFilter, model.RouterFilter, model.ParentMenuFilter, OrganizationId, totalRecords).ToList(); list.GetAllMenuListDataViewResult = Mapper.Map <List <SP_GetAllMenuListData_Result>, List <GetAllMenuListDataViewResult> >(data); list.TotalRecords = Convert.ToInt32(totalRecords.Value); return(list); }
public static MenuViewList GetList(IWhere whereClause, IOrderBy orderByClause) { SqlDataReader dataReader = GetListReader(DatabaseEnum.INTRANET, TABLE, whereClause, orderByClause, true); MenuViewList list = new MenuViewList(); while (dataReader.Read()) { list.Add(GetDataObjectFromReader(dataReader)); } dataReader.Close(); return(list); }