public ActionResult Edit(FormCollection fc, CMS_News obj)
{
try
{
if (ModelState.IsValid)
{
CMS_News_DAO objDAO = new CMS_News_DAO();
CSF_Users_DAO objUserDao = new CSF_Users_DAO();
int userID = objUserDao.GetUserIDByUserName(HttpContext.User.Identity.Name);
obj.ID_USERMODIFY = userID;
bool update = false;
update = objDAO.Update(obj);
if (update)
{
SetAlert("Cập nhật tin tức thành công", AlertType.Success);
return(RedirectToAction("Index", "CMS_News"));
}
else
{
SetAlert("Cập nhật không thành công", AlertType.Error);
}
}
return(View(obj));
}
catch (Exception ex)
{
SetAlert("Lỗi" + ex.Message.ToString(), AlertType.Error);
Logs.WriteLog(ex);
return(View());
}
}
public ActionResult Create()
{
try
{
CMS_News_DAO objDAO = new CMS_News_DAO();
DT_WebGISEntities MVCContext = new DT_WebGISEntities();
//var listData = MVCContext.CMS_Categories.Where(x => x.PUBLISH == true).AsQueryable().Select(new x SubSelectBox { }).ToList();
List <SubSelectBox> listTree = new List <SubSelectBox>();
SubSelectBox sc;
var listData = (from a in MVCContext.CMS_Categories where a.PUBLISH == true select new SubSelectBox()
{
id = a.ID, name = a.NAME, parentid = (int)a.PARENTCATE
}).ToList();
var listData0 = listData.Where(x => x.parentid == 0).ToList();
string tag = "";
foreach (var item in listData0)
{
sc = new SubSelectBox();
sc.id = item.id;
sc.name = item.name;
listTree.Add(sc);
BuildSubTree(listTree, item.id, listData, tag);
}
TempData["categories"] = listTree;
TempData.Keep("categories");
return(View());
}
catch (Exception ex)
{
SetAlert("Lỗi" + ex.Message.ToString(), AlertType.Error);
Logs.WriteLog(ex);
return(View());
}
}
public ActionResult Create(FormCollection fc, CMS_News obj)
{
try
{
TempData.Keep("categories");
if (ModelState.IsValid)
{
CMS_News_DAO objDAO = new CMS_News_DAO();
CSF_Users_DAO objUserDao = new CSF_Users_DAO();
int userID = objUserDao.GetUserIDByUserName(HttpContext.User.Identity.Name);
obj.ID_USERCREATE = userID;
int ReturnID = objDAO.Insert(obj);
if (ReturnID > 0)
{
SetAlert("Thêm tin tức thành công", AlertType.Success);
return(RedirectToAction("Index", "CMS_News"));
}
else
{
ModelState.AddModelError("", "Thêm tin tức không thành công");
}
return(View("Index"));
}
return(View());
}
catch (Exception ex)
{
SetAlert("Lỗi" + ex.Message.ToString(), AlertType.Error);
Logs.WriteLog(ex);
return(View());
}
}
public JsonResult SetCongBo(string[] arrChecked, string[] checkedTieuDiem)
{
try
{
int ikq = 0;
string[] arrIDTinTuc = arrChecked;
string[] arrIDTinTucTieuDiem = checkedTieuDiem;
CMS_News_DAO objNewsDao = new CMS_News_DAO();
CMS_Approves_DAO objApproverDao = new CMS_Approves_DAO();
CMS_Approves objApp = new CMS_Approves();
int iIDNews = 0;
//int intRoleID = Convert.ToInt32(RoleID);
//int intUserID = 0;
//CSF_UserRole_DAO objUserRoleDAO = new CSF_UserRole_DAO();
if (arrIDTinTuc != null && arrIDTinTuc.Length > 0)
{
for (int i = 0; i < arrIDTinTuc.Length; i++)
{
Int16 iTieuDiem = 0;
if (arrIDTinTucTieuDiem != null && arrIDTinTucTieuDiem.Length > 0)
{
for (int j = 0; j < arrIDTinTucTieuDiem.Length; j++)
{
if (arrIDTinTuc[i].ToString() == arrIDTinTucTieuDiem[j].ToString())
{
iTieuDiem = 1;
break;
}
}
}
iIDNews = Convert.ToInt32(arrIDTinTuc[i].ToString());
objNewsDao.UpdateTrangThai(iIDNews, 5, iTieuDiem);
ikq = 1;
}
}
if (ikq > 0)
{
//cache lai tin bai
WebApp.Controllers.HomeController hController = new WebApp.Controllers.HomeController();
hController.Cache_TinBai();
return(Json(new { status = true, message = "Công bố tin tức thành công" }, JsonRequestBehavior.AllowGet));
}
else
{
return(Json(new { status = false, message = "Lỗi công bố tin tức" }, JsonRequestBehavior.AllowGet));
}
}
catch (Exception ex)
{
Logs.WriteLog(ex);
return(Json(new { status = false, message = "Lỗi: " + ex }, JsonRequestBehavior.AllowGet));
}
}
public void Cache_TinBai()
{
try
{
CMS_News_DAO objNewDao = new CMS_News_DAO();
MemoryCache objCache = MemoryCache.Default;
List <CMS_News_LayTinBaiCongKhaiTheoCateKey_Result> lstNews = objNewDao.LayTinBaiCongKhaiTheoCateKey("");
objCache.Remove("TinBai");
objCache.Add("TinBai", lstNews, DateTime.Now.AddDays(SoNgayCache));
}
catch (Exception ex)
{
Logs.WriteLog(ex);
}
}
public PartialViewResult ChuongTrinhDeTaiKhoaHoc(string title, string category)
{
try
{
ViewBag.TITLE = title;
CMS_News_DAO objNewDao = new CMS_News_DAO();
var listData = GetCacheTinBai().Where(s => s.CateKey == "chuong-trinh-de-tai-khoa-hoc").Take(5).ToList();
return(PartialView(listData));
}
catch (Exception ex)
{
Logs.WriteLog(ex);
return(PartialView());
}
}
public PartialViewResult ThongTinDuAnHangMuc(string title, string category)
{
try
{
ViewBag.TITLE = title;
CMS_News_DAO objNewDao = new CMS_News_DAO();
var listData = GetCacheTinBai().Where(s => s.CateKey == "du-an-hang-muc-dau-tu").Take(5).ToList();
return(PartialView(listData));
}
catch (Exception ex)
{
Logs.WriteLog(ex);
return(PartialView());
}
}
public PartialViewResult ThongTinCL_DH_QH_KH(string title, string category)
{
try
{
ViewBag.TITLE = title;
CMS_News_DAO objNewDao = new CMS_News_DAO();
var listData = GetCacheTinBai().Where(s => s.CateKey == "chien-luoc-quy-hoach-ke-hoach").Take(5).ToList();
return(PartialView(listData));
}
catch (Exception ex)
{
Logs.WriteLog(ex);
return(PartialView());
}
}
public PartialViewResult ThongTinTuyenTruyen(string title, string category)
{
try
{
ViewBag.TITLE = title;
CMS_News_DAO objNewDao = new CMS_News_DAO();
var listData = GetCacheTinBai().Where(s => s.CateKey == "thong-tin-tuyen-truyen").Take(5).ToList();
return(PartialView(listData));
}
catch (Exception ex)
{
Logs.WriteLog(ex);
return(PartialView());
}
}
public PartialViewResult ThongTinChiDaoDieuHanh(string title, string category)
{
try
{
ViewBag.TITLE = title;
CMS_News_DAO objNewDao = new CMS_News_DAO();
var listData = GetCacheTinBai().Where(s => s.CateKey == "chi-dao-dieu-hanh").Take(5).ToList();
return(PartialView(listData));
}
catch (Exception ex)
{
Logs.WriteLog(ex);
return(PartialView());
}
}
public PartialViewResult SliderNews(string title, string category)
{
try
{
ViewBag.TITLE = title;
CMS_News_DAO objNewDao = new CMS_News_DAO();
var listData = GetCacheTinBai().Where(s => s.ISFOCUS == 1).Where(s => s.CateKey == "tin-hoat-dong" || s.CateKey == "tin-chuyen-nganh" || s.CateKey == "tin-tuc-su-kien" || s.CateKey == "tin-cong-nghe" || s.CateKey == "su-kien").OrderByDescending(s => s.CREATEDATE).Take(5).ToList();
return(PartialView(listData));
}
catch (Exception ex)
{
Logs.WriteLog(ex);
return(PartialView());
}
}
public PartialViewResult TinTucSuKienNoiBat(string title, string category)
{
try
{
ViewBag.TITLE = title;
CMS_News_DAO objNewDao = new CMS_News_DAO();
var listData = GetCacheTinBai().Where(s => s.ISFOCUS == 1).OrderByDescending(s => s.CREATEDATE).Take(5).ToList();
return(PartialView(listData));
}
catch (Exception ex)
{
Logs.WriteLog(ex);
return(PartialView());
}
}
public JsonResult SetNgungCongBo(string[] arrChecked, string abc)
{
try
{
int ikq = 0;
string[] arrIDTinTuc = arrChecked;
CMS_News_DAO objNewsDao = new CMS_News_DAO();
CMS_Approves_DAO objApproverDao = new CMS_Approves_DAO();
CMS_Approves objApp = new CMS_Approves();
int iIDNews = 0;
if (arrIDTinTuc != null && arrIDTinTuc.Length > 0)
{
for (int i = 0; i < arrIDTinTuc.Length; i++)
{
iIDNews = Convert.ToInt32(arrIDTinTuc[i].ToString());
objNewsDao.UpdateTrangThai(iIDNews, 6, 0);
objApp.ID_News = iIDNews;
objApp.ID_News_Status = 6;
CSF_Users_DAO objUserDao = new CSF_Users_DAO();
int intUserID = objUserDao.GetUserIDByUserName(HttpContext.User.Identity.Name);
objApp.ID_User = intUserID;
objApp.Comment = abc;
ikq = objApproverDao.Insert(objApp);
}
}
if (ikq > 0)
{
//cache lai tin bai
WebApp.Controllers.HomeController hController = new WebApp.Controllers.HomeController();
hController.Cache_TinBai();
return(Json(new { status = true, message = "Ngừng công bố tin tức thành công" }, JsonRequestBehavior.AllowGet));
}
else
{
return(Json(new { status = false, message = "Lỗi ngừng công bố tin tức" }, JsonRequestBehavior.AllowGet));
}
}
catch (Exception ex)
{
Logs.WriteLog(ex);
return(Json(new { status = false, message = "Lỗi: " + ex }, JsonRequestBehavior.AllowGet));
}
}
public JsonResult SetDuyet(string[] arrChecked, string abc)
{
try
{
int ikq = 0;
string[] arrIDTinTuc = arrChecked;
CMS_News_DAO objNewsDao = new CMS_News_DAO();
CMS_Approves_DAO objApproverDao = new CMS_Approves_DAO();
CMS_Approves objApp = new CMS_Approves();
int iIDNews = 0;
//int intRoleID = Convert.ToInt32(RoleID);
//int intUserID = 0;
//CSF_UserRole_DAO objUserRoleDAO = new CSF_UserRole_DAO();
if (arrIDTinTuc != null && arrIDTinTuc.Length > 0)
{
for (int i = 0; i < arrIDTinTuc.Length; i++)
{
iIDNews = Convert.ToInt32(arrIDTinTuc[i].ToString());
objNewsDao.UpdateTrangThai(iIDNews, 4, 0);
objApp.ID_News = iIDNews;
objApp.ID_News_Status = 4;
CSF_Users_DAO objUserDao = new CSF_Users_DAO();
int intUserID = objUserDao.GetUserIDByUserName(HttpContext.User.Identity.Name);
objApp.ID_User = intUserID;
objApp.Comment = abc;
ikq = objApproverDao.Insert(objApp);
}
}
if (ikq > 0)
{
return(Json(new { status = true, message = "Duyệt tin tức thành công" }, JsonRequestBehavior.AllowGet));
}
else
{
return(Json(new { status = false, message = "Lỗi duyệt tin tức" }, JsonRequestBehavior.AllowGet));
}
}
catch (Exception ex)
{
Logs.WriteLog(ex);
return(Json(new { status = false, message = "Lỗi: " + ex }, JsonRequestBehavior.AllowGet));
}
}
public ActionResult Index(string keyWord, int?page)
{
try
{
keyWord = keyWord != null ? keyWord : "";
CMS_News_DAO objDAO = new CMS_News_DAO();
var data = objDAO.LayDanhSachDeCongBo(keyWord, 0);
ViewBag.SearchString = keyWord;
int pageSize = 10;
int pageNumber = (page ?? 1);
TempData["DsTinTucNgungCongBo"] = objDAO.Search(keyWord, 0, 5).ToList().ToPagedList(pageNumber, pageSize);
TempData.Keep("DsTinTucNgungCongBo");
return(View(data.ToPagedList(pageNumber, pageSize)));
}
catch (Exception ex)
{
SetAlert("Lỗi" + ex.Message.ToString(), "error");
Logs.WriteLog(ex);
return(View());
}
}
public JsonResult Delete(int id)
{
try
{
CMS_News_DAO objDAO = new CMS_News_DAO();
if (objDAO.Delete(id))
{
SetAlert("Xóa tin thành công", AlertType.Success);
return(Json(new { status = true, message = "" }, JsonRequestBehavior.AllowGet));
}
else
{
return(Json(new { status = false, message = "Lỗi xóa tin" }, JsonRequestBehavior.AllowGet));
}
}
catch (Exception ex)
{
Logs.WriteLog(ex);
return(Json(new { status = false, message = "Lỗi: " + ex }, JsonRequestBehavior.AllowGet));
}
}
public ActionResult DSNgungCongBo(string keyWord1, int?page1)
{
try
{
//int categoryID = category != null ? Convert.ToInt32(category) : 0;
keyWord1 = keyWord1 != null ? keyWord1 : "";
CMS_News_DAO objDAO = new CMS_News_DAO();
var data = objDAO.Search(keyWord1, 0, 5).ToList();
ViewBag.SearchString = keyWord1;
int pageSize1 = 10;
int pageNumber1 = (page1 ?? 1);
return(PartialView(data.ToPagedList(pageNumber1, pageSize1)));
}
catch (Exception ex)
{
SetAlert("Lỗi" + ex.Message.ToString(), "error");
Logs.WriteLog(ex);
return(PartialView());
}
}
public PartialViewResult TimKiem(string title, string category, string key, string type, int?page)
{
try
{
ViewBag.TITLE = title;
ViewBag.CATE = category;
int typeID = type != null?Convert.ToInt32(type) : 0;
key = key != null ? key : "";
CMS_News_DAO objDAO = new CMS_News_DAO();
var data = objDAO.Search(key, typeID, 5);
int pageSize = 10;
int pageNumber = (page ?? 1);
DT_WebGISEntities MyContext = new DT_WebGISEntities();
var listData = MyContext.CMS_Categories.Where(x => x.PUBLISH == true).ToList();
List <SubSelectBox> listCate = new List <SubSelectBox>();
SubSelectBox sc;
var listData0 = listData.Where(x => x.PARENTCATE == 0).OrderBy(x => x.ORDERS);
string tag = "";
foreach (var item in listData0)
{
sc = new SubSelectBox();
sc.id = item.ID;
sc.name = item.NAME;
listCate.Add(sc);
BuildSubCate(listCate, item.ID, listData, tag);
}
TempData["category"] = listCate;
TempData.Keep("category");
ViewBag.KEY = key;
ViewBag.TYPE = typeID;
return(PartialView(data.ToPagedList(pageNumber, pageSize)));
}
catch (Exception ex)
{
Logs.WriteLog(ex);
return(PartialView());
}
}
public PartialViewResult ChucNangNhiemVu(string title, string category)
{
try
{
ViewBag.CategoryTitle = title;
CMS_News_DAO objNewDao = new CMS_News_DAO();
List <CMS_News_LayTinBaiCongKhaiTheoCateKey_Result> lstGioiThieu = new List <CMS_News_LayTinBaiCongKhaiTheoCateKey_Result>();
lstGioiThieu = objHomeController.GetCacheTinBai().Where(s => s.CateKey == category).ToList();
if (lstGioiThieu != null && lstGioiThieu.Count > 0)
{
ViewBag.TITLE = lstGioiThieu[0].TITLE;
ViewBag.EXCERPT = lstGioiThieu[0].EXCERPT;
ViewBag.CONTENTS = lstGioiThieu[0].CONTENTS;
}
return(PartialView());
}
catch (Exception ex)
{
Logs.WriteLog(ex);
return(PartialView());
}
}
public ActionResult Index(string keyWord, string category, string newsStatus, int?page)
{
try
{
int categoryID = category != null?Convert.ToInt32(category) : 0;
int newsStatusID = newsStatus != null?Convert.ToInt32(newsStatus) : 0;
keyWord = keyWord != null ? keyWord : "";
CMS_News_DAO objDAO = new CMS_News_DAO();
var data = objDAO.Search(keyWord, categoryID, 2);
ViewBag.SearchString = keyWord;
int pageSize = 10;
int pageNumber = (page ?? 1);
return(View(data.ToPagedList(pageNumber, pageSize)));
}
catch (Exception ex)
{
SetAlert("Lỗi" + ex.Message.ToString(), "error");
Logs.WriteLog(ex);
return(View());
}
}
