public async void Search()
{
if (string.IsNullOrEmpty(SearchText))
{
return;
}
else
{
try
{
var query = (from user in Context.Users
join access in Context.UserAccesses on user.UserAccessId equals access.UserAccessId
where (user.Name == SearchText) || (user.Name.Contains(SearchText)) ||
(user.UserId == SearchText) || (user.UserId.Contains(SearchText)) ||
(user.Username == SearchText) || (user.Username.Contains(SearchText))
select new
{
user.UserId,
user.Username,
user.Password,
user.Administrator,
user.ActiveStatus,
user.LastLoggedIn,
user.UserAccessId,
user.Name,
access.Caption,
});
UsersModelCollection.Clear();
foreach (var v in query.ToList())
{
UsersModelCollection.Add(new UserModel
{
UserId = v.UserId,
Name = v.Name,
Username = v.Username,
Password = v.Password,
AdministratorLevel = v.Administrator,
ActiveStatus = v.ActiveStatus,
Caption = v.Caption,
});
}
await Task.Delay(TimeSpan.FromSeconds(0.1));
}
catch (Exception)
{
await DI.UI.ShowMessage(new MessageBoxDialogViewModel
{
Title = "Error",
Message = $"Data {SearchText} Tidak ditemukan di dalam database",
DialogsYesVisible = false
});
}
}
}
public async void LoadData()
{
if (!string.IsNullOrEmpty(SearchText))
{
SearchText = string.Empty;
}
UsersModelCollection.Clear();
var query = (from user in Context.Users
join access in Context.UserAccesses on user.UserAccessId equals access.UserAccessId
orderby user.UserId
select new
{
user.UserId,
user.UserAccessId,
user.Username,
user.Password,
user.Name,
user.Administrator,
user.ActiveStatus,
user.LastLoggedIn,
access.Caption,
access.LevelAccess,
}).ToList();
foreach (var user in query)
{
UsersModelCollection.Add(new UserModel
{
UserId = user.UserId,
Username = user.Username,
Password = user.Password,
UserAccessId = user.UserAccessId,
Name = user.Name,
AdministratorLevel = user.Administrator,
LastLoggedIn = user.LastLoggedIn.ToString(),
LevelAccess = user.LevelAccess,
Caption = user.Caption,
ActiveStatus = user.ActiveStatus,
});
}
await Task.Delay(TimeSpan.FromSeconds(0.5));
}
