public static EmployeeObjectCollection DataTableToCollection(DataTable employees, string alias) { EmployeeObjectCollection objectsTotal; EmployeeObjectCollection objects = new EmployeeObjectCollection(); try { IEnumerator enumerator = null; try { enumerator = employees.Rows.GetEnumerator(); while (enumerator.MoveNext()) { DataRow current = (DataRow)enumerator.Current; objects.Add(EmployeeRowToObject(current, alias)); } } 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 EmployeeObjectCollection DataTableToCollection(DataTable employees, string alias) { EmployeeObjectCollection objectsTotal; EmployeeObjectCollection objects = new EmployeeObjectCollection(); try { IEnumerator enumerator = null; try { enumerator = employees.Rows.GetEnumerator(); while (enumerator.MoveNext()) { DataRow current = (DataRow)enumerator.Current; objects.Add(EmployeeRowToObject(current, alias)); } } 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 EmployeeObjectCollection GetAll() { EmployeeObjectCollection employees = new EmployeeObjectCollection(); QueryBuilder builder; try { builder = new QueryBuilder(); builder.Append(this.BaseQuery(false,0)); builder.AppendWhereBoolean(EmployeeObject.ARCHIVE, false, QueryBuilder.ParameterLocation.FIRST_LAST); builder.AppendOrderBy(EmployeeObject.NAME, QueryBuilder.OrderByType.ASC, QueryBuilder.ParameterLocation.FIRST_LAST); employees = EmployeeConvertor.DataTableToCollection(this.ExecuteDataSet(builder.Query, false).Tables[0], ""); } catch (System.Exception exception1) { throw new Exception(MethodBase.GetCurrentMethod().Name, exception1); } return employees; }