private void ShowCategorySale()
{
List <EtSale> sales = QuerySalesFromDB();
SetCategorySalesFromEtSales(sales);
DgvCategorySale.Rows.Clear();
DgvCategorySale.RowsDefaultCellStyle.BackColor = Color.FromArgb(240, 255, 255);
DgvCategorySale.AlternatingRowsDefaultCellStyle.BackColor = Color.White;
DgvCategorySale.AllowUserToAddRows = false;
DgvCategorySale.RowHeadersVisible = false;
foreach (KeyValuePair <int, ClsCategorySale> kvp in categorySales)
{
ClsCategorySale categorySale = kvp.Value;
DgvCategorySale.Rows.Add(new object[]
{
categorySale.ParentCategoryName,
categorySale.Count,
categorySale.GrossSales,
categorySale.Profits
});
}
}
private DataTable CreateDataTable()
{
List <EtSale> sales = QuerySalesFromDB();
SetCategorySalesFromEtSales(sales);
DataTable dt = new DataTable();
dt.Columns.Add("ParentCategoryName");
dt.Columns.Add("Count");
dt.Columns.Add("GrossSales");
dt.Columns.Add("Profits");
foreach (KeyValuePair <int, ClsCategorySale> kvp in categorySales)
{
DataRow dr = dt.NewRow();
ClsCategorySale categorySale = kvp.Value;
dr["ParentCategoryName"] = categorySale.ParentCategoryName;
dr["Count"] = categorySale.Count;
dr["GrossSales"] = categorySale.GrossSales;
dr["Profits"] = categorySale.Profits;
dt.Rows.Add(dr);
}
return(dt);
}
