public Employee CreateEmployee(Employee employee)
{
var dc = new DataClassesDataContext(_connectionString);
dc.Employees.InsertOnSubmit(employee);
dc.SubmitChanges();
return employee;
}
partial void DeleteEmployee(Employee instance);
partial void UpdateEmployee(Employee instance);
partial void InsertEmployee(Employee instance);
public Employee UpdateEmployee(Employee employee)
{
var dc = new DataClassesDataContext(_connectionString);
dc.Employees.Attach(employee, ReadEmployee(employee.EmployeeID));
dc.SubmitChanges();
return employee;
}
public Order[] SearchOrder(Employee employee, DateTime dateFrom, DateTime dateTo)
{
var dc = new DataClassesDataContext(_connectionString);
IQueryable<Order> s = from e in dc.Orders
where (dateFrom == default(DateTime) || e.ShippedDate >= dateFrom)
&& (dateTo == default(DateTime) || e.ShippedDate < dateTo)
&& (employee == null || e.Employee == employee)
select e;
return s.ToArray();
}
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();
}