public void PreInsertEventListener_must_be_fired() { IMappedStatement statement = statement = ((IModelStoreAccessor)dataMapper).ModelStore.GetMappedStatement("InsertAccount"); Assert.That(statement, Is.Not.Null); statement.PreInsert += PreInsertEventHandler; Account account = new Account(); account.Id = 6; account.FirstName = "Calamity"; account.LastName = "Jane"; account.EmailAddress = "*****@*****.**"; dataMapper.Insert("InsertAccount", account); account = dataMapper.QueryForObject <Account>("SelectAccount", 6); Assert.That(account, Is.Not.Null); Assert.That(account.Id, Is.EqualTo(6)); Assert.That(account.FirstName, Is.EqualTo("Calamity")); Assert.That(account.LastName, Is.EqualTo("Jane")); Assert.That(account.EmailAddress, Is.EqualTo("*****@*****.**")); statement.PreInsert -= PreInsertEventHandler; }
public void TestCategoryInsertAndDelete() { // // Create and Insert new Category // Category c = new Category() { CategoryName = "Fish", Description = "Live under water!" }; object id = categories.Insert(c); // // Get the new category object from database // Category actual = (Category)categories.GetById(id); Assert.AreEqual(c.CategoryName, actual.CategoryName); Assert.AreEqual(c.Description, actual.Description); // // Delete the created category from database // categories.Delete(actual); object res = categories.GetById(id); actual = res != null ? (Category)res : default(Category); Assert.IsNull(actual.CategoryName); Assert.IsNull(actual.Description); }
public void TestRegionInsertAndDelete() { // // Create and Insert new Region // Region c = new Region() { RegionID = 17, RegionDescription = "Central", }; object id = regions.Insert(c); // // Get the new Region object from database // Region actual = (Region)regions.GetById(id); string regionDescription = actual.RegionDescription; string trimmedResult = regionDescription.Trim(); trimmedResult = Regex.Replace(trimmedResult, @"\t|\n|\r", ""); Assert.AreEqual(c.RegionDescription, trimmedResult); // // Delete the created Region from database // regions.Delete(actual); object res = regions.GetById(id); actual = res != null ? (Region)res : default(Region); Assert.IsNull(res); }
internal void TestRegionInsertAndDelete() { // // Create and Insert new Region Region r = new Region() { RegionID = 12, RegionDescription = "Western ", }; object id = regions.Insert(r); // // Get the new region object from database // Region actual = (Region)regions.GetById(12); Assert.AreEqual(r.RegionID, actual.RegionID); Assert.AreEqual(r.RegionDescription, actual.RegionDescription); // Delete the created region from database // regions.Delete(actual); object res = regions.GetById(12); actual = res != null ? (Region)res : default(Region); Assert.IsNull(actual); }
public static void m1() { Builder builder = new Builder( typeof(SqlDataMapper <>), new Object[] { SqlMapperUnitTest.getMySqlConnectionString() }, typeof(PropertyColumnMapper), typeof(SingleConnectionPolicy)); IDataMapper <ProductSimple> productMapper = builder.Build <ProductSimple>(); IConnectionPolicy policy = productMapper.GetConnectionPolicy(); ProductSimple p = productMapper.GetAll().First(); p.ProductName = "Potatoes"; productMapper.Update(p); ProductSimple p2 = productMapper.GetAll().First(); p2.ProductName = "Chai"; productMapper.Update(p2); ProductSimple novoP = new ProductSimple(); novoP.ProductName = "batatas"; novoP.QuantityPerUnit = "setenta mil"; productMapper.Insert(novoP); }
public void TestProductInsertAndDelete() { // // Create and insert a new product // Category c = (Category)categories.GetById(4); Supplier s = (Supplier)suppliers.GetById(17); Product p = new Product() { Category = c, Supplier = s, ProductName = "Bacalhau", ReorderLevel = 23, UnitsInStock = 100, UnitsOnOrder = 40 }; object id = prods.Insert(p); // // Get the new product object from database // Product actual = (Product)prods.GetById(id); Assert.AreEqual(p.ProductName, actual.ProductName); Assert.AreEqual(p.UnitsInStock, actual.UnitsInStock); // // Delete the created product from database // prods.Delete(actual); actual = (Product)prods.GetById(id); Assert.IsNull(actual); }
public void TestEmployeeInsertAndDelete() { Employee e = new Employee() { LastName = "Silva", FirstName = "Manuel", Title = "Sales Representative", TitleOfCourtesy = "Mr.", Address = "There", City = "This one", Region = "That one", PostalCode = "IDK", Country = "Portugal", HomePhone = "(206) 555-9857", Extension = "100" }; object id = employee.Insert(e); // // Get the new employee object from database // Employee actual = (Employee)employee.GetById(id); Assert.AreEqual(e.LastName, actual.LastName); Assert.AreEqual(e.FirstName, actual.FirstName); // // Delete the created employee from database // employee.Delete(actual); object res = employee.GetById(id); actual = res != null ? (Employee)res : default(Employee); Assert.IsNull(actual.LastName); Assert.IsNull(actual.FirstName); }
public void TestShipperInsertAndDelete() { // // Create and Insert new Shipper // Shipper c = new Shipper() { CompanyName = "New Company", Phone = "(555) 123-4567" }; object id = shippers.Insert(c); // // Get the new category object from database // Shipper actual = (Shipper)shippers.GetById(id); Assert.AreEqual(c.CompanyName, actual.CompanyName); Assert.AreEqual(c.Phone, actual.Phone); // // Delete the created category from database // shippers.Delete(actual); object res = shippers.GetById(id); actual = res != null ? (Shipper)res : default(Shipper); Assert.IsNull(actual.CompanyName); Assert.IsNull(actual.Phone); }
public void TestRegionInsertAndDelete() { // // Create and Insert new Region // Region r = new Region() { RegionID = 5, RegionDescription = "Northwest " }; object id = regions.Insert(r); // // Get the new Region object from database // Region actual = (Region)regions.GetById(id); Assert.AreEqual(r.RegionDescription, actual.RegionDescription); // // Delete the created Region from database // regions.Delete(actual); object res = regions.GetById(id); actual = res != null ? (Region)res : default(Region); Assert.IsNull(actual.RegionDescription); }
private void SeedDB() { var order1 = new Entities.FluentMappedOrder { OrderName = "Order 1" }; _db.Insert <Entities.FluentMappedOrder>(order1); }
public void NullValue_should_be_replaced() { Account account = NewAccount6(); dataMapper.Insert("InsertAccountViaParameterMap", account); account = (Account)dataMapper.QueryForObject("GetAccountNullableEmail", 6); AssertAccount6(account); }
public void Nvelocity_procedure_with_dynamic_parameter_should_work() { Account account = new Account(); account.Id = 99; account.FirstName = "Achille"; account.LastName = "Talon"; account.NullBannerOption = false; IDictionary <string, object> parameters = new Dictionary <string, object>(); parameters.Add("account", account); dataMapper.Insert("NVelocity.Procedure", parameters); Account testAccount = dataMapper.QueryForObject <Account>("NVelocity.Simple", parameters); Assert.IsNotNull(testAccount); Assert.That(testAccount.Id, Is.EqualTo(99)); Assert.That(testAccount.EmailAddress, Is.EqualTo("*****@*****.**")); Assert.That(testAccount.BannerOption, Is.False); Assert.That(testAccount.CartOption, Is.False); account.Id = 100; account.FirstName = "Achille"; account.LastName = "Talon"; account.NullBannerOption = true; account.CartOption = true; parameters = new Dictionary <string, object>(); parameters.Add("account", account); dataMapper.Insert("NVelocity.Procedure", parameters); testAccount = dataMapper.QueryForObject <Account>("NVelocity.Simple", parameters); Assert.IsNotNull(testAccount); Assert.That(testAccount.Id, Is.EqualTo(100)); Assert.That(testAccount.EmailAddress, Is.EqualTo("*****@*****.**")); Assert.That(testAccount.BannerOption, Is.True); Assert.That(testAccount.CartOption, Is.True); }
public void CustomersInsert() { Customer cust1 = new Customer(); cust1.CustomerID = "SERRA"; cust1.CompanyName = "Insert test kjd"; custMapper.Insert(cust1); int res = connMan.GetAffectedRows(); Assert.IsTrue(res == 1); }
private void SeedDB() { var order1 = new FluentMappedOrder { OrderName = "Order 1" }; var order2 = new FluentMappedOrder { OrderName = "Order 2" }; _db.Insert <FluentMappedOrder>(order1); _db.Insert <FluentMappedOrder>(order2); foreach (var order in (new[] { order1, order2 })) { for (var i = 1; i < 3; i++) { var oi = new FluentMappedOrderItem { ItemDescription = order.OrderName + " - Item " + i.ToString(), OrderID = order.ID, Price = 5.5m }; _db.Insert <FluentMappedOrderItem>(oi); var receipt = new FluentMappedReceipt { OrderItemID = oi.ID, AmountPaid = 5.5m }; _db.Insert(receipt); } } }
public static void EmployeeEmit() { IDataMapper test = EmitDataMapper.Build(typeof(Employee), connStr, true); object id = test.Insert(tester); IEnumerable res = test.GetAll(); Employee actual = (Employee)test.GetById(id); test.Delete(actual); Employee original = (Employee)test.GetById(1); test.Update(tester); test.Update(original); }
public static void CustomerEmit() { IDataMapper test = EmitDataMapper.Build(typeof(Customer), connStr, true); object id = test.Insert(insertTestC); IEnumerable res = test.GetAll(); Customer actual = (Customer)test.GetById(id); test.Delete(actual); Customer original = (Customer)test.GetById("ALFKI"); test.Update(updateTestC); test.Update(original); }
public void TestCustomerInsertAndDelete() { // // Create and Insert new Customer // Customer c = new Customer() { CustomerID = "TESTE", CompanyName = "Testing code", ContactName = "Programmer", Address = "IP", City = "Lisbon", PostalCode = "IDK", Region = "Potato", Country = "Test", Phone = "None", Fax = "see above" }; object id = customers.Insert(c); // // Get the new Customer object from database // Customer actual = (Customer)customers.GetById(id); Assert.AreEqual(actual.CustomerID, c.CustomerID); Assert.AreEqual(actual.CompanyName, c.CompanyName); Assert.AreEqual(actual.ContactName, c.ContactName); Assert.AreEqual(actual.Address, c.Address); Assert.AreEqual(actual.City, c.City); Assert.AreEqual(actual.PostalCode, c.PostalCode); Assert.AreEqual(actual.Region, c.Region); Assert.AreEqual(actual.Country, c.Country); Assert.AreEqual(actual.Phone, c.Phone); Assert.AreEqual(actual.Fax, c.Fax); // // Delete the created Customer from database // customers.Delete(actual); object res = customers.GetById(id); actual = res != null ? (Customer)res : default(Customer); Assert.IsNull(actual); }
public static void ProductEmit() { IDataMapper test = EmitDataMapper.Build(typeof(Product), connStr, true); IDataMapper categories = EmitDataMapper.Build(typeof(Category), connStr, true); IDataMapper suppliers = EmitDataMapper.Build(typeof(Supplier), connStr, true); Category c = (Category)categories.GetById(4); Supplier s = (Supplier)suppliers.GetById(17); object id = test.Insert(ProductBuilder(c, s)); IEnumerable res = test.GetAll(); Product actual = (Product)test.GetById(id); test.Delete(actual); Product original = (Product)test.GetById(10); c = (Category)categories.GetById(4); s = (Supplier)suppliers.GetById(17); test.Update(ProductBuilder(c, s)); test.Update(original); }
public void AddEntity(T entity) { DataMapper.Insert(typeof(T).Name + ConfigurationManager.AppSettings["InsertSuffix"], entity); }
public void Add(T entity) { // throw new NotImplementedException(); // _dataSet.Add(entity); _dataMapper.Insert(entity); }
public void Insert(Module module) { _moduleDataMapper.Insert(module); }
public void Insert(CourseProfile profile) { _profileDataMapper.Insert(profile); }
public void Add(T entity) { // throw new NotImplementedException(); // I have no choice but to cheat and write directly in the DB _dataMapper.Insert(entity); }
internal object Insert(string statementName, object parameterObject) { return(dataMapper.Insert(statementName, parameterObject)); }