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