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