public ETLJobRunningState GetETLJobRunningState(Session session, string Name) { ETLJobRunningState _ETLJobRunningState = null; try { CriteriaOperator criteria = new BinaryOperator("Name", Name, BinaryOperatorType.Equal); _ETLJobRunningState = session.FindObject <ETLJobRunningState>(criteria); } catch (Exception) { throw; } return(_ETLJobRunningState); }
public void CreatETLJobRunningState(Session session, string Name, string Description) { try { CriteriaOperator criteria = new BinaryOperator("Name", Name, BinaryOperatorType.Equal); ETLJobRunningState _ETLJobRunningState = session.FindObject <ETLJobRunningState>(criteria); if (_ETLJobRunningState == null) { _ETLJobRunningState = new ETLJobRunningState(session); _ETLJobRunningState.Name = Name; _ETLJobRunningState.Description = Description; _ETLJobRunningState.Save(); } } catch (Exception) { throw; } }
public bool CreatETLJobLog(Session session, Guid jobId, string StateName, string StatusName, DateTime date) { bool res = true; try { DateTime nowTime = date; string currentDay = nowTime.Day.ToString(); string currentMonth = nowTime.Month.ToString(); string currentYear = nowTime.Year.ToString(); string currentHour = nowTime.Hour.ToString(); string currentMinute = nowTime.Minute.ToString(); DayDim day = GetDayDim(session, currentDay); if (day == null) { return(false); } MonthDim month = GetMonthDim(session, currentMonth); if (month == null) { return(false); } YearDim year = GetYearDim(session, currentYear); if (year == null) { return(false); } HourDim hour = GetHourDim(session, currentHour); if (hour == null) { return(false); } MinuteDim minute = GetMinuteDim(session, currentMinute); if (minute == null) { return(false); } ETLJobRunningState state = GetETLJobRunningState(session, StateName); if (state == null) { return(false); } ETLJobRunningStatus status = GetETLJobRunningStatus(session, StatusName); if (status == null) { return(false); } ETLJob job = session.GetObjectByKey <ETLJob>(jobId); if (job == null) { return(false); } ETLJobLog etlJobLog = new ETLJobLog(session); etlJobLog.ETLJobId = job; etlJobLog.DayDimId = day; etlJobLog.MinuteDimId = minute; etlJobLog.MonthDimId = month; etlJobLog.YearDimId = year; etlJobLog.HourDimId = hour; etlJobLog.ETLJobRunningStateId = state; etlJobLog.ETLJobRunningStatusId = status; etlJobLog.Save(); } catch (Exception) { return(false); throw; } return(res); }