Features

SYSCore/Attributes/DateControlGuardAttribute.cs

+using Oracle.ManagedDataAccess.Client;
+using SYS_Core.aControl;
+using System;
+using System.Net;
+using System.Net.Http;
+using System.Web.Http.Controllers;
+using System.Web.Http.Filters;
+
+namespace SYSCore.Attributes
+{
+    public class DateControlGuardAttribute : ActionFilterAttribute
+    {
+        private DBOracle oOracledb = new DBOracle();
+
+        public override void OnActionExecuting(HttpActionContext actionContext)
+        {
+            HttpRequestMessage request = actionContext.Request;
+            string ErrorMessage;
+            if(!CheckDateControl(out ErrorMessage))
+            {
+                actionContext.Response = new System.Net.Http.HttpResponseMessage()
+                {
+                    Content = new StringContent(String.Concat("[System]", ErrorMessage)),
+                    StatusCode = HttpStatusCode.Forbidden
+                };
+            }
+
+            base.OnActionExecuting(actionContext);
+        }
+
+        private bool CheckDateControl(out string ErrorMessage)
+        {
+            try
+            {
+                OracleCommand cmd = new OracleCommand();
+                cmd.CommandText = "SP_NP_CHECK_CURRENT_DATE";
+                cmd = oOracledb.SqlQueryReturnValue(cmd);
+
+                ErrorMessage = "";
+
+                return true;
+
+            }
+            catch (OracleException ex)
+            {
+                if (ex.Number == 20001)
+                {
+                    ErrorMessage = oOracledb.GetErrorMessage(ex);
+
+                    return false;
+                }
+
+                throw new Exception("Unknown error");
+            }
+            catch (Exception ex)
+            {
+                ErrorMessage = ex.Message;
+                return false;
+            }
+        }
+    }
+}
\ No newline at end of file

SYSCore/Attributes/RunBatchGuardAttribute.cs

+using Oracle.ManagedDataAccess.Client;
+using SYS_Core.aControl;
+using System;
+using System.Net;
+using System.Net.Http;
+using System.Web.Http.Controllers;
+using System.Web.Http.Filters;
+
+namespace SYSCore.Attributes
+{
+    public class RunBatchGuardAttribute : ActionFilterAttribute
+    {
+        private DBOracle oOracledb = new DBOracle();
+
+        public override void OnActionExecuting(HttpActionContext actionContext)
+        {
+            HttpRequestMessage request = actionContext.Request;
+            string ErrorMessage;
+            if (!CheckBatchRunning(out ErrorMessage))
+            {
+                actionContext.Response = new System.Net.Http.HttpResponseMessage()
+                {
+                    Content = new StringContent(String.Concat("[System]", ErrorMessage)),
+                    StatusCode = HttpStatusCode.Forbidden
+                };
+            }
+
+            base.OnActionExecuting(actionContext);
+        }
+
+        private bool CheckBatchRunning(out string ErrorMessage)
+        {
+            try
+            {
+                OracleCommand cmd = new OracleCommand();
+                cmd.CommandText = "SP_NP_CHECK_BATCH_RO_RUNNING";
+                cmd = oOracledb.SqlQueryReturnValue(cmd);
+
+                ErrorMessage = "";
+
+                return true;
+
+            }
+            catch (OracleException ex)
+            {
+                if(ex.Number == 20001)
+                {
+                    ErrorMessage = oOracledb.GetErrorMessage(ex);
+
+                    return false;
+                }
+
+                throw new Exception("Unknown error");
+            }
+            catch (Exception ex)
+            {
+                ErrorMessage = ex.Message;
+                return false;
+            }
+        }
+    }
+}
\ No newline at end of file

SYSCore/Controllers/SystemApiController.cs

@@ -25,6 +25,7 @@ using System.Data.OleDb;
 using System.Globalization;
 using static SYSCore.aControl.EmailSender;
 using SYSCore.aControl;
+using SYSCore.Attributes;
 
 namespace SYS_Core.Controllers
 {

SYSCore/SYSCore.csproj

@@ -261,6 +261,8 @@
     <Compile Include="Areas\HelpPage\SampleGeneration\SampleDirection.cs" />
     <Compile Include="Areas\HelpPage\SampleGeneration\TextSample.cs" />
     <Compile Include="Areas\HelpPage\XmlDocumentationProvider.cs" />
+    <Compile Include="Attributes\DateControlGuardAttribute.cs" />
+    <Compile Include="Attributes\RunBatchGuardAttribute.cs" />
     <Compile Include="Connected Services\ReportingService\Reference.cs">
       <AutoGen>True</AutoGen>
       <DesignTime>True</DesignTime>
@@ -503,8 +505,6 @@
   </ItemGroup>
   <ItemGroup>
     <Folder Include="App_Data\" />
-    <Folder Include="Attributes\" />
-    <Folder Include="Middlewares\" />
   </ItemGroup>
   <ItemGroup>
     <Content Include="fonts\glyphicons-halflings-regular.woff2" />