public static void UpdateCustomer(string companyName, string updateCompanyName)
{
using (var db = new NorthwindEntities())
{
Customer updateCustomer = GetCustomerCompanyName(db, companyName);
updateCustomer.CompanyName = updateCompanyName;
db.SaveChanges();
}
}
public static void DeleteCustomer(string companyName)
{
using (var db = new NorthwindEntities())
{
Customer deleteCustomer = GetCustomerCompanyName(db, companyName);
db.Customers.Remove(deleteCustomer);
db.SaveChanges();
}
}
public static void CreateCustomer(string id, string companyName)
{
using (var db = new NorthwindEntities())
{
Customer newCustomer = new Customer
{
CustomerID = id,
CompanyName = companyName
};
db.Customers.Add(newCustomer);
db.SaveChanges();
}
}
public static void FindCustomersWithOrders(string shipedCountry, int year)
{
using (var db = new NorthwindEntities())
{
var orders =
from o in db.Orders
where o.Customer.Country == shipedCountry
select o;
foreach(var item in orders.Where(x => x.OrderDate.Value.Year == year))
{
Console.WriteLine("Company name: {1} --- Order Dates: {0}",
item.OrderDate.Value.ToShortDateString(), item.Customer.CompanyName);
}
}
}
static Customer GetCustomerCompanyName(NorthwindEntities nortwindEntities, string companyName)
{
var result = nortwindEntities.Customers.First(
x => x.CompanyName == companyName);
return result;
}
