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 btnLuu_Click(object sender, EventArgs e)
{
if (i == 1)
{
if (txtMaHoaDon.Text == "" || cmbNhanVien.SelectedValue.ToString() == "" || cmbMaPhieuThue.SelectedValue.ToString() == "")
{
MessageBox.Show("Bạn hãy nhập đầy đủ thông tin!");
}
else
{
HoaDon hoaDon = dt.HoaDons.Where(s => s.MaHoaDon == Convert.ToInt32(txtMaHoaDon.Text)).FirstOrDefault();
if (hoaDon != null)
{
MessageBox.Show("Hóa Đơn Đã Tồn Tại Vui Lòng Nhập Mã Hóa Đơn Khác !", "Thông Báo!", MessageBoxButtons.OK);
}
else
{
dt.themhd1(Convert.ToInt32(txtMaHoaDon.Text), cmbNhanVien.SelectedValue.ToString(), cmbMaKH.SelectedValue.ToString(),
cmbMaPhieuThue.SelectedValue.ToString(), Convert.ToInt32(txtSoNgay.Text), txtTienDV.Text, Convert.ToInt32(txtTongTien.Text), Convert.ToDateTime(dtNgayTraPhong.Text));
MessageBox.Show("Bạn đã thêm thành công");
s = cmbMaPhieuThue.SelectedValue.ToString();
CT_PhieuThue MaLoaiPhhong = dt.CT_PhieuThues.Where(p => p.MaPhieuThue == cmbMaPhieuThue.SelectedValue.ToString()).FirstOrDefault();
dt.update_TinhTrangPhongCuaPhong(MaLoaiPhhong.MaPhong.ToString(), "TT3", null);
}
}
}
else if (i == 2)
{
if (txtMaHoaDon.Text == "" || cmbNhanVien.SelectedValue.ToString() == "" || cmbMaPhieuThue.SelectedValue.ToString() == "")
{
MessageBox.Show("Bạn hãy nhập đầy đủ thông tin!");
}
else
{
dt.suahd(Convert.ToInt32(txtMaHoaDon.Text), cmbNhanVien.SelectedValue.ToString(), cmbMaKH.SelectedValue.ToString(),
cmbMaPhieuThue.SelectedValue.ToString(), Convert.ToInt32(txtSoNgay.Text), Convert.ToInt32(txtTongTien.Text), Convert.ToDateTime(dtNgayTraPhong.Text), txtTienDV.Text);
MessageBox.Show("Bạn đã sửa thành công");
s = cmbMaPhieuThue.SelectedValue.ToString();
CT_PhieuThue MaLoaiPhhong = dt.CT_PhieuThues.Where(p => p.MaPhieuThue == cmbMaPhieuThue.SelectedValue.ToString()).FirstOrDefault();
dt.update_TinhTrangPhongCuaPhong(MaLoaiPhhong.MaPhong.ToString(), "TT3", null);
}
}
dataGridViewX1.DataSource = dt.selectHd1();
// dataGridViewX1.DataSource = dt.selectcthd();
ChiTietHoaDon_User_Load(sender, e);
}
private void dataGridViewX1_CellClick(object sender, DataGridViewCellEventArgs e)
{
int i = dataGridViewX1.CurrentRow.Index;
if (i >= 0 && i < dataGridViewX1.RowCount - 1)
{
mahd = dataGridViewX1.Rows[i].Cells[0].Value.ToString();
txtMaHoaDon.Text = dataGridViewX1.Rows[i].Cells[0].Value.ToString();
cmbNhanVien.Text = dataGridViewX1.Rows[i].Cells[1].Value.ToString();
cmbMaKH.Text = dataGridViewX1.Rows[i].Cells[2].Value.ToString();
cmbMaPhieuThue.Text = dataGridViewX1.Rows[i].Cells[3].Value.ToString();
string maphieu = dataGridViewX1.Rows[i].Cells[3].Value.ToString();
// dateTimePicker1.Value =Convert.ToDateTime( dataGridViewX1.Rows[i].Cells[0].Value.ToString());
txtTienPhong.Text = dataGridViewX1.Rows[i].Cells[4].Value.ToString();
txtSoNgay.Text = dataGridViewX1.Rows[i].Cells[5].Value.ToString();
txtTienDV.Text = dataGridViewX1.Rows[i].Cells[6].Value.ToString();
txtTongTien.Text = dataGridViewX1.Rows[i].Cells[7].Value.ToString();
dateTimePicker1.Value = Convert.ToDateTime(dataGridViewX1.Rows[i].Cells[8].Value.ToString());
dtNgayTraPhong.Value = Convert.ToDateTime(dateTimePicker1.Value.ToString());
CT_PhieuThue phieu = dt.CT_PhieuThues.FirstOrDefault(p => p.MaPhieuThue == maphieu);
if (phieu != null)
{
DanhSachDichVu danhSachDichVu = dt.DanhSachDichVus.Where(s => s.SoPhieuThue == phieu.SoPhieuThue).FirstOrDefault();
if (danhSachDichVu != null)
{
txtDichVu.Text = danhSachDichVu.MaDanhSach.ToString();
try
{
DV dV = dt.DVs.Where(s => s.MaDanhSach == danhSachDichVu.MaDanhSach).FirstOrDefault();
LoaiDV loaiDV = dt.LoaiDVs.Where(s => s.MaLoaiDV == dV.MaLoaiDV).FirstOrDefault();
if (loaiDV != null)
{
TienDVResult tienDVResult = dt.TienDV(txtDichVu.Text).FirstOrDefault();
txtTienDV.Text = tienDVResult.Column1.ToString();
// MessageBox.Show(tienDVResult.Column1.ToString());
}
}
catch
{
}
}
}
dateNgayThuePhong.Value = Convert.ToDateTime(phieu.NgayNhanPhong.Value.ToString());
}
// MessageBox.Show(i.ToString());
// cmbNhanVien.SelectedValue = dataGridViewX1.Rows[i].Cells[0].Value.ToString();
}
private void btnXoa_Click(object sender, EventArgs e)
{
CT_PhieuThue cT_PhieuThue = dt.CT_PhieuThues.Where(s => s.MaPhong == txtMaPhong.Text.Trim()).FirstOrDefault();
if (cT_PhieuThue == null)
{
DialogResult xoa = MessageBox.Show("bạn có muốn xóa không?", "", MessageBoxButtons.YesNo);
if (xoa == DialogResult.Yes)
{
dt.deletePhong(txtMaPhong.Text);
}
}
else
{
MessageBox.Show("Không Xóa Được", "Thông Báo !", MessageBoxButtons.OK);
}
UserPhong_Load(sender, e);
}
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 btnXoa_Click(object sender, EventArgs e)
{
if (txtMaHoaDon.Text == "")
{
MessageBox.Show("Bạn chưa chọn hóa đơn xóa !!", "Thông Báo", MessageBoxButtons.OK);
}
else
{
DialogResult xoa = MessageBox.Show("bạn có chắc muốn xóa không?", "", MessageBoxButtons.YesNo);
if (xoa == DialogResult.Yes)
{
var data = dt.deleteHoaDon(Convert.ToInt32(txtMaHoaDon.Text));
CT_PhieuThue MaLoaiPhhong = dt.CT_PhieuThues.Where(p => p.MaPhieuThue == cmbMaPhieuThue.SelectedValue.ToString()).FirstOrDefault();
dt.update_TinhTrangPhongCuaPhong(MaLoaiPhhong.MaPhong.ToString(), "TT2", null);
ChiTietHoaDon_User_Load(sender, e);
}
}
}
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());
}
