Merge to Release

SYSCore/Controllers/TechnicalApiController.cs

+using Oracle.ManagedDataAccess.Client;
+using SYS_Core.aControl;
+using System;
+using System.Collections.Generic;
+using System.Configuration;
+using System.Data;
+using System.Linq;
+using System.Net;
+using System.Net.Http;
+using System.Web.Http;
+using System.Web.Http.Cors;
+using System.Collections;
+using System.Web;
+using System.Net.Sockets;
+using System.Threading.Tasks;
+using System.IO;
+using System.Text;
+using SYS_Core.aBiz;
+using System.Globalization;
+
+namespace SYS_Core.Controllers
+{
+
+    [EnableCors("*", "*", "*")]
+    [RoutePrefix("api/TI")]
+    public class TechnicalController : ApiController
+    {
+
+        private DBOracle oOracledb = new DBOracle();
+        private String gSQL = "";
+        private DataModel DataModel = new DataModel();
+
+        #region SNSE143_F2
+        [HttpGet, Route("SNSE143_F2_GetDetailByFileName/{fileName}")]
+        [Authorize]
+        public IHttpActionResult SNSE143_F2_GetDetailByFileName (string fileName)
+        {
+            try
+            {
+                OracleCommand cmd = new OracleCommand();
+                cmd.CommandText = "SP_NP_SNSE143_F2_DETAILBYNAME";
+                cmd.Parameters.Add("P_COMPANY_CODE", OracleDbType.Varchar2).Value = DataService.GetIdentity(User, Cons.SS_COMPANY_CODE);
+                cmd.Parameters.Add("P_FILE_NAME", OracleDbType.Varchar2).Value = fileName;
+                cmd.Parameters.Add("C_RETURN", OracleDbType.RefCursor).Direction = ParameterDirection.Output;
+
+                DataSet ds = oOracledb.SqlQueryDS_CMD(cmd);
+
+                return Json(DTFM.convertToList(ds));
+            }
+            catch (Exception ex)
+            {
+                throw new Exception(ex.Message);
+            }
+
+        }
+
+        [HttpGet, Route("SNSE143_F2_GetFileList")]
+        [Authorize]
+        public IHttpActionResult SNSE143_F2_GetFileList()
+        {
+            try
+            {
+                OracleCommand cmd = new OracleCommand();
+                cmd.CommandText = "SP_NP_SNSE143_F2_FileList";
+                cmd.Parameters.Add("P_COMPANY_CODE", OracleDbType.Varchar2).Value = DataService.GetIdentity(User, Cons.SS_COMPANY_CODE);
+                cmd.Parameters.Add("C_RETURN", OracleDbType.RefCursor).Direction = ParameterDirection.Output;
+
+                DataSet ds = oOracledb.SqlQueryDS_CMD(cmd);
+
+                return Json(DTFM.convertToList(ds));
+            }
+            catch (Exception ex)
+            {
+                throw new Exception(ex.Message);
+            }
+
+        }
+
+        [HttpPost, Route("SNSE143_F2_TransferData/{fileName}")]
+        [Authorize]
+        public IHttpActionResult SNSE143_F2_TransferData(string fileName)
+        {
+            try
+            {
+                OracleCommand cmd = new OracleCommand();
+                cmd.CommandText = "PK_NP_SNSE143_F2.CONFIRM_PFPM_FOR_REGIS";
+                cmd.Parameters.Add("P_COMPANY_CODE", OracleDbType.Varchar2).Value = DataService.GetIdentity(User, Cons.SS_COMPANY_CODE);
+                cmd.Parameters.Add("P_FILE_NAME", OracleDbType.Varchar2).Value = fileName;
+                cmd.Parameters.Add("P_SYSTEM_USER", OracleDbType.Varchar2).Value = DataService.GetIdentity(User, Cons.SS_USER_NAME);
+
+                cmd = oOracledb.SqlQueryReturnValue(cmd);
+
+                return Ok();
+            }
+            catch (Exception ex)
+            {
+                throw new Exception(ex.Message);
+            }
+
+        }
+
+        [HttpPost, Route("SNSE143_F2_UploadFile")]
+        [Authorize]
+        public async Task<IHttpActionResult> SNSE143_F2_UploadFile (HttpRequestMessage request) {
+            if (!request.Content.IsMimeMultipartContent()) {
+                throw new HttpResponseException(HttpStatusCode.UnsupportedMediaType);
+            }
+            var reqParts = await request.Content.ReadAsMultipartAsync();
+
+            try
+            {
+
+                foreach (var file in reqParts.Contents)
+                {
+                    var timestamp = DateTime.Now.ToString("yyyyMMdd");
+                    var buffer = await file.ReadAsByteArrayAsync();
+                    string gFileName = file.Headers.ContentDisposition.FileName.Trim('\"');
+                    string gFileNameExtend = String.Concat(gFileName, '_', timestamp);
+                    string gRootPath = ConfigurationManager.AppSettings["RootSharedPath"].ToString();
+                    string gUploadLication = System.IO.Path.Combine(gRootPath, "tempFile/SNSE143_F2");
+                    string gFileLocation = System.IO.Path.Combine(gUploadLication, gFileNameExtend);
+
+                    DataService.SaveBytesToFileByLocation(buffer
+                                                    , gUploadLication
+                                                    , gFileLocation);
+
+                    try
+                    {
+                        OracleCommand cmd = new OracleCommand();
+                        cmd.CommandText = "PK_NP_SNSE143_F2.REMOVE_PFPM";
+                        cmd.Parameters.Add("P_COMPANY_CODE", OracleDbType.Varchar2).Value = DataService.GetIdentity(User, Cons.SS_COMPANY_CODE);
+                        cmd.Parameters.Add("P_FILE_NAME", OracleDbType.Varchar2).Value = gFileNameExtend;
+
+                        oOracledb.SqlQueryReturnValue(cmd);
+                    }
+                    catch (Exception ex)
+                    {
+                        throw new HttpResponseException(HttpStatusCode.InternalServerError);
+                    }
+
+                    //Begin read file
+                    Stream stream = new MemoryStream(buffer);
+
+                    using (StreamReader reader = new StreamReader(stream, Encoding.UTF8))
+                    {
+                        string line;
+                        int itemNo = 1;
+                        while((line = reader.ReadLine()) != null) {
+                            //read line from memorystream
+
+                            OracleCommand cmd = new OracleCommand();
+                            cmd.CommandText = "PK_NP_SNSE143_F2.EXTRACT_PFPM";
+                            cmd.Parameters.Add("P_COMPANY_CODE", OracleDbType.Varchar2).Value = DataService.GetIdentity(User, Cons.SS_COMPANY_CODE);
+                            cmd.Parameters.Add("P_FILE_NAME", OracleDbType.Varchar2).Value = gFileNameExtend;
+                            cmd.Parameters.Add("P_ITEM_NO", OracleDbType.Decimal).Value = itemNo;
+                            cmd.Parameters.Add("P_TEXT_DATA", OracleDbType.Varchar2).Value = line;
+                            cmd.Parameters.Add("P_SYSTEM_USER", OracleDbType.Varchar2).Value = DataService.GetIdentity(User, Cons.SS_USER_NAME);
+
+                            cmd = oOracledb.SqlQueryReturnValue(cmd);
+
+                            //if(cmd.Parameters["P_STATUS"].Value.ToString() == "OK")
+                            //{
+                                itemNo++;
+                            //}
+                        }
+                    }
+                    return Ok(gFileNameExtend);
+                }
+            }
+            catch (Exception ex) {
+                throw new HttpResponseException(HttpStatusCode.NotAcceptable);
+            }
+
+            throw new Exception("Something wrong");
+
+        }
+        #endregion
+    }
+}
\ No newline at end of file

SYSCore/SYSCore.csproj

@@ -225,6 +225,7 @@
     <Compile Include="Controllers\ValuesController.cs" />
     <Compile Include="Controllers\AccountApiController.cs" />
     <Compile Include="Controllers\WarehouseApiController.cs" />
+    <Compile Include="Controllers\TechnicalApiController.cs" />
     <Compile Include="Global.asax.cs">
       <DependentUpon>Global.asax</DependentUpon>
     </Compile>

.gitignore

@@ -4,3 +4,4 @@
 /.vscode
 /Release
 /SYSCore/tempFile
+.DS_Store
\ No newline at end of file

launch.js

+var exec = require('child_process').exec;
+exec('sh startServer.sh');
\ No newline at end of file

startServer.sh

+Port=8090
+
+# Stop any servers running on port 5001
+ps aux | grep -i xsp4.*$Port | awk '{print $2}' | xargs kill -9
+
+cd ./SYSCore && MONO_MANAGED_WATCHER="y" MONO_OPTIONS="--debug --debugger-agent=transport=dt_socket,server=y,suspend=n,setpgid=y,address=127.0.0.1:55551"  MONO_ASPNET_WEBCONFIG_CACHESIZE="2000" xsp4 --address 127.0.0.1 --port $Port --nonstop &
+
+# Wait to make sure the server has really started.
+sleep 2s
+
+open http://127.0.0.1:$Port &
+
+echo 'Server started'
+
+read quit
\ No newline at end of file