// Thêm phiếu mượn
public bool Add(PhieuMuon value)
{
try
{
_db.PhieuMuon.Add(value);
_db.SaveChanges();
return true;
}
catch (Exception e)
{
Console.WriteLine(e.Message);
return false;
}
}
//timphieumuon
public PhieuMuon _Search(int? docgia, DateTime? ngaymuon)
{
try
{
PhieuMuon pm = new PhieuMuon();
var query = from c in _db.PhieuMuon
where c.MaDocGia.Equals(docgia)
select c;
var temp = query.Where(v => v.NgayMuon >= ngaymuon).ToList();
foreach(var item in temp)
{
pm.MaPhieuMuon = item.MaPhieuMuon;
pm.NgayMuon = item.NgayMuon;
pm.MaDocGia = item.MaDocGia;
}
return pm;
}
catch (Exception e)
{
Console.WriteLine(e.Message);
return null;
}
}
public ActionResult submit(String _madocgia,FormCollection fc)
{
PhieuMuon phieumuon = new PhieuMuon();
phieumuon.MaDocGia = int.Parse(_madocgia);
phieumuon.NgayMuon = DateTime.Parse(fc["ngay"]);
phieumuon.tinhtrang = false;
dbpm.Add(phieumuon);
int madocgia=int.Parse(_madocgia);
DateTime ngaymuon=DateTime.Parse(fc["ngay"]);
var list = dbpm.Search(madocgia, ngaymuon);
foreach(var item in list)
{
maphieumuon = item.MaPhieuMuon;
}
var query=from c in _db.Temp
select c;
var temp = query.Where(v => v.MaDocGia == madocgia).ToList();
foreach(var item in temp)
{
CTPhieuMuon ct = new CTPhieuMuon();
ct.MaPhieuMuon = maphieumuon;
ct.MaCuonSach = item.MaCuonSach;
ct.DaTra = false;
_db.CTPhieuMuon.Add(ct);
CuonSach cs=new CuonSach();
cs = dbsach.GetByID(item.MaCuonSach);
cs.MaTinhTrang = 2;
dbsach.Update(cs);
}
deleteallrow();
return RedirectToAction("Index");
}
// Cập nhật phiếu mượn
public bool Update(PhieuMuon value)
{
try
{
PhieuMuon record = _db.PhieuMuon.SingleOrDefault(v => v.MaPhieuMuon == value.MaPhieuMuon);
record.MaDocGia = value.MaDocGia;
record.NgayMuon = value.NgayMuon;
record.tinhtrang = value.tinhtrang;
_db.SaveChanges();
return true;
}
catch (Exception e)
{
Console.WriteLine(e.Message);
return false;
}
}
public ActionResult xulytrasach(FormCollection fc,String mapm)
{
int maphieumuon=int.Parse(mapm);
PhieuTra phieutra = new PhieuTra();
phieutra.MaPhieuMuon = maphieumuon;
phieutra.NgayTra = DateTime.Parse(fc["ngay"]);
pt.Add(phieutra);
DateTime ngaytra = DateTime.Parse(fc["ngay"]);
var list_ = pt.Search(maphieumuon, ngaytra).ToList();
foreach(var item in list_)
{
maphieutra = item.MaPhieuTra;
}
int _id = int.Parse(mapm);
var temp = ctpm.Search_id(_id).ToList();
List<DataRow
> list = new List<DataRow
>();
foreach (var item in temp)
{
System.Data.DataTable dt = dbsach.searchbyid(item.MaCuonSach);
foreach (DataRow dr in dt.Rows)
{
list.Add(dr);
}
}
foreach(var item in list)
{
if (fc[item["MaCuonSach"].ToString()] == "check")
{
int ma=int.Parse(item["MaCuonSach"].ToString());
CTPhieuTra ct = new CTPhieuTra();
ct.MaCuonSach=int.Parse(item["MaCuonSach"].ToString());
ct.MaPhieuTra = maphieutra;
ctpt.Add(ct);
var query=from c in _db.CTPhieuMuon
where c.MaCuonSach.Equals(ma)&&c.DaTra==false
select c;
foreach(CTPhieuMuon _ct in query)
{
_ct.DaTra = true;
}
_db.SaveChanges();
CuonSach cs = new CuonSach();
cs = dbsach.GetByID(int.Parse(item["MaCuonSach"].ToString()));
cs.MaTinhTrang = 1;
dbsach.Update(cs);
}
}
int soluongsach = dbpm.soluongsachmuon(maphieumuon);
if(!(soluongsach>0))
{
PhieuMuon pm = new PhieuMuon();
pm = dbpm.GetByID(maphieumuon);
pm.tinhtrang = true;
dbpm.Update(pm);
}
return RedirectToAction("Index");
}
