public string GETtUsed(string ptUrl, string ptPOSNo, string ptTransNo, string ptTransType, string ptTransDate
, string ptPlantCode, string ptBBYNo, string ptDiscAmt, string ptDateIns, string ptTimeIns, string ptSrcSeqNo)
{
//-------------------------------------------Used------------------------------------------------//
try
{
mlREQQtaByTdrUsed oREQQtaByTdrUsed = new mlREQQtaByTdrUsed()
{
tML_POSNo = ptPOSNo,
tML_TransNo = ptTransNo,
tML_TransType = ptTransType,
tML_TransDate = ptTransDate,
tML_PlantCode = ptPlantCode,
tML_BBYNo = ptBBYNo,
tML_DiscAmt = ptDiscAmt,
tML_DateIns = ptDateIns,
tML_TimeIns = ptTimeIns,
tML_SrcSeqNo = ptSrcSeqNo
};
var tJson = JsonConvert.SerializeObject(oREQQtaByTdrUsed, Formatting.Indented);
var tResultMsg = oC_POSTJsonToAPI.C_POSTtHTTPCliant(ptUrl + "/Used", 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_SEToUsed(mlREQQtaByTdrUsed poREQQtaByTdrUsed)
{
var oRESQtaByTdrcs = new cResQtaByTdrcs();
var oSql = new StringBuilder();
string tResCode;
string tMessage;
string tTransStatus = "U";
try
{
var tTransDate = "'" + cCNSP.DTEtByFormat(poREQQtaByTdrUsed.tML_TransDate, "YYYY-MM-DD") + "'";
oSql.Clear();
oSql.AppendLine("UPDATE TPSTSalBBYTdr WITH(ROWLOCK)");
oSql.AppendLine("SET FTSbyStatus='" + tTransStatus + "' ");
oSql.AppendLine(",FCScdAmt = '" + poREQQtaByTdrUsed.tML_DiscAmt + "' ");
oSql.AppendLine("WHERE (FTShdPlantCode = '" + poREQQtaByTdrUsed.tML_PlantCode + "' )");
oSql.AppendLine("AND (FTTmnNum = '" + poREQQtaByTdrUsed.tML_POSNo + "')");
oSql.AppendLine("AND (FTShdTransNo = '" + poREQQtaByTdrUsed.tML_TransNo + "' )");
oSql.AppendLine("AND (FTShdTransType = '" + poREQQtaByTdrUsed.tML_TransType + "' )");
oSql.AppendLine("AND (FDShdTransDate = " + tTransDate + " )");
oSql.AppendLine("AND (FTScdBBYNo = '" + poREQQtaByTdrUsed.tML_BBYNo + "' )");
oSql.AppendLine("AND (FDDateIns = '" + poREQQtaByTdrUsed.tML_DateIns + "' )");
oSql.AppendLine("AND (FTTimeIns = '" + poREQQtaByTdrUsed.tML_TimeIns + "' )");
oSql.AppendLine("AND (FNSrcSeqNo = '" + poREQQtaByTdrUsed.tML_SrcSeqNo + "' )");
oSql.AppendLine("AND (FTSbyStatus = 'R')");
var nResult = cCNSP.SP_SETnDbTbl(oSql.ToString());
if (nResult > 0)
{
tResCode = "04";
tMessage = "ยืนยันการใช่สิทธิ์ สำเร็จ";
return(oRESQtaByTdrcs.C_SEToRESQtaByTdr(tResCode, tMessage));
}
else
{
tResCode = "44";
tMessage = "ยืนยันการใช่สิทธิ์ ไม่สำเร็จ";
return(oRESQtaByTdrcs.C_SEToRESQtaByTdr(tResCode, tMessage));
}
}
catch (Exception oEx)
{
tResCode = "44";
tMessage = "Used Error=" + oEx.Message;
return(oRESQtaByTdrcs.C_SEToRESQtaByTdr(tResCode, tMessage));
}
}
public IHttpActionResult SEToPromoByTdrUsed([FromBody] mlREQQtaByTdrUsed pmlREQQtaByTdrUsed)
{
try
{
oC_Log.Debug("-------------------------------START------------------------------------");
Thread.CurrentThread.CurrentCulture = new CultureInfo("en-US");
// C_CHKxMemcach();
var oUsed = new cUsed();
oC_RESQtaByTdrcs = new mlRESQtaByTdr();
oC_RESQtaByTdrcs = oUsed.C_SEToUsed(pmlREQQtaByTdrUsed);
oC_Log.Debug("-------------------------------End------------------------------------");
return(Json(oC_RESQtaByTdrcs));
}
catch (Exception oEx)
{
return(BadRequest(oEx.Message));
}
}
