public ActionResult Index(string keyWord, string type, string area, string org, int?page)
{
try
{
int typeID = type != null?Convert.ToInt32(type) : 0;
int areaID = area != null?Convert.ToInt32(area) : 0;
int orgID = org != null?Convert.ToInt32(org) : 0;
keyWord = keyWord != null ? keyWord : "";
CMS_Documents_DAO objDAO = new CMS_Documents_DAO();
var data = objDAO.Search(keyWord, typeID, areaID, orgID);
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());
}
}
public ActionResult ThongKeVanBan(string keyWord, string type, string area, string org, int?page)
{
try
{
DT_WebGISEntities MVCContext = new DT_WebGISEntities();
TempData["TypeOfDocumentID"] = MVCContext.CMS_TypeOfDocument.ToList();
TempData.Keep("TypeOfDocumentID");
TempData["AreaOfDocument"] = MVCContext.CMS_AreaOfDocument.ToList();
TempData.Keep("AreaOfDocument");
TempData["OrganizationID"] = MVCContext.CMS_Organization.ToList();
TempData.Keep("OrganizationID");
int typeID = Convert.ToInt32(type);
int areaID = Convert.ToInt32(area);
int orgID = Convert.ToInt32(org);
keyWord = keyWord != null ? keyWord : "";
CMS_Documents_DAO objDAO = new CMS_Documents_DAO();
var data = objDAO.Search(keyWord, typeID, areaID, orgID).Where(x => x.Publish == true);
ViewBag.SearchString = keyWord;
ViewBag.TYPE = type;
ViewBag.AREA = area;
ViewBag.ORG = org;
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());
}
}
public void Cache_VanBan()
{
try
{
CMS_Documents_DAO objDAO = new CMS_Documents_DAO();
MemoryCache objCache = MemoryCache.Default;
List <CMS_Documents_LayTatCa_Result> lstNews = objDAO.Search("", 0, 0, 0).Where(s => s.Publish == true).ToList();
objCache.Remove("VanBan");
objCache.Add("VanBan", lstNews, DateTime.Now.AddDays(SoNgayCache));
}
catch (Exception ex)
{
Logs.WriteLog(ex);
}
}
public ActionResult export_excel(FormCollection fc)
{
try
{
DT_WebGISEntities MyContext = new DT_WebGISEntities();
CMS_Documents_DAO objDAO = new CMS_Documents_DAO();
int typeID = fc["type_excel"].ToString() != "" ? Convert.ToInt32(fc["type_excel"].ToString()) : 0;
int areaID = fc["area_excel"].ToString() != "" ? Convert.ToInt32(fc["area_excel"].ToString()) : 0;
int orgID = fc["org_excel"].ToString() != "" ? Convert.ToInt32(fc["org_excel"].ToString()) : 0;
string keyWord = fc["key_excel"].ToString();
var data = objDAO.Search(keyWord, typeID, areaID, orgID).Where(x => x.Publish == true).ToList();
MemoryStream stream = new MemoryStream();
using (SpreadsheetDocument spreadsheetDoc = SpreadsheetDocument.Create(stream, SpreadsheetDocumentType.Workbook))
{
CWorkbook workbook = new CWorkbook(spreadsheetDoc);
string sheetName = "ThongKe";
CSheet sheetLH = createSheet(spreadsheetDoc, workbook, sheetName, data);
sheetLH._worksheetPart.Worksheet.Save();
}
string fileName = "ThongKeVanBan.xlsx";
var contentType = "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet";
Response.Clear();
Response.ContentType = contentType;
string contentDisposition = "attachment; filename*=UTF-8''" + Uri.EscapeDataString(fileName);
Response.AddHeader("content-disposition", contentDisposition);
Response.AddHeader("Content-Length", stream.Length.ToString());
Response.Cache.SetCacheability(HttpCacheability.NoCache);
Response.BinaryWrite(stream.ToArray());
Response.Flush();
Response.SuppressContent = true;
System.Web.HttpContext.Current.ApplicationInstance.CompleteRequest();
return(View());
}
catch (Exception ex)
{
SetAlert("Lỗi" + ex.Message.ToString(), "error");
Logs.WriteLog(ex);
return(View());
}
}