static void Main() { using (var context = new BDC()) { Application.EnableVisualStyles(); Application.SetCompatibleTextRenderingDefault(false); Application.Run(new MainForm(context)); } }
public static Task UpdateGrid(ref DataGridView grid, BDC context) { grid.Columns.Clear(); AddGridColumn(ref grid, "Date", "Organisation", "City", "Country", "Manager", "Count", "Sum", "id"); grid.Columns[grid.Columns.Count - 1].Visible = false; //id not visible for user var RegList = context.Regs; foreach (var item in RegList) { grid.Rows.Add(item.RegDate.ToString("dd-MM-yyyy"), item.RegOrgName, item.RegCityName, item.RegCountryName, item.RegManagerName, item.RegCount, item.RegTotalSum, item.Id); } return(Task.CompletedTask); }
public static Task UpdateGrid(ref DataGridView grid, BDC context, ListBox.SelectedObjectCollection selectedItems) { if (selectedItems.Count > 1) { UpdateGrid(ref grid, context); foreach (DataGridViewColumn column in grid.Columns) { if (column.HeaderText == "Count" || column.HeaderText == "Sum") { continue; } column.Visible = false; foreach (var item in selectedItems) { if (column.HeaderText.ToLower() == item.ToString().ToLower()) { column.Visible = true; } } } } else if (selectedItems.Count == 1) { grid.Columns.Clear(); AddGridColumn(ref grid, selectedItems[0].ToString(), "Count", "Sum"); IQueryable <Searching> search = null; switch (selectedItems[0].ToString()) { case "Organisation": search = context.Regs.Select(o => new Searching { Result = o.RegOrgName, Count = context.Regs.Where(i => i.RegOrgName == o.RegOrgName).Sum(s => s.RegCount), TotalSum = context.Regs.Where(i => i.RegOrgName == o.RegOrgName).Sum(s => s.RegTotalSum) }).Distinct(); break; case "City": search = context.Regs.Select(o => new Searching { Result = o.RegCityName, Count = context.Regs.Where(i => i.RegCityName == o.RegCityName).Sum(s => s.RegCount), TotalSum = context.Regs.Where(i => i.RegCityName == o.RegCityName).Sum(s => s.RegTotalSum) }).Distinct(); break; case "Country": search = context.Regs.Select(o => new Searching { Result = o.RegCountryName, Count = context.Regs.Where(i => i.RegCountryName == o.RegCountryName).Sum(s => s.RegCount), TotalSum = context.Regs.Where(i => i.RegCountryName == o.RegCountryName).Sum(s => s.RegTotalSum) }).Distinct(); break; case "Manager": search = context.Regs.Select(o => new Searching { Result = o.RegManagerName, Count = context.Regs.Where(i => i.RegManagerName == o.RegManagerName).Sum(s => s.RegCount), TotalSum = context.Regs.Where(i => i.RegManagerName == o.RegManagerName).Sum(s => s.RegTotalSum) }).Distinct(); break; } if (search != null) { foreach (var item in search) { grid.Rows.Add(item.Result, item.Count, item.TotalSum); } } else { UpdateGrid(ref grid, context); } } else { UpdateGrid(ref grid, context); } return(Task.CompletedTask); }
public MainForm(BDC context_) : this() { _context = context_; Source.UpdateGrid(ref dataGridView, _context); }