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 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 ActionResult Create(Customer customer) { try { CustomerModel customerModel = new CustomerModel(); customerModel.create(customer); return RedirectToAction("Index"); } catch(Exception e) { return RedirectToAction("Error", "Home", new { ErrorMessage = e.Message }); } }
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; } }
public ActionResult Edit(Customer customer) { CustomerModel CustomerModel = new CustomerModel(); CustomerModel.editCustomer(customer); return RedirectToAction("Index"); }
partial void DeleteCustomer(Customer instance);
partial void UpdateCustomer(Customer instance);
partial void InsertCustomer(Customer instance);