// deleting a customer and everything connected to it
public bool deleteCustomer(string CustomerID)
{
Customer c = null;
Person p = null;
Property pr = null;
Address a = null;
c = db.Customers.Where(i => i.custID == CustomerID).FirstOrDefault();
if (c != null)
{
db.DeleteObject(c);
p = db.People.Where(i => i.Customer_Id == c.Id).FirstOrDefault();
}
if (p != null)
{
pr = db.Properties.Where(o => o.Customer_Id == c.Id).FirstOrDefault();
db.DeleteObject(p);
}
if (pr != null)
{
a = db.Addresses.Where(i => i.Id == pr.Address_Id).FirstOrDefault();
db.DeleteObject(pr);
db.DeleteObject(a);
}
db.SaveChanges();
return(true);
}
// deleting a customer and everything connected to it
public bool deleteEmployee(string EmployeeID)
{
Employee c = db.Employees.Where(i => i.empID == EmployeeID).FirstOrDefault();
Address a = db.Addresses.Where(i => i.Id == c.Address_Id).FirstOrDefault();
if (c != null && a != null)
{
db.DeleteObject(a);
db.DeleteObject(c);
db.SaveChanges();
return(true);
}
else
{
return(false);
}
}
