public void getProducts()
{
using (var dbs = new NORTHWNDEntities())
{
var pd = dbs.Products.Select(p => new
{
ProductCode = p.ProductID,
p.ProductName,
Price = p.UnitPrice,
PriceIncludeVat = ((float)p.UnitPrice * (float)1.07)
}).ToList();
DataTable dt = new DataTable();
dt = ToDataTable(pd);
dataGridView1.DataSource = dt;
DataTable dt2 = new DataTable();
dt2.Columns.Add("The Max Price");
dt2.Columns.Add("The Min Price");
dt2.Columns.Add("The Average Price");
string mx = dbs.Products.Max(p => p.UnitPrice).ToString();
string mn = dbs.Products.Min(p => p.UnitPrice).ToString();
string avg = dbs.Products.Average(p => p.UnitPrice).ToString();
DataRow dr = dt2.NewRow();
dr["The Max Price"] = mx;
dr["The Min Price"] = mn;
dr["The Average Price"] = avg;
dt2.Rows.Add(dr);
dataGridView2.DataSource = dt2;
}
}
public void getCustomers()
{
using (var dbs = new NORTHWNDEntities())
{
//var cust2 = dbs.Customers.Select(p => new
//{
// p.CustomerID,
// p.CompanyName,
// p.ContactName,
// TotalOrderPrice = p.Orders.Select(o => o.Order_Details.Select(od => od.UnitPrice))
//}).ToList();
//dataGridView3.DataSource = cust2;
//MessageBox.Show("123");
var cust = dbs.Customers.Select(p => new
{
p.CustomerID,
p.CompanyName,
p.ContactName,
TotalOrderPrice = (float?)p.Orders.Sum(o => o.Order_Details.Sum(od => od.UnitPrice * od.Quantity))
}).ToList();
dataGridView3.DataSource = cust;
DataTable dt = new DataTable();
dt = ToDataTable(cust);
dataGridView3.DataSource = dt;
DataTable dt2 = new DataTable();
dt2.Columns.Add("The Max is ");
dt2.Columns.Add("The Min is ");
dt2.Columns.Add("The Average is ");
dt2.Columns.Add("Summary is ");
string mx = dbs.Customers.Max(p =>
(float?)p.Orders.Sum(o => o.Order_Details.Sum(od => od.UnitPrice * od.Quantity))
).ToString();
string mn = dbs.Customers.Min(p =>
(float?)p.Orders.Sum(o => o.Order_Details.Sum(od => od.UnitPrice * od.Quantity))
).ToString();
string avg = dbs.Customers.Average(p =>
(double?)p.Orders.Sum(o => o.Order_Details.Sum(od => od.UnitPrice * od.Quantity))
).ToString();
string sm = dbs.Customers.Sum(p =>
p.Orders.Sum(o => o.Order_Details.Sum(od => od.UnitPrice * od.Quantity))
).ToString();
DataRow dr = dt2.NewRow();
dr["The Max is "] = mx;
dr["The Min is "] = mn;
dr["The Average is "] = avg;
dr["Summary is "] = sm;
dt2.Rows.Add(dr);
dataGridView4.DataSource = dt2;
}
}
