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