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