public Customer InsertCustomer(Customer _customer) { using (customerEntities entities = new customerEntities()) { entities.Customers.Add(_customer); entities.SaveChanges(); } return(_customer); }
protected virtual void Dispose(bool disposing) { if (disposing) { if (this.db != null) { this.db.Dispose(); this.db = null; } } }
public void DeleteCustomer(Customer _customer) { using (customerEntities entities = new customerEntities()) { Customer customer = (from c in entities.Customers where c.CustomerId == _customer.CustomerId select c).FirstOrDefault(); entities.Customers.Remove(customer); entities.SaveChanges(); } }
public bool UpdateCustomer(Customer _customer) { using (customerEntities entities = new customerEntities()) { 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); }
public CustomersRepositoryProvider(customerEntities customerEntities) { this.db = customerEntities; }