public void TestCleanup() { try { MapRepository.Instance.EnableTraceLogging = false; _db.Delete <FluentMappedReceipt>(r => r.OrderItemID > 0); _db.Delete <FluentMappedOrderItem>(oi => oi.ID > 0); _db.Delete <FluentMappedOrder>(o => o.ID > 0); } finally { _db.Dispose(); } }
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); }
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 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 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); }
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); }
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 void CustomersDelete() { Customer cust1 = new Customer(); cust1.CustomerID = "SERRA"; custMapper.Delete(cust1); int res = connMan.GetAffectedRows(); Assert.IsTrue(res == 1); }
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); }
internal int Delete(string statementName, object parameterObject) { int num = 0; try { num = dataMapper.Delete(statementName, parameterObject); } catch (Exception ex) { throw ex; } return(num); }
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 int DeleteEntity(T entity) { throw new Exception(); return(DataMapper.Delete(typeof(T).Name + ConfigurationManager.AppSettings["DeleteSuffix"], entity)); }
public void Remove(T entity) { // throw new NotImplementedException(); // _dataSet.Remove(entity); _dataMapper.Delete(entity); }
public void Remove(T entity) { // throw new NotImplementedException(); // Again I have to send this to the under layer it knows better the object // Othervise I have to make sure each object has Id with Interface or Abstract class _dataMapper.Delete(entity); }
public void Delete(long id) { _profileDataMapper.Delete(id); }
public void Delete(long id) { _moduleDataMapper.Delete(id); }