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)); }