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