public void TestRetrieveAll() { ProductSQLDB db = new ProductSQLDB(dataSource); List <ProductProps> propsList = (List <ProductProps>)db.RetrieveAll(db.GetType()); Assert.AreEqual(16, propsList.Count); }
public void TestRetrieveAll() { ProductSQLDB db = new ProductSQLDB(dataSource); // create and fill list of ProductProps List <ProductProps> cProps = (List <ProductProps>)db.RetrieveAll(db.GetType()); // cProps count should be equal to 16 (length of MMABooksUpdated Products table) Assert.AreEqual(16, cProps.Count); }
public void TestCreate() { ProductSQLDB db = new ProductSQLDB(dataSource); ProductProps p = new ProductProps(); List <ProductProps> propList = (List <ProductProps>)db.RetrieveAll(typeof(ProductProps)); p.ID = 800; p.description = "Description"; p.onhandquantity = 400; p.unitprice = 515.25m; p.ConcurrencyID = 1; Assert.AreEqual(16, propList.Count); ProductProps newProp = (ProductProps)db.Create(p); List <ProductProps> newList = (List <ProductProps>)db.RetrieveAll(typeof(ProductProps)); Assert.AreEqual(17, newList.Count); Assert.AreEqual(52.50m, propList[9].unitprice); ProductProps anotherProp = (ProductProps)db.Create(newProp); }
public void TestRetrieveAll() { list = (List <ProductProps>)db.RetrieveAll(props.GetType()); Assert.AreEqual(list.Count, 16); }