MySQL settings

10 files changed, 597 insertions, 22 deletions

diff --git a/kurier/Form1.Designer.cs b/kurier/Form1.Designer.cs
index 1193d9e..41ac97b 100644
--- a/kurier/Form1.Designer.cs
+++ b/kurier/Form1.Designer.cs
@@ -92,6 +92,7 @@
             this.bSettings.Size = new System.Drawing.Size(70, 70);
             this.bSettings.TabIndex = 5;
             this.bSettings.UseVisualStyleBackColor = true;
+            this.bSettings.Click += new System.EventHandler(this.bSettings_Click);
             // 
             // bSave
             // 
@@ -119,6 +120,7 @@
             this.MinimizeBox = false;
             this.Name = "Form1";
             this.Text = "KurierSQL";
+            this.Load += new System.EventHandler(this.Form1_Load);
             this.ResumeLayout(false);
             this.PerformLayout();
 
diff --git a/kurier/Form1.cs b/kurier/Form1.cs
index 5da317b..eb6ab88 100644
--- a/kurier/Form1.cs
+++ b/kurier/Form1.cs
@@ -24,5 +24,16 @@ namespace kurier
         {
             this.tBucketID.Enabled = this.cSend.Checked;
         }
+
+        private void Form1_Load(object sender, EventArgs e)
+        {
+            if (!MySQL.getConfigured()) (new MysqlSettings()).ShowDialog();
+            if (!MySQL.getConfigured()) this.Dispose();
+        }
+
+        private void bSettings_Click(object sender, EventArgs e)
+        {
+            (new MysqlSettings()).ShowDialog();
+        }
     }
 }
diff --git a/kurier/MySQL.cs b/kurier/MySQL.cs
new file mode 100644
index 0000000..cafb5c8
--- /dev/null
+++ b/kurier/MySQL.cs
@@ -0,0 +1,70 @@
+using System;
+using System.Collections.Generic;
+using System.Text;
+using MySql.Data.MySqlClient;
+
+namespace kurier
+{
+    public class MySQL
+    {
+        private MySqlConnection conn;
+        private string database;
+
+        public MySQL(string database)
+        {
+            this.database = database;
+            connect();
+        }
+
+        public void connect()
+        {
+            conn = new MySqlConnection((database != "" ? ("Database=" + database + ";") : "")
+                + "Data Source=" + getHost() + ";User Id=" + getUser() + ";Password=" + getPass() 
+                + ";Port=" + getPort() + ";charset=utf8;");
+
+            conn.Open();
+        }
+
+        public void close()
+        {
+            try
+            {
+                conn.Close();
+                conn = null;
+            }
+            catch (Exception)
+            {
+            }
+        }
+
+        public bool isOpen()
+        {
+            return conn != null;
+        }
+
+        public static string test()
+        {
+            try
+            {
+                MySqlConnection conn = new MySqlConnection("Data Source=" + getHost() + ";User Id=" + getUser() + ";Password=" + getPass()
+                + ";Port=" + getPort() + ";charset=utf8;");
+                conn.Open();
+            }
+            catch (MySqlException e)
+            {
+                return e.Message;
+            }
+            catch (Exception e)
+            {
+                return "Prawdopodobnie brakuje Ci dll-ki od MySQL'a.\n\n" + e.Message;
+            }
+            return "";
+        }
+
+        public static string getHost() { return Properties.Settings.Default.HOST; }
+        public static string getUser() { return Properties.Settings.Default.USER; }
+        public static string getPass() { return Properties.Settings.Default.PASS; }
+        public static string getPort() { return Properties.Settings.Default.PORT; }
+        public static bool getConfigured() { return Properties.Settings.Default.CONFIGURED; }
+    }
+}
diff --git a/kurier/MysqlSettings.Designer.cs b/kurier/MysqlSettings.Designer.cs
new file mode 100644
index 0000000..41cd176
--- /dev/null
+++ b/kurier/MysqlSettings.Designer.cs
@@ -0,0 +1,107 @@
+namespace kurier
+{
+    partial class MysqlSettings
+    {
+        /// <summary>
+        /// Required designer variable.
+        /// </summary>
+        private System.ComponentModel.IContainer components = null;
+
+        /// <summary>
+        /// Clean up any resources being used.
+        /// </summary>
+        /// <param name="disposing">true if managed resources should be disposed; otherwise, false.</param>
+        protected override void Dispose(bool disposing)
+        {
+            if (disposing && (components != null))
+            {
+                components.Dispose();
+            }
+            base.Dispose(disposing);
+        }
+
+        #region Windows Form Designer generated code
+
+        /// <summary>
+        /// Required method for Designer support - do not modify
+        /// the contents of this method with the code editor.
+        /// </summary>
+        private void InitializeComponent()
+        {
+            System.ComponentModel.ComponentResourceManager resources = new System.ComponentModel.ComponentResourceManager(typeof(MysqlSettings));
+            this.eHost = new System.Windows.Forms.TextBox();
+            this.eUser = new System.Windows.Forms.TextBox();
+            this.ePass = new System.Windows.Forms.TextBox();
+            this.ePort = new System.Windows.Forms.TextBox();
+            this.bOk = new System.Windows.Forms.Button();
+            this.SuspendLayout();
+            // 
+            // eHost
+            // 
+            this.eHost.Location = new System.Drawing.Point(12, 12);
+            this.eHost.Name = "eHost";
+            this.eHost.Size = new System.Drawing.Size(100, 20);
+            this.eHost.TabIndex = 0;
+            // 
+            // eUser
+            // 
+            this.eUser.Location = new System.Drawing.Point(12, 38);
+            this.eUser.Name = "eUser";
+            this.eUser.Size = new System.Drawing.Size(100, 20);
+            this.eUser.TabIndex = 1;
+            // 
+            // ePass
+            // 
+            this.ePass.Location = new System.Drawing.Point(12, 64);
+            this.ePass.Name = "ePass";
+            this.ePass.PasswordChar = '*';
+            this.ePass.Size = new System.Drawing.Size(100, 20);
+            this.ePass.TabIndex = 2;
+            // 
+            // ePort
+            // 
+            this.ePort.Location = new System.Drawing.Point(12, 90);
+            this.ePort.Name = "ePort";
+            this.ePort.Size = new System.Drawing.Size(100, 20);
+            this.ePort.TabIndex = 3;
+            // 
+            // bOk
+            // 
+            this.bOk.Location = new System.Drawing.Point(12, 116);
+            this.bOk.Name = "bOk";
+            this.bOk.Size = new System.Drawing.Size(100, 23);
+            this.bOk.TabIndex = 4;
+            this.bOk.Text = "OK";
+            this.bOk.UseVisualStyleBackColor = true;
+            this.bOk.Click += new System.EventHandler(this.button1_Click);
+            // 
+            // MysqlSettings
+            // 
+            this.AcceptButton = this.bOk;
+            this.AutoScaleDimensions = new System.Drawing.SizeF(6F, 13F);
+            this.AutoScaleMode = System.Windows.Forms.AutoScaleMode.Font;
+            this.ClientSize = new System.Drawing.Size(124, 147);
+            this.Controls.Add(this.bOk);
+            this.Controls.Add(this.ePort);
+            this.Controls.Add(this.ePass);
+            this.Controls.Add(this.eUser);
+            this.Controls.Add(this.eHost);
+            this.FormBorderStyle = System.Windows.Forms.FormBorderStyle.FixedToolWindow;
+            this.Icon = ((System.Drawing.Icon)(resources.GetObject("$this.Icon")));
+            this.Name = "MysqlSettings";
+            this.Text = "Ustawienia MySQL";
+            this.Load += new System.EventHandler(this.MysqlSettings_Load);
+            this.ResumeLayout(false);
+            this.PerformLayout();
+
+        }
+
+        #endregion
+
+        private System.Windows.Forms.TextBox eHost;
+        private System.Windows.Forms.TextBox eUser;
+        private System.Windows.Forms.TextBox ePass;
+        private System.Windows.Forms.TextBox ePort;
+        private System.Windows.Forms.Button bOk;
+    }
+}
\ No newline at end of file
diff --git a/kurier/MysqlSettings.cs b/kurier/MysqlSettings.cs
new file mode 100644
index 0000000..01b1b08
--- /dev/null
+++ b/kurier/MysqlSettings.cs
@@ -0,0 +1,46 @@
+using System;
+using System.Collections.Generic;
+using System.ComponentModel;
+using System.Data;
+using System.Drawing;
+using System.Text;
+using System.Windows.Forms;
+
+namespace kurier
+{
+    public partial class MysqlSettings : Form
+    {
+        public MysqlSettings()
+        {
+            InitializeComponent();
+        }
+
+        private void MysqlSettings_Load(object sender, EventArgs e)
+        {
+            eHost.Text = Properties.Settings.Default.HOST;
+            eUser.Text = Properties.Settings.Default.USER;
+            ePass.Text = Properties.Settings.Default.PASS;
+            ePort.Text = Properties.Settings.Default.PORT;
+        }
+
+        private void button1_Click(object sender, EventArgs e)
+        {
+            Properties.Settings.Default.HOST = eHost.Text;
+            Properties.Settings.Default.USER = eUser.Text;
+            Properties.Settings.Default.PASS = ePass.Text;
+            Properties.Settings.Default.PORT = ePort.Text;
+
+            string msg = MySQL.test();
+            if (msg == "")
+            {
+                Properties.Settings.Default.CONFIGURED = true;
+                Properties.Settings.Default.Save();
+                Close();
+            }
+            else
+            {
+                MessageBox.Show(msg, "Nieprawidłowe ustawienia", MessageBoxButtons.OK, MessageBoxIcon.Stop);
+            }
+        }
+    }
+}
diff --git a/kurier/MysqlSettings.resx b/kurier/MysqlSettings.resx
new file mode 100644
index 0000000..14a4aab
--- /dev/null
+++ b/kurier/MysqlSettings.resx
@@ -0,0 +1,197 @@
+<?xml version="1.0" encoding="utf-8"?>
+<root>
+  <!-- 
+    Microsoft ResX Schema 
+    
+    Version 2.0
+    
+    The primary goals of this format is to allow a simple XML format 
+    that is mostly human readable. The generation and parsing of the 
+    various data types are done through the TypeConverter classes 
+    associated with the data types.
+    
+    Example:
+    
+    ... ado.net/XML headers & schema ...
+    <resheader name="resmimetype">text/microsoft-resx</resheader>
+    <resheader name="version">2.0</resheader>
+    <resheader name="reader">System.Resources.ResXResourceReader, System.Windows.Forms, ...</resheader>
+    <resheader name="writer">System.Resources.ResXResourceWriter, System.Windows.Forms, ...</resheader>
+    <data name="Name1"><value>this is my long string</value><comment>this is a comment</comment></data>
+    <data name="Color1" type="System.Drawing.Color, System.Drawing">Blue</data>
+    <data name="Bitmap1" mimetype="application/x-microsoft.net.object.binary.base64">
+        <value>[base64 mime encoded serialized .NET Framework object]</value>
+    </data>
+    <data name="Icon1" type="System.Drawing.Icon, System.Drawing" mimetype="application/x-microsoft.net.object.bytearray.base64">
+        <value>[base64 mime encoded string representing a byte array form of the .NET Framework object]</value>
+        <comment>This is a comment</comment>
+    </data>
+                
+    There are any number of "resheader" rows that contain simple 
+    name/value pairs.
+    
+    Each data row contains a name, and value. The row also contains a 
+    type or mimetype. Type corresponds to a .NET class that support 
+    text/value conversion through the TypeConverter architecture. 
+    Classes that don't support this are serialized and stored with the 
+    mimetype set.
+    
+    The mimetype is used for serialized objects, and tells the 
+    ResXResourceReader how to depersist the object. This is currently not 
+    extensible. For a given mimetype the value must be set accordingly:
+    
+    Note - application/x-microsoft.net.object.binary.base64 is the format 
+    that the ResXResourceWriter will generate, however the reader can 
+    read any of the formats listed below.
+    
+    mimetype: application/x-microsoft.net.object.binary.base64
+    value   : The object must be serialized with 
+            : System.Runtime.Serialization.Formatters.Binary.BinaryFormatter
+            : and then encoded with base64 encoding.
+    
+    mimetype: application/x-microsoft.net.object.soap.base64
+    value   : The object must be serialized with 
+            : System.Runtime.Serialization.Formatters.Soap.SoapFormatter
+            : and then encoded with base64 encoding.
+
+    mimetype: application/x-microsoft.net.object.bytearray.base64
+    value   : The object must be serialized into a byte array 
+            : using a System.ComponentModel.TypeConverter
+            : and then encoded with base64 encoding.
+    -->
+  <xsd:schema id="root" xmlns="" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata">
+    <xsd:import namespace="http://www.w3.org/XML/1998/namespace" />
+    <xsd:element name="root" msdata:IsDataSet="true">
+      <xsd:complexType>
+        <xsd:choice maxOccurs="unbounded">
+          <xsd:element name="metadata">
+            <xsd:complexType>
+              <xsd:sequence>
+                <xsd:element name="value" type="xsd:string" minOccurs="0" />
+              </xsd:sequence>
+              <xsd:attribute name="name" use="required" type="xsd:string" />
+              <xsd:attribute name="type" type="xsd:string" />
+              <xsd:attribute name="mimetype" type="xsd:string" />
+              <xsd:attribute ref="xml:space" />
+            </xsd:complexType>
+          </xsd:element>
+          <xsd:element name="assembly">
+            <xsd:complexType>
+              <xsd:attribute name="alias" type="xsd:string" />
+              <xsd:attribute name="name" type="xsd:string" />
+            </xsd:complexType>
+          </xsd:element>
+          <xsd:element name="data">
+            <xsd:complexType>
+              <xsd:sequence>
+                <xsd:element name="value" type="xsd:string" minOccurs="0" msdata:Ordinal="1" />
+                <xsd:element name="comment" type="xsd:string" minOccurs="0" msdata:Ordinal="2" />
+              </xsd:sequence>
+              <xsd:attribute name="name" type="xsd:string" use="required" msdata:Ordinal="1" />
+              <xsd:attribute name="type" type="xsd:string" msdata:Ordinal="3" />
+              <xsd:attribute name="mimetype" type="xsd:string" msdata:Ordinal="4" />
+              <xsd:attribute ref="xml:space" />
+            </xsd:complexType>
+          </xsd:element>
+          <xsd:element name="resheader">
+            <xsd:complexType>
+              <xsd:sequence>
+                <xsd:element name="value" type="xsd:string" minOccurs="0" msdata:Ordinal="1" />
+              </xsd:sequence>
+              <xsd:attribute name="name" type="xsd:string" use="required" />
+            </xsd:complexType>
+          </xsd:element>
+        </xsd:choice>
+      </xsd:complexType>
+    </xsd:element>
+  </xsd:schema>
+  <resheader name="resmimetype">
+    <value>text/microsoft-resx</value>
+  </resheader>
+  <resheader name="version">
+    <value>2.0</value>
+  </resheader>
+  <resheader name="reader">
+    <value>System.Resources.ResXResourceReader, System.Windows.Forms, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089</value>
+  </resheader>
+  <resheader name="writer">
+    <value>System.Resources.ResXResourceWriter, System.Windows.Forms, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089</value>
+  </resheader>
+  <assembly alias="System.Drawing" name="System.Drawing, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" />
+  <data name="$this.Icon" type="System.Drawing.Icon, System.Drawing" mimetype="application/x-microsoft.net.object.bytearray.base64">
+    <value>
+        AAABAAEAICAAAAEAIACoEAAAFgAAACgAAAAgAAAAQAAAAAEAIAAAAAAAgBAAAAAAAAAAAAAAAAAAAAAA
+        AAD19fUAgIGBAGFncgBjaXYAY2l1AGNpdQBjaXUAYmh1AF9mdQBrb3UCeHp4And4dwBzcnQAcGtyAG5o
+        cABtZ3AAbWdwAG5ocABwa3IAdHJ1AHh4dwB4eXgCbm9xAWhpagBqamwAamttAGprbQBqa20Aa2xuAGZn
+        aQCFhYYA+/v7AOvr7AAcGRUAUDMAAF4+AQBbPAAAWzwAAFg6AABePgABcE0AATokAAAAAAAAAQAADQAF
+        ADYOIgZfHjwRfiVHFo0kRxaMHTsQfAwgBF0ABAAzAAABCwEAAAAsIxIAR0ArAjw0IQE6MR4AOzMgADsz
+        IAA9NSIAMSoYACYmJAD09fUA6OnsACklGQDprA0A/8EVAP68FAD+uhQA/8cWAfe6FQF/UQYAHRoHJS9P
+        I4Bcl0LPdcFV+YDTXf+D2GD/hNlh/4TZYP+B113/fNFa/3G+UvdXkz/LLEofehYWEiBMRksAnJyZAaSk
+        oQGbmpgAnpyaAKCenACWlJMAOTk5APDw8ADo6ewAJiEWANyaCQD3rhEA7KYPAP+4EgK7ggsAFAkADhU6
+        HX1krEvrgdVd/3/RXP56ylj/d8VW/XfEVvx2xFX8c8JR/HLCUfx0xFP9d8lW/3zRWf5901r/YKdE5xk2
+        DnUMCA8LcXBzAJWWlgKIiIkAjY6OAIOEhAA1NTUA8fHxAOjp7AAmIRYA4J0JAPauEQD/uxICpXEJAAEG
+        BChKhjvGhtld/3zNWv52xFb8dsVW/HfGVv54x1j/d8ZV/3PEUf9zxFH/dMVS/3TFUv90xVP+dMRT/HPD
+        U/x6zVj+gNdd/0Z9ML0DBQIhZmNnAJmamAKNjY0Ah4eHADU1NQDx8fEA6OnsACYhFwDcmQkA/74TAqt1
+        CQAEDgg0ZKpJ4oXYXv91w1b7d8VW/XjHV/94x1f/ecdY/3bGVP9zxFH/c8RR/3PEUf9zxFH/dMVS/3TF
+        Uv90xVP/dcZU/3TEU/1zwlL7gdhd/12gQdoGDAQramdrAJmamAKEhIQANTU1APHx8QDo6ewAJB8WAOij
+        CgLYmA4ADxEGJmKpSuGC1V3/dcJV+3jHV/94x1f/ecdY/3nHWf90xVL/ccNO/3PEUP90xFL/dMRS/3TE
+        Uv90xFL/dcVT/3XFU/91xlT/dcZU/3XGVP9ywVL7f9Vc/1ufQNgNEAwdgoGCAIuLigE0NDQA8fHxAOjp
+        7AAlIBcB6KQKAEMtAwdHhTzBhdhe/3XCVft4x1f/eMdX/3fHVv90xlP/bsNL/2vCR/9twkn/bsJK/27C
+        S/9ww03/cMNN/3DDTf9ww03/ccRO/3HETv90xVL/dcZU/3XGVP9ywVL7gdhd/0R7LbUqJisBjY6NADQ0
+        NAHx8fEA5ObsADYvGQOLWgAAKk0jdoPYXf92w1X7eMdX/3jHV/94x1f/ecdY/3fEV/90w1P/dcRU/3bE
+        VP92xFX/dsVV/3fFVv94xVf/d8VX/3jGWP94xlj/esda/3TFUv90xVL/dcZU/3XGVP9zw1P7ftVa/yZD
+        GWhYVFsAPj89A+/v7wDn6ewBKSIWACkiAhlosk/nfMxZ/3fGVv54x1f/echZ/3HET/+Y1H//9/v2//H4
+        7v/y+e//8vnv//L57//y+e//8fnu//H57//y+e//8vnv//L57//y+e//gspk/2/DTP91xlT/dcZU/3TE
+        U/16zlj/YKdD3iIlIRA5OTkA8PDwAe7w7gQOCRAAL1IfdYLWXv92w1b7eMdX/3jHV/95x1j/dMVS/43Q
+        cf/J6bz/xOe2/8Xnt//F57f/xee3/8bnuP/G6Lj/xOe2/8Lms//C5rT/w+a1/8PmtP98yFz/ccNO/3XF
+        U/90xVL/dcZU/3PDU/x91Fr/KEcbZh0YHwD3+PYE7e3tABMREwBZmD7Jf9Fc/3fFVv14x1f/eMdX/3jH
+        V/94x1j/dsZU/3DETf9wxE3/cMRN/3DETf9xxE//bMJI/2vCR/9rwUb/Z79C/2m/RP9qwEX/a8BH/3LE
+        UP9zxFH/c8RR/3TFUv90xVL/c8NT/H3SWv9OijW8GxgcAPf49wHp5uoAJC8gJXC+T/l6yVn/eMdX/njH
+        V/94x1f/eMdX/3jHV/95x1j/eshZ/3rIWf96yFn/fMlc/3LFUP+O0HL/gspj/2fAQf90xVL/csRP/3PE
+        UP90xVL/c8RR/3PEUf9zxFH/c8RR/3TFUv90xFL+eMpW/2e1SPEqMSYa8/H0AOXg5wA5Ui9Pec1W/3jG
+        V/x4x1f/eMdX/3jHV/94x1f/eMdX/3jHV/94x1f/eMdX/3rIWv9xxE//h81q/+n25P/m9OD/eMVY/2bA
+        Qf9yxFD/cMNN/3HDTv9yxFD/c8RR/3PEUf9zxFH/c8RR/3TFUv91xVP9c8dQ/z1RNEHv6/EA493mAEls
+        OnB70Fj/d8VX+3jHV/94x1f/eMdX/3jHV/94x1f/eMdX/3jHV/96yFr/ccRP/4jOa//m9eH/8fnu//L6
+        7//k897/ecVY/2fAQf9yxFD/cMNN/3HDTv9yw0//c8RR/3PEUf9zxFH/c8RR/3bFVfx5zVX/TGo/Ye3o
+        8ADj3eYAUHdAgXzRWP93xVf7eMdX/3jHV/94x1f/eMdX/3jHV/94x1f/esha/3HET/+Izmv/5vXg//P6
+        8P/s9+j/7Pfn//T78f/k897/ecVY/2fAQf9yxFD/cMNN/3HDTv9yxE//c8RR/3PEUf91xVT/eMVX+3nO
+        Vv9TdUVx7efvAOPd5gBQd0CAfNFY/3fFV/t4x1f/eMdX/3jHV/94x1f/eMdX/3nIWf9wxE3/h81q/+X0
+        3v/y+u//7Pfo/+746v/u+Or/7Pfn//P68P/i8tv/d8RW/2S/P/9xxE7/cMNN/3HDTv9xw0//dsZU/3jH
+        V/94xVf7ec5W/1N1RXHt5+8A493mAEpuO2580Vj/d8VX+3jHV/94x1f/eMdX/3jHV/95x1j/dMVT/5DR
+        df/t+On/+v35/+/46//u+Or/7vjq/+746v/u+Or/7/nr//3//P/s9uj/gspk/2rBRf9wxE3/b8NM/3XF
+        U/94x1f/eMdX/3jGV/t5zVX/TWxAX+3n8ADk3+cAO1UxS3rOV/94xlf8eMdX/3jHV/94x1f/eMdX/3fH
+        Vv96yFr/wOWw/9Dsxf/G57j/4fPa//D57f/t+On/7fjp//H67v/e79b/vd+u/8nmvf+336b/bsNL/23D
+        Sv91xVP/ecdY/3jHV/94x1f/eMdY/XbJU/8/VDY97+rxAOjl6QAnMyIgc8FR+HnJWP94x1f+eMdX/3jH
+        V/94x1f/eMdX/3nHWP90xVL/csRQ/2rBRf/B5bL/9vv0/+z36P/s9+f/+P32/7bcpv9VtSz/Y709/2a/
+        QP9uw0v/dMVS/3nHWP94x1f/eMdX/3jGV/57y1n/bLhM8Cw0KBbz8fQA7e3sARQTFQBbnEPGf9Fb/3fF
+        Vv14x1f/eMdX/3jHV/94x1f/eMdX/3nHWP97yVv/ccVP/8Tntv/2+/T/7Pfo/+z35//4/Pb/uuCr/2K9
+        O/9yxE//bsNL/3TGU/95x1j/eMdX/3jHV/94x1f/d8VW/H/SXP9Xkj64HxwgAPb39gLp7O4EJBgQAF92
+        KW960l//eMVV+3jHV/94x1f/eMdX/3jHV/94x1f/eMdX/3rIWf9wxE3/w+a1//b79P/s9+j/7Pfn//j9
+        9v+636r/Xrs3/27DSf90xVL/ecdY/3jHV/94x1f/eMdX/3jHV/93xFb8ftNa/0VjNmAoIyoA9PX0BOXo
+        7AExJxUAo3sOE2y4VuR8y1j/d8ZX/njHV/94x1f/eMdX/3jHV/94x1f/eshZ/3DETf/E5rb/9/v1/+33
+        6f/t9+j/+f33/7reqv9eujf/d8dV/3nHWP94x1f/eMdX/3jHV/94x1f/d8ZX/XzNWf9ts1HaNjo5Ci4t
+        LgDz8/IB6OnsACYjGAPhlgMAipY1bXHLXv96xlX6eMdX/3jHV/94x1f/eMdX/3jHV/96yFn/cMRO/8Lm
+        s//z+vH/6fbl/+n25P/0+/L/ud+p/2nARf97yVv/eMdX/3jHV/94x1f/eMdX/3jHV/94xVb7edBb/1Rv
+        QF9GPDgALC0rA/Pz8wDo6ewAJCAXAOWhCQHjnxAAcqlNunfNW/95xVb6eMdX/3jHV/94x1f/eMdX/3jH
+        V/93x1b/gcti/4fNaf+GzWj/hs1o/4fNaf+By2L/eMdW/3jHV/94x1f/eMdX/3jHV/94x1f/ecVV+nbN
+        XP92pkms3poSANaXCwIvKyEA8vP2AOjp7AAmIRYA3ZwKAf+0DwDLmRoZdLpZ3HfLWf96xlb7eMdX/3jH
+        V/94x1f/eMdX/3jHV/92xlX/dcZT/3XGU/91xlP/dcZT/3bGVf94x1f/eMdX/3jHV/94x1f/eMdX/3rG
+        Vfp2zFn/drdW0tGaFxH/tw8A35sHATArIQDx8/YA6OnsACYhFwDgnAkA+LETAv2tCwDQpCIker5b3XLK
+        Wf96xlX6ecdX/XjHV/94x1f/eMdX/3nHWP95x1j/ecdY/3nHWP95x1j/ecdY/3jHV/94x1f/eMdX/3nH
+        V/16xlX6ccpa/328WdTWpB4c/K4MAPixEwLdmgcAMCshAPLz9gDo6ewAJiEWAOCcCQD7sREA8q0RA/yt
+        CwDfpx4Xkb9WvXDKX/90xlX9esZV+3rHV/x4x1f+eMdX/3jHV/94x1f/eMdX/3jHV/94x1f/eMdX/nrH
+        V/x6xlX8dMZV/nDKX/+VvVOy46cbEfytCwDyrBEC+7ISAN2aBwAwKyEA8vP2AOjp7AApJBoA4J4NAPqy
+        FQD0rRQA868VAvqvEAH1rRgBwb5IaofMZulwy2L/cchb/nbIWf95yFn8eshZ+3rIWvt6yFr7eshZ+3nI
+        Wf12yFn/cchb/nDLYv+KzGXlxb1FYPesFgD5rxAC864VAvStFAD7sxYA3psLADMuJADy8/YA6OnsACYh
+        FQDflwAA+asBAPOmAAD0pwAA86cAAvSnAAP9pQAA8K0QEMS6NW2YwkrIfsRP+XLETv9vw0v/bsNK/27D
+        Sv9vw0z/c8RO/3/ET/eawkrEyLozZvKsDg38pQAA9KcAA/OnAAH0pwAA86YAAPqrAgDdlAAAMCsgAPLz
+        9gD09PYAlZKNAPDPhwD92YsA+deKAPrXigD614oA+teKAPjXiwP71YUB/9WEAP7ZkADw4KQd3Oa1Sszp
+        vGvF57d7xee3e83pvGnd5rRH8d+iGv7ZjwD/1IMA+9WGAfjXiwP614oA+teKAPrXigD514oA/dmLAO7O
+        hgCal5IA+Pn6AP///wD///8A////AP///wD///8A////AP///wD///8A////AP///wH+//8E/v//Av//
+        /wD///8A////AP///wD///8A////AP///wD///8A/v//Av7//wT///8B////AP///wD///8A////AP//
+        /wD///8A////AP///wD///8AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
+        AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
+        AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=
+</value>
+  </data>
+</root>
\ No newline at end of file
diff --git a/kurier/Properties/Settings.Designer.cs b/kurier/Properties/Settings.Designer.cs
index 4e8a361..6ba5ba7 100644
--- a/kurier/Properties/Settings.Designer.cs
+++ b/kurier/Properties/Settings.Designer.cs
@@ -8,23 +8,79 @@
 // </auto-generated>
 //------------------------------------------------------------------------------
 
-namespace kurier.Properties
-{
-
-
+namespace kurier.Properties {
+    
+    
     [global::System.Runtime.CompilerServices.CompilerGeneratedAttribute()]
     [global::System.CodeDom.Compiler.GeneratedCodeAttribute("Microsoft.VisualStudio.Editors.SettingsDesigner.SettingsSingleFileGenerator", "10.0.0.0")]
-    internal sealed partial class Settings : global::System.Configuration.ApplicationSettingsBase
-    {
-
+    internal sealed partial class Settings : global::System.Configuration.ApplicationSettingsBase {
+        
         private static Settings defaultInstance = ((Settings)(global::System.Configuration.ApplicationSettingsBase.Synchronized(new Settings())));
-
-        public static Settings Default
-        {
-            get
-            {
+        
+        public static Settings Default {
+            get {
                 return defaultInstance;
             }
         }
+        
+        [global::System.Configuration.UserScopedSettingAttribute()]
+        [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
+        [global::System.Configuration.DefaultSettingValueAttribute("localhost")]
+        public string HOST {
+            get {
+                return ((string)(this["HOST"]));
+            }
+            set {
+                this["HOST"] = value;
+            }
+        }
+        
+        [global::System.Configuration.UserScopedSettingAttribute()]
+        [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
+        [global::System.Configuration.DefaultSettingValueAttribute("3306")]
+        public string PORT {
+            get {
+                return ((string)(this["PORT"]));
+            }
+            set {
+                this["PORT"] = value;
+            }
+        }
+        
+        [global::System.Configuration.UserScopedSettingAttribute()]
+        [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
+        [global::System.Configuration.DefaultSettingValueAttribute("root")]
+        public string USER {
+            get {
+                return ((string)(this["USER"]));
+            }
+            set {
+                this["USER"] = value;
+            }
+        }
+        
+        [global::System.Configuration.UserScopedSettingAttribute()]
+        [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
+        [global::System.Configuration.DefaultSettingValueAttribute("")]
+        public string PASS {
+            get {
+                return ((string)(this["PASS"]));
+            }
+            set {
+                this["PASS"] = value;
+            }
+        }
+        
+        [global::System.Configuration.UserScopedSettingAttribute()]
+        [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
+        [global::System.Configuration.DefaultSettingValueAttribute("False")]
+        public bool CONFIGURED {
+            get {
+                return ((bool)(this["CONFIGURED"]));
+            }
+            set {
+                this["CONFIGURED"] = value;
+            }
+        }
     }
 }
diff --git a/kurier/Properties/Settings.settings b/kurier/Properties/Settings.settings
index 3964565..1749fb4 100644
--- a/kurier/Properties/Settings.settings
+++ b/kurier/Properties/Settings.settings
@@ -1,7 +1,21 @@
 <?xml version='1.0' encoding='utf-8'?>
-<SettingsFile xmlns="http://schemas.microsoft.com/VisualStudio/2004/01/settings" CurrentProfile="(Default)">
-  <Profiles>
-    <Profile Name="(Default)" />
-  </Profiles>
-  <Settings />
-</SettingsFile>
+<SettingsFile xmlns="http://schemas.microsoft.com/VisualStudio/2004/01/settings" CurrentProfile="(Default)" GeneratedClassNamespace="kurier.Properties" GeneratedClassName="Settings">
+  <Profiles />
+  <Settings>
+    <Setting Name="HOST" Type="System.String" Scope="User">
+      <Value Profile="(Default)">localhost</Value>
+    </Setting>
+    <Setting Name="PORT" Type="System.String" Scope="User">
+      <Value Profile="(Default)">3306</Value>
+    </Setting>
+    <Setting Name="USER" Type="System.String" Scope="User">
+      <Value Profile="(Default)">root</Value>
+    </Setting>
+    <Setting Name="PASS" Type="System.String" Scope="User">
+      <Value Profile="(Default)" />
+    </Setting>
+    <Setting Name="CONFIGURED" Type="System.Boolean" Scope="User">
+      <Value Profile="(Default)">False</Value>
+    </Setting>
+  </Settings>
+</SettingsFile>
\ No newline at end of file
diff --git a/kurier/app.config b/kurier/app.config
new file mode 100644
index 0000000..ffe99a0
--- /dev/null
+++ b/kurier/app.config
@@ -0,0 +1,27 @@
+<?xml version="1.0" encoding="utf-8" ?>
+<configuration>
+    <configSections>
+        <sectionGroup name="userSettings" type="System.Configuration.UserSettingsGroup, System, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" >
+            <section name="kurier.Properties.Settings" type="System.Configuration.ClientSettingsSection, System, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" allowExeDefinition="MachineToLocalUser" requirePermission="false" />
+        </sectionGroup>
+    </configSections>
+    <userSettings>
+        <kurier.Properties.Settings>
+            <setting name="HOST" serializeAs="String">
+                <value>localhost</value>
+            </setting>
+            <setting name="PORT" serializeAs="String">
+                <value>3306</value>
+            </setting>
+            <setting name="USER" serializeAs="String">
+                <value>root</value>
+            </setting>
+            <setting name="PASS" serializeAs="String">
+                <value />
+            </setting>
+            <setting name="CONFIGURED" serializeAs="String">
+                <value>False</value>
+            </setting>
+        </kurier.Properties.Settings>
+    </userSettings>
+</configuration>
\ No newline at end of file
diff --git a/kurier/kurier.csproj b/kurier/kurier.csproj
index dbdf4e7..b955ee2 100644
--- a/kurier/kurier.csproj
+++ b/kurier/kurier.csproj
@@ -13,6 +13,21 @@
     <TargetFrameworkVersion>v4.0</TargetFrameworkVersion>
     <TargetFrameworkProfile>Client</TargetFrameworkProfile>
     <FileAlignment>512</FileAlignment>
+    <PublishUrl>publish\</PublishUrl>
+    <Install>true</Install>
+    <InstallFrom>Disk</InstallFrom>
+    <UpdateEnabled>false</UpdateEnabled>
+    <UpdateMode>Foreground</UpdateMode>
+    <UpdateInterval>7</UpdateInterval>
+    <UpdateIntervalUnits>Days</UpdateIntervalUnits>
+    <UpdatePeriodically>false</UpdatePeriodically>
+    <UpdateRequired>false</UpdateRequired>
+    <MapFileExtensions>true</MapFileExtensions>
+    <ApplicationRevision>0</ApplicationRevision>
+    <ApplicationVersion>1.0.0.%2a</ApplicationVersion>
+    <IsWebBootstrapper>false</IsWebBootstrapper>
+    <UseApplicationTrust>false</UseApplicationTrust>
+    <BootstrapperEnabled>true</BootstrapperEnabled>
   </PropertyGroup>
   <PropertyGroup Condition=" '$(Configuration)|$(Platform)' == 'Debug|x86' ">
     <PlatformTarget>x86</PlatformTarget>
@@ -34,18 +49,15 @@
     <WarningLevel>4</WarningLevel>
   </PropertyGroup>
   <ItemGroup>
+    <Reference Include="MySql.Data, Version=6.9.7.0, Culture=neutral, PublicKeyToken=c5687fc88969c44d, processorArchitecture=MSIL" />
     <Reference Include="System">
       <HintPath>C:\Program Files (x86)\Reference Assemblies\Microsoft\Framework\.NETFramework\v4.0\Profile\Client\System.dll</HintPath>
     </Reference>
-    <Reference Include="System.Core" />
-    <Reference Include="System.Xml.Linq" />
     <Reference Include="System.Data.DataSetExtensions" />
-    <Reference Include="Microsoft.CSharp" />
     <Reference Include="System.Data" />
     <Reference Include="System.Deployment" />
     <Reference Include="System.Drawing" />
     <Reference Include="System.Windows.Forms" />
-    <Reference Include="System.Xml" />
   </ItemGroup>
   <ItemGroup>
     <Compile Include="Form1.cs">
@@ -54,16 +66,27 @@
     <Compile Include="Form1.Designer.cs">
       <DependentUpon>Form1.cs</DependentUpon>
     </Compile>
+    <Compile Include="MySQL.cs" />
+    <Compile Include="MysqlSettings.cs">
+      <SubType>Form</SubType>
+    </Compile>
+    <Compile Include="MysqlSettings.Designer.cs">
+      <DependentUpon>MysqlSettings.cs</DependentUpon>
+    </Compile>
     <Compile Include="Program.cs" />
     <Compile Include="Properties\AssemblyInfo.cs" />
     <EmbeddedResource Include="Form1.resx">
       <DependentUpon>Form1.cs</DependentUpon>
     </EmbeddedResource>
+    <EmbeddedResource Include="MysqlSettings.resx">
+      <DependentUpon>MysqlSettings.cs</DependentUpon>
+    </EmbeddedResource>
     <EmbeddedResource Include="Properties\Resources.resx">
       <Generator>ResXFileCodeGenerator</Generator>
       <SubType>Designer</SubType>
       <LastGenOutput>Resources.Designer.cs</LastGenOutput>
     </EmbeddedResource>
+    <None Include="app.config" />
     <None Include="Properties\Settings.settings">
       <Generator>SettingsSingleFileGenerator</Generator>
       <LastGenOutput>Settings.Designer.cs</LastGenOutput>
@@ -85,6 +108,28 @@
   <ItemGroup>
     <None Include="Resources\settings.png" />
   </ItemGroup>
+  <ItemGroup>
+    <BootstrapperPackage Include=".NETFramework,Version=v4.0,Profile=Client">
+      <Visible>False</Visible>
+      <ProductName>Microsoft .NET Framework 4 Client Profile %28x86 and x64%29</ProductName>
+      <Install>true</Install>
+    </BootstrapperPackage>
+    <BootstrapperPackage Include="Microsoft.Net.Client.3.5">
+      <Visible>False</Visible>
+      <ProductName>.NET Framework 3.5 SP1 Client Profile</ProductName>
+      <Install>false</Install>
+    </BootstrapperPackage>
+    <BootstrapperPackage Include="Microsoft.Net.Framework.3.5.SP1">
+      <Visible>False</Visible>
+      <ProductName>.NET Framework 3.5 SP1</ProductName>
+      <Install>false</Install>
+    </BootstrapperPackage>
+    <BootstrapperPackage Include="Microsoft.Windows.Installer.3.1">
+      <Visible>False</Visible>
+      <ProductName>Windows Installer 3.1</ProductName>
+      <Install>true</Install>
+    </BootstrapperPackage>
+  </ItemGroup>
   <Import Project="$(MSBuildToolsPath)\Microsoft.CSharp.targets" />
   <!-- To modify your build process, add your task inside one of the targets below and uncomment it. 
        Other similar extension points exist, see Microsoft.Common.targets.