private void btnThem_Click(object sender, EventArgs e)
{
string user = Properties.Settings.Default.useName;
string pass = Properties.Settings.Default.passWord;
if (user.Equals("Empty") && pass.Equals("Empty"))
{
Login frm = new Login();
frm.ShowDialog();
}
else
{
if (txtSL.Text != "")
{
List <eTieuDe> list = new List <eTieuDe>();
list = tdbul.getTieuDes();
eTieuDe etd = new eTieuDe();
etd = list.FirstOrDefault(a => a.tenTieuDe == cbbTieuDe.Text);
eDVD dVD = new eDVD();
dVD.id_TieuDe = etd.id_TieuDe;
dVD.trangThai = -1; //onshelf
for (int i = 0; i < Convert.ToInt32(txtSL.Text.Trim()); i++)
{
dvdbul.Save(dVD);
}
MessageBox.Show("Thêm thành công");
}
else
{
MessageBox.Show("Vui lòng nhập số lượng");
}
}
}
private void btnDelete_Click(object sender, EventArgs e)
{
foreach (DataGridViewRow row in dsDiaThue.SelectedRows)
{
if (!row.Cells[0].Value.ToString().Equals(""))
{
int iddia = Convert.ToInt32(row.Cells[0].Value.ToString());
int id_tieude = Convert.ToInt32(row.Cells[1].Value.ToString());
eDVD dvd = new eDVD();
dvd.id_DVD = iddia;
dvd.id_TieuDe = id_tieude;
dvd.trangThai = -1;
dsDiaThue.Rows.Remove(row);
phiThue -= Convert.ToInt32(tlbus.GetTheLoaiByID(tieuDeBUL.Find(id_tieude).id_TheLoai).giaThue);
tongPhi = phiThue + phiTreHen;
listDsDVD.Add(dvd);
foreach (eDVD item in listThue)
{
if (iddia == item.id_DVD)
{
listThue.Remove(item);
break;
}
}
}
}
LoadData(dgvDSDia, listDsDVD);
txtPhiThue.Text = phiThue.ToString();
txtTong.Text = tongPhi.ToString();
}
private void btn_tkDia_Click(object sender, EventArgs e)
{
if (!txt_IDDia.Text.Trim().Equals(""))
{
listDsDVD.Clear();
List <eDVD> list = new List <eDVD>();
eDVD dvd = dVDBUL.FindDVDById(Convert.ToInt32(txt_IDDia.Text.Trim()));
if (dvd != null)
{
list.Add(dvd);
LoadData(dgvDSDia, list);
}
listDsDVD = list;
}
if (!txt_tendia.Text.Trim().Equals(""))
{
listDsDVD.Clear();
List <eDVD> listDVD = new List <eDVD>();
List <eTieuDe> list = tieuDeBUL.getTieuDeByTen(txt_tendia.Text.Trim());
foreach (eTieuDe item in list)
{
listDVD = dVDBUL.getDVDsByTieuDe(item.id_TieuDe);
}
LoadData(dgvDSDia, listDVD);
listDsDVD = listDVD;
}
}
private void btn_thue_Click(object sender, EventArgs e)
{
// add dvd to grid view
foreach (DataGridViewRow row in dgvDSDia.SelectedRows)
{
if (!row.Cells[0].Value.ToString().Equals(""))
{
int iddia = Convert.ToInt32(row.Cells[0].Value.ToString());
int id_tieude = Convert.ToInt32(row.Cells[1].Value.ToString());
eDVD dvd = new eDVD();
dvd.id_DVD = iddia;
dvd.id_TieuDe = id_tieude;
dvd.trangThai = -1;
dgvDSDia.Rows.Remove(row);
foreach (eDVD item in listDsDVD)
{
if (iddia == item.id_DVD)
{
listDsDVD.Remove(item);
break;
}
}
phiThue += Convert.ToInt32(tlbus.GetTheLoaiByID(tieuDeBUL.Find(id_tieude).id_TheLoai).giaThue);
tongPhi = phiThue + phiTreHen;
listThue.Add(dvd);
}
}
dsDiaThue.DataSource = ConvertListToDataTable(listThue);
FormatGridViewDiaThue(dsDiaThue);
txtPhiThue.Text = phiThue.ToString();
txtTong.Text = tongPhi.ToString();
}
private void btn_timkiem_Click(object sender, EventArgs e)
{
Clearr();
if (nhapid.Text != "")
{
int id = Convert.ToInt32(nhapid.Text);
eDVD dvd = dVDBUL.FindDVDById(id);
if (dvd != null)
{
eTieuDe tieuDe = tieuDe = tieuDeBUL.Find(dvd.id_TieuDe);
eTheLoai theLoai = tieuDeBUL.FindTheLoaiById(tieuDe.id_TieuDe);
txt_tendia.Text = tieuDe.tenTieuDe;
txtgiathue.Text = theLoai.giaThue.ToString();
txttgthue.Text = theLoai.thoiGianThue.ToString();
txt_iddia.Text = dvd.id_DVD.ToString();
txt_tragthai.Text = dvd.trangThai.ToString();
btn_timkiem.Text = " Tìm kiếm";
}
else
{
MessageBox.Show("Không có đĩa trong danh sách");
}
}
else
{
MessageBox.Show("Nhap ma can tim");
}
}
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 void Save(eDVD d)
{
DVD item = new DVD();
item.id_DVD = d.id_DVD;
item.trangThai = d.trangThai;
item.id_TieuDe = d.id_TieuDe;
dvddal.Save(item);
}
private void cb_listkh_SelectedIndexChanged(object sender, EventArgs e)
{
if (cb_listkh.SelectedIndex == 1)
{
List <eKhachHang> lskh = khbul.getKhachHangs();
List <eKhachHang> lskh1 = new List <eKhachHang>();
foreach (var item in lskh)
{
List <ePhieuThueTra> lsp = phieu.getPhieuThueTraByKHBaoCao(item.id_KhachHang);
foreach (var item1 in lsp)
{
eDVD dvd1 = dvd.FindDVDById(item1.id_DVD);
eTieuDe t = td.GetTieuDeByID(dvd1.id_TieuDe);
eTheLoai theloai = tl.GetTheLoaiByID(t.id_TheLoai);
DateTime dt = (DateTime)item1.ngayThue;
DateTime today = DateTime.Now;
if (item1.ngayTra == null && DateTime.Compare(today, dt.AddDays(theloai.thoiGianThue)) == 1)
{
lskh1.Add(item);
break;
}
}
}
dgv_dskh.DataSource = lskh1;
FormatLaiDataGridviewkh(dgv_dskh);
}
else if (cb_listkh.SelectedIndex == 0)
{
List <eKhachHang> ls = khbul.getKhachHangs();
dgv_dskh.DataSource = ls;
FormatLaiDataGridviewkh(dgv_dskh);
}
else
{
List <eKhachHang> lskh = khbul.getKhachHangs();
List <eKhachHang> lskh1 = new List <eKhachHang>();
foreach (var item in lskh)
{
List <ePhieuThueTra> lsp = phieu.getPhieuThueTraByKHBaoCao(item.id_KhachHang);
foreach (var item1 in lsp)
{
if (item1.ngayTraPhiTreHen == null)
{
lskh1.Add(item);
break;
}
}
}
dgv_dskh.DataSource = lskh1;
FormatLaiDataGridviewkh(dgv_dskh);
}
}
public List <eDVD> getDVDsByTieuDe(int tieude)
{
List <eDVD> list = new List <eDVD>();
foreach (var item in dvddal.getDVDsByTieuDe(tieude))
{
eDVD tam = new eDVD();
tam.id_DVD = item.id_DVD;
tam.trangThai = item.trangThai;
tam.id_TieuDe = item.id_TieuDe;
list.Add(tam);
}
return(list);
}
public eDVD getDVDOnShelf(int id_tieude)
{
DVD item = dvddal.getDVDOnShelf(id_tieude);
if (item != null)
{
eDVD tam = new eDVD();
tam.id_DVD = item.id_DVD;
tam.trangThai = item.trangThai;
tam.id_TieuDe = item.id_TieuDe;
return(tam);
}
return(null);
}
public eDVD FindDVDById(int id)
{
DVD t = dvddal.Find(id);
if (t != null)
{
eDVD e = new eDVD();
e.id_DVD = t.id_DVD;
e.trangThai = t.trangThai;
e.id_TieuDe = t.id_TieuDe;
return(e);
}
return(null);
}
public eDVD Updatee(int id)
{
DVD dv = dvddal.Find(id);
if (dv != null)
{
dv = dvddal.Update(id);
eDVD t = new eDVD();
t.id_DVD = dv.id_DVD;
t.trangThai = dv.trangThai;
t.id_TieuDe = dv.id_TieuDe;
return(t);
}
return(null);
}
private void btn_tradia_Click(object sender, EventArgs e)
{
DateTime now = DateTime.Now;
listKH = new List <eKhachHang>();
listDVD = new List <eDVD>();
int count = 0;
foreach (DataGridViewRow row in dgvDsTra.Rows)
{
int id_phieu = Convert.ToInt32(row.Cells[0].Value.ToString());
DateTime ngayThue = Convert.ToDateTime(row.Cells[2].Value.ToString());
int id_dvd = Convert.ToInt32(row.Cells[1].Value.ToString());
double time = theLoaiBUL.GetTheLoaiByID(tieuDeBUL.GetTieuDeByID(dvdBul.FindDVDById(id_dvd).id_TieuDe).id_TheLoai).thoiGianThue;
eDVD dvd = dvdBul.FindDVDById(id_dvd);
if (!listDVD.Contains(dvd))
{
listDVD.Add(dvd);
}
eKhachHang kh = khBul.Find(Convert.ToInt32(row.Cells[3].Value.ToString()));
if (!listKH.Contains(kh))
{
listKH.Add(kh);
}
if ((now - ngayThue).TotalDays > time)
{
count = phieuTTBul.UpdatePhieuThue_Tre(id_phieu, now, PHI_TRE_HEN);
}
else
{
count = phieuTTBul.UpdatePhieuThue(id_phieu, now, now, 0);
}
dvdBul.UpdateTrangThaiDVD(id_dvd, -1);
}
if (count == 1)
{
MessageBox.Show("Trả đĩa thành công");
table.Clear();
LoadData();
}
CheckPhiTreHen();
UpdateDVDDatTruoc();
}
private void btn_dat_Click(object sender, EventArgs e)
{
DataGridViewRow row = this.dgv_dstieude.Rows[vitri];
//Ma tieu de
int s = Convert.ToInt32(row.Cells[0].Value.ToString());
ePhieuDatTruoc pdt = new ePhieuDatTruoc();
int id = Convert.ToInt32(txt_idkh.Text);
eKhachHang kh = khachHangBUL.Find(id);
if (kh != null)
{
eDVD dvd = dVDBUL.getDVDOnShelf(s);
if (dvd != null)
{
pdt.id_DVD = dvd.id_DVD;
pdt.id_TieuDe = s;
pdt.ngayDatTruoc = DateTime.Today;
pdt.id_KhachHang = kh.id_KhachHang;
pdt.trangThai = 0;
phieuDatTruocBUL.Save(pdt);
MessageBox.Show("Đặt trước thành công");
dVDBUL.UpdateTrangThaiDVD(dvd.id_DVD, 0);
}
else
{
pdt.id_TieuDe = s;
pdt.ngayDatTruoc = DateTime.Today;
pdt.id_KhachHang = kh.id_KhachHang;
pdt.trangThai = 0;
phieuDatTruocBUL.Save(pdt);
MessageBox.Show("Đặt trước thành công");
}
}
else
{
MessageBox.Show("Không tìm thấy khách hàng");
return;
}
dgv_dstieude.DataSource = tieuDeBUL.getTieuDes();
}
private void btnThem_Click(object sender, EventArgs e)
{
if (txtSL.Text != "")
{
List <eTieuDe> list = new List <eTieuDe>();
list = tdbul.getTieuDes();
eTieuDe etd = new eTieuDe();
etd = list.FirstOrDefault(a => a.tenTieuDe == cbbTieuDe.Text);
eDVD dVD = new eDVD();
dVD.id_TieuDe = etd.id_TieuDe;
dVD.trangThai = 1;
dvdbul.Save(dVD);
MessageBox.Show("Them Thanh Cong");
}
else
{
MessageBox.Show("Vui long nhap so luong");
}
}
private void btnThem_Click(object sender, EventArgs e)
{
if (txtSL.Text != "")
{
List <eTieuDe> list = new List <eTieuDe>();
list = tdbul.getTieuDes();
eTieuDe etd = new eTieuDe();
etd = list.FirstOrDefault(a => a.tenTieuDe == cbbTieuDe.Text);
eDVD dVD = new eDVD();
dVD.id_TieuDe = etd.id_TieuDe;
dVD.trangThai = 0; //onshelf
for (int i = 0; i < Convert.ToInt32(txtSL.Text.Trim()); i++)
{
dvdbul.Save(dVD);
}
MessageBox.Show("Thêm thành công");
}
else
{
MessageBox.Show("Vui lòng nhập số lượng");
}
}