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); } }