Ability to dump multiple databasesv1.0

6 files changed, 394 insertions, 34 deletions

diff --git a/spedytor/Form1.Designer.cs b/spedytor/Form1.Designer.cs
index f3c4f89..c86364b 100644
--- a/spedytor/Form1.Designer.cs
+++ b/spedytor/Form1.Designer.cs
@@ -31,7 +31,6 @@
             this.components = new System.ComponentModel.Container();
             System.ComponentModel.ComponentResourceManager resources = new System.ComponentModel.ComponentResourceManager(typeof(Form1));
             this.lChooseDatabase = new System.Windows.Forms.Label();
-            this.cbDatabaseName = new System.Windows.Forms.ComboBox();
             this.cSend = new System.Windows.Forms.CheckBox();
             this.nInterval = new System.Windows.Forms.NumericUpDown();
             this.label1 = new System.Windows.Forms.Label();
@@ -46,6 +45,7 @@
             this.notifyIcon = new System.Windows.Forms.NotifyIcon(this.components);
             this.contextMenuStrip = new System.Windows.Forms.ContextMenuStrip(this.components);
             this.closeMenuItem = new System.Windows.Forms.ToolStripMenuItem();
+            this.bSelectDBs = new System.Windows.Forms.Button();
             ((System.ComponentModel.ISupportInitialize)(this.nInterval)).BeginInit();
             this.contextMenuStrip.SuspendLayout();
             this.SuspendLayout();
@@ -55,18 +55,9 @@
             this.lChooseDatabase.AutoSize = true;
             this.lChooseDatabase.Location = new System.Drawing.Point(12, 11);
             this.lChooseDatabase.Name = "lChooseDatabase";
-            this.lChooseDatabase.Size = new System.Drawing.Size(34, 13);
+            this.lChooseDatabase.Size = new System.Drawing.Size(71, 13);
             this.lChooseDatabase.TabIndex = 0;
-            this.lChooseDatabase.Text = "Baza:";
-            // 
-            // cbDatabaseName
-            // 
-            this.cbDatabaseName.DropDownStyle = System.Windows.Forms.ComboBoxStyle.DropDownList;
-            this.cbDatabaseName.FormattingEnabled = true;
-            this.cbDatabaseName.Location = new System.Drawing.Point(52, 8);
-            this.cbDatabaseName.Name = "cbDatabaseName";
-            this.cbDatabaseName.Size = new System.Drawing.Size(186, 21);
-            this.cbDatabaseName.TabIndex = 1;
+            this.lChooseDatabase.Text = "Bazy danych:";
             // 
             // cSend
             // 
@@ -116,6 +107,7 @@
             // 
             // bTimer
             // 
+            this.bTimer.Enabled = false;
             this.bTimer.Image = global::spedytor.Properties.Resources.refresh;
             this.bTimer.Location = new System.Drawing.Point(153, 35);
             this.bTimer.Name = "bTimer";
@@ -152,6 +144,7 @@
             // 
             // bSave
             // 
+            this.bSave.Enabled = false;
             this.bSave.Image = global::spedytor.Properties.Resources.save;
             this.bSave.Location = new System.Drawing.Point(12, 35);
             this.bSave.Name = "bSave";
@@ -209,11 +202,22 @@
             this.closeMenuItem.Text = "Zakończ";
             this.closeMenuItem.Click += new System.EventHandler(this.closeMenuItem_Click);
             // 
+            // bSelectDBs
+            // 
+            this.bSelectDBs.Location = new System.Drawing.Point(89, 4);
+            this.bSelectDBs.Name = "bSelectDBs";
+            this.bSelectDBs.Size = new System.Drawing.Size(148, 23);
+            this.bSelectDBs.TabIndex = 12;
+            this.bSelectDBs.Text = "[nie wybrano]";
+            this.bSelectDBs.UseVisualStyleBackColor = true;
+            this.bSelectDBs.Click += new System.EventHandler(this.button1_Click);
+            // 
             // Form1
             // 
             this.AutoScaleDimensions = new System.Drawing.SizeF(6F, 13F);
             this.AutoScaleMode = System.Windows.Forms.AutoScaleMode.Font;
             this.ClientSize = new System.Drawing.Size(307, 208);
+            this.Controls.Add(this.bSelectDBs);
             this.Controls.Add(this.tbLog);
             this.Controls.Add(this.bToggleLog);
             this.Controls.Add(this.label1);
@@ -223,7 +227,6 @@
             this.Controls.Add(this.bSettings);
             this.Controls.Add(this.bSave);
             this.Controls.Add(this.cSend);
-            this.Controls.Add(this.cbDatabaseName);
             this.Controls.Add(this.lChooseDatabase);
             this.Icon = ((System.Drawing.Icon)(resources.GetObject("$this.Icon")));
             this.MaximizeBox = false;
@@ -243,7 +246,6 @@
         #endregion
 
         private System.Windows.Forms.Label lChooseDatabase;
-        private System.Windows.Forms.ComboBox cbDatabaseName;
         private System.Windows.Forms.CheckBox cSend;
         private System.Windows.Forms.Button bSave;
         private System.Windows.Forms.Button bSettings;
@@ -258,6 +260,7 @@
         private System.Windows.Forms.NotifyIcon notifyIcon;
         private System.Windows.Forms.ContextMenuStrip contextMenuStrip;
         private System.Windows.Forms.ToolStripMenuItem closeMenuItem;
+        private System.Windows.Forms.Button bSelectDBs;
     }
 }
 
diff --git a/spedytor/Form1.cs b/spedytor/Form1.cs
index c049af7..ac9cb43 100644
--- a/spedytor/Form1.cs
+++ b/spedytor/Form1.cs
@@ -14,10 +14,14 @@ namespace spedytor
     public partial class Form1 : Form
     {
         const string LOG_FILENAME = "spedytor.log";
+        private List<string> selectedDBs = new List<string>();
+        private dbWindow dbSelectionWindow = new dbWindow();
+        private int runningDumps = 0;
 
         public Form1()
         {
             InitializeComponent();
+            this.dbSelectionWindow.setParent(this);
         }
 
         private void bExit_Click(object sender, EventArgs e)
@@ -54,14 +58,20 @@ namespace spedytor
 
         internal void refreshDatabaseList()
         {
-            this.cbDatabaseName.Items.Clear();
+            this.dbSelectionWindow.lbDatabases.Items.Clear();
             MySQL c = new MySQL("");
             MySqlDataReader dbs = c.select("SELECT TABLE_SCHEMA FROM information_schema.COLUMNS GROUP BY TABLE_SCHEMA;");
+            int index = 0;
             while (dbs.Read())
             {
-                this.cbDatabaseName.Items.Add(dbs.GetString(0));
+                string dbName = dbs.GetString(0);
+                this.dbSelectionWindow.lbDatabases.Items.Add(dbName);
+                if (this.selectedDBs.IndexOf(dbName) > -1)
+                {
+                    this.dbSelectionWindow.lbDatabases.SelectedIndices.Add(index);
+                }
+                index++;
             }
-            this.cbDatabaseName.SelectedIndex = 0;
             dbs.Close();
         }
 
@@ -102,24 +112,24 @@ namespace spedytor
 
         private void bSave_Click(object sender, EventArgs e)
         {
-            this.setControlState(false, null);
             string directory = this.getDirectory();
             if (directory.Length > 0)
             {
-                string filePath = Path.Combine(directory, this.cbDatabaseName.SelectedItem.ToString() + DateTime.Now.ToString("-yyyyMMdd-HHmmss") + ".sql");
-                string dbName = this.cbDatabaseName.SelectedItem.ToString();
-                this.invokeSave(filePath, dbName);
-            }
-            else
-            {
-
-                this.setControlState(true, null);
-                return;
+                foreach (string dbName in this.selectedDBs)
+                {
+                    string filePath = Path.Combine(directory, dbName + DateTime.Now.ToString("-yyyyMMdd-HHmmss") + ".sql");
+                    this.invokeSave(filePath, dbName, true);
+                }
             }
         }
 
-        private void saveFile(string filePath, string dbName, string s3Bucket = null, bool enableControls = true)
+        private void saveFile(string filePath, string dbName, string s3Bucket = null, bool enableControls = false)
         {
+            if (enableControls && this.runningDumps == 0)
+            {
+                this.Invoke(new setStateDelegate(setControlState), new object[] { false, null });
+            }
+            this.runningDumps++;
             try
             {
                 MySQL c = new MySQL(dbName);
@@ -130,7 +140,7 @@ namespace spedytor
                 {
                     S3 s3Client = new S3();
                     s3Client.send(s3Bucket, filePath, dbName + ".sql");
-                    Logger.getLogger(this.tbLog, LOG_FILENAME).log("Wysłano!");
+                    Logger.getLogger(this.tbLog, LOG_FILENAME).log("Wysłano bazę danych: " + dbName + "!");
                 }
             }
             catch (Exception ex)
@@ -139,7 +149,8 @@ namespace spedytor
             }
             finally
             {
-                if (enableControls)
+                this.runningDumps--;
+                if (enableControls && this.runningDumps == 0)
                 {
                     this.Invoke(new setStateDelegate(setControlState), new object[] { true, null });
                 }
@@ -190,9 +201,11 @@ namespace spedytor
             }
             if (this.repeatFilePath.Length > 0)
             {
-                string filePath = Path.Combine(this.repeatFilePath, this.cbDatabaseName.SelectedItem.ToString() + DateTime.Now.ToString("-yyyyMMdd-HHmmss") + ".sql");
-                string dbName = this.cbDatabaseName.SelectedItem.ToString();
-                this.invokeSave(filePath, dbName, false);
+                foreach (string dbName in this.selectedDBs)
+                {
+                    string filePath = Path.Combine(this.repeatFilePath, dbName + DateTime.Now.ToString("-yyyyMMdd-HHmmss") + ".sql");
+                    this.invokeSave(filePath, dbName, false);
+                }
             }
             else
             {
@@ -256,5 +269,26 @@ namespace spedytor
         {
             this.bExit_Click(null, null);
         }
+
+        private void button1_Click(object sender, EventArgs e)
+        {
+            this.refreshDatabaseList();
+            this.dbSelectionWindow.ShowDialog();
+        }
+
+        internal void setSelectedDBs(List<string> selected)
+        {
+            this.selectedDBs = selected;
+            this.bSave.Enabled = this.bTimer.Enabled = (this.selectedDBs.Count > 0);
+            if (this.selectedDBs.Count == 0)
+            {
+                this.bSelectDBs.Text = "[nie wybrano]";
+            }
+            else
+            {
+                this.bSelectDBs.Text = String.Format("[wybrano: {0}]", this.selectedDBs.Count);
+            }
+        }
+
     }
 }
diff --git a/spedytor/dbWindow.Designer.cs b/spedytor/dbWindow.Designer.cs
new file mode 100644
index 0000000..b544a6a
--- /dev/null
+++ b/spedytor/dbWindow.Designer.cs
@@ -0,0 +1,75 @@
+namespace spedytor
+{
+    partial class dbWindow
+    {
+        /// <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(dbWindow));
+            this.bOK = new System.Windows.Forms.Button();
+            this.lbDatabases = new System.Windows.Forms.ListBox();
+            this.SuspendLayout();
+            // 
+            // bOK
+            // 
+            this.bOK.Location = new System.Drawing.Point(13, 220);
+            this.bOK.Name = "bOK";
+            this.bOK.Size = new System.Drawing.Size(259, 23);
+            this.bOK.TabIndex = 0;
+            this.bOK.Text = "OK";
+            this.bOK.UseVisualStyleBackColor = true;
+            this.bOK.Click += new System.EventHandler(this.bOK_Click);
+            // 
+            // lbDatabases
+            // 
+            this.lbDatabases.FormattingEnabled = true;
+            this.lbDatabases.Location = new System.Drawing.Point(13, 13);
+            this.lbDatabases.Name = "lbDatabases";
+            this.lbDatabases.SelectionMode = System.Windows.Forms.SelectionMode.MultiSimple;
+            this.lbDatabases.Size = new System.Drawing.Size(259, 199);
+            this.lbDatabases.TabIndex = 3;
+            // 
+            // dbWindow
+            // 
+            this.AutoScaleDimensions = new System.Drawing.SizeF(6F, 13F);
+            this.AutoScaleMode = System.Windows.Forms.AutoScaleMode.Font;
+            this.ClientSize = new System.Drawing.Size(284, 255);
+            this.Controls.Add(this.lbDatabases);
+            this.Controls.Add(this.bOK);
+            this.FormBorderStyle = System.Windows.Forms.FormBorderStyle.FixedToolWindow;
+            this.Icon = ((System.Drawing.Icon)(resources.GetObject("$this.Icon")));
+            this.Name = "dbWindow";
+            this.Text = "Wybór baz danych";
+            this.ResumeLayout(false);
+
+        }
+
+        #endregion
+
+        private System.Windows.Forms.Button bOK;
+        public System.Windows.Forms.ListBox lbDatabases;
+    }
+}
\ No newline at end of file
diff --git a/spedytor/dbWindow.cs b/spedytor/dbWindow.cs
new file mode 100644
index 0000000..3002075
--- /dev/null
+++ b/spedytor/dbWindow.cs
@@ -0,0 +1,41 @@
+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;
+
+namespace spedytor
+{
+    public partial class dbWindow : Form
+    {
+        private Form1 mainForm;
+
+        public dbWindow()
+        {
+            InitializeComponent();
+        }
+
+        public void setParent(Form1 parent)
+        {
+            this.mainForm = parent;
+        }
+
+        private void bOK_Click(object sender, EventArgs e)
+        {
+            if (this.mainForm != null)
+            {
+                List<string> selected = new List<string>();
+                foreach (int index in this.lbDatabases.SelectedIndices)
+                {
+                    selected.Add(this.lbDatabases.Items[index].ToString());
+                }
+                this.mainForm.setSelectedDBs(selected);
+            }
+            this.Close();
+        }
+
+    }
+}
diff --git a/spedytor/dbWindow.resx b/spedytor/dbWindow.resx
new file mode 100644
index 0000000..c473cfa
--- /dev/null
+++ b/spedytor/dbWindow.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=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089</value>
+  </resheader>
+  <resheader name="writer">
+    <value>System.Resources.ResXResourceWriter, System.Windows.Forms, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089</value>
+  </resheader>
+  <assembly alias="System.Drawing" name="System.Drawing, Version=2.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/spedytor/spedytor.csproj b/spedytor/spedytor.csproj
index 0d56b46..91afa2e 100644
--- a/spedytor/spedytor.csproj
+++ b/spedytor/spedytor.csproj
@@ -74,8 +74,15 @@
     <Reference Include="System.Deployment" />
     <Reference Include="System.Drawing" />
     <Reference Include="System.Windows.Forms" />
+    <Reference Include="System.Xml" />
   </ItemGroup>
   <ItemGroup>
+    <Compile Include="dbWindow.cs">
+      <SubType>Form</SubType>
+    </Compile>
+    <Compile Include="dbWindow.Designer.cs">
+      <DependentUpon>dbWindow.cs</DependentUpon>
+    </Compile>
     <Compile Include="Form1.cs">
       <SubType>Form</SubType>
     </Compile>
@@ -98,6 +105,9 @@
       <DesignTimeSharedInput>True</DesignTimeSharedInput>
       <DependentUpon>S3Settings.settings</DependentUpon>
     </Compile>
+    <EmbeddedResource Include="dbWindow.resx">
+      <DependentUpon>dbWindow.cs</DependentUpon>
+    </EmbeddedResource>
     <EmbeddedResource Include="Form1.resx">
       <DependentUpon>Form1.cs</DependentUpon>
     </EmbeddedResource>
@@ -179,4 +189,4 @@
   <Target Name="AfterBuild">
   </Target>
   -->
-</Project>
+</Project>
\ No newline at end of file