public async Task SetLogin(string login) { var loginCell = _config.CurrentValue.RaidbotsAccountData.LoginCellAddress; await _googleService.WriteDataAsync(loginCell, login); await Context.Channel.SendMessageAsync("Pomyślnie zaktualizowano login dla serwisu Raidbots"); await Context.Message.DeleteAsync(); }
private async void SubstractFlasks(List <Friendly> characters, int count, DateTime fightDate) { var googleSettings = _config.CurrentValue.GoogleSettings; var nerdRoster = await _googleService.GetNerdsAsync(); var curentValues = await _googleService.ReadDataAsync <FlaskModel>(googleSettings.FlaskData.ReportValuesAddres); var newMembersLastRow = (await _googleService.ReadCellAsync(googleSettings.NewMembers.ConfigLastRow)).GetInt(); var newMembers = new List <Friendly>(); foreach (var character in characters) { var raider = nerdRoster.FirstOrDefault(x => x.AllNicks.Contains(character.Name, StringComparer.InvariantCultureIgnoreCase)); if (raider != null) { if (raider.Handled) { continue; // skip if already counted } var flaskData = curentValues.First(x => x.WowNick == raider.MainNick); if (flaskData != null) { flaskData.FlaskCount -= count; } else { newMembers.Add(character); // missing data } raider.Handled = true; } else { newMembers.Add(character); } } var rangeToSave = string.Format(googleSettings.FlaskData.ReportFlaskCountAddresTemplate, curentValues.Count + 1); var valuesToSave = curentValues.Select(x => x.FlaskCount).ToList(); var newMembersRangeToSave = string.Format(googleSettings.NewMembers.NewMembersAddresTemplate, newMembersLastRow, newMembersLastRow + newMembers.Count); var newMembersValuesToSave = newMembers.Select(x => new { fightDate = fightDate.ToString("yyyy-MM-dd"), x.Name, x.Server, x.Type }).ToList(); await _googleService.WriteDataAsync(rangeToSave, valuesToSave); await _googleService.WriteDataAsync(newMembersRangeToSave, newMembersValuesToSave); await _googleService.WriteDataAsync(googleSettings.FlaskData.ReportSubstarctDateAddres, DateTime.Now.ToString(googleSettings.FlaskData.ReportDateFormat)); }