Oracle Provider update

optimajet · optimajet · commit 02857aab63af · 2016-03-01T18:53:26.000+03:00
diff --git a/Provider for Oracle/Models/WorkflowGlobalParameter.cs b/Provider for Oracle/Models/WorkflowGlobalParameter.cs
@@ -1,6 +1,7 @@
 ﻿using System;
 using Oracle.ManagedDataAccess.Client;
 
+// ReSharper disable once CheckNamespace
 namespace OptimaJet.Workflow.Oracle
 {
     public sealed class WorkflowGlobalParameter : DbObject<WorkflowGlobalParameter>
diff --git a/Provider for Oracle/Models/WorkflowProcessInstance.cs b/Provider for Oracle/Models/WorkflowProcessInstance.cs
@@ -2,6 +2,7 @@
 using System;
 using Oracle.ManagedDataAccess.Client;
 
+// ReSharper disable once CheckNamespace
 namespace OptimaJet.Workflow.Oracle
 {
     public class WorkflowProcessInstance: DbObject<WorkflowProcessInstance>
diff --git a/Provider for Oracle/Models/WorkflowProcessTimer.cs b/Provider for Oracle/Models/WorkflowProcessTimer.cs
@@ -146,7 +146,7 @@ public static int SetIgnore(OracleConnection connection, WorkflowProcessTimer[]
             }
 
             return ExecuteCommand(connection,
-                string.Format("DELETE FROM {0} WHERE ID IN ({1})", ObjectName, string.Join(",", parameters)),
+                string.Format("UPDATE {0} SET IGNORE = 1 WHERE ID IN ({1})", ObjectName, string.Join(",", parameters)),
                 sqlParameters.ToArray());
          }
     }

Original file line number	Diff line number	Diff line change
`@@ -1,6 +1,7 @@`
`1`	`1`	`using System;`
`2`	`2`	`using Oracle.ManagedDataAccess.Client;`
`3`	`3`
	`4`	`+// ReSharper disable once CheckNamespace`
`4`	`5`	`namespace OptimaJet.Workflow.Oracle`
`5`	`6`	`{`
`6`	`7`	`public sealed class WorkflowGlobalParameter : DbObject<WorkflowGlobalParameter>`
Original file line number	Diff line number	Diff line change
`@@ -2,6 +2,7 @@`
`2`	`2`	`using System;`
`3`	`3`	`using Oracle.ManagedDataAccess.Client;`
`4`	`4`
	`5`	`+// ReSharper disable once CheckNamespace`
`5`	`6`	`namespace OptimaJet.Workflow.Oracle`
`6`	`7`	`{`
`7`	`8`	`public class WorkflowProcessInstance: DbObject<WorkflowProcessInstance>`
Original file line number	Diff line number	Diff line change
`@@ -146,7 +146,7 @@ public static int SetIgnore(OracleConnection connection, WorkflowProcessTimer[]`
`146`	`146`	`}`
`147`	`147`
`148`	`148`	`return ExecuteCommand(connection,`
`149`		`- string.Format("DELETE FROM {0} WHERE ID IN ({1})", ObjectName, string.Join(",", parameters)),`
	`149`	`+ string.Format("UPDATE {0} SET IGNORE = 1 WHERE ID IN ({1})", ObjectName, string.Join(",", parameters)),`
`150`	`150`	`sqlParameters.ToArray());`
`151`	`151`	`}`
`152`	`152`	`}`