public void DeleteAddress(int postalCode, string addressLine1) { using (var database = new EstateBrokerContext()) { database.Addresses.Remove(database.Addresses.Find(postalCode, addressLine1)); database.SaveChanges(); } }
public void DeleteProperty(int ID) { using (var database = new EstateBrokerContext()) { database.Properties.Remove(database.Properties.Find(ID)); database.SaveChanges(); } }
public int CreateProperty(double estimatedPrice, int caseID, int postalCode, string adressLine1) { var database = new EstateBrokerContext(); var property = new Database.Property() { EstimatedPrice = estimatedPrice, PostalCode = postalCode, AddressLine1 = adressLine1, CaseID = caseID }; database.Properties.Add(property); database.SaveChanges(); return(property.PropertyID); }
public bool UpdateAddress(int postalCode, string addressLine1, double ownershipCost, int exteriorArea, int interiorArea) { try { using (var database = new EstateBrokerContext()) { Address address = database.Addresses.Find(postalCode, addressLine1); address.OwnershipCost = ownershipCost; address.ExteriorArea = exteriorArea; address.InteriorArea = interiorArea; database.SaveChanges(); } return(true); } catch { return(false); } }
public int CreateAddress(int postalCode, string addressLine1, string addressLine2, double ownershipCost, int exteriorArea, int interiorArea, int buildYear) { var database = new EstateBrokerContext(); var address = new Database.Address(); { address.PostalCode = postalCode; address.AddressLine1 = addressLine1; address.AddressLine2 = addressLine2; address.OwnershipCost = ownershipCost; address.ExteriorArea = exteriorArea; address.InteriorArea = interiorArea; address.BuildYear = buildYear; }; database.Addresses.Add(address); database.SaveChanges(); return(address.PostalCode); }
public bool UpdateProperty(int ID, double estimatedPrice, int caseID, int postalCode, string adressLine1) { try { using (var database = new EstateBrokerContext()) { Database.Property property = database.Properties.Find(ID); property.EstimatedPrice = estimatedPrice; property.CaseID = caseID; property.PostalCode = postalCode; property.AddressLine1 = adressLine1; database.SaveChanges(); } return(true); } catch { return(false); } }