private void HabilitDataGridView(DtvTypes type) { dtvBankAccount.Visible = false; dtvCreditCard.Visible = false; dtvCategorias.Visible = false; dtvEntries.Visible = false; dtvEntries2.Visible = false; if (type == DtvTypes.Account) { dtvBankAccount.Visible = true; } else if (type == DtvTypes.CreditCard) { dtvCreditCard.Visible = true; } else if (type == DtvTypes.Entries) { dtvEntries.Visible = true; } else if (type == DtvTypes.Categories) { dtvCategorias.Visible = true; } else if (type == DtvTypes.Transfer) { dtvEntries2.Visible = true; } else { dtvEntries.Visible = true; } }
public void LoadDtvCategories(DataGridView dtv, DtvTypes type, Report report) { int i, j, qtdEntry; double valueExpense = 0.00; bool addRow = false; string description; i = 0; List <EntryExpenses> entries = new List <EntryExpenses>(); List <Category> cats = new List <Category>(); List <SubCategories> subCats = new List <SubCategories>(); dtv.Rows.Clear(); dtv.Columns[0].Name = type == DtvTypes.Categories ? "Categoria" : "SubCategoria"; foreach (var entry in report.EntryExpenses) { entries.Add(entry); } foreach (var entry in report.EntryRevenue) { entries.Add(entry); } entries = entries.OrderBy(e => e.Date).ToList(); foreach (var cat in report.Categories) { j = 1; valueExpense = 0.00; qtdEntry = 0; addRow = false; description = ""; foreach (var entry in entries) { if (entry.Category.Id == cat.Id) { valueExpense += entry.Value; qtdEntry++; addRow = true; description = type == DtvTypes.Categories ? cat.Description : entry.SubCategory.Description; } if (entries.Count == j && addRow) { dtv.Rows.Add(); dtv.Rows[i].Cells[0].Value = description; dtv.Rows[i].Cells[1].Value = valueExpense; dtv.Rows[i].Cells[2].Value = entry.EntryType == EntryType.Expense ? "Despesa" : "Receita"; dtv.Rows[i].Cells[3].Value = qtdEntry; i++; } j++; } } }