static void Main(string[] args) { ShopDB shopDB = new ShopDB(); var employeesTableAdapter = new ShopDBTableAdapters.EmployeesTableAdapter(); employeesTableAdapter.Fill(shopDB.Employees); var ordersTableAdapter = new ShopDBTableAdapters.OrdersTableAdapter(); ordersTableAdapter.Fill(shopDB.Orders); var orderDetailsTableAdapter = new ShopDBTableAdapters.OrderDetailsTableAdapter(); orderDetailsTableAdapter.Fill(shopDB.OrderDetails); ShopDB.EmployeesDataTable employees = employeesTableAdapter.GetData(); ShopDB.OrdersDataTable orders = ordersTableAdapter.GetData(); employees.Columns.Add("Count", typeof(int)); foreach (DataRow employeeRow in employees.Rows) { employeeRow["Count"] = orders.Count(o => o.EmployeeID == (int)employeeRow["EmployeeID"]); foreach (DataColumn column in employees.Columns) { if (column.ColumnName == "EmployeeID" || column.ColumnName == "Count") { Console.WriteLine("{0}: {1}", column.ColumnName, employeeRow[column]); } } Console.WriteLine(); } }
private void Window_Loaded(object sender, RoutedEventArgs e) { ShopDB dataBase = new ShopDB(); var empAdapter = new ShopDBTableAdapters.EmployeesTableAdapter(); var employees = empAdapter.GetData(); var ordAdapter = new ShopDBTableAdapters.OrdersTableAdapter(); var orders = ordAdapter.GetData(); var ordDetAdapter = new ShopDBTableAdapters.OrderDetailsTableAdapter(); var orderDet = ordDetAdapter.GetData(); employees.Columns.Add("TotalSum", typeof(decimal)); var sum = from em in employees.AsQueryable() join ord in orders.AsQueryable() on em.EmployeeID equals ord.EmployeeID into ordGroup from o in ordGroup join det in orderDet.AsQueryable() on o.OrderID equals det.OrderID into detGroup select new { FName = em.FName, LName = em.LName, Total = detGroup.Sum(od => od.TotalPrice) }; var full = from s in sum.AsQueryable() group s by new { s.FName, s.LName } into g select new { FName = g.Key.FName, LName = g.Key.LName, Total = g.Sum(a => a.Total) }; dtgrd.ItemsSource = full; var custAdap = new ShopDBTableAdapters.CustomersTableAdapter(); DataTable customers = custAdap.GetData(); dtgrd2.ItemsSource = customers.Select("City = 'Киев'"); }
private void Window_Loaded(object sender, RoutedEventArgs e) { ShopDB dataBase = new ShopDB(); var empAdapter = new ShopDBTableAdapters.EmployeesTableAdapter(); var employees = empAdapter.GetData(); var ordAdapter = new ShopDBTableAdapters.OrdersTableAdapter(); var orders = ordAdapter.GetData(); var ordDetAdapter = new ShopDBTableAdapters.OrderDetailsTableAdapter(); var orderDet = ordDetAdapter.GetData(); employees.Columns.Add("TotalSum", typeof(decimal)); var sum = from em in employees.AsQueryable() join ord in orders.AsQueryable() on em.EmployeeID equals ord.EmployeeID into ordGroup from o in ordGroup join det in orderDet.AsQueryable() on o.OrderID equals det.OrderID into detGroup select new { FName = em.FName, LName = em.LName, Total = detGroup.Sum(od => od.TotalPrice) }; var full = from s in sum.AsQueryable() group s by new { s.FName, s.LName } into g select new { FName = g.Key.FName, LName = g.Key.LName, Total = g.Sum(a => a.Total) }; dtgrd.ItemsSource = full; var custAdap = new ShopDBTableAdapters.CustomersTableAdapter(); DataTable customers = custAdap.GetData(); dtgrd2.ItemsSource = customers.Select("City = 'Киев'"); }