private DataSet gridTasks_OnDataReload(string completeWhere, string currentOrder, int currentTopN, string columns, int currentOffset, int currentPageSize, ref int totalRecords)
{
completeWhere = new WhereCondition(completeWhere).And().WhereIn("TaskID", TaskGroupTaskInfoProvider.GetTaskGroupTasks().WhereEquals("TaskGroupID", CurrentTaskGroup.TaskGroupID).Column("TaskID")).ToString(true);
// Get the tasks
DataSet ds = StagingTaskInfoProvider.SelectTaskList(CurrentSiteID, SelectedServerID, completeWhere, currentOrder, currentTopN, columns, currentOffset, currentPageSize, ref totalRecords);
pnlFooter.Visible = (totalRecords > 0);
return(ds);
}
/// <summary>
/// All items synchronization.
/// </summary>
private string SynchronizeAllInternal()
{
AddLog(GetString("Synchronization.RunningTasks"));
// Get the tasks
DataSet ds = StagingTaskInfoProvider.SelectTaskList(CurrentSiteID, SelectedServerID, GridTasks.CustomFilter.WhereCondition, "TaskID", -1, "TaskID")
.WhereIn("TaskID", TaskGroupTaskInfoProvider.GetTaskGroupTasks().WhereEquals("TaskGroupID", CurrentTaskGroup.TaskGroupID).Column("TaskID"));
// Run the synchronization
return(StagingTaskRunner.RunSynchronization(ds));
}
/// <summary>
/// Gets the task groups, in which the staging task is.
/// </summary>
/// <param name="ti">Staging task</param>
/// <returns>Returns display names of task groups, in which the task exists</returns>
private static IEnumerable <string> GetTaskGroupsFromStagingTask(StagingTaskInfo ti)
{
List <string> taskGroups = new List <string>();
TaskGroupInfoProvider.GetTaskGroups()
.Columns("TaskGroupID", "TaskGroupCodeName")
.WhereIn("TaskGroupID", TaskGroupTaskInfoProvider.GetTaskGroupTasks().WhereEquals("TaskID", ti.TaskID).Column("TaskGroupID"))
.ForEachObject(t => taskGroups.Add(t.TaskGroupCodeName));
return(taskGroups);
}
/// <summary>
/// Deletes all tasks.
/// </summary>
private string DeleteAllInternal()
{
AddLog(GetString("Synchronization.DeletingTasks"));
// Get the tasks
DataSet ds = StagingTaskInfoProvider.SelectTaskList(CurrentSiteID, SelectedServerID, GridTasks.CustomFilter.WhereCondition, "TaskID", -1, "TaskID, TaskTitle")
.WhereIn("TaskID", TaskGroupTaskInfoProvider.GetTaskGroupTasks().WhereEquals("TaskGroupID", CurrentTaskGroup.TaskGroupID).Column("TaskID"));
DeleteTasks(ds);
return(null);
}
private DataSet gridTasks_OnDataReload(string completeWhere, string currentOrder, int currentTopN, string columns, int currentOffset, int currentPageSize, ref int totalRecords)
{
completeWhere = new WhereCondition(completeWhere).And().WhereIn("TaskID", TaskGroupTaskInfoProvider.GetTaskGroupTasks().WhereEquals("TaskGroupID", CurrentTaskGroup.TaskGroupID).Column("TaskID")).ToString(true);
// Get the tasks
var tasksQuery = StagingTaskInfoProvider.SelectTaskList(CurrentSiteID, SelectedServerID, completeWhere, currentOrder, currentTopN, columns, currentOffset, currentPageSize);
var result = tasksQuery.Result;
totalRecords = tasksQuery.TotalRecords;
return(result);
}
private void GetStagingTasksByTaskGroup(WhereCondition where, int taskGroupSelected)
{
if (taskGroupSelected > 0)
{
// Get tasks for given task group
where.WhereIn("TaskID", TaskGroupTaskInfoProvider.GetTaskGroupTasks().WhereEquals("TaskGroupID", taskGroupSelected).Column("TaskID"));
}
else if (taskGroupSelected == UniSelector.US_NONE_RECORD)
{
where.WhereNotIn("TaskID", TaskGroupTaskInfoProvider.GetTaskGroupTasks().Column("TaskID"));
}
}
