private void ShowSaved() { imageListView1.ShowCheckBoxes = false; var db = new SqLiteDatabase(); var query = "SELECT * FROM arts_" + _seriesId; try { var dt = db.GetDataTable(query); imageListView1.Items.Clear(); for (var i = 0; i < dt.Rows.Count; i++) { DataRow drow = dt.Rows[i]; var img1 = new ImageListViewItem {FileName = @drow["image"].ToString()}; imageListView1.Items.AddRange(new[] { img1 }); } } catch(Exception e){ Console.WriteLine(e.Message); var createTable = "CREATE TABLE " + "arts_" + _seriesId + "(" + "_id" + " INTEGER PRIMARY KEY," + "image" + " TEXT" + ")"; var adb = new ArtsDatabaseEntry( "res/" + _seriesName + "_banner.jpg"); var adb2 = new ArtsDatabaseEntry("res/" + _seriesName + "_poster.jpg"); var adb3 = new ArtsDatabaseEntry( "res/" + _seriesName + "_fanart.jpg"); try { db.CreateTable(createTable); db.InsertArts(adb, "arts_" + _seriesId); db.InsertArts(adb2, "arts_" + _seriesId); db.InsertArts(adb3, "arts_" + _seriesId); ShowSaved(); } catch (Exception crap) { MessageBox.Show(crap.Message); } } }
private void save_Click(object sender, EventArgs e) { Cursor = Cursors.WaitCursor; var db = new SqLiteDatabase(); foreach(var i in imageListView1.CheckedItems){ File.Copy(i.FileName, @"res/"+Path.GetFileName(i.FileName)); try{ db.InsertArts(new ArtsDatabaseEntry("res/" + Path.GetFileName(i.FileName)), "arts_" + _seriesId); } catch(Exception ex){ MessageBox.Show(ex.Message); } } ShowSaved(); Cursor = Cursors.Default; }