From c2d53052e846fa2f8bbedcae9eb37ed607bb13ee Mon Sep 17 00:00:00 2001 From: emkael Date: Thu, 3 Sep 2015 12:58:13 +0200 Subject: * options for collecting play and bidding data --- Aktywator/Bws.cs | 26 ++++++++++++++++++++++++++ Aktywator/MainForm.Designer.cs | 26 ++++++++++++++++++++++++++ 2 files changed, 52 insertions(+) diff --git a/Aktywator/Bws.cs b/Aktywator/Bws.cs index 0be06df..20278e0 100644 --- a/Aktywator/Bws.cs +++ b/Aktywator/Bws.cs @@ -54,6 +54,8 @@ namespace Aktywator settings.Add(new Setting("BM2AutoBoardNumber", main.xAutoBoardNumber, this)); settings.Add(new Setting("BM2ResetFunctionKey", main.xResetFunctionKey, this)); settings.Add(new Setting("BM2ViewHandrecord", main.xViewHandrecord, this)); + settings.Add(new Setting("BM2RecordBidding", main.xCollectBidding, this)); + settings.Add(new Setting("BM2RecordPlay", main.xCollectPlay, this)); } public string sectionsForHandRecords() @@ -131,6 +133,8 @@ namespace Aktywator settings.Add(new Setting("BM2NameSource", "integer", "2")); settings.Add(new Setting("BM2ViewHandrecord", "bit", "false")); settings.Add(new Setting("BM2EnterHandrecord", "bit", "false")); + settings.Add(new Setting("BM2RecordBidding", "bit", "false")); + settings.Add(new Setting("BM2RecordPlay", "bit", "false")); settings.Add(new Setting("Name", "text(18)", "''", "PlayerNumbers")); settings.Add(new Setting("Updated", "bit", "false", "PlayerNumbers")); @@ -167,6 +171,28 @@ namespace Aktywator catch (OleDbException) { } + try + { + sql.query("CREATE TABLE PlayData (" + + "`ID` integer, `Section` integer, `Table` integer, `Round` integer, `Board` integer," + + "`Counter` integer, `Direction` text(2), `Card` text(10), `DateLog` datetime," + + "`TimeLog` datetime, `Erased` bit" + + ");"); + } + catch (OleDbException) + { + } + try + { + sql.query("CREATE TABLE BiddingData (" + + "`ID` integer, `Section` integer, `Table` integer, `Round` integer, `Board` integer," + + "`Counter` integer, `Direction` text(2), `Bid` text(10), `DateLog` datetime," + + "`TimeLog` datetime, `Erased` bit" + + ");"); + } + catch (OleDbException) + { + } } public void updateSettings() diff --git a/Aktywator/MainForm.Designer.cs b/Aktywator/MainForm.Designer.cs index 8a68b44..03a692f 100644 --- a/Aktywator/MainForm.Designer.cs +++ b/Aktywator/MainForm.Designer.cs @@ -105,6 +105,8 @@ this.bLoadHands = new System.Windows.Forms.Button(); this.timer = new System.Windows.Forms.Timer(this.components); this.openPBN = new System.Windows.Forms.OpenFileDialog(); + this.xCollectBidding = new System.Windows.Forms.CheckBox(); + this.xCollectPlay = new System.Windows.Forms.CheckBox(); this.groupBoxTop.SuspendLayout(); this.menu.SuspendLayout(); this.statusStrip1.SuspendLayout(); @@ -240,6 +242,8 @@ // // tabPage1 // + this.tabPage1.Controls.Add(this.xCollectPlay); + this.tabPage1.Controls.Add(this.xCollectBidding); this.tabPage1.Controls.Add(this.xViewHandrecord); this.tabPage1.Controls.Add(this.xResultsOverview); this.tabPage1.Controls.Add(this.bLoad); @@ -894,6 +898,26 @@ // this.openPBN.Filter = "PBN|*.pbn"; // + // xCollectBidding + // + this.xCollectBidding.AutoSize = true; + this.xCollectBidding.Location = new System.Drawing.Point(339, 115); + this.xCollectBidding.Name = "xCollectBidding"; + this.xCollectBidding.Size = new System.Drawing.Size(97, 17); + this.xCollectBidding.TabIndex = 30; + this.xCollectBidding.Text = "zbieraj licytację"; + this.xCollectBidding.UseVisualStyleBackColor = true; + // + // xCollectPlay + // + this.xCollectPlay.AutoSize = true; + this.xCollectPlay.Location = new System.Drawing.Point(339, 138); + this.xCollectPlay.Name = "xCollectPlay"; + this.xCollectPlay.Size = new System.Drawing.Size(146, 17); + this.xCollectPlay.TabIndex = 31; + this.xCollectPlay.Text = "zbieraj przebieg rozgrywki"; + this.xCollectPlay.UseVisualStyleBackColor = true; + // // MainForm // this.AutoScaleDimensions = new System.Drawing.SizeF(6F, 13F); @@ -1008,6 +1032,8 @@ private System.Windows.Forms.Label label13; private System.Windows.Forms.Label label9; private System.Windows.Forms.TextBox eOomRounds; + public System.Windows.Forms.CheckBox xCollectPlay; + public System.Windows.Forms.CheckBox xCollectBidding; } } -- cgit v1.2.3 From 6f5d3a1d030fe7d66d56c71bdacb2534a9c98561 Mon Sep 17 00:00:00 2001 From: emkael Date: Sat, 14 Nov 2015 10:55:05 +0100 Subject: * autonumber IDs in bidding/play tables --- Aktywator/Bws.cs | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) diff --git a/Aktywator/Bws.cs b/Aktywator/Bws.cs index 20278e0..8884868 100644 --- a/Aktywator/Bws.cs +++ b/Aktywator/Bws.cs @@ -174,7 +174,7 @@ namespace Aktywator try { sql.query("CREATE TABLE PlayData (" - + "`ID` integer, `Section` integer, `Table` integer, `Round` integer, `Board` integer," + + "`ID` autoincrement, `Section` integer, `Table` integer, `Round` integer, `Board` integer," + "`Counter` integer, `Direction` text(2), `Card` text(10), `DateLog` datetime," + "`TimeLog` datetime, `Erased` bit" + ");"); @@ -185,7 +185,7 @@ namespace Aktywator try { sql.query("CREATE TABLE BiddingData (" - + "`ID` integer, `Section` integer, `Table` integer, `Round` integer, `Board` integer," + + "`ID` autoincrement, `Section` integer, `Table` integer, `Round` integer, `Board` integer," + "`Counter` integer, `Direction` text(2), `Bid` text(10), `DateLog` datetime," + "`TimeLog` datetime, `Erased` bit" + ");"); -- cgit v1.2.3