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