jeudi 16 août 2018

UWP - Display database in listview with certain conditions

I have a database called "Tryout.sqlite". I want to display the sqlite in a listview. If the user clicks on "kelas 7", then the one displayed in the listview has only "kelas 7" questions. Database: Database

Code:

string path;
SQLite.Net.SQLiteConnection conn;
List<DBName> DB_TryoutList = new List<DBName>();

kelasDetail = e.ClickedItem as Kelas;
path = Path.Combine(Windows.Storage.ApplicationData.Current.LocalFolder.Path, "Tryout.sqlite");
conn = new SQLite.Net.SQLiteConnection(new SQLite.Net.Platform.WinRT.SQLitePlatformWinRT(), path);

if (kelasDetail.KelasList == "Kelas 7")
{
    DB_TryoutList.Clear();
    var query = conn.Table<DBName>();
    string name = "";

    foreach (var message in query)
    {
        if (message.Judul.ToLower().Contains("kelas 7 -") || message.Judul.ToLower().Contains("kelas 7-"))
        {
            name = message.Judul;

            this.DB_TryoutList.Add(new DBName { ID = message.ID, Judul = name, Deskripsi = message.Deskripsi, Durasi = message.Durasi, JumlahSoal = message.JumlahSoal, Syarat = message.Syarat });
        }
     }
}

else if (kelasDetail.KelasList == "Kelas 9")
{
    DB_TryoutList.Clear();
    var query = conn.Table<DBName>();
    string name = "";

    foreach (var message in query)
    {
        if (message.Judul.ToLower().Contains("kelas 9 -") || message.Judul.ToLower().Contains("kelas 9-"))
        {
            name = message.Judul;

            this.DB_TryoutList.Add(new DBName { ID = message.ID, Judul = name, Deskripsi = message.Deskripsi, Durasi = message.Durasi, JumlahSoal = message.JumlahSoal, Syarat = message.Syarat });
        }
    }
}

if (DB_TryoutList.Count > 0)
{
    ListTryout.Visibility = Visibility.Visible;
    this.ListTryout.ItemsSource = DB_TryoutList;
}

I have a problem, which is when I click "kelas 7", the problem shown is "kelas 7", and after that I click "kelas 9", the problem is displayed as still in "kelas 7" (as shown below) Picture 1 Picture 2 How to handle it?

Aucun commentaire:

Enregistrer un commentaire