private void pbXacNhan_Click(object sender, EventArgs e) { DTO_HoaDon hoadon = new DTO_HoaDon(); hoadon.MaPhong = maphong; hoadon.MaChiNhanh = machinhanh; hoadon.STT = stt; hoadon.MaHD = mahd; BO_QuanLiChiNhanh yeucau = new BO_QuanLiChiNhanh(); int result = yeucau.ThucHienYeuCau(hoadon); if (result != -1) { this.Hide(); YeuCauKhachHang dsyeucau = new YeuCauKhachHang(); dsyeucau.MANV = manv; dsyeucau.MACHINHANH = machinhanh; dsyeucau.TENNV = tennv; dsyeucau.TENCHINHANH = tenchinhanh; dsyeucau.ShowDialog(); this.Close(); } else { MessageBox.Show("Đã xảy ra lỗi vui lòng thử lại", "Thông Báo", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void pictureBox1_Click(object sender, EventArgs e) { DialogResult answer = MessageBox.Show("Bạn có muốn xóa yêu cầu này không ?", "Thông Báo", MessageBoxButtons.YesNo, MessageBoxIcon.Question); if (answer == DialogResult.Yes) { DTO_HoaDon hoadon = new DTO_HoaDon(); hoadon.MaPhong = maphong; hoadon.MaChiNhanh = machinhanh; hoadon.STT = stt; hoadon.MaHD = mahd; BO_QuanLiChiNhanh yeucau = new BO_QuanLiChiNhanh(); int result = yeucau.XoaYeuCau(hoadon); if (result != -1) { this.Hide(); YeuCauKhachHang dsyeucau = new YeuCauKhachHang(); dsyeucau.MANV = manv; dsyeucau.MACHINHANH = machinhanh; dsyeucau.TENNV = tennv; dsyeucau.TENCHINHANH = tenchinhanh; dsyeucau.ShowDialog(); this.Close(); } else { MessageBox.Show("Đã xảy ra lỗi vui lòng thử lại", "Thông Báo", MessageBoxButtons.OK, MessageBoxIcon.Error); } } }
private void picture_Click(object sender, EventArgs e) { DialogResult answer = MessageBox.Show("Phòng này đã được đặt cọc chưa ?", "Thông Báo", MessageBoxButtons.YesNo, MessageBoxIcon.Question); if (answer == DialogResult.Yes) { DTO_HoaDon hoadon = new DTO_HoaDon(); hoadon.MaHD = mahd; BO_QuanLiChiNhanh datcoc = new BO_QuanLiChiNhanh(); int kt = datcoc.DatCoc(hoadon); if (kt != -1) { MessageBox.Show("Đặt cọc thành công", "Thông Báo", MessageBoxButtons.OK, MessageBoxIcon.Information); this.ParentForm.Refresh(); } else { MessageBox.Show("Lỗi khi đặt cọc phòng", "Thông Báo", MessageBoxButtons.OK, MessageBoxIcon.Error); } } }
private void pbXacNhan_Click(object sender, EventArgs e) { DTO_HoaDon hoadon = new DTO_HoaDon(); hoadon.ThanhTien = total; hoadon.MaPhong = maphong; hoadon.MaChiNhanh = machinhanh; hoadon.MaHD = mahd; hoadon.SoDienThoai = sdt; hoadon.ThanhTien = total; BO_QuanLiChiNhanh quanli1 = new BO_QuanLiChiNhanh(); int KQ = quanli1.TichLuyDiem(hoadon); if (KQ != -1) { int table = quanli1.SetHoaDon(hoadon); if (table != -1) { this.Hide(); MessageBox.Show("Thanh toán thành công", "Thông Báo", MessageBoxButtons.OK, MessageBoxIcon.Information); GiaoDienQuanLi quanli = new GiaoDienQuanLi(); quanli.MANV = manv; quanli.MACHINHANH = machinhanh; quanli.TENCHINHANH = tenchinhanh; quanli.TENNV = tennv; quanli.ShowDialog(); this.Close(); } else { MessageBox.Show("Lỗi khi set Hóa đơn", "Thông Báo", MessageBoxButtons.OK, MessageBoxIcon.Error); } } else { MessageBox.Show("Lỗi tích lũy", "Thông Báo", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void load() { lb_TenChiNhanh.Text = tenchinhanh; DTO_HoaDon hoadon = new DTO_HoaDon(); hoadon.MaChiNhanh = machinhanh; BO_QuanLiChiNhanh yeucau = new BO_QuanLiChiNhanh(); DataSet result = yeucau.HienThiYeuCau(hoadon); Point vitridau = new Point(20, 20); if (result.Tables.Count > 0 && result.Tables[0].Rows.Count > 0) { int demyeucau = result.Tables[0].Rows.Count; for (int i = 0; i < demyeucau; i++) { if (i == 5) { YeuCau request = new YeuCau(); request.MAPHONG = result.Tables[0].Rows[i][6].ToString(); DTO_Phong phong = new DTO_Phong(); phong.MaChiNhanh = machinhanh; phong.MaPhong = result.Tables[0].Rows[i][6].ToString(); BO_QuanLiChiNhanh quanli = new BO_QuanLiChiNhanh(); DataSet table = quanli.LayTenPhong(phong); request.TENPHONG = table.Tables[0].Rows[0][2].ToString(); request.TENCHINHANH = tenchinhanh; request.MACHINHANH = machinhanh; request.TENDV = result.Tables[0].Rows[i][0].ToString(); request.SOLUONG = result.Tables[0].Rows[i][1].ToString(); request.TENNV = tennv; request.THOIGIAN = DateTime.Parse(result.Tables[0].Rows[i][13].ToString()); request.MAHD = result.Tables[0].Rows[i][3].ToString(); request.MANV = manv; request.STT = int.Parse(result.Tables[0].Rows[i][4].ToString()); pl_YeuCau.Controls.Add(request); vitridau.X = 20; vitridau.Y = 150; request.Location = vitridau; vitridau.X += 165; danhsach.Add(request); } else { if (i == 10) { YeuCau request = new YeuCau(); request.MAPHONG = result.Tables[0].Rows[i][6].ToString(); DTO_Phong phong = new DTO_Phong(); phong.MaChiNhanh = machinhanh; phong.MaPhong = result.Tables[0].Rows[i][6].ToString(); BO_QuanLiChiNhanh quanli = new BO_QuanLiChiNhanh(); DataSet table = quanli.LayTenPhong(phong); request.TENPHONG = table.Tables[0].Rows[0][2].ToString(); request.TENCHINHANH = tenchinhanh; request.MAHD = result.Tables[0].Rows[i][3].ToString(); request.MACHINHANH = machinhanh; request.THOIGIAN = DateTime.Parse(result.Tables[0].Rows[i][13].ToString()); request.TENDV = result.Tables[0].Rows[i][0].ToString(); request.STT = int.Parse(result.Tables[0].Rows[i][4].ToString()); request.SOLUONG = result.Tables[0].Rows[i][1].ToString(); request.TENNV = tennv; request.MANV = manv; pl_YeuCau.Controls.Add(request); vitridau.X = 20; vitridau.Y = 280; request.Location = vitridau; vitridau.X += 165; danhsach.Add(request); } else { if (i == 15) { YeuCau request = new YeuCau(); request.MAPHONG = result.Tables[0].Rows[i][6].ToString(); DTO_Phong phong = new DTO_Phong(); phong.MaChiNhanh = machinhanh; phong.MaPhong = result.Tables[0].Rows[i][6].ToString(); BO_QuanLiChiNhanh quanli = new BO_QuanLiChiNhanh(); DataSet table = quanli.LayTenPhong(phong); request.TENPHONG = table.Tables[0].Rows[0][2].ToString(); request.MAHD = result.Tables[0].Rows[i][3].ToString(); request.TENCHINHANH = tenchinhanh; request.THOIGIAN = DateTime.Parse(result.Tables[0].Rows[i][13].ToString()); request.MACHINHANH = machinhanh; request.TENDV = result.Tables[0].Rows[i][0].ToString(); request.STT = int.Parse(result.Tables[0].Rows[i][4].ToString()); request.SOLUONG = result.Tables[0].Rows[i][1].ToString(); request.TENNV = tennv; request.MANV = manv; pl_YeuCau.Controls.Add(request); vitridau.X = 20; vitridau.Y = 410; request.Location = vitridau; vitridau.X += 165; danhsach.Add(request); } else { if (i == 20) { YeuCau request = new YeuCau(); request.MAPHONG = result.Tables[0].Rows[i][6].ToString(); DTO_Phong phong = new DTO_Phong(); phong.MaChiNhanh = machinhanh; phong.MaPhong = result.Tables[0].Rows[i][6].ToString(); BO_QuanLiChiNhanh quanli = new BO_QuanLiChiNhanh(); DataSet table = quanli.LayTenPhong(phong); request.TENPHONG = table.Tables[0].Rows[0][2].ToString(); request.TENCHINHANH = tenchinhanh; request.THOIGIAN = DateTime.Parse(result.Tables[0].Rows[i][13].ToString()); request.TENDV = result.Tables[0].Rows[i][0].ToString(); request.MAHD = result.Tables[0].Rows[i][3].ToString(); request.SOLUONG = result.Tables[0].Rows[i][1].ToString(); request.STT = int.Parse(result.Tables[0].Rows[i][4].ToString()); request.MACHINHANH = machinhanh; request.TENNV = tennv; request.MANV = manv; pl_YeuCau.Controls.Add(request); vitridau.X = 20; vitridau.Y = 540; request.Location = vitridau; vitridau.X += 165; danhsach.Add(request); } else { YeuCau request = new YeuCau(); request.MAPHONG = result.Tables[0].Rows[i][6].ToString(); DTO_Phong phong = new DTO_Phong(); phong.MaChiNhanh = machinhanh; phong.MaPhong = result.Tables[0].Rows[i][6].ToString(); BO_QuanLiChiNhanh quanli = new BO_QuanLiChiNhanh(); DataSet table = quanli.LayTenPhong(phong); request.TENPHONG = table.Tables[0].Rows[0][2].ToString(); request.TENCHINHANH = tenchinhanh; request.THOIGIAN = DateTime.Parse(result.Tables[0].Rows[i][13].ToString()); request.TENDV = result.Tables[0].Rows[i][0].ToString(); request.MAHD = result.Tables[0].Rows[i][3].ToString(); request.STT = int.Parse(result.Tables[0].Rows[i][4].ToString()); request.SOLUONG = result.Tables[0].Rows[i][1].ToString(); request.MACHINHANH = machinhanh; request.TENNV = tennv; request.MANV = manv; pl_YeuCau.Controls.Add(request); request.Location = vitridau; vitridau.X += 165; danhsach.Add(request); } } } } } } }
public void load() { Point vitribandau = new Point(20, 20); DTO_HoaDon hoadon = new DTO_HoaDon(); hoadon.MaChiNhanh = machinhanh; BO_QuanLiChiNhanh hienthi = new BO_QuanLiChiNhanh(); DataSet table = new DataSet(); table = hienthi.HienThiPhongChuaDatCoc(hoadon); if (table.Tables.Count > 0 && table.Tables[0].Rows.Count > 0) { for (int i = 0; i < table.Tables[0].Rows.Count; i++) { if (i == 5) { PhongChuaDatCoc phong = new PhongChuaDatCoc(); phong.MAHD = table.Tables[0].Rows[i][3].ToString(); phong.MAPHONG = table.Tables[0].Rows[i][6].ToString(); DataSet laytenphong = new DataSet(); DTO_Phong phong1 = new DTO_Phong(); phong1.MaPhong = table.Tables[0].Rows[i][6].ToString(); phong1.MaChiNhanh = machinhanh; laytenphong = hienthi.LayTenPhong(phong1); phong.TENPHONG = laytenphong.Tables[0].Rows[0][2].ToString(); DateTime ngaythuchien = new DateTime(int.Parse("20" + table.Tables[0].Rows[i][13].ToString().Substring(6, 2)), int.Parse(table.Tables[0].Rows[i][13].ToString().Substring(3, 2)), int.Parse(table.Tables[0].Rows[i][13].ToString().Substring(0, 2)), int.Parse(table.Tables[0].Rows[i][13].ToString().Substring(9, 2)), int.Parse(table.Tables[0].Rows[i][13].ToString().Substring(12, 2)), int.Parse(table.Tables[0].Rows[i][13].ToString().Substring(15, 2))); phong.THOIGIANTHUCHIEN = ngaythuchien; pl_phong.Controls.Add(phong); vitribandau.X = 20; vitribandau.Y = 150; phong.Location = vitribandau; vitribandau.Y += 165; } else { if (i == 10) { PhongChuaDatCoc phong = new PhongChuaDatCoc(); phong.MAHD = table.Tables[0].Rows[i][3].ToString(); phong.MAPHONG = table.Tables[0].Rows[i][6].ToString(); DataSet laytenphong = new DataSet(); DTO_Phong phong1 = new DTO_Phong(); phong1.MaPhong = table.Tables[0].Rows[i][6].ToString(); phong1.MaChiNhanh = machinhanh; laytenphong = hienthi.LayTenPhong(phong1); phong.TENPHONG = laytenphong.Tables[0].Rows[0][2].ToString(); DateTime ngaythuchien = new DateTime(int.Parse("20" + table.Tables[0].Rows[i][13].ToString().Substring(6, 2)), int.Parse(table.Tables[0].Rows[i][13].ToString().Substring(3, 2)), int.Parse(table.Tables[0].Rows[i][13].ToString().Substring(0, 2)), int.Parse(table.Tables[0].Rows[i][13].ToString().Substring(9, 2)), int.Parse(table.Tables[0].Rows[i][13].ToString().Substring(12, 2)), int.Parse(table.Tables[0].Rows[i][13].ToString().Substring(15, 2))); phong.THOIGIANTHUCHIEN = ngaythuchien; pl_phong.Controls.Add(phong); vitribandau.X = 20; vitribandau.Y = 230; phong.Location = vitribandau; vitribandau.Y += 165; } else { if (i == 15) { PhongChuaDatCoc phong = new PhongChuaDatCoc(); phong.MAHD = table.Tables[0].Rows[i][3].ToString(); phong.MAPHONG = table.Tables[0].Rows[i][6].ToString(); DataSet laytenphong = new DataSet(); DTO_Phong phong1 = new DTO_Phong(); phong1.MaPhong = table.Tables[0].Rows[i][6].ToString(); phong1.MaChiNhanh = machinhanh; laytenphong = hienthi.LayTenPhong(phong1); phong.TENPHONG = laytenphong.Tables[0].Rows[0][2].ToString(); DateTime ngaythuchien = new DateTime(int.Parse("20" + table.Tables[0].Rows[i][13].ToString().Substring(6, 2)), int.Parse(table.Tables[0].Rows[i][13].ToString().Substring(3, 2)), int.Parse(table.Tables[0].Rows[i][13].ToString().Substring(0, 2)), int.Parse(table.Tables[0].Rows[i][13].ToString().Substring(9, 2)), int.Parse(table.Tables[0].Rows[i][13].ToString().Substring(12, 2)), int.Parse(table.Tables[0].Rows[i][13].ToString().Substring(15, 2))); phong.THOIGIANTHUCHIEN = ngaythuchien; pl_phong.Controls.Add(phong); vitribandau.X = 20; vitribandau.Y = 360; phong.Location = vitribandau; vitribandau.Y += 165; } else { PhongChuaDatCoc phong = new PhongChuaDatCoc(); phong.MAHD = table.Tables[0].Rows[i][3].ToString(); phong.MAPHONG = table.Tables[0].Rows[i][6].ToString(); DataSet laytenphong = new DataSet(); DTO_Phong phong1 = new DTO_Phong(); phong1.MaPhong = table.Tables[0].Rows[i][6].ToString(); phong1.MaChiNhanh = machinhanh; laytenphong = hienthi.LayTenPhong(phong1); phong.TENPHONG = laytenphong.Tables[0].Rows[0][2].ToString(); DateTime ngaythuchien = new DateTime(int.Parse("20" + table.Tables[0].Rows[i][13].ToString().Substring(6, 2)), int.Parse(table.Tables[0].Rows[i][13].ToString().Substring(3, 2)), int.Parse(table.Tables[0].Rows[i][13].ToString().Substring(0, 2)), int.Parse(table.Tables[0].Rows[i][13].ToString().Substring(9, 2)), int.Parse(table.Tables[0].Rows[i][13].ToString().Substring(12, 2)), int.Parse(table.Tables[0].Rows[i][13].ToString().Substring(15, 2))); phong.THOIGIANTHUCHIEN = ngaythuchien; pl_phong.Controls.Add(phong); phong.Location = vitribandau; vitribandau.Y += 165; } } } } } }
private void load() { lbTen.Text = tennv; lbTenChiNhanh.Text = tenchinhanh; DTO_HoaDon phong = new DTO_HoaDon(); phong.MaChiNhanh = machinhanh; BO_QuanLiChiNhanh quanli = new BO_QuanLiChiNhanh(); DataSet table = new DataSet(); table = quanli.HienThiDSPhongDaDatCuaKhachHang(phong); if (table.Tables.Count > 0 && table.Tables[0].Rows.Count > 0) { Point vitridau = new Point(20, 20); for (int i = 0; i < table.Tables[0].Rows.Count; i++) { if (i == 5) { PhongCuaKhach dsphong = new PhongCuaKhach(); dsphong.MACHINHANH = machinhanh; dsphong.MAPHONG = table.Tables[0].Rows[i][6].ToString(); BO_QuanLiChiNhanh quanli1 = new BO_QuanLiChiNhanh(); DTO_Phong phong1 = new DTO_Phong(); phong1.MaPhong = table.Tables[0].Rows[i][6].ToString(); phong1.MaChiNhanh = machinhanh; DataSet KQ = quanli1.LayTenPhong(phong1); dsphong.TENPHONG = KQ.Tables[0].Rows[0][2].ToString(); dsphong.SDT = table.Tables[0].Rows[i][7].ToString(); dsphong.TENCHINHANH = tenchinhanh; dsphong.TENNV = tennv; dsphong.MANV = manv; DateTime ngaydat = new DateTime(int.Parse("20" + table.Tables[0].Rows[i][8].ToString().Substring(6, 2)), int.Parse(table.Tables[0].Rows[i][8].ToString().Substring(3, 2)), int.Parse(table.Tables[0].Rows[i][8].ToString().Substring(0, 2)), int.Parse(table.Tables[0].Rows[i][8].ToString().Substring(9, 2)), int.Parse(table.Tables[0].Rows[i][8].ToString().Substring(12, 2)), int.Parse(table.Tables[0].Rows[i][8].ToString().Substring(15, 2))); dsphong.NGAYDAT = ngaydat; dsphong.MAHD = table.Tables[0].Rows[i][3].ToString(); vitridau.X = 20; vitridau.Y = 150; dsphong.Location = vitridau; pl_phong.Controls.Add(dsphong); vitridau.X += 165; } else { PhongCuaKhach dsphong = new PhongCuaKhach(); dsphong.MACHINHANH = machinhanh; dsphong.MAPHONG = table.Tables[0].Rows[i][6].ToString(); BO_QuanLiChiNhanh quanli1 = new BO_QuanLiChiNhanh(); DTO_Phong phong1 = new DTO_Phong(); phong1.MaPhong = table.Tables[0].Rows[i][6].ToString(); phong1.MaChiNhanh = machinhanh; DataSet KQ = quanli1.LayTenPhong(phong1); dsphong.TENPHONG = KQ.Tables[0].Rows[0][2].ToString(); dsphong.SDT = table.Tables[0].Rows[i][7].ToString(); dsphong.TENCHINHANH = tenchinhanh; DateTime ngaydat = new DateTime(int.Parse("20" + table.Tables[0].Rows[i][8].ToString().Substring(6, 2)), int.Parse(table.Tables[0].Rows[i][8].ToString().Substring(3, 2)), int.Parse(table.Tables[0].Rows[i][8].ToString().Substring(0, 2)), int.Parse(table.Tables[0].Rows[i][8].ToString().Substring(9, 2)), int.Parse(table.Tables[0].Rows[i][8].ToString().Substring(12, 2)), int.Parse(table.Tables[0].Rows[i][8].ToString().Substring(15, 2))); dsphong.NGAYDAT = ngaydat; dsphong.TENNV = tennv; dsphong.MANV = manv; dsphong.MAHD = table.Tables[0].Rows[i][3].ToString(); dsphong.Location = vitridau; pl_phong.Controls.Add(dsphong); vitridau.X += 165; } } } }