private async void LoadData() { DepartmentCollection.Clear(); CategoryCollection.Clear(); var dCollection = await DbHandler.Instance.GetAllData <BbDepartment>(); DepartmentCollection.AddRange(dCollection); var cCollection = await DbHandler.Instance.GetAllData <BbCategory>(); CategoryCollection.AddRange(cCollection); }
public void AddDepartment() { try { using (var context = new SchoolU_DBEntities()) { context.Database.Connection.Open(); DepartmentCollection.Clear(); IList <Department> allDepartments = context.Departments.Where(i => i.DepartmentId != 0).ToList(); foreach (var dep in allDepartments) { _departmentCollection.Add(new Department { DepartmentName = dep.DepartmentName, DepartmentAbbr = dep.DepartmentAbbr }); } DepartmentCollection = _departmentCollection; } } catch (Exception ex) { //MessageBox.Show(ex.Message); return; } }