private void btnback_Click(object sender, EventArgs e)
{
foreach (DataGridViewRow row in dgvphitrehanthanhtoan.SelectedRows)
{
ePhieuThueTra phieu = new ePhieuThueTra();
phieu.id_PhieuThue = Convert.ToInt32(row.Cells[0].Value.ToString());
phieu.id_DVD = Convert.ToInt32(row.Cells[1].Value.ToString());
phieu.ngayThue = Convert.ToDateTime(row.Cells[2].Value.ToString());
phieu.ngayTra = Convert.ToDateTime(row.Cells[3].Value.ToString());
phieu.phiTreHan = PHI_TRE_HEN;
double phi = Convert.ToDouble(phieu.phiTreHan) * Convert.ToDouble(tlbus.GetTheLoaiByID(
tieuDeBUL.Find(dVDBUL.FindDVDById(phieu.id_DVD).id_TieuDe).id_TheLoai).giaThue);
phiTreHen -= phi;
tongPhi = phiTreHen + phiThue;
foreach (ePhieuThueTra item in listPhieuPhiTreHenSau)
{
if (phieu.id_PhieuThue == item.id_PhieuThue)
{
listPhieuPhiTreHenSau.Remove(item);
break;
}
}
listPhieuPhiTreHenTruoc.Add(phieu);
dgvphitrehanthanhtoan.Rows.Remove(row);
}
dgvallphitrehan.DataSource = ConvertListToDataTableTreHan(listPhieuPhiTreHenTruoc);
FormatGridViewTrehan(dgvallphitrehan);
txtPhiTre.Text = phiTreHen.ToString();
txtTong.Text = tongPhi.ToString();
}
private void btn_tkID_Click(object sender, EventArgs e)
{
if (txt_IDDia.Text.ToString().Trim().Equals(""))
{
MessageBox.Show("Nhập Id DVD");
txt_IDDia.Focus();
return;
}
int id_dvd = Convert.ToInt32(txt_IDDia.Text.ToString().Trim());
ePhieuThueTra phieu = phieuTTBul.getPhieuThueTraByIdDVD(id_dvd);
if (phieu != null)
{
eKhachHang kh = khBul.GetKhachHangByID(phieu.id_KhachHang);
txt_idkh.Text = kh.id_KhachHang.ToString();
txt_sdt.Text = kh.soDT;
txt_tenkh.Text = kh.tenKhachHang;
txt_tendia.Text = tieuDeBUL.GetTieuDeByID(dvdBul.FindDVDById(id_dvd).id_TieuDe).tenTieuDe;
table.Rows.Add(phieu.id_PhieuThue, phieu.id_DVD, phieu.ngayThue, kh.id_KhachHang, kh.tenKhachHang);
LoadData();
}
else
{
MessageBox.Show("Không tìm thấy kết quả");
}
}
private void btnnext_Click(object sender, EventArgs e)
{
foreach (DataGridViewRow row in dgvallphitrehan.SelectedRows)
{
ePhieuThueTra phieu = new ePhieuThueTra();
phieu.id_PhieuThue = Convert.ToInt32(row.Cells[0].Value.ToString());
phieu.id_DVD = Convert.ToInt32(row.Cells[1].Value.ToString());
phieu.ngayThue = Convert.ToDateTime(row.Cells[2].Value.ToString());
phieu.ngayTra = Convert.ToDateTime(row.Cells[3].Value.ToString());
double phi = Convert.ToDouble(row.Cells[4].Value.ToString());
phieu.phiTreHan = phi;
foreach (ePhieuThueTra item in listPhieuPhiTreHenTruoc)
{
if (phieu.id_PhieuThue == item.id_PhieuThue)
{
listPhieuPhiTreHenTruoc.Remove(item);
break;
}
}
phiTreHen += phi;
tongPhi = phiTreHen + phiThue;
listPhieuPhiTreHenSau.Add(phieu);
dgvallphitrehan.Rows.Remove(row);
}
dgvphitrehanthanhtoan.DataSource = ConvertListToDataTableTreHan(listPhieuPhiTreHenSau);
FormatGridViewTrehan(dgvphitrehanthanhtoan);
txtPhiTre.Text = phiTreHen.ToString();
txtTong.Text = tongPhi.ToString();
}
private void btnCheck_Click(object sender, EventArgs e)
{
if (!txtIDdia.Text.ToString().Trim().Equals(""))
{
eDVD dvd = dVDBUL.FindDVDById(Convert.ToInt32(txtIDdia.Text.ToString()));
if (dvd != null)
{
this.Size = new Size(319, 137);
lblTieuDe1.Visible = true;
lblTrangThai1.Visible = true;
lblTieuDe.Visible = true;
lblTrangThai.Visible = true;
lblTieuDe.Text = tieuDeBUL.Find(dvd.id_TieuDe).tenTieuDe;
if (dvd.trangThai == -1)
{
lblTrangThai.Text = "Trên kệ";
}
else if (dvd.trangThai == 0)
{
this.Size = new Size(319, 223);
grCho.Visible = true;
grThue.Visible = false;
lblTrangThai.Text = "Đang giữ";
ePhieuDatTruoc phieu = phieuDatTruocBUL.GetPhieuDatTruocByID(dvd.id_DVD);
lblNguoiDatTrc.Text = khachHangBUL.Find(phieu.id_KhachHang).tenKhachHang;
lblNgayLay.Text = phieu.ngayDatTruoc.ToShortDateString();
}
else
{
this.Size = new Size(319, 223);
grThue.Visible = true;
grCho.Visible = false;
lblTrangThai.Text = "Đang thuê";
ePhieuThueTra phieu = phieuThueTraBUL.getPhieuThueTraByIdDVD(dvd.id_DVD);
if (phieu != null)
{
lblNguoiThue.Text = khachHangBUL.Find(phieu.id_KhachHang).tenKhachHang;
int tgianThue = theLoaiBUL.GetTheLoaiByID(tieuDeBUL.Find(dvd.id_TieuDe).id_TheLoai).thoiGianThue;
DateTime ngayTraDuKien = phieu.ngayThue.AddDays(tgianThue);
lblDenHan.Text = ngayTraDuKien.ToShortDateString();
}
}
}
else
{
this.Size = new Size(319, 79);
grThue.Visible = false;
grCho.Visible = false;
lblTieuDe1.Visible = false;
lblTrangThai1.Visible = false;
lblTieuDe.Visible = false;
lblTrangThai.Visible = false;
MessageBox.Show("Không tồn tại DVD");
return;
}
}
}
public ePhieuThueTra getPhieuThueTraByIdDVD(int id_dvd)
{
PhieuThueTra phieu = phieuThuTraDal.getPhieuThueTraByIdDVD(id_dvd);
if (phieu != null)
{
ePhieuThueTra item = new ePhieuThueTra();
item.id_KhachHang = phieu.id_KhachHang;
item.id_DVD = phieu.id_DVD;
item.id_PhieuThue = phieu.id_PhieuThue;
item.ngayThue = phieu.ngayThue;
item.ngayTra = phieu.ngayTra;
return(item);
}
return(null);
}
public List <ePhieuThueTra> getPhieuThueTraByKH(int id_KH)
{
List <ePhieuThueTra> list = new List <ePhieuThueTra>();
foreach (var phieu in phieuThuTraDal.getPhieuThueTraByKH(id_KH))
{
ePhieuThueTra item = new ePhieuThueTra();
item.id_KhachHang = phieu.id_KhachHang;
item.id_DVD = phieu.id_DVD;
item.id_PhieuThue = phieu.id_PhieuThue;
item.ngayThue = phieu.ngayThue;
item.ngayTra = phieu.ngayTra;
list.Add(item);
}
return(list);
}
public List <ePhieuThueTra> getListPhiTreHen(int id_KH)
{
List <ePhieuThueTra> list = new List <ePhieuThueTra>();
foreach (PhieuThueTra item in phiTreHen.getListPhiTreHen(id_KH))
{
ePhieuThueTra phieu = new ePhieuThueTra();
phieu.id_DVD = item.id_DVD;
phieu.id_KhachHang = item.id_KhachHang;
phieu.ngayThue = item.ngayThue;
phieu.id_PhieuThue = item.id_PhieuThue;
phieu.ngayTra = item.ngayTra;
list.Add(phieu);
}
return(list);
}
