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