public bool UpdatePaymentMethod(int id, UpdatePaymentMethodDTO paymentMethodToUpdate)
        {
            using (var db = new SqlConnection(_connectionString))
            {
                var sql = @"Update [PaymentMethod]
                               SET [PaymentTypeId] = @PaymentTypeId
                               ,[CardNumber] = @CardNumber
                               ,[NameOnCard] = @NameOnCard
                               ,[ExpirationDate] = @ExpirationDate
                               ,[CVV] = @CVV
                            Where [Id] = @Id";

                paymentMethodToUpdate.Id = id;

                return(db.Execute(sql, paymentMethodToUpdate) == 1);
            }
        }
Exemple #2
0
 public IActionResult UpdatePaymentMethodById(int paymentMethodId, UpdatePaymentMethodDTO paymentMethodToUpdate)
 {
     _repo.UpdatePaymentMethod(paymentMethodId, paymentMethodToUpdate);
     return(Ok());
 }