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