public bool sua_KhachThue(KHACHTHUE pkt)
{
try
{
KHACHTHUE kt = data.KHACHTHUEs.Where(t => t.MAKT == pkt.MAKT).FirstOrDefault();
if (kt != null)
{
kt.TENKT = pkt.TENKT;
kt.GIOITINH = pkt.GIOITINH;
kt.SDT = pkt.SDT;
kt.ANH = pkt.ANH;
kt.QUEQUAN = pkt.QUEQUAN;
kt.SOCMND = pkt.SOCMND;
kt.NGAYSINH = pkt.NGAYSINH;
kt.TINHTRANGTAMTRU = pkt.TINHTRANGTAMTRU;
data.SubmitChanges();
}
return(true);
}
catch
{
return(false);
}
}
private void btn_xacnhan_Click(object sender, EventArgs e)
{
DialogResult res;
res = MessageBox.Show("Xác nhận trả phòng!", "Xác nhận", MessageBoxButtons.YesNo, MessageBoxIcon.Question, MessageBoxDefaultButton.Button1);
if (res == DialogResult.Yes)
{
try
{
int position = gridView_traphong.FocusedRowHandle;
string m = gridView_traphong.GetRowCellValue(position, "Makt").ToString();
string n = gridView_traphong.GetRowCellValue(position, "Mahd").ToString();
HOPDONG hd = new HOPDONG();
hd.MAHD = n;
hd.TINHTRANG = false;
KHACHTHUE kt = new KHACHTHUE();
kt.MAKT = m;
kt.TINHTRANG = false;
if (hopdong.sua_tinhtrangHopDong(hd) == true)
{
dal_sm.updatetinhtrangKT(hd.MAHD);
grv_traphong.DataSource = traphong.LoadTraPhong();
}
else
{
MessageBox.Show("Thất bại");
}
PHONG p = new PHONG();
p.MAPHONG = txt_maphong.Text;
p.TINHTRANG = false;
p.SOLUONG_HT = 0;
if (phong.sua_slhientai(p) == true)
{
MessageBox.Show(" thành công");
}
else
{
MessageBox.Show("Sữa slht thất bại");
}
}
catch
{
MessageBox.Show("Lỗi !!!");
}
frm_traphong_Load(sender, e);
txt_slhientai.Text = "0";
}
else
{
return;
}
}
private void txt_makt_TextChanged(object sender, EventArgs e)
{
try
{
KHACHTHUE kt = new KHACHTHUE();
kt = dal_khachthue.loadTenKhachThue(txt_makt.Text);
txt_cmnd.Text = kt.SOCMND;
txt_sdt.Text = kt.SDT;
}
catch { MessageBox.Show("Lỗi hệ thống"); }
}
//Thêm
public bool them_KhachThue(KHACHTHUE kt)
{
try
{
data.KHACHTHUEs.InsertOnSubmit(kt);
data.SubmitChanges();
return(true);
}
catch
{
return(false);
}
}
//Xóa
public bool xoa_KhachThue(string pmakt)
{
try
{
KHACHTHUE lp = data.KHACHTHUEs.Where(t => t.MAKT == pmakt).FirstOrDefault();
data.KHACHTHUEs.DeleteOnSubmit(lp);
data.SubmitChanges();
return(true);
}
catch
{
return(false);
}
}
public bool sua_tinhtrangOkhachthue(KHACHTHUE pkt)
{
try
{
KHACHTHUE kt = data.KHACHTHUEs.Where(t => t.MAKT == pkt.MAKT).FirstOrDefault();
if (kt != null)
{
kt.TINHTRANG = pkt.TINHTRANG;
data.SubmitChanges();
}
return(true);
}
catch
{
return(false);
}
}
public bool suatinhtrangkhachthue(KHACHTHUE kt)
{
try
{
KHACHTHUE hd = data.KHACHTHUEs.Where(t => t.MAKT == kt.MAKT).FirstOrDefault();
if (hd != null)
{
//hd.SOLAN = pvipham.SOLAN;
hd.TINHTRANG = kt.TINHTRANG;
data.SubmitChanges();
}
return(true);
}
catch
{
return(false);
}
}
private void btn_luu_Click(object sender, EventArgs e)
{
try
{
if (txt_makt.Text == string.Empty && txt_sdt.Text == string.Empty && txt_cmnd.Text == string.Empty &&
txt_quequan.Text == string.Empty)
{
MessageBox.Show(" không được để trống");
return;
}
if (pic_anhkt.Image == null)
{
MessageBox.Show("Thêm ảnh khách thuê");
return;
}
byte[] b = convertImage(pic_anhkt.Image);
// khách thuê
KHACHTHUE kt = new KHACHTHUE();
kt.MAKT = txt_makt.Text;
kt.TENKT = txt_tenkt.Text;
kt.SDT = txt_sdt.Text;
kt.ANH = b;
kt.TINHTRANGTAMTRU = "chưa đăng ký";
if (rdb_nam.Checked == true)
{
kt.GIOITINH = rdb_nam.Text;
}
else
{
kt.GIOITINH = rdb_nu.Text;
}
kt.SOCMND = txt_cmnd.Text;
kt.NGAYSINH = Convert.ToDateTime(txt_ngaysinh.Text);
kt.QUEQUAN = txt_quequan.Text;
if (ckb_truongphong.Checked == true)
{
kt.TRUONGPHONG = true;
}
else
{
kt.TRUONGPHONG = false;
}
//kt.MAPHONG = txt_tenphong.Text;
kt.MK = "abc";
kt.TINHTRANG = true;
// khách thuê phòng
KHACHTHUEPHONG ktp = new KHACHTHUEPHONG();
ktp.MAKTP = dal_sm.sinhmakhachthuephong();
ktp.MAPHONG = txt_tenphong.Text;
ktp.MAKT = txt_makt.Text;
if (btn_sua.Enabled == false && btn_them.Enabled == true)
{
try
{
if (khachthue.ktkc_khachthue(txt_makt.Text) == true)
{
MessageBox.Show("Trùng khóa chính");
return;
}
if (khachthue.ThemKT(kt) == true && dal_khachthuephong.them_khachthuephong(ktp) == true)
{
PHONG ph = new PHONG();
ph.MAPHONG = txt_tenphong.Text;
ph.SOLUONG_HT = datphong.demsohd(ph.MAPHONG);
if (phong.sua_sl(ph) == true)
{
MessageBox.Show("Thành công");
}
else
{
MessageBox.Show("Thất bại");
}
}
if (khachthue.ktTRuongPhong(txt_tenphong.Text) == true)
{
ckb_truongphong.Enabled = false;
}
else
{
ckb_truongphong.Enabled = true;
}
}
catch
{
MessageBox.Show("Thất bại");
}
grv_khachthue.DataSource = dal_loakt.loadkhachthuetheomaphong(txt_tenphong.Text);
}
if (btn_sua.Enabled == true && btn_them.Enabled == false)
{
try
{
if (txt_makt.Text == string.Empty && txt_sdt.Text == string.Empty && txt_cmnd.Text == string.Empty &&
txt_quequan.Text == string.Empty)
{
MessageBox.Show(" không được để trống");
return;
}
if (khachthue.sua_khachthue(kt) == true)
{
grv_khachthue.DataSource = dal_loakt.loadkhachthue();
MessageBox.Show("Thành công");
}
}
catch
{
MessageBox.Show("thất bại");
}
}
txt_makt.Enabled = txt_tenkt.Enabled = txt_sdt.Enabled
= txt_quequan.Enabled = txt_ngaysinh.Enabled = false;
txt_cmnd.Enabled = rdb_nam.Enabled = rdb_nu.Enabled = false;
txt_makt.Text = bll_sinhma.SinhMa_KhachThue();
btn_huy.Enabled = btn_luu.Enabled = btn_xoa.Enabled = btn_sua.Enabled = false;
ckb_truongphong.Checked = false;
}
catch
{
MessageBox.Show("Lỗi");
}
}
private void grv_khachthue_Click(object sender, EventArgs e)
{
KHACHTHUE kt = new KHACHTHUE();
btn_sua.Enabled = btn_xoa.Enabled = true;
btn_them.Enabled = false;
btn_huy.Enabled = true;
if (gridView_khachthue.RowCount > 0)
{
int position = gridView_khachthue.FocusedRowHandle;
try
{
//kt.MAPHONG = gridView_khachthue.GetRowCellValue(position, "MAPHONG").ToString();
kt.TENKT = gridView_khachthue.GetRowCellValue(position, "TENKT1").ToString();
kt.MAKT = gridView_khachthue.GetRowCellValue(position, "MAKT1").ToString();
kt.NGAYSINH = Convert.ToDateTime(gridView_khachthue.GetRowCellValue(position, "NGAYSINH1").ToString());
kt.GIOITINH = gridView_khachthue.GetRowCellValue(position, "GIOITINH1").ToString();
kt.QUEQUAN = gridView_khachthue.GetRowCellValue(position, "QUEQUAN1").ToString();
kt.SOCMND = gridView_khachthue.GetRowCellValue(position, "SOCMND1").ToString();
kt.SDT = gridView_khachthue.GetRowCellValue(position, "SDT1").ToString();
txt_makt.Text = kt.MAKT.ToString();
txt_tenkt.Text = kt.TENKT.ToString();
txt_sdt.Text = kt.SDT.ToString();
txt_cmnd.Text = kt.SOCMND.ToString();
txt_ngaysinh.Text = kt.NGAYSINH.ToString();
txt_quequan.Text = kt.QUEQUAN.ToString();
//txt_tenphong.Text = kt.MAPHONG;
if (kt.GIOITINH == "Nam")
{
rdb_nam.Checked = true;
}
if (kt.GIOITINH == "Nữ")
{
rdb_nu.Checked = true;
}
//var q3 = data.KHACHTHUEs.Where(c => c.MAKT == kt.MAKT).Select(c => c.ANH).FirstOrDefault();
//byte[] b = q3.ToArray();
//if(kt.ANH!=null)
//{
try
{
byte[] b = (byte[])khachthue.layanh(kt.MAKT);
pic_anhkt.Image = bytetoimage(b);
pic_anhkt.SizeMode = PictureBoxSizeMode.StretchImage;
}
catch
{
return;
}
// }
//else
//{
// MessageBox.Show("Không có ảnh");
//}
}
catch { }
}
else
{
return;
}
int sltd = Convert.ToInt32(bll_datphong.laysoLuongtd(cbo_phong.SelectedValue.ToString()));
if (bll_datphong.demsohd(cbo_phong.SelectedValue.ToString()) <= sltd)
{
btn_them.Enabled = false;
}
}
public bool sua_tinhtrangOKhachthue(KHACHTHUE pkt)
{
return(dkt.sua_tinhtrangOkhachthue(pkt));
}
public bool sua_tinhtrangkt(KHACHTHUE pkt)
{
return(dkt.sua_tinhtrangkt(pkt));
}
//Sửa
public bool sua_khachthue(KHACHTHUE pkt)
{
return(dkt.sua_KhachThue(pkt));
}
//Thêm
public bool ThemKT(KHACHTHUE pkt)
{
return(dkt.them_KhachThue(pkt));
}
