public List <UserLoginTableModel> SearchUserLogin(UserLoginQueryModel query) { var result = new List <UserLoginTableModel>(); using (var command = Context.Connection.GenerateCommand( "ais.search_userlogin", new { isfromgn = query.IsFromGN, username = query.Username?.ExtendToSearch(), logindatefrom = query.LoginDateFrom, logindateto = query.LoginDateTo, loginip = query.LoginIp?.ExtendToSearch() })) { using (var reader = command.ExecuteReaderSafety()) { while (reader.Read()) { result.Add( new UserLoginTableModel { Username = reader.GetFieldValue <string>("username"), LoginDate = reader.GetFieldValue <DateTime?>("logindate"), LoginIp = reader.GetFieldValue <string>("loginip"), }); } } } return(result); }
public List <UserLoginTableModel> SearchUserLogin(UserLoginQueryModel query) { return(adminRepository.SearchUserLogin(query)); }