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)); }