public List <Customer> GetAll()
{
using (INFODYNAMICSEntities db = new INFODYNAMICSEntities())
{
return(db.Customers.ToList());
}
}
public Customer GetById(int id)
{
using (INFODYNAMICSEntities db = new INFODYNAMICSEntities())
{
return(db.Customers.Find(id));
}
}
public void Update(Customer customer)
{
using (INFODYNAMICSEntities db = new INFODYNAMICSEntities())
{
db.Customers.Attach(customer);
db.Entry(customer).State = EntityState.Modified;
db.SaveChanges();
}
}
public Customer Insert(Customer customer)
{
using (INFODYNAMICSEntities db = new INFODYNAMICSEntities())
{
db.Customers.Add(customer);
db.SaveChanges();
return(customer);
}
}
public void Delete(Customer customer)
{
using (INFODYNAMICSEntities db = new INFODYNAMICSEntities())
{
db.Customers.Attach(customer);
db.Customers.Remove(customer);
db.SaveChanges();
}
}
