public void AddCustomer(Customer customer)
{
using (var _db = new CRUDEFEntities()) {
_db.Customers.Add(customer);
_db.SaveChanges();
}
}
public List <Customer> GetAllCustomers()
{
using (var _db = new CRUDEFEntities()) {
IQueryable <Customer> list = from c in _db.Customers
select c;
return(list.ToList());
}
}
public void DeleteCustomer(int idCustomer)
{
using (var _db = new CRUDEFEntities()) {
var currentCustomer = _db.Customers.SingleOrDefault(c => c.CustomerID == idCustomer);
_db.Entry(currentCustomer).State = System.Data.Entity.EntityState.Deleted;
_db.SaveChanges();
}
}
public void UpdateCustomer(Customer customer)
{
using (var _db = new CRUDEFEntities()) {
var customer_temp = _db.Customers.SingleOrDefault(c => c.CustomerID == customer.CustomerID);
_db.Entry(customer_temp).CurrentValues.SetValues(customer);
_db.SaveChanges();
}
}
public Customer GetCustomerByID(int idCustomer)
{
using (var _db = new CRUDEFEntities())
{
var currentCustomer = from c in _db.Customers
where c.CustomerID.Equals(idCustomer)
select c;
return(currentCustomer.Single());
}
}
