/// <summary> /// Отобразить содержимое локальной БД /// </summary> /// <returns></returns> public ChannelsSetsList GetDataFromDB() { ChannelsSetsList setsList = new ChannelsSetsList(); SQLiteDatabase db; try { db = ReadableDatabase; } catch (Exception) { ClearDatabase(); return(setsList); } // Работа с сетами ICursor allSets = db.RawQuery("SELECT * FROM " + SETS_TABLE_NAME, null); if (allSets.MoveToFirst()) { String[] columnNames = allSets.GetColumnNames(); do { // Проходимся по каждому сету в таблице сетов и создаем новый объект сета var a = allSets.GetString(allSets.GetColumnIndex(columnNames[0])); setsList.AddSet(new ChannelsSet(allSets.GetString(allSets.GetColumnIndex(columnNames[1])))); } while (allSets.MoveToNext()); } // Работа с каналами ICursor allChannels = db.RawQuery("SELECT * FROM " + CHANNELS_TABLE_NAME, null); if (allChannels.MoveToFirst()) { String[] columnNames = allChannels.GetColumnNames(); do { // Проходимся по каждому каналу в таблице каналов var channelName = allChannels.GetString(allChannels.GetColumnIndex(columnNames[1])); var channelPlatform = allChannels.GetString(allChannels.GetColumnIndex(columnNames[2])); var channelSetIndex = allChannels.GetString(allChannels.GetColumnIndex(columnNames[3])); Channel channel = new Channel(channelName, (DATA.Platforms)Int32.Parse(channelPlatform)); setsList.AddChannel(channel, Int32.Parse(channelSetIndex) - 1); } while (allChannels.MoveToNext()); } return(setsList); }
public override View OnCreateView(LayoutInflater inflater, ViewGroup container, Bundle savedInstanceState) { // Use this to return your custom view for this Fragment view = inflater.Inflate(Resource.Layout.FragmentEditSetLayout, container, false); _currentSetIndex = ((MainActivity)Activity).SelectedSetIndex; _setList = ((MainActivity)Activity).SetsList; editSetRecyclerView = (RecyclerView)view.FindViewById(Resource.Id.editSet_recyclerView); editSetAdapter = new Adapters.EditSetRecyclerViewAdapter(Activity, _setList); editSetRecyclerView.SetLayoutManager(new LinearLayoutManager(context)); editSetAdapter.ItemClick += EditSetAdapter_ItemClick; editSetAdapter.ItemLongClick += EditSetAdapter_ItemLongClick; editSetRecyclerView.SetAdapter(editSetAdapter); return(view); }
private void InitChannelsSets() { SETS_LIST = new ChannelsSetsList(); SETS_LIST = dbHandler.GetDataFromDB(); }