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); } }
private void BtnSaveClick(object sender, RoutedEventArgs e) { dynamic ctx = DataContext; var person = (CompanyDataSet.PersonRow)ctx.Person; var emp = (CompanyDataSet.EmployeeRow)ctx.Employee; var eda = new linqToDataSet.CompanyDataSetTableAdapters.EmployeeTableAdapter(); eda.Update(emp); var pda = new linqToDataSet.CompanyDataSetTableAdapters.PersonTableAdapter(); pda.Update(person); if(OnEmployeeChanged != null) { OnEmployeeChanged(this, new EmployeeChangedEventArgs(person.Name)); } }
private void PageLoaded(object sender, RoutedEventArgs e) { var eda = new linqToDataSet.CompanyDataSetTableAdapters.EmployeeTableAdapter(); var ds = new CompanyDataSet(); eda.FillBy(ds.Employee, _employeeId); var pda = new linqToDataSet.CompanyDataSetTableAdapters.PersonTableAdapter(); pda.FillBy(ds.Person, ds.Employee.Single().person_id); var emp = ds.Employee.Single(); var person = emp.PersonRow; WindowsTitle = person.Name; DataContext = new { Person = person, Employee = emp }; }
private void BtnSaveClick(object sender, RoutedEventArgs e) { dynamic ctx = DataContext; var person = (CompanyDataSet.PersonRow)ctx.Person; var emp = (CompanyDataSet.EmployeeRow)ctx.Employee; var eda = new linqToDataSet.CompanyDataSetTableAdapters.EmployeeTableAdapter(); eda.Update(emp); var pda = new linqToDataSet.CompanyDataSetTableAdapters.PersonTableAdapter(); pda.Update(person); if (OnEmployeeChanged != null) { OnEmployeeChanged(this, new EmployeeChangedEventArgs(person.Name)); } }
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 }; }
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); } }
private void PageLoaded(object sender, RoutedEventArgs e) { var eda = new linqToDataSet.CompanyDataSetTableAdapters.EmployeeTableAdapter(); var ds = new CompanyDataSet(); eda.FillBy(ds.Employee, _employeeId); var pda = new linqToDataSet.CompanyDataSetTableAdapters.PersonTableAdapter(); pda.FillBy(ds.Person, ds.Employee.Single().person_id); var emp = ds.Employee.Single(); var person = emp.PersonRow; WindowsTitle = person.Name; DataContext = new {Person = person, Employee = emp}; }