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