} //end of Retrieve() public object RetrieveAll(Type type) { List <ProductProps> list = new List <ProductProps>(); DBDataReader reader = null; ProductProps props; try { reader = RunProcedure("usp_ProductSelectAll"); if (!reader.IsClosed) { while (reader.Read()) { props = new ProductProps(); props.SetState(reader); list.Add(props); } } return(list); } catch (Exception e) { // log this exception throw e; } finally { if (!reader.IsClosed) { reader.Close(); } } }
public void TestSetState() { string xml = p.GetState(); p1.SetState(xml); Assert.True(xml == p1.GetState()); }
public void TestSetStateXML() { ProductProps newP = new ProductProps(); string xml = p.GetState(); newP.SetState(xml); Assert.AreEqual(newP.productID, p.productID); Assert.AreEqual(newP.description, p.description); }
public void TestSetState() { string xml = props1.GetState(); props2.SetState(xml); Assert.AreEqual(props1.description, props2.description); Assert.AreEqual(props1.unitPrice, props2.unitPrice); }
public void TestSetState() { string xml = props1.GetState(); ProductProps props2 = new ProductProps(); props2.SetState(xml); Assert.AreEqual(props1.ProductCode, props2.ProductCode); Assert.AreEqual(props1.Description, props2.Description); }
public void TestSetState() { string xml = props1.GetState(); ProductProps props2 = new ProductProps(); props2.SetState(xml); Assert.AreEqual(props1.ID, props2.ID); Assert.AreEqual(props1.productcode, props2.productcode); Assert.AreEqual(props1.unitprice, props2.unitprice); Assert.AreEqual(props1.onhandquantity, props2.onhandquantity); Assert.AreEqual(props1.ConcurrencyID, props2.ConcurrencyID); }
public void SetStateTest() { ProductProps props2 = new ProductProps(); props2.SetState(props.GetState()); Assert.AreEqual(props.ID, props2.ID); Assert.AreEqual(props.productCode, props2.productCode); Assert.AreEqual(props.description, props2.description); Assert.AreEqual(props.unitPrice, props2.unitPrice); Assert.AreEqual(props.onHandQuantity, props2.onHandQuantity); Assert.AreEqual(props.ConcurrencyID, props2.ConcurrencyID); }
public void TestSetState() { string output = p.GetState(); ProductProps newP = new ProductProps(); newP.SetState(output); Assert.AreEqual(p.ID, newP.ID); Assert.AreEqual(p.Code, newP.Code); Assert.AreEqual(p.Description, newP.Description); Assert.AreEqual(p.Quantity, newP.Quantity); Assert.AreEqual(p.ConcurrencyID, newP.ConcurrencyID); }
public void TestSetState() { string pString = testp.GetState(); ProductProps p2 = new ProductProps(); p2.SetState(pString); Assert.AreEqual(testp.ID, p2.ID); Assert.AreEqual(testp.quantity, p2.quantity); Assert.AreEqual(testp.code, p2.code); Assert.AreEqual(testp.price, p2.price); Assert.AreEqual(testp.description, p2.description); Assert.AreEqual(testp.ConcurrencyID, p2.ConcurrencyID); }
public IBaseProps Retrieve(Object key) { DBDataReader data = null; ProductProps props = new ProductProps(); DBCommand command = new DBCommand(); command.CommandText = "usp_ProductSelect"; command.CommandType = CommandType.StoredProcedure; command.Parameters.Add("@ProductID", SqlDbType.Int); command.Parameters["@ProductID"].Value = (Int32)key; try { data = RunProcedure(command); if (!data.IsClosed) { if (data.Read()) { props.SetState(data); } else { throw new Exception("Record doesn't exist in the database."); } } return(props); } catch (Exception e) { throw; } finally { if (data != null) { if (!data.IsClosed) { data.Close(); } } } }
public void SetStateTest() { ProductProps props2 = new ProductProps(); props2.SetState(props.GetState()); Assert.AreEqual(props.ID, props2.ID); Assert.AreEqual(props.ProductCode, props2.ProductCode); Assert.AreEqual(props.Description, props2.Description); Assert.AreEqual(props.UnitPrice, props2.UnitPrice); Assert.AreEqual(props.OnHandQuantity, props2.OnHandQuantity); Assert.AreEqual(props.ConcurrencyID, props2.ConcurrencyID); //finish properties //test clone // do productprops in the same way. // }
public void SetStateTest() { ProductProps props2 = new ProductProps(); props2.SetState(props.GetState()); Assert.AreEqual(props.productID, props2.productID); Assert.AreEqual(props.productCode, props2.productCode); Assert.AreEqual(props.description, props2.description); Assert.AreEqual(props.unitPrice, props2.unitPrice); Assert.AreEqual(props.onHandQuantity, props2.onHandQuantity); Assert.AreEqual(props.ConcurrencyID, props2.ConcurrencyID); string output1 = props.GetState(); string output2 = props2.GetState(); Console.WriteLine(output1); Console.WriteLine(output2); }