//get
public eKhachHang getKhachHang(int id)
{
data = new DvdRentDbDataContext();
KhachHang item = data.KhachHangs.Single(n => n.Id == id);
return(new eKhachHang(item.Id, item.Ten, item.DiaChi, item.Sdt, (bool)item.TrangThai));
}
//get
public eNhanVien getNhanVien(int id)
{
data = new DvdRentDbDataContext();
NhanVien item = data.NhanViens.Single(n => n.Id == id);
return(new eNhanVien(item.Id, item.Password, item.Ten, item.DiaChi, item.Sdt));
}
public eChiTietPhieuMuon getChiTietPhieuMuon(int idPhieuMuon, int idDvd)
{
data = new DvdRentDbDataContext();
ChiTietPhieuMuon item = data.ChiTietPhieuMuons.Single(n => n.IdDVD == idDvd && n.IdPhieuMuon == idPhieuMuon);
return(new eChiTietPhieuMuon(item.IdPhieuMuon, item.IdDVD, item.PhiTre, (DateTime)item.NgayTra, (bool)item.TinhTrang));
}
public eDvd getDvd(int id)
{
data = new DvdRentDbDataContext();
DVD item = data.DVDs.Single(n => n.Id == id);
return(new eDvd(item.Id, item.IdTitle, item.TinhTrang, (bool)item.TrangThai));
}
//get
public ePhieuDatTruoc getPhieuDatTruocByKhachHangId(int id)
{
data = new DvdRentDbDataContext();
PhieuDatTruoc item = data.PhieuDatTruocs.Single(n => n.IdKhachHang == id);
return(new ePhieuDatTruoc(item.Id, item.IdKhachHang, DateTime.Parse(item.NgayTao.ToString())));
}
public ePhieuMuon getPhieuMuon(int id)
{
data = new DvdRentDbDataContext();
PhieuMuon item = data.PhieuMuons.Single(n => n.Id == id);
return(new ePhieuMuon(item.Id, item.IdKhachHang, DateTime.Parse(item.NgayTao.ToString())));
}
public void removeDvd(int id)
{
data = new DvdRentDbDataContext();
DVD item = data.DVDs.Single(n => n.Id == id);
item.TrangThai = false;
data.SubmitChanges();
}
//remove
public void removeKhachHang(int id)
{
data = new DvdRentDbDataContext();
KhachHang item = data.KhachHangs.Single(n => n.Id == id);
item.TrangThai = false;
data.SubmitChanges();
}
public void removeChiTietDatTruoc(int idDat, int idTitle)
{
data = new DvdRentDbDataContext();
ChiTietPhieuDatTruoc item = data.ChiTietPhieuDatTruocs.Single(n => n.IdPhieuDatTruoc == idDat && n.IdTitle == idTitle);
item.Huy = false;
data.SubmitChanges();
}
//insert
public void insertPhieuMuon(ePhieuMuon item)
{
data = new DvdRentDbDataContext();
data.PhieuMuons.InsertOnSubmit(new PhieuMuon()
{
IdKhachHang = item.IdKhach,
NgayTao = item.NgayTao
});
data.SubmitChanges();
}
public void updateChiTietPhieuDatTruoc(eChiTietPhieuDatTruoc newitem)
{
data = new DvdRentDbDataContext();
ChiTietPhieuDatTruoc item = data.ChiTietPhieuDatTruocs.Single(n => n.IdPhieuDatTruoc == newitem.IdPhieuDatTruoc && n.IdTitle == newitem.IdTitle);
item.IdPhieuDatTruoc = newitem.IdPhieuDatTruoc;
item.IdTitle = newitem.IdTitle;
item.TrangThai = newitem.TrangThai1;
item.Huy = newitem.Huy;
data.SubmitChanges();
}
public void insertDvd(eDvd item)
{
data = new DvdRentDbDataContext();
data.DVDs.InsertOnSubmit(new DVD()
{
IdTitle = item.IdTiltle,
TinhTrang = item.TinhTrang,
TrangThai = item.TrangThai1
});
data.SubmitChanges();
}
//getAll
public List <eNhanVien> getAllNhanVien()
{
data = new DvdRentDbDataContext();
List <eNhanVien> list = new List <eNhanVien>();
var temp = data.NhanViens;
foreach (var item in temp)
{
list.Add(new eNhanVien(item.Id, item.Password, item.Ten, item.DiaChi, item.Sdt));
}
return(list);
}
//update
public void updateKhachHang(eKhachHang newitem)
{
data = new DvdRentDbDataContext();
KhachHang item = data.KhachHangs.Single(n => n.Id == newitem.IdKhach);
item.Id = newitem.IdKhach;
item.Ten = newitem.TenKhach;
item.DiaChi = newitem.DiaChiKhach;
item.Sdt = newitem.SdtKhach;
item.TrangThai = newitem.TrangThai1;
data.SubmitChanges();
}
//getAll
public List <eKhachHang> getAllKhachHang()
{
data = new DvdRentDbDataContext();
List <eKhachHang> list = new List <eKhachHang>();
var temp = data.KhachHangs;
foreach (var item in temp)
{
list.Add(new eKhachHang(item.Id, item.Ten, item.DiaChi, item.Sdt, (bool)item.TrangThai));
}
return(list);
}
public void insertChiPhieuDatTruoc(eChiTietPhieuDatTruoc item)
{
data = new DvdRentDbDataContext();
data.ChiTietPhieuDatTruocs.InsertOnSubmit(new ChiTietPhieuDatTruoc()
{
IdPhieuDatTruoc = item.IdPhieuDatTruoc,
IdTitle = item.IdTitle,
TrangThai = item.TrangThai1,
Huy = item.Huy
});
data.SubmitChanges();
}
public List <eChiTietPhieuDatTruoc> getAllChiTietPhieuDatTruoc()
{
data = new DvdRentDbDataContext();
List <eChiTietPhieuDatTruoc> list = new List <eChiTietPhieuDatTruoc>();
var temp = data.ChiTietPhieuDatTruocs;
foreach (var item in temp)
{
list.Add(new eChiTietPhieuDatTruoc(item.IdPhieuDatTruoc, item.IdTitle, item.TrangThai, (bool)item.Huy));
}
return(list);
}
//update
public void updateChiTietPhieuMuon(eChiTietPhieuMuon newitem)
{
data = new DvdRentDbDataContext();
ChiTietPhieuMuon item = data.ChiTietPhieuMuons.Single(n => n.IdDVD == newitem.IdDvd && n.IdPhieuMuon == newitem.IdPhieuMuon);
item.IdPhieuMuon = newitem.IdPhieuMuon;
item.IdDVD = newitem.IdDvd;
item.PhiTre = newitem.PhiTre;
item.NgayTra = newitem.NgayTra;
item.TinhTrang = newitem.TinhTrang;
data.SubmitChanges();
}
//getAll
public List <ePhieuMuon> getAllPhieuMuon()
{
data = new DvdRentDbDataContext();
List <ePhieuMuon> list = new List <ePhieuMuon>();
var temp = data.PhieuMuons;
foreach (var item in temp)
{
list.Add(new ePhieuMuon(item.Id, item.IdKhachHang, DateTime.Parse(item.NgayTao.ToString())));
}
return(list);
}
//insert
public void insertKhachHang(eKhachHang item)
{
data = new DvdRentDbDataContext();
data.KhachHangs.InsertOnSubmit(new KhachHang()
{
Ten = item.TenKhach,
DiaChi = item.DiaChiKhach,
Sdt = item.SdtKhach,
TrangThai = item.TrangThai1
});
data.SubmitChanges();
}
public List <eTitle> getAllTitle()
{
data = new DvdRentDbDataContext();
List <eTitle> list = new List <eTitle>();
var itemlist = data.Titles;
foreach (var item in itemlist)
{
list.Add(new eTitle(item.Id, (int)item.PhiTre, (int)item.ThoiGianThue, (int)item.Gia, item.Ten, (bool)item.TheLoai, (bool)item.TrangThai));
}
return(list);
}
//getAll
public List <eChiTietPhieuMuon> getAllChiTietPhieuMuon()
{
data = new DvdRentDbDataContext();
List <eChiTietPhieuMuon> list = new List <eChiTietPhieuMuon>();
var temp = data.ChiTietPhieuMuons;
foreach (var item in temp)
{
list.Add(new eChiTietPhieuMuon(item.IdPhieuMuon, item.IdDVD, item.PhiTre, (DateTime)item.NgayTra, (bool)item.TinhTrang));
}
return(list);
}
public List <eDvd> getAllDvd()
{
data = new DvdRentDbDataContext();
List <eDvd> list = new List <eDvd>();
var itemlist = data.DVDs;
foreach (var item in itemlist)
{
list.Add(new eDvd(item.Id, item.IdTitle, item.TinhTrang, (bool)item.TrangThai));
}
return(list);
}
//insert
public void insertChiTietPhieuMuon(eChiTietPhieuMuon item)
{
data = new DvdRentDbDataContext();
data.ChiTietPhieuMuons.InsertOnSubmit(new ChiTietPhieuMuon()
{
IdPhieuMuon = item.IdPhieuMuon,
IdDVD = item.IdDvd,
PhiTre = item.PhiTre,
NgayTra = item.NgayTra,
TinhTrang = item.TinhTrang
});
data.SubmitChanges();
}
public void insertTitle(eTitle item)
{
data = new DvdRentDbDataContext();
data.Titles.InsertOnSubmit(new Title()
{
PhiTre = item.PhiTre,
ThoiGianThue = item.ThoiGianThue,
Gia = item.GiaThue,
Ten = item.TenTitle,
TheLoai = item.TheLoai,
TrangThai = item.TrangThai1
});
data.SubmitChanges();
}
public eTitle getTitle(int id)
{
data = new DvdRentDbDataContext();
Title item = data.Titles.Single(n => n.Id == id);
return(new eTitle(
item.Id,
int.Parse(item.PhiTre.ToString()),
int.Parse(item.ThoiGianThue.ToString()),
int.Parse(item.Gia.ToString()),
item.Ten,
(bool)item.TheLoai,
(bool)item.TrangThai
));
}