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();
}
//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 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();
}
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 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();
}
public void DeleteHouseOwner(CHUNHA ChuNha)
{
if (ChuNha is null)
{
throw new System.ArgumentNullException(nameof(ChuNha));
}
using (var db = new QUANLYNHADATEntities())
{
db.CHUNHAs.Remove(ChuNha);
db.SaveChanges();
}
this.Reset();
}
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 void DeleteHouseCategory(LOAINHA loaiNha)
{
if (loaiNha is null)
{
throw new System.ArgumentNullException(nameof(loaiNha));
}
using (var db = new QUANLYNHADATEntities())
{
db.LOAINHAs.Remove(loaiNha);
db.SaveChanges();
}
this.Reset();
}
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 void AddNewStaff(NHANVIEN nhanVien)
{
if (nhanVien is null)
{
throw new System.ArgumentNullException(nameof(nhanVien));
}
using (var db = new QUANLYNHADATEntities())
{
db.NHANVIENs.Add(nhanVien);
db.SaveChanges();
}
this.Reset();
}
public void DeleteStaff(NHANVIEN nhanVien)
{
if (nhanVien is null)
{
throw new System.ArgumentNullException(nameof(nhanVien));
}
using (var db = new QUANLYNHADATEntities())
{
var agency = db.CHINHANHs.Find(nhanVien.MACN);
agency.NHANVIENs.Remove(nhanVien);
db.NHANVIENs.Remove(nhanVien);
db.SaveChanges();
}
this.Reset();
}
public void EditHouseCategory(LOAINHA loaiNha)
{
if (loaiNha is null)
{
throw new System.ArgumentNullException(nameof(loaiNha));
}
using (var db = new QUANLYNHADATEntities())
{
var houseCate = db.LOAINHAs.Find(loaiNha.MALOAI);
if (houseCate != null)
{
houseCate.TEN = loaiNha.TEN;
db.SaveChanges();
}
}
this.Reset();
}
public void EditAgency(CHINHANH chiNhanh)
{
if (chiNhanh is null)
{
throw new System.ArgumentNullException(nameof(chiNhanh));
}
using (var db = new QUANLYNHADATEntities())
{
var agency = db.CHINHANHs.Find(chiNhanh.MACN);
if (agency != null)
{
agency.FAX = chiNhanh.FAX;
agency.SDT = chiNhanh.SDT;
agency.DIACHI = chiNhanh.DIACHI;
db.SaveChanges();
}
}
this.Reset();
}
public void EditHouseOwner(CHUNHA ChuNha)
{
if (ChuNha is null)
{
throw new System.ArgumentNullException(nameof(ChuNha));
}
using (var db = new QUANLYNHADATEntities())
{
var HouseOwner = db.CHUNHAs.Find(ChuNha.MACNHA);
if (HouseOwner != null)
{
HouseOwner.TEN = ChuNha.TEN;
HouseOwner.SDT = ChuNha.SDT;
HouseOwner.DIACHI = ChuNha.DIACHI;
db.SaveChanges();
}
}
this.Reset();
}
private void UpdateNameAndAddressAndDetail(KHACHHANG KhachHang)
{
if (KhachHang is null)
{
throw new System.ArgumentNullException(nameof(KhachHang));
}
using (var db = new QUANLYNHADATEntities())
{
try
{
db.USP_UpdateCustomerDetail(KhachHang.MAKH, KhachHang.CNQUANLY, KhachHang.TEN, KhachHang.DIACHI, KhachHang.CHITIET);
db.SaveChanges();
this.Reset();
}
catch (System.Exception ex)
{
MessageBox.Show(ex.ToString());
}
}
}
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 void UpdateHouseCategory(NHA Nha)
{
if (Nha is null)
{
throw new System.ArgumentNullException(nameof(Nha));
}
using (var db = new QUANLYNHADATEntities())
{
try
{
db.USP_UpdateHouseTypeInHouse(Nha.MANHA, Nha.MALOAI);
db.SaveChanges();
this.Reset();
}
catch (System.Exception ex)
{
MessageBox.Show(ex.ToString());
}
}
}
private void UpdateSalary(NHANVIEN nhanVien)
{
if (nhanVien == null)
{
throw new System.ArgumentNullException(nameof(nhanVien));
}
using (var db = new QUANLYNHADATEntities())
{
try
{
db.USP_UpdateSalaryStaff(nhanVien.MANV, (double)((decimal)nhanVien.LUONG));
db.SaveChanges();
this.Reset();
}
catch (System.Exception ex)
{
MessageBox.Show(ex.ToString());
}
}
}
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();
}
public void UpdateHouseRentalPrice(object[] keys)
{
var maNha = (int)keys[0];
var maCN = (int)keys[1];
var price = (int?)keys[2];
using (var db = new QUANLYNHADATEntities())
{
var rentalhouseDetail = db.CHITIETNHATHUEs.Find(maNha, maCN);
if (rentalhouseDetail != null)
{
try
{
db.USP_UpdateHousePrice(maCN, maNha, price);
db.SaveChanges();
this.Reset();
}
catch (System.Exception ex)
{
MessageBox.Show(ex.ToString());
}
}
}
}
