protected override void SetUp()
{
mProps = new CustomerProps();
mOldProps = new CustomerProps();
if (this.mConnectionString == "")
{
mdbReadable = new CustomerDB();
mdbWriteable = new CustomerDB();
}
else
{
mdbReadable = new CustomerDB(this.mConnectionString);
mdbWriteable = new CustomerDB(this.mConnectionString);
}
}
/// <summary>
/// Retrieves a list of Events.
/// </summary>
///
// *** I had to change this
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);
Product.Add(p);
}
return(products);
}
/// <summary>
/// Retrieves a list of Customers.
/// </summary>
public static List <Customer> GetList(string cnString)
{
CustomerDB db = new CustomerDB(cnString);
List <Customer> customers = new List <Customer>();
List <CustomerProps> props = new List <CustomerProps>();
// *** methods in the textdb and sqldb classes don't match
// Ideally, I should go back and fix the IReadDB interface!
props = (List <CustomerProps>)db.RetrieveAll(props.GetType());
foreach (CustomerProps prop in props)
{
// *** creates the business object from the props objet
Customer c = new Customer(prop, cnString);
customers.Add(c);
}
return(customers);
}
public static void Delete(CustomerProps c)
{
CustomerDB db = new CustomerDB();
db.Delete(c);
}
public static void Delete(int id, string cnString)
{
ProductDB db = new ProductDB(cnString);
db.Delete(id);
}
/// <summary>
/// Deletes the customer identified by the id.
/// </summary>
public static void Delete(int id)
{
ProductDB db = new ProductDB();
db.Delete(id);
}
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());
}
public static void Delete(int id, string cnString)
{
CustomerDB db = new CustomerDB(cnString);
db.Delete(id);
}
/// <summary>
/// Deletes the customer identified by the id.
/// </summary>
public static void Delete(int id)
{
CustomerDB db = new CustomerDB();
db.Delete(id);
}
public static DataTable GetTable()
{
CustomerDB db = new CustomerDB();
return(db.RetrieveTable());
}
// *** this is new
public static DataTable GetTable(string cnString)
{
CustomerDB db = new CustomerDB(cnString);
return(db.RetrieveTable());
}
