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);
}
