public DataTable DataTable_DSTDV(ArrayList ds)
        {
            DichVuBUS        dvbus   = new DichVuBUS();
            PhongBUS         pbus    = new PhongBUS();
            KhachHangBUS     khbus   = new KhachHangBUS();
            HoaDonDichVuBUS  hddvbus = new HoaDonDichVuBUS();
            ChiTietDichVuBUS ctdvbus = new ChiTietDichVuBUS();
            eHoaDonDichVu    hddv    = new eHoaDonDichVu();//
            DataTable        dt      = new DataTable();

            dt.Columns.Add("Phòng", typeof(string));
            dt.Columns.Add("Khách hàng", typeof(string));
            dt.Columns.Add("Tiền DV", typeof(double));
            dt.Columns.Add("Ngày Lập", typeof(string));
            for (int i = 0; i < ds.Count; i++)
            {
                for (int j = 1; j < ds.Count; j++)
                {
                    if (i == j)
                    {
                        continue;
                    }
                    if (ds[i].Equals(ds[j]))
                    {
                        ds.RemoveAt(i);
                    }
                }
            }
            double tongTienDV = 0;

            foreach (string item in ds)
            {
                foreach (var ctdv in ctdvbus.getctdv_byMaThue(item))
                {
                    double tienDV = 0;
                    foreach (var ctdv1 in ctdvbus.getctdv_byMaThue(ctdv.MaThue))
                    {
                        tienDV += ctdv1.SoLuong * dvbus.getDonGia_byID(ctdv1.MaDV);
                    }
                    dt.Rows.Add(pbus.getTenPhong_ByID(ctdv.MaPhong), khbus.getenKH_ByID(ctdv.MaKhach), tienDV, hddvbus.getNgay_byMaThue(ctdv.MaThue).ToShortDateString());
                    tongTienDV += tienDV;
                    break;
                }
            }
            lblTongTien.Text = string.Format("{0:#,##0 vnđ}", tongTienDV).ToString();
            return(dt);
        }
Example #2
0
        public double tienDV(ArrayList ds)
        {
            double           tongTienDV = 0;
            DichVuBUS        dvbus      = new DichVuBUS();
            PhongBUS         pbus       = new PhongBUS();
            KhachHangBUS     khbus      = new KhachHangBUS();
            HoaDonDichVuBUS  hddvbus    = new HoaDonDichVuBUS();
            ChiTietDichVuBUS ctdvbus    = new ChiTietDichVuBUS();
            eHoaDonDichVu    hddv       = new eHoaDonDichVu();

            for (int i = 0; i < ds.Count; i++)
            {
                for (int j = 1; j < ds.Count; j++)
                {
                    if (i == j)
                    {
                        continue;
                    }
                    if (ds[i].Equals(ds[j]))
                    {
                        ds.RemoveAt(i);
                    }
                }
            }
            foreach (string item in ds)
            {
                foreach (var ctdv in ctdvbus.getctdv_byMaThue(item))
                {
                    double tienDV = 0;
                    foreach (var ctdv1 in ctdvbus.getctdv_byMaThue(ctdv.MaThue))
                    {
                        tienDV += ctdv1.SoLuong * dvbus.getDonGia_byID(ctdv1.MaDV);
                    }
                    tongTienDV += tienDV;
                    break;
                }
            }
            return(tongTienDV);
        }
        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();
                        }
                    }
                }
            }
        }
Example #4
0
        private void btnLuu_Click(object sender, EventArgs e)
        {
            ThuePhongBUS        tpbus   = new ThuePhongBUS();
            ChiTietThuePhongBUS cttpbus = new ChiTietThuePhongBUS();
            ChiTietDichVuBUS    ctdvbus = new ChiTietDichVuBUS();
            PhongBUS            pbus    = new PhongBUS();
            int s = 0;

            foreach (eThuePhong item in tpbus.getMaThue(maThue))
            {
                eThuePhong etp = new eThuePhong();
                etp.MaNV         = item.MaNV;
                etp.MaDoan       = item.MaDoan;
                etp.SoLuongPhong = item.SoLuongPhong;
                etp.TrangThai    = false;
                s = tpbus.insertThuePhong(etp);
            }

            if (s != 1)
            {
                return;
            }
            if (s == 1)
            {
                foreach (eChiTietThuePhong item in cttpbus.getChiTietThuePhong_By_MaThue_MaPhong(maThue, pbus.maPhong_byTen(TenPhong)))
                {
                    eChiTietThuePhong ect = new eChiTietThuePhong();
                    ect.GioRa     = item.GioRa;
                    ect.GioVao    = item.GioVao;
                    ect.MaKhach   = item.MaKhach;
                    ect.MaPhong   = cboPhongTrong.SelectedValue.ToString();
                    ect.NgayRa    = item.NgayRa;
                    ect.NgayVao   = item.NgayVao;
                    ect.TienKhac  = tienkhac;
                    ect.MaThue    = tpbus.getMaThueCuoi();
                    ect.TrangThai = false;
                    ect.GhiChu    = cttpbus.getCTTP_By_MaPhong_TrangThai(pbus.maPhong_byTen(TenPhong), false).GhiChu + lblTenPhong.Text + " (" + item.GioVao + " " + item.NgayVao.ToShortDateString() + ")" + " đến " + cboPhongTrong.Text + " (" + DateTime.Now.ToLongTimeString() + " " + DateTime.Now.ToShortDateString() + ")";
                    cttpbus.insertCTTP(ect);
                }
                foreach (eChiTietThuePhong item in cttpbus.getChiTietThuePhong_By_MaThue_TrangThai(maThue, 0))
                {
                    if (!item.MaPhong.Equals(pbus.maPhong_byTen(TenPhong)))
                    {
                        eChiTietThuePhong ect = new eChiTietThuePhong();
                        ect.GioRa     = item.GioRa;
                        ect.GioVao    = item.GioVao;
                        ect.MaKhach   = item.MaKhach;
                        ect.MaPhong   = item.MaPhong;
                        ect.NgayRa    = item.NgayRa;
                        ect.NgayVao   = item.NgayVao;
                        ect.MaThue    = tpbus.getMaThueCuoi();
                        ect.TrangThai = false;
                        cttpbus.insertCTTP(ect);
                    }
                }
                foreach (eChiTietThuePhong item in cttpbus.getChiTietThuePhong_By_MaThue_TrangThai(maThue, 1))
                {
                    eChiTietThuePhong ect = new eChiTietThuePhong();
                    ect.GioRa     = item.GioRa;
                    ect.GioVao    = item.GioVao;
                    ect.MaKhach   = item.MaKhach;
                    ect.MaPhong   = item.MaPhong;
                    ect.NgayRa    = item.NgayRa;
                    ect.NgayVao   = item.NgayVao;
                    ect.MaThue    = tpbus.getMaThueCuoi();
                    ect.TrangThai = true;
                    cttpbus.insertCTTP(ect);
                }

                foreach (eChiTetDichVu item in ctdvbus.getctdv_byMaThue(maThue))
                {
                    eChiTetDichVu ctdv = new eChiTetDichVu();
                    ctdv.MaThue  = tpbus.getMaThueCuoi();
                    ctdv.MaPhong = cboPhongTrong.SelectedValue.ToString();
                    ctdv.MaKhach = item.MaKhach;
                    ctdv.MaDV    = item.MaDV;
                    ctdv.SoLuong = item.SoLuong;
                    ctdvbus.insertCTDV(ctdv);
                }

                foreach (var item in cttpbus.getChiTietThuePhong_By_MaThue(maThue))
                {
                    if (item.MaPhong.Equals(pbus.maPhong_byTen(TenPhong)))
                    {
                        eChiTietThuePhong ectOld = new eChiTietThuePhong();
                        ectOld.MaThue  = maThue;
                        ectOld.MaPhong = item.MaPhong;
                        //ectOld.MaKhach = cttpbus.getMaKhach_By_MaPhong_TrangThai(ectOld.MaPhong, false);
                        ectOld.MaKhach   = item.MaKhach;
                        ectOld.TrangThai = true;
                        ectOld.GhiChu    = "Đổi phòng";
                        cttpbus.updateTrangThaiChiTietThuePhong(ectOld);
                    }
                    else
                    {
                        eChiTietThuePhong ectOld = new eChiTietThuePhong();
                        ectOld.MaThue    = maThue;
                        ectOld.MaPhong   = item.MaPhong;
                        ectOld.MaKhach   = item.MaKhach;
                        ectOld.TrangThai = true;
                        ectOld.GhiChu    = null;
                        cttpbus.updateTrangThaiChiTietThuePhong(ectOld);
                    }
                }

                eThuePhong tp = new eThuePhong();
                tp.MaThue    = maThue;
                tp.TrangThai = true;
                tpbus.updateThuePhong(tp);

                ePhong ep = new ePhong();
                ep.MaPhong   = pbus.maPhong_byTen(TenPhong);
                ep.TinhTrang = false;
                pbus.updateTinhTrangPhong(ep);

                ePhong newp = new ePhong();
                newp.MaPhong     = cboPhongTrong.SelectedValue.ToString();
                newp.TinhTrang   = true;
                newp.SoNgHienTai = pbus.getEPhong_byID(pbus.maPhong_byTen(TenPhong)).SoNgHienTai;
                pbus.updateTinhTrangPhong(newp);

                MessageBox.Show("Thành công");
                this.Close();
            }
            else
            {
                MessageBox.Show("Không thành công");
                return;
            }
        }