public ActionResult InsertGhiChu(string SLID, string STID, string STNAME) { GhiChu gc = db.GhiChus.SingleOrDefault(a => a.TID.Equals(STID)); if (gc == null) { gc = new GhiChu(); gc.TID = STID; gc.HienThi = true; db.GhiChus.Add(gc); GhiChuCT ct = new GhiChuCT(); ct.TID = STID; ct.LID = SLID; ct.TName = STNAME; db.GhiChuCTs.Add(ct); db.SaveChanges(); return(Json("1", JsonRequestBehavior.AllowGet)); } else { return(Json("0", JsonRequestBehavior.AllowGet)); } }
public ActionResult ChiTietVanBan(int id) { if (KiemTraSession() == true) { return(RedirectToAction("DangNhap", "QuanTri")); } Tools tool = new Tools(); ViewBag.TinhTrang = tool.DMTinhTrang(0); ViewBag.LoaiVanBan = new SelectList(db.LoaiTaiLieux.OrderBy(n => n.CapTaiLieu), "MaLoaiTL", "TenLoaiTL"); ViewBag.PhongBan = new SelectList(db.DMPhongBans.Where(n => n.KichHoat == true), "Id", "TenPhong"); ViewBag.NoiBanHanh = new SelectList(db.DMPhongBans.Where(n => n.KichHoat == true), "Id", "TenPhong"); TaiLieu tl = db.TaiLieux.SingleOrDefault(n => n.MaTaiLieu == id); //lay cac van ban lien quan ViewBag.VBCC = db.VB_VBCC.Where(n => n.MaVanBan == id); ViewBag.VBSD = db.VB_VBSD.Where(n => n.MaVanBan == id); ViewBag.VBHD = db.VB_VBHD.Where(n => n.MaVanBan == id); ViewBag.VBLQ = db.VB_VBLQ.Where(n => n.MaVanBan == id); ViewBag.Revision = db.Revisions.Where(n => n.MaVanBan == id); ViewBag.CauHinh = db.CauHinhs; // BEGIN ViewBag.BMLQ = db.VB_BMLQ.Where(n => n.MaVanBan == id); // END //lay ghi chu van ban if (Session["DangNhap"] != null) { NhanVien nv = (NhanVien)Session["DangNhap"]; GhiChu gGhiChu = db.GhiChus.SingleOrDefault(n => n.MaVanBan == tl.MaTaiLieu && n.IdNhanVien == nv.Id); if (gGhiChu != null) { ViewBag.NoiDungGhiChu = gGhiChu.NoiDung; } //kiem tra van ban lu tru ViewBag.VBLuuTru = db.VBLuuTrus.Count(n => n.IdNhanVien == nv.Id && n.MaVanBan == tl.MaTaiLieu); } if (tl.BaoMat == true && !System.Web.HttpContext.Current.User.IsInRole("XEM-VB-MAT")) { return(RedirectToAction("IndexVanBan")); } return(View(tl)); }
public ActionResult GhiChu(string NoiDung, int MaVanBan) { if (Session["DangNhap"] != null) { NhanVien nv = (NhanVien)Session["DangNhap"]; GhiChu ktGhiChu = db.GhiChus.SingleOrDefault(n => n.MaVanBan == MaVanBan && n.IdNhanVien == nv.Id); if (ktGhiChu == null) { GhiChu themGC = new GhiChu(); themGC.MaVanBan = MaVanBan; themGC.IdNhanVien = nv.Id; themGC.NoiDung = NoiDung; db.GhiChus.Add(themGC); db.SaveChanges(); } else { ktGhiChu.NoiDung = NoiDung; db.SaveChanges(); } } return(Content("")); }