Пример #1
0
        private void ShowTree()
        {
            var ds = new CompanyDataSet();
            var cda = new linqToDataSet.CompanyDataSetTableAdapters.CompanyTableAdapter();
            cda.Fill(ds.Company);

            var tvCompanyItem = new TreeViewItem
            {
                Header = ds.Company.FirstOrDefault().Name
            };
            this.treeCompany.Items.Add(tvCompanyItem);

            var dda = new linqToDataSet.CompanyDataSetTableAdapters.DepartmentTableAdapter();
            dda.Fill(ds.Department);

            var eda = new linqToDataSet.CompanyDataSetTableAdapters.EmployeeTableAdapter();
            eda.Fill(ds.Employee);

            var pda = new linqToDataSet.CompanyDataSetTableAdapters.PersonTableAdapter();
            pda.Fill(ds.Person);

            foreach (var dept in ds.Department.Where(d=>d.Isparent_idNull()))
            {
                var tv = new TreeViewItem
                {
                    Header = dept.Name,
                    Tag = new DepartmentDetailsPage(dept.department_id)
                };
                tvCompanyItem.Items.Add(tv);
                GetSubTree(ref tv, dept);
            }
        }
Пример #2
0
        private void PageLoaded(object sender, RoutedEventArgs e)
        {
            var dda = new linqToDataSet.CompanyDataSetTableAdapters.DepartmentTableAdapter();
            var ds = new CompanyDataSet();
            dda.FillBy(ds.Department, _departmentId);

            var eda = new linqToDataSet.CompanyDataSetTableAdapters.EmployeeTableAdapter();
            eda.Fill(ds.Employee);
            var manager = ds.Employee.Where(emp => (emp.department_id == _departmentId) && emp.IsManager).Single();

            var pda = new linqToDataSet.CompanyDataSetTableAdapters.PersonTableAdapter();
            pda.FillBy(ds.Person, manager.person_id);

            var dept = ds.Department.Where(d => d.department_id == _departmentId).Single();
            WindowsTitle = dept.Name;

            Total = Features.SubTotalForDept(_departmentId);

            DataContext = new { Name = manager.PersonRow.Name };
        }
Пример #3
0
        private void ShowTree()
        {
            var ds  = new CompanyDataSet();
            var cda = new linqToDataSet.CompanyDataSetTableAdapters.CompanyTableAdapter();

            cda.Fill(ds.Company);

            var tvCompanyItem = new TreeViewItem
            {
                Header = ds.Company.FirstOrDefault().Name
            };

            this.treeCompany.Items.Add(tvCompanyItem);

            var dda = new linqToDataSet.CompanyDataSetTableAdapters.DepartmentTableAdapter();

            dda.Fill(ds.Department);

            var eda = new linqToDataSet.CompanyDataSetTableAdapters.EmployeeTableAdapter();

            eda.Fill(ds.Employee);

            var pda = new linqToDataSet.CompanyDataSetTableAdapters.PersonTableAdapter();

            pda.Fill(ds.Person);

            foreach (var dept in ds.Department.Where(d => d.Isparent_idNull()))
            {
                var tv = new TreeViewItem
                {
                    Header = dept.Name,
                    Tag    = new DepartmentDetailsPage(dept.department_id)
                };
                tvCompanyItem.Items.Add(tv);
                GetSubTree(ref tv, dept);
            }
        }
Пример #4
0
        private void PageLoaded(object sender, RoutedEventArgs e)
        {
            var dda = new linqToDataSet.CompanyDataSetTableAdapters.DepartmentTableAdapter();
            var ds  = new CompanyDataSet();

            dda.FillBy(ds.Department, _departmentId);

            var eda = new linqToDataSet.CompanyDataSetTableAdapters.EmployeeTableAdapter();

            eda.Fill(ds.Employee);
            var manager = ds.Employee.Where(emp => (emp.department_id == _departmentId) && emp.IsManager).Single();

            var pda = new linqToDataSet.CompanyDataSetTableAdapters.PersonTableAdapter();

            pda.FillBy(ds.Person, manager.person_id);

            var dept = ds.Department.Where(d => d.department_id == _departmentId).Single();

            WindowsTitle = dept.Name;

            Total = Features.SubTotalForDept(_departmentId);

            DataContext = new { Name = manager.PersonRow.Name };
        }