Esempio n. 1
0
        private async Task <List <DetailDataViewModel> > GetAsync()
        {
            GoogleSheetHelper sheet = new GoogleSheetHelper();
            var serviceValues       = sheet.GetSheetsService().Spreadsheets.Values;

            return(await sheet.ReadAsync(serviceValues));
        }
Esempio n. 2
0
        private async Task PutAsync([FromBody] DetailDataViewModel newData)
        {
            GoogleSheetHelper sheet = new GoogleSheetHelper();
            var serviceValues       = sheet.GetSheetsService().Spreadsheets.Values;

            List <object> data = new List <object>
            {
                newData.CharName,
                newData.Type,
                newData.Skins,
                newData.Skin_Spotlight
            };
            var    end        = _configuration.GetValue <string>("DefaultSettings:Parameters:ColumnRange");
            string writeRange = "A" + newData.Id + ":" + end + newData.Id;
            await sheet.WriteAsync(serviceValues, data, writeRange);
        }