/// <summary> /// thêm thông tin phiếu thu tiền phạtvào database /// </summary> public static void AddPhieuThuTienPhat(PhieuThuTienPhat PhieuThuTienPhat) { using (var db = new LiteDatabase(DatabaseConnectionString)) { db.GetCollection <PhieuThuTienPhat>("PhieuThuTienPhat").Insert(PhieuThuTienPhat); } }
public async Task <IActionResult> Edit(int id, [Bind("PhieuThuTienPhatID,TienCoc,TienPhat,TienConLai,DocGiaID,PhieuTraID")] PhieuThuTienPhat phieuThuTienPhat) { if (id != phieuThuTienPhat.PhieuThuTienPhatID) { return(NotFound()); } if (ModelState.IsValid) { try { _context.Update(phieuThuTienPhat); await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!PhieuThuTienPhatExists(phieuThuTienPhat.PhieuThuTienPhatID)) { return(NotFound()); } else { throw; } } return(RedirectToAction(nameof(Index))); } ViewData["DocGiaID"] = new SelectList(_context.DocGia, "DocGiaID", "DiaChi", phieuThuTienPhat.DocGiaID); ViewData["PhieuTraID"] = new SelectList(_context.PhieuTra, "PhieuTraID", "PhieuTraID", phieuThuTienPhat.PhieuTraID); return(View(phieuThuTienPhat)); }
/// <summary> /// cập nhật thông tin phiếu thu tiền phạtvào database /// </summary> public static bool SetPhieuThuTienPhat(PhieuThuTienPhat PhieuThuTienPhat) { bool result; using (var db = new LiteDatabase(DatabaseConnectionString)) { result = db.GetCollection <PhieuThuTienPhat>("PhieuThuTienPhat").Update(PhieuThuTienPhat); } return(result); }
public async Task <IActionResult> Create([Bind("PhieuThuTienPhatID,TienCoc,TienPhat,TienConLai,DocGiaID,PhieuTraID")] PhieuThuTienPhat phieuThuTienPhat) { if (ModelState.IsValid) { _context.Add(phieuThuTienPhat); await _context.SaveChangesAsync(); return(RedirectToAction(nameof(Index))); } ViewData["DocGiaID"] = new SelectList(_context.DocGia, "DocGiaID", "DiaChi", phieuThuTienPhat.DocGiaID); ViewData["PhieuTraID"] = new SelectList(_context.PhieuTra, "PhieuTraID", "PhieuTraID", phieuThuTienPhat.PhieuTraID); return(View(phieuThuTienPhat)); }
public ActionResult DaTraSach(string stt, string iddg, string idsach) { CTMuonTra ct = db.CTMuonTras.Where(n => n.STT == stt && n.IDSach == idsach && n.IDDocGia == iddg).SingleOrDefault(); ct.NgayTraThucTe = DateTime.Now.Date; if (DateTime.Now.Date <= ct.NgayTraQuyDinh) { ct.NgayQuaHan = 0; ct.TienPhat = 0; } else { TimeSpan Time = DateTime.Now.Date - ct.NgayTraQuyDinh.Value; ct.NgayQuaHan = Time.Days; ct.TienPhat = Time.Days * 1000; ct.TongTien += Time.Days * 1000; DocGia dg = db.DocGias.Find(iddg); dg.TongTienPhat += Time.Days * 1000; db.Entry(dg).State = EntityState.Modified; db.SaveChanges(); PhieuThuTienPhat phieu = new PhieuThuTienPhat(); phieu.IDPhieuThuTienPhat = ""; phieu.NgayThang = DateTime.Now.Date; phieu.IDDocGia = iddg; phieu.TienThu = Time.Days * 1000; db.PhieuThuTienPhats.Add(phieu); db.SaveChanges(); } ct.TinhTrangMuon = 3; db.Entry(ct).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("SachDaTra")); }
public IActionResult SubmitKiemTraPhieuTra(List <CT_PhieuMuon> model, int id) { var phieumuon = _context.PhieuMuon.Find(id); var ctpm = _context.CT_PhieuMuon.Where(s => s.PhieuMuonID == id).ToList(); //tinh so ngay muon TimeSpan songaymuon = DateTime.Now.Subtract(phieumuon.NgayMuon); if (phieumuon.TinhTrangPhieuMuonID == 2) //2 là phiếu mượn đã trả { return(RedirectToAction("index", "phieumuon")); } else { //so ngay muon ko qua han if (songaymuon.Days <= 4) { PhieuTra phieutra = new PhieuTra(); phieutra.DocGiaID = phieumuon.DocGiaID; phieutra.NgayTra = DateTime.Now; _context.PhieuTra.Add(phieutra); _context.SaveChanges(); foreach (var a in ctpm) { CT_PhieuTra ctpt = new CT_PhieuTra(); ctpt.SoNgayMuon = songaymuon.Days; ctpt.PhieuTraID = phieutra.PhieuTraID; ctpt.SachID = a.SachID; _context.CT_PhieuTra.Add(ctpt); _context.SaveChanges(); } var docgia = _context.DocGia.FirstOrDefault(l => l.DocGiaID == phieutra.DocGiaID); docgia.SLSachDaMuon = 0; _context.SaveChanges(); //cập nhật lại tình trạng phiếu mượn phieumuon.TinhTrangPhieuMuonID = 2;//2 là phiếu mượn hoan thanh _context.SaveChanges(); double sum = 0; #pragma warning disable CS0162 // Unreachable code detected for (int i = 0; i < model.Count; i++) #pragma warning restore CS0162 // Unreachable code detected { if (model[i].IsSelected) { var sach = _context.Sach.FirstOrDefault(x => x.SachID == model[i].SachID); sach.TinhTrangSachID = 1; //1 chua thue _context.SaveChanges(); } else { var sach = _context.Sach.FirstOrDefault(x => x.SachID == model[i].SachID); sach.TinhTrangSachID = 3; //3 mat sum += sach.Gia; } } PhieuThuTienPhat pttp = new PhieuThuTienPhat(); pttp.DocGiaID = docgia.DocGiaID; pttp.TienCoc = phieumuon.TienCoc; pttp.PhieuTraID = phieutra.PhieuTraID; pttp.TienPhat = sum; pttp.TienConLai = phieumuon.TienCoc - pttp.TienPhat; _context.PhieuThuTienPhat.Add(pttp); docgia.ConLai = pttp.TienConLai; _context.SaveChanges(); return(RedirectToAction("details", new RouteValueDictionary(new { Controller = "phieuthutienphat", Action = "details", id = pttp.PhieuThuTienPhatID }))); } //so ngay muon qua han else { PhieuTra phieutra = new PhieuTra(); phieutra.DocGiaID = phieumuon.DocGiaID; phieutra.NgayTra = DateTime.Now; _context.PhieuTra.Add(phieutra); _context.SaveChanges(); // tien tra tre han double sum = 0; sum = (songaymuon.Days - 4) * 1000; foreach (var a in ctpm) { CT_PhieuTra ctpt = new CT_PhieuTra(); ctpt.SoNgayMuon = songaymuon.Days; ctpt.PhieuTraID = phieutra.PhieuTraID; ctpt.SachID = a.SachID; _context.CT_PhieuTra.Add(ctpt); _context.SaveChanges(); } var docgia = _context.DocGia.FirstOrDefault(l => l.DocGiaID == phieutra.DocGiaID); docgia.SLSachDaMuon = 0; _context.SaveChanges(); //cập nhật lại tình trạng phiếu mượn phieumuon.TinhTrangPhieuMuonID = 2;//2 là phiếu mượn hoan thanh _context.SaveChanges(); for (int i = 0; i < model.Count; i++) { // trễ hạn nhưng đủ sách if (model[i].IsSelected == true) { var sach = _context.Sach.FirstOrDefault(x => x.SachID == model[i].SachID); sach.TinhTrangSachID = 1; //1 chua thue _context.SaveChanges(); } // trễ hạn nhưng thiếu sách else { var sach = _context.Sach.FirstOrDefault(x => x.SachID == model[i].SachID); sach.TinhTrangSachID = 3; //3 mat sum += sach.Gia; } } PhieuThuTienPhat pttp = new PhieuThuTienPhat(); pttp.DocGiaID = docgia.DocGiaID; pttp.PhieuTraID = phieutra.PhieuTraID; pttp.TienCoc = phieumuon.TienCoc; pttp.TienPhat = sum; pttp.TienConLai = phieumuon.TienCoc - pttp.TienPhat; _context.PhieuThuTienPhat.Add(pttp); _context.SaveChanges(); return(RedirectToAction("details", new RouteValueDictionary(new { Controller = "phieuthutienphat", Action = "details", id = pttp.PhieuThuTienPhatID }))); } } }