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