public bool checkIn_HoaDon() { DV dV = dt.DVs.Where(s => s.MaDV == txtMaDVu.Text).FirstOrDefault(); if (dV != null) { DanhSachDichVu danhSachDichVu = dt.DanhSachDichVus.Where(s => s.MaDanhSach == cmbMaDanhSach.Text).FirstOrDefault(); if (danhSachDichVu != null) { CT_PhieuThue cT_PhieuThue = dt.CT_PhieuThues.Where(s => s.SoPhieuThue == Convert.ToInt32(danhSachDichVu.SoPhieuThue)). FirstOrDefault(); if (cT_PhieuThue != null) { PhieuThuePhong phieuThuePhong = dt.PhieuThuePhongs.Where(s => s.MaPhieuThue == cT_PhieuThue.MaPhieuThue).FirstOrDefault(); if (phieuThuePhong != null) { string a = phieuThuePhong.MaPhieuThue.ToString(); HoaDon hoaDon = dt.HoaDons.Where(s => s.MaPhieuThue == phieuThuePhong.MaPhieuThue).FirstOrDefault(); if (hoaDon != null) { return(false); } } } //MessageBox.Show("Dịch Vụ Này đã được thanh toán trong hóa đơn! không xóa được"); } } return(true); }
private void bindingNavigatorDeleteItem_Click(object sender, EventArgs e) { if (txtMaNhanVien.Text != null) { PhieuThuePhong phieuThuePhong = dt.PhieuThuePhongs.Where(s => s.MaNhanVien == txtMaNhanVien.Text).FirstOrDefault(); if (phieuThuePhong == null) { DialogResult xoa = MessageBox.Show("bạn có muốn xóa không?", "", MessageBoxButtons.YesNo); if (xoa == DialogResult.Yes) { var data = dt.xoanhanvienn(txtMaNhanVien.Text); } } else { MessageBox.Show("Không Thể Xóa !"); } } else { MessageBox.Show("Bạn Chưa Chọn Nhân Viên Xóa"); } dtgNhanVien.DataSource = new DataClasses1DataContext().NhanViens.ToList(); }
private void save_Click(object sender, EventArgs e) { if (i == 1) { if (txtMaKhachHang.Text == "" || cmbQuocTich.SelectedValue.ToString() == "" || txtTenKhachHang.Text == "" || txtCMND.Text == "" || cbGioiTinh.Text == "" || txtDiaChi.Text == "" || txtSdt.Text == "") { MessageBox.Show("Bạn chưa nhập đầy đủ thông tin !", "Thông Báo", MessageBoxButtons.OK); } else { KhachHang khachHang = dt.KhachHangs.Where(s => s.MaKhachHang == txtMaKhachHang.Text).FirstOrDefault(); if (khachHang != null) { MessageBox.Show("Khách Hàng đã tồn tại vui lòng nhập mã khách hàng khác !!"); } else { DialogResult xoa = MessageBox.Show("bạn có muốn Thêm không?", "", MessageBoxButtons.YesNo); if (xoa == DialogResult.Yes) { dt.themkhachhangs(txtMaKhachHang.Text, cmbQuocTich.SelectedValue.ToString(), txtTenKhachHang.Text, txtCMND.Text, cbGioiTinh.Text, txtDiaChi.Text, txtSdt.Text); MessageBox.Show("Thêm Thành Công ?", "Thông Báo", MessageBoxButtons.OK); } } } } else if (i == 2) { if (txtMaKhachHang.Text == "" || cmbQuocTich.SelectedValue.ToString() == "" || txtTenKhachHang.Text == "" || txtCMND.Text == "" || cbGioiTinh.Text == "" || txtDiaChi.Text == "" || txtSdt.Text == "") { MessageBox.Show("Bạn chưa nhập đầy đủ thông tin !", "Thông Báo", MessageBoxButtons.OK); } else { PhieuThuePhong phieuThuePhong = dt.PhieuThuePhongs.Where(s => s.MaKhachHang == txtMaKhachHang.Text).FirstOrDefault(); if (phieuThuePhong != null) { MessageBox.Show(" Không cho sửa ?", "", MessageBoxButtons.OK); } DialogResult xoa = MessageBox.Show("bạn có muốn sửa không?", "", MessageBoxButtons.YesNo); if (xoa == DialogResult.Yes) { var data = dt.suakhachhang(txtMaKhachHang.Text, cmbQuocTich.SelectedValue.ToString(), txtTenKhachHang.Text, txtCMND.Text, cbGioiTinh.Text, txtDiaChi.Text, txtSdt.Text); MessageBox.Show("Sửa Thành Công ?", "Thông Báo", MessageBoxButtons.OK); } } } KhachHangUser_Load(sender, e); btnLuu.Enabled = false; }
private void button6_Click(object sender, EventArgs e) { PhieuThuePhong ptp = db.PhieuThuePhongs.Find(txtPTP.Text); ptp.Xoa = 1; db.SaveChanges(); MessageBox.Show("Đã xóa thành công phiếu thuê phòng này."); txtPTP.Text = ""; DateTime date = DateTime.Now; txtNgayThue.Text = String.Format("{0:d/M/yyyy}", date); txtDMP.Text = ""; txtPhong.Text = ""; dgvKH.Rows.Clear(); }
private void btnXoa_Click(object sender, EventArgs e) { PhieuThuePhong phieuThuePhong = dt.PhieuThuePhongs.Where(s => s.MaKhachHang == txtMaKhachHang.Text).FirstOrDefault(); if (phieuThuePhong == null) { DialogResult xoa = MessageBox.Show("Bạn có muốn xóa không?", "", MessageBoxButtons.YesNo); if (xoa == DialogResult.Yes) { var data = dt.xoakhachhang(txtMaKhachHang.Text); } } else { MessageBox.Show("Không xóa được !"); } datagKhachhang.DataSource = new DataClasses1DataContext().KhachHangs.ToList(); }
public bool checkIn_HoaDon() { CT_PhieuThue cT_PhieuThue = dt.CT_PhieuThues.Where(s => s.SoPhieuThue == Convert.ToInt32(cmbSoPhieuNhan.SelectedValue.ToString())). FirstOrDefault(); if (cT_PhieuThue != null) { PhieuThuePhong phieuThuePhong = dt.PhieuThuePhongs.Where(s => s.MaPhieuThue == cT_PhieuThue.MaPhieuThue).FirstOrDefault(); if (phieuThuePhong != null) { HoaDon hoaDon = dt.HoaDons.Where(s => s.MaPhieuThue == phieuThuePhong.MaPhieuThue).FirstOrDefault(); if (hoaDon != null) { return(false); } } } return(true); }
private void btnXacNhan_Click(object sender, EventArgs e) { QLKS.Controller.Soluongkhach slk = new Controller.Soluongkhach(); int dem = slk.SoLuongKhach(); if (dataGridView1.Rows.Count > dem) { MessageBox.Show(String.Format("Một phòng chỉ được tối đa {0} người", dem.ToString()), dem.ToString()); } else { try { PhieuThuePhong PTP = new PhieuThuePhong(); int maPTP = PTP.LapPhieuThuePhong(txtPhong.Text.ToString(), txtNgayBatDau.Text.ToString(), dataGridView1.Rows.Count - 1); List <int> dsmakhachhang = new List <int>(); int makhachhang; for (int i = 0; i < dataGridView1.Rows.Count - 1; i++) { makhachhang = PTP.ThemKhachHang(dataGridView1.Rows[i].Cells[0].Value.ToString(), dataGridView1.Rows[i].Cells[1].Value.ToString(), dataGridView1.Rows[i].Cells[2].Value.ToString(), dataGridView1.Rows[i].Cells[3].Value.ToString()); dsmakhachhang.Add(makhachhang); } foreach (int item in dsmakhachhang) { PTP.ThemChiTietPhieuThuePhong(item.ToString(), maPTP.ToString()); } MessageBox.Show("Lặp Phiếu Thuê Phòng Thành Công"); this.Close(); } catch { MessageBox.Show("Lặp Phiếu Thuê Phòng Không Thành Công"); this.Close(); } } }
private void txtPTP_TextChanged(object sender, EventArgs e) { if (txtPTP.Text == "") { return; } dgvKH.Rows.Clear(); PhieuThuePhong ptp = db.PhieuThuePhongs.Find(txtPTP.Text); Phong ph = db.Phongs.Find(ptp.MaPhong); DanhMucPhong dmp = db.DanhMucPhongs.Find(ph.MaDanhMucPhong); txtDMP.Text = dmp.TenDMP; txtPhong.Text = ph.TenPhong; txtNgayThue.Text = string.Format("{0:d/M/yyyy}", ptp.NgayBatDauThue); var result = from c in db.CT_PhieuThuePhong from d in db.KhachHangs from a in db.LoaiKhachHangs where (c.MaPhieuThuePhong == ptp.MaPhieuThuePhong && c.MaKhachHang == d.MaKhachHang && d.MaLoaiKhachHang == a.MaLoaiKhachHang) select new { d.TenKhachHang, a.TenLoaiKhachHang, d.CMND, d.DiaChi }; foreach (var i in result) { string[] row1 = new string[] { i.TenKhachHang, i.TenLoaiKhachHang, i.CMND, i.DiaChi }; dgvKH.Rows.Add(row1); } }
private void button2_Click(object sender, EventArgs e) { DateTime ngbd = Convert.ToDateTime(txtNgayThue.Text); var count_ptp = from c in db.PhieuThuePhongs select c; PhieuThuePhong ptp = new PhieuThuePhong() { MaPhieuThuePhong = "PTP" + (count_ptp.Count() + 1), MaPhong = cbbP.SelectedValue.ToString(), NgayBatDauThue = ngbd.Date, Xoa = 0 }; db.PhieuThuePhongs.Add(ptp); Phong pg = db.Phongs.Find(cbbP.SelectedValue.ToString()); pg.TinhTrang = "Đang thuê"; string maptp = "PTP" + (count_ptp.Count() + 1); for (int i = 0; i < dgvKH.Rows.Count; i++) { string cmnd = dgvKH[2, i].Value.ToString(); string loaikh = dgvKH[1, i].Value.ToString(); var count_kh = from c in db.KhachHangs select c; var check_cmnd = from c in db.KhachHangs where c.CMND == cmnd select c; if (check_cmnd.Count() == 0) { var malkh = from c in db.LoaiKhachHangs where c.TenLoaiKhachHang == loaikh select c; KhachHang kh = new KhachHang(); kh.MaKhachHang = "KH" + (count_kh.Count() + 1); kh.TenKhachHang = dgvKH[0, i].Value.ToString(); kh.CMND = cmnd; kh.DiaChi = dgvKH[3, i].Value.ToString(); foreach (var b in malkh) { kh.MaLoaiKhachHang = b.MaLoaiKhachHang; } db.KhachHangs.Add(kh); var count_ct = from c in db.CT_PhieuThuePhong select c; CT_PhieuThuePhong ct = new CT_PhieuThuePhong() { MaCTPhieuThuePhong = "CTPTP" + (count_ct.Count() + 1), MaPhieuThuePhong = maptp, MaKhachHang = "KH" + (count_kh.Count() + 1) }; db.CT_PhieuThuePhong.Add(ct); } else { var kh = from c in db.KhachHangs where c.CMND == cmnd select c; foreach (var a in kh) { var count_ct = from c in db.CT_PhieuThuePhong select c; CT_PhieuThuePhong ct = new CT_PhieuThuePhong() { MaCTPhieuThuePhong = "CTPTP" + (count_ct.Count() + 1), MaPhieuThuePhong = maptp, MaKhachHang = a.MaKhachHang }; db.CT_PhieuThuePhong.Add(ct); } } db.SaveChanges(); } MessageBox.Show("Tạo phiếu thuê phòng thành công"); }
private void cmbMaPhieuThue_SelectedIndexChanged(object sender, EventArgs e) { string mapt = cmbMaPhieuThue.Text.ToString(); PhieuThuePhong ptp = dt.PhieuThuePhongs.FirstOrDefault(p => p.MaPhieuThue == mapt); if (ptp != null) { cmbMaKH.SelectedValue = ptp.MaKhachHang; CT_PhieuThue cT_PhieuThue1 = dt.CT_PhieuThues.FirstOrDefault(p => p.MaPhieuThue == mapt); if (cT_PhieuThue1 != null) { DanhSachDichVu danhSachDichVu = dt.DanhSachDichVus.Where(s => s.SoPhieuThue == cT_PhieuThue1.SoPhieuThue).FirstOrDefault(); if (danhSachDichVu != null) { string ds = danhSachDichVu.MaDanhSach; txtDichVu.Text = danhSachDichVu.MaDanhSach.ToString(); DV dichVu = dt.DVs.Where(s => s.MaDanhSach == danhSachDichVu.MaDanhSach).FirstOrDefault(); if (dichVu != null) { LoaiDV loaiDV = dt.LoaiDVs.Where(s => s.MaLoaiDV == dichVu.MaLoaiDV).FirstOrDefault(); if (loaiDV != null) { TienDVResult tienDVResult = dt.TienDV(ds).FirstOrDefault(); txtTienDV.Text = tienDVResult.Column1.ToString(); // MessageBox.Show(tienDVResult.Column1.ToString()); } } } else { txtTienDV.Text = "0"; txtDichVu.Text = ""; } } } CT_PhieuThue cT_PhieuThue = dt.CT_PhieuThues.FirstOrDefault(p => p.MaPhieuThue == mapt); if (cT_PhieuThue != null) { txtTienPhong.Text = cT_PhieuThue.DonGia.ToString(); dateNgayThuePhong.Value = Convert.ToDateTime(cT_PhieuThue.NgayNhanPhong.Value.ToString()); //// MessageBox.Show(date.ToString()); //MessageBox.Show(date.ToString()); DateTime date1 = new DateTime(dateNgayThuePhong.Value.Year, dateNgayThuePhong.Value.Month, dateNgayThuePhong.Value.Day, dateNgayThuePhong.Value.Hour, dateNgayThuePhong.Value.Minute, dateNgayThuePhong.Value.Second); DateTime date2 = new DateTime(dtNgayTraPhong.Value.Year, dtNgayTraPhong.Value.Month, dtNgayTraPhong.Value.Day, dtNgayTraPhong.Value.Hour, dtNgayTraPhong.Value.Minute, dtNgayTraPhong.Value.Second); TimeSpan diff1 = date2.Subtract(date1); if (diff1.Days < 1) { txtSoNgay.Text = "1"; } else if (diff1.Hours >= 1 && diff1.Days >= 1) { txtSoNgay.Text = Convert.ToString(diff1.Days + 1); } else if (diff1.Hours < 1 && diff1.Days >= 1) { txtSoNgay.Text = diff1.Days.ToString(); } if (txtSoNgay.Text != null && txtTienPhong.Text != null) { tt = Convert.ToInt32(txtSoNgay.Text) * Convert.ToDouble(txtTienPhong.Text); txtTongTien.Text = tt.ToString(); if (txtTienDV.Text != "") { txtTongTien.Text = (Convert.ToInt32(txtTongTien.Text) + Convert.ToInt32(txtTienDV.Text)).ToString(); } } // } // MessageBox.Show(date.ToString()); }