public static IEnumerable<Customer> ReadList()
{
CustomerDataContext context = new CustomerDataContext();
IEnumerable<Customer> custList = context.Customers;
return custList;
}
public static Customer ReadItem(string customerID)
{
CustomerDataContext context = new CustomerDataContext();
Customer cust = context.Customers.Single(c => c.CustomerID == customerID);
return cust;
}
public static void Delete(string customerID)
{
CustomerDataContext context = new CustomerDataContext();
Customer cust = context.Customers.Single(c => c.CustomerID == customerID);
context.Customers.DeleteOnSubmit(cust);
context.SubmitChanges();
}
public static Customer Create(Customer newCustomer)
{
CustomerDataContext context = new CustomerDataContext();
context.Customers.InsertOnSubmit(newCustomer);
context.SubmitChanges();
Customer cust = context.Customers.Single(c => c.CustomerID == newCustomer.CustomerID);
return cust;
}
public static void Update(Customer customer, string customerID)
{
CustomerDataContext context = new CustomerDataContext();
Customer cust = context.Customers.Single(c => c.CustomerID == customer.CustomerID);
cust.CustomerID = customer.CustomerID;
cust.Address = customer.Address;
cust.City = customer.City;
cust.CompanyName = customer.CompanyName;
cust.ContactName = customer.ContactName;
cust.ContactTitle = customer.ContactTitle;
cust.Country = customer.Country;
cust.Fax = customer.Fax;
cust.Phone = customer.Phone;
cust.PostalCode =customer.PostalCode;
cust.Region = customer.Region;
context.SubmitChanges();
}
