private static EtlSessionSummary GetEtlSessionSummary(EtlSession session, IEtlLogParser logParser)
        {
            var sessionSummary = new EtlSessionSummary
            {
                EtlPackageId = session.EtlPackageId,
                EtlPackageName = session.EtlPackageName,
                EtlSessionId = session.EtlSessionId,
                StartDateTime = session.StartDateTime,
                StartUtcDateTime = session.StartUtcDateTime,
                EndDateTime = session.EndDateTime,
                EndUtcDateTime = session.EndUtcDateTime,
                Status = session.Status,
                UserName = session.UserName,
            };

            var variables = logParser.GetEtlVariables(session.EtlPackageId, session.EtlSessionId);
            sessionSummary.Variables.AddRange(variables);

            var counters = logParser.GetEtlCounters(session.EtlPackageId, session.EtlSessionId);
            sessionSummary.Counters.AddRange(counters);

            var messages = logParser.GetEtlMessages(session.EtlPackageId, session.EtlSessionId);
            sessionSummary.Messages.AddRange(messages);

            for (var i = messages.Length - 1; i >= 0; i--)
            {
                if (messages[i].MessageType == EtlMessageType.Error)
                {
                    sessionSummary.LastErrorMessage = messages[i];
                    break;
                }
            }

            return sessionSummary;
        }
Ejemplo n.º 2
0
        private static EtlSessionSummary GetEtlSessionSummary(EtlSession session, IEtlLogParser logParser)
        {
            var sessionSummary = new EtlSessionSummary
            {
                EtlPackageId     = session.EtlPackageId,
                EtlPackageName   = session.EtlPackageName,
                EtlSessionId     = session.EtlSessionId,
                StartDateTime    = session.StartDateTime,
                StartUtcDateTime = session.StartUtcDateTime,
                EndDateTime      = session.EndDateTime,
                EndUtcDateTime   = session.EndUtcDateTime,
                Status           = session.Status,
                UserName         = session.UserName,
            };

            var variables = logParser.GetEtlVariables(session.EtlPackageId, session.EtlSessionId);

            sessionSummary.Variables.AddRange(variables);

            var counters = logParser.GetEtlCounters(session.EtlPackageId, session.EtlSessionId);

            sessionSummary.Counters.AddRange(counters);

            var messages = logParser.GetEtlMessages(session.EtlPackageId, session.EtlSessionId);

            sessionSummary.Messages.AddRange(messages);

            for (var i = messages.Length - 1; i >= 0; i--)
            {
                if (messages[i].MessageType == EtlMessageType.Error)
                {
                    sessionSummary.LastErrorMessage = messages[i];
                    break;
                }
            }

            return(sessionSummary);
        }
 private static int SortSessionsDesc(EtlSessionSummary x, EtlSessionSummary y)
 {
     if (x.StartDateTime == y.StartDateTime)
     {
         return 0;
     }
     else if (x.StartDateTime > y.StartDateTime)
     {
         return -1;
     }
     else
     {
         return 1;
     }
 }