public void RemoveAll(MaintenanceObjectCollection maintenances) { try { foreach (MaintenanceObject maintenance in maintenances) { Remove(maintenance); } } catch (Exception exception1) { Exception innerException = exception1; throw new Exception(MethodBase.GetCurrentMethod().Name, innerException); } }
public MaintenanceObjectCollection GetAll() { MaintenanceObjectCollection maintenances = new MaintenanceObjectCollection(); QueryBuilder builder; try { builder = new QueryBuilder(); builder.Append(this.BaseQuery(false, 0)); builder.AppendOrderBy(MaintenanceObject.START_MAINTENANCE, QueryBuilder.OrderByType.ASC, QueryBuilder.ParameterLocation.FIRST_LAST); maintenances = MaintenanceConvertor.DataTableToCollection(this.ExecuteDataSet(builder.Query, false).Tables[0]); } catch (System.Exception exception1) { throw new Exception(MethodBase.GetCurrentMethod().Name, exception1); } return(maintenances); }
public MaintenanceObjectCollection GetMemosByMaintenanceID(MaterialObject material) { MaintenanceObjectCollection maintenances = new MaintenanceObjectCollection(); QueryBuilder builder; try { builder = new QueryBuilder(); builder.Append(this.BaseQuery(false, 0)); builder.AppendWhereString(MaintenanceObject.MAT_ID, material.MatID.ToString(), QueryBuilder.ComparisonOperators.Equal, QueryBuilder.ParameterLocation.FIRST); builder.Append("AND " + MaintenanceObject.MAT_ID + " is not null "); maintenances = MaintenanceConvertor.DataTableToCollection(this.ExecuteDataSet(builder.Query, false).Tables[0]); } catch (System.Exception exception1) { throw new Exception(MethodBase.GetCurrentMethod().Name, exception1); } return(maintenances); }
public void Save(MaintenanceObjectCollection maintenances) { try { foreach (MaintenanceObject maintenance in maintenances) { if (maintenance.State == PROF_IT.Common.Enumerations.ObjectState.Deleted) { Remove(maintenance); } if (maintenance.State == PROF_IT.Common.Enumerations.ObjectState.Modified | maintenance.State == PROF_IT.Common.Enumerations.ObjectState.Created) { Save(maintenance); } } } catch (Exception exception1) { Exception innerException = exception1; throw new Exception(MethodBase.GetCurrentMethod().Name, innerException); } }