public void SelectWjereInvalidStatement()
{
ACAD food = new CADFood("GebatDataConnectionString");
food.SelectWhere("Name = ; ");
}
public void SelectWhereFailConn()
{
setFailConn();
ACAD food = new CADFood("GebatDataConnectionString");
food.SelectWhere("Name = 'Patates'");
}
public void SelectWhereInvalidStart()
{
ACAD food = new CADFood("GebatDataConnectionString");
food.SelectWhere("Name = 'Patates'", -3);
}
public void SelectWhere()
{
ACAD food = new CADFood("GebatDataConnectionString");
DataTable expected = tableFormat;
DataRow row = expected.NewRow();
row["Id"] = 1;
row["Name"] = "Patates";
row["Quantity"] = 2;
expected.Rows.Add(row);
DataTable actual = food.SelectWhere("Name = 'Patates'");
for (int i = 0; i < expected.Rows.Count; i++)
{
Assert.AreEqual(expected.Rows[i]["Id"], actual.Rows[i]["Id"]);
Assert.AreEqual(expected.Rows[i]["Name"], actual.Rows[i]["Name"]);
Assert.AreEqual(expected.Rows[i]["Quantity"], actual.Rows[i]["Quantity"]);
}
}
