private void xoaChiTietPhieuMuonTrung(string ms)
{
CHITIETPHIEUMUON sa = DB.CHITIETPHIEUMUONs.FirstOrDefault(s => s.MaSach.Equals(ms));
try
{
DB.CHITIETPHIEUMUONs.DeleteOnSubmit(sa);
DB.SubmitChanges();
}
catch (SqlException ex)
{
MessageBox.Show(ex.Message);
}
}
private void TraSachTrongChiTietPhieuMuonSach(string mS, DateTime nt)
{
CHITIETPHIEUMUON ctpms = DB.CHITIETPHIEUMUONs.FirstOrDefault(s => s.MaSach == mS);
ctpms.NgayTra = nt;
try
{
DB.SubmitChanges();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void themChiTietPhieuMuonSach(string ms, int mpm)
{
CHITIETPHIEUMUON ctpms = new CHITIETPHIEUMUON();
ctpms.MaSach = ms;
ctpms.MaPhieuMuon = mpm;
ctpms.NgayTra = null;
try
{
DB.CHITIETPHIEUMUONs.InsertOnSubmit(ctpms);
DB.SubmitChanges();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}