public string GETtCancel(string ptUrl, string ptPOSNo, string ptTransNo, string ptTransType, string ptTransDate , string ptPlantCode, string ptBBYNo, string ptDateIns, string ptTimeIns, string ptSrcSeqNo) { //-------------------------------------------------Cancel-----------------------------------------------// try { mlREQQtaByTdrCancel oREQQtaByTdrCancel = new mlREQQtaByTdrCancel() { tML_POSNo = ptPOSNo, tML_TransNo = ptTransNo, tML_TransType = ptTransType, tML_TransDate = ptTransDate, tML_PlantCode = ptPlantCode, tML_BBYNo = ptBBYNo, tML_DateIns = ptDateIns, tML_TimeIns = ptTimeIns, tML_SrcSeqNo = ptSrcSeqNo }; var tJson = JsonConvert.SerializeObject(oREQQtaByTdrCancel, Formatting.Indented); var tResultMsg = oC_POSTJsonToAPI.C_POSTtHTTPCliant(ptUrl + "/Cancel", tJson); var oRESQtaByTdr = JsonConvert.DeserializeObject <mlRESQtaByTdr>(tResultMsg); var tResult = oRESQtaByTdr.tML_ResCode + "|" + oRESQtaByTdr.tML_Message + "|" + oRESQtaByTdr.tML_DateIns + "|" + oRESQtaByTdr.tML_TimeIns; return(tResult); } catch (Exception oEx) { throw oEx; } }
public mlRESQtaByTdr C_SEToCancel(mlREQQtaByTdrCancel poREQQtaByTdrCancel) { var oRESQtaByTdrcs = new cResMsgQtaByTdrcs(); var oSql = new StringBuilder(); string tResCode; string tMessage; string tTransStatus = "U"; try { var tTransDate = "'" + cCNSP.DTEtByFormat(poREQQtaByTdrCancel.tML_TransDate, "YYYY-MM-DD") + "'"; oSql.Clear(); oSql.AppendLine("UPDATE TPSTSalBBYTdr WITH(ROWLOCK)"); oSql.AppendLine("SET FTSbyStatus='" + tTransStatus + "' "); oSql.AppendLine("WHERE (FTShdPlantCode = '" + poREQQtaByTdrCancel.tML_PlantCode + "')"); oSql.AppendLine("AND (FTTmnNum = '" + poREQQtaByTdrCancel.tML_POSNo + "')"); oSql.AppendLine("AND (FTShdTransNo = '" + poREQQtaByTdrCancel.tML_TransNo + "')"); oSql.AppendLine("AND (FTShdTransType = '" + poREQQtaByTdrCancel.tML_TransType + "')"); oSql.AppendLine("AND (FDShdTransDate = " + tTransDate + " )"); oSql.AppendLine("AND (FTScdBBYNo = '" + poREQQtaByTdrCancel.tML_BBYNo + "')"); oSql.AppendLine("AND (FDDateIns = '" + poREQQtaByTdrCancel.tML_DateIns + "')"); oSql.AppendLine("AND (FTTimeIns = '" + poREQQtaByTdrCancel.tML_TimeIns + "')"); oSql.AppendLine("AND (FNSrcSeqNo = '" + poREQQtaByTdrCancel.tML_SrcSeqNo + "')"); oSql.AppendLine("AND (FTSbyStatus = 'R')"); int nResult = cConDbByTender.C_SETnDbTbl(oSql.ToString()); if (nResult > 0) { tResCode = "01"; tMessage = "ยกเลิกการจอง สำเร็จ"; return(oRESQtaByTdrcs.C_SEToRESQtaByTdr(tResCode, tMessage)); } else { tResCode = "44"; tMessage = "ยกเลิกการจอง ไม่สำเร็จ"; return(oRESQtaByTdrcs.C_SEToRESQtaByTdr(tResCode, tMessage)); } } catch (Exception ex) { tResCode = "44"; tMessage = "[Cancel] Error=" + ex.Message; return(oRESQtaByTdrcs.C_SEToRESQtaByTdr(tResCode, tMessage)); } }
public IHttpActionResult SEToPromoByTdrCancel([FromBody] mlREQQtaByTdrCancel pmlREQQtaByTdrCancel) { try { oC_Log.Debug("-------------------------------START------------------------------------"); Thread.CurrentThread.CurrentCulture = new CultureInfo("en-US"); var oCancel = new cCancel(); // C_CHKxMemcach(); oC_RESQtaByTdrcs = new mlRESQtaByTdr(); oC_RESQtaByTdrcs = oCancel.C_SEToCancel(pmlREQQtaByTdrCancel); oC_Log.Debug("-------------------------------End------------------------------------"); return(Json(oC_RESQtaByTdrcs)); } catch (Exception oEx) { return(BadRequest(oEx.Message)); } }