public static void TestDaoClass(NorthwindEntities context, Customer customer)
{
NorthwindDao.AddCustomer(context, customer);
Customer addedCustomer = NorthwindDao.FindCustomerById(context, customer.CustomerID);
Console.WriteLine("Added customer:");
PrintCustomerInformation(addedCustomer);
customer.ContactTitle = "UPDATED TITLE";
NorthwindDao.EditCustomer(context, customer);
Customer updatedCustomer = NorthwindDao.FindCustomerById(context, customer.CustomerID);
Console.WriteLine("Updated customer:");
PrintCustomerInformation(updatedCustomer);
NorthwindDao.DeleteCustomer(context, customer);
Customer deletedCustomer = NorthwindDao.FindCustomerById(context, customer.CustomerID);
Console.WriteLine("Deleted customer:");
PrintCustomerInformation(deletedCustomer);
}
public static void FilterOrdersByYearAndDestinationWithSqlQuery(NorthwindEntities context)
{
IEnumerable <Customer> filteredCustomersByQuery =
NorthwindDao.FindCustomersWithSpecialOrdersWithSqlQuery(context, 1997, "Canada");
Console.WriteLine("\n*************************************************************\n");
Console.WriteLine("Customers with orders made in 1997 and shipped to Canada With SQL:");
foreach (var currentCustomer in filteredCustomersByQuery)
{
PrintCustomerInformation(currentCustomer);
}
}
public static void FilterSalesByRegionAndperiod(NorthwindEntities context)
{
Console.WriteLine("\n*************************************************************\n");
Console.WriteLine("Sales by region and period:");
DateTime startDate = new DateTime(1998, 1, 1, 0, 0, 0);
DateTime endDate = DateTime.Now;
IEnumerable <Order> filteredSales = NorthwindDao.FindSalesByRegionInPerion(context, "RJ", startDate, endDate);
foreach (var order in filteredSales)
{
PrintOrderInformation(order);
}
Console.WriteLine("\n*************************************************************\n");
}