public override object Execute()
{
foreach (NewCriteria <T> criteria in _criterias)
{
if (criteria != null)
{
switch (criteria.Criteria)
{
case Utilites.QueryCriteria.ID:
CustomerAccess.GetCustomersByID(Convert.ToInt32(criteria.First));
break;
case Utilites.QueryCriteria.Bithday:
if (criteria.Predicate == "Between")
{
CustomerAccess.GetCustomersByBirthdayBetween(Convert.ToDateTime(criteria.First),
Convert.ToDateTime(criteria.Second));
}
else
{
CustomerAccess.GetCustomersByBirthOfDay(Convert.ToDateTime(criteria.First),
criteria.Predicate);
}
break;
default:
CustomerAccess.GetDataByCriteria(criteria.Criteria,
criteria.Values.Cast <object>().ToArray(), criteria.Predicate);
break;
}
}
}
return(CustomerAccess.GetData());
}
public void CustomerAccess_GetCustomersByBirthdayBetween_TestMethod()
{
SqlConnection connection = ConnectionManager.Connection;
connection.Open();
CustomerAccess.FillDictionary();
CustomerAccess.FillCustomerData();
CustomerAccess.GetCustomersByBirthdayBetween(new DateTime(1970, 1, 1), new DateTime(2016, 01, 01));
DataSet dataSet = (DataSet)CustomerAccess.GetData();
Assert.IsTrue(dataSet.Tables["Customer"].Rows.Count > 0);
}