public async Task <IActionResult> GetOwners()
{
ListFilesResponse listFilesResponse = await _googleSheetsService.ListSheetsInFolder(string.Empty);
var owners = listFilesResponse.Files.Select(o => o.Owners.Distinct());
Response.Headers.Add("Cache-Control", "no-cache");
return(Json(owners));
}
public Query(IGoogleSheetsService googleSheetsService, ISheetsCatalogImportRepository sheetsCatalogImportRepository)
{
Name = "Query";
FieldAsync <BooleanGraphType>(
"haveToken",
resolve: async context =>
{
Token token = await googleSheetsService.GetGoogleToken();
return(token != null && !string.IsNullOrEmpty(token.RefreshToken));
}
);
/// query Reviews($searchTerm: String, $from: Int, $to: Int, $orderBy: String, $status: Boolean)
FieldAsync <StringGraphType>(
"getOwnerEmail",
arguments: new QueryArguments(
new QueryArgument <StringGraphType> {
Name = "accountName", Description = "Account Name"
}
),
resolve: async context =>
{
string email = string.Empty;
string accountName = context.GetArgument <string>("accountName");
Token token = await googleSheetsService.GetGoogleToken();
if (token != null)
{
string productsFolderId = string.Empty;
FolderIds folderIds = await sheetsCatalogImportRepository.LoadFolderIds(accountName);
if (folderIds != null)
{
if (!string.IsNullOrEmpty(folderIds.FolderOwner))
{
email = folderIds.FolderOwner;
}
else
{
productsFolderId = folderIds.ProductsFolderId;
ListFilesResponse listFilesResponse = await googleSheetsService.ListSheetsInFolder(productsFolderId);
if (listFilesResponse != null)
{
var owners = listFilesResponse.Files.Select(o => o.Owners.Distinct()).FirstOrDefault();
if (owners != null)
{
email = owners.Select(o => o.EmailAddress).FirstOrDefault();
}
}
}
}
}
return(email);
}
);
FieldAsync <StringGraphType>(
"sheetLink",
resolve: async context =>
{
return(await googleSheetsService.GetSheetLink());
}
);
}