public void ThemChiTietPhieuMuonSach(string maSach, int maPhieu)
{
ChiTietPhieuMuon p = new ChiTietPhieuMuon();
p.MaSach = Int32.Parse(maSach);
p.MaPhieuMuon = maPhieu;
qltvDB.ChiTietPhieuMuons.InsertOnSubmit(p);
qltvDB.SubmitChanges();
}
public void ThemNV(string ten, string ns, string dc, string sdt, int bc)
{
NhanVien nv = new NhanVien();
nv.HoTenNhanVien = ten;
nv.NgaySinh = DateTime.Parse(ns);
nv.DiaChi = dc;
nv.DienThoai = sdt;
nv.MaBangCap = bc;
qltvDB.NhanViens.InsertOnSubmit(nv);
qltvDB.SubmitChanges();
}
public void ThemSach(string tenSach, string tg, int namXB, string NXB, double donGia)
{
Sach s = new Sach(); // object Sach trong QuanLyThuVienDatabase
s.TenSach = tenSach;
s.TacGia = tg;
s.NamXuatBan = namXB;
s.NhaXuatBan = NXB;
s.TriGia = donGia;
s.NgayNhap = DateTime.Now;
qltvDB.Saches.InsertOnSubmit(s);
qltvDB.SubmitChanges();
}
public void ThemDG(string ten, string ns, string dc, string email)
{
DocGia dg = new DocGia();
dg.HoTenDocGia = ten;
dg.NgaySinh = DateTime.Parse(ns);
dg.DiaChi = dc;
dg.Email = email;
DateTime now = DateTime.Now;
dg.NgayLapThe = now;
dg.NgayHetHan = now.AddDays(730);
qltvDB.DocGias.InsertOnSubmit(dg);
qltvDB.SubmitChanges();
}
public PhieuMuonSach ThemPhieuMuonSach(string maDocGia)
{
PhieuMuonSach p = new PhieuMuonSach();
p.MaDocGia = Int32.Parse(maDocGia);
p.NgayMuon = DateTime.Now;
qltvDB.PhieuMuonSaches.InsertOnSubmit(p);
qltvDB.SubmitChanges();
return(p);
}
