/// <summary>
/// Export grid
/// </summary>
/// <typeparam name="T"></typeparam>
/// <param name="data"></param>
/// <param name="mode"></param>
/// <returns></returns>
public List <T> Export <T>(IQueryable <T> data, GridExportMode mode)
{
var exportData = new List <T>();
switch (mode)
{
case GridExportMode.All:
{
exportData = data.ToList();
break;
}
case GridExportMode.CurrentSearch:
{
exportData = Search(data, false).rows.Cast <T>().ToList();
break;
}
case GridExportMode.CurrentPage:
{
exportData = Search(data).rows.Cast <T>().ToList();
break;
}
}
return(exportData);
}
/// <summary>
/// Export notified contacts
/// </summary>
/// <param name="si"></param>
/// <param name="gridExportMode"></param>
/// <param name="notificationId"></param>
/// <returns></returns>
public HSSFWorkbook ExportsNotifiedContacts(JqSearchIn si, GridExportMode gridExportMode, int notificationId)
{
var notifiedContacts = SearchNotifiedContacts(notificationId);
var exportData = si.Export(notifiedContacts, gridExportMode);
return(ExcelUtilities.CreateWorkBook(exportData));
}
/// <summary>
/// Export notification templates
/// </summary>
/// <param name="si"></param>
/// <param name="gridExportMode"></param>
/// <returns></returns>
public HSSFWorkbook Exports(JqSearchIn si, GridExportMode gridExportMode)
{
var notificationTemplates = SearchNotificationTemplates();
var exportData = si.Export(notificationTemplates, gridExportMode);
return(ExcelUtilities.CreateWorkBook(exportData));
}
/// <summary>
/// Export Plugins
/// </summary>
/// <param name="si"></param>
/// <param name="gridExportMode"></param>
/// <returns></returns>
public HSSFWorkbook Exports(JqSearchIn si, GridExportMode gridExportMode)
{
var plugins = GetAll().AsQueryable();
var exportData = si.Export(plugins, gridExportMode);
return(ExcelUtilities.CreateWorkBook(exportData));
}
/// <summary>
/// Export form component templates
/// </summary>
/// <param name="si"></param>
/// <param name="gridExportMode"></param>
/// <returns></returns>
public ActionResult Exports(JqSearchIn si, GridExportMode gridExportMode)
{
var workbook = _formComponentTemplateService.Exports(si, gridExportMode);
var output = new MemoryStream();
workbook.Write(output);
return File(output.ToArray(), "application/vnd.ms-excel", "FormComponentTemplates.xls");
}
/// <summary>
/// Export FavouriteNavigations
/// </summary>
/// <param name="si"></param>
/// <param name="gridExportMode"></param>
/// <returns></returns>
public ActionResult Exports(JqSearchIn si, GridExportMode gridExportMode)
{
var workbook = _favouriteNavigationService.Exports(si, gridExportMode);
var output = new MemoryStream();
workbook.Write(output);
return(File(output.ToArray(), "application/vnd.ms-excel", "FavouriteNavigations.xls"));
}
/// <summary>
/// Export localized resources
/// </summary>
/// <param name="si"></param>
/// <param name="model"></param>
/// <param name="gridExportMode"></param>
/// <returns></returns>
public HSSFWorkbook Exports(JqSearchIn si, GridExportMode gridExportMode, LocalizedResourceSearchModel model)
{
var data = gridExportMode == GridExportMode.All ? GetAll() : SearchLocalizedResources(model);
var localizedResources = Maps(data);
var exportData = si.Export(localizedResources, gridExportMode);
return(ExcelUtilities.CreateWorkBook(exportData));
}
/// <summary>
/// Export EventSchedules
/// </summary>
/// <param name="si"></param>
/// <param name="gridExportMode"></param>
/// <param name="eventId"></param>
/// <returns></returns>
public HSSFWorkbook Exports(JqSearchIn si, GridExportMode gridExportMode, int?eventId)
{
var data = gridExportMode == GridExportMode.All ? GetAll() : SearchEventSchedules(eventId);
var eventSchedules = Maps(data);
var exportData = si.Export(eventSchedules, gridExportMode);
return(ExcelUtilities.CreateWorkBook(exportData));
}
/// <summary>
/// Export templates
/// </summary>
/// <param name="si"></param>
/// <param name="model"></param>
/// <param name="gridExportMode"></param>
/// <returns></returns>
public HSSFWorkbook Exports(JqSearchIn si, GridExportMode gridExportMode, WidgetTemplateSearchModel model)
{
var data = gridExportMode == GridExportMode.All ? GetAll() : SearchTemplates(model);
var templates = Maps(data);
var exportData = si.Export(templates, gridExportMode);
return(ExcelUtilities.CreateWorkBook(exportData));
}
/// <summary>
/// Export link trackers
/// </summary>
/// <param name="si"></param>
/// <param name="searchModel"></param>
/// <param name="gridExportMode"></param>
/// <returns></returns>
public HSSFWorkbook Exports(JqSearchIn si, GridExportMode gridExportMode, LinkTrackerSearchModel searchModel)
{
var data = gridExportMode == GridExportMode.All ? GetAll() : SearchLinkTrackers(searchModel);
var linkTrackers = Maps(data, searchModel);
var exportData = si.Export(linkTrackers, gridExportMode);
return(ExcelUtilities.CreateWorkBook(exportData));
}
/// <summary>
/// Export link tracker clicks
/// </summary>
/// <param name="si"></param>
/// <param name="gridExportMode"></param>
/// <param name="linkTrackerId"></param>
/// <returns></returns>
public ActionResult Exports(JqSearchIn si, GridExportMode gridExportMode, int?linkTrackerId)
{
var workbook = _linkTrackerClickService.Exports(si, gridExportMode, linkTrackerId);
var output = new MemoryStream();
workbook.Write(output);
return(File(output.ToArray(), "application/vnd.ms-excel", "LinkTrackerClicks.xls"));
}
/// <summary>
/// Export form component fields
/// </summary>
/// <param name="si"></param>
/// <param name="gridExportMode"></param>
/// <param name="formComponentId"></param>
/// <returns></returns>
public ActionResult Exports(JqSearchIn si, GridExportMode gridExportMode, int?formComponentId)
{
var workbook = _formComponentFieldService.Exports(si, gridExportMode, formComponentId);
var output = new MemoryStream();
workbook.Write(output);
return(File(output.ToArray(), "application/vnd.ms-excel", "FormComponentFields.xls"));
}
/// <summary>
/// Export poll answers
/// </summary>
/// <param name="si"></param>
/// <param name="gridExportMode"></param>
/// <param name="model"></param>
/// <returns></returns>
public HSSFWorkbook Exports(JqSearchIn si, GridExportMode gridExportMode, PollAnswerSearchModel model)
{
var data = gridExportMode == GridExportMode.All ? GetAll() : SearchPollAnswers(model);
var pollAnswers = Maps(data);
var exportData = si.Export(pollAnswers, gridExportMode);
return(ExcelUtilities.CreateWorkBook(exportData));
}
/// <summary>
/// Export user groups
/// </summary>
/// <param name="si"></param>
/// <param name="gridExportMode"></param>
/// <param name="userId"></param>
/// <returns></returns>
public ActionResult ExportsUserGroupsOfUser(JqSearchIn si, GridExportMode gridExportMode, int userId)
{
var workbook = _userGroupService.ExportsUserGroupsOfUser(si, gridExportMode, userId);
var output = new MemoryStream();
workbook.Write(output);
return(File(output.ToArray(), "application/vnd.ms-excel", "UserGroups.xls"));
}
/// <summary>
/// Export rotating image groups
/// </summary>
/// <param name="si"></param>
/// <param name="gridExportMode"></param>
/// <returns></returns>
public ActionResult Exports(JqSearchIn si, GridExportMode gridExportMode)
{
var workbook = _rotatingImageGroupService.Exports(si, gridExportMode);
var output = new MemoryStream();
workbook.Write(output);
return(File(output.ToArray(), "application/vnd.ms-excel", "RotatingImageGroups.xls"));
}
/// <summary>
/// Export slide in helps
/// </summary>
/// <param name="si"></param>
/// <param name="gridExportMode"></param>
/// <param name="languageId"></param>
/// <returns></returns>
public ActionResult Exports(JqSearchIn si, GridExportMode gridExportMode, int languageId)
{
var workbook = _slideInHelpService.Exports(si, gridExportMode, languageId);
var output = new MemoryStream();
workbook.Write(output);
return(File(output.ToArray(), "application/vnd.ms-excel", "SlideInHelps.xls"));
}
/// <summary>
/// Export remote authenticate configurations
/// </summary>
/// <param name="si"></param>
/// <param name="gridExportMode"></param>
/// <returns></returns>
public HSSFWorkbook Exports(JqSearchIn si, GridExportMode gridExportMode)
{
var data = GetAll();
var remoteAuthentications = Maps(data);
var exportData = si.Export(remoteAuthentications, gridExportMode);
return(ExcelUtilities.CreateWorkBook(exportData));
}
/// <summary>
/// Export Social Media Logs
/// </summary>
/// <returns></returns>
public ActionResult Exports(JqSearchIn si, int?socialMediaTokenId, GridExportMode gridExportMode, int?socialMediaId)
{
var workbook = _socialMediaLogService.Exports(si, gridExportMode, socialMediaTokenId, socialMediaId);
var output = new MemoryStream();
workbook.Write(output);
return(File(output.ToArray(), "application/vnd.ms-excel", "SocialMediaLogs.xls"));
}
/// <summary>
/// Export event categories
/// </summary>
/// <param name="si"></param>
/// <param name="gridExportMode"></param>
/// <param name="eventId"></param>
/// <returns></returns>
public ActionResult Exports(JqSearchIn si, GridExportMode gridExportMode, int?eventId)
{
var workbook = _eventCategoryService.Exports(si, gridExportMode, eventId);
var output = new MemoryStream();
workbook.Write(output);
return(File(output.ToArray(), "application/vnd.ms-excel", "EventCategories.xls"));
}
/// <summary>
/// Export the slide in helps
/// </summary>
/// <param name="si"></param>
/// <param name="gridExportMode"></param>
/// <param name="languageId"></param>
/// <returns></returns>
public HSSFWorkbook Exports(JqSearchIn si, GridExportMode gridExportMode, int languageId)
{
var data = gridExportMode == GridExportMode.All ? GetAll() : SearchSlideInHelps(languageId);
var slideInHelps = Maps(data);
var exportData = si.Export(slideInHelps, gridExportMode);
return(ExcelUtilities.CreateWorkBook(exportData));
}
/// <summary>
/// Export link trackers
/// </summary>
/// <param name="si"></param>
/// <param name="gridExportMode"></param>
/// <param name="pageId"></param>
/// <returns></returns>
public HSSFWorkbook ExportsLinkTrackersByPage(JqSearchIn si, GridExportMode gridExportMode, int pageId)
{
var data = gridExportMode == GridExportMode.All ? GetAll() : SearchLinkTrackers(pageId);
var linkTrackers = Maps(data, new LinkTrackerSearchModel());
var exportData = si.Export(linkTrackers, gridExportMode);
return(ExcelUtilities.CreateWorkBook(exportData));
}
/// <summary>
/// Export email accounts
/// </summary>
/// <param name="si"></param>
/// <param name="gridExportMode"></param>
/// <returns></returns>
public HSSFWorkbook Exports(JqSearchIn si, GridExportMode gridExportMode)
{
var data = GetAll();
var emailAccounts = Maps(data);
var exportData = si.Export(emailAccounts, gridExportMode);
return(ExcelUtilities.CreateWorkBook(exportData));
}
/// <summary>
/// Export page reads
/// </summary>
/// <param name="si"></param>
/// <param name="model"></param>
/// <param name="gridExportMode"></param>
/// <returns></returns>
public ActionResult Exports(JqSearchIn si, GridExportMode gridExportMode, PageReadSearchModel model)
{
var workbook = _pageReadService.Exports(si, gridExportMode, model);
var output = new MemoryStream();
workbook.Write(output);
return(File(output.ToArray(), "application/vnd.ms-excel", "PageReads.xls"));
}
/// <summary>
/// Export contacts of user
/// </summary>
/// <param name="si"></param>
/// <param name="gridExportMode"></param>
/// <param name="userId"></param>
/// <returns></returns>
public HSSFWorkbook ExportsContactsByUser(JqSearchIn si, GridExportMode gridExportMode, int userId)
{
var data = gridExportMode == GridExportMode.All ? GetAll() : SearchContactsByUser(userId);
var contacts = Maps(data);
var exportData = si.Export(contacts, gridExportMode);
return(ExcelUtilities.CreateWorkBook(exportData));
}
/// <summary>
/// Export the widgets
/// </summary>
/// <param name="si"></param>
/// <param name="gridExportMode"></param>
/// <param name="model"></param>
/// <returns></returns>
public HSSFWorkbook Exports(JqSearchIn si, GridExportMode gridExportMode, WidgetSearchModel model)
{
var data = gridExportMode == GridExportMode.All ? GetAllWidgets() : SearchWidgets(model);
var widgets = data.AsQueryable();
var exportData = si.Export(widgets, gridExportMode);
return(ExcelUtilities.CreateWorkBook(exportData));
}
/// <summary>
/// Export the anonymous contacts
/// </summary>
/// <param name="si"></param>
/// <param name="model"></param>
/// <param name="gridExportMode"></param>
/// <returns></returns>
public HSSFWorkbook Exports(JqSearchIn si, GridExportMode gridExportMode, AnonymousContactSearchModel model)
{
var data = gridExportMode == GridExportMode.All ? GetAll() : SearchAnonymousContacts(model);
var anonymousContactts = Maps(data);
var exportData = si.Export(anonymousContactts, gridExportMode);
return(ExcelUtilities.CreateWorkBook(exportData));
}
/// <summary>
/// Export user login histories
/// </summary>
/// <param name="si"></param>
/// <param name="gridExportMode"></param>
/// <param name="model"></param>
/// <returns></returns>
public HSSFWorkbook Exports(JqSearchIn si, GridExportMode gridExportMode, UserLoginHistorySearchModel model)
{
var data = gridExportMode == GridExportMode.All ? GetAll() : SearchUserLoginHistories(model);
var userLoginHistories = Maps(data);
var exportData = si.Export(userLoginHistories, gridExportMode);
return(ExcelUtilities.CreateWorkBook(exportData));
}
/// <summary>
/// Export page templates
/// </summary>
/// <param name="si"></param>
/// <param name="gridExportMode"></param>
/// <param name="pageTemplateId"></param>
/// <returns></returns>
public ActionResult Exports(JqSearchIn si, GridExportMode gridExportMode, int?pageTemplateId)
{
var workbook = _pageTemplateService.Exports(si, gridExportMode, pageTemplateId);
var output = new MemoryStream();
workbook.Write(output);
return(File(output.ToArray(), "application/vnd.ms-excel", "PageTemplates.xls"));
}
/// <summary>
/// Export subscription logs
/// </summary>
/// <param name="si"></param>
/// <param name="gridExportMode"></param>
/// <returns></returns>
public HSSFWorkbook Exports(JqSearchIn si, GridExportMode gridExportMode)
{
var data = GetAll();
var subscriptionLogs = Maps(data);
var exportData = si.Export(subscriptionLogs, gridExportMode);
return(ExcelUtilities.CreateWorkBook(exportData));
}
/// <summary>
/// Export location types
/// </summary>
/// <param name="si"></param>
/// <param name="gridExportMode"></param>
/// <param name="locationId"></param>
/// <returns></returns>
public HSSFWorkbook Exports(JqSearchIn si, GridExportMode gridExportMode, int?locationId)
{
var data = gridExportMode == GridExportMode.All ? GetAll() : SearchLocationTypesByLocation(locationId);
var locationTypes = Maps(data);
var exportData = si.Export(locationTypes, gridExportMode);
return(ExcelUtilities.CreateWorkBook(exportData));
}
