/// <summary>
/// Instantiates mProps and mOldProps as new Props objects.
/// Instantiates mbdReadable and mdbWriteable as new DB objects.
/// </summary>
protected override void SetUp()
{
mProps = new ProductProps();
mOldProps = new ProductProps();
if (this.mConnectionString == "")
{
mdbReadable = new ProductDB();
mdbWriteable = new ProductDB();
}
else
{
mdbReadable = new ProductDB(this.mConnectionString);
mdbWriteable = new ProductDB(this.mConnectionString);
}
}
public void Setup()
{
db = new ProductDB(dataSource);
p = new ProductProps();
DBCommand command = new DBCommand();
command.CommandText = "usp_testingResetData";
command.CommandType = CommandType.StoredProcedure;
db.RunNonQueryProcedure(command);
p.productID = 100;
p.productCode = "xxx";
p.description = "my test product";
p.onHandQuantity = 2;
p.unitPrice = 99;
}
public static List <Product> GetList(string cnString)
{
ProductDB db = new ProductDB(cnString);
List <Product> products = new List <Product>();
List <ProductProps> props = new List <ProductProps>();
// *** methods in the textdb and sqldb classes don't match
// Ideally, I should go back and fix the IReadDB interface!
props = (List <ProductProps>)db.RetrieveAll(props.GetType());
foreach (ProductProps prop in props)
{
// *** creates the business object from the props objet
Product p = new Product(prop, cnString);
products.Add(p);
}
return(products);
}
public static DataTable GetTable()
{
ProductDB db = new ProductDB();
return(db.RetrieveTable());
}
// *** this is new
public static DataTable GetTable(string cnString)
{
ProductDB db = new ProductDB(cnString);
return(db.RetrieveTable());
}
