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