Exemplo n.º 1
0
 private void GridView_SelectionChanged(object sender, SelectionChangedEventArgs e)
 {
     DAO.Manga manga = (sender as GridView).SelectedItem as DAO.Manga;
     if (manga != null)
     {
         Frame.Navigate(typeof(MangaPage), manga.Id);
     }
 }
Exemplo n.º 2
0
 public async Task <bool> UpdateMangaChapterAsync(Manga manga)
 {
     using (SqliteConnection db = new SqliteConnection(App.APP_DB_STRING))
     {
         db.Open();
         // TODO Code Goes Here
         db.Close();
     }
     throw new NotImplementedException();
 }
Exemplo n.º 3
0
        public async Task <List <Manga> > SearchMangaCategoryAsync(string category)
        {
            List <Manga> mangas = new List <Manga>();

            if (category == null)
            {
                return(mangas);
            }
            using (SqliteConnection db = new SqliteConnection(App.APP_DB_STRING))
            {
                db.Open();
                SqliteDataReader reader        = null;
                SqliteCommand    searchCommand = new SqliteCommand();
                searchCommand.Connection  = db;
                searchCommand.CommandText = "SELECT " + App.APP_MANGA_TABLE + ".manga_id, manga_title, alias, image_url, hits, last_chapter_date, " +
                                            "status FROM " + App.APP_MANGA_TABLE + " INNER JOIN " + App.APP_MANGA_CATEGORY_TABLE + " ON " + App.APP_MANGA_TABLE + ".manga_id = " +
                                            App.APP_MANGA_CATEGORY_TABLE + ".manga_id WHERE category = @CATEGORY ORDER BY hits DESC;";
                searchCommand.Parameters.AddWithValue("@CATEGORY", category);
                try
                {
                    reader = await searchCommand.ExecuteReaderAsync();
                }
                catch (SqliteException e)
                {
                    Debug.WriteLine(e.StackTrace);
                    Debug.WriteLine(e.TargetSite);
                }
                if (reader != null)
                {
                    while (reader.Read())
                    {
                        Manga manga = new Manga
                        {
                            Id    = reader.GetString(0),
                            Title = reader.GetString(1),
                            Alias = reader.GetString(2),
                            Hits  = reader.GetInt32(4),
                        };
                        if (!reader.IsDBNull(3))
                        {
                            manga.ImageString = reader.GetString(3);
                        }
                        if (!reader.IsDBNull(5))
                        {
                            manga.LastDate = reader.GetString(5);
                        }
                        mangas.Add(manga);
                    }
                }
                db.Close();
            }
            return(mangas);
        }
Exemplo n.º 4
0
        /// <summary>
        /// Method to perform an Update/Insert of a Manga Object.
        /// </summary>
        /// <param name="manga">Manga Object to be updated/inserted into DB.
        /// required to have ID, Title, Alias, and Status</param>
        /// <returns>True if sucess, False if an Error is encountered</returns>
        public async Task <bool> UpdateMangaAsync(Manga manga)
        {
            //Debug.WriteLine("UpdateMangaAsync - Begin");
            bool flag = true;

            if (manga.Id == null || manga.Title == null || manga.Alias == null || manga.Status == null)
            {
                flag = false;
                return(flag);
            }
            using (SqliteConnection db = new SqliteConnection(App.APP_DB_STRING))
            {
                db.Open();
                SqliteDataReader reader;
                SqliteCommand    existsCommand = new SqliteCommand();
                existsCommand.Connection = db;

                // EXISTS

                existsCommand.CommandText = "SELECT manga_id FROM " + App.APP_MANGA_TABLE + " WHERE manga_id = @ID";
                existsCommand.Parameters.AddWithValue("@ID", manga.Id);

                try
                {
                    reader = await existsCommand.ExecuteReaderAsync();
                }
                catch (SqliteException e)
                {
                    Debug.WriteLine(e.StackTrace);
                    Debug.WriteLine("UpdateMangaAsync - Exists");
                    flag = false;
                    db.Close();
                    return(flag);
                }
                bool update = false;
                while (await reader.ReadAsync())
                {
                    update = true;
                }
                //Debug.WriteLine("UpdateMangaAsync - Exists: " + update);
                //Debug.WriteLine("Last date: " + manga.LastDate + " | " + (manga.LastDate != null));

                // UPDATE/INSERT


                if (update)
                {
                    SqliteCommand updateCommand = new SqliteCommand();
                    updateCommand.Connection  = db;
                    updateCommand.CommandText = "UPDATE " + App.APP_MANGA_TABLE + " SET manga_title = @TITLE, alias = @ALIAS, status = @STATUS, last_chapter_date = @DATE, hits = @HITS, " +
                                                "image_url = @IMAGE WHERE manga_id = @ID;";
                    updateCommand.Parameters.AddWithValue("@TITLE", manga.Title);
                    updateCommand.Parameters.AddWithValue("@ALIAS", manga.Alias);
                    updateCommand.Parameters.AddWithValue("@STATUS", manga.Status);
                    if (manga.LastDate != null)
                    {
                        updateCommand.Parameters.AddWithValue("@DATE", manga.LastDate);
                    }
                    else
                    {
                        updateCommand.Parameters.AddWithValue("@DATE", DBNull.Value);
                    }
                    updateCommand.Parameters.AddWithValue("@HITS", manga.Hits);
                    updateCommand.Parameters.AddWithValue("@ID", manga.Id);
                    if (manga.ImageString != null)
                    {
                        updateCommand.Parameters.AddWithValue("@IMAGE", manga.ImageString);
                    }
                    else
                    {
                        updateCommand.Parameters.AddWithValue("@IMAGE", DBNull.Value);
                    }

                    //string query = "UPDATE " + App.APP_MANGA_TABLE + " SET manga_title = '" + manga.Title + "', alias = '" + manga.Alias +                // WORKS
                    //    "', status = '" + manga.Status + "', last_chapter_date = '" + manga.LastDate + "', hits = " + manga.Hits + " WHERE " +
                    //    "manga_id = '" + manga.Id + "';";
                    //SqliteCommand updateCommand = new SqliteCommand(query, db);

                    try
                    {
                        await updateCommand.ExecuteReaderAsync();
                    }
                    catch (SqliteException e)
                    {
                        Debug.WriteLine(e.StackTrace);
                        Debug.WriteLine("UpdateMangaAsync - Update");
                        flag = false;
                    }

                    //// Remove Existing categories

                    //SqliteCommand removeCommand = new SqliteCommand();
                    //removeCommand.Connection = db;
                    //removeCommand.CommandText = "DELETE FROM " + App.APP_MANGA_CATEGORY_TABLE + " WHERE manga_id = @ID;";
                    //removeCommand.Parameters.AddWithValue("@ID", manga.Id);
                    //try
                    //{
                    //    await removeCommand.ExecuteReaderAsync();
                    //}
                    //catch(SqliteException e)
                    //{
                    //    Debug.WriteLine(e.StackTrace);
                    //    Debug.WriteLine("UpdateMangaAsync - Remove Category");
                    //    flag = false;
                    //}

                    //// Manga Categories

                    //foreach (string category in manga.Categories)
                    //{
                    //    SqliteCommand categoryCommand = new SqliteCommand();
                    //    categoryCommand.Connection = db;

                    //    categoryCommand.CommandText = "INSERT INTO " + App.APP_MANGA_CATEGORY_TABLE + " (manga_id, category) VALUES " +
                    //        "(@ID, @CATEGORY);";
                    //    categoryCommand.Parameters.AddWithValue("@ID", manga.Id);
                    //    categoryCommand.Parameters.AddWithValue("@CATEGORY", category);
                    //    try
                    //    {
                    //        await categoryCommand.ExecuteReaderAsync();
                    //    }
                    //    catch (SqliteException e)
                    //    {
                    //        Debug.WriteLine(e.StackTrace);
                    //        Debug.WriteLine("UpdateMangaAsync - Category");
                    //        flag = false;
                    //    }
                    //}
                }
                else
                {
                    SqliteCommand insertCommand = new SqliteCommand();
                    insertCommand.Connection = db;

                    insertCommand.CommandText = "INSERT INTO " + App.APP_MANGA_TABLE + " (manga_id, manga_title, alias, status, last_chapter_date, hits, image_url) " +
                                                "VALUES (@ID, @TITLE, @ALIAS, @STATUS, @DATE, @HITS, @IMAGE);";
                    insertCommand.Parameters.AddWithValue("@ID", manga.Id);
                    insertCommand.Parameters.AddWithValue("@TITLE", manga.Title);
                    insertCommand.Parameters.AddWithValue("@ALIAS", manga.Alias);
                    insertCommand.Parameters.AddWithValue("@STATUS", manga.Status);
                    if (manga.LastDate != null)
                    {
                        insertCommand.Parameters.AddWithValue("@DATE", manga.LastDate);
                    }
                    else
                    {
                        insertCommand.Parameters.AddWithValue("@DATE", DBNull.Value);
                    }
                    insertCommand.Parameters.AddWithValue("@HITS", manga.Hits);
                    if (manga.ImageString != null)
                    {
                        insertCommand.Parameters.AddWithValue("@IMAGE", manga.ImageString);
                    }
                    else
                    {
                        insertCommand.Parameters.AddWithValue("@IMAGE", DBNull.Value);
                    }

                    try
                    {
                        await insertCommand.ExecuteReaderAsync();
                    }
                    catch (SqliteException e)
                    {
                        Debug.WriteLine(e.StackTrace);
                        Debug.WriteLine("UpdateMangaAsync - Insert");
                        flag = false;
                    }

                    // Manga Categories

                    foreach (string category in manga.Categories)
                    {
                        SqliteCommand categoryCommand = new SqliteCommand();
                        categoryCommand.Connection = db;

                        categoryCommand.CommandText = "INSERT INTO " + App.APP_MANGA_CATEGORY_TABLE + " (manga_id, category) VALUES " +
                                                      "(@ID, @CATEGORY);";
                        categoryCommand.Parameters.AddWithValue("@ID", manga.Id);
                        categoryCommand.Parameters.AddWithValue("@CATEGORY", category);
                        try
                        {
                            await categoryCommand.ExecuteReaderAsync();
                        }
                        catch (SqliteException e)
                        {
                            Debug.WriteLine(e.StackTrace);
                            Debug.WriteLine("UpdateMangaAsync - Category");
                            flag = false;
                        }
                    }
                }
                db.Close();
                //Debug.WriteLine("UpdateMangaAsync: " + flag + " | Update: " + update);
            }
            return(flag);
        }
Exemplo n.º 5
0
        public async Task <bool> CreateMangaAsync(Manga manga)
        {
            bool flag = true;

            if (manga.Title == null || manga.Id == null || manga.Alias == null || manga.Status == null)
            {
                flag = false;
                return(flag);
            }
            using (SqliteConnection db = new SqliteConnection(App.APP_DB_STRING))
            {
                db.Open();

                SqliteCommand command = new SqliteCommand();
                command.Connection = db;

                command.CommandText = "INSERT INTO " + App.APP_MANGA_TABLE + " (manga_id, manga_title, alias, status, last_chapter_date, hits, image_url) " +
                                      "VALUES (@ID, @TITLE, @ALIAS, @STATUS, @DATE, @HITS, @IMAGE);";
                command.Parameters.AddWithValue("@ID", manga.Id);
                command.Parameters.AddWithValue("@TITLE", manga.Title);
                command.Parameters.AddWithValue("@ALIAS", manga.Alias);
                command.Parameters.AddWithValue("@STATUS", manga.Status);
                if (manga.LastDate != null)
                {
                    command.Parameters.AddWithValue("@DATE", manga.LastDate);
                }
                else
                {
                    command.Parameters.AddWithValue("@DATE", DBNull.Value);
                }
                command.Parameters.AddWithValue("@HITS", manga.Hits);
                if (manga.ImageString != null)
                {
                    command.Parameters.AddWithValue("@IMAGE", manga.ImageString);
                }
                else
                {
                    command.Parameters.AddWithValue("@IMAGE", DBNull.Value);
                }

                try
                {
                    await command.ExecuteReaderAsync();
                }
                catch (SqliteException e)
                {
                    Debug.WriteLine(e.StackTrace);
                    Debug.WriteLine("CreateMangaAsync");
                    flag = false;
                }

                // Manga Categories

                foreach (string category in manga.Categories)
                {
                    SqliteCommand categoryCommand = new SqliteCommand();
                    categoryCommand.Connection = db;

                    categoryCommand.CommandText = "INSERT INTO " + App.APP_MANGA_CATEGORY_TABLE + " (manga_id, category) VALUES " +
                                                  "(@ID, @CATEGORY);";
                    categoryCommand.Parameters.AddWithValue("@ID", manga.Id);
                    categoryCommand.Parameters.AddWithValue("@CATEGORY", category);
                    try
                    {
                        await categoryCommand.ExecuteReaderAsync();
                    }
                    catch (SqliteException e)
                    {
                        Debug.WriteLine(e.StackTrace);
                        Debug.WriteLine("CreateMangaAsync - Category");
                        flag = false;
                    }
                }

                db.Close();
                Debug.WriteLine("CreateMangaAsync: " + flag);
            }
            return(flag);
        }
Exemplo n.º 6
0
        /// <summary>
        ///
        /// </summary>
        /// <param name="title"></param>
        /// <returns>List of Manga</returns>
        public async Task <List <Manga> > SearchMangaAsync(string title)
        {
            Debug.WriteLine("Begin search");
            List <Manga> mangas = new List <Manga>();

            title = Sanitize.SanitizeString(title);
            if (title == null)
            {
                return(mangas);
            }
            using (SqliteConnection db = new SqliteConnection(App.APP_DB_STRING))
            {
                db.Open();
                SqliteDataReader reader        = null;
                SqliteCommand    searchCommand = new SqliteCommand
                {
                    Connection  = db,
                    CommandText = "SELECT manga_id, manga_title, alias, image_url, hits, last_chapter_date, " +
                                  "status FROM " + App.APP_MANGA_TABLE + " WHERE manga_title LIKE '%" + title + "%' COLLATE NOCASE ORDER BY hits DESC;"
                };
                //searchCommand.Parameters.AddWithValue("@TITLE", title);
                try
                {
                    reader = await searchCommand.ExecuteReaderAsync();
                }
                catch (SqliteException e)
                {
                    Debug.WriteLine(e.StackTrace);
                    Debug.WriteLine("SearchMangaAsync");
                }

                if (reader != null)
                {
                    Debug.WriteLine("Reader found something");
                    while (reader.Read())
                    {
                        Debug.WriteLine("read: " + reader.GetString(0));
                        Manga manga = new Manga
                        {
                            Id    = reader.GetString(0),
                            Title = reader.GetString(1),
                            Alias = reader.GetString(2),
                            Hits  = reader.GetInt32(4),
                        };
                        if (!reader.IsDBNull(3))
                        {
                            manga.ImageString = reader.GetString(3);
                        }
                        if (!reader.IsDBNull(5))
                        {
                            manga.LastDate = reader.GetString(5);
                        }
                        mangas.Add(manga);
                    }
                }
                else
                {
                    Debug.WriteLine("Reader null");
                }

                db.Close();
            }
            return(mangas);
        }
Exemplo n.º 7
0
 private void MangaResultList_SelectionChanged(object sender, SelectionChangedEventArgs e)
 {
     DAO.Manga manga = ((DAO.Manga)((ListView)sender).SelectedItem);
     Frame.Navigate(typeof(MangaPage), manga.Id);
 }