public bool InsertCustomer(Customer customer) { bool status = false; using (CustomerDetailsEntities db = new CustomerDetailsEntities()) { db.Customers.Add(customer); if (db.SaveChanges() > 0) { status = true; } } return(status); }
public bool UpdateCustomer(Customer customer) { bool status = false; using (CustomerDetailsEntities db = new CustomerDetailsEntities()) { db.Entry(customer).State = EntityState.Modified; if (db.SaveChanges() > 0) { status = true; } } return(status); }
public bool DeleteCustomer(int id) { bool status = false; using (CustomerDetailsEntities db = new CustomerDetailsEntities()) { Customer customer = db.Customers.Find(id) ?? new Customer(); if (customer != null) { db.Customers.Remove(customer); if (db.SaveChanges() > 0) { status = true; } } } return(status); }
public bool DeleteCity(int id) { bool status = false; using (CustomerDetailsEntities db = new CustomerDetailsEntities()) { City city = db.Cities.Find(id) ?? new City(); if (city != null) { db.Cities.Remove(city); if (db.SaveChanges() > 0) { status = true; } } } return(status); }