public static void AddCustomer(Customer customer)
{
using (context=new NORTHWNDEntities())
{
context.Customers.Add(customer);
context.SaveChanges();
}
}
public static void ModifyCustomer(Expression<Func<Customer, bool>> exp, Customer newData)
{
using (context=new NORTHWNDEntities())
{
var customer = context.Customers.First(exp);
customer = newData;
context.SaveChanges();
}
}
public static Customer RemoveCustomer(string contactName)
{
using (context=new NORTHWNDEntities())
{
var customer = context.Customers.First(x => x.ContactName == contactName);
context.Customers.Remove(customer);
return customer;
context.SaveChanges();
}
}
public static Customer RemoveCustomer(int id)
{
using (context=new NORTHWNDEntities())
{
var customer = context.Customers.Find(id);
context.Customers.Remove(customer);
return customer;
context.SaveChanges();
}
}
public static ICollection<Customer> GetCustomersByOrder(int orderDate, string orderCountry)
{
using (context=new NORTHWNDEntities())
{
var customers =
context.Orders.Where(
x => x.OrderDate.Value.Year == orderDate &&
x.ShipCountry == orderCountry)
.Select(x => x.Customer);
return customers.ToList();
}
}
static void AddOrder(Order order, List<Order_Detail> details)
{
using (var ctx = new NORTHWNDEntities())
{
using (var tran = ctx.Database.BeginTransaction(IsolationLevel.Serializable))
{
ctx.Orders.Add(order);
ctx.SaveChanges();
foreach (var orderDetail in details)
{
ctx.Order_Details.Add(orderDetail);
}
ctx.SaveChanges();
tran.Commit();
}
}
}
public static void AddCustomer(string companyName, string contactName,string contactTitle, string address, string city, string region)
{
using (context=new NORTHWNDEntities())
{
context.Customers.Add(
new Customer()
{
Address = address,
City = city,
CompanyName = companyName,
ContactName = contactName,
ContactTitle = contactTitle,
Region = region
});
context.SaveChanges();
}
}
public static ICollection<Customer> GetCustomersByOrderNative(int orderDate, string orderCountry)
{
using (context=new NORTHWNDEntities())
{
var customers = context.Database.SqlQuery<Customer>(
"SELECT * FROM Customers c INNER JOIN Orders o"
+ " ON c.CustomerID=o.CustomerID" +
" WHERE DATEPART ( year , o.OrderDate )=" + orderDate + " AND o.ShipCountry=" + "'" + orderCountry + "'");
return customers.ToList();
}
}
public static ICollection<Order> FindSales(DateTime start, DateTime end, string region)
{
using (context=new NORTHWNDEntities())
{
var orders =
context.Orders.Where(x => x.OrderDate >= start && x.OrderDate <= end && x.ShipRegion == region);
return orders.ToList();
}
}