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