From bbf238ffe5a7cd27a6e1162f2731bea9b17bc526 Mon Sep 17 00:00:00 2001
From: emkael <emkael@tlen.pl>
Date: Wed, 23 Aug 2017 20:56:59 +0200
Subject: Separate settings for separate sections

---
 Aktywator/Setting.cs | 28 ++++++++++++++++++++++++----
 1 file changed, 24 insertions(+), 4 deletions(-)

(limited to 'Aktywator/Setting.cs')

diff --git a/Aktywator/Setting.cs b/Aktywator/Setting.cs
index e981328..a5540d6 100644
--- a/Aktywator/Setting.cs
+++ b/Aktywator/Setting.cs
@@ -26,23 +26,33 @@ namespace Aktywator
             this.fwV = firmwareVersion;
         }
 
-        public void load()
+        public void load(string section = null)
         {
             StringBuilder str = new StringBuilder();
             str.Append("SELECT ");
             str.Append(this.name);
             str.Append(" FROM Settings");
+            if (section != null)
+            {
+                str.Append(" WHERE `Section` = ");
+                str.Append(section);
+            }
             field.Checked = false;
             string a = bws.sql.selectOne(str.ToString());
             field.Checked = a.ToUpper() == "TRUE" ? true : false;
         }
 
-        public static string load(string name, Bws bws, StringBuilder errors)
+        public static string load(string name, Bws bws, StringBuilder errors, string section = null)
         {
             StringBuilder str = new StringBuilder();
             str.Append("SELECT ");
             str.Append(name);
             str.Append(" FROM Settings");
+            if (section != null)
+            {
+                str.Append(" WHERE `Section` = ");
+                str.Append(section);
+            }
             try
             {
                 return bws.sql.selectOne(str.ToString());
@@ -55,23 +65,33 @@ namespace Aktywator
             }
         }
 
-        public void save()
+        public void save(string section = null)
         {
             StringBuilder str = new StringBuilder();
             str.Append("UPDATE Settings SET ");
             str.Append(this.name);
             if (field.Checked) str.Append("=true");
             else str.Append("=false");
+            if (section != null)
+            {
+                str.Append(" WHERE `Section` = ");
+                str.Append(section);
+            }
             bws.sql.query(str.ToString());
         }
 
-        public static void save(string name, string value, Bws bws, StringBuilder errors)
+        public static void save(string name, string value, Bws bws, StringBuilder errors, string section = null)
         {
             StringBuilder str = new StringBuilder();
             str.Append("UPDATE Settings SET ");
             str.Append(name);
             str.Append("=");
             str.Append(value);
+            if (section != null)
+            {
+                str.Append(" WHERE `Section` = ");
+                str.Append(section);
+            }
             try
             {
                 bws.sql.query(str.ToString());
-- 
cgit v1.2.3