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