public ScheduledTask GetScheduledTask(long scheduledTaskId, DeletedInclusion deletedInclusion = DeletedInclusion.NotDeletedOnly)
{
using (WebHawkDataProvider data = new WebHawkDataProvider(ConnectionString))
{
return(data.GetScheduledTask(scheduledTaskId, deletedInclusion));
}
}
public List <ScheduledTask> GetAllScheduledTasks(DeletedInclusion deletedInclusion = DeletedInclusion.NotDeletedOnly)
{
using (WebHawkDataProvider data = new WebHawkDataProvider(ConnectionString))
{
return(data.GetAllScheduledTasks(deletedInclusion));
}
}
public SequenceDetail GetSequenceDetail(long sequenceId, DeletedInclusion deletedInclusion = DeletedInclusion.NotDeletedOnly)
{
using (WebHawkDataProvider data = new WebHawkDataProvider(ConnectionString))
{
return(data.GetSequenceDetail(sequenceId, deletedInclusion));
}
}
public static bool?ToBoolean(this DeletedInclusion deletedInclusion)
{
switch (deletedInclusion)
{
case DeletedInclusion.NotDeletedOnly:
return(false);
case DeletedInclusion.DeletedOnly:
return(true);
default:
return(null);
}
}
public SequenceDetail GetSequenceDetail(long sequenceId, DeletedInclusion deletedInclusion = DeletedInclusion.NotDeletedOnly)
{
SequenceDetail sequenceDetail = null;
m_DataAccess.ExecuteQueryReader(dataAccess.CommandType.StoredProcedure, "usp_Seq_GetSequenceDetail", paramBuilder => new List <DbParameter>()
{
paramBuilder.CreateParameter("@sequenceId", sequenceId),
paramBuilder.CreateParameter("@isDeleted", deletedInclusion.ToBoolean())
}, reader =>
{
while (reader.Read())
{
sequenceDetail = zMapToSequenceDetail(reader);
}
});
return(sequenceDetail);
}
public List <Sequence> GetAllSequences(DeletedInclusion deletedInclusion = DeletedInclusion.NotDeletedOnly)
{
List <Sequence> list = new List <Sequence>();
m_DataAccess.ExecuteQueryReader(dataAccess.CommandType.StoredProcedure, "usp_Seq_GetAllSequences", paramBuilder => new List <DbParameter>()
{
paramBuilder.CreateParameter("@isDeleted", deletedInclusion.ToBoolean())
}, reader =>
{
while (reader.Read())
{
Sequence seq = zMapToSequence(reader);
list.Add(seq);
}
});
return(list);
}
public ScheduledTask GetScheduledTask(long scheduledTaskId, DeletedInclusion deletedInclusion = DeletedInclusion.NotDeletedOnly)
{
ScheduledTask scheduledTask = null;
m_DataAccess.ExecuteQueryReader(dataAccess.CommandType.StoredProcedure, "usp_Sched_GetScheduledTask", paramBuilder => new List <DbParameter>()
{
paramBuilder.CreateParameter("@scheduledTaskId", scheduledTaskId),
paramBuilder.CreateParameter("@isDeleted", deletedInclusion.ToBoolean())
}, reader =>
{
while (reader.Read())
{
scheduledTask = zMapToScheduledTask(reader);
}
});
return(scheduledTask);
}
