private async Task ProvideHelpAsync(Update update)
{
try
{
string spreadSheetId = await _spreadsheetIdStore.GetSpreadSheetIdAsync(update.Message.Chat.Id.ToString());
string response = $@"Current spreadsheet url: `{_spreadsheetIdStore.ConvertSpreadSheetIdToUrl(spreadSheetId)}`
To change it, use `/spreadsheet <spreadsheet url>`
To create a new spreadsheet, use `/spreadsheet new`";
await _telegramBotClient.SendTextMessageAsync(update.Message.Chat.Id,
response, ParseMode.Markdown);
}
catch (SpreadSheetNotSetException)
{
var response = @"There is no spreadsheet set yet.
To set it, use `/spreadsheet <spreadsheet url>`
To create a new spreadsheet, use `/spreadsheet new`";
await _telegramBotClient.SendTextMessageAsync(update.Message.Chat.Id,
response, ParseMode.Markdown);
}
}
public async Task Note(string chatId, Message message)
{
SheetsService sheetsService = await _sheetsServiceFactory.GetSheetsServiceAsync(chatId);
_logger.Debug("getting spreadsheetId for chat {chatId}", chatId);
string spreadSheetId = await _spreadsheetIdStore.GetSpreadSheetIdAsync(chatId);
_logger.Debug("fetched spreadSheetId for chat {chatId}", chatId);
_logger.Debug("making note in spreadshet for chatId {chatId}", chatId);
await AppendMessageAsync(sheetsService, spreadSheetId, message);
_logger.Debug("sucessfully saved note in spreadsheet for chatId {chatId}", chatId);
}
