コード例 #1
0
 public static TaskPeopleObjectCollection DataTableToCollection(DataTable taskPeoples)
 {
     TaskPeopleObjectCollection objectsTotal;
     TaskPeopleObjectCollection objects = new TaskPeopleObjectCollection();
     try
     {
         IEnumerator enumerator = null;
         try
         {
             enumerator = taskPeoples.Rows.GetEnumerator();
             while (enumerator.MoveNext())
             {
                 DataRow current = (DataRow)enumerator.Current;
                 objects.Add(TaskPeopleRowToObject(current));
             }
         }
         finally
         {
             if (enumerator is IDisposable)
             {
                 (enumerator as IDisposable).Dispose();
             }
         }
         objectsTotal = objects;
     }
     catch (System.Exception exception1)
     {
         Exception innerException = exception1;
         throw new Exception(MethodBase.GetCurrentMethod().Name, innerException);
     }
     return objectsTotal;
 }
コード例 #2
0
        public static TaskPeopleObjectCollection DataTableToCollection(DataTable taskPeoples)
        {
            TaskPeopleObjectCollection objectsTotal;
            TaskPeopleObjectCollection objects = new TaskPeopleObjectCollection();

            try
            {
                IEnumerator enumerator = null;
                try
                {
                    enumerator = taskPeoples.Rows.GetEnumerator();
                    while (enumerator.MoveNext())
                    {
                        DataRow current = (DataRow)enumerator.Current;
                        objects.Add(TaskPeopleRowToObject(current));
                    }
                }
                finally
                {
                    if (enumerator is IDisposable)
                    {
                        (enumerator as IDisposable).Dispose();
                    }
                }
                objectsTotal = objects;
            }
            catch (System.Exception exception1)
            {
                Exception innerException = exception1;
                throw new Exception(MethodBase.GetCurrentMethod().Name, innerException);
            }
            return(objectsTotal);
        }
コード例 #3
0
 public TaskPeopleObjectCollection GetActive()
 {
     try
     {
         TaskPeopleObjectCollection taskPeoples = new TaskPeopleObjectCollection();
         foreach (TaskPeopleObject taskPeople in this)
         {
             if (taskPeople.State != PROF_IT.Common.Enumerations.ObjectState.Deleted)
             {
                 taskPeoples.Add(taskPeople);
             }
         }
         return(taskPeoples);
     }
     catch (System.Exception exception1)
     {
         Exception innerException = exception1;
         throw new Exception(MethodBase.GetCurrentMethod().Name, innerException);
     }
 }
コード例 #4
0
ファイル: TaskPeople.cs プロジェクト: GianiWVL/VUYLSTEKE
        public void Save(TaskPeopleObjectCollection taskPeoples)
        {
            try
            {
                foreach (TaskPeopleObject taskPeople in taskPeoples)
                {
                    if (taskPeople.State == PROF_IT.Common.Enumerations.ObjectState.Deleted)
                        Remove(taskPeople);
                    if (taskPeople.State == PROF_IT.Common.Enumerations.ObjectState.Modified |
                            taskPeople.State == PROF_IT.Common.Enumerations.ObjectState.Created)
                        Save(taskPeople);
                }

            }
            catch (Exception exception1)
            {
                Exception innerException = exception1;
                throw new Exception(MethodBase.GetCurrentMethod().Name, innerException);
            }
        }
コード例 #5
0
ファイル: TaskPeople.cs プロジェクト: GianiWVL/VUYLSTEKE
 public void RemoveAll(TaskPeopleObjectCollection taskPeoples)
 {
     try
     {
         foreach (TaskPeopleObject taskPeople in taskPeoples)
         {
             Remove(taskPeople);
         }
     }
     catch (Exception exception1)
     {
         Exception innerException = exception1;
         throw new Exception(MethodBase.GetCurrentMethod().Name, innerException);
     }
 }
コード例 #6
0
 public TaskPeopleObjectCollection GetActive()
 {
     try
     {
         TaskPeopleObjectCollection taskPeoples = new TaskPeopleObjectCollection();
         foreach (TaskPeopleObject taskPeople in this)
         {
             if (taskPeople.State != PROF_IT.Common.Enumerations.ObjectState.Deleted)
                 taskPeoples.Add(taskPeople);
         }
         return taskPeoples;
     }
     catch (System.Exception exception1)
     {
         Exception innerException = exception1;
         throw new Exception(MethodBase.GetCurrentMethod().Name, innerException);
     }
 }
コード例 #7
0
 public TaskPeopleObjectCollection GetReporterByTaskID(Guid taskID)
 {
     TaskPeopleObjectCollection taskPeoples = new TaskPeopleObjectCollection();
     QueryBuilder builder;
     try
     {
         builder = new QueryBuilder();
         builder.Append(this.BaseQuery(false, 0));
         builder.AppendWhereString(TaskPeopleObject.TASK_ID, taskID.ToString(), QueryBuilder.ComparisonOperators.Equal, QueryBuilder.ParameterLocation.FIRST);
         builder.AppendWhereBoolean(TaskPeopleObject.REPORTER, true, QueryBuilder.ParameterLocation.LAST);
         taskPeoples = TaskPeopleConvertor.DataTableToCollection(this.ExecuteDataSet(builder.Query, false).Tables[0]);
     }
     catch (System.Exception exception1)
     {
         throw new Exception(MethodBase.GetCurrentMethod().Name, exception1);
     }
     return taskPeoples;
 }
コード例 #8
0
 public TaskPeopleObjectCollection GetByEmployee(EmployeeObject employee)
 {
     TaskPeopleObjectCollection taskPeoples = new TaskPeopleObjectCollection();
     QueryBuilder builder;
     try
     {
         builder = new QueryBuilder();
         builder.Append(this.BaseQuery(false, 0));
         builder.AppendWhereString(TaskPeopleObject.EMP_ID, employee.EmpID.ToString(), QueryBuilder.ComparisonOperators.Equal, QueryBuilder.ParameterLocation.FIRST);
         builder.Append("AND " + TaskPeopleObject.EMP_ID + " is not null ");
         builder.Append("AND " + TaskObject.TASK_ID + " is not null ");
         builder.AppendWhereBoolean(TaskPeopleObject.ASSIGNEE, true, QueryBuilder.ParameterLocation.LAST);
         taskPeoples = TaskPeopleConvertor.DataTableToCollection(this.ExecuteDataSet(builder.Query, false).Tables[0]);
     }
     catch (System.Exception exception1)
     {
         throw new Exception(MethodBase.GetCurrentMethod().Name, exception1);
     }
     return taskPeoples;
 }
コード例 #9
0
 public TaskPeopleObjectCollection GetAll()
 {
     TaskPeopleObjectCollection parameters = new TaskPeopleObjectCollection();
     QueryBuilder builder;
     try
     {
         builder = new QueryBuilder();
         builder.Append(this.BaseQuery(false,0));
         parameters = TaskPeopleConvertor.DataTableToCollection(this.ExecuteDataSet(builder.Query, false).Tables[0]);
     }
     catch (System.Exception exception1)
     {
         throw new Exception(MethodBase.GetCurrentMethod().Name, exception1);
     }
     return parameters;
 }