public static TaskScheduleObjectCollection DataTableToCollection(DataTable taskSchedules)
{
TaskScheduleObjectCollection objectsTotal;
TaskScheduleObjectCollection objects = new TaskScheduleObjectCollection();
try
{
IEnumerator enumerator = null;
try
{
enumerator = taskSchedules.Rows.GetEnumerator();
while (enumerator.MoveNext())
{
DataRow current = (DataRow)enumerator.Current;
objects.Add(TaskScheduleRowToObject(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 void RemoveAll(TaskScheduleObjectCollection taskSchedules)
{
try
{
foreach (TaskScheduleObject taskSchedule in taskSchedules)
{
this.Remove(taskSchedule);
}
}
catch (Exception exception1)
{
Exception innerException = exception1;
throw new Exception(MethodBase.GetCurrentMethod().Name, innerException);
}
}
public TaskScheduleObjectCollection GetAll()
{
TaskScheduleObjectCollection taskSchedules = new TaskScheduleObjectCollection();
QueryBuilder builder;
try
{
builder = new QueryBuilder();
builder.Append(this.BaseQuery(false,0));
taskSchedules = TaskScheduleConvertor.DataTableToCollection(this.ExecuteDataSet(builder.Query, false).Tables[0]);
}
catch (System.Exception exception1)
{
throw new Exception(MethodBase.GetCurrentMethod().Name, exception1);
}
return taskSchedules;
}
public TaskScheduleObjectCollection GetAll()
{
TaskScheduleObjectCollection taskSchedules = new TaskScheduleObjectCollection();
QueryBuilder builder;
try
{
builder = new QueryBuilder();
builder.Append(this.BaseQuery(false,0));
taskSchedules = TaskScheduleConvertor.DataTableToCollection(this.ExecuteDataSet(builder.Query, false).Tables[0]);
}
catch (System.Exception exception1)
{
throw new Exception(MethodBase.GetCurrentMethod().Name, exception1);
}
return taskSchedules;
}
public void RemoveAll(TaskScheduleObjectCollection taskSchedules)
{
try
{
foreach (TaskScheduleObject taskSchedule in taskSchedules)
{
this.Remove(taskSchedule);
}
}
catch (Exception exception1)
{
Exception innerException = exception1;
throw new Exception(MethodBase.GetCurrentMethod().Name, innerException);
}
}
public TaskScheduleObjectCollection GetByTaskID(Guid taskID)
{
TaskScheduleObjectCollection taskSchedules = new TaskScheduleObjectCollection();
QueryBuilder builder;
try
{
builder = new QueryBuilder();
builder.Append(this.BaseQuery(false, 0));
builder.AppendWhereString(TaskScheduleObject.TASK_ID, taskID.ToString(), QueryBuilder.ComparisonOperators.Equal, QueryBuilder.ParameterLocation.FIRST_LAST);
taskSchedules = TaskScheduleConvertor.DataTableToCollection(this.ExecuteDataSet(builder.Query, false).Tables[0]);
}
catch (System.Exception exception1)
{
throw new Exception(MethodBase.GetCurrentMethod().Name, exception1);
}
return taskSchedules;
}
public void Save(TaskScheduleObjectCollection taskSchedules)
{
try
{
foreach (TaskScheduleObject taskSchedule in taskSchedules)
{
if (taskSchedule.State == PROF_IT.Common.Enumerations.ObjectState.Created |
taskSchedule.State == PROF_IT.Common.Enumerations.ObjectState.Modified)
{
Save(taskSchedule);
}
if (taskSchedule.State == PROF_IT.Common.Enumerations.ObjectState.Deleted)
{
Remove(taskSchedule);
}
}
}
catch (Exception exception1)
{
Exception innerException = exception1;
throw new Exception(MethodBase.GetCurrentMethod().Name, innerException);
}
}
public TaskScheduleObjectCollection GetByTaskID(Guid taskID)
{
TaskScheduleObjectCollection taskSchedules = new TaskScheduleObjectCollection();
QueryBuilder builder;
try
{
builder = new QueryBuilder();
builder.Append(this.BaseQuery(false, 0));
builder.AppendWhereString(TaskScheduleObject.TASK_ID, taskID.ToString(), QueryBuilder.ComparisonOperators.Equal, QueryBuilder.ParameterLocation.FIRST_LAST);
taskSchedules = TaskScheduleConvertor.DataTableToCollection(this.ExecuteDataSet(builder.Query, false).Tables[0]);
}
catch (System.Exception exception1)
{
throw new Exception(MethodBase.GetCurrentMethod().Name, exception1);
}
return taskSchedules;
}
public void Save(TaskScheduleObjectCollection taskSchedules)
{
try
{
foreach (TaskScheduleObject taskSchedule in taskSchedules)
{
if (taskSchedule.State == PROF_IT.Common.Enumerations.ObjectState.Created |
taskSchedule.State == PROF_IT.Common.Enumerations.ObjectState.Modified)
{
Save(taskSchedule);
}
if (taskSchedule.State == PROF_IT.Common.Enumerations.ObjectState.Deleted)
{
Remove(taskSchedule);
}
}
}
catch (Exception exception1)
{
Exception innerException = exception1;
throw new Exception(MethodBase.GetCurrentMethod().Name, innerException);
}
}
