private void btCapNhat_Click(object sender, EventArgs e) { SanBong sanBong = (SanBong)sanBongList[lvSanBong.SelectedIndices[0]]; PhieuDatSanBong phieuDatSanBong = PhieuDatSanBongBUS.getLatestPhieuDatSanBong(sanBong.id); HoaDon hoaDon = HoaDonBUS.getHoaDon(phieuDatSanBong.idHoaDon); int pos; foreach (MatHang matHang in matHangChoList) { pos = kiemTraChiTietHoaDon(matHang.id); if (pos == -1) { ChiTietHoaDonBUS.addChiTietHoaDon(new ChiTietHoaDon(0, hoaDon.id, matHang.id, matHang.soLuong, matHang.donGia)); } else { ((ChiTietHoaDon)chiTietHoaDonList[pos]).soLuong = matHang.soLuong; ChiTietHoaDonBUS.updateChiTietHoaDon((ChiTietHoaDon)chiTietHoaDonList[pos]); } } hoaDon.tenKhachHang = tbTenKhachHang.Text; HoaDonBUS.updateHoaDon(hoaDon); phieuDatSanBong.thoiGianBatDau = dtpGioVao.Value; phieuDatSanBong.soGioDat = (int)nudSoGio.Value; PhieuDatSanBongBUS.updatePhieuDatSanBong(phieuDatSanBong); }
private void btThuTien_Click(object sender, EventArgs e) { SanBong sanBong = (SanBong)sanBongList[lvSanBong.SelectedIndices[0]]; PhieuDatSanBong phieuDatSanBong = PhieuDatSanBongBUS.getLatestPhieuDatSanBong(sanBong.id); HoaDon hoaDon = HoaDonBUS.getHoaDon(phieuDatSanBong.idHoaDon); hoaDon.daThanhToan = true; HoaDonBUS.updateHoaDon(hoaDon); btThuTien.Enabled = false; }
private void btDoiSan_Click(object sender, EventArgs e) { PhieuDatSanBong phieuDatSanBong = PhieuDatSanBongBUS.getLatestPhieuDatSanBong(sanBong.id); SanBong sanBongDoi = (SanBong)sanBongList[lvSanBong.SelectedIndices[0]]; phieuDatSanBong.idSanBong = sanBongDoi.id; if (!PhieuDatSanBongBUS.updatePhieuDatSanBong(phieuDatSanBong)) { MessageBox.Show("That Bai"); } this.Close(); }
private void btHuySan_Click(object sender, EventArgs e) { SanBong sanBong = (SanBong)sanBongList[lvSanBong.SelectedIndices[0]]; PhieuDatSanBong phieuDatSanBong = PhieuDatSanBongBUS.getLatestPhieuDatSanBong(sanBong.id); if (HoaDonBUS.deleteHoaDon(phieuDatSanBong.idHoaDon)) { statusBarAddText("Hủy sân thành công"); updateListViewSan(); } else { MessageBox.Show("Không thể hủy sân!" + lvSanBong.SelectedItems[0].Text, "Lỗi khi hủy sân", MessageBoxButtons.OK, MessageBoxIcon.Error); statusBarAddText("Lỗi khi hủy sân!"); } }
public static ArrayList getAllSan() { ArrayList dataList = new ArrayList(); try { DataSet dataSet = SanBongDAO.getAllSan(); ArrayList phieuDatSanBongList; DateTime thoiGianBatDau, thoiGianKetThuc; int soSanhKetThuc, soSanhBatDau; DateTime now = DateTime.Now; bool dangThue; foreach (DataRow row in dataSet.Tables[0].Rows) { String tenSan = row["tenSan"].ToString(); int idSan = Convert.ToInt32(row["id"]); double donGia = Convert.ToInt32(row["donGia"]); dangThue = false; phieuDatSanBongList = PhieuDatSanBongBUS.getAllPhieuDatSanBong(idSan); foreach (PhieuDatSanBong phieuDatSan in phieuDatSanBongList) { thoiGianBatDau = phieuDatSan.thoiGianBatDau; thoiGianKetThuc = thoiGianBatDau.AddHours((double)phieuDatSan.soGioDat); soSanhKetThuc = DateTime.Compare(thoiGianKetThuc, now); soSanhBatDau = DateTime.Compare(thoiGianBatDau, now); if (soSanhBatDau < 0 && soSanhKetThuc > 0) { dangThue = true; break; } } SanBong sanBong = new SanBong(idSan, tenSan, dangThue, donGia); dataList.Insert(0, sanBong); } } catch (SqlException e) { } return(dataList); }
private void btDatSan_Click(object sender, EventArgs e) { HoaDonBUS.addHoaDon(new HoaDon(0, DateTime.Now, tbTenKhachHang.Text, false)); HoaDon hoaDon = HoaDonBUS.getLastHoaDon(); SanBong sanBong = (SanBong)sanBongList[lvSanBong.SelectedIndices[0]]; PhieuDatSanBongBUS.addPhieuDatSanBong(new PhieuDatSanBong(0, sanBong.id, dtpGioVao.Value, (int)nudSoGio.Value, (double)nudDonGia.Value, hoaDon.id)); updateListViewSan(); if (lvChiTietHoaDon.Items.Count > 0) { foreach (MatHang matHang in matHangChoList) { ChiTietHoaDonBUS.addChiTietHoaDon(new ChiTietHoaDon(0, hoaDon.id, matHang.id, matHang.soLuong, matHang.donGia)); } } btDatSan.Enabled = false; }
public async Task <SanBong> Create(SanBongForCreateDto sanBong) { var newSanBong = new SanBong { MaSanBong = GenerateId(), TenSanBong = sanBong.TenSanBong, ChieuDai = sanBong.ChieuDai, ChieuRong = sanBong.ChieuRong, GhiChu = sanBong.GhiChu, ThoiGianTao = DateTime.Now, ThoiGianCapNhat = DateTime.Now, TrangThai = 1 }; newSanBong.DienTich = sanBong.ChieuDai * sanBong.ChieuRong; await _context.DanhSachSanBong.AddAsync(newSanBong); await _context.SaveChangesAsync(); return(newSanBong); }
public async Task <SanBong> UpdateById(string id, SanBongForUpdateDto sanBong) { var oldRecord = await _context.DanhSachSanBong.AsNoTracking().FirstOrDefaultAsync(x => x.MaSanBong == id); var sanBongToUpdate = new SanBong { MaSanBong = id, TenSanBong = sanBong.TenSanBong, ChieuDai = sanBong.ChieuDai, ChieuRong = sanBong.ChieuRong, GhiChu = sanBong.GhiChu, ThoiGianTao = oldRecord.ThoiGianTao, ThoiGianCapNhat = DateTime.Now, TrangThai = sanBong.TrangThai }; sanBongToUpdate.DienTich = sanBong.ChieuDai * sanBong.ChieuRong; _context.DanhSachSanBong.Update(sanBongToUpdate); await _context.SaveChangesAsync(); return(sanBongToUpdate); }
public async Task <Object> GetGeneralStatistics(PhieuDatSanGeneralStatisticsParams userParams) { var result = _context.DanhSachPhieuDatSan.AsQueryable(); var totalPhieuDatSan = 0; KhachHang DatSanNhieuNhat = new KhachHang(); NhanVien TiepNhanDatSanNhieuNhat = new NhanVien(); SanBong DuocDatNhieuNhat = new SanBong(); ICollection <KhachHang> danhSachKhachHang = await _context.DanhSachKhachHang.OrderBy(x => x.ThoiGianTao).ToListAsync(); ICollection <NhanVien> danhSachNhanVien = await _context.DanhSachNhanVien.OrderBy(x => x.ThoiGianTao).ToListAsync(); ICollection <SanBong> danhSachSanBong = await _context.DanhSachSanBong.OrderBy(x => x.ThoiGianTao).ToListAsync(); var demKhachHang = new List <int>(); var demNhanVien = new List <int>(); var demSanBong = new List <int>(); if (userParams != null && userParams.StartingTime.GetHashCode() != 0 && userParams.EndingTime.GetHashCode() != 0) { totalPhieuDatSan = result.Where(x => x.ThoiGianTao >= userParams.StartingTime && x.ThoiGianTao <= userParams.EndingTime).Count(); var danhSachPhieuDatSan = result.Where(x => x.ThoiGianTao >= userParams.StartingTime && x.ThoiGianTao <= userParams.EndingTime); //khách hàng foreach (var khachHang in danhSachKhachHang) { var demKH = 0; foreach (var phieuDatSan in danhSachPhieuDatSan) { if (phieuDatSan.MaKhachHang == khachHang.MaKhachHang) { demKH = demKH + 1; } } demKhachHang.Add(demKH); } int max = demKhachHang.Max(); var index = demKhachHang.IndexOf(max); DatSanNhieuNhat = danhSachKhachHang.ElementAt(index); //Nhân viên foreach (var nhanVien in danhSachNhanVien) { var demNV = 0; foreach (var phieuDatSan in danhSachPhieuDatSan) { if (phieuDatSan.MaNhanVien == nhanVien.MaNhanVien) { demNV = demNV + 1; } } demNhanVien.Add(demNV); } int maxNV = demNhanVien.Max(); var indexNV = demKhachHang.IndexOf(maxNV); TiepNhanDatSanNhieuNhat = danhSachNhanVien.ElementAt(indexNV); var danhSachChiTietPDS = _context.DanhSachChiTietPhieuDatSan.Where(x => x.ThoiGianTao >= userParams.StartingTime && x.ThoiGianTao <= userParams.EndingTime); foreach (var sanBong in danhSachSanBong) { var demSB = 0; foreach (var chiTietPhieuDatSan in danhSachChiTietPDS) { if (chiTietPhieuDatSan.MaSanBong == sanBong.MaSanBong) { demSB = demSB + 1; } } demSanBong.Add(demSB); } int maxSB = demSanBong.Max(); var indexSB = demSanBong.IndexOf(maxSB); DuocDatNhieuNhat = danhSachSanBong.ElementAt(indexSB); } else { totalPhieuDatSan = result.Count(); var danhSachPhieuDatSan = result.OrderBy(x => x.ThoiGianTao); var danhSachChiTietPDS = _context.DanhSachChiTietPhieuDatSan.OrderBy(x => x.ThoiGianTao); foreach (var khachHang in danhSachKhachHang) { var demKH = 0; foreach (var phieuDatSan in danhSachPhieuDatSan) { if (phieuDatSan.MaKhachHang == khachHang.MaKhachHang) { demKH = demKH + 1; } } demKhachHang.Add(demKH); } int max = demKhachHang.Max(); var index = demKhachHang.IndexOf(max); DatSanNhieuNhat = danhSachKhachHang.ElementAt(index); foreach (var nhanVien in danhSachNhanVien) { var demNV = 0; foreach (var phieuDatSan in danhSachPhieuDatSan) { if (phieuDatSan.MaNhanVien == nhanVien.MaNhanVien) { demNV = demNV + 1; } } demNhanVien.Add(demNV); } int maxNV = demNhanVien.Max(); var indexNV = demNhanVien.IndexOf(maxNV); TiepNhanDatSanNhieuNhat = danhSachNhanVien.ElementAt(indexNV); foreach (var sanBong in danhSachSanBong) { var demSB = 0; foreach (var chiTietPhieuDatSan in danhSachChiTietPDS) { if (chiTietPhieuDatSan.MaSanBong == sanBong.MaSanBong) { demSB = demSB + 1; } } demSanBong.Add(demSB); } int maxSB = demSanBong.Max(); var indexSB = demSanBong.IndexOf(maxSB); DuocDatNhieuNhat = danhSachSanBong.ElementAt(indexSB); } return(new { totalPhieuDatSan, DatSanNhieuNhat, TiepNhanDatSanNhieuNhat, DuocDatNhieuNhat }); }
private void lvSanBong_SelectedIndexChanged(object sender, EventArgs e) { if (lvSanBong.SelectedItems.Count > 0) { tbTenSan.Text = (lvSanBong.SelectedItems[0]).Text; nudDonGia.Value = (decimal)((SanBong)sanBongList[lvSanBong.SelectedIndices[0]]).donGia; btSuaSan.Enabled = true; btXoaSan.Enabled = true; tabTinhTien.Enabled = true; SanBong sanBong = ((SanBong)sanBongList[lvSanBong.SelectedIndices[0]]); if (sanBong.dangThue) { PhieuDatSanBong phieuDatSanBong = PhieuDatSanBongBUS.getLatestPhieuDatSanBong(sanBong.id); tbTenKhachHang.Text = HoaDonBUS.getHoaDon(phieuDatSanBong.idHoaDon).tenKhachHang; dtpGioVao.Value = phieuDatSanBong.thoiGianBatDau; nudSoGio.Value = phieuDatSanBong.soGioDat; dtpGioRa.Value = phieuDatSanBong.thoiGianBatDau.AddHours((double)phieuDatSanBong.soGioDat); btDatSan.Enabled = false; loadLvChiTietHoaDon(phieuDatSanBong.idHoaDon); btDoiSan.Enabled = true; btCapNhat.Enabled = true; btHuySan.Enabled = true; HoaDon hoaDon = HoaDonBUS.getHoaDon(phieuDatSanBong.idHoaDon); if (hoaDon.daThanhToan) { btThuTien.Enabled = false; btDoiSan.Enabled = false; btCapNhat.Enabled = false; gbMatHangTinhTien.Enabled = false; lbThanhToan.Text = "ĐÃ THANH TOÁN"; } else { btThuTien.Enabled = true; lbThanhToan.Text = "CHƯA THANH TOÁN"; btDoiSan.Enabled = true; btCapNhat.Enabled = true; gbMatHangTinhTien.Enabled = true; } } else { btDatSan.Enabled = true; matHangChoList.Clear(); btDoiSan.Enabled = false; btCapNhat.Enabled = false; btHuySan.Enabled = false; btThuTien.Enabled = false; gbMatHangTinhTien.Enabled = true; } tbTenSanTT.Text = sanBong.tenSan; } else { tbTenSan.Text = ""; btSuaSan.Enabled = false; btXoaSan.Enabled = false; tabTinhTien.Enabled = false; tbTenSanTT.Text = ""; tbTenKhachHang.Text = ""; nudSoGio.Value = 0; dtpGioVao.Value = DateTime.Now; dtpGioRa.Value = DateTime.Now; tbTienSan.Text = ""; tbTienHang.Text = ""; nudGiamGia.Value = 0; nudTienKhac.Value = 0; lvChiTietHoaDon.Items.Clear(); nudDonGia.Value = 0; btDoiSan.Enabled = false; lbThanhToan.Text = "CHƯA THANH TOÁN"; } loadTinhTien(); }
public FDoiSan(SanBong sanBong) { InitializeComponent(); this.sanBong = sanBong; }