public void CreateBorrowBookBill() { PHIEUMUONSACH temp = new PHIEUMUONSACH() { MADG = Client.MADG, NGMUON = DateTime.Today, NGUOILAP = dataProvider.User.MATK }; if (dataProvider.Create <PHIEUMUONSACH>(temp)) { foreach (CTSACH item in BorrowList) { item.MATT = 3; dataProvider.UpdateCTS(item, temp); } } BorrowList = new BindableCollection <CTSACH>(); BorrowBillList = dataProvider.GetPMS(x => x.MADG == Client.MADG); Amount = dataProvider.LibraryRules.SACHMUONTOIDA ?? 5; foreach (PHIEUMUONSACH item in BorrowBillList) { Amount -= item.CTSACH.Count - item.CTPTS.Count; } MyList = dataProvider.ReturnBookList(Client); ReturnBookBill = new BindableCollection <CTPTS>(); eventAggregator.PublishOnCurrentThread(new Models.Message("Thông báo", "Tạo phiếu mượn sách thành công")); }
public void AddPhieuMuon(string ngayMuon, int idDocGia) { if (this.QLThuVienDC.Connection.State == System.Data.ConnectionState.Closed) { this.QLThuVienDC.Connection.Open(); } QLThuVienDC.Transaction = QLThuVienDC.Connection.BeginTransaction(); try { PHIEUMUONSACH e = new PHIEUMUONSACH(); e.NgayMuon = DateTime.Parse(ngayMuon); e.MaDocGia = idDocGia; QLThuVienDC.PHIEUMUONSACHes.InsertOnSubmit(e); QLThuVienDC.SubmitChanges(); QLThuVienDC.Transaction.Commit(); } catch (SqlException ex) { MessageBox.Show(ex.Message); QLThuVienDC.Transaction.Rollback(); } finally { QLThuVienDC.Transaction.Dispose(); this.QLThuVienDC.Connection.Close(); } }
public void add(DocGiaFrm f) { DOCGIA dg = new DOCGIA(); PHIEUMUONSACH pm = new PHIEUMUONSACH(); if (f.emailTxt.Text == "" || f.tenDocGiaTxt.Text == "") { MessageBox.Show("Tên và Email không được trống", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Warning); } else { dg.HoTenDocGia = f.tenDocGiaTxt.Text; dg.NgaySinh = Convert.ToDateTime(f.ngaySinhDT.Text); dg.DiaChi = f.diaChiTxt.Text; dg.Email = f.emailTxt.Text; dg.NgayLapThe = Convert.ToDateTime(f.ngayLapTheDT.Text); dg.NgayHetHan = Convert.ToDateTime(f.ngayHetHanDT.Text); db.database().DOCGIAs.InsertOnSubmit(dg); db.database().SubmitChanges(); pm.TinhTrangThanhToan = "Chưa thanh toán"; pm.MaDocGia = db.database().LAST_DOCGIA_FUNC().Value; pm.MaNhanVien = 1; pm.NgayMuon = DateTime.Now; pm.MaSach = 1; db.database().PHIEUMUONSACHes.InsertOnSubmit(pm); db.database().SubmitChanges(); loadAllData(f); } }
public void UpdatePhieuMuon(int idPhieuMuon, string ngayMuon, int idDocGia) { PHIEUMUONSACH e = QLThuVienDC.PHIEUMUONSACHes.FirstOrDefault(s => s.MaPhieuMuon.Equals(idPhieuMuon)); e.NgayMuon = DateTime.Parse(ngayMuon); e.MaDocGia = idDocGia; QLThuVienDC.SubmitChanges(); }
public void UpdateCTS(CTSACH cs, PHIEUMUONSACH pms) { using (QLTVEntities db = new QLTVEntities()) { CTSACH c = db.CTSACH.FirstOrDefault(x => x.MACTS == cs.MACTS); PHIEUMUONSACH d = db.PHIEUMUONSACH.FirstOrDefault(x => x.MAPMS == pms.MAPMS); c.MATT = cs.MATT; c.PHIEUMUONSACH.Add(d); d.CTSACH.Add(c); db.SaveChanges(); } }
//-------------------------Sửa mượn sách------------------------------ void suathongtinmuonsach() { PHIEUMUONSACH p1 = db.PHIEUMUONSACH.FirstOrDefault(a => a.MADOCGIA == cmmadocgia.Text); if (p1 != null) { p1.MADOCGIA = cmmadocgia.Text; p1.MASACH = cmmasach.Text; p1.NGAYMUONSACH = Convert.ToDateTime(dateTimemuon.Text); p1.NGAYTRA = Convert.ToDateTime(dateTimetrasach.Text); p1.SOLUONGMUON = Convert.ToInt32(txtsoluongmuon.Text); p1.MANHANVIEN = cmmanhanvien.Text; db.SaveChanges(); } danhsachmuon(db.PHIEUMUONSACH.ToList()); }
void muonsach() { try { PHIEUMUONSACH p = new PHIEUMUONSACH(); DateTime dt = DateTime.Now; DateTime dtreturn = DateTime.Now.AddDays(15); p.MADOCGIA = cmmadocgia.Text; p.MASACH = cmmasach.Text; p.NGAYMUONSACH = DateTime.Now; p.NGAYTRA = Convert.ToDateTime(dateTimetrasach.Text); p.SOLUONGMUON = Convert.ToInt32(txtsoluongmuon.Text); p.MANHANVIEN = cmmanhanvien.Text; db.PHIEUMUONSACH.Add(p); db.SaveChanges(); danhsachmuon(db.PHIEUMUONSACH.ToList()); } catch (Exception ex) { MessageBox.Show(ex.Message); } }
//Sách đã mượn void danhsachmuon(List <PHIEUMUONSACH> listmuon) { DataTable tbmuon = new DataTable(); tbmuon.Columns.Add("STT"); tbmuon.Columns.Add("Mã độc giả"); tbmuon.Columns.Add("Mã sách"); tbmuon.Columns.Add("Ngày mượn sách"); tbmuon.Columns.Add("Ngày trả"); tbmuon.Columns.Add("Số lượng"); tbmuon.Columns.Add("Mã nhân viên"); int STT = 1; for (int i = 0; i < listmuon.Count; i++, STT++) { PHIEUMUONSACH phieumuon = listmuon[i]; tbmuon.Rows.Add(new String[] { STT.ToString(), phieumuon.MADOCGIA, phieumuon.MASACH, phieumuon.NGAYMUONSACH.ToString(), phieumuon.NGAYTRA.ToString(), phieumuon.SOLUONGMUON.ToString(), phieumuon.MANHANVIEN }); } dtgvsachmuon.DataSource = tbmuon; }
public void add(PhieuMuonSachFrm f) { PHIEUMUONSACH pm = new PHIEUMUONSACH(); pm.NgayMuon = Convert.ToDateTime(f.ngayMuonDtp.Text); pm.MaDocGia = int.Parse(f.tenDocGiaCb.SelectedValue.ToString()); pm.MaNhanVien = int.Parse(f.tenNhanVienCb.SelectedValue.ToString()); pm.MaSach = int.Parse(f.maSachCb.SelectedValue.ToString()); if (f.chuaThanhToanRb.Checked) { pm.TinhTrangThanhToan = "Chưa thanh toán"; } else { pm.TinhTrangThanhToan = "Đã thanh toán"; } db.database().PHIEUMUONSACHes.InsertOnSubmit(pm); db.database().SubmitChanges(); loadAllData(f); }
//---------------------------------Tra sach theo ma------------------------------------------------- void trasachtheomasach() { PHIEUMUONSACH p3 = db.PHIEUMUONSACH.FirstOrDefault(a => a.MADOCGIA == txtmadocgiatra.Text); if (p3 != null) { string Madocgia = txtmadocgiatra.Text; string Masachtra = txtmasachtra.Text; using (var dbcontext = new ThuvienDBContext()) { if (dbcontext.PHIEUMUONSACH.Any(pm => pm.MADOCGIA == Madocgia && pm.MASACH == Masachtra)) { db.PHIEUMUONSACH.Remove(p3); db.SaveChanges(); MessageBox.Show("Đã xóa thành công!"); danhsachmuon(db.PHIEUMUONSACH.ToList()); } else { MessageBox.Show("Xóa thất bại!"); } } } }