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