private void frmThanhToan_Load(object sender, EventArgs e)
{
if (doan != null)
{
DoanBUS dbus = new DoanBUS();
txtTenDoan.Text = dbus.getTen_ById(doan);
}
lblMaThue.Text = MaThue;
lblLoaiPhong.Text = LoaiPhong;
lblTenPhong.Text = TenPhong;
loadKhachHang();
tienPhuThu();
tinhTienPhong();
load_list_dichvu();
double tongtien = tienvat + tienphong + tiendv + Convert.ToDouble(phuthu) + Convert.ToDouble(tienkhac) - giamgia;
txtTongTien.Text = string.Format("{0:#,##0}", tongtien).ToString();
}
public DataTable DataTable_DSTP(ArrayList ds)
{
KhachHangBUS khbus = new KhachHangBUS();
PhongBUS pbus = new PhongBUS();
ThuePhongBUS tpbus = new ThuePhongBUS();
DoanBUS dbus = new DoanBUS();
LoaiPhongBUS lpbus = new LoaiPhongBUS();
ChiTietThuePhongBUS cttpbus = new ChiTietThuePhongBUS();
eHoaDonTienPhong hdtp = new eHoaDonTienPhong();
DataTable dt = new DataTable();
dt.Columns.Add("Tên khách hàng", typeof(string));
dt.Columns.Add("Tiền phòng", typeof(double));
dt.Columns.Add("Thời gian vào", typeof(string));
dt.Columns.Add("Thời gian ra", typeof(string));
foreach (string item in ds)
{
double tienPhong = 0;
foreach (var cttp in cttpbus.getChiTietThuePhong_By_MaThue(item))
{
tienPhong += hdtp.tinhTienPhong(cttp, lpbus.donGia(pbus.getLoaiPhong_ByID(cttp.MaPhong)), Convert.ToDateTime(cttp.GioVao + " " + cttp.NgayVao.ToShortDateString()), Convert.ToDateTime(cttp.GioRa + " " + cttp.NgayRa.ToShortDateString())) + hdtp.tinhTienPhuThu(cttp, lpbus.donGia(pbus.getLoaiPhong_ByID(cttp.MaPhong))) + cttp.TienKhac;
}
if (tpbus.getMaDoan_ByMaThue(item) == null)
{
foreach (var cttp in cttpbus.getChiTietThuePhong_By_MaThue(item))
{
dt.Rows.Add(khbus.getenKH_ByID(cttp.MaKhach), tienPhong, cttp.GioVao + " " + cttp.NgayVao.ToShortDateString(), cttp.GioRa + " " + cttp.NgayRa.ToShortDateString());
}
}
else
{
foreach (var cttp in cttpbus.getChiTietThuePhong_By_MaThue(item))
{
dt.Rows.Add(dbus.getTen_ById(tpbus.getMaDoan_ByMaThue(item)), tienPhong, cttp.GioVao + " " + cttp.NgayVao.ToShortDateString(), cttp.GioRa + " " + cttp.NgayRa.ToShortDateString());
break;
}
}
}
return(dt);
}
//Load giao diện các phòng trống và phòng có chứa khách hàng
public void TaoGiaoDienPhong(List <ePhong> soPhong, List <ePhong> phongTrong, List <ePhong> coKhach, string title)
{
//Tạo ra một flowLayoutPanel để chứa các panel
PhongBUS pbus = new PhongBUS();
FlowLayoutPanel flowLayoutPanel3 = new FlowLayoutPanel();
flowLayoutPanel3.AutoSize = true;
flowLayoutPanel3.AutoSizeMode = AutoSizeMode.GrowAndShrink;
flowLayoutPanel1.Controls.Add(flowLayoutPanel3);
Label text = new Label();
text.Size = new Size(1850, 30);
text.TextAlign = ContentAlignment.TopCenter;
text.Text = title;
flowLayoutPanel3.Controls.Add(text);
//Tạo các label để chứa thông tin, màu sắc thể hiện các phòng
foreach (var item in soPhong)
{
DevExpress.XtraEditors.PanelControl P0001 = new DevExpress.XtraEditors.PanelControl();
Label lbl = new Label();
flowLayoutPanel3.Controls.Add(P0001);
P0001.Appearance.Options.UseBackColor = true;
P0001.BorderStyle = DevExpress.XtraEditors.Controls.BorderStyles.Style3D;
P0001.Controls.Add(lbl);
P0001.Location = new Point(3, 3);
P0001.Name = item.MaPhong;
P0001.Size = new Size(170, 150);
lbl.Font = new Font("Tahoma", 9F);
lbl.Dock = DockStyle.Fill;
lbl.Size = new Size(150, 120);
lbl.TextAlign = ContentAlignment.TopCenter;
}
//Load thông tin của phòng trống vào từng label
foreach (var item in phongTrong)
{
foreach (var pnl in flowLayoutPanel3.Controls.OfType <DevExpress.XtraEditors.PanelControl>())
{
if (pnl.Name.Equals(item.MaPhong.Trim()))
{
pnl.BackColor = Color.LawnGreen;
foreach (var lbl in pnl.Controls.OfType <Label>())
{
string ma = item.MaPhong.Substring(3, 5);
lbl.BackColor = Color.LawnGreen;
lbl.Text = "Phòng " + Convert.ToInt32(ma);
lbl.MouseDown += new MouseEventHandler(lbl_ClickTP);
lbl.ContextMenuStrip = cmnstrpSanSang;
}
}
}
}
//Load thông tin của phòng đang có khách vào từng label
foreach (var item in coKhach)
{
foreach (var pnl in flowLayoutPanel3.Controls.OfType <DevExpress.XtraEditors.PanelControl>())
{
if (pnl.Name.Equals(item.MaPhong.Trim()))
{
pnl.BackColor = Color.FromArgb(((int)(((byte)(255)))), ((int)(((byte)(192)))), ((int)(((byte)(128)))));
foreach (var lbl in pnl.Controls.OfType <Label>())
{
lbl.BackColor = Color.FromArgb(((int)(((byte)(255)))), ((int)(((byte)(192)))), ((int)(((byte)(128)))));
string ma = item.MaPhong.Substring(3, 5);
ChiTietThuePhongBUS cttpbus = new ChiTietThuePhongBUS();
DoanBUS dbus = new DoanBUS();
ThuePhongBUS tpbus = new ThuePhongBUS();
foreach (var thuePhong in tpbus.getMaThue(cttpbus.getMaThue_By_MaPhong_TrangThai(item.MaPhong, false)))
{
if (thuePhong.MaDoan == null)
{
lbl.Text = "Phòng " + Convert.ToInt32(ma);
}
else
{
string tendoan = dbus.getTen_ById(tpbus.getMaDoan_ByMaThue(cttpbus.getMaThue_By_MaPhong_TrangThai(item.MaPhong, false)));
string tenPhong = "Phòng " + Convert.ToInt32(ma);
lbl.Text = tenPhong + "\n\n\rĐoàn: " + tendoan;
}
}
lbl.MouseDown += new MouseEventHandler(lblred_Click);
lbl.MouseHover += new EventHandler(lblred_MouseHover);
lbl.ContextMenuStrip = cmnstrpCoKhach;
}
}
}
}
}
private void btnThanhToan_Click(object sender, EventArgs e)
{
ChiTietThuePhongBUS cttpbus = new ChiTietThuePhongBUS();
ThuePhongBUS tpbus = new ThuePhongBUS();
DoanBUS dbus = new DoanBUS();
PhongBUS pbus = new PhongBUS();
HoaDonTienPhongBUS hdtpbus = new HoaDonTienPhongBUS();
TimeSpan gioHienTai = new TimeSpan(DateTime.Now.Hour, DateTime.Now.Minute, DateTime.Now.Second);
eHoaDonTienPhong tt_ent = new eHoaDonTienPhong();
tt_ent.MaThue = tpbus.getMaThue_ByMaDoan(dbus.getId_ByTenDoan(txtTenDoan.Text), 0);
tt_ent.NgayLap = DateTime.Now;
tt_ent.GioLap = gioHienTai;
tt_ent.ThueVAT = Convert.ToSingle(txtThueVAT.Text);
tt_ent.KhuyenMai = Convert.ToSingle(txtKhuyenMai.Text);
int a = hdtpbus.insertThanhToan(tt_ent);
if (a == 1)
{
foreach (var item in cttpbus.getChiTietThuePhong_By_MaThue(tpbus.getMaThue_ByMaDoan(dbus.getId_ByTenDoan(txtTenDoan.Text), 0)))
{
eChiTietThuePhong ectOld = new eChiTietThuePhong();
ectOld.MaThue = tpbus.getMaThue_ByMaDoan(dbus.getId_ByTenDoan(txtTenDoan.Text), 0);
ectOld.MaPhong = item.MaPhong;
ectOld.MaKhach = item.MaKhach;
ectOld.NgayRa = DateTime.Now.Date;
ectOld.GioRa = gioHienTai;
ectOld.TrangThai = true;
cttpbus.updateChiTietThuePhong(ectOld);
ePhong newp = new ePhong();
newp.MaPhong = item.MaPhong;
newp.TinhTrang = false;
newp.SoNgHienTai = 0;
pbus.updateTinhTrangPhong(newp);
}
eThuePhong tp = new eThuePhong();
tp.MaThue = tpbus.getMaThue_ByMaDoan(dbus.getId_ByTenDoan(txtTenDoan.Text), 0);
tp.TrangThai = true;
tpbus.updateThuePhong(tp);
MessageBox.Show("Thanh toán thành công");
NhanVienBUS nvbus = new NhanVienBUS();
LoaiPhongBUS lpbus = new LoaiPhongBUS();
HoaDon bc = new HoaDon();
List <eChiTietBaoCao> listphong = new List <eChiTietBaoCao>();
foreach (var item in cttpbus.getChiTietThuePhong_By_MaThue_TrangThai(tp.MaThue, 1))
{
eChiTietBaoCao ctbc = new eChiTietBaoCao();
ctbc.tenPhong = pbus.getTenPhong_ByID(item.MaPhong);
ctbc.tenLoaiPhong = lpbus.getTen_Byma(pbus.getLoaiPhong_ByID(item.MaPhong));
ctbc.thoiGianNhan = item.GioVao + " " + item.NgayVao.Date.ToShortDateString();
ctbc.thoiGianTra = item.GioRa + " " + item.NgayRa.Date.ToShortDateString();
eHoaDonTienPhong hdtp = new eHoaDonTienPhong();
double tienPhong = Convert.ToDouble(hdtp.tinhTienPhong(item, lpbus.donGia(pbus.getLoaiPhong_ByID(item.MaPhong)), Convert.ToDateTime(item.GioVao + " " + item.NgayVao.ToShortDateString()), Convert.ToDateTime(DateTime.Now.ToLongTimeString() + " " + DateTime.Now.ToShortDateString())));
double tienPhuThu = Convert.ToDouble(hdtp.tinhTienPhuThu(item, lpbus.donGia(pbus.getLoaiPhong_ByID(item.MaPhong))));
ctbc.tienPhong = tienPhong + tienPhuThu;
listphong.Add(ctbc);
}
for (int i = 0; i < listphong.Count; i++)
{
for (int j = 1; j < listphong.Count; j++)
{
if (i == j)
{
continue;
}
if (listphong[i].tenPhong.Equals(listphong[j].tenPhong))
{
listphong.RemoveAt(i);
}
}
}
foreach (var item in tpbus.getMaThue(tp.MaThue))
{
bc.tenNV = nvbus.getenNV_ByID(maNVThanhToan);
bc.tenKH = dbus.getTen_ById(item.MaDoan);
bc.soHD = hdtpbus.gemaHD_BymaThue(tp.MaThue); //Cần xem xét lại
bc.thoiGianInHD = DateTime.Now.ToLongTimeString() + " " + DateTime.Now.ToShortDateString();
}
this.Close();
frmPrint frmp = new frmPrint();
frmp.InHoaDonInTuReport(bc, listphong.ToList());
frmp.ShowDialog();
ChiTietDichVuBUS ctdvbus = new ChiTietDichVuBUS();
HoaDonDichVuBUS hddvbus = new HoaDonDichVuBUS();
DichVuBUS dvbus = new DichVuBUS();
KhachHangBUS khbus = new KhachHangBUS();
if (ctdvbus.getctdv_byMaThue(tt_ent.MaThue) != null)
{
foreach (var item in ctdvbus.getctdv_byMaThue(tt_ent.MaThue))
{
if (hddvbus.kiemTraTonTai(item.MaThue, item.MaPhong) == false)
{
eHoaDonDichVu hddv = new eHoaDonDichVu();
hddv.MaHDDV = (DateTime.Now.Day).ToString() + (DateTime.Now.Month).ToString() + (DateTime.Now.Year).ToString() + item.MaThue + item.MaKhach + item.MaPhong;
hddv.MaThue = item.MaThue;
hddv.MaKH = item.MaKhach;
hddv.MaPhong = item.MaPhong;
hddv.NgayLap = DateTime.Now.Date;
hddv.GioLap = gioHienTai;
hddvbus.insertThanhToanDV(hddv);
List <eCTDV> lsctdv = new List <eCTDV>();
foreach (eChiTetDichVu dv in ctdvbus.getctdv_MaThue_MaPhong(item.MaThue, item.MaPhong))
{
eCTDV ctdv = new eCTDV();
ctdv.TenDV = dvbus.getTenDV_byID(dv.MaDV);
ctdv.SoLuong = dv.SoLuong;
ctdv.DonGia = dvbus.getDonGia_byID(dv.MaDV);
lsctdv.Add(ctdv);
}
bc.tenNV = nvbus.getenNV_ByID(maNVThanhToan);
bc.tenKH = khbus.getenKH_ByID(item.MaKhach);
bc.soHD = hddvbus.gemaHD_BymaThue_maPhong(item.MaThue, item.MaPhong);
bc.thoiGianInHD = DateTime.Now.ToLongTimeString() + " " + DateTime.Now.ToShortDateString();
bc.tenPhong = pbus.getTenPhong_ByID(item.MaPhong);
frmPrint frmInDV = new frmPrint();
frmInDV.InHoaDonInDichVuTuReport(bc, lsctdv.ToList());
frmInDV.ShowDialog();
this.Close();
}
}
}
}
}