} //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);
}
