public ActionResult PopulateSearchFilteredMap(string[] region, string[] country, string[] sector, string[] document) { SearchMapModel model = new SearchMapModel(); model.PopulateCountryWithRecordsbySearchFilter(region, country, sector, document); return(View("~/Views/Shared/PartialViews/Home/_WorldMapFilter.cshtml", model)); }
/// <summary> /// Get Country with records -- by Selected Filter /// </summary> /// <returns></returns> public ActionResult GetCountryWithRecordsbySearchFilter() { SearchMapModel model = new SearchMapModel(); //model.PopulateCountryWithRecordsbySearchFilter(); JavaScriptSerializer serializer = new JavaScriptSerializer(); string json = serializer.Serialize(model.CountryRecords); return(Content(json)); }
public ActionResult PopulateSearchFilteredMap(string[] region, string[] country, string[] sector, string[] document, string[] year, string[] period, string[] last_Update, string[] counterpart, string[] DocCheckboxData, string[] thematicCheckboxData, string[] designProcessCheckboxData) { SearchMapModel model = new SearchMapModel(); model.PopulateCountryWithRecordsbySearchFilter(region, country, sector, document, year, period, last_Update, counterpart, DocCheckboxData, thematicCheckboxData, designProcessCheckboxData); return(View("~/Views/Shared/PartialViews/search/_Worldmap.cshtml", model)); }
public ActionResult PopulateAdvanceSearchFilter(string[] region, string[] country, string[] sector, string[] document, string[] year, string[] period, string[] last_Update, string[] counterpart, string[] DocCheckboxData, string[] thematicCheckboxData, string[] designProcessCheckboxData, string[] pagesize, string[] page, int?sortColumnIndex, int?sortDirection) { SearchMapModel model = new SearchMapModel(); #region [Page] int pageSize = 5; if (pagesize != null) { int.TryParse(pagesize[0], out pageSize); } int Pages = 1; if (page != null) { int.TryParse(page[0], out Pages); } #endregion SearchAttributes searchParam = new SearchAttributes(); searchParam.CurrentPageNumber = Pages; // searchParam.RecordsPerPage = AppSettingsUtility.GetInt(AppSettingsKeys.RecordsPerPage); searchParam.RecordsPerPage = pageSize; if (sortColumnIndex.HasValue) { searchParam.SortColumnIndex = sortColumnIndex.Value; } else { searchParam.SortColumnIndex = 1; } searchParam.SortDirection = (sortDirection.HasValue && sortDirection.Value == 1) ? Entity.SortDirection.Descending : Entity.SortDirection.Ascending; model.SearchParam = searchParam; model.PageSize = pageSize; List <RecordData> recordDataList = new List <RecordData>(); model.GetFilterRecordInformation(region, country, sector, document, year, period, last_Update, counterpart, DocCheckboxData, thematicCheckboxData, designProcessCheckboxData, pageSize, searchParam, sortColumnIndex, sortDirection, out recordDataList); return(View("~/Views/Shared/PartialViews/search/_RecordFilter.cshtml", model)); }
public ActionResult ExportPDF(string[] region, string[] country, string[] sector, string[] document, string[] year, string[] period, string[] last_Update, string[] counterpart, string[] DocCheckboxData, string[] thematicCheckboxData, string[] designProcessCheckboxData, string[] pagesize, string[] page, int?sortColumnIndex, int?sortDirection, string filetype) { SearchMapModel model = new SearchMapModel(); #region [Page] int pageSize = 20000; //if (pagesize != null) //{ // int.TryParse(pagesize[0], out pageSize); //} int Pages = 1; if (page != null) { int.TryParse(page[0], out Pages); } #endregion SearchAttributes searchParam = new SearchAttributes(); searchParam.CurrentPageNumber = Pages; // searchParam.RecordsPerPage = AppSettingsUtility.GetInt(AppSettingsKeys.RecordsPerPage); searchParam.RecordsPerPage = pageSize; if (sortColumnIndex.HasValue) { searchParam.SortColumnIndex = sortColumnIndex.Value; } else { searchParam.SortColumnIndex = 1; } searchParam.SortDirection = (sortDirection.HasValue && sortDirection.Value == 1) ? Entity.SortDirection.Descending : Entity.SortDirection.Ascending; model.SearchParam = searchParam; List <ExportRecordData> exportRecordData = new List <ExportRecordData>(); exportRecordData = model.GetExportFilteredData(region, country, sector, document, year, period, last_Update, counterpart, DocCheckboxData, thematicCheckboxData, designProcessCheckboxData, pageSize, model.SearchParam, sortColumnIndex, sortDirection); ExportList <ExportRecordData> exp = new ExportList <ExportRecordData>(); string filePathExport = string.Empty; exp.PathTemplateFolder = Server.MapPath("~/ExportTemplates/"); if (filetype == "excel") { filePathExport = Server.MapPath("~/ExportFiles/" + DateTime.Now.Ticks + ".xlsx"); exp.ExportTo(exportRecordData, ExportToFormat.Excel2007, filePathExport); } else if (filetype == "pdf") { filePathExport = Server.MapPath("~/ExportFiles/" + DateTime.Now.Ticks + ".csv"); exp.ExportTo(exportRecordData, ExportToFormat.CSV, filePathExport); } else if (filetype == "csv") { filePathExport = Server.MapPath("~/ExportFiles/" + DateTime.Now.Ticks + ".csv"); exp.ExportTo(exportRecordData, ExportToFormat.CSV, filePathExport); } else { filePathExport = Server.MapPath("~/ExportFiles/" + DateTime.Now.Ticks + ".csv"); exp.ExportTo(exportRecordData, ExportToFormat.CSV, filePathExport); } //return this.File(filePathExport, "application/octet-stream", System.IO.Path.GetFullPath(filePathExport)); return(Json(new { fileurl = "/ExportFiles/" + System.IO.Path.GetFileName(filePathExport) }, JsonRequestBehavior.AllowGet)); }