public Employee CreateEmployee(Employee employee)
{
var dc = new DataClassesDataContext(_connectionString);
dc.Employees.InsertOnSubmit(employee);
dc.SubmitChanges();
return employee;
}
public Category CreateCategory(Category category)
{
var dc = new DataClassesDataContext(_connectionString);
dc.Categories.InsertOnSubmit(category);
dc.SubmitChanges();
return category;
}
public Customer CreateCustomer(Customer customer)
{
var dc = new DataClassesDataContext(_connectionString);
dc.Customers.InsertOnSubmit(customer);
dc.SubmitChanges();
return customer;
}
public Product CreateProduct(Product product)
{
var dc = new DataClassesDataContext(_connectionString);
if (product.Category != null)
{
dc.Categories.Attach(product.Category, false);
}
if (product.Supplier != null)
{
dc.Suppliers.Attach(product.Supplier, false);
}
dc.Products.InsertOnSubmit(product);
dc.SubmitChanges();
return product;
}
public Order CreateOrder(Order order)
{
var dc = new DataClassesDataContext(_connectionString);
if (order.Shipper != null)
{
dc.Shippers.Attach(order.Shipper, false);
}
if (order.Customer != null)
{
dc.Customers.Attach(order.Customer, false);
}
if (order.Employee != null)
{
dc.Employees.Attach(order.Employee, false);
}
dc.Orders.InsertOnSubmit(order);
dc.SubmitChanges();
return order;
}
public Supplier UpdateSupplier(Supplier supplier)
{
var dc = new DataClassesDataContext(_connectionString);
dc.Suppliers.Attach(supplier, ReadSupplier(supplier.SupplierID));
dc.SubmitChanges();
return supplier;
}
public Product UpdateProduct(Product product)
{
var dc = new DataClassesDataContext(_connectionString);
dc.Products.Attach(product, ReadProduct(product.ProductID));
dc.SubmitChanges();
return product;
}
public Order UpdateOrder(Order order)
{
var dc = new DataClassesDataContext(_connectionString);
dc.Orders.Attach(order, ReadOrder(order.OrderID));
dc.SubmitChanges();
return order;
}
public Employee UpdateEmployee(Employee employee)
{
var dc = new DataClassesDataContext(_connectionString);
dc.Employees.Attach(employee, ReadEmployee(employee.EmployeeID));
dc.SubmitChanges();
return employee;
}
public void DeleteCustomer(Customer customer)
{
var dc = new DataClassesDataContext(_connectionString);
IQueryable<Customer> s = from e in dc.Customers
where e.CustomerID == customer.CustomerID
select e;
dc.Customers.DeleteOnSubmit(s.First());
dc.SubmitChanges();
}
public Category UpdateCategory(Category category)
{
var dc = new DataClassesDataContext(_connectionString);
dc.Categories.Attach(category, ReadCategory(category.CategoryID));
dc.SubmitChanges();
return category;
}
public void DeleteSupplier(Supplier supplier)
{
var dc = new DataClassesDataContext(_connectionString);
IQueryable<Supplier> s = from e in dc.Suppliers
where e.SupplierID == supplier.SupplierID
select e;
dc.Suppliers.DeleteOnSubmit(s.First());
dc.SubmitChanges();
}
public void DeleteProduct(Product product)
{
var dc = new DataClassesDataContext(_connectionString);
IQueryable<Product> s = from e in dc.Products
where e.ProductID == product.ProductID
select e;
dc.Products.DeleteOnSubmit(s.First());
dc.SubmitChanges();
}
public void DeleteEmployee(Employee employee)
{
var dc = new DataClassesDataContext(_connectionString);
IQueryable<Employee> s = from e in dc.Employees
where e.EmployeeID == employee.EmployeeID
select e;
dc.Employees.DeleteOnSubmit(s.First());
dc.SubmitChanges();
}
public Customer UpdateCustomer(Customer customer)
{
var dc = new DataClassesDataContext(_connectionString);
dc.Customers.Attach(customer, ReadCustomer(customer.CustomerID));
dc.SubmitChanges();
return customer;
}
public Supplier CreateSupplier(Supplier supplier)
{
var dc = new DataClassesDataContext(_connectionString);
dc.Suppliers.InsertOnSubmit(supplier);
dc.SubmitChanges();
return supplier;
}
public void DeleteCategory(Category category)
{
var dc = new DataClassesDataContext(_connectionString);
IQueryable<Category> s = from e in dc.Categories
where e.CategoryID == category.CategoryID
select e;
dc.Categories.DeleteOnSubmit(s.First());
dc.SubmitChanges();
}