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