// Thêm cuốn sách
public bool Add(CuonSach value)
{
try
{
_db.CuonSach.Add(value);
_db.SaveChanges();
return true;
}
catch (Exception e)
{
Console.WriteLine(e.Message);
return false;
}
}
private void btnAdd_Click(object sender, RoutedEventArgs e)
{
if (!CheckNull()) return;
var record = new CuonSach()
{
MaDauSach = (int)cbxMaDauSach.SelectedValue,
MaTinhTrang = (int)cbxMaTinhTrang.SelectedValue
};
if (db.Add(record))
{
MessageBox.Show("Thêm thành công");
btnResetS_Click(null, null);
cuonSachDataGrid.SelectedIndex = cuonSachDataGrid.Items.Count - 1;
cuonSachDataGrid.ScrollIntoView(record);
btnAdd.IsEnabled = false;
}
else MessageBox.Show("Thêm thất bại");
}
// Cập nhật cuốn sách
public bool Update(CuonSach value)
{
try
{
CuonSach record = _db.CuonSach.SingleOrDefault(v => v.MaCuonSach == value.MaCuonSach);
//record.MaDauSach = value.MaDauSach;
record.MaTinhTrang = value.MaTinhTrang;
_db.SaveChanges();
return true;
}
catch (Exception e)
{
Console.WriteLine(e.Message);
return false;
}
}
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");
}
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");
}