public void CapNhatSachTrongKho(int SoLuong, string MaSach)
{
KetNoi = new Data.QuanLyThuVienDataContext();
Data.Sach Temp2 = new Data.Sach();
Temp2 = KetNoi.Saches.Where(s => s.MaSach == MaSach).Single();
Temp2.SoLuong = SoLuong;
KetNoi.SubmitChanges();
}
//
public void XoaSach(string MaSach)
{
KetNoi = new Data.QuanLyThuVienDataContext();
Data.Sach Temp1 = new Data.Sach();
Temp1 = KetNoi.Saches.Where(s => s.MaSach == MaSach.ToString()).Single();
KetNoi.Saches.DeleteOnSubmit(Temp1);
KetNoi.SubmitChanges();
}
//Cộng SoLuongSach
public void Plus_SoLuongSach(string MaSach)
{
Class.XuLyThuVien KiemTra = new Class.XuLyThuVien();
int SoLuong = KiemTra.LaySoLuongSach(MaSach);
KetNoi = new Data.QuanLyThuVienDataContext();
Data.Sach Temp2 = new Data.Sach();
Temp2 = KetNoi.Saches.Where(s => s.MaSach == MaSach).Single();
Temp2.SoLuong = SoLuong + 1;
KetNoi.SubmitChanges();
}
//
public void ThemSachVaoKho(Sach Book)
{
Data.Sach Temp = new Data.Sach();
Temp.MaSach = Book.MaSach;
Temp.TenSach = Book.TenSach;
Temp.SoLuong = Book.SoLuong;
Temp.NamXuatBan = Book.NamXuatBan;
Temp.NhaXuatBan = Book.NhaSanXuat;
Temp.NgayVaoKho = Book.NgayVaoKho;
Temp.TheLoai = Book.TheLoai;
Temp.TenTacGia = Book.TacGia;
KetNoi = new Data.QuanLyThuVienDataContext();
KetNoi.Saches.InsertOnSubmit(Temp);
KetNoi.SubmitChanges();
}
