public static StringBuilder FetchConvertVerify(SheetsService service, Spreadsheets.Operator[] operators, Spreadsheets.SheetsRanges allRanges)
{
StringBuilder sb = new StringBuilder(DateTime.Now.ToShortDateString()).Append(", ").AppendLine(DateTime.Now.ToShortTimeString());
foreach (Spreadsheets.Operator operatorData in operators)
{
StringBuilder operatorProblems = fetchConvertVerifySpreadsheet(service, operatorData, allRanges);
sb.Append(operatorProblems);
sb.AppendLine();
}
StringBuilder repSb = RepeatFinder.FindRepeats(allInspections);
sb.AppendLine().AppendLine("Pasikartojantys suvirinimai:");
sb.Append(repSb);
return(sb);
}
/// <summary>
/// 1. Fetches Google Sheets data
/// 2. Converts Google Sheets data to WeldingInspection objects
/// 3. Checks if the WeldingInspection objects are valid for database
/// </summary>
/// <param name="service">Google Sheets API v4 service to connect to Google Sheets</param>
/// <param name="operators">All operators data from spreadsheets.json config file</param>
/// <param name="allRanges">All range data from spreadsheets.json config file</param>
/// <param name="sb">StringBuilder workflow output</param>
public static void DoControll(
SheetsService service,
Spreadsheets.Operator[] operators,
Spreadsheets.SheetsRanges allRanges,
StringBuilder sb)
{
allInspections = new List <WeldingInspection>();
foreach (Spreadsheets.Operator oper in operators)
{
sb.AppendLine();
OnProgressUpdated(0,
$"verifying data: operator - {oper.OperatorId}, sheet - \"{allRanges.Pirmieji.SheetName}\"...");
DoControllSingleSheet(
service,
oper,
allRanges.Pirmieji,
DataConverter.ConvertPirmieji,
ObjectVerifier.VerifyPirmieji,
sb);
OnProgressUpdated(0,
$"verifying data: operator - {oper.OperatorId}, sheet - \"{allRanges.Nepirmieji.SheetName}\"...");
DoControllSingleSheet(
service,
oper,
allRanges.Nepirmieji,
DataConverter.ConvertNepirmieji,
ObjectVerifier.VerifyNepirmieji,
sb);
}
StringBuilder repSb = RepeatFinder.FindRepeats(allInspections.ToList());
sb.AppendLine(Messages.Default.RepeatedRecordsHeader);
sb.Append(repSb);
}
