public async void updateList(string searchText) { if (loaded != null) { loaded.OnProgressStart("Обновление..."); } userList.Clear(); using (ApplicationContext db = new ApplicationContext()) { var query = from u in db.Users orderby u.c_login select u; foreach (var item in string.IsNullOrEmpty(searchText) ? query : query.Where(t => t.c_login.ToLower().Contains(searchText) || t.c_fio.ToLower().Contains(searchText))) { userList.Add(item); } UserList.ItemsSource = userList; } if (loaded != null) { loaded.OnProgressEnd(); } }
public async void updateList(int?type, string search) { if (loaded != null) { loaded.OnProgressStart("Обновление..."); } knowList.Clear(); using (ApplicationContext db = new ApplicationContext()) { var query = from t in db.KnowledgeBases join t1 in db.Actions on t.f_action equals t1.id orderby t.dx_created descending select new { t.id, t.c_question, t.jb_data, t.jb_tags, t.f_action, t1.c_short_name, t.dx_created, t.b_disabled }; foreach (var item in string.IsNullOrEmpty(search) ? (type.HasValue ? query.Where(t => t.f_action == type.Value) : query): (type.HasValue ? query.Where(t => t.f_action == type.Value) : query).Where(t => t.c_question.ToLower().Contains(search))) { knowList.Add(new KnowledgeBase() { id = item.id, c_question = item.c_question, jb_data = item.jb_data, jb_tags = item.jb_tags, b_disabled = item.b_disabled, dx_created = item.dx_created, ActionName = item.c_short_name, f_action = item.f_action }); } KnowList.ItemsSource = knowList; } if (loaded != null) { loaded.OnProgressEnd(); } }
public async void updateList(int?type) { if (loaded != null) { loaded.OnProgressStart("Обновление..."); } settingList.Clear(); using (ApplicationContext db = new ApplicationContext()) { var query = from t in db.Setting join t1 in db.SettingTypes on t.f_type equals t1.id orderby t.c_key select new { t.id, t.c_key, t.c_summary, t.c_value, t.f_type, t1.c_name }; foreach (var item in type.HasValue ? query.Where(t => t.f_type == type.Value) : query) { settingList.Add(new Setting() { id = item.id, c_key = item.c_key, c_summary = item.c_summary, c_value = item.c_value, f_type = item.f_type, TypeName = item.c_name }); } SettingList.ItemsSource = settingList; } if (loaded != null) { loaded.OnProgressEnd(); } }