/// <summary> /// Search user login histories /// </summary> /// <param name="model"></param> /// <returns></returns> private IQueryable <UserLoginHistory> SearchUserLoginHistories(UserLoginHistorySearchModel model) { return(Fetch(userLoginHistory => (string.IsNullOrEmpty(model.Keyword) || (!string.IsNullOrEmpty(userLoginHistory.User.Username) && userLoginHistory.User.Username.Contains(model.Keyword)) || (!string.IsNullOrEmpty(userLoginHistory.User.Email) && userLoginHistory.User.Email.Contains(model.Keyword)) || (!string.IsNullOrEmpty(userLoginHistory.BrowserName) && userLoginHistory.BrowserName.Contains(model.Keyword)) || (!string.IsNullOrEmpty(userLoginHistory.BrowserType) && userLoginHistory.BrowserType.Contains(model.Keyword)) || (!string.IsNullOrEmpty(userLoginHistory.BrowserVersion) && userLoginHistory.BrowserVersion.Contains(model.Keyword)) || (!string.IsNullOrEmpty(userLoginHistory.IpAddress) && userLoginHistory.IpAddress.Contains(model.Keyword)) || (!string.IsNullOrEmpty(userLoginHistory.Platform) && userLoginHistory.Platform.Contains(model.Keyword)) || (!string.IsNullOrEmpty(userLoginHistory.OsVersion) && userLoginHistory.OsVersion.Contains(model.Keyword))) && (!model.UserId.HasValue || userLoginHistory.UserId == model.UserId))); }
/// <summary> /// Search the user login histories. /// </summary> /// <returns></returns> public JqGridSearchOut SearchUserLoginHistories(JqSearchIn si, UserLoginHistorySearchModel model) { var data = SearchUserLoginHistories(model); var userLoginHistories = Maps(data); return(si.Search(userLoginHistories)); }
/// <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 user login histories /// </summary> /// <param name="si"></param> /// <param name="model"></param> /// <param name="gridExportMode"></param> /// <returns></returns> public ActionResult Exports(JqSearchIn si, GridExportMode gridExportMode, UserLoginHistorySearchModel model) { var workbook = _userLoginHistoryService.Exports(si, gridExportMode, model); var output = new MemoryStream(); workbook.Write(output); return(File(output.ToArray(), "application/vnd.ms-excel", "UserLoginHistories.xls")); }
public string _AjaxBinding(JqSearchIn si, UserLoginHistorySearchModel model) { return(JsonConvert.SerializeObject(_userLoginHistoryService.SearchUserLoginHistories(si, model))); }
public ActionResult Index(int?userId) { var model = new UserLoginHistorySearchModel(userId); return(View(model)); }