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