private void dgvKH_RowHeaderMouseClick(object sender, DataGridViewCellMouseEventArgs e)
{
object i = dgvKH.SelectedRows[0].Cells[0].Value;
string s = i.ToString();
KHACH_THUE khach = kt.lay1khach(s);
txtMaKH.Text = khach.MaKhach;
txtTenKhach.Text = khach.TenKhach;
txtNghe.Text = khach.QueQuan;
txtCMND.Text = khach.CMND;
txtQue.Text = khach.QueQuan;
txtSDT.Text = khach.SDT;
if (khach.GioiTinh == "Nữ")
{
radioButtonNu.Checked = true;
}
else
{
radioButtonNam.Checked = true;
}
byte[] MyData = new byte[50];
MyData = khach.HinhAnh;
if (MyData.Length > 50)
{
MemoryStream stream = new MemoryStream(MyData);
pictureBox1.Image = new Bitmap(stream);
}
path1.Text = "label13";
}
private void butThem_Click(object sender, EventArgs e)
{
try
{
if (MessageBox.Show("Bạn có chắc muốn thêm khách thuê này?", "Thêm", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
{
object i = dgvKhachChuaCoPhong.SelectedRows[0].Cells[0].Value;
string makhach = i.ToString();
KHACH_THUE k = kt.lay1khach(makhach);
CT_KHACH_THUE ct = new CT_KHACH_THUE
{
MaKhach = k.MaKhach,
NgayVaoPhong = DateTime.Now,
};
if (rbtPhongMoi.Checked)
{
ct.MaPhong = cbbPhongMoi.SelectedItem.ToString();
ql.AddKhachPhongMoi(ct);
DangKyThue_Load(this, e);
}
else if (rbtGhep.Checked)
{
ct.MaPhong = cbbPhongGhep.SelectedItem.ToString();
ql.AddKhachGhep(ct);
DangKyThue_Load(this, e);
}
MessageBox.Show("Thêm Khách Thuê Thành Công!");
}
}
catch (Exception ex)
{
MessageBox.Show("Mời kiểm tra lại thông tin!");
}
}
public void AddKhachGhep(CT_KHACH_THUE ct)
{
ql.CT_KHACH_THUE.Add(ct);
PHONG_TRO pt = ql.PHONG_TRO.Where(x => x.MaPhong == ct.MaPhong).SingleOrDefault();
pt.SoNguoi++;
KHACH_THUE k = ql.KHACH_THUE.Where(x => x.MaKhach == ct.MaKhach).SingleOrDefault();
k.TinhTrang = 1;
ql.SaveChanges();
}
public void Delete(string s)
{
KHACH_THUE k = this.lay1khach(s);
//USER_KHACHTHUE u = ql.USER_KHACHTHUE.Where(x => x.MaKhach == k.MaKhach).SingleOrDefault();
CT_KHACH_THUE ct = ql.CT_KHACH_THUE.Where(x => x.MaKhach == k.MaKhach).SingleOrDefault();
ct.PHONG_TRO.SoNguoi--;
ql.KHACH_THUE.Remove(k);
ql.CT_KHACH_THUE.Remove(ct);
// ql.USER_KHACHTHUE.Remove(u);
ql.SaveChanges();
}
public void Update(KHACH_THUE ks, string ma)
{
KHACH_THUE kc = this.lay1khach(ma);
kc.TenKhach = ks.TenKhach;
kc.GioiTinh = ks.GioiTinh;
kc.HinhAnh = ks.HinhAnh;
kc.CMND = ks.CMND;
kc.SDT = ks.SDT;
kc.NgheNghiep = ks.NgheNghiep;
kc.QueQuan = ks.QueQuan;
ql.SaveChanges();
}
public void Add(KHACH_THUE ks)
{
try
{
ql.KHACH_THUE.Add(ks);
ks.TinhTrang = 0;
ql.SaveChanges();
MessageBox.Show("Thêm Khách Thuê Thành Công!");
}
catch (Exception ex)
{
MessageBox.Show("Mời kiểm tra lại thông tin!");
}
}
public void ThemKhachVaoPhongMoi(CT_KHACH_THUE kt)
{
ql.CT_KHACH_THUE.Add(kt);
HOP_DONG hd = new HOP_DONG
{
MaPhong = kt.MaPhong,
NgayLap = kt.NgayVaoPhong
};
ql.HOP_DONG.Add(hd);
PHONG_TRO pt = ql.PHONG_TRO.Where(x => x.MaPhong == kt.MaPhong).SingleOrDefault();
KHACH_THUE k = ql.KHACH_THUE.Where(x => x.MaKhach == kt.MaKhach).SingleOrDefault();
k.TinhTrang = 1; // co phong
pt.TrangThai = 1; // co nguoi thue
pt.SoNguoi++;
ql.SaveChanges();
}
private void butSua_Click(object sender, EventArgs e)
{
if (MessageBox.Show("Bạn có chắc muốn sửa khách thuê này?", "Sửa", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
{
object i = dgvKH.SelectedRows[0].Cells[0].Value;
string s = i.ToString();
KHACH_THUE kc = kt.lay1khach(s);
string fm = "Nữ";
byte[] img = new byte[50];
if (radioButtonNam.Checked)
{
fm = "Nam";
}
if (path1.Text == "label13")
{
img = kc.HinhAnh;
}
else
{
img = convertimagetobyte();
}
KHACH_THUE ks = new KHACH_THUE
{
MaKhach = s,
TenKhach = txtTenKhach.Text,
CMND = txtCMND.Text,
QueQuan = txtQue.Text,
SDT = txtSDT.Text,
NgheNghiep = txtNghe.Text,
HinhAnh = img,
GioiTinh = fm,
};
kt.Update(ks, s);
MessageBox.Show("Sửa Thành Công!", "OK", MessageBoxButtons.OK);
dgvKH.DataSource = kt.show();
path1.Text = "label13";
}
}
private void butThem_Click(object sender, EventArgs e)
{
if (MessageBox.Show("Bạn có chắc muốn thêm khách thuê này?", "Thêm", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
{
string gt = "Nam";
if (radioButtonNu.Checked)
{
gt = "Nữ";
}
byte[] img = new byte[50];
if (path1.Text != "label13")
{
img = convertimagetobyte();
}
KHACH_THUE k = new KHACH_THUE
{
MaKhach = txtMaKH.Text,
TenKhach = txtTenKhach.Text,
CMND = txtCMND.Text,
QueQuan = txtQue.Text,
NgheNghiep = txtNghe.Text,
GioiTinh = gt,
SDT = txtSDT.Text,
HinhAnh = img
};
if (checkempty(txtMaKH.Text) == true || checkempty(txtTenKhach.Text) == true)
{
MessageBox.Show("Mời kiểm tra lại thông tin", "OK", MessageBoxButtons.OK);
}
else
{
kt.Add(k);
dgvKH.DataSource = kt.show();
Reset();
}
}
}
public void Add(KHACH_THUE k)
{
kt.Add(k);
}
public void Update(KHACH_THUE ks, string ma)
{
kt.Update(ks, ma);
}
