public void Create(Customer newCustomer, IDbConnection connection) { const string sql = @" INSERT INTO Customers (CustomerID, CompanyName, ContactName) VALUES (@customerID, @companyName, @contactName)"; connection.Execute(sql, new { customerId = newCustomer.CustomerId, companyName = newCustomer.CompanyName, contactName = newCustomer.ContactName }); }
public void Create_ShouldUpdateTableWithCustomerData() { const string customerId = "SKN"; var expectedCustomer = new Customer( customerId, "SkyNet", "T-800" ); _customersDataAdapter.Create(expectedCustomer, SqlConnection); var actualCustomer = _customersDataAdapter.Get(customerId, SqlConnection); Assert.AreEqual(expectedCustomer.CustomerId, actualCustomer.CustomerId); Assert.AreEqual(expectedCustomer.CompanyName, actualCustomer.CompanyName); Assert.AreEqual(expectedCustomer.ContactName, actualCustomer.ContactName); }
public void Update(string customerId, Customer updatedCustomer, IDbConnection connection) { const string sql = @" UPDATE Customers SET CompanyName = @companyName, ContactName = @contactName WHERE CustomerId = @customerId"; connection.Execute(sql, new { // ReSharper disable RedundantAnonymousTypePropertyName customerId = customerId, // ReSharper restore RedundantAnonymousTypePropertyName companyName = updatedCustomer.CompanyName, contactName = updatedCustomer.ContactName }); }
public void Delete_WithValidCustomerId_ShouldRemoveCustomerFromDatabase() { const string customerId = "SKN"; var customer = new Customer( customerId, "SkyNet", "T-800" ); _customersDataAdapter.Create(customer, SqlConnection); // Act _customersDataAdapter.Delete(customerId, SqlConnection); var actualCustomer = _customersDataAdapter.Get(customerId, SqlConnection); Assert.IsNull(actualCustomer); }
public void Update_WithExistingCustomer_ShouldUpdateCustomerInDatabase() { const string customerId = "SKN"; var originalCustomer = new Customer( customerId, "SkyNet", "T-800" ); _customersDataAdapter.Create(originalCustomer, SqlConnection); // Act var updatedCustomer = new Customer( customerId, "TurboProp Inc.", "Roger Ramjet"); _customersDataAdapter.Update(customerId, updatedCustomer, SqlConnection); var actualCustomer = _customersDataAdapter.Get(customerId, SqlConnection); Assert.AreEqual(updatedCustomer.CustomerId, actualCustomer.CustomerId); Assert.AreEqual(updatedCustomer.CompanyName, actualCustomer.CompanyName); Assert.AreEqual(updatedCustomer.CustomerId, actualCustomer.CustomerId); }
private static void CheckExpectedCustomer3(Customer customer) { Assert.AreEqual(CustomerSeeder.CustomerId3, customer.CustomerId); Assert.AreEqual(CustomerSeeder.CustomerName3, customer.CompanyName); Assert.AreEqual(CustomerSeeder.ContactName3, customer.ContactName); }