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;
}
}
}
//insert
public void insertPhieuDatTruoc(ePhieuDatTruoc item)
{
data = new DvdRentDbDataContext();
data.PhieuDatTruocs.InsertOnSubmit(new PhieuDatTruoc()
{
IdKhachHang = item.IdKhach,
NgayTao = item.NgayTao
});
data.SubmitChanges();
}
public void Save(ePhieuDatTruoc p)
{
PhieuDatTruoc pdt = new PhieuDatTruoc();
pdt.id_DVD = p.id_DVD;
pdt.id_TieuDe = p.id_TieuDe;
pdt.id_PhieuDatTruoc = p.id_PhieuDatTruoc;
pdt.id_KhachHang = p.id_KhachHang;
pdt.ngayDatTruoc = p.ngayDatTruoc;
pdtdal.Save(pdt);
}
public ePhieuDatTruoc FindbyID(int id)
{
PhieuDatTruoc p = tddal.FindbyID(id);
ePhieuDatTruoc tam = new ePhieuDatTruoc();
tam.id_DVD = p.id_DVD;
tam.id_TieuDe = p.id_TieuDe;
tam.id_PhieuDatTruoc = p.id_PhieuDatTruoc;
tam.id_KhachHang = p.id_KhachHang;
tam.ngayDatTruoc = p.ngayDatTruoc;
return(tam);
}
public ePhieuDatTruoc GetPhieuDatTruocByID(int id_dvd)
{
PhieuDatTruoc phieu = pdtdal.GetPhieuDatTruocByID(id_dvd);
ePhieuDatTruoc tam = new ePhieuDatTruoc();
tam.id_DVD = phieu.id_DVD;
tam.id_TieuDe = phieu.id_TieuDe;
tam.id_PhieuDatTruoc = phieu.id_PhieuDatTruoc;
tam.id_KhachHang = phieu.id_KhachHang;
tam.ngayDatTruoc = phieu.ngayDatTruoc;
tam.trangThai = phieu.trangThai;
return(tam);
}
public List <ePhieuDatTruoc> GetPhieuDatTruocsByDvdNull()
{
List <ePhieuDatTruoc> list = new List <ePhieuDatTruoc>();
foreach (var item in pdtdal.getPhieuDatTruocs())
{
ePhieuDatTruoc tam = new ePhieuDatTruoc();
tam.id_TieuDe = item.id_TieuDe;
tam.id_PhieuDatTruoc = item.id_PhieuDatTruoc;
tam.id_KhachHang = item.id_KhachHang;
tam.ngayDatTruoc = item.ngayDatTruoc;
list.Add(tam);
}
return(list);
}
public List <ePhieuDatTruoc> FindPhieuDatTruocByidTieuDe(int id)
{
List <PhieuDatTruoc> lst = tddal.FindPhieuDatTruocByidTieuDe(id);
List <ePhieuDatTruoc> lit = new List <ePhieuDatTruoc>();
foreach (var item in lst)
{
ePhieuDatTruoc e = new ePhieuDatTruoc();
e.id_DVD = item.id_DVD;
e.id_TieuDe = item.id_TieuDe;
e.id_PhieuDatTruoc = item.id_PhieuDatTruoc;
e.id_KhachHang = item.id_KhachHang;
e.ngayDatTruoc = item.ngayDatTruoc;
lit.Add(e);
}
return(lit);
}
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)
{
eKhachHang ekh = new eKhachHang();
ekh.tenKhachHang = txt_tenkh.Text;
ekh.soDT = txt_sdt.Text;
ekh.soCMND = txtsocm.Text;
khachHangBUL.Save(ekh);
List <eKhachHang> lst = khachHangBUL.getKhachHangs();
eKhachHang khh = lst.FirstOrDefault(st => st.id_KhachHang.Equals(ekh.id_KhachHang));
if (khh != null)
{
pdt.id_TieuDe = s;
pdt.ngayDatTruoc = DateTime.Today;
pdt.id_KhachHang = khh.id_KhachHang;
pdt.trangThai = 0;
phieuDatTruocBUL.Save(pdt);
MessageBox.Show("Đặt trước thành công");
}
}
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");
}
dgv_dstieude.DataSource = tieuDeBUL.getTieuDes();
}
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();
}
