private void button2_Click(object sender, EventArgs e)
{
try
{
SQLiteDatabaseOperations sqliteDb = new SQLiteDatabaseOperations();
if (mode == 'a')
{
if (textBox1.Text.ToString().Length < 1)
{
MessageBox.Show("Name can not be blank");
return;
}
sqliteDb.SaveImgSndRecord(img_arr1, snd_arr1, textBox1.Text);
}
if (mode == 'e')
{
sqliteDb.UpdateImgSndRecord(img_arr1, snd_arr1, listBox1.SelectedItem.ToString());
}
if (mode == 'd')
{
sqliteDb.DeleteImgSndRecord(listBox1.SelectedItem.ToString());
}
listBox1.DataSource = getKeys();
resetScreen();
resetVariables();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
resetScreen();
resetVariables();
}
}
static void Main()
{
Application.EnableVisualStyles();
Application.SetCompatibleTextRenderingDefault(false);
SQLiteDatabaseOperations db = new SQLiteDatabaseOperations();
Application.Run(new Form1());
}
private void ArrayToSound()
{
if (listBox1.SelectedItem.ToString().Length > 0)
{
SQLiteDatabaseOperations sdb = new SQLiteDatabaseOperations();
snd_arr1 = sdb.getSound(listBox1.SelectedItem.ToString());
}
}
private void ArrayToImage()
{
if (listBox1.SelectedItem != null && listBox1.SelectedItem.ToString().Length > 0)
{
SQLiteDatabaseOperations sdb = new SQLiteDatabaseOperations();
byte[] img_arr1 = sdb.getImage(listBox1.SelectedItem.ToString());
if (img_arr1 != null)
{
MemoryStream ms1 = new MemoryStream(img_arr1);
ms1.Seek(0, SeekOrigin.Begin);
System.Drawing.Image image = System.Drawing.Image.FromStream(ms1);
pictureBox1.Image = image;
}
else
{
textBox4.Text = "No image file stored.";
}
}
}
private List <string> getKeys()
{
SQLiteDatabaseOperations sqlop = new SQLiteDatabaseOperations();
return(sqlop.getKeys());
}
