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