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); }