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