public ActionResult Sua(LICHLAMVIEC llv) { using (Web_KTCKEntities db = new Web_KTCKEntities()) { LICHLAMVIEC lichlamviec = db.LICHLAMVIECs.SingleOrDefault(n => n.IdLLV == llv.IdLLV); if (lichlamviec != null) { lichlamviec.TieuDe = llv.TieuDe; lichlamviec.LinkNoiDung = llv.LinkNoiDung; if (llv.NgayDang == null) { lichlamviec.NgayDang = lichlamviec.NgayDang; } else { lichlamviec.NgayDang = llv.NgayDang; } lichlamviec.NhacLich = llv.NhacLich; lichlamviec.IdTaiKhoan = llv.IdTaiKhoan; ViewBag.IdTaiKhoan = new SelectList(db.TAIKHOANs.ToList(), "IdTK", "HoTen", lichlamviec.IdTaiKhoan); db.SaveChanges(); } return(RedirectToAction("Index", "LichLamViec")); } }
//POST: Admin/ThongBao/Sua public ActionResult Sua(THONGBAO tb) { using (Web_KTCKEntities db = new Web_KTCKEntities()) { THONGBAO thongbao = db.THONGBAOs.SingleOrDefault(n => n.IdTB == tb.IdTB); if (thongbao != null) { thongbao.TieuDe = tb.TieuDe; thongbao.NoiDung = tb.NoiDung; if (tb.NgayDang == null) { thongbao.NgayDang = thongbao.NgayDang; } else { thongbao.NgayDang = tb.NgayDang; } thongbao.TrangThai = tb.TrangThai; thongbao.IdTaiKhoan = tb.IdTaiKhoan; ViewBag.IdTaiKhoan = new SelectList(db.TAIKHOANs.ToList(), "IdTK", "HoTen"); db.SaveChanges(); } return(RedirectToAction("Index")); } }
public ActionResult Them(LICHLAMVIEC llv) { using (Web_KTCKEntities db = new Web_KTCKEntities()) { if (llv.NgayDang == null) { llv.NgayDang = DateTime.Parse(DateTime.Now.ToString()); } else { llv.NgayDang = llv.NgayDang; } if (llv.NhacLich == null) { llv.NhacLich = "Mọi người chú ý thực hiện đầy đủ!"; } else { llv.NhacLich = llv.NhacLich; } llv.LuotXem = 0; ViewBag.IdTaiKhoan = new SelectList(db.TAIKHOANs.ToList(), "IdTK", "HoTen"); db.LICHLAMVIECs.Add(llv); db.SaveChanges(); return(RedirectToAction("Index", "LichLamViec")); } }
// POST: Admin/HinhAnh/Sua public ActionResult Sua(HINHANH ha) { using (Web_KTCKEntities db = new Web_KTCKEntities()) { HINHANH hinhanh = db.HINHANHs.SingleOrDefault(n => n.IdHinhAnh == ha.IdHinhAnh); if (hinhanh != null) { hinhanh.TenHinhAnh = ha.TenHinhAnh; if (ha.NgayDang == null) { hinhanh.NgayDang = hinhanh.NgayDang; } else { hinhanh.NgayDang = ha.NgayDang; } hinhanh.HinhAnh1 = ha.HinhAnh1; hinhanh.IdAlbum = ha.IdAlbum; ViewBag.IdAlbum = new SelectList(db.ALBUMs.ToList(), "IdAlbum", "TenAlbum"); ViewBag.IdTaiKhoan = new SelectList(db.TAIKHOANs.ToList(), "IdTK", "HoTen"); hinhanh.IdTaiKhoan = ha.IdTaiKhoan; db.SaveChanges(); } } return(RedirectToAction("Index")); }
public ActionResult Sua(CANBO cb) { using (Web_KTCKEntities db = new Web_KTCKEntities()) { CANBO canbo = db.CANBOes.SingleOrDefault(n => n.IdCB == cb.IdCB); if (canbo != null) { canbo.HoTen = cb.HoTen; canbo.ChucVu = cb.ChucVu; canbo.BangCap = cb.BangCap; canbo.QueQuan = cb.QueQuan; canbo.Email = cb.Email; if (cb.NgaySinh == null) { canbo.NgaySinh = canbo.NgaySinh; } else { canbo.NgaySinh = cb.NgaySinh; } canbo.NgayCapNhat = DateTime.Parse(DateTime.Now.ToString()); canbo.SoDT = cb.SoDT; canbo.AnhMoTa = cb.AnhMoTa; canbo.ChiTiet = cb.ChiTiet; canbo.IdTaiKhoan = cb.IdTaiKhoan; canbo.IdPhongBan = cb.IdPhongBan; ViewBag.IdPhongBan = new SelectList(db.PHONGBANs.ToList(), "IdPB", "TenPhong", canbo.IdPhongBan); ViewBag.IdTaiKhoan = new SelectList(db.TAIKHOANs.ToList(), "IdTK", "HoTen"); db.SaveChanges(); } return(RedirectToAction("Index")); } }
public ActionResult Them(BAIVIET bv) { using (Web_KTCKEntities db = new Web_KTCKEntities()) { try { if (bv.NgayDang == null) { bv.NgayDang = DateTime.Parse(DateTime.Now.ToString()); } else { bv.NgayDang = bv.NgayDang; } bv.NgayCapNhat = null; bv.LuotXem = 0; ViewBag.IdTheLoai = new SelectList(db.THELOAIBAIVIETs.ToList(), "IdTheLoai", "TenTheLoai"); ViewBag.IdTaiKhoan = new SelectList(db.TAIKHOANs.ToList(), "IdTK", "HoTen"); db.BAIVIETs.Add(bv); db.SaveChanges(); return(RedirectToAction("Index")); } catch { return(RedirectToAction("Index")); } } }
public ActionResult DangKy(TAIKHOAN tk) { using (Web_KTCKEntities db = new Web_KTCKEntities()) { var checkMail = db.TAIKHOANs.SingleOrDefault(n => n.Email.Trim() == tk.Email.Trim()); var checkTen = db.TAIKHOANs.SingleOrDefault(n => n.HoTen.Trim() == tk.HoTen.Trim()); if (checkTen == null) { if (checkMail == null) { tk.Password = MaHoaMd5.EncryptMD5(tk.Email + tk.Password); tk.RetypePassword = MaHoaMd5.EncryptMD5(tk.Email + tk.RetypePassword); tk.TrangThai = "Hoạt động"; tk.Quyen = "User"; db.TAIKHOANs.Add(tk); db.SaveChanges(); ViewBag.tbDangKy = "Người dùng: " + tk.HoTen + " đăng ký thành công!"; return(View()); } else { ViewBag.tbTonTai = "Email: " + tk.Email + " đã tồn tại!"; return(View()); } } else { ViewBag.tbTonTai = "Tên người dùng: " + tk.HoTen + " đã tồn tại!"; return(View()); } } }
// POST: Admin/Video/Sua public ActionResult Sua(VIDEO vdo) { using (Web_KTCKEntities db = new Web_KTCKEntities()) { VIDEO video = db.VIDEOs.SingleOrDefault(n => n.IdVideo == vdo.IdVideo); if (video != null) { video.TenVideo = vdo.TenVideo; video.LinkVideo = vdo.LinkVideo; if (vdo.NgayDang == null) { video.NgayDang = video.NgayDang; } else { video.NgayDang = vdo.NgayDang; } video.IdAlbum = vdo.IdAlbum; ViewBag.IdAlbum = new SelectList(db.ALBUMs.ToList(), "IdAlbum", "TenAlbum", video.IdAlbum); ViewBag.IdTaiKhoan = new SelectList(db.TAIKHOANs.ToList(), "IdTK", "HoTen"); video.IdTaiKhoan = vdo.IdTaiKhoan; db.SaveChanges(); } return(RedirectToAction("Index")); } }
public ActionResult Index(string tukhoa) { using (Web_KTCKEntities db = new Web_KTCKEntities()) { List <THELOAIBAIVIET> lstResult = db.THELOAIBAIVIETs.Where(n => n.TenTheLoai.Contains(tukhoa)).ToList(); return(View("Index", lstResult)); } }
public ActionResult Index() { using (Web_KTCKEntities db = new Web_KTCKEntities()) { List <THELOAIBAIVIET> dstheloaibv = db.THELOAIBAIVIETs.ToList(); return(View(dstheloaibv)); } }
public ActionResult Index() { using (Web_KTCKEntities db = new Web_KTCKEntities()) { List <PHONGBAN> dsPhongban = db.PHONGBANs.ToList(); return(View(dsPhongban)); } }
public ActionResult Index(string tukhoa) { using (Web_KTCKEntities db = new Web_KTCKEntities()) { List <PHONGBAN> lstResult = db.PHONGBANs.Where(n => n.TenPhong.Contains(tukhoa)).ToList(); return(View("Index", lstResult)); } }
// GET: Admin/BaiViet/Sua public ActionResult Sua(int id) { using (Web_KTCKEntities db = new Web_KTCKEntities()) { BAIVIET baiviet = db.BAIVIETs.SingleOrDefault(n => n.IdBV == id); ViewBag.IdTheLoai = new SelectList(db.THELOAIBAIVIETs.ToList(), "IdTheLoai", "TenTheLoai", baiviet.IdTheLoai); ViewBag.IdTaiKhoan = new SelectList(db.TAIKHOANs.ToList(), "IdTK", "HoTen"); return(View(baiviet)); } }
// POST: Admin/CanBoNhanVien/Xoa public ActionResult Xoa(int id) { using (Web_KTCKEntities db = new Web_KTCKEntities()) { CANBO canbo = db.CANBOes.SingleOrDefault(n => n.IdCB == id); db.CANBOes.Remove(canbo); db.SaveChanges(); return(RedirectToAction("Index")); } }
//string MaTinTuc; //public reportTinTuccs(string MaTT) //{ // InitializeComponent(); // MaTinTuc = MaTT; // LoadTT(int.Parse(MaTT)); //} public reportTinTuccs(int id) { InitializeComponent(); Web_KTCKEntities db = new Web_KTCKEntities(); var baiviet = db.BAIVIETs.Where(n => n.IdBV == id).ToList(); DetailReport.DataSource = baiviet; xrLabel1.DataBindings.Add("Text", DetailReport.DataSource, "TieuDe"); xrLabel2.DataBindings.Add("Text", DetailReport.DataSource, "TomTat"); xrRichText1.DataBindings.Add("Html", DetailReport.DataSource, "NoiDung"); }
public ActionResult Index(string tukhoa, int?page) { using (Web_KTCKEntities db = new Web_KTCKEntities()) { int itemPageSize = 20; int pageNumber = (page ?? 1); var lstResult = db.VIDEOs.Where(n => n.TenVideo.Contains(tukhoa)).OrderByDescending(n => n.NgayDang).ToPagedList(pageNumber, itemPageSize); ViewBag.IdAlbum = new SelectList(db.ALBUMs.ToList(), "IdAlbum", "TenAlbum"); ViewBag.IdTaiKhoan = new SelectList(db.TAIKHOANs.ToList(), "IdTK", "HoTen"); return(View("Index", lstResult)); } }
public ActionResult Them(CANBO cb) { using (Web_KTCKEntities db = new Web_KTCKEntities()) { cb.NgayCapNhat = DateTime.Parse(DateTime.Now.ToString()); ViewBag.IdPhongBan = new SelectList(db.PHONGBANs.ToList(), "IdPb", "TenPhongBan"); ViewBag.IdTaiKhoan = new SelectList(db.TAIKHOANs.ToList(), "IdTK", "HoTen"); db.CANBOes.Add(cb); db.SaveChanges(); return(RedirectToAction("Index")); } }
// POST: Admin/TaiKhoan/Sua public ActionResult Sua(TAIKHOAN tk) { using (Web_KTCKEntities db = new Web_KTCKEntities()) { TAIKHOAN taikhoan = db.TAIKHOANs.SingleOrDefault(n => n.IdTK == tk.IdTK); taikhoan.HoTen = tk.HoTen; taikhoan.TrangThai = tk.TrangThai; taikhoan.Quyen = tk.Quyen; db.SaveChanges(); return(RedirectToAction("Index")); } }
//POST: Admin/LichLamViec/Xoa public ActionResult Xoa(int id) { using (Web_KTCKEntities db = new Web_KTCKEntities()) { LICHLAMVIEC llv = db.LICHLAMVIECs.SingleOrDefault(n => n.IdLLV == id); if (llv != null) { db.LICHLAMVIECs.Remove(llv); db.SaveChanges(); } return(RedirectToAction("Index", "LichLamViec")); } }
// POST: Admin/Video/Xoa public ActionResult Xoa(int id) { using (Web_KTCKEntities db = new Web_KTCKEntities()) { VIDEO vdo = db.VIDEOs.SingleOrDefault(n => n.IdVideo == id); if (vdo != null) { db.VIDEOs.Remove(vdo); db.SaveChanges(); } return(RedirectToAction("Index")); } }
// POST: Admin/HinhAnh/Xoa public ActionResult Xoa(int id) { using (Web_KTCKEntities db = new Web_KTCKEntities()) { HINHANH ha = db.HINHANHs.SingleOrDefault(n => n.IdHinhAnh == id); if (ha != null) { db.HINHANHs.Remove(ha); db.SaveChanges(); } } return(RedirectToAction("Index")); }
public ActionResult Sua(BINHLUAN bl) { using (Web_KTCKEntities db = new Web_KTCKEntities()) { BINHLUAN binhluan = db.BINHLUANs.SingleOrDefault(n => n.IdBL == bl.IdBL); if (binhluan != null) { binhluan.TrangThai = bl.TrangThai; db.SaveChanges(); } return(RedirectToAction("Index")); } }
//POST: Admin/BinhLuan/Xoa public ActionResult Xoa(int id) { using (Web_KTCKEntities db = new Web_KTCKEntities()) { BINHLUAN bl = db.BINHLUANs.SingleOrDefault(n => n.IdBL == id); if (bl != null) { db.BINHLUANs.Remove(bl); db.SaveChanges(); } return(RedirectToAction("Index")); } }
public ActionResult Sua(PHONGBAN pb) { using (Web_KTCKEntities db = new Web_KTCKEntities()) { PHONGBAN phongban = db.PHONGBANs.SingleOrDefault(n => n.IdPB == pb.IdPB); if (phongban != null) { phongban.TenPhong = pb.TenPhong; db.SaveChanges(); } return(RedirectToAction("Index")); } }
// POST: Admin/BaiViet/Xoa public ActionResult Xoa(int id) { using (Web_KTCKEntities db = new Web_KTCKEntities()) { BAIVIET bv = db.BAIVIETs.SingleOrDefault(n => n.IdBV == id); if (bv != null) { db.BAIVIETs.Remove(bv); db.SaveChanges(); } return(RedirectToAction("Index")); } }
//POST: Admin/CongVanTaiLieu/Xoa public ActionResult Xoa(int id) { using (Web_KTCKEntities db = new Web_KTCKEntities()) { TAILIEU tl = db.TAILIEUx.SingleOrDefault(n => n.IdTL == id); if (tl != null) { db.TAILIEUx.Remove(tl); db.SaveChanges(); } return(RedirectToAction("Index")); } }
//POST: Admin/TheLoaiBaiViet/Them public ActionResult Them(THELOAIBAIVIET tlbv) { using (Web_KTCKEntities db = new Web_KTCKEntities()) { var checkTheLoai = db.THELOAIBAIVIETs.SingleOrDefault(n => n.TenTheLoai.Trim() == tlbv.TenTheLoai.Trim()); if (checkTheLoai == null) { db.THELOAIBAIVIETs.Add(tlbv); db.SaveChanges(); } return(RedirectToAction("Index")); } }
//POST: Admin/ThongBao/Xoa public ActionResult Xoa(int id) { using (Web_KTCKEntities db = new Web_KTCKEntities()) { THONGBAO tb = db.THONGBAOs.SingleOrDefault(n => n.IdTB == id); if (tb != null) { db.THONGBAOs.Remove(tb); db.SaveChanges(); } return(RedirectToAction("Index")); } }
//POST: Admin/TheLoaiBaiViet/Sua public ActionResult Sua(THELOAIBAIVIET tlbv) { using (Web_KTCKEntities db = new Web_KTCKEntities()) { THELOAIBAIVIET theloaibv = db.THELOAIBAIVIETs.SingleOrDefault(n => n.IdTheLoai == tlbv.IdTheLoai); if (theloaibv != null) { theloaibv.TenTheLoai = tlbv.TenTheLoai; db.SaveChanges(); } return(RedirectToAction("Index")); } }
// GET: Admin/BinhLuan public ActionResult Index(int?page) { using (Web_KTCKEntities db = new Web_KTCKEntities()) { int itemPageSize = 30; int pageNumber = (page ?? 1); var tatcabl = db.BINHLUANs.ToList(); ViewBag.Count = tatcabl.Count; var dsbinhluan = db.BINHLUANs.OrderByDescending(n => n.NgayBinhLuan).ToPagedList(pageNumber, itemPageSize); ViewBag.IdTaiKhoan = new SelectList(db.TAIKHOANs.ToList(), "IdTK", "HoTen"); ViewBag.IdBaiViet = new SelectList(db.BAIVIETs.ToList(), "IdBV", "TieuDe"); return(View(dsbinhluan)); } }