internal void GetAllStaffs()
{
using (QUANLYNHADATEntities db = new QUANLYNHADATEntities())
{
Staffs = new ObservableCollection <NHANVIEN>(db.NHANVIENs.Where(item => item.MACN == MACN));
}
}
//Read for deadlock
public void EditCustomer(KHACHHANG KhachHang)
{
if (KhachHang is null)
{
throw new System.ArgumentNullException(nameof(KhachHang));
}
using (var db = new QUANLYNHADATEntities())
{
var customer = db.KHACHHANGs.Find(KhachHang.MAKH, KhachHang.CNQUANLY);
if (customer != null)
{
customer.CNQUANLY = KhachHang.CNQUANLY;
customer.SDT = KhachHang.SDT;
if (customer.TEN != KhachHang.TEN ||
customer.DIACHI != KhachHang.DIACHI ||
customer.CHITIET != KhachHang.CHITIET)
{
this.UpdateNameAndAddressAndDetail(KhachHang);
}
/*customer.TEN = KhachHang.TEN;
* customer.DIACHI = KhachHang.DIACHI;
* customer.CHITIET = KhachHang.CHITIET;*/
db.SaveChanges();
}
}
this.Reset();
}
public void EditHouse(NHA Nha)
{
if (Nha is null)
{
throw new System.ArgumentNullException(nameof(Nha));
}
using (var db = new QUANLYNHADATEntities())
{
var house = db.NHAs.Find(Nha.MANHA, Nha.MACN);
if (house != null)
{
house.MACN = Nha.MACN;
house.MACNHA = Nha.MACNHA;
house.MANV = Nha.MANV;
//house.MALOAI = Nha.MALOAI;
if (house.MALOAI != Nha.MALOAI)
{
this.UpdateHouseCategory(Nha);
}
house.SOLUONGPHONGO = Nha.SOLUONGPHONGO;
house.NGAYHETHAN = Nha.NGAYHETHAN;
house.NGAYDANG = Nha.NGAYDANG;
house.DUONG = Nha.DUONG;
house.QUAN = Nha.QUAN;
house.KHUVUC = Nha.KHUVUC;
house.THANHPHO = Nha.THANHPHO;
house.TINHTRANG = Nha.TINHTRANG;
house.SOLUOTXEM = Nha.SOLUOTXEM;
db.SaveChanges();
}
}
this.Reset();
}
internal void updateHouseHouseType(int maNha, int newLoaiNha)
{
using (QUANLYNHADATEntities db = new QUANLYNHADATEntities())
{
db.USP_UpdateHouseInHouseType_Test(maNha, newLoaiNha);
}
}
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;
}
}
public void EditStaff(NHANVIEN nhanVien)
{
if (nhanVien is null)
{
throw new System.ArgumentNullException(nameof(nhanVien));
}
using (var db = new QUANLYNHADATEntities())
{
var staff = db.NHANVIENs.Find(nhanVien.MACN, nhanVien.MANV);
if (staff != null)
{
staff.MACN = nhanVien.MACN;
staff.TEN = nhanVien.TEN;
staff.SDT = nhanVien.SDT;
staff.DIACHI = nhanVien.DIACHI;
staff.GIOITINH = nhanVien.GIOITINH;
staff.NGAYSINH = nhanVien.NGAYSINH;
if (staff.LUONG != nhanVien.LUONG)
{
this.UpdateSalary(nhanVien);
}
//staff.LUONG = nhanVien.LUONG;
db.SaveChanges();
}
}
this.Reset();
}
private ChiNhanhMainViewModel()
{
using (QUANLYNHADATEntities db = new QUANLYNHADATEntities())
{
Houses = new ObservableCollection <NHA>(db.NHAs.ToList());
HouseOwners = new ObservableCollection <CHUNHA>(db.CHUNHAs.ToList());
}
}
private void HouseSearchButton_Click(object sender, RoutedEventArgs e)
{
GetHouseByStateComboBox.SelectedIndex = 0;
using (QUANLYNHADATEntities db = new QUANLYNHADATEntities())
{
HouseListDataGrid.ItemsSource = db.USP_TEST_AGENCY_GetHouse(HomeScreenViewModel.Instance.MACN);
}
}
internal void DeleteHouse(int maNha)
{
try
{
using (QUANLYNHADATEntities db = new QUANLYNHADATEntities())
{
db.USP_USER_DeleteHouse(maNha);
}
}
catch (Exception ex) { }
}
internal void GetHouseSuitable(int maLoai)
{
QUANLYNHADATEntities db = new QUANLYNHADATEntities();
var dataContext = db.USP_GetCustomerSuitableHouse(maLoai, MACN);
var screen = new Agency_IsHousePriceIncreases("Các nhà phù hợp yêu cầu")
{
DataContext = dataContext
};
screen.Show();
}
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();
}
internal void UpdateHousePriceIfYes(int soLuong, float phanTram)
{
QUANLYNHADATEntities db = new QUANLYNHADATEntities();
var dataContext = db.USP_IsPriceIncreases(phanTram, soLuong, MACN);
var screen = new Agency_IsHousePriceIncreases("Thông kê nhà tăng giá")
{
DataContext = dataContext
};
screen.Show();
}
internal void GetAllHouseAgain()
{
using (QUANLYNHADATEntities db = new QUANLYNHADATEntities())
{
Houses = new ObservableCollection <NHA>(db.NHAs.Where(item => item.MACNHA == MACNHA).ToList());
foreach (var house in Houses)
{
house.LOAINHA = db.LOAINHAs.FirstOrDefault(item => item.MALOAI == house.MALOAI);
}
AllHouseTypes = new ObservableCollection <LOAINHA>(db.LOAINHAs);
}
}
public bool IsContainsHouse(NHA Nha)
{
if (Nha is null)
{
throw new System.ArgumentNullException(nameof(Nha));
}
using (var db = new QUANLYNHADATEntities())
{
return(db.CHITIETNHATHUEs.Any(c => c.MANHA == Nha.MANHA && c.MACN == Nha.MACN));
}
}
internal void updateHousePriceInHouseRent()
{
try
{
int maNha = SelectedHouse.MANHA;
int newPrice = (int)SelectedHouseForRent.GIATHUE;
using (QUANLYNHADATEntities db = new QUANLYNHADATEntities())
{
db.USP_UpdateHousePrice(MACN, maNha, newPrice);
}
}
catch (Exception ex) { MessageBox.Show(ex.ToString()); }
}
internal void updateHouseTypeInHouse()
{
try
{
int maNha = SelectedHouse.MANHA;
int newLoaiNha = SelectedHouse.LOAINHA.MALOAI;
using (QUANLYNHADATEntities db = new QUANLYNHADATEntities())
{
db.USP_UpdateHouseTypeInHouse(maNha, newLoaiNha);
}
}
catch (Exception ex) { MessageBox.Show(ex.ToString()); }
}
public ObservableCollection <LOAINHA> GetAllHouseCategories()
{
if (houseCategoriesCollection == null || this.needReset)
{
if (this.needReset)
{
this.needReset = false;
}
using var db = new QUANLYNHADATEntities();
houseCategoriesCollection = db.LOAINHAs.ToObservableCollection();
}
return(houseCategoriesCollection);
}
public ObservableCollection <CHINHANH> GetAllAgencies()
{
if (agenciesCollection == null || this.needReset)
{
if (this.needReset)
{
this.needReset = false;
}
using var db = new QUANLYNHADATEntities();
//db.Configuration.LazyLoadingEnabled = false;
agenciesCollection = db.CHINHANHs.ToObservableCollection();
}
return(agenciesCollection);
}
public ObservableCollection <NHA> GetAllHouses()
{
if (housesCollection == null || this.needReset)
{
if (this.needReset)
{
this.needReset = false;
}
using var db = new QUANLYNHADATEntities();
//db.Configuration.LazyLoadingEnabled = false;
housesCollection = db.NHAs.ToObservableCollection();
}
return(housesCollection);
}
internal void SetSelectedCustomer(KHACHHANG kHACHHANG)
{
if (kHACHHANG != null)
{
using (QUANLYNHADATEntities db = new QUANLYNHADATEntities())
{
SelectedCustomer = db.KHACHHANGs.FirstOrDefault(item => item.MAKH == kHACHHANG.MAKH);
}
}
else
{
SelectedCustomer = kHACHHANG;
}
}
public ObservableCollection <CHITIETNHATHUE> GetAllRentalHousingDetails()
{
if (rentalHousingDetailsCollection == null || this.needReset)
{
if (this.needReset)
{
this.needReset = false;
}
using var db = new QUANLYNHADATEntities();
//db.Configuration.LazyLoadingEnabled = false;
rentalHousingDetailsCollection = db.CHITIETNHATHUEs.ToObservableCollection();
}
return(rentalHousingDetailsCollection);
}
public ObservableCollection <KHACHHANG> GetAllCustomers()
{
if (customersCollection == null || this.needReset)
{
if (this.needReset)
{
this.needReset = false;
}
using var db = new QUANLYNHADATEntities();
//db.Configuration.LazyLoadingEnabled = false;
customersCollection = db.KHACHHANGs.ToObservableCollection();
}
return(customersCollection);
}
internal void UpdateStaffSalary()
{
try
{
int maNV = SelectedStaff.MANV;
int newLuong = (int)SelectedStaff.LUONG;
using (QUANLYNHADATEntities db = new QUANLYNHADATEntities())
{
db.USP_UpdateSalaryStaff(maNV, newLuong);
}
}
catch (Exception ex) {
MessageBox.Show(ex.ToString());
}
}
public void AddNewCustomer(KHACHHANG KhachHang)
{
if (KhachHang is null)
{
throw new System.ArgumentNullException(nameof(KhachHang));
}
using (var db = new QUANLYNHADATEntities())
{
db.KHACHHANGs.Add(KhachHang);
db.SaveChanges();
}
this.Reset();
}
public KHACHHANG GetCustomerById(object[] keys)
{
var maKH = (int)keys[0];
var cnQuanLy = (int)keys[1];
using (var db = new QUANLYNHADATEntities())
{
var customer = db.KHACHHANGs.Find(maKH, cnQuanLy);
if (customer != null)
{
return(customer.ShallowClone());
}
}
return(null);
}
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();
}
public CHITIETNHATHUE GetRentalhouseDetailById(object[] keys)
{
var maNha = (int)keys[0];
var maCN = (int)keys[1];
using (var db = new QUANLYNHADATEntities())
{
var rentalhouseDetail = db.CHITIETNHATHUEs.Find(maNha, maCN);
if (rentalhouseDetail != null)
{
return(rentalhouseDetail.ShallowClone());
}
}
return(null);
}
public void AddNewHouse(NHA Nha)
{
if (Nha is null)
{
throw new System.ArgumentNullException(nameof(Nha));
}
using (var db = new QUANLYNHADATEntities())
{
db.NHAs.Add(Nha);
db.SaveChanges();
}
this.Reset();
}
public CHINHANH GetAgencyById(int id)
{
if (id > 0)
{
using (var db = new QUANLYNHADATEntities())
{
var agency = db.CHINHANHs.Find(id);
if (agency != null)
{
return(agency.ShallowClone());
}
}
}
return(null);
}
public void DeleteAgency(CHINHANH chiNhanh)
{
if (chiNhanh is null)
{
throw new System.ArgumentNullException(nameof(chiNhanh));
}
using (var db = new QUANLYNHADATEntities())
{
db.CHINHANHs.Remove(chiNhanh);
db.SaveChanges();
}
this.Reset();
}
