partial void UpdateSupplier(Supplier instance);
partial void DeleteSupplier(Supplier instance);
partial void InsertSupplier(Supplier instance);
public Supplier CreateSupplier(Supplier supplier)
{
var dc = new DataClassesDataContext(_connectionString);
dc.Suppliers.InsertOnSubmit(supplier);
dc.SubmitChanges();
return supplier;
}
public Supplier UpdateSupplier(Supplier supplier)
{
var dc = new DataClassesDataContext(_connectionString);
dc.Suppliers.Attach(supplier, ReadSupplier(supplier.SupplierID));
dc.SubmitChanges();
return supplier;
}
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 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();
}