//Tìm khách thuê theo nghề nghiệp public DataTable TimKhachThueTheoNgheNghiep(KhachThue khachthue) { String sql = "select * from KHACH_THUE where NgheNghiep like N'%" + khachthue.getNgheNghiep() + "%'"; rs = manager.executeQuery(sql); return(rs); }
private void btnThemMoi_Click(object sender, EventArgs e) { KhachThue khach = new KhachThue(); if (txtCMND.Text.ToString() == "" || txtMaKhach.Text.ToString() == "" || txtNgheNghiep.Text.ToString() == null || txtQueQuan.Text.ToString() == null || txtTenKhach.Text.ToString() == null || cbGioiTinh.Text.ToString() == null) { MessageBox.Show("Hãy điền đầy đủ thông tin"); } else { khach.setMaKhach(txtMaKhach.Text.ToString()); khach.setCmnd(txtCMND.Text.ToString()); khach.setNghenghiep(txtNgheNghiep.Text.ToString()); khach.setQuequan(txtQueQuan.Text.ToString()); khach.setTenKhach(txtTenKhach.Text.ToString()); khach.setPhai(cbGioiTinh.Text.ToString()); khachThueBLL.ThemKhachThueVaoPhongMoi(khach); dgvDSKhachThue.DataSource = khachThueBLL.LoadKhachThue(); MessageBox.Show("Thêm khách thành công."); } txtCMND.Enabled = false; txtMaKhach.Enabled = false; txtNgheNghiep.Enabled = false; txtQueQuan.Enabled = false; txtTenKhach.Enabled = false; cbGioiTinh.Enabled = false; }
private void btnCapNhat_Click(object sender, EventArgs e) { DataGridViewRow updaterow = dgvDSKhachThue.Rows[indexRowKhach]; if (updaterow.Cells[0].Value == null || updaterow.Cells[1].Value == null || updaterow.Cells[2].Value == null || updaterow.Cells[3].Value == null || updaterow.Cells[4].Value == null || updaterow.Cells[5].Value == null) { MessageBox.Show("Hãy chọn khách hàng cần cập nhật"); } else { KhachThue khach = new KhachThue(); khach.setMaKhach(txtMaKhach.Text.ToString()); khach.setCmnd(txtCMND.Text.ToString()); khach.setNghenghiep(txtNgheNghiep.Text.ToString()); khach.setQuequan(txtQueQuan.Text.ToString()); khach.setTenKhach(txtTenKhach.Text.ToString()); khach.setPhai(cbGioiTinh.Text.ToString()); khachThueBLL.SuaKhachThue(khach); dgvDSKhachThue.DataSource = khachThueBLL.LoadKhachThue(); } txtCMND.Enabled = false; txtMaKhach.Enabled = false; txtNgheNghiep.Enabled = false; txtQueQuan.Enabled = false; txtTenKhach.Enabled = false; cbGioiTinh.Enabled = false; }
//thêm khách thuê có đặt phòng trước /*public bool ThemKhachThueDatPhong(KhachThue khachthue) * { * SqlParameter p1 = new SqlParameter("@makhach", khachthue.getMaKhach()); * SqlParameter p2 = new SqlParameter("@tenkhach", khachthue.getTenKhach()); * SqlParameter p3 = new SqlParameter("@phai", khachthue.getPhai()); * SqlParameter p4 = new SqlParameter("@cmnd", khachthue.getCmnd()); * SqlParameter p5 = new SqlParameter("@quequan", khachthue.getQuequan()); * SqlParameter p6 = new SqlParameter("@nghenghiep", khachthue.getNgheNghiep()); * * * * SqlParameter[] giatri = { p1, p2, p3, p4, p5, p6 }; * * return data.Update("ThemKhachThueDatPhong", giatri); * }*/ //Xóa khách thuê public void XoaKhach(KhachThue khachthue) { SqlParameter p1 = new SqlParameter("@makhach", khachthue.getMaKhach()); SqlParameter[] giatri = { p1 }; String delete = "delete from CT_KHACH_THUE where MaKhach = @makhach; delete from KHACH_THUE where MaKhach = @makhach"; manager.Delete(delete, giatri); }
//Sửa khách thuê public bool SuaKhachthue(KhachThue khachthue) { SqlParameter p1 = new SqlParameter("@makhach", khachthue.getMaKhach()); SqlParameter p2 = new SqlParameter("@tenkhach", khachthue.getTenKhach()); SqlParameter p3 = new SqlParameter("@phai", khachthue.getPhai()); SqlParameter p4 = new SqlParameter("@cmnd", khachthue.getCmnd()); SqlParameter p5 = new SqlParameter("@quequan", khachthue.getQuequan()); SqlParameter p6 = new SqlParameter("@nghenghiep", khachthue.getNgheNghiep()); SqlParameter[] giatri = { p1, p2, p3, p4, p5, p6 }; return(manager.Update(@"dbo.[SuaKhachThue]", giatri)); }
//thêm khách thuê public void ThemKhachthue(KhachThue khachthue) { SqlParameter p1 = new SqlParameter("@makhach", khachthue.getMaKhach()); SqlParameter p2 = new SqlParameter("@tenkhach", khachthue.getTenKhach()); SqlParameter p3 = new SqlParameter("@phai", khachthue.getPhai()); SqlParameter p4 = new SqlParameter("@cmnd", khachthue.getCmnd()); SqlParameter p5 = new SqlParameter("@quequan", khachthue.getQuequan()); SqlParameter p6 = new SqlParameter("@nghenghiep", khachthue.getNgheNghiep()); //String insert = "insert into KHACH_THUE values (@makhach, @tenkhach, @phai, @cmnd, @quequan, @nghenghiep)"; SqlParameter[] giatri = { p1, p2, p3, p4, p5, p6 }; manager.Update(@"dbo.[ThemKhachThue]", giatri); }
private void btnXoa_Click(object sender, EventArgs e) { try { int selectedIndex = dgvDSKhachThue.CurrentCell.RowIndex; if (selectedIndex > -1) { KhachThue khach = new KhachThue(); khach.setMaKhach(txtMaKhach.Text.ToString()); khachThueBLL.XoaKhachThue(khach); dgvDSKhachThue.DataSource = khachThueBLL.LoadKhachThue(); } } catch (InvalidOperationException ex) { throw ex; } }
public DataTable TimKhachThueTheoQueQuan(KhachThue KhachThue) { return(KhachThueDAL.getInstance().TimKhachThueTheoQueQuan(KhachThue)); }
public DataTable TimKhachThueTheoNghe(KhachThue KhachThue) { return(KhachThueDAL.getInstance().TimKhachThueTheoNgheNghiep(KhachThue)); }
public void XoaKhachThue(KhachThue KhachThue) { KhachThueDAL.getInstance().XoaKhach(KhachThue); }
//Thêm khách thuê có đặt phòng trước /*public bool ThemKhachThueDatPhong(KhachThue KhachThue) * { * return khachthue.ThemKhachThueDatPhong(KhachThue); * }*/ public bool SuaKhachThue(KhachThue KhachThue) { return(KhachThueDAL.getInstance().SuaKhachthue(KhachThue)); }
/*public DataTable loadkhachthuedatphong() * { * return khachthue.loadkhachthuedatphong(); * }*/ //Thêm khách thuê không đặt phòng trước public void ThemKhachThueVaoPhongMoi(KhachThue KhachThue) { KhachThueDAL.getInstance().ThemKhachthue(KhachThue); }
private void khachthueToolStripMenuItem_Click(object sender, EventArgs e) { KhachThue kt = new KhachThue(); kt.Show(); }