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