private void ResearchObjectsRefresh(object sender, PaginationOnRefreshEventArgs e) { List <research_objects> ros = new List <research_objects>(); long barcode = 0; if (!string.IsNullOrWhiteSpace(ResearchObjectsSearchField.Text) && long.TryParse(ResearchObjectsSearchField.Text, out barcode)) { ros = (from ro in App.DB.research_objects where ro.patient == CurrentPatient.id && ro.barcode == barcode orderby ro.id ascending select ro).Skip(unchecked ((int)e.CurrentOffset)).Take(20).ToList(); } else { ros = (from ro in App.DB.research_objects where ro.patient == CurrentPatient.id orderby ro.id ascending select ro).Skip(unchecked ((int)e.CurrentOffset)).Take(20).ToList(); } ResearchObjectsDataGrid.Columns.Clear(); ResearchObjectsDataGrid.ItemsSource = ros; e.Controls.SetEnabledState(true); }
private void ServicesRefresh(object sender, PaginationOnRefreshEventArgs e) { List <service> services = new List <service>(); if (!string.IsNullOrWhiteSpace(ServicesSearchField.Text)) { services = (from s in App.DB.services where App.currentUserServices.Contains(s.id) && s.name.Contains(ServicesSearchField.Text) orderby s.id ascending select s) .Skip(unchecked ((int)e.CurrentOffset)).Take(20).ToList(); } else { services = (from s in App.DB.services where App.currentUserServices.Contains(s.id) orderby s.id ascending select s) .Skip(unchecked ((int)e.CurrentOffset)).Take(20).ToList(); } ServicesDataGrid.Columns.Clear(); ServicesDataGrid.ItemsSource = services; e.Controls.SetEnabledState(true); }
private void RefreshEntries(object sender, PaginationOnRefreshEventArgs e) { var query = (from t in App.DB.users_auth_tries join u in App.DB.users on t.user equals u.id select new { t.id, t.is_success, t.tried_at, t.user, u.login }); if (e.EntriesCount != -1) { //<e.EntriesCount> entries query = query.Skip(unchecked ((int)e.CurrentOffset)).Take(unchecked ((int)e.EntriesCount)); } if (CurrentUser.id != -1) { query = query.Where(t => t.user == CurrentUser.id); } if (TriedAtDatePicker.SelectedDate.HasValue) { query = query.Where(t => DbFunctions.DiffDays(TriedAtDatePicker.SelectedDate.Value, t.tried_at) == 0); } AuthTriesHistoryDataGrid.Columns.Clear(); AuthTriesHistoryDataGrid.ItemsSource = query.Select(t => new AuthTryShrinked { login = t.login, tried_at = t.tried_at, is_successful = t.is_success }).ToList(); UpdateAuthTriesCounters(); e.Controls.SetEnabledState(true); }
private void PatientsRefresh(object sender, PaginationOnRefreshEventArgs e) { PaginationController controller = sender as PaginationController; List <PatientsShrinked> patients; if (!string.IsNullOrWhiteSpace(e.SearchQuery)) { patients = (from p in App.DB.patients where p.full_name.Contains(e.SearchQuery) orderby p.id ascending select new PatientsShrinked { id = p.id, full_name = p.full_name, birthdate = p.birthdate, passport_number = p.passport_number, passport_serial = p.passport_serial }).Skip(unchecked ((int)e.CurrentOffset)).Take(20).ToList(); } else { patients = (from p in App.DB.patients orderby p.id ascending select new PatientsShrinked { id = p.id, full_name = p.full_name, birthdate = p.birthdate, passport_number = p.passport_number, passport_serial = p.passport_serial }).Skip(unchecked ((int)e.CurrentOffset)).Take(20).ToList(); } patientsDataGrid.Columns.Clear(); patientsDataGrid.ItemsSource = patients; e.Controls.SetEnabledState(true); }