diff options
| -rw-r--r-- | kurier/Form1.Designer.cs | 2 | ||||
| -rw-r--r-- | kurier/Form1.cs | 11 | ||||
| -rw-r--r-- | kurier/MySQL.cs | 70 | ||||
| -rw-r--r-- | kurier/MysqlSettings.Designer.cs | 107 | ||||
| -rw-r--r-- | kurier/MysqlSettings.cs | 46 | ||||
| -rw-r--r-- | kurier/MysqlSettings.resx | 197 | ||||
| -rw-r--r-- | kurier/Properties/Settings.Designer.cs | 80 | ||||
| -rw-r--r-- | kurier/Properties/Settings.settings | 26 | ||||
| -rw-r--r-- | kurier/app.config | 27 | ||||
| -rw-r--r-- | kurier/kurier.csproj | 53 |
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. |