public IActionResult SaveItem(string Id = null)
{
ArticlesModel data = new ArticlesModel();
string ControllerName = this.ControllerContext.RouteData.Values["controller"].ToString() + "_" + HttpContext.Request.Headers["UserName"];
int IdDC = Int32.Parse(MyModels.Decode(Id, API.Models.Settings.SecretId + ControllerName).ToString());
data.SearchData = new SearchArticles()
{
CurrentPage = 0, ItemsPerPage = 10, Keyword = ""
};
data.ListItemsDanhMuc = CategoriesArticlesService.GetListItems();
data.ListItemsAuthors = API.Areas.Admin.Models.USUsers.USUsersService.GetListItemsAuthor(4);
data.ListItemType = ArticlesService.GetListItemsType();
Articles Item = new Articles()
{
PublishUp = DateTime.Now, PublishUpShow = DateTime.Now.ToString("dd/MM/yyyy"), Status = true
};
if (IdDC > 0)
{
Item = ArticlesService.GetItem(IdDC, API.Models.Settings.SecretId + ControllerName);
}
data.Item = Item;
return(View(data));
}
public IActionResult Index([FromQuery] SearchArticles dto)
{
int TotalItems = 0;
string ControllerName = this.ControllerContext.RouteData.Values["controller"].ToString() + "_" + HttpContext.Request.Headers["UserName"];
dto.IdCoQuan = int.Parse(HttpContext.Request.Headers["IdCoQuan"]);
ArticlesModel data = new ArticlesModel()
{
SearchData = dto
};
data.ListItems = ArticlesService.GetListPagination(data.SearchData, API.Models.Settings.SecretId + ControllerName);
data.ListItemsDanhMuc = CategoriesArticlesService.GetListItems();
data.ListItemsAuthors = API.Areas.Admin.Models.USUsers.USUsersService.GetListItemsAuthor(4);
data.ListItemsCreatedBy = API.Areas.Admin.Models.USUsers.USUsersService.GetListItemsAuthor(3);
data.ListItemsStatus = ArticlesService.GetListItemsStatus();
if (data.ListItems != null && data.ListItems.Count() > 0)
{
TotalItems = data.ListItems[0].TotalRows;
}
HttpContext.Session.SetString("STR_Action_Link_" + ControllerName, Request.QueryString.ToString());
data.Pagination = new Models.Partial.PartialPagination()
{
CurrentPage = data.SearchData.CurrentPage, ItemsPerPage = data.SearchData.ItemsPerPage, TotalItems = TotalItems, QueryString = Request.QueryString.ToString()
};
return(View(data));
}
public async Task <ActionResult> SaveItem(Articles data)
{
ArticlesModel model = new ArticlesModel()
{
Item = data
};
string ControllerName = this.ControllerContext.RouteData.Values["controller"].ToString() + "_" + HttpContext.Request.Headers["UserName"];
int IdDC = Int32.Parse(MyModels.Decode(model.Item.Ids, API.Models.Settings.SecretId + ControllerName).ToString());
if (ModelState.IsValid)
{
if (data.Alias == null || data.Alias == "")
{
model.Item.Alias = API.Models.MyHelper.StringHelper.UrlFriendly(data.Title);
}
if (model.Item.Icon != null)
{
var Image = await FileHelpers.ProcessFormFile(model.Item.Icon, ModelState);
if (Image.Length > 0)
{
model.Item.Images = Image;
}
}
if (model.Item.Id == IdDC)
{
model.Item.CreatedBy = int.Parse(HttpContext.Request.Headers["Id"]);
model.Item.ModifiedBy = int.Parse(HttpContext.Request.Headers["Id"]);
model.Item.IdCoQuan = int.Parse(HttpContext.Request.Headers["IdCoQuan"]);
try
{
ArticlesService.SaveItem(model.Item);
TempData["MessageSuccess"] = "Cập nhật thành công";
string Str_Url = HttpContext.Session.GetString("STR_Action_Link_" + ControllerName);
if (Str_Url != null && Str_Url != "")
{
return(Redirect("/Admin/" + this.ControllerContext.RouteData.Values["controller"].ToString() + "/Index" + Str_Url));
}
else
{
return(RedirectToAction("Index"));
}
}
catch
{
}
}
}
model.SearchData = new SearchArticles()
{
CurrentPage = 0, ItemsPerPage = 10, Keyword = ""
};
model.ListItemsDanhMuc = CategoriesArticlesService.GetListItems();
model.ListItemsAuthors = API.Areas.Admin.Models.USUsers.USUsersService.GetListItemsAuthor(4);
model.ListItemType = ArticlesService.GetListItemsType();
return(View(model));
}
public IActionResult Detail(string alias, int id)
{
ArticlesModel data = new ArticlesModel();
string ControllerName = this.ControllerContext.RouteData.Values["controller"].ToString();
data.SearchData = new SearchArticles()
{
CurrentPage = 0, ItemsPerPage = 10, Keyword = ""
};
data.ListItemsDanhMuc = CategoriesArticlesService.GetListItems();
data.Item = ArticlesService.GetItem(id, API.Models.Settings.SecretId + ControllerName);
CategoriesArticles categories = CategoriesArticlesService.GetItem(data.Item.CatId);
var hit = ArticlesService.UpdateHit(id);
data.Categories = categories;
if (categories.Id != 0)
{
data.ListItems = ArticlesService.GetListRelativeNews(alias, categories.Id);
}
return(View(data));
}
public IActionResult SaveItem(string Id = null)
{
CategoriesArticlesModel data = new CategoriesArticlesModel();
string ControllerName = this.ControllerContext.RouteData.Values["controller"].ToString();
int IdDC = Int32.Parse(MyModels.Decode(Id, API.Models.Settings.SecretId + ControllerName).ToString());
data.ListItemsDanhMuc = CategoriesArticlesService.GetListItems();
data.SearchData = new SearchCategoriesArticles()
{
CurrentPage = 0, ItemsPerPage = 10, Keyword = ""
};
if (IdDC == 0)
{
data.Item = new CategoriesArticles();
}
else
{
data.Item = CategoriesArticlesService.GetItem(IdDC, API.Models.Settings.SecretId + ControllerName);
}
return(View(data));
}
public async Task <ActionResult> SaveItem(CategoriesArticlesModel model)
{
string ControllerName = this.ControllerContext.RouteData.Values["controller"].ToString();
int IdDC = Int32.Parse(MyModels.Decode(model.Item.Ids, API.Models.Settings.SecretId + ControllerName).ToString());
CategoriesArticlesModel data = model;
if (ModelState.IsValid)
{
if (model.Item.Icon != null)
{
var Image =
await FileHelpers.ProcessFormFile(model.Item.Icon, ModelState);
if (Image.Length > 0)
{
model.Item.Images = Image;
}
}
if (model.Item.Id == IdDC)
{
model.Item.CreatedBy = int.Parse(HttpContext.Request.Headers["Id"]);
model.Item.ModifiedBy = int.Parse(HttpContext.Request.Headers["Id"]);
var Obj = CategoriesArticlesService.SaveItem(model.Item);
if (Obj.N == -2)
{
TempData["MessageError"] = "Chọn danh mục cha không hợp lệ";
data.ListItemsDanhMuc = CategoriesArticlesService.GetListItems();
return(View(data));
}
TempData["MessageSuccess"] = "Cập nhật thành công";
return(RedirectToAction("Index"));
}
}
data.ListItemsDanhMuc = CategoriesArticlesService.GetListItems();
return(View(data));
}
public IActionResult Index([FromQuery] SearchArticles dto, string btn = "search")
{
int TotalItems = 0;
string ControllerName = this.ControllerContext.RouteData.Values["controller"].ToString() + "_" + HttpContext.Request.Headers["UserName"];
dto.IdCoQuan = int.Parse(HttpContext.Request.Headers["IdCoQuan"]);
ArticlesModel data = new ArticlesModel()
{
SearchData = dto
};
data.SearchData.ItemsPerPage = 50;
data.ListItems = ArticlesService.GetListReport(data.SearchData, API.Models.Settings.SecretId + ControllerName);
data.ListItemsDanhMuc = CategoriesArticlesService.GetListItems();
data.ListItemsAuthors = API.Areas.Admin.Models.USUsers.USUsersService.GetListItemsAuthor(4);
data.ListItemsCreatedBy = API.Areas.Admin.Models.USUsers.USUsersService.GetListAll();
data.ListItemType = ArticlesService.GetListItemsType(true);
if (data.ListItems != null && data.ListItems.Count() > 0)
{
TotalItems = data.ListItems[0].TotalRows;
}
HttpContext.Session.SetString("STR_Action_Link_" + ControllerName, Request.QueryString.ToString());
data.Pagination = new Models.Partial.PartialPagination()
{
CurrentPage = data.SearchData.CurrentPage, ItemsPerPage = data.SearchData.ItemsPerPage, TotalItems = TotalItems, QueryString = Request.QueryString.ToString()
};
//--Xuất excel
if (btn == "excel")
{
try
{
// var l = ThongKeRepository.GetList(page, 50000, ArticleCatId, login.Role, ListCheck, tungay, denngay);
var workbook = new XLWorkbook();
var ws = workbook.Worksheets.Add("DanhSach");
int i = 1;
ws.Cell("A1").Value = "STT";
ws.Cell("B1").Value = "Tên bài viết";
ws.Cell("C1").Value = "Ngày đăng";
ws.Cell("D1").Value = "Người đăng";
ws.Cell("E1").Value = "Loại tin bài";
ws.Cell("F1").Value = "Danh mục";
ws.Cell("G1").Value = "Nguồn";
var rngTable = ws.Range("A1:G1");
rngTable.Style.Font.Bold = true;
var search2 = data.SearchData;
search2.ItemsPerPage = 100000;
var l = ArticlesService.GetListReport(search2, API.Models.Settings.SecretId + ControllerName);
foreach (var item in l)
{
i++;
ws.Cell("A" + i).Value = i - 1;;
ws.Cell("B" + i).Value = item.Title;
ws.Cell("C" + i).Value = "Ngày: " + DateTime.Parse(item.CreatedDate.ToString()).ToString("dd/MM/yyyy HH:mm:ss");
ws.Cell("D" + i).Value = item.CreatedByName;
ws.Cell("E" + i).Value = (item.TypeId == 1 ? "Tin tự biên tập" : "Tin đăng lại");
ws.Cell("F" + i).Value = item.Category;
ws.Cell("G" + i).Value = item.SourceLink;
}
ws.Columns().AdjustToContents();
var path = Path.Combine(_hostingEnvironment.WebRootPath, "CMS");
var filename = "ThongKe_" + DateTime.Now.Ticks + ".xlsx";
workbook.SaveAs(System.IO.Path.Combine(path, filename));
string filepath = Path.Combine(path, filename);
FileInfo file = new FileInfo(filepath);
if (file.Exists)
{
byte[] fileBytes = System.IO.File.ReadAllBytes(filepath);
return(File(fileBytes, "application/x-msdownload", filename));
//System.IO.File.Delete(filepath);
}
}
catch (Exception e)
{
return(View(data));
}
}
return(View(data));
}