private List<DeleteStructure> LoadAllDeleteLists() { try { int userId = 0; List<DeleteStructure> deleteStructureList = new List<DeleteStructure>(); int i = 0; string connectionString = ConfigurationSettings.AppSettings["fleetnetbaseConnectionString"]; DataBlock dataBlock = new DataBlock(connectionString, ConfigurationManager.AppSettings["language"]); DeleteStructure deleteStructureTemp; List<int> dataBlockIds = new List<int>(); dataBlock.OpenConnection(); dataBlockIds = dataBlock.GetAllParsedDataBlockIDs(userId); foreach (int dataBlockId in dataBlockIds) { i++; deleteStructureTemp = new DeleteStructure(); deleteStructureTemp.dataBlockId = dataBlockId; deleteStructureTemp.number = i; deleteStructureTemp.name = dataBlock.GetDriversNameOrVehiclesNumberByBlockId(dataBlockId); deleteStructureTemp.cardTypeName = dataBlock.GetCardTypeName(dataBlockId); deleteStructureTemp.recordsCount = dataBlock.GetDataBlock_RecorsCount(dataBlockId); deleteStructureTemp.createTime = dataBlock.GetDataBlock_EDate(dataBlockId); deleteStructureTemp.dataBlockState = dataBlock.GetDataBlockState(dataBlockId); deleteStructureList.Add(deleteStructureTemp); } if (dataBlockIds.Count == 0) Status.Text = "Нет записей для отображения"; AddGrid.DataSource = CreateDeleteDataSource(deleteStructureList); AddGrid.DataBind(); dataBlock.CloseConnection(); return deleteStructureList; } catch (Exception ex) { Status.Text = "Произошла ошибка: " + ex.Message + " Возможо просто нету данных в БД. Исправление в след. версии"; return null; } finally { } }