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