C# (CSharp) linqToDataSet.CompanyDataSetTableAdapters.PersonTableAdapter.FillBy Exemples

Exemple #1

Fichier : EmployeeDetailsPage.xaml.cs Projet : nietcdf/101repo

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

Exemple #2

Fichier : DepartmentDetailsPage.xaml.cs Projet : nuzil/101repo

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

Exemple #3

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

Exemple #4

Fichier : EmployeeDetailsPage.xaml.cs Projet : nuzil/101repo

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