public ActionResult Index(string searchString, int page = 1, int pageSize = 10) { var dao = new DonViDao(); var model = dao.ListAllPaging(searchString, page, pageSize); ViewBag.SearchString = searchString; return(View(model)); }
public ActionResult Index(string searchYeuCau, string searchTinhTrang, string searchName, string searchTenDanhMuc, string searchTenDonVi, string searchTenLop, string searchEmail, string searchTenVaiTro, int page = 1, int pageSize = 10) { var dao = new HocVuDao(); var model = dao.ListThongKe(searchYeuCau, searchTinhTrang, searchName, searchTenDanhMuc, searchTenDonVi, searchTenLop, searchEmail, searchTenVaiTro, page, pageSize); var dao1 = new DonViDao(); ViewBag.listDonVi = new SelectList(dao1.ListAll(), "TenDonVi", "TenDonVi"); ViewBag.listTinhTrang = new SelectList(dao.ListAll(), "TinhTrang", "TinhTrang"); var lop = new LopDao(); ViewBag.listLop = new SelectList(lop.ListAll(), "TenLop", "TenLop"); var vaitro = new VaiTroDao(); ViewBag.listVaiTro = new SelectList(vaitro.ListAll(), "TenVaiTro", "TenVaiTro"); ViewBag.searchYeuCau = searchYeuCau; ViewBag.searchTinhTrang = searchTinhTrang; ViewBag.searchName = searchName; ViewBag.searchTenDanhMuc = searchTenDanhMuc; ViewBag.searchTenDonVi = searchTenDonVi; ViewBag.searchTenLop = searchTenLop; ViewBag.searchEmail = searchEmail; ViewBag.searchTenVaiTro = searchTenVaiTro; var list = dao.ListAll(); List <int> repart = new List <int>(); var userID = list.Select(x => x.UserID).Distinct(); var listUser = from a in userID join b in db.Users on a.Value equals b.UserID select b.UserName; foreach (var item in userID) { repart.Add(list.Count(x => x.UserID == item)); } var rep = repart; ViewBag.UserID = listUser; ViewBag.REP = repart.ToList(); var danhmucID = list.Select(x => x.DanhMucID).Distinct(); var listDM = from a in danhmucID join b in db.DanhMucs on a.ToString() equals b.DanhMucID.ToString() select b.TenDanhMuc; List <int> listDanhMuc = new List <int>(); foreach (var item in danhmucID) { listDanhMuc.Add(list.Count(x => x.DanhMucID == item)); } ViewBag.danhmucID = listDM; ViewBag.listDanhMuc = listDanhMuc.ToList(); return(View(model)); }
public ActionResult Index(string searchString, string searchUser, int page = 1, int pageSize = 100) { var dao = new HocVuDao(); var model = dao.ListHocVu(searchString, searchUser, page, pageSize); ViewBag.SearchString = searchString; ViewBag.searchUser = searchUser; var dao1 = new DonViDao(); ViewBag.listDonVi = new SelectList(dao1.ListAll(), "TenDonVi", "TenDonVi"); return(View(model)); }
public ActionResult Update(DM_DON_VI DonVi) { var dao = new DonViDao(); if (dao.isExistWhenUpdate(DonVi.DV_MA, DonVi.DV_ID)) { var model = new { errorMsg = "Mã đơn vị đã tồn tại" }; return(Json(model, JsonRequestBehavior.AllowGet)); } else { dao.Update(DonVi); var model = new { sussMsg = "Thêm thành công" }; return(Json(model, JsonRequestBehavior.AllowGet)); } }
public ActionResult Create(DonVi donvi) { if (ModelState.IsValid) { var dao = new DonViDao(); int id = dao.Insert(donvi); if (id > 0) { SetAlert("Thêm đơn vị thành công", "success"); return(RedirectToAction("Index", "DonVi")); } else { ModelState.AddModelError("", "Thêm đơn vị không thành công"); } } return(View("Index")); }
public ActionResult Edit(DonVi donvi) { if (ModelState.IsValid) { var dao = new DonViDao(); var result = dao.Update(donvi); if (result) { SetAlert("Chỉnh sửa đơn vị thành công", "success"); return(RedirectToAction("Index", "DonVi")); } else { ModelState.AddModelError("", "cập nhật không thành công"); } } return(View("Index")); }
public ActionResult Edit(int id) { var user = new DonViDao().ViewDetail(id); return(View(user)); }
public void SetViewBag(int?DonViID = null) { var dao = new DonViDao(); ViewBag.DonViID = new SelectList(dao.ListAll(), "DonViID", "TenDonVi", DonViID); }
public ActionResult Delete(long id) { var data = new DonViDao().Delete(id); return(Json(data, JsonRequestBehavior.AllowGet)); }
public ActionResult LoadData(string sort = "DV_MA", string order = "asc") { var data = new DonViDao().ListAll(sort, order); return(Json(data, JsonRequestBehavior.AllowGet)); }