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