private void treeView1_AfterSelect(object sender, TreeViewEventArgs e)
{
listKhach.Items.Clear();
TreeNode theNode = this.treeView1.SelectedNode;
KhachThueBUS _ListKT = new KhachThueBUS();
if (theNode.Tag.ToString() == "2")
{
panel2.Visible = false;
string node = theNode.Name.ToString();
var list_khach = _ListKT.GetKhach(node);
for (int i = 0; i < list_khach.Rows.Count; i++)
{
ListViewItem item = new ListViewItem(list_khach.Rows[i][0].ToString());
if (list_khach.Rows[i][2].ToString() == "Nam")
{
item.ImageIndex = 3;
}
else
{
item.ImageIndex = 2;
}
item.SubItems.Add(list_khach.Rows[i][1].ToString());
item.SubItems.Add(list_khach.Rows[i][3].ToString());
item.SubItems.Add(list_khach.Rows[i][4].ToString());
item.SubItems.Add(list_khach.Rows[i][5].ToString());
listKhach.Items.Add(item);
}
}
}
private void dgvQLKhach_SelectionChanged(object sender, EventArgs e)
{
clearall();
if (dgvQLKhach.SelectedCells.Count > 0)
{
int index = dgvQLKhach.SelectedCells[0].RowIndex;
DataGridViewRow selectedrow = dgvQLKhach.Rows[index];
string makhach = Convert.ToString(selectedrow.Cells["Mã Khách"].Value);
string sql = "SELECT * FROM ThongTinKhach WHERE MaKhachTro = '" + makhach + "'";
List <KhachThue> tmp = new KhachThueBUS().GetKhach_List(sql);
lbMaKt.DataBindings.Add("Text", tmp, "MaKhachTro");
cbGioiTinh.DataBindings.Add("Text", tmp, "GioiTinh");
txtTen.DataBindings.Add("Text", tmp, "Ten");
txtHo.DataBindings.Add("Text", tmp, "Ho");;
dtpNgaySinh.DataBindings.Add("Text", tmp, "NgaySinh");
txtCMND.DataBindings.Add("Text", tmp, "CMND");
txtQue.DataBindings.Add("Text", tmp, "QueQuan");
txtNghe.DataBindings.Add("Text", tmp, "NgheNghiep");
txtGhiChu.DataBindings.Add("Text", tmp, "GhiChu");
}
btnCancel.Visible = false;
btnSave.Visible = false;
btnSua.Visible = true;
}
private void frmInformation_Load(object sender, EventArgs e)
{
txtTen.Enabled = false;
txtHo.Enabled = false;
txtHoTen.Enabled = false;
dtpNgaySinh.Enabled = false;
cbGioiTinh.Enabled = false;
txtCMND.Enabled = false;
txtQue.Enabled = false;
txtNghe.Enabled = false;
txtGhiChu.Enabled = false;
string sql = "SELECT * FROM ThongTinKhach WHERE MaKhachTro = '" + _id + "'";
List <KhachThue> tmp = new KhachThueBUS().GetKhach_List(sql);
lbMaKt.DataBindings.Add("Text", tmp, "MaKhachTro");
cbGioiTinh.DataBindings.Add("Text", tmp, "GioiTinh");
txtTen.DataBindings.Add("Text", tmp, "Ten");
txtHo.DataBindings.Add("Text", tmp, "Ho");;
txtHoTen.Text = txtHo.Text + " " + txtTen.Text;
dtpNgaySinh.DataBindings.Add("Text", tmp, "NgaySinh");
txtCMND.DataBindings.Add("Text", tmp, "CMND");
txtQue.DataBindings.Add("Text", tmp, "QueQuan");
txtNghe.DataBindings.Add("Text", tmp, "NgheNghiep");
txtGhiChu.DataBindings.Add("Text", tmp, "GhiChu");
}
//Nút Lưu
private void btnSave_Click(object sender, EventArgs e)
{
//Sinh Ma Khach moi
ThongTinThuePhongBUS data = new ThongTinThuePhongBUS();
makhach = data.newID();
//Lay thong tin bang ThongTinKhach
ho = txtHo.Text.Trim();
ten = txtTen.Text.Trim();
ngaysinh = dtpNgaySinh.Value;
if (cbGioiTinh.SelectedItem.ToString() == "Nam")
{
gioitinh = "Nam";
}
else
{
gioitinh = "Nữ";
}
cmnd = txtCMND.Text.Trim();
quequan = txtQueQuan.Text.Trim();
nghenghiep = txtNgheNghiep.Text.Trim();
maphong = lbMaPhong.Text.Trim();
ghichu = "1";
tiendatcoc = Convert.ToInt32(txtTienDatCoc.Text);
//Lay thong tin ThongTinThuePhong
string idtttp = new ThongTinThuePhongBUS().newID_tttp().ToString();
string select_maphong = lbMaPhong.Text;
DateTime ngaythue = dtpNgayThue.Value;
if (MessageBox.Show("Bạn có muốn lưu?", "Mã khách trọ: " + makhach, MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
{
//Them vao bang ThongTinKhach
KhachThue kt = new KhachThue(makhach, ho, ten, gioitinh, ngaysinh, cmnd, quequan, nghenghiep, maphong, ghichu);
string sqlAddKhachInfo = "INSERT INTO ThongTinKhach(MaKhachTro,Ho,Ten,GioiTinh,NgaySinh,CMND,QueQuan,NgheNghiep,MaPhong,GhiChu) VALUES(@makhach,@ho,@ten,@gioitinh,@ngaysinh,@cmnd,@quequan,@nghenghiep,@maphong,@ghichu)";
int j = new KhachThueBUS().Insert(sqlAddKhachInfo, kt);
//Them vao bang ThongTinThuePhong
ThongTinThue ttp = new ThongTinThue(idtttp, makhach, maphong, ngaythue, tiendatcoc);
string sqlinsert = "INSERT INTO ThongTinThuePhong(MaHD, MaKhachTro, MaPhong, NgayThue,TienDatCoc) VALUES(@id, @makhachtro,@maphong,@ngaythue,@tiendatcoc)";
int i = new ThongTinThuePhongBUS().Insert(sqlinsert, ttp);
//Cap nhat trang thai phong
ThongTinThuePhongBUS update = new ThongTinThuePhongBUS();
string sqlupdate = "UPDATE Phong SET TrangThai=@trangthai WHERE MaPhong='" + select_maphong + "'";
update.Update(sqlupdate);
//Refresh Form
lvPhong.Items.Clear();
LoadData_ListPhong();
ClearAll();
Load_ListKhach(maphong);
MessageBox.Show("Đã thêm thành công!");
}
}
private void btnSave_Click(object sender, EventArgs e)
{
string _id, ho, ten, birthday, cmnd, quequan, job, gioitinh, ghichu;
_id = lbMaKt.Text;
ho = txtHo.Text.Trim();
ten = txtTen.Text;
birthday = dtpNgaySinh.Text.Trim();
if (cbGioiTinh.SelectedItem.ToString() == "Nam")
{
gioitinh = "Nam";
}
else
{
gioitinh = "Nữ";
}
cmnd = txtCMND.Text.Trim();
quequan = txtQue.Text.Trim();
job = txtNghe.Text.Trim();
ghichu = txtGhiChu.Text.Trim();
txtHo.Enabled = false;
txtTen.Enabled = false;
dtpNgaySinh.Enabled = false;
cbGioiTinh.Enabled = false;
txtCMND.Enabled = false;
txtQue.Enabled = false;
txtNghe.Enabled = false;
txtGhiChu.Enabled = false;
btnSave.Visible = false;
btnCancel.Visible = false;
btnSua.Visible = true;
string sql = "UPDATE ThongTinKhach SET Ho=N'" + ho + "', Ten=N'" + ten + "', GioiTinh=N'" + gioitinh + "', NgaySinh='" + birthday + "', CMND='" + cmnd + "', QueQuan=N'" + quequan + "', NgheNghiep=N'" + job + "', GhiChu=N'" + ghichu + "' WHERE MaKhachTro = '" + _id + "'";
List <KhachThue> tmp = new KhachThueBUS().GetKhach_List(sql);
MessageBox.Show("Đã sửa thông tin khách!");
//Refresh
Load_DSKhach();
}
private void load_khach_dau(string id)
{
KhachThueBUS kt = new KhachThueBUS();
var sqlkt = kt.GetKhachTheoMaPhong("SELECT * FROM ThongTinKhach WHERE MaKhachTro='" + id + "'");
lbHoTen.Text = sqlkt.Rows[0][1] + " " + sqlkt.Rows[0][2];
dtNgaySinh.Text = sqlkt.Rows[0][5].ToString();
lbGioiTinh.Text = sqlkt.Rows[0][3].ToString();
lbCMND.Text = sqlkt.Rows[0][6].ToString();
lbQueQuan.Text = sqlkt.Rows[0][7].ToString();
lbNgheNghiep.Text = sqlkt.Rows[0][8].ToString();
lbMaKhach.Text = sqlkt.Rows[0][0].ToString();
ThongTinThuePhongBUS ttt = new ThongTinThuePhongBUS();
var sqlttt = ttt.GetKhach("SELECT * FROM ThongTinThuePhong WHERE MaKhachTro='" + id + "'");
lbPhong.Text = sqlttt.Rows[0][2].ToString();
dtNgayThue.Text = sqlttt.Rows[0][3].ToString();
tiendatcoc = Convert.ToInt32(sqlttt.Rows[0][4].ToString());
lbTienDatCoc.Text = string.Format("{0:#,##0}", tiendatcoc);
}
private void lvPhong_Click(object sender, EventArgs e)
{
lvKhach.Items.Clear();
ListViewItem a = lvPhong.SelectedItems[0];
string map = a.Text;
string id;
//string map = lvPhong.SelectedItems[0].ToString().TrimEnd();
string sqll = "SELECT * FROM ThongTinKhach WHERE MaPhong= '" + map + "'";
KhachThueBUS data = new KhachThueBUS();
DataTable sql = data.GetKhachTheoMaPhong(sqll);
for (int i = 0; i < sql.Rows.Count; i++)
{
ListViewItem item = new ListViewItem(sql.Rows[i][0].ToString());
item.SubItems.Add(sql.Rows[i][1].ToString() + " " + sql.Rows[i][2].ToString());
item.SubItems.Add(sql.Rows[i][3].ToString());
lvKhach.Items.Add(item);
}
id = sql.Rows[0][0].ToString();
load_khach_dau(id);
}
//Load ListView Khach thue
private void Load_ListKhach(string maphong)
{
KhachThueBUS khach = new KhachThueBUS();
var listkhach = khach.GetKhach(maphong);
lvKhachThue.Items.Clear();
for (int i = 0; i < listkhach.Rows.Count; i++)
{
ListViewItem item = new ListViewItem(listkhach.Rows[i][0].ToString());
if (listkhach.Rows[i][2].ToString() == "Nam")
{
item.ImageIndex = 3;
}
else
{
item.ImageIndex = 2;
}
item.SubItems.Add(listkhach.Rows[i][1].ToString());
item.SubItems.Add(listkhach.Rows[i][3].ToString());
item.SubItems.Add(listkhach.Rows[i][5].ToString());
lvKhachThue.Items.Add(item);
}
lbSoNguoi.Text = listkhach.Rows.Count.ToString();
}
private void btnSave_Click(object sender, EventArgs e)
{
try
{
string ho, ten, gioitinh, cmnd, quequan, nghenghiep, maphong, ghichu, makhach;
DateTime ngaysinh;
//Sinh Ma Khach moi
ThongTinThuePhongBUS data = new ThongTinThuePhongBUS();
makhach = data.newID();
//Lay thong tin bang ThongTinKhach
ho = txtHo.Text.Trim();
ten = txtTen.Text.Trim();
ngaysinh = dtpNgaySinh.Value;
gioitinh = cbGioiTinh.SelectedItem.ToString();
cmnd = txtCMND.Text.Trim();
quequan = txtQueQuan.Text.Trim();
nghenghiep = txtNgheNghiep.Text.Trim();
maphong = lbMaPhong.Text.Trim();
ghichu = "1";
List <string> tmp = new List <string>();
tmp.Add(ho);
tmp.Add(ten);
tmp.Add(gioitinh);
tmp.Add(nghenghiep);
tmp.Add(quequan);
tmp.Add(cmnd);
tmp.Add(txtTienDatCoc.Text);
foreach (string chuoi in tmp)
{
if (chuoi == "")
{
kiemtra = 1;
}
}
if (kiemtra == 1)
{
MessageBox.Show("Quý khách phải nhập đủ thông tin!");
kiemtra = 0;
}
else
{
if (MessageBox.Show("Bạn có muốn lưu?", "Mã khách trọ: " + makhach, MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
{
//Them vao bang ThongTinKhach
KhachThue kt = new KhachThue(makhach, ho, ten, gioitinh, ngaysinh, cmnd, quequan, nghenghiep, maphong, ghichu);
string sqlAddKhachInfo = "INSERT INTO ThongTinKhach(MaKhachTro,Ho,Ten,GioiTinh,NgaySinh,CMND,QueQuan,NgheNghiep,MaPhong,GhiChu) VALUES(@makhach,@ho,@ten,@gioitinh,@ngaysinh,@cmnd,@quequan,@nghenghiep,@maphong,@ghichu)";
int j = new KhachThueBUS().Insert(sqlAddKhachInfo, kt);
//Them vao bang ThongTinThuePhong
//Lay thong tin
string idtttp = new ThongTinThuePhongBUS().newID_tttp().ToString();
string select_maphong = lbMaPhong.Text;
DateTime ngaythue = dtpNgayThue.Value;
tiendatcoc = Convert.ToInt32(txtTienDatCoc.Text);
//INSERT vao bang
ThongTinThue ttp = new ThongTinThue(idtttp, makhach, maphong, ngaythue, tiendatcoc);
string sqlinsert = "INSERT INTO ThongTinThuePhong(MaHD, MaKhachTro, MaPhong, NgayThue,TienDatCoc) VALUES(@id, @makhachtro,@maphong,@ngaythue,@tiendatcoc)";
int i = new ThongTinThuePhongBUS().Insert(sqlinsert, ttp);
//Cap nhat trang thai phong
ThongTinThuePhongBUS update = new ThongTinThuePhongBUS();
string sqlupdate = "UPDATE Phong SET TrangThai=@trangthai WHERE MaPhong='" + select_maphong + "'";
update.Update(sqlupdate);
//Xoa Khach tu DS Dang Ky
ListViewItem item = listKDK.SelectedItems[0];
int id_kdk = Convert.ToInt32(item.Text);
string sqlxoa = "DELETE From ThongTinDangKyPhong Where Id=" + id_kdk;
int z = new ThongTinDKBUS().XoaKDK(sqlxoa);
//Refresh Form
lvPhong.Items.Clear();
LoadData_ListPhong();
Load_ListKDK();
MessageBox.Show("Đã thêm thành công!");
}
}
}
catch (FormatException)
{
}
}
