private List <CoverageEntity> GetCurrentMethodList() { var now = _dateTimeHelper.Now; var startIndex = 1; var maxRow = string.Empty; List <CoverageEntity> methodLogList = new List <CoverageEntity>(); IList <IList <object> > values = _googleSheetsService.GetValues(_sheetsId, $"{now.Year}!A{startIndex + 1}:I{maxRow}"); var index = startIndex; if (values != null && values.Count > 0) { foreach (var row in values) { if (row.Count < 5) { continue; } index++; var methodEntity = new CoverageEntity { Repository = row[0].ToString().Trim(), Project = row[1].ToString().Trim(), Namespace = row[2].ToString().Trim(), Class = row[3].ToString().Trim(), Method = row[4].ToString().Trim(), RawIndex = index, RawData = row, }; if (string.IsNullOrWhiteSpace(methodEntity.Method) == false) { methodLogList.Add(methodEntity); } } } return(methodLogList); }
private static void DuplicateCoverageLog(IServiceProvider serviceProvider, IGoogleSheetsService googleSheetsService, string sourceId, string targetId) { var dateTimeHelper = serviceProvider.GetService <IDateTimeHelper>(); var now = dateTimeHelper.Now; var sheetName = now.ToString("yyyy"); //// Read var firstRow = 1; var maxRow = string.Empty; var startColumn = "A"; var endColumn = "BH"; var range = $"{sheetName}!{startColumn}{firstRow}:{endColumn}{maxRow}"; Console.WriteLine($"Source Range: {range}"); var sourceList = googleSheetsService.GetValues(sourceId, range); //// Write var targetRange = $"{sheetName}!{startColumn}{firstRow}:{endColumn}{sourceList.Count + 1}"; Console.WriteLine($"Target Range: {targetRange}"); googleSheetsService.SetValue(targetId, targetRange, sourceList); }
private static void DuplicateCoverage(IGoogleSheetsService googleSheetsService, string sourceId, string targetId) { var sheetName = "Coverage"; //// Read var firstRow = 2; var maxRow = string.Empty; var startColumn = "A"; var endColumn = "J"; var range = $"{sheetName}!{startColumn}{firstRow}:{endColumn}{maxRow}"; Console.WriteLine($"Source Range: {range}"); var sourceList = googleSheetsService.GetValues(sourceId, range); var methodList = Program.SheetRangeToEntityList(sourceList); //// Write endColumn = "H"; var targetRange = $"{sheetName}!{startColumn}{firstRow}:{endColumn}{sourceList.Count + 1}"; Console.WriteLine($"Target Range: {targetRange}"); var targetList = Program.EntityListToSheetRange(methodList); googleSheetsService.SetValue(targetId, targetRange, targetList); }