public Employee CreateEmployee(Employee employee) { var dc = new DataClassesDataContext(_connectionString); dc.Employees.InsertOnSubmit(employee); dc.SubmitChanges(); return employee; }
public Customer CreateCustomer(Customer customer) { var dc = new DataClassesDataContext(_connectionString); dc.Customers.InsertOnSubmit(customer); dc.SubmitChanges(); return customer; }
public Category CreateCategory(Category category) { var dc = new DataClassesDataContext(_connectionString); dc.Categories.InsertOnSubmit(category); dc.SubmitChanges(); return category; }
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 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 Supplier[] SearchSupplier(string companyName, string contactName, string counrty) { var dc = new DataClassesDataContext(_connectionString); IQueryable<Supplier> s = from e in dc.Suppliers where (string.IsNullOrEmpty(companyName) || e.CompanyName == companyName) && (string.IsNullOrEmpty(contactName) || e.ContactName == contactName) && (string.IsNullOrEmpty(counrty) || e.Country == counrty) select e; return s.ToArray(); }
public Product[] SearchProduct(Category category, Supplier supplier) { var dc = new DataClassesDataContext(_connectionString); IQueryable<Product> s = from e in dc.Products select e; IEnumerable<Product> ss = from e in s.ToList() where (category == null || e.Category.CategoryID == category.CategoryID) && (supplier == null || e.SupplierID == supplier.SupplierID) select e; try { return ss.ToArray(); } catch (Exception e) { Debug.WriteLine(e); } return new Product[0]; }
public Shipper[] SearchShipper(string companyName, string phone) { var dc = new DataClassesDataContext(_connectionString); IQueryable<Shipper> s = from e in dc.Shippers where (string.IsNullOrEmpty(companyName) || e.CompanyName == companyName) && (string.IsNullOrEmpty(phone) || e.Phone == phone) select e; return s.ToArray(); }
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 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 Product UpdateProduct(Product product) { var dc = new DataClassesDataContext(_connectionString); dc.Products.Attach(product, ReadProduct(product.ProductID)); dc.SubmitChanges(); return product; }
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 Category UpdateCategory(Category category) { var dc = new DataClassesDataContext(_connectionString); dc.Categories.Attach(category, ReadCategory(category.CategoryID)); dc.SubmitChanges(); return category; }
public Employee UpdateEmployee(Employee employee) { var dc = new DataClassesDataContext(_connectionString); dc.Employees.Attach(employee, ReadEmployee(employee.EmployeeID)); dc.SubmitChanges(); return employee; }
public Product ReadProduct(int productId) { var dc = new DataClassesDataContext(_connectionString); IQueryable<Product> s = from e in dc.Products where e.ProductID == productId select e; return s.First(); }
public Order ReadOrder(int orderId) { var dc = new DataClassesDataContext(_connectionString); IQueryable<Order> s = from e in dc.Orders where e.OrderID == orderId select e; return s.First(); }
public Employee ReadEmployee(int employeeId) { var dc = new DataClassesDataContext(_connectionString); IQueryable<Employee> s = from e in dc.Employees where e.EmployeeID == employeeId select e; return s.First(); }
public Customer ReadCustomer(string customerId) { var dc = new DataClassesDataContext(_connectionString); IQueryable<Customer> s = from e in dc.Customers where e.CustomerID == customerId select e; return s.First(); }
public Category ReadCategory(int categoryId) { var dc = new DataClassesDataContext(_connectionString); IQueryable<Category> s = from e in dc.Categories where e.CategoryID == categoryId select e; return s.First(); }
public Customer UpdateCustomer(Customer customer) { var dc = new DataClassesDataContext(_connectionString); dc.Customers.Attach(customer, ReadCustomer(customer.CustomerID)); dc.SubmitChanges(); return customer; }
public Supplier ReadSupplier(int supplierId) { var dc = new DataClassesDataContext(_connectionString); IQueryable<Supplier> s = from e in dc.Suppliers where e.SupplierID == supplierId select e; return s.First(); }
public Order UpdateOrder(Order order) { var dc = new DataClassesDataContext(_connectionString); dc.Orders.Attach(order, ReadOrder(order.OrderID)); dc.SubmitChanges(); return order; }
public Category[] SearchCategory(string categoryName, string description) { var dc = new DataClassesDataContext(_connectionString); IQueryable<Category> s = from e in dc.Categories where (string.IsNullOrEmpty(categoryName) || e.CategoryName == categoryName) && (string.IsNullOrEmpty(description) || e.Description == description) select e; return s.ToArray(); }
public Supplier UpdateSupplier(Supplier supplier) { var dc = new DataClassesDataContext(_connectionString); dc.Suppliers.Attach(supplier, ReadSupplier(supplier.SupplierID)); dc.SubmitChanges(); return supplier; }
public Customer[] SearchCustomer(string companyName, string contactName, string contactTitle) { var dc = new DataClassesDataContext(_connectionString); IQueryable<Customer> s = from e in dc.Customers where (string.IsNullOrEmpty(companyName) || e.CompanyName == companyName) && (string.IsNullOrEmpty(contactTitle) || e.ContactTitle == contactTitle) && (string.IsNullOrEmpty(contactName) || e.ContactName == contactName) select e; return s.ToArray(); }
public Employee[] SearchEmployee(string lastName, string firstName, string title) { var dc = new DataClassesDataContext(_connectionString); IQueryable<Employee> s = from e in dc.Employees where (string.IsNullOrEmpty(lastName) || e.LastName == lastName) && (string.IsNullOrEmpty(firstName) || e.FirstName == firstName) && (string.IsNullOrEmpty(title) || e.Title == title) select e; return s.ToArray(); }
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 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(); }