public List <KhoanVay> GetKhoanVay(string matv) { const string proc = "SP_XemKhoanVay"; List <SqlParameter> para = new List <SqlParameter>() { new SqlParameter("matv", matv) }; IDataReader reader = DataProvider.ExecuteReader(proc, para); List <KhoanVay> result = new List <KhoanVay>(); KhoanVay vt; while (reader.Read()) { vt = new KhoanVay(); vt.id = Convert.ToInt32(reader["id"]); vt.ngayvay = Convert.ToDateTime(reader["NgayVay"]); vt.nguoivay = Convert.ToString(reader["NguoiVay"]); vt.sotien = Convert.ToInt32(reader["SoTien"]); vt.sotiendatra = Convert.ToInt32(reader["SoTienDaTra"]); vt.sotienchuatra = Convert.ToInt32(reader["SoTienChuaTra"]); vt.trangthai = Convert.ToString(reader["TrangThai"]); result.Add(vt); } return(result); }
// // GET: /KhoanVay/Delete/5 public ActionResult Delete(int id = 0) { ViewBag.KV_id = id; KhoanVay khoanvay = db.KhoanVay.Find(id); if (khoanvay == null) { return(HttpNotFound()); } return(View(khoanvay)); }
// // GET: /KhoanVay/Edit/5 public ActionResult Edit(int id = 0) { ViewBag.HV_id = id; KhoanVay khoanvay = db.KhoanVay.Find(id); if (khoanvay == null) { return(HttpNotFound()); } ViewBag.idMucDichSuDung = new SelectList(db.dmMucDichSuDung, "id", "TenMucDich", khoanvay.idMucDichSuDung); ViewBag.idNhanVienVayMuon = new SelectList(db.NhanVienVayMuon, "id", "MaNV", khoanvay.idNhanVienVayMuon); return(View(khoanvay)); }
public ActionResult DeleteConfirmed(int id) { KhoanVay khoanvay = db.KhoanVay.Find(id); var hoanvay = from h in db.HoanVay where h.idKhoanVay == id select h; int nvid = khoanvay.idNhanVienVayMuon; try { db.KhoanVay.Remove(khoanvay); db.SaveChanges(); TempData["Message"] = "Xóa khoản vay thành công"; } catch (Exception e) { TempData["Message"] = "Xóa khoản vay không thành công"; } return(RedirectToAction("Index", new { NV_id = nvid })); }
public ActionResult Edit(KhoanVay khoanvay) { try { if (ModelState.IsValid) { db.Entry(khoanvay).State = EntityState.Modified; db.SaveChanges(); TempData["Message"] = "Chỉnh sửa khoản vay thành công"; return(RedirectToAction("Index", new { NV_id = khoanvay.idNhanVienVayMuon })); } } catch (Exception e) { TempData["Message"] = "Chỉnh sửa khoản vay không thành công"; } ViewBag.idMucDichSuDung = new SelectList(db.dmMucDichSuDung, "id", "MaMucDich", khoanvay.idMucDichSuDung); ViewBag.idNhanVienVayMuon = new SelectList(db.NhanVienVayMuon, "id", "MaNV", khoanvay.idNhanVienVayMuon); return(View(khoanvay)); }
public ActionResult Create(KhoanVay khoanvay) { try { if (ModelState.IsValid) { db.KhoanVay.Add(khoanvay); db.SaveChanges(); TempData["Message"] = "Thêm mới khoản vay thành công"; return(RedirectToAction("Index", new { NV_id = khoanvay.idNhanVienVayMuon })); } } catch (Exception e) { TempData["Message"] = "Thêm mới khoản vay không thành công"; } ViewBag.idMucDichSuDung = new SelectList(db.dmMucDichSuDung, "id", "TenMucDich", khoanvay.idMucDichSuDung); ViewBag.idNhanVienVayMuon = new SelectList(db.NhanVienVayMuon, "id", "MaNV", khoanvay.idNhanVienVayMuon); return(View(khoanvay)); }