Changeset 7 for Common/Database.cs

Timestamp:

May 13, 2019, 1:20:39 PM (6 years ago)

Author:

chronos

Message:

• Added: Support logging in case of database exception.

File:

• Common/Database.cs (modified) (10 diffs)

Common/Database.cs

@@ -26 +26 @@
         public delegate void DatabaseInitializedHandler();       
         public static event DatabaseInitializedHandler DatabaseInitialized;
+        public delegate void LogMessageHandler(string text);
+        public static event LogMessageHandler LogMessage;
         public static string connectionString = "";
         public static string databaseName = "";
@@ -71 +73 @@
                     {
                         result = false;
+                        Log("When connecting to DB: " + ex.Message);
                         throw new Exception("When connecting to DB: " + ex.Message);
                     }
@@ -84 +87 @@
 
             return result;
+        }
+
+        private static void Log(string message)
+        {
+            if (LogMessage != null) LogMessage(message);
         }
 
@@ -289 +297 @@
                 if ((error.Class > 10) && (error.Number != 3013))
                 {
+                    Log(error.ToString());
                     throw new Exception(error.ToString());
                 }
@@ -319 +328 @@
             catch (DbException ex)
             {
+                Log("When executing query sql command:\n" + query + "\nException text: " + ex.Message);
                 throw new Exception("When executing query sql command:\n" + query + "\nException text: " + ex.Message);
             }
@@ -347 +357 @@
             }
             catch (DbException ex)
-            {                
+            {
+                Log("When executing sql transaction:\nException text: " + ex.Message);
                 throw new Exception("When executing sql transaction:\nException text: " + ex.Message);
             }
@@ -386 +397 @@
             catch (DbException ex)
             {
+                Log("When executing query sql command:\n" + query + "\nException text: " + ex.Message);
                 throw new Exception("When executing query sql command:\n" + query + "\nException text: " + ex.Message);
             }
@@ -406 +418 @@
             catch (DbException ex)
             {
+                Log("When executing query sql command:\n" + query + "\nException text: " + ex.Message);
                 throw new Exception("When executing query sql command:\n" + query + "\nException text: " + ex.Message);
             }
@@ -433 +446 @@
             catch (DbException ex)
             {
+                Log("When executing non query sql command:\n" + query + "\nException text: " + ex.Message);
                 throw new Exception("When executing non query sql command:\n" + query + "\nException text: " + ex.Message);
             }
@@ -491 +505 @@
             return result;
         }
+
+        public static void CreateIndexOnColumn(string table, string column, string indexName = null)
+        {
+            if (indexName == null) indexName = table + "_" + column;
+            ExecuteNonQuery("CREATE INDEX " + indexName + " ON " + table + " (" + column + ")");
+        }
     }