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