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