public ChartsSheetService(BudgetDto budget, ILogger log)
{
_budget = budget ?? throw new ArgumentNullException(nameof(budget));
_log = log;
int rowsNumber = 5 + _budget.Categories.Count + 54;
int colsNumber = 7;
_googleSheetService = new GoogleSheetService("Charts", 2, rowsNumber, colsNumber, 0, 0, true, GetSheetsColor());
_googleSheetService.SetRowHeight(0, 50);
_googleSheetService.AddProtectedRanges(0, 2, 1, 3 + _budget.Categories.Count);
}
public DashboardSheetService(BudgetDto budget)
{
_budget = budget ?? throw new ArgumentNullException(nameof(budget));
int rowsNumber = 3 + (_budget.Categories.Count * 2) + _budget.Subcategories.Count;
int colsNumber = 4;
_googleSheetService = new GoogleSheetService("Dashboard", 0, rowsNumber, colsNumber, 0, 2, true, GetSheetsColor());
_subcategoryRows = new List <Model.DTOs.GoogleSpreadsheet.DashboardSubcategoryRowDto>();
_googleSheetService.SetRowHeight(0, 50);
_googleSheetService.AddProtectedRanges(0, 4, 1, rowsNumber);
}
public SpendingSheetService(BudgetDto budget)
{
_budget = budget;
int rowsNumber = 16 + (_budget.Incomes.Count + 4) + (_budget.Categories.Count * 4) + _budget.Subcategories.Count;
int colsNumber = 6 + DateTime.DaysInMonth(_budget.Month.Year, _budget.Month.Month);
_googleSheetService = new GoogleSheetService("Spending", 1, rowsNumber, colsNumber, 5, 0, false, GetSheetsColor());
_subcategoriesRowsIndexes = new List <int>();
_subcategoriesRows = new List <CellData>();
_googleSheetService.SetRowHeight(0, 50);
_googleSheetService.SetColumnWidth(0, 180);
_googleSheetService.SetColumnWidth(1, 110);
_googleSheetService.SetColumnWidth(2, 110);
_googleSheetService.SetColumnWidth(3, 110);
_googleSheetService.SetColumnWidth(4, 100);
}
private void AddCategoryHeader(CategoryDto category)
{
var cells = new List <CellData>();
cells.Add(new CellData()
{
UserEnteredValue = new ExtendedValue()
{
FormulaValue = $"=Spending!{GoogleSheetService.GetCellAddress(0, category.RowIndex)}"
},
UserEnteredFormat = CategoryHeaderFormat()
});
_googleSheetService.SetRowHeight(_googleSheetService.CurrentRow, 30);
_googleSheetService.MergeRange(new GridRange()
{
StartRowIndex = _googleSheetService.CurrentRow,
EndRowIndex = _googleSheetService.CurrentRow + 1,
StartColumnIndex = 0,
EndColumnIndex = 4
});
_googleSheetService.AddRow(cells);
}