GetGroupDescriptions() public method

public GetGroupDescriptions ( string connectionString, int startIndex, int pageSize, System sortedColumns, int &totalRecordCount, int &searchRecordCount, string searchString ) : List
connectionString string
startIndex int
pageSize int
sortedColumns System
totalRecordCount int
searchRecordCount int
searchString string
return List
GroupDescriptionsRepository Class Documentation
Beispiel #1
0
        public JsonResult GroupDescriptionSearch(JQueryDataTablesModel jQueryDataTablesModel, string identifier)
        {
            int totalRecordCount;
            int searchRecordCount;

            //Get Connection string
            var entityConnectionString = HydroServerToolsUtils.BuildConnectionStringForUserName(HttpContext.User.Identity.Name);
            //var entityConnectionString = HydroServerToolsUtils.GetDBEntityConnectionStringByName(connectionName);

            if (String.IsNullOrEmpty(entityConnectionString))
            {
                ModelState.AddModelError(String.Empty, Ressources.HYDROSERVER_USERLOOKUP_FAILED);

            }

            var repository = new GroupDescriptionsRepository();
            var items = repository.GetGroupDescriptions(entityConnectionString, startIndex: jQueryDataTablesModel.iDisplayStart,
                pageSize: jQueryDataTablesModel.iDisplayLength, sortedColumns: jQueryDataTablesModel.GetSortedColumns(),
                totalRecordCount: out totalRecordCount, searchRecordCount: out searchRecordCount, searchString: jQueryDataTablesModel.sSearch);

            var result = from c in items
                         select new[] {
                            c.GroupID,
                            c.GroupDescription
                };

            return this.DataTablesJson(items: result,
                totalRecords: totalRecordCount,
                totalDisplayRecords: searchRecordCount,
                sEcho: jQueryDataTablesModel.sEcho);
        }