public bool AddCustomerPaymentMethod(AddPaymentMethodDTO paymentMethodToAdd)
{
using (var db = new SqlConnection(_connectionString))
{
var sql = @"INSERT INTO[dbo].[PaymentMethod]
([CustomerId]
,[PaymentTypeId]
,[CardNumber]
,[NameOnCard]
,[ExpirationDate]
,[CVV])
VALUES
(@CustomerId
, @PaymentTypeId
, @CardNumber
, @NameOnCard
, @ExpirationDate
, @CVV)";
return(db.Execute(sql, paymentMethodToAdd) == 1);
}
}
public IEnumerable <PaymentMethod> AddPaymentMethod(AddPaymentMethodDTO paymentMethodToAdd)
{
_repo.AddCustomerPaymentMethod(paymentMethodToAdd);
return(_repo.GetPaymentMethodByCustomerId(paymentMethodToAdd.CustomerId));
}
