SNM110P

SYSCore/Controllers/WarehouseApiController.cs

@@ -2439,6 +2439,68 @@ namespace SYS_Core.Controllers
 
             return Json(DTFM.convertToList(ds));
         }
+
+        [HttpGet, Route("SNM110P_GetOverlapLocation/{mainCategory}/{subCategory}/{fromLocation}/{toLocation}")]
+        [Authorize]
+        public IHttpActionResult SNM110P_GetOverlapLocation(string mainCategory, string subCategory, string fromLocation, string toLocation)
+        {
+            DataSet ds = new DataSet();
+
+            OracleCommand cmd = new OracleCommand();
+            cmd.CommandText = "SP_NP_SNM110P_OVERLAP_LOCATION";
+            cmd.Parameters.Add("P_COMPANY_CODE", OracleDbType.Varchar2).Value = DataService.GetIdentity(User, Cons.SS_COMPANY_CODE);
+            cmd.Parameters.Add("P_MAIN_CATEGORY", OracleDbType.Varchar2).Value = mainCategory;
+            cmd.Parameters.Add("P_SUB_CATEGORY", OracleDbType.Varchar2).Value = subCategory;
+            cmd.Parameters.Add("P_FROM_LOCATION", OracleDbType.Varchar2).Value = fromLocation;
+            cmd.Parameters.Add("P_TO_LOCATION", OracleDbType.Varchar2).Value = toLocation;
+            cmd.Parameters.Add("C_RETURN", OracleDbType.RefCursor).Direction = ParameterDirection.Output;
+
+            ds = oOracledb.SqlQueryDS_CMD(cmd);
+
+            return Json(DTFM.convertToList(ds));
+        }
+
+
+        [HttpPost, Route("SNM110P_AddCategoryLocation/{mainCategory}/{subCategory}/{fromLocation}/{toLocation}")]
+        [Authorize]
+        public IHttpActionResult SNM110P_AddCategoryLocation(string mainCategory, string subCategory, string fromLocation, string toLocation)
+        {
+            DataSet ds = new DataSet();
+
+            OracleCommand cmd = new OracleCommand();
+            cmd.CommandText = "SP_NP_SNM110P_ADD";
+            cmd.Parameters.Add("P_COMPANY_CODE", OracleDbType.Varchar2).Value = DataService.GetIdentity(User, Cons.SS_COMPANY_CODE);
+            cmd.Parameters.Add("P_MAIN_CATEGORY", OracleDbType.Varchar2).Value = mainCategory;
+            cmd.Parameters.Add("P_SUB_CATEGORY", OracleDbType.Varchar2).Value = subCategory;
+            cmd.Parameters.Add("P_FROM_LOCATION", OracleDbType.Varchar2).Value = fromLocation;
+            cmd.Parameters.Add("P_TO_LOCATION", OracleDbType.Varchar2).Value = toLocation;
+            cmd.Parameters.Add("P_SYSTEM_USER", OracleDbType.Varchar2).Value = DataService.GetIdentity(User, Cons.SS_USER_NAME);
+
+            ds = oOracledb.SqlQueryDS_CMD(cmd);
+
+            return Json(DTFM.convertToList(ds));
+        }
+
+
+        [HttpPost, Route("SNM110P_DeleteCategoryLocation/{mainCategory}/{subCategory}/{fromLocation}/{toLocation}")]
+        [Authorize]
+        public IHttpActionResult SNM110P_DeleteCategoryLocation(string mainCategory, string subCategory, string fromLocation, string toLocation)
+        {
+            DataSet ds = new DataSet();
+
+            OracleCommand cmd = new OracleCommand();
+            cmd.CommandText = "SP_NP_SNM110P_DELETE";
+            cmd.Parameters.Add("P_COMPANY_CODE", OracleDbType.Varchar2).Value = DataService.GetIdentity(User, Cons.SS_COMPANY_CODE);
+            cmd.Parameters.Add("P_MAIN_CATEGORY", OracleDbType.Varchar2).Value = mainCategory;
+            cmd.Parameters.Add("P_SUB_CATEGORY", OracleDbType.Varchar2).Value = subCategory;
+            cmd.Parameters.Add("P_FROM_LOCATION", OracleDbType.Varchar2).Value = fromLocation;
+            cmd.Parameters.Add("P_TO_LOCATION", OracleDbType.Varchar2).Value = toLocation;
+            cmd.Parameters.Add("P_SYSTEM_USER", OracleDbType.Varchar2).Value = DataService.GetIdentity(User, Cons.SS_USER_NAME);
+
+            ds = oOracledb.SqlQueryDS_CMD(cmd);
+
+            return Json(DTFM.convertToList(ds));
+        }
         #endregion
     }
 }