public void Add(Home home)
{
home.HomeID = getLastId() + 1;
var h1 = _homes.SingleOrDefault(h => h.HomeID == home.HomeID);
if (h1 == null)
{
_homes.Add(home);
using (HomeTrackerModel1 db = new HomeTrackerModel1())
{
try
{
home.OwnerID = home.Owner.OwnerID;
db.Homes.Add(home);
db.SaveChanges(); //tried to add home with out owner and had this exception thrown. Owner can't be an option?
}
catch (Exception ex)
{
int i = 0;
}
}
}
}
public void Add(Home home)
{
home.HomeID = getLastId() + 1;
var h1 = _homes.SingleOrDefault(h => h.HomeID == home.HomeID);
if (h1 == null)
{
_homes.Add(home);
using (HomeTrackerModel1 db = new HomeTrackerModel1())
{
try
{
home.OwnerID = home.Owner.OwnerID;
home.Owner = null;
db.Homes.Add(home);
db.SaveChanges();
}
catch (Exception)
{
int i = 0;
}
}
}
}
public bool Remove(Home removeMe)
{
bool removed = false;
if (_homes.Remove(removeMe))
{
removed = true;
using (HomeTrackerModel1 db = new HomeTrackerModel1())
{
var homeSalesToRemove = from hs in db.HomeSales
where hs.HomeID == removeMe.HomeID
select hs;
try
{
foreach (var hs in homeSalesToRemove)//could have used single or default
{
db.Entry(hs).State = EntityState.Deleted;
}
db.Entry(removeMe).State = EntityState.Deleted;
db.SaveChanges();
}
catch (Exception ex)
{
//notify user
}
}
}
return(removed);
}
public void RemoveHomeList()
{
using (var db = new HomeTrackerModel1())
{
homesRM = new HomeCollection(db.Homes.ToList());
this.RemoveListBox.DisplayMemberPath = "Address";
this.RemoveListBox.SelectedValuePath = "HomeID";
this.RemoveListBox.ItemsSource = homesRM;
}
}
private void CheckAgent_Checked(object sender, RoutedEventArgs e)
{
using (var db = new HomeTrackerModel1())
{
homeCollection = new HomeCollection(db.Homes.ToList());
this.HomeListBox.DisplayMemberPath = "Address";
this.HomeListBox.SelectedValuePath = "HomeID";
this.HomeListBox.ItemsSource = homeCollection;
}
}
private int getLastId()
{
int ret = -1;
using (HomeTrackerModel1 db = new HomeTrackerModel1())
{
ret = db.Homes.Max(p => p.HomeID);
}
return(ret);
}
private int getLastId()
{
int ret = -1;
using (HomeTrackerModel1 db = new HomeTrackerModel1())
{
ret = db.People.Max(p => p.PersonID);
}
return(ret);
}
private void Button_Click_3(object sender, RoutedEventArgs e)//refresh db
{
using (HomeTrackerModel1 db = new HomeTrackerModel1())
{
//retrieve data:
homeCollection = new HomeCollection(db.Homes.ToList());
homeSalesCollection = new HomeSalesCollection(db.HomeSales.ToList());
peopleCollection = new PeopleCollection(db.People.ToList());
realEstateCompaniesCollection = new RealEstateCompanyCollection(db.RealEstateCompanies.ToList());
}
HomeDataGrid.DataContext = homeCollection;
}
private void LoadHomesList()
{
using (var db = new HomeTrackerModel1())
{
homeCollection = new HomeCollection(db.Homes.ToList());
this.HomeListBox.DisplayMemberPath = "Address";
this.HomeListBox.SelectedValuePath = "HomeID";
this.HomeListBox.ItemsSource = homeCollection;
realEstateCompaniesCollection = new RealEstateCompanyCollection(db.RealEstateCompanies.ToList());
this.CompanyListBox.DisplayMemberPath = "CompanyName";
this.CompanyListBox.SelectedValuePath = "CompanyID";
this.CompanyListBox.ItemsSource = realEstateCompaniesCollection;
}
}
public Form1()
{
InitializeComponent();
var homeCollection = new HomeCollection();
using (HomeTrackerModel1 db = new HomeTrackerModel1())//move this to form load
{
//retrieve data:
Home home = (from h in db.Homes
select h).FirstOrDefault();
homeCollection.Add(home);
}
foreach (Home home in homeCollection)
{
//searchBox.Text = home.Address; ADD THIS BACK EVENTUALLY, THIS WAS THE TEST TO SEE IF WE CAN CONNECT to db
}
}
public MainWindow()
{
homeCollection = new HomeCollection();
homeSalesCollection = new HomeSalesCollection();
peopleCollection = new PeopleCollection();
realEstateCompaniesCollection = new RealEstateCompanyCollection();
InitializeComponent();
DataContext = this;
using (HomeTrackerModel1 db = new HomeTrackerModel1())
{
//retrieve data:
homeCollection = new HomeCollection(db.Homes.ToList());
homeSalesCollection = new HomeSalesCollection(db.HomeSales.ToList());
peopleCollection = new PeopleCollection(db.People.ToList());
realEstateCompaniesCollection = new RealEstateCompanyCollection(db.RealEstateCompanies.ToList());
addHomeWindow = new AddHome(peopleCollection, homeCollection);
updateHomesWindow = new UpdateHomes(peopleCollection, homeCollection, homeSalesCollection, realEstateCompaniesCollection);
removeAHomeWindow = new removeAHome(peopleCollection, homeCollection);
}
}
public void Update(HomeSale homeSale)
{
if (homeSale == null)
{
return;
}
using (HomeTrackerModel1 db = new HomeTrackerModel1())
{
try
{
db.Entry(homeSale).State = EntityState.Modified;
db.SaveChanges();
}
catch (Exception ex)
{
//Todo: notify user
int i = 0;
}
}
}
public void Add(Person person)
{
person.PersonID = getLastId() + 1;
var p1 = _peopleList.SingleOrDefault(p => p.PersonID == person.PersonID);
if (p1 == null)
{
_peopleList.Add(person);
using (HomeTrackerModel1 db = new HomeTrackerModel1())
{
try
{
db.Entry(person).State = EntityState.Added;
if (person.Owner != null)
{
person.Owner.OwnerID = person.PersonID;
db.Entry(person.Owner).State = EntityState.Added;
}
if (person.Agent != null)
{
person.Agent.AgentID = person.PersonID;
db.Entry(person.Agent).State = EntityState.Added;
}
if (person.Buyer != null)
{
person.Buyer.BuyerID = person.PersonID;
db.Entry(person.Buyer).State = EntityState.Added;
}
db.SaveChanges();
}
catch (Exception ex)
{
int i = 0;
}
}
}
}
public void Add(HomeSale homeSale)
{
homeSale.SaleID = getLastId() + 1;
var homeS = _homeSales.SingleOrDefault(hs => hs.SaleID == homeSale.SaleID);
if (homeS == null)
{
_homeSales.Add(homeSale);
using (HomeTrackerModel1 db = new HomeTrackerModel1())
{
try
{
db.HomeSales.Add(homeSale);
db.SaveChanges();
}
catch (Exception ex)
{
//Todo: notify user
int i = 0;
}
}
}
}
