public ReactionsParser(SheetsService service, Models.Spreadsheet spreadsheet, SupportMethods supportMethods) { _service = service; _spreadsheet = spreadsheet; _supportMethods = supportMethods; }
private void PopulateSpreadsheetModel(string databaseFamilyNamesColumn, int databaseHeadersRow, int partiesHeadersRow) { var databaseSheet = Spreadsheet.DatabaseSheet; databaseSheet.ColumnHeadersRow = databaseHeadersRow; databaseSheet.FamilyNamesColumn = databaseFamilyNamesColumn; databaseSheet.DatabaseRows = SupportMethods.FetchAllDatabaseRowsFromSpreadsheet(databaseFamilyNamesColumn); databaseSheet.DatabaseColumns = SupportMethods.GetColumns(databaseSheet, databaseHeadersRow); var partiesSheet = Spreadsheet.PartiesSheet; partiesSheet.ColumnHeadersRow = partiesHeadersRow; partiesSheet.DatabaseColumns = SupportMethods.GetColumns(partiesSheet, databaseHeadersRow); }
private SpreadsheetInstance(string spreadsheetId, string databaseSheet, string databaseFamilyNamesColumn, int databaseHeadersRow, string partiesSheet, int partiesHeadersRow) { UserCredential credential; using (var stream = new FileStream("client_secret.json", FileMode.Open, FileAccess.Read)) { string credPath = Environment.GetFolderPath( Environment.SpecialFolder.Personal); credPath = Path.Combine(credPath, ".credentials/sheets.googleapis.com-dotnet-quickstart.json"); credential = GoogleWebAuthorizationBroker.AuthorizeAsync( GoogleClientSecrets.Load(stream).Secrets, Scopes, "user", CancellationToken.None, new FileDataStore(credPath, true)).Result; Console.WriteLine("Credential file saved to: " + credPath); } // Create Google Sheets API service. Service = new SheetsService(new BaseClientService.Initializer() { HttpClientInitializer = credential, ApplicationName = ApplicationName, }); Spreadsheet = new Models.Spreadsheet(spreadsheetId) { DatabaseSheet = new DatabaseSheet(databaseSheet), PartiesSheet = new DatabaseSheet(partiesSheet) }; SupportMethods = new SupportMethods(Service, Spreadsheet); PopulateSpreadsheetModel(databaseFamilyNamesColumn, databaseHeadersRow, partiesHeadersRow); CommandsParser = new CommandsParser(Service, Spreadsheet, SupportMethods); ReactionsParser = new ReactionsParser(Service, Spreadsheet, SupportMethods); }