public Customer getById(int id) { Customer customer = new Customer(); using (DataClassesOurCompanyDataContext db = new DataClassesOurCompanyDataContext()) { customer = (from c in db.Customers where c.id == id select c).First(); } return customer; }
public void deleteCustomer(int id) { using (DataClassesOurCompanyDataContext db = new DataClassesOurCompanyDataContext()) { Customer customer = (from c in db.Customers where c.id == id select c).First(); db.Customers.DeleteOnSubmit(customer); db.SubmitChanges(); } }
public List<Customer> getAll() { List<Customer> customerList = new List<Customer>(); using (DataClassesOurCompanyDataContext db = new DataClassesOurCompanyDataContext()) { customerList = (from c in db.Customers select c).ToList(); } return customerList; }
public void editCustomer(Customer c) { using (DataClassesOurCompanyDataContext db = new DataClassesOurCompanyDataContext()) { var q = (from cust in db.Customers where cust.id == c.id select cust).First(); q.Name = c.Name; q.Address = c.Address; q.TelephoneNo = c.TelephoneNo; q.EmailAddress = c.EmailAddress; db.SubmitChanges(); } }
public void create(Customer c) { try { using (DataClassesOurCompanyDataContext db = new DataClassesOurCompanyDataContext()) { Customer cust = new Customer(); cust.Name = c.Name; cust.Address = c.Address; cust.TelephoneNo = c.TelephoneNo; cust.EmailAddress = c.EmailAddress; db.Customers.InsertOnSubmit(cust); db.SubmitChanges(); } } catch (Exception e) { throw e; } }