public Customer InsertCustomer(Customer _customer) { using (CustomersEntities1 entities = new CustomersEntities1()) { entities.Customers.Add(_customer); entities.SaveChanges(); } return(_customer); }
public void DeleteCustomer(Customer _customer) { using (CustomersEntities1 entities = new CustomersEntities1()) { Customer customer = (from c in entities.Customers where c.CustomerId == _customer.CustomerId select c).FirstOrDefault(); entities.Customers.Remove(customer); entities.SaveChanges(); } }
//GET : HOME public ActionResult Index() { CustomersEntities1 entities = new CustomersEntities1(); List <Customer> customers = entities.Customers.ToList(); if (customers.Count == 0) { customers.Add(new Customer()); } return(View(customers)); }
public bool UpdateCustomer(Customer _customer) { using (CustomersEntities1 entities = new CustomersEntities1()) { Customer updatedCustomer = (from c in entities.Customers where c.CustomerId == _customer.CustomerId select c).FirstOrDefault(); updatedCustomer.Name = _customer.Name; updatedCustomer.Country = _customer.Country; entities.SaveChanges(); } return(true); }