public List <LOAI_VUAN> GetThongKe_HS() { NL2_QLVAEntities1 db = new NL2_QLVAEntities1(); List <LOAI_VUAN> loaiva = db.LOAI_VUAN.OrderByDescending(x => x.MA_LoaiVA).ToList(); return(loaiva); }
public ActionResult Change_Password1(string id, string password) { NHANVIEN nv = new NHANVIEN(); if (!ModelState.IsValid) { return(View(nv)); } if (TryUpdateModel(nv, "", new string[] { "MA_NhanVien", "MatKhau" })) { try { NL2_QLVAEntities1 db = new NL2_QLVAEntities1(); var nhanVienCu = db.NHANVIENs.FirstOrDefault(nvc => nvc.MA_NhanVien == nv.MA_NhanVien); nhanVienCu.MatKhau = nv.MatKhau; db.SaveChanges(); } catch (RetryLimitExceededException) { ModelState.AddModelError("", "Lỗi"); } } return(RedirectToAction("Index1", "TrangCaNhan")); }
public List <DUONGSU> Get_DS(string ds_ma) { NL2_QLVAEntities1 db = new NL2_QLVAEntities1(); List <DUONGSU> duongsu = db.DUONGSUs.ToList(); return(duongsu); }
public ActionResult DangNhap(string maNhanVien, string matKhau) { var nhanvien = db.NHANVIENs.SingleOrDefault(s => s.MA_NhanVien == maNhanVien && s.MatKhau == matKhau); using (NL2_QLVAEntities1 db = new NL2_QLVAEntities1()) if (nhanvien != null) { Session["MaNV"] = nhanvien.MA_NhanVien; Session["TenNV"] = nhanvien.HoTen_NV; Session["MatKhau"] = nhanvien.MatKhau; Session["QuyenSD"] = nhanvien.MA_QNSD; //gán session Tài khoản Session["online"] = nhanvien; Session["TaiKhoan"] = nhanvien as NHANVIEN; List <MenuModel> _menus = db.SUB_MENU.Where(x => x.MA_QNSD == nhanvien.MA_QNSD).Select(x => new MenuModel { ID_Main = x.MAIN_MENU.ID_Main, Ten_Main = x.MAIN_MENU.Ten_Main, ID_SUB = x.ID_SUB, Ten_SUB = x.CHUCNANG.Ten_Action_Viet, Controller_SUB = x.CHUCNANG.DANHMUC_CHUCNANG.Ten_Controller_code, Action_SUB = x.CHUCNANG.Ten_Action_code, MA_QNSD = x.MA_QNSD, Ten_QNSD = x.QUYEN_NSD.Ten_QNSD }).ToList(); //Get the Menu details from entity and bind it in MenuModels list. FormsAuthentication.SetAuthCookie(nhanvien.HoTen_NV, false); // set the formauthentication cookie Session["LoginCredentials"] = nhanvien; // Bind the _logincredentials details to "LoginCredentials" session Session["MenuMaster"] = _menus; //Bind the _menus list to MenuMaster session Session["UserName"] = nhanvien.MA_NhanVien; if (nhanvien.MA_QNSD == "Q01") { return(RedirectToAction("ListNV", "NhanVien")); } return(RedirectToAction("ListHS", "HoSoVuAn")); } ViewBag.message = "Sai tài khoản hoặc mật khẩu"; return(View()); }
public JsonResult GetThongKe_HS(string id) { using (NL2_QLVAEntities1 db = new NL2_QLVAEntities1()) { var a = (from hs in db.HOSO_VUAN join nv in db.NHANVIENs on hs.MA_NhanVien equals nv.MA_NhanVien join lva in db.LOAI_VUAN on hs.MA_LoaiVA equals lva.MA_LoaiVA join tt in db.TRANGTHAI_HS on hs.MA_TrangThai equals tt.MA_TrangThai select new ModelsXetXu { MA_HoSo = hs.MA_HoSo, Ten_VuAn = hs.Ten_VuAn, Loai_HS = hs.Loai_HS, NgayNhan_HS = hs.NgayNhan_HS.Value.ToString("dd/MM/yyyy"), MA_TrangThai = hs.MA_TrangThai, MA_NhanVien = hs.MA_NhanVien, Ten_TT = tt.Ten_TT, MA_LoaiVA = hs.MA_LoaiVA, HoTen_NV = nv.HoTen_NV, }).ToList(); return(Json(a, JsonRequestBehavior.AllowGet)); } }