error check on DB write

AzmodanRO · AzmodanRO · commit b04359dde7bf · 2020-06-28T08:49:16.000+03:00
diff --git a/Software/C#/freETarget/StorageController.cs b/Software/C#/freETarget/StorageController.cs
@@ -239,11 +239,17 @@ public void storeSession(Session session) {
             string controlString = getControlString(session);
             cmd.Parameters.AddWithValue("@hash", GetMd5Hash(controlString));
 
-            cmd.Prepare();
+            try {
+                cmd.Prepare();
 
-            cmd.ExecuteNonQuery();
-            con.Close();
-            Console.WriteLine("Session saved");
+                cmd.ExecuteNonQuery();
+
+                Console.WriteLine("Session saved");
+            } catch(Exception ex){
+                MessageBox.Show("Error saving session to the database. Make sure you have write access to the folder." + Environment.NewLine + ex.Message, "Error writing to DB", MessageBoxButtons.OK, MessageBoxIcon.Error);
+            } finally {
+                con.Close();
+            }
         }
 
         public string getControlString(Session session) {
