public static bool WithdrawTransaction(long transactionMasterId, int userId, string reason)
{
short status = VerificationDomain.GetVerification(VerificationType.Withdrawn);
const string sql = "UPDATE transactions.transaction_master SET verification_status_id=@Status, verified_by_user_id=@UserId, verification_reason=@Reason WHERE transactions.transaction_master.transaction_master_id=@TransactionMasterId;";
using (NpgsqlCommand command = new NpgsqlCommand(sql))
{
command.Parameters.AddWithValue("@Status", status);
command.Parameters.AddWithValue("@UserId", userId);
command.Parameters.AddWithValue("@Reason", reason);
command.Parameters.AddWithValue("@TransactionMasterId", transactionMasterId);
return(DbOperations.ExecuteNonQuery(command));
}
}
public static bool WithdrawTransaction(long transactionMasterId, int userId, string reason)
{
short status = VerificationDomain.GetVerification(VerificationType.Withdrawn);
return(Data.Verification.Withdrawal.WithdrawTransaction(transactionMasterId, userId, reason, status));
}
