public HourDim GetHourDim(Session session, string Name) { HourDim Hour = null; try { CriteriaOperator criteria = new BinaryOperator("Name", Name, BinaryOperatorType.Equal); Hour = session.FindObject <HourDim>(criteria); } catch (Exception) { throw; } return(Hour); }
public void CreatHourDim(Session session, string Name, string Description) { try { CriteriaOperator criteria = new BinaryOperator("Name", Name, BinaryOperatorType.Equal); HourDim Hour = session.FindObject <HourDim>(criteria); if (Hour == null) { Hour = new HourDim(session); Hour.Name = Name; Hour.Description = Description; Hour.RowStatus = Constant.ROWSTATUS_ACTIVE; Hour.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); }