using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;

using System.IO;

namespace FileUploader_TEST
{
    public partial class Form1 : Form
    {
        string _folder;

        public Form1()
        {
            InitializeComponent();

            _folder = "c:\\";
        }

        private void button1_Click(object sender, EventArgs e)
        {
            _folder = (System.IO.Directory.Exists(_folder)) ? _folder : "";


            var dlg1 = new OpenFileDialog();
            dlg1.InitialDirectory = _folder;

            DialogResult result = dlg1.ShowDialog();

            if(result.Equals(System.Windows.Forms.DialogResult.OK))
            {
                textBox1.Text = dlg1.FileName;
            }
        }

        private void button2_Click(object sender, EventArgs e)
        {
            upload(textBox1.Text);
        }

        void upload(string strFileName)
        {
            MySql.Data.MySqlClient.MySqlConnection conn;
            MySql.Data.MySqlClient.MySqlCommand cmd;
            conn = new MySql.Data.MySqlClient.MySqlConnection();
            cmd = new MySql.Data.MySqlClient.MySqlCommand();
            string SQL;
            int FileSize;
            byte[] rawData;
            FileStream fs;
            conn.ConnectionString = "server=10.10.3.45;uid=root;"
                + "pwd=ruben;database=test;";
            try
            {
                fs = new FileStream(strFileName, FileMode.Open, FileAccess.Read);
                FileSize = (int)fs.Length;
                rawData = new byte[FileSize];
                fs.Read(rawData, 0, FileSize);
                fs.Close();
                conn.Open();

                SQL = "INSERT INTO file VALUES(NULL, @FileName, @FileSize, @File)";
                cmd.Connection = conn;
                cmd.CommandText = SQL;
                cmd.Parameters.AddWithValue("@FileName", strFileName);
                cmd.Parameters.AddWithValue("@FileSize", FileSize);
                cmd.Parameters.AddWithValue("@File", rawData);
                cmd.ExecuteNonQuery();

                MessageBox.Show("File Inserted into database successfully!", "Success!", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);

                conn.Close();
            } catch(MySql.Data.MySqlClient.MySqlException ex)
            {
                MessageBox.Show("Error " + ex.Number + " has occurred: " + ex.Message,
                "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
            }
        }
    }
}