private void Form1_Load(object sender, EventArgs e)
{
ShopDB shopDB = new ShopDB();
var employeesTableAdapter = new ShopDBTableAdapters.EmployeesTableAdapter();
employeesTableAdapter.Fill(shopDB.Employees);
var ordersTableAdapter = new ShopDBTableAdapters.OrdersTableAdapter();
ordersTableAdapter.Fill(shopDB.Orders);
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"]);
}
dataGridView1.DataSource = employees;
this.dataGridView1.Columns["FName"].Visible = false;
this.dataGridView1.Columns["LName"].Visible = false;
this.dataGridView1.Columns["MName"].Visible = false;
this.dataGridView1.Columns["Salary"].Visible = false;
this.dataGridView1.Columns["PriorSalary"].Visible = false;
this.dataGridView1.Columns["HireDate"].Visible = false;
this.dataGridView1.Columns["TerminationDate"].Visible = false;
this.dataGridView1.Columns["ManagerEmpID"].Visible = false; ////
}
private void Form1_Load(object sender, EventArgs e)
{
ShopDB shopDB = new ShopDB();
var customersTableAdapter = new ShopDBTableAdapters.CustomersTableAdapter();
customersTableAdapter.Fill(shopDB.Customers);
var ordersTableAdapter = new ShopDBTableAdapters.OrdersTableAdapter();
ordersTableAdapter.Fill(shopDB.Orders);
var employeesTableAdapter = new ShopDBTableAdapters.EmployeesTableAdapter(); //
employeesTableAdapter.Fill(shopDB.Employees);
shopDB.Orders.Columns.Add("SurnameEmployee", typeof(String));
shopDB.Orders.Columns.Add("NameEmployee", typeof(String));
shopDB.Orders.Columns.Add("SurnameCustomer", typeof(String));
shopDB.Orders.Columns.Add("NameCustomer", typeof(String));
foreach (var orderRow in shopDB.Orders)
{
orderRow["NameEmployee"] = orderRow.EmployeesRow.FName;
orderRow["SurnameEmployee"] = orderRow.EmployeesRow.LName;
orderRow["SurnameCustomer"] = orderRow.CustomersRow.FName;
orderRow["NameCustomer"] = orderRow.CustomersRow.LName;
}
dataGridView1.DataSource = shopDB.Orders;
dataGridView1.Columns[0].Visible = false;
dataGridView1.Columns[1].Visible = false;
dataGridView1.Columns[3].Visible = false;
dataGridView1.Columns["OrderDate"].Visible = false;
}
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 = 'Киев'");
}
