public int updateTransactionStatus(CompleteTransactionRequest completeTransactionRequest) { string sqlString = "Update MERCHANT_TRANSACTION set transaction_status ='" + completeTransactionRequest.status + "' where guid = " + completeTransactionRequest.merchant_guid; MySql.Data.MySqlClient.MySqlCommand cmd = new MySql.Data.MySqlClient.MySqlCommand(sqlString, conn); int result = cmd.ExecuteNonQuery(); return(result); }
// POST: api/CompleteTransaction public CompleteTransactionResponse Post([FromBody] CompleteTransactionRequest completeTransactionRequest) { SalePersistence sp = new SalePersistence(); int result = sp.updateTransactionStatus(completeTransactionRequest); CompleteTransactionResponse completeTransactionResponse = new CompleteTransactionResponse(); completeTransactionResponse.status = result.ToString(); return(completeTransactionResponse); }