internal void SetSelectedHouse(NHA selectedNha)
{
SelectedHouse = selectedNha;
if (selectedNha != null)
{
using (QUANLYNHADATEntities db = new QUANLYNHADATEntities())
{
SelectedHouseForRent = db.CHITIETNHATHUEs.FirstOrDefault(item => item.MANHA == selectedNha.MANHA);
SelectedHouseForSale = db.CHITIETNHABANs.FirstOrDefault(item => item.MANHA == selectedNha.MANHA);
}
}
else
{
SelectedHouseForRent = new CHITIETNHATHUE();
SelectedHouseForSale = new CHITIETNHABAN();
}
if (SelectedHouseForRent != null)
{
HouseType = 0;
}
else if (SelectedHouseForSale != null)
{
HouseType = 1;
}
}
private async void ExecuteEditHouseCommand(object key)
{
var values = (object[])key;
this.ModifiedHouse = NhaDAO.GetInstance().GetHouseById(values);
this.ModifiedRentalHouseDetail = ChiTietNhaThueDAO.GetInstance().GetRentalhouseDetailById(values);
var selectedhHouseCate = this.allHouseCategories.FirstOrDefault(c => c.MALOAI == this.ModifiedHouse.MALOAI);
var cateIndex = this.allHouseCategories.IndexOf(selectedhHouseCate);
this.HouseDetailViewModel = new HouseDetailViewModel
{
HouseCateSelectedIndex = cateIndex,
SelectedHouse = this.ModifiedHouse,
SelectedRentalHouseDetail = this.ModifiedRentalHouseDetail,
AgenciesCollection = this.allAgencies,
HouseOwnersCollection = this.allHouseOwners,
StaffsCollection = this.allStaffs,
HouseCatesCollection = this.allHouseCategories
};
var view = new HouseDetailDialog
{
DataContext = this.HouseDetailViewModel
};
//show the dialog
var result = await DialogHost.Show(view, BaseMainWindowViewModel.Instance.Identifier, ExtendedOpenedEventHandler, EditHouseClosingEventHandler).ConfigureAwait(false);
//check the result...
Console.WriteLine("Dialog was closed, the CommandParameter used to close it was: " + (result ?? "NULL"));
}
private HomeScreenViewModel()
{
using (QUANLYNHADATEntities db = new QUANLYNHADATEntities())
{
Houses = new ObservableCollection <NHA>(db.NHAs.Where(item => item.MACNHA == MACNHA).ToList());
AllHouseTypes = new ObservableCollection <LOAINHA>(db.LOAINHAs);
}
SelectedHouse = new NHA();
SelectedHouseForRent = new CHITIETNHATHUE();
SelectedHouseForSale = new CHITIETNHABAN();
}
public void DeleteRentalhouseDetail(CHITIETNHATHUE ChiTietNhaThue)
{
if (ChiTietNhaThue is null)
{
throw new System.ArgumentNullException(nameof(ChiTietNhaThue));
}
using (var db = new QUANLYNHADATEntities())
{
db.CHITIETNHATHUEs.Remove(ChiTietNhaThue);
db.SaveChanges();
}
this.Reset();
}
private void UpdateHouseRentalPrice(CHITIETNHATHUE ChiTietNhaThue)
{
if (ChiTietNhaThue is null)
{
throw new System.ArgumentNullException(nameof(ChiTietNhaThue));
}
using (var db = new QUANLYNHADATEntities())
{
try
{
db.USP_UpdateHousePrice(ChiTietNhaThue.MACN, ChiTietNhaThue.MANHA, ChiTietNhaThue.GIATHUE);
db.SaveChanges();
this.Reset();
}
catch (System.Exception ex)
{
MessageBox.Show(ex.ToString());
}
}
}
private HomeScreenViewModel()
{
using (QUANLYNHADATEntities db = new QUANLYNHADATEntities())
{
Houses = new ObservableCollection <NHA>(db.NHAs.Where(item => item.MACN == MACN));
AllHouses = new ObservableCollection <NHA>(db.NHAs.Where(item => item.MACN == MACN));
AllHouseTypes = new ObservableCollection <LOAINHA>(db.LOAINHAs);
AllHouseOwners = new ObservableCollection <CHUNHA>(db.CHUNHAs);
Staffs = new ObservableCollection <NHANVIEN>(db.NHANVIENs.Where(item => item.MACN == MACN));
Customers = new ObservableCollection <KHACHHANG>(db.KHACHHANGs.Where(item => item.CNQUANLY == MACN));
}
SelectedHouse = new NHA();
SelectedHouseForRent = new CHITIETNHATHUE();
SelectedHouseForSale = new CHITIETNHABAN();
SelectedStaff = new NHANVIEN();
SelectedCustomer = new KHACHHANG();
OldNewHousetypeRequest = new Dictionary <int, int>();
}
private async void ExecuteDeleteHouseCommand(object key)
{
var values = (object[])key;
this.ModifiedHouse = NhaDAO.GetInstance().GetHouseById(values);
this.ModifiedRentalHouseDetail = ChiTietNhaThueDAO.GetInstance().GetRentalhouseDetailById(values);
var okeCancelDialogViewModel = new OkCancelDialogViewModel
{
Message = "Xóa nhà này?"
};
var view = new OkCancelDialogControl
{
DataContext = okeCancelDialogViewModel
};
//show the dialog
var result = await DialogHost.Show(view, BaseMainWindowViewModel.Instance.Identifier, ExtendedOpenedEventHandler, DeleteExtendedClosingEventHandler).ConfigureAwait(false);
//check the result...
Console.WriteLine("Dialog was closed, the CommandParameter used to close it was: " + (result ?? "NULL"));
}
public void EditRentalhouseDetail(CHITIETNHATHUE ChiTietNhaThue)
{
if (ChiTietNhaThue is null)
{
throw new System.ArgumentNullException(nameof(ChiTietNhaThue));
}
using (var db = new QUANLYNHADATEntities())
{
var rentalhouseDetail = db.CHITIETNHATHUEs.Find(ChiTietNhaThue.MANHA, ChiTietNhaThue.MACN);
if (rentalhouseDetail != null)
{
rentalhouseDetail.MACN = ChiTietNhaThue.MACN;
if (rentalhouseDetail.GIATHUE != ChiTietNhaThue.GIATHUE)
{
UpdateHouseRentalPrice(ChiTietNhaThue);
}
//rentalhouseDetail.GIATHUE = ChiTietNhaThue.GIATHUE;
db.SaveChanges();
}
}
this.Reset();
}
