static void Main(string[] args)
{
Customer customer = new Customer
{
CustomerID = "MINIV",
Address = "Student city",
City = "Sofia",
CompanyName = "Telerik",
ContactName = "Minka Ivanova",
ContactTitle = "Owner",
Country = "Bulgaria",
Phone = "0711-020364",
PostalCode = "51104"
};
DAO.UpdateCustomer(new Customer { CustomerID = "WOLZA" }, customer);
//3. Write a method that finds all customers who have orders made in 1997 and shipped to Canada
FindCustomers("Canada", 1997);
Console.WriteLine();
//4. Implement previous by using native SQL query and executing it through the DbContext
FindCustomersSqlQuery("Canada", 1997);
//5. Write a method that finds all the sales by specified region and period (start / end dates).
Console.WriteLine(Environment.NewLine + "Orders:");
FindSalesByRegionAndPeriod("SP", new DateTime(1997, 6, 25), new DateTime(1998, 6, 25));
}
public static void InsertCustomer(Customer customer)
{
NorthwndEntities database = new NorthwndEntities();
using (database)
{
database.Customers.Add(customer);
database.SaveChanges();
}
}
public static void DeleteCustomer(Customer customer)
{
NorthwndEntities database = new NorthwndEntities();
using (database)
{
var cust = database.Customers.Find(customer.CustomerID);
database.Customers.Remove(cust);
database.SaveChanges();
}
}
public static void UpdateCustomer(Customer oldCustomer, Customer newCustomer)
{
NorthwndEntities database = new NorthwndEntities();
using (database)
{
var customer = database.Customers.Find(oldCustomer.CustomerID);
customer.Address = newCustomer.Address;
customer.City = newCustomer.City;
customer.CompanyName = newCustomer.CompanyName;
customer.ContactName = newCustomer.ContactName;
customer.ContactTitle = newCustomer.ContactTitle;
customer.Country = newCustomer.Country;
customer.CustomerDemographics = newCustomer.CustomerDemographics;
customer.Fax = newCustomer.Fax;
customer.Orders = newCustomer.Orders;
customer.Phone = newCustomer.Phone;
customer.PostalCode = newCustomer.PostalCode;
customer.Region = newCustomer.Region;
database.SaveChanges();
}
}
