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