protected virtual void EPDepartment_RowInserting(PXCache cache, PXRowInsertingEventArgs e) { string DepartmentID = ((EPDepartment)e.Row).DepartmentID; EPDepartment p = PXSelect <EPDepartment, Where <EPDepartment.departmentID, Equal <Required <EPDepartment.departmentID> > > > .SelectWindowed(this, 0, 1, DepartmentID); if (p != null) { cache.RaiseExceptionHandling <EPDepartment.departmentID>(e.Row, DepartmentID, new PXException(Messages.RecordExists)); e.Cancel = true; } }
protected virtual void EPDepartment_DepartmentID_FieldUpdating(PXCache cache, PXFieldUpdatingEventArgs e) { EPDepartment row = e.Row as EPDepartment; if (row != null) { if (e.NewValue != null && row.DepartmentID != null) { EPEmployee employee = PXSelect <EPEmployee, Where <EPEmployee.departmentID, Equal <Required <EPDepartment.departmentID> > > > .SelectWindowed(this, 0, 1, row.DepartmentID); if (employee != null && employee.DepartmentID != e.NewValue.ToString()) { throw new PXSetPropertyException(Messages.DepartmentInUse); } } } }