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);
}