Dev

SYSCore/Controllers/MarketingApiController.cs

@@ -26,5 +26,76 @@ namespace SYS_Core.Controllers
         private String gSQL = "";
         private DataModel DataModel = new DataModel();
 
+        #region SNM101P
+
+            [HttpGet, Route("SNM101P_GetPart/{part_no}/{noofshowrec}")]
+            [Authorize]
+            public IHttpActionResult SNM101P_GetPart(string part_no, int noofshowrec)
+            {
+                DataSet ds = new DataSet();
+
+                part_no = ismoUtil.escapeCharacter(part_no);
+
+                try
+                {
+                    OracleCommand cmd = new OracleCommand();
+                    cmd.CommandText = "SP_NP_SNM101P_GET_PART ";
+                    cmd.Parameters.Add("P_COMPANY_CODE", OracleDbType.Varchar2).Value = DataService.GetIdentity(User, Cons.SS_COMPANY_CODE);
+                    cmd.Parameters.Add("P_PART_NO", OracleDbType.Varchar2).Value = part_no.ToUpper() == "NULL" ? (object)DBNull.Value : part_no;
+                    //cmd.Parameters.Add("P_SHOW_RECORD", OracleDbType.Int16).Value = noofshowrec;
+                    cmd.Parameters.Add("C_RETURN", OracleDbType.RefCursor).Direction = ParameterDirection.Output;
+
+                    ds = oOracledb.SqlQueryDS_CMD(cmd);
+                    return Json(DTFM.convertToList(ds));
+                }
+
+
+                catch (Exception ex)
+                {
+                    oOracledb.WriteLog("ErrorHandle", ex.Message, "SNPE045_GetDocList");
+                    return ResponseMessage(Request.CreateResponse(HttpStatusCode.InternalServerError, ex.Message));
+                }
+            }
+
+        [HttpPost, Route("SNM101P_Insert")]
+        [Authorize]
+        public IHttpActionResult SNM130P_Insert([FromBody] dynamic param)
+        {
+            DataSet ds = new DataSet();
+
+            try
+            {
+                OracleCommand cmd = new OracleCommand();
+                cmd.CommandText = "SP_NP_SNM101P_INSERT";
+                cmd.Parameters.Add("P_COMPANY_CODE", OracleDbType.Varchar2).Value = DataService.GetIdentity(User, Cons.SS_COMPANY_CODE);
+                cmd.Parameters.Add("P_PART_NO", OracleDbType.Varchar2).Value = param.SPPS_CODE;
+                cmd.Parameters.Add("P_LENGTH", OracleDbType.Varchar2).Value = param.FILE_NAME;
+                cmd.Parameters.Add("P_WIDTH", OracleDbType.Varchar2).Value = param.FILE_NAME;
+                cmd.Parameters.Add("P_HEIGHT", OracleDbType.Varchar2).Value = param.FILE_NAME;
+                cmd.Parameters.Add("P_LIMITED_STACK", OracleDbType.Varchar2).Value = param.FILE_NAME;
+                cmd.Parameters.Add("P_SYSTEM_USER", OracleDbType.Varchar2).Value = DataService.GetIdentity(User, Cons.SS_USER_NAME);                
+                cmd.Parameters.Add("R_STATUS", OracleDbType.Varchar2, 1000).Direction = ParameterDirection.Output;
+                cmd.Parameters.Add("R_MESSAGE", OracleDbType.Varchar2, 1000).Direction = ParameterDirection.Output;
+
+                cmd = oOracledb.SqlQueryReturnValue(cmd);
+
+                string R_STATUS = cmd.Parameters["R_STATUS"].Value.ToString();
+                string R_MESSAGE = cmd.Parameters["R_MESSAGE"].Value.ToString();
+
+                if (R_STATUS == "FAIL")
+                {
+                    oOracledb.WriteLog("ErrorHandle", R_MESSAGE, "SNM101P_Insert");
+                }
+
+                return Json(new { STATUS_MSG = R_STATUS, });
+            }
+            catch (Exception ex)
+            {
+                oOracledb.WriteLog("ErrorHandle", ex.Message, "SNM101P_Insert");
+                return ResponseMessage(Request.CreateResponse(HttpStatusCode.InternalServerError, ex.Message));
+            }
+
+        }
+        #endregion
     }
 }