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