Ejemplo n.º 1
0
        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);
        }
Ejemplo n.º 2
0
        /// <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);
        }