public Entities.Address ReadAddress(int postalCode, string addressLine1)
{
using (var database = new EstateBrokerContext())
{
return((Entities.Address)AddressFactory.CreateAddress(database.Addresses.Find(postalCode, addressLine1)));
}
}
public Entities.Property ReadPropertyFromCaseID(int ID)
{
using (var database = new EstateBrokerContext())
{
return((Entities.Property)PropertyFactory.CreateProperty(database.Properties.FirstOrDefault(a => a.CaseID == ID)));
}
}
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 List <Entities.Property> GetAllProperties()
{
List <Entities.Property> workingList = new List <Entities.Property>();
using (var database = new EstateBrokerContext())
{
foreach (var Property in database.Properties)
{
workingList.Add((Entities.Property)PropertyFactory.CreateProperty(Property));
}
}
return(workingList);
}
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);
}
}
