private void gridView2_CustomUnboundColumnData(object sender, DevExpress.XtraGrid.Views.Base.CustomColumnDataEventArgs e) { if (e.Column.FieldName == "colSoLuong") { if (e.IsGetData) { e.Value = dichVuPhong.Rows[e.ListSourceRowIndex]["SoLuong"]; } if (e.IsSetData) { DichVuPhongBUS.UpdateDichVuPhong(new DichVuPhongDTO((int)dichVuPhong.Rows[e.ListSourceRowIndex]["MaDVP"], (int)dichVuPhong.Rows[e.ListSourceRowIndex]["MaThuePhong"], (int)dichVuPhong.Rows[e.ListSourceRowIndex]["MaDV"], DateTime.Parse(dichVuPhong.Rows[e.ListSourceRowIndex]["ThoiGian"].ToString()), Convert.ToDouble(e.Value), (double)dichVuPhong.Rows[e.ListSourceRowIndex]["Gia"])); RefreshDataBindingDichVuPhong(); } } else if (e.Column.FieldName == "colDonGia") { if (e.IsGetData) { e.Value = Convert.ToInt32(dichVuPhong.Rows[e.ListSourceRowIndex]["Gia"]); } if (e.IsSetData) { DichVuPhongBUS.UpdateDichVuPhong(new DichVuPhongDTO((int)dichVuPhong.Rows[e.ListSourceRowIndex]["MaDVP"], (int)dichVuPhong.Rows[e.ListSourceRowIndex]["MaThuePhong"], (int)dichVuPhong.Rows[e.ListSourceRowIndex]["MaDV"], DateTime.Parse(dichVuPhong.Rows[e.ListSourceRowIndex]["ThoiGian"].ToString()), (double)dichVuPhong.Rows[e.ListSourceRowIndex]["SoLuong"], Convert.ToDouble(e.Value))); RefreshDataBindingDichVuPhong(); } } else if (e.Column.FieldName == "colThanhTien") { if (e.IsGetData) { e.Value = Convert.ToInt32(dichVuPhong.Rows[e.ListSourceRowIndex]["SoLuong"]) * (double)dichVuPhong.Rows[e.ListSourceRowIndex]["Gia"]; } } }
public void LuuKhuyenMai() { foreach (DichVuPhongDTO dichVuPhong in listKhuyenMai.Values) { DichVuPhongBUS.LuuThongTinDichVuPhong(new DichVuPhongDTO(DichVuPhongBUS.PhatSinhMaDichVuPhong(), thuePhong.MaThuePhong, dichVuPhong.MaDV, dichVuPhong.ThoiGian, dichVuPhong.SoLuong, dichVuPhong.DonGia)); } }
public void XoaDichVu() { if (gridView1.RowCount == 0) { XtraMessageBox.Show("Không có dịch vụ/Khuyến mãi nào được chọn", "Lỗi", MessageBoxButtons.OK, MessageBoxIcon.Information); return; } if (XtraMessageBox.Show("Bạn có chắc muốn xóa dịch vụ/khuyến mãi " + dichVuPhong.Rows[gridView1.GetFocusedDataSourceRowIndex()]["TenDV"] + "' ?", "Xác nhận", MessageBoxButtons.YesNo, MessageBoxIcon.Exclamation) == DialogResult.No) { return; } if (dichVuPhong.Rows[gridView1.GetFocusedDataSourceRowIndex()]["colType"].ToString() == "Khuyến mãi") { listKhuyenMai.Remove((int)dichVuPhong.Rows[gridView1.GetFocusedDataSourceRowIndex()]["MaDVP"]); } else { DichVuPhongBUS.XoaDichVuPhong((int)dichVuPhong.Rows[gridView1.GetFocusedDataSourceRowIndex()]["MaDVP"]); } RefreshDataBindingDichVuPhong(); CalcTongTienAction(); }
public void ThemDichVu() { folderDichVu.ChonDichVu chonDichVu = new folderDichVu.ChonDichVu(true); XtraDialogArgs args = new XtraDialogArgs(caption: "Chọn dịch vụ", content: chonDichVu, buttons: new DialogResult[] { DialogResult.OK, DialogResult.Cancel }); args.Showing += Args_Showing; if (XtraDialog.Show(args) == DialogResult.OK) { foreach (int dichVu_Key in chonDichVu.GetSelectedDichVu().Keys) { if (DichVuBUS.LayThongTinDichVu(dichVu_Key).MaLoaiDV == 3) { listKhuyenMai.Add(-(listKhuyenMai.Count + 1), new DichVuPhongDTO(-(listKhuyenMai.Count + 1), thuePhong.MaThuePhong, dichVu_Key, DateTime.Now, chonDichVu.GetSelectedDichVu()[dichVu_Key], DichVuBUS.LayThongTinDichVu(dichVu_Key).DonGia)); } else { DichVuPhongBUS.LuuThongTinDichVuPhong(new DichVuPhongDTO(DichVuPhongBUS.PhatSinhMaDichVuPhong(), thuePhong.MaThuePhong, dichVu_Key, DateTime.Now, chonDichVu.GetSelectedDichVu()[dichVu_Key], DichVuBUS.LayThongTinDichVu(dichVu_Key).DonGia)); } //DichVuBUS.LayThongTinDichVu(dichVu_Key); } RefreshDataBindingDichVuPhong(); CalcTongTienAction(); } }
public void RefreshDataBinding_ReadOnly(ThuePhongDTO thuePhong) { this.thuePhong = thuePhong; txtGioVao.Time = thuePhong.GioThuePhong; txtGioRa.Time = (thuePhong.GioTraPhong == DateTime.MinValue) ? DateTime.Now : thuePhong.GioTraPhong; txtTienGio.Properties.NullText = thuePhong.TienGio.ToString("###,###,##0 VNĐ"); TongTienGio = thuePhong.TienGio; txtTienGio.ReadOnly = true; gridView1.OptionsBehavior.ReadOnly = true; dichVuPhong = DichVuPhongBUS.LayTatCaDichVuPhong_DichVu(thuePhong); dichVuPhong.Columns.Add(new DataColumn("colType")); foreach (DataRow row in dichVuPhong.Rows) { if ((int)row["MaLDV"] == 3) { row["colType"] = "Khuyến mãi"; } else { row["colType"] = "Dịch vụ"; } } gridControl1.DataSource = dichVuPhong; }
public void LuuThongTinDichVuPhong(ThuePhongDTO tp) { foreach (DataRow dr in dichVuPhong.Rows) { DichVuPhongBUS.LuuThongTinDichVuPhong(new DichVuPhongDTO(DichVuPhongBUS.PhatSinhMaDichVuPhong(), tp.MaThuePhong, (int)dr["MaDichVu"], DateTime.Now, (double)dr["SoLuong"], (double)dr["Gia"])); } }
void RefreshDataBindingDichVuPhong() { dichVuPhong = DichVuPhongBUS.LayTatCaDichVuPhong_DichVu(thuePhong); gridControl1.DataSource = dichVuPhong; if (gridView1.RowCount == 0) { wbntQuanlyphong.Buttons["Xóa Dịch Vụ"].Properties.Visible = false; } else { wbntQuanlyphong.Buttons["Xóa Dịch Vụ"].Properties.Visible = true; } }
public void RefreshDataBinding() { dtHoaDon = DichVuPhongBUS.LayThongKeTatCaCacDichVu_TrongThang(datepickerNam.DateTime); dtHoaDon.TableName = "hoadon"; dtChiTietDichVu = DichVuPhongBUS.LayTatCaCacDichVu_TrongNam(datepickerNam.DateTime); dtChiTietDichVu.TableName = "chitiet"; dsHoaDon = new DataSet(); dsHoaDon.Tables.Add(dtHoaDon); dsHoaDon.Tables.Add(dtChiTietDichVu); dsHoaDon.Relations.Add("Thông tin chi tiết", dsHoaDon.Tables["hoadon"].Columns["Thang"], dsHoaDon.Tables["chitiet"].Columns["Thang"]); GridControlHoaDon.DataSource = dsHoaDon.Tables["hoadon"]; GridControlHoaDon.LevelTree.Nodes.Add("Thông tin chi tiết", gridView1); chartControl.Series[1].Points.Clear(); Dictionary <int, double> doanhThuNam = DichVuPhongBUS.GetTongDoanhThuTheoThang(datepickerNam.DateTime); for (int i = 1; i <= 12; i++) { if (doanhThuNam.ContainsKey(i)) { chartControl.Series[1].Points.Add(new DevExpress.XtraCharts.SeriesPoint("Tháng " + i, doanhThuNam[i])); } else { chartControl.Series[1].Points.Add(new DevExpress.XtraCharts.SeriesPoint("Tháng " + i, 0)); } } //rangeControl1.SelectAll(); gridViewHoaDon.ActiveFilterString = ""; gridViewHoaDon.ExpandAllGroups(); gridViewHoaDon.FocusedRowHandle = -1; //foreach (DevExpress.XtraCharts.Series series in chartControl.Series) //{ // series.Visible = false; //} //chartControl.Series["Doanh thu theo tháng"].Visible = true; chartControl.Animate(); }
void RefreshDataBindingDichVuPhong() { dichVuPhong = DichVuPhongBUS.LayTatCaDichVuPhong_DichVu(thuePhong); dichVuPhong.Columns.Add(new DataColumn("colType")); foreach (DataRow row in dichVuPhong.Rows) { row["colType"] = "Dịch vụ"; } foreach (DichVuPhongDTO khuyenMai in listKhuyenMai.Values) { DataRow dr = dichVuPhong.NewRow(); dr["MaDVP"] = khuyenMai.MaDVP; dr["MaThuePhong"] = khuyenMai.MaThuePhong; dr["MaDV"] = khuyenMai.MaDV; dr["ThoiGian"] = khuyenMai.ThoiGian; dr["SoLuong"] = khuyenMai.SoLuong; dr["Gia"] = khuyenMai.DonGia; DichVuDTO thongTinDichVu = DichVuBUS.LayThongTinDichVu(khuyenMai.MaDV); dr["TenDV"] = thongTinDichVu.TenDV; dr["DonVi"] = thongTinDichVu.DonVi; dr["MaLDV"] = thongTinDichVu.MaLoaiDV; dr["TenLDV"] = "Khuyến mãi"; dr["colType"] = "Khuyến mãi"; dichVuPhong.Rows.Add(dr); } gridControl1.DataSource = dichVuPhong; gridView1.ExpandAllGroups(); }
private void wbntQuanlyphong_ButtonClick(object sender, DevExpress.XtraBars.Docking2010.ButtonEventArgs e) { switch (e.Button.Properties.Tag.ToString()) { case "Thêm Dịch Vụ": folderDichVu.ChonDichVu chonDichVu = new folderDichVu.ChonDichVu(false); XtraDialogArgs args = new XtraDialogArgs(caption: "Chọn dịch vụ", content: chonDichVu, buttons: new DialogResult[] { DialogResult.OK, DialogResult.Cancel }); args.Showing += Args_Showing; if (XtraDialog.Show(args) == DialogResult.OK) { foreach (int dichVu_Key in chonDichVu.GetSelectedDichVu().Keys) { DichVuPhongBUS.LuuThongTinDichVuPhong(new DichVuPhongDTO(DichVuPhongBUS.PhatSinhMaDichVuPhong(), thuePhong.MaThuePhong, dichVu_Key, DateTime.Now, chonDichVu.GetSelectedDichVu()[dichVu_Key], DichVuBUS.LayThongTinDichVu(dichVu_Key).DonGia)); //DichVuBUS.LayThongTinDichVu(dichVu_Key); } RefreshDataBindingDichVuPhong(); } break; case "Chuyển Phòng": ChuyenPhong formChuyenPhong = new ChuyenPhong(thuePhong); if (FlyoutDialog.Show(this.FindForm(), formChuyenPhong) == DialogResult.OK) { OnThueThemPhongSuccess(); } break; case "Xóa Dịch Vụ": if (XtraMessageBox.Show("Bạn có chắc muốn xóa dịch vụ '" + dichVuPhong.Rows[gridView1.GetFocusedDataSourceRowIndex()]["TenDV"] + "' ?", "Xác nhận", MessageBoxButtons.YesNo, MessageBoxIcon.Exclamation) == DialogResult.Yes) { DichVuPhongBUS.XoaDichVuPhong((int)dichVuPhong.Rows[gridView1.GetFocusedDataSourceRowIndex()]["MaDVP"]); RefreshDataBindingDichVuPhong(); } break; case "Hủy Phòng": //Thông báo xác nhận if (XtraMessageBox.Show("Bạn có chắc hủy thuê phòng này ?", "Xác nhận", MessageBoxButtons.YesNo) == DialogResult.No) { return; } ThuePhongBUS.XoaCacDichVuPhong(thuePhong); ThuePhongBUS.XoaThuePhong(thuePhong); PhongBUS.CapNhatTinhTrangPhong(thuePhong.MaPhong, 0); if (HoaDonBUS.DemSoLuongThuePhong(hoaDon.MaHoaDon) == 0) { HoaDonBUS.XoaHoaDon(hoaDon); } ((ThongTinChiTietNhieuPhong)Parent.Parent.Parent).OnXoaPhong(); break; case "Trả Phòng": //Đếm số lượng phòng đã trả trong hóa đơn / Nếu hóa đơn còn 1 phòng chuyển qua thanh toán if (HoaDonBUS.DemSoLuongPhongDangConDuocThueHienTai(hoaDon) == 1) { XtraMessageBox.Show("Hóa đơn chỉ còn lại 1 phòng! Vui lòng thanh toán", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information); return; } //Xác nhận trả phòng if (XtraMessageBox.Show("Bạn có chắc trả phòng này ?", "Xác nhận", MessageBoxButtons.YesNo) == DialogResult.No) { return; } ThuePhongBUS.CapNhatThongTinThuePhong(new ThuePhongDTO(thuePhong.MaThuePhong, thuePhong.MaPhong, thuePhong.GioThuePhong, DateTime.Now, thuePhong.MaHoaDon, Double.NaN)); switch (PhongBUS.LayThongTinPhong(thuePhong.MaPhong).MaTinhTrangPhong) { case 1: if (ThamSoBUS.LayChuyenSangChoDonDepSauKhiThanhToan()) { PhongBUS.CapNhatTinhTrangPhong(thuePhong.MaPhong, 5); } else { PhongBUS.CapNhatTinhTrangPhong(thuePhong.MaPhong, 0); } break; case 7: if (ThamSoBUS.LayChuyenSangChoDonDepSauKhiThanhToan()) { PhongBUS.CapNhatTinhTrangPhong(thuePhong.MaPhong, 6); } else { PhongBUS.CapNhatTinhTrangPhong(thuePhong.MaPhong, 4); } break; } //Thông báo thành công XtraMessageBox.Show("Trả phòng thành công!", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information); RefreshDataBinding(phong, ThuePhongBUS.LayThongTinThuePhong(thuePhong.MaThuePhong)); break; case "Thanh Toán": goToThanhToan(thuePhong); break; case "Thông tin đặt phòng": (this.ParentForm as MainForm).HienThiThongTinDatPhong(HoaDonBUS.LayThongTinHoaDon(thuePhong.MaHoaDon).MaDatPhong); break; case "Tách Hóa Đơn": if (HoaDonBUS.LayTatCaCacThuePhong(hoaDon.MaHoaDon).Count == 1) { XtraMessageBox.Show("Hóa đơn chỉ có 1 phòng nên không thể tách!", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information); return; } FlyoutDialog.Show(this.FindForm(), new TachHoaDon(hoaDon, OnThueThemPhongSuccess)); break; case "Thuê Thêm Phòng": FlyoutDialog.Show(this.FindForm(), new ThemPhongVaoHoaDon(hoaDon, OnThueThemPhongSuccess)); break; } }