public static HomeSale GetHomeSale(DateTime marketDate, decimal saleAmount)
{
HomeSale result = null;
if (marketDate != null && saleAmount > 0m)
{
using (var context = new HSTDataModel())
{
result = context.HomeSales
.Where(hs =>
hs.MarketDate == marketDate && hs.SaleAmount == saleAmount)
.Include(hs => hs.Home)
.Include(hs => hs.RealEstateCompany)
.Include(hs => hs.Agent)
.Include(hs => hs.Buyer)
.FirstOrDefault();
}
}
return(result);
}
public static HomeSale GetHomeSale(int homesaleID)
{
HomeSale result = null;
if (homesaleID < 0)
{
return(result);
}
using (var context = new HSTDataModel())
{
result = context.HomeSales
.Where(hs =>
hs.SaleID == homesaleID)
.Include(hs => hs.Home)
.Include(hs => hs.RealEstateCompany)
.Include(hs => hs.Agent)
.Include(hs => hs.Buyer)
.FirstOrDefault();
}
return(result);
}
/// <summary>
/// Return a list of objects hydrated from XML file data. Depends on GetXmlFileData().
/// </summary>
/// <param name="filepath"></param>
/// <param name="objName"></param>
/// <returns></returns>
public static List <HomeSale> GetHomeSales(FileInfo filepath, string objName)
{
List <HomeSale> homeSales = new List <HomeSale>();
var xmlFileData = GetXmlFileData(filepath.FullName, objName);
foreach (var hs in xmlFileData)
{
HomeSale homeSale = new HomeSale();
homeSale.SaleID = int.Parse(hs.Element("SaleID").Value);
homeSale.HomeID = int.Parse(hs.Element("HomeID")?.Value);
var date_time = hs.Element("SoldDate")?.Value;
if (date_time == null || date_time == string.Empty)
{
homeSale.SoldDate = null;
}
else
{
homeSale.SoldDate = DateTime.Parse(hs.Element("SoldDate").Value);
}
homeSale.AgentID = int.Parse(hs.Element("AgentID")?.Value);
homeSale.SaleAmount = decimal.Parse(hs.Element("SaleAmount")?.Value);
var buyer_id = hs.Element("BuyerID")?.Value;
if (buyer_id == null || string.IsNullOrEmpty(buyer_id))
{
homeSale.BuyerID = null;
}
else
{
homeSale.BuyerID = int.Parse(buyer_id);
}
homeSale.MarketDate = DateTime.Parse(hs.Element("MarketDate")?.Value);
homeSale.CompanyID = int.Parse(hs.Element("CompanyID")?.Value);
homeSales.Add(homeSale);
}
return(homeSales);
}
/// <summary>
/// Take a generic item and enable removing from the DB via EF.
/// </summary>
/// <typeparam name="T"></typeparam>
/// <param name="item"></param>
/// <returns></returns>
public static bool RemoveEntity <T>(T item)
{
bool result = false;
int itemsAffected = 0;
string name = item.GetType().Name;
using (var context = new HSTDataModel())
{
switch (name)
{
case "Person":
{
Person person = (item as Person);
Person personToDelete = context.People.Find(person.PersonID);
if (personToDelete != null)
{
Person removedPerson = context.People.Remove(personToDelete);
}
break;
}
case "Owner":
{
Owner owner = (item as Owner);
Owner ownerToDelete = context.Owners.Find(owner.OwnerID);
if (ownerToDelete != null)
{
context.Owners.Remove(ownerToDelete);
}
break;
}
case "Home":
{
Home home = (item as Home);
Home homeToDelete = context.Homes.Find(home.HomeID);
if (homeToDelete != null)
{
context.Homes.Remove(homeToDelete);
}
break;
}
case "RealEstateCompany":
{
RealEstateCompany reco = (item as RealEstateCompany);
RealEstateCompany recoToDelete = context.RealEstateCompanies.Find(reco.CompanyID);
if (recoToDelete != null)
{
context.RealEstateCompanies.Remove(recoToDelete);
}
break;
}
case "Agent":
{
Agent agent = (item as Agent);
Agent agentToDelete = context.Agents.Find(agent.AgentID);
if (agentToDelete != null)
{
context.Agents.Remove(agentToDelete);
}
break;
}
case "Buyer":
{
Buyer buyer = (item as Buyer);
Buyer buyerToDelete = context.Buyers.Find(buyer.BuyerID);
if (buyerToDelete != null)
{
context.Buyers.Remove(buyerToDelete);
}
break;
}
case "HomeSale":
{
HomeSale homeSale = (item as HomeSale);
HomeSale homeSaleToDelete = context.HomeSales.Find(homeSale.SaleID);
if (homeSaleToDelete != null)
{
context.HomeSales.Remove(homeSaleToDelete);
}
break;
}
default:
{
break;
}
}
try
{
itemsAffected = context.SaveChanges();
}
catch (Exception ex)
{
throw new Exception("LogicBroker.context.SaveChanges threw an Exception.", ex);
}
if (itemsAffected > 0)
{
result = true;
}
}
return(result);
}
/// <summary>
/// Take a generic item (EXCEPT HomeSale) and enable updating the existing item in the store with properties of the item passed-in.
/// </summary>
/// <typeparam name="T"></typeparam>
/// <param name="item"></param>
/// <returns></returns>
public static bool UpdateExistingItem <T>(T item)
{
bool result = false;
int itemsAffected = 0;
string name = item.GetType().Name;
using (var context = new HSTDataModel())
{
switch (name)
{
case "Person":
{
Person person = item as Person;
Person dbPerson = context.People.Find(person.PersonID);
if (dbPerson == null)
{
break;
}
if (dbPerson.Equals(person))
{
dbPerson.Email = person.Email;
dbPerson.Phone = person.Phone;
}
break;
}
case "Owner":
{
Owner owner = item as Owner;
Owner dbOwner = context.Owners.Find(owner.OwnerID);
if (dbOwner == null)
{
break;
}
if (dbOwner.Homes.Count != owner.Homes.Count && owner.Homes.Count > 0)
{
dbOwner.Homes = owner.Homes;
}
dbOwner.PreferredLender = owner.PreferredLender;
break;
}
case "Home":
{
Home home = item as Home;
Home dbHome = context.Homes.Find(home.HomeID);
if (dbHome == null)
{
break;
}
if (dbHome.HomeSales.Count != home.HomeSales.Count && home.HomeSales.Count > 0)
{
dbHome.HomeSales = home.HomeSales;
}
if (dbHome.Owner != null && dbHome.Owner != home.Owner)
{
dbHome.Owner = home.Owner;
}
break;
}
case "RealEstateCompany":
{
RealEstateCompany reco = item as RealEstateCompany;
RealEstateCompany dbReco = context.RealEstateCompanies.Find(reco.CompanyID);
if (dbReco == null)
{
break;
}
if (dbReco.Phone != reco.Phone)
{
dbReco.Phone = reco.Phone;
}
if (dbReco.HomeSales.Count != reco.HomeSales.Count && reco.HomeSales.Count > 0)
{
dbReco.HomeSales = reco.HomeSales;
}
if (dbReco.Agents.Count != reco.Agents.Count)
{
dbReco.Agents = reco.Agents;
}
break;
}
case "Agent":
{
Agent agent = item as Agent;
Agent dbAgent = context.Agents.Find(agent.AgentID);
if (dbAgent == null)
{
break;
}
if (dbAgent.HomeSales.Count != agent.HomeSales.Count && agent.HomeSales.Count > 0)
{
dbAgent.HomeSales = agent.HomeSales;
}
dbAgent.CommissionPercent = agent.CommissionPercent;
dbAgent.CompanyID = agent.CompanyID;
break;
}
case "Buyer":
{
Buyer buyer = item as Buyer;
Buyer dbBuyer = context.Buyers.Find(buyer.BuyerID);
if (dbBuyer == null)
{
break;
}
if (dbBuyer.HomeSales.Count != buyer.HomeSales.Count && buyer.HomeSales.Count > 0)
{
dbBuyer.HomeSales = buyer.HomeSales;
}
dbBuyer.CreditRating = buyer.CreditRating;
break;
}
case "HomeSale":
{
HomeSale homesale = item as HomeSale;
HomeSale dbHomesale = context.HomeSales.Find(homesale.SaleID);
if (dbHomesale == null)
{
break;
}
if (dbHomesale.MarketDate == homesale.MarketDate)
{
dbHomesale.SoldDate = homesale.SoldDate;
dbHomesale.SaleAmount = homesale.SaleAmount;
}
break;
}
default:
{
break;
}
}
try
{
itemsAffected = context.SaveChanges();
}
catch
{
_ = 0;
}
if (itemsAffected > 0)
{
result = true;
}
if (itemsAffected < 0)
{
result = false;
}
}
return(result);
}
/// <summary>
/// Takes a fundamental HomeSaleTracker type and attempts to add or update the database.
/// Returns 1 if something was saved or updated, 0 otherwise.
/// </summary>
/// <typeparam name="T"></typeparam>
/// <param name="item"></param>
/// <returns></returns>
public static bool StoreItem <T>(T item)
{
bool result = false;
int itemsAffected = 0;
string name = item.GetType().Name;
using (var context = new HSTDataModel())
{
switch (name)
{
case "Person":
{
Person person = item as Person;
context.People.AddOrUpdate(p => new { p.FirstName, p.LastName }, person);
break;
}
case "Agent":
{
Agent agent = item as Agent;
context.Agents.AddOrUpdate(a => new { a.AgentID }, agent);
break;
}
case "Buyer":
{
Buyer buyer = item as Buyer;
context.Buyers.AddOrUpdate(b => new { b.BuyerID }, buyer);
break;
}
case "Owner":
{
Owner owner = item as Owner;
context.Owners.AddOrUpdate(o => new { o.OwnerID }, owner);
break;
}
case "Home":
{
Home home = item as Home;
context.Homes.AddOrUpdate(h => new { h.Address, h.Zip }, home);
break;
}
case "HomeSale":
{
HomeSale homeSale = item as HomeSale;
context.HomeSales.AddOrUpdate(hs => new { hs.SaleID }, homeSale);
break;
}
case "RealEstateCompany":
{
RealEstateCompany reco = item as RealEstateCompany;
context.RealEstateCompanies.AddOrUpdate(re => new { re.CompanyID }, reco);
break;
}
default:
{
itemsAffected = -1;
break;
}
}
itemsAffected = context.SaveChanges();
if (itemsAffected > 0)
{
result = true;
}
if (itemsAffected < 1)
{
result = false;
}
}
return(result);
}
