public void SearchByDriverByMssql()
{
IDataHandler datahandler = new DBDataHandler(new CarDBContext());
Car expectedResult = datahandler.SearchByDriver("Janos")[5];
Assert.That(expectedResult, Is.Not.Null);
}
public void SearchByColorByMssql()
{
IDataHandler datahandler = new DBDataHandler(new CarDBContext());
Car expectedResult = datahandler.SearchByColor("Red")[0];
Assert.IsTrue(expectedResult.Driver.Equals("Dominic West"));
}
public void Initialize()
{
dataHandlerFactory = new DataHandlerFactory();
xMLDataHandler = new XMLDataHandler();
cSVDataHandler = new CSVDataHandler();
dBDataHandler = new DBDataHandler(new CarDBContext());
}
public static List <Customer> read(string customQuery, string limitQuery)
{
try
{
List <Customer> customers = new List <Customer>();
DBHandler dbHandler = new DBHandler();
string query = "SELECT * FROM customer ";
if (limitQuery != null)
{
query += limitQuery;
}
dbHandler.OPEN(query);
while (dbHandler.reader.Read())
{
Customer customer = new Customer();
customer.code = DBDataHandler.object_to_string(dbHandler.reader["code"]);
customer.name = DBDataHandler.object_to_string(dbHandler.reader["name"]);
customer.address1 = DBDataHandler.object_to_string(dbHandler.reader["address1"]);
customer.email = DBDataHandler.object_to_string(dbHandler.reader["email"]);
customers.Add(customer);
}
dbHandler.CLOSE();
return(customers);
}
catch (Exception)
{
return(null);
}
}
public static List <Inventory> read(string customQuery, string limitQuery)
{
try
{
DBHandler dbHandler = new DBHandler();
List <Inventory> inventories = new List <Inventory>();
string query = "SELECT * FROM inventory ";
if (limitQuery != null)
{
query += limitQuery;
}
dbHandler.OPEN(query);
while (dbHandler.reader.Read())
{
Inventory inventory = new Inventory();
inventory.code = DBDataHandler.object_to_string(dbHandler.reader["code"]);
inventory.name = DBDataHandler.object_to_string(dbHandler.reader["name"]);
inventory.description = DBDataHandler.object_to_string(dbHandler.reader["description"]);
inventory.price = DBDataHandler.object_to_decimal(dbHandler.reader["price"]);
inventories.Add(inventory);
}
dbHandler.CLOSE();
return(inventories);
}
catch (Exception)
{
return(null);
}
}
